Calc hangs while opening xlsx file

Bug #1065486 reported by Kamalakar Agashe on 2012-10-11

This bug report will be marked for expiration in 51 days if no further activity occurs. (find out why)

18
This bug affects 3 people
Affects Status Importance Assigned to Milestone
libreoffice (Ubuntu)
Low
Unassigned

Bug Description

$ 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) wrote :
Kamalakar Agashe (kagashe) wrote :

Adding other attachments

Kamalakar Agashe (kagashe) wrote :

Adding the xlxs file due to which libreoffice hangs.

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
status: New → Incomplete
summary: - Libreoofice hangs while opening xlsx file
+ Calc hangs while opening xlsx file
Download full text (3.6 KiB)

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
>
> *...

Read more...

Launchpad Janitor (janitor) wrote :

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

Changed in libreoffice (Ubuntu):
status: Incomplete → Expired
Changed in libreoffice (Ubuntu):
status: Expired → New
Doug Lomax (dlomax11) wrote :

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) wrote :

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.

Changed in libreoffice (Ubuntu):
status: New → Confirmed

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

Changed in libreoffice (Ubuntu):
status: Confirmed → Incomplete
Kamalakar Agashe (kagashe) wrote :

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

description: updated
Changed in libreoffice (Ubuntu):
status: Incomplete → New
Launchpad Janitor (janitor) wrote :

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

Changed in libreoffice (Ubuntu):
status: New → Confirmed

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.

Changed in libreoffice (Ubuntu):
status: Confirmed → Incomplete
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers