Calc takes 80 seconds to load 8.7 KB file

[Jesusfreak]

Have a look at the example.ods attached. The process of opening it takes 80 seconds on my system, though the size is just 8.7 kB. The example.ods was originally my file for personal contacts which at one point started to misbehave as described. I have deleted all the other tabs and all the content visible now. However, there seems to be something left somewhere. When I do CTRL+A Delete and save the problem disappears. I would expect that something like this should not happen.

ProblemType: Bug
DistroRelease: Ubuntu 12.10
Package: libreoffice-calc 1:3.6.2~rc2-0ubuntu4
ProcVersionSignature: Ubuntu 3.5.0-18.29-generic 3.5.7
Uname: Linux 3.5.0-18-generic x86_64
ApportVersion: 2.6.1-0ubuntu10
Architecture: amd64
Date: Sun Mar 3 21:07:47 2013
EcryptfsInUse: Yes
InstallationDate: Installed on 2012-08-13 (202 days ago)
InstallationMedia: Xubuntu 12.04 LTS "Precise Pangolin" - Release amd64 (20120425)
MarkForUpload: True
ProcEnviron:
 TERM=xterm
 PATH=(custom, no user)
 XDG_RUNTIME_DIR=<set>
 LANG=en_US.UTF-8
 SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: Upgraded to quantal on 2012-10-19 (135 days ago)

[Kurt Cancemi (x64architecture)]

I have tried on precise and quantal and I can not reproduce your problem.

[Jesusfreak (launchpad-bikelab)]

With the help of gnumeric I have found out now that cell F7 contains an emailaddress followed by some abnormal content (see screenshot attached). With calc I can see the email address but not the rubbish that follows. It is possible to just delete the email address in a way the cell looks empty but is not really. When I delete all the content of this cell everything works as expected.

[Launchpad Janitor (janitor)]

[Expired for libreoffice (Ubuntu) because there has been no activity for 60 days.]

[penalvch (penalvch)]

Jesusfreak, does the LibreOffice PPA provide a WORKAROUND for you via https://launchpad.net/~libreoffice/+archive/libreoffice-4-0?field.series_filter=quantal ?

[Jesusfreak (launchpad-bikelab)]

No, it is not a WORKAROUND. The problem persists also with this PPA version.

[penalvch (penalvch)]

Jesusfreak, thank you for performing the requested test. Did this issue not occur in a release prior to Quantal?

[Jesusfreak (launchpad-bikelab)]

I cannot give an exact date when this problem occurred to me the first time. I didn't notice the issue prior to Quantal, but it is very well possible that this was just because the problematic content of cell F7 did not exist in the file yet.

[Launchpad Janitor (janitor)]

[Expired for libreoffice (Ubuntu) because there has been no activity for 60 days.]

[Jesusfreak (launchpad-bikelab)]

Here is some activity. I have just tested it with libreoffice Version 4.0.2.2 (Build ID: 400m0(Build:2)) and can still reproduce this bug.

[Bryan Quigley (bryanquigley)]

It opens instantly for me on LibreOffice 4.1.

Maybe try on a LiveCD or clear your libreoffice config by opening a terminal and running:
mv .config/libreoffice/ .libreoffice-old

[Launchpad Janitor (janitor)]

[Expired for libreoffice (Ubuntu) because there has been no activity for 60 days.]

[Jens Herrmann (bugs-u)]

Seems to be fixed now, Version: 4.2.6.3 opens the file instantly.