Bug 56824

Summary: FILEOPEN: Large XLSX document takes 1.5 hours to load
Product: LibreOffice Reporter: Nicolas Dietrich <nidi>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED FIXED    
Severity: normal    
Priority: medium    
Version: 3.5.7.2 release   
Hardware: Other   
OS: All   
Whiteboard: BSA
Crash report or crash signature: Regression By:

Description Nicolas Dietrich 2012-11-06 21:44:41 UTC
Problem description: 

Trying to open the XSLX document "Liste der Stationsnamen" takes forever (on Fedora 17). I don't get any debug output on the terminal.

The document is linked from http://www.bav.admin.ch/dokumentation/publikationen/00475/01497/index.html?lang=de

or can be accessed directly:

http://www.bav.admin.ch/dokumentation/publikationen/00475/01497/index.html?lang=de&download=NHzLpZeg7t,lnp6I0NTU042l2Z6ln1acy4Zn4Z2qZpnO2Yuq2Z6gpJCDdX96fmym162epYbg2c_JjKbNoKSn6A--

              
Browser: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11
Comment 1 billhook 2012-11-09 00:24:54 UTC
Tested on LO 3.6.3.1 Windows Vista 32bit and it opened in around 45 seconds. (I have a fairly old computer FWIW)

I think there were perhaps some performance issues with opening large spreadsheets that were fixed in recent 3.6.x versions? I can't find the bugreports....
Comment 2 Nicolas Dietrich 2012-11-10 18:16:13 UTC
I tried it again with more patience. The document actually did open after around 1.5 hours, on a new Core i5-2 machine.

I can also confirm that opening on current LibreOffice 3.6.3 on Windows XP succeeds in 2 minutes.
Comment 3 billhook 2012-11-10 20:21:51 UTC
btw 3.5.7 is the last scheduled release for the 3.5 version. It may be that the only way to resolve this issue is to upgrade to 3.6?
Comment 4 Stephan van den Akker 2012-11-25 22:46:03 UTC
Tested with LOdev Version 4.0.0.0.alpha0+ (Build ID: 67fca3) 

Opening this file takes about 90 seconds under openSUSE 12.2 32-bit on a Pentium 4 machine with 2 GB of RAM.

Loading time is 220 seconds With LO LibreOffice 3.5.4, Build ID: 350m1(Build:403) on the same machine.

Calc is definitely no speed devil on any system, but in this case there may be some Fedora specific problems involved.
Comment 5 ringe 2013-03-08 18:55:55 UTC
Did not take unreasonably long on Linux Mint 14 with LibO 4.0.1.2. Certainly not minutes. I didn't time it, though.
Comment 6 Nicolas Dietrich 2013-03-08 19:14:22 UTC
This doesn't happen on LibreOffice 3.6.5.2 on Fedora 18 anymore, the original document is now opening in around 30 seconds.

Marking as resolved fixed.