Calc ods file not loadable

[dino99]

Since a couple days, i cant open/load an ods file with Disco, at load time a popup warns about libreoffice have crashed, and its related to its .~locl.myfile.ods#
Deleting that lock file does not help, its again the same problem with the new created one.
The same file load as expected with a bionic session.

As its a silent load crash, with no found log, i wonder about the possible cause.

[corradoventu]

i have no problem with:

corrado@corrado-p5-dd-1123:~$ apt policy libreoffice-cal*
libreoffice-calc:
  Installed: 1:6.1.3-0ubuntu3
  Candidate: 1:6.1.3-0ubuntu3
  Version table:
 *** 1:6.1.3-0ubuntu3 500
        500 http://archive.ubuntu.com/ubuntu disco/main amd64 Packages
        100 /var/lib/dpkg/status
corrado@corrado-p5-dd-1123:~$

which libreoffice do you have?

[dino99]

Mine is from 'proposed' (the devil might be there; will test later as im outside for a while)

libreoffice (1:6.1.3-0ubuntu6) disco; urgency=medium

[ Evangelos Foutras ]
* poppler-fix-build-0-70.patch: fix build failure with poppler >= 0.70

[ Olivier Tilloy ]
* debian/patches/poppler-dropped-gbool.patch: updated to patch an additional
source file (sdext/source/pdfimport/xpdfwrapper/wrapper_gpl.cxx)

-- Olivier Tilloy <email address hidden> Mon, 26 Nov 2018 16:48:41 +0100

[Smask]

Mine is from 'proposed' (the devil might be there; will test later as im outside for a while)

libreoffice (1:6.1.3-0ubuntu6) disco; urgency=medium

Wut? Maybe they removed 1:6.1.3-0ubuntu6 for some reason, because I've got the same version as Corrado and I have proposed enabled on both machines here.

[dino99]

As you can see, it is still proposed. But it seem locked and have not reached the Disco download list. (amd64 & arm64 packages have failed at built time)
( my system is a "amd64" one, so still using the previous version)

https://launchpad.net/ubuntu/+source/libreoffice

So i still use libreoffice (1:6.1.3-0ubuntu3) disco; urgency=medium

* No-change rebuild for icu soname changes.

-- Matthias Klose <doko@ubuntu.com> Tue, 13 Nov 2018 08:30:22 +0000
--------------------------------------------------------------------------------------------------------------------------
Maybe the problem is due to:

icu (63.1-5) unstable; urgency=medium

* Build without Paragraph Layout API.
* Remove libiculx63 package, no longer needed (closes: #898571).

-- Laszlo Boszormenyi (GCS) <gcs@debian.org> Sun, 02 Dec 2018 10:31:22 +0000

------------------------------------------------------------------------------------------------------------------------------
but reinstalling libiculx63 is not possible as that remove lot of packages.

[VMC]

Open from terminal and see if any errors appears other than perhaps java:

$ soffice whatever.ods

[dino99]

I have already tested loading that ods file via the terminal:
- there is no output at all
- only create the -~lock file, then a recovery popup is shown, but even not list that file !!!; so its useless.

[dino99]

Finally solved that issue via the hard way:
- purged all the libreoffice* packages and the dependencies
- try reinstallation via synaptic: impossible as the libreoffice* packages fails due to broken dependencies !!!! but succeed via the terminal (very strange)
- then starting soffice via le terminal and got the previous popup about an 'untitled1' faulty package to restore, and the restoration has been accepted that time. But searching about that file accross the whole system and user space (even the hidden ones) does not succeed !!! A real ghost.

Is that an example of the Debian/Ubuntu delta configuration/packaging ?

[dino99]

Next problem:

After the previous post, i have opened the calc settings to set some bigger font size (+2) for an easier menu reading. And on the next calc opening, the menu, columns number and raws are not displayed at all.
So its impossible to set the options back via the calc menu. Going to dconf editor does not help either. Then i was hoping to redo the purging/reinstalling process to get back a usable interface; but still fails, and the initial problem is now back again.
I cant beleive that purging all the libreoffice installation, and deleting the .config dir too, still does not purge the previous conflicting settings. What a mess .
Searching for possible libreoffice/calc hidden settings left behind also fails. So where they can be hidden ?

[dino99]

Disco still has that problem; and i'm not alone https://bugs.launchpad.net/ubuntu/+s...e/+bug/1813506

This is a soffice pure problem (tested via a terminal)

Confirm the comment from the report: purging libreoffice-gnome/libreoffice-gtk3, then soffice can be used as expected.