Calc hangs while opening xlsx file

[Kamalakar Agashe]

$ lsb_release -rd
Description: Ubuntu 12.04.1 LTS
Release: 12.04

Version: libreoffice-calc 1:3.5.4-0ubuntu1.1

I installed libreoffice-dbg 1:3.5.4-0ubuntu1.1
and followed instructions.
$ soffice --backtrace

and opened the xlsx file and libreoffice hanged.

I killed the process by opening another terminal.
$ pkill -15 soffice.bin

gdbtrace.log file is attached.

Then I have run
$ soffice --strace

and opened the xlsx file and libreoffice hanged.

I killed the process by opening another terminal.
$ pkill -15 soffice.bin

$ bzip2 strace.log

strace.log.bz2 file is attached.

WORKAROUND: I am using Libreoffice 4.0 from https://launchpad.net/~libreoffice/+archive/ppa?field.series_filter=precise on Ubuntu 12.04 and the file opens OK.

ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: libreoffice (not installed)
ProcVersionSignature: Ubuntu 3.2.0-31.50-generic-pae 3.2.28
Uname: Linux 3.2.0-31-generic-pae i686
ApportVersion: 2.0.1-0ubuntu13
Architecture: i386
Date: Thu Oct 11 17:16:28 2012
InstallationMedia: Ubuntu 12.04 LTS "Precise Pangolin" - Release i386 (20120423)
ProcEnviron:
 LANGUAGE=en_IN:en
 TERM=xterm
 PATH=(custom, no user)
 LANG=en_IN
 SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: No upgrade log present (probably fresh install)

[Kamalakar Agashe (kagashe)]

Adding other attachments

[Kamalakar Agashe (kagashe)]

Adding the xlxs file due to which libreoffice hangs.

[penalvch (penalvch)]

Kamalakar Agashe, thank you for reporting this and helping make Ubuntu better.

With an Acer Aspire 5750-9668, it took Xubuntu 12.10 ~1.5 minutes for the file to open.

Does it ultimately open in Precise if you let it "hang"? If so, how long does it take?

cd ~/Desktop && wget -c https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1065486/+attachment/3394549/+files/Daily_meeting_11th_oct.XLSX -O example.xlsx && localc --nologo example.xlsx

lsb_release -rd
Description: Ubuntu 12.10
Release: 12.10

apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.6.2~rc2-0ubuntu3
  Candidate: 1:3.6.2~rc2-0ubuntu3
  Version table:
 *** 1:3.6.2~rc2-0ubuntu3 0
        500 http://archive.ubuntu.com/ubuntu/ quantal/main i386 Packages
        100 /var/lib/dpkg/status

It opens up near instantly via Gnumeric.

apt-cache policy gnumeric
gnumeric:
  Installed: 1.10.17-1.1ubuntu1
  Candidate: 1.10.17-1.1ubuntu1
  Version table:
 *** 1.10.17-1.1ubuntu1 0
        500 http://archive.ubuntu.com/ubuntu/ quantal/universe i386 Packages
        100 /var/lib/dpkg/status

It took ~20 seconds for Microsoft Office Professional Plus 2010 Excel Version 14.0.6023.1000 (32-bit) to open it.

wine ~/.wine/drive_c/Program\ Files/Microsoft\ Office/Office14/EXCEL.EXE /e example.xlsx

apt-cache policy wine1.5
wine1.5:
  Installed: 1.5.12-0ubuntu1
  Candidate: 1.5.12-0ubuntu1
  Version table:
 *** 1.5.12-0ubuntu1 0
        100 /var/lib/dpkg/status

[Kamalakar Agashe (kagashe)]

It does not open in Precise even if I wait for more than 5 minutes.

I installed gnumeric 1.10.17 and it opens but gives following warning:
'Eq.chp!#REF!' Invalid expression
''Long pending jobs'!#REF!' Invalid expression
''29-03-2012 '!#REF!' Invalid expression
''26-06-2012'!#REF!' Invalid expression
''26-05-2012 '!#REF!' Invalid expression
''26-03-2012 '!#REF!' Invalid expression
''24-03-2012 '!#REF!' Invalid expression
''23-03-2012 '!#REF!' Invalid expression
''22-03-2012 '!#REF!' Invalid expression
''21-03-2012 '!#REF!' Invalid expression
''20-03-2012 '!#REF!' Invalid expression
''19-05-2012 '!#REF!' Invalid expression
''19-03-2012'!#REF!' Invalid expression
''17-03-2012 '!#REF!' Invalid expression
''16-03-2012 '!#REF!' Invalid expression
''14-04-2012'!#REF!' Invalid expression
''12-05-2012 '!#REF!' Invalid expression
''11-10-12'!#REF!' Invalid expression
''10-04-2012'!#REF!' Invalid expression
''07-04-2012'!#REF!' Invalid expression
''05-05-2012'!#REF!' Invalid expression
''04-04-2012 '!#REF!' Invalid expression
''03-04-2012 '!#REF!' Invalid expression
''02-04-2012'!#REF!' Invalid expression

This is a file which I receive daily and I was opening it through WindowsXP/MS Office through Virtualbox. Now I can open it in gnumeric on Ubuntu 12.04.

Thank you.

Kamalakar Agashe

-------- Original Message --------
From: "Christopher M. Penalver" <email address hidden>
Apparently from: <email address hidden>
To: <email address hidden>
Subject: [Bug 1065486] Re: Libreoofice hangs while opening xlsx file
Date: Thu, 11 Oct 2012 17:00:25 -0000

> Kamalakar Agashe, thank you for reporting this and helping make Ubuntu
> better.
>
> With an Acer Aspire 5750-9668, it took Xubuntu 12.10 ~1.5 minutes for
> the file to open.
>
> Does it ultimately open in Precise if you let it "hang"? If so, how long
> does it take?
>
> cd ~/Desktop && wget -c
> https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1065486/+attachment/3394549/+files/Daily_meeting_11th_oct.XLSX
> -O example.xlsx && localc --nologo example.xlsx
>
> lsb_release -rd
> Description: Ubuntu 12.10
> Release: 12.10
>
> apt-cache policy libreoffice-calc
> libreoffice-calc:
> Installed: 1:3.6.2~rc2-0ubuntu3
> Candidate: 1:3.6.2~rc2-0ubuntu3
> Version table:
> *** 1:3.6.2~rc2-0ubuntu3 0
> 500 http://archive.ubuntu.com/ubuntu/ quantal/main i386 Packages
> 100 /var/lib/dpkg/status
>
> It opens up near instantly via Gnumeric.
>
> apt-cache policy gnumeric
> gnumeric:
> Installed: 1.10.17-1.1ubuntu1
> Candidate: 1.10.17-1.1ubuntu1
> Version table:
> *** 1.10.17-1.1ubuntu1 0
> 500 http://archive.ubuntu.com/ubuntu/ quantal/universe i386 Packages
> 100 /var/lib/dpkg/status
>
> It took ~20 seconds for Microsoft Office Professional Plus 2010 Excel
> Version 14.0.6023.1000 (32-bit) to open it.
>
> wine ~/.wine/drive_c/Program\ Files/Microsoft\ Office/Office14/EXCEL.EXE
> /e example.xlsx
>
> apt-cache policy wine1.5
> wine1.5:
> Installed: 1.5.12-0ubuntu1
> Candidate: 1.5.12-0ubuntu1
> Version table:
> *** 1.5.12-0ubuntu1 0
> 100 /var/lib/dpkg/status
>
> ** Changed in: libreoffice (Ubuntu)
> Importance: Undecided => Low
>
> *...

[Launchpad Janitor (janitor)]

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

[Doug Lomax (dlomax11)]

I tested this on LibreOffice 3.5.7.2 Build ID: 350m1(Build:2), Ubuntu 12.04 LTS with a HP AMD Phenom(tm) II X4 840T Processor × 4, using 32 bit. I was able to open a 50,000 row xlsx spreadsheet in about 30 seconds. I opened a ~420,000 row csv spreadsheet in a couple minutes (I got exceed maximum row length warning. The 50, 000 row file opens faster in excel, the 420K file opens slower in excel (although it brings in another ~200,000 rows.

[Bryan Quigley (bryanquigley)]

This has been fixed in LibreOffice 4.0 in Raring. It does actually finish loading for me on Ubuntu 12.04, it just takes 20+ minutes.

[penalvch (penalvch)]

Kamalakar Agashe, does the LibreOffice PPA provide a WORKAROUND: https://launchpad.net/~libreoffice/+archive/ppa?field.series_filter=precise ?

[Kamalakar Agashe (kagashe)]

I am using Libreoffice 4.0 from PPA on Ubuntu 12.04 and the file opens OK.

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Marcus Tomlinson (marcustomlinson)]

This release of Ubuntu is no longer receiving maintenance updates. If this is still an issue on a maintained version of Ubuntu please let us know.

[Launchpad Janitor (janitor)]

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

[penalvch (penalvch)]

Kamalakar Agashe, this is no longer reproducible in:
Version: 6.3.2.2 (x64)
Build ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c

This is a significant bug in Ubuntu. If you need a fix for the bug in previous versions of Ubuntu, please perform as much as possible of the SRU Procedure [1] to bring the need to a developer's attention.

[1]: https://wiki.ubuntu.com/StableReleaseUpdates#Procedure