Ubuntu

Graying out a spreadsheet while loading or saving

Asked by ealthuis

Libreoffice 6.0.4 when about three quarters done grays out the spreadsheet for as much as 3 minutes before the load completes.

same thing happens when that spreadsheet is saved.

I copied the folder to an external drive connected that to another computer and the same thing happened, which suggests the problem is with the actual spreadsheet?? as another spreadsheet loaded without problems.

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu Edit question
Assignee:
No assignee Edit question
Solved by:
ealthuis
Solved:
Last query:
Last reply:
Revision history for this message
actionparsnip (andrew-woodhead666) said : 		#1

What is the output of:

lsb_release -a; uname -a; apt-cache policy libreoffice

Thanks

Revision history for this message
ealthuis (ealthuis) said : 		#2

ea@Discovery:~$ lsb_release -a; uname -a; apt-cache policy libreoffice
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 16.04.4 LTS
Release: 16.04
Codename: xenial
Linux Discovery 4.4.0-128-generic #154-Ubuntu SMP Fri May 25 14:15:18 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
libreoffice:
  Installed: (none)
  Candidate: 1:5.4.6~rc2-0ubuntu0.16.04.1
  Version table:
     1:5.4.6~rc2-0ubuntu0.16.04.1 500
        500 http://ppa.launchpad.net/libreoffice/libreoffice-5-4/ubuntu xenial/main amd64 Packages
     1:5.1.6~rc2-0ubuntu1~xenial3 500
        500 http://ca.archive.ubuntu.com/ubuntu xenial-updates/universe amd64 Packages
        500 http://security.ubuntu.com/ubuntu xenial-security/universe amd64 Packages
     1:5.1.2-0ubuntu1 500
        500 http://ca.archive.ubuntu.com/ubuntu xenial/universe amd64 Packages
ea@Discovery:~$

Revision history for this message
actionparsnip (andrew-woodhead666) said : 		#3

Then I suggest you contact the PPA maintenaner. They manage their own packages.

Revision history for this message
ealthuis (ealthuis) said : 		#4

I already have posed the problem in the libreoffice community forum.

Revision history for this message
ealthuis (ealthuis) said : 		#5

Libreoffice 6.0.4 was installed from a snap package.

This problem was solved by me through extensive testing.
The copy and paste I used to get the data also brought other data that LO could not properly resolve. By removing the sheet with the offending data I corrected the problem.