Issue 107004

Summary: open XLSX file: hangs and consumes all memory
Product: Calc Reporter: euklid2 <franz.graf>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, francis.vaccarella, issues, msaum, raal, rcstudo, tehniclugoj
Version: OOO320m4   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
test file for issue
none
price offer none

Description euklid2 2009-11-18 15:41:52 UTC 
If I open a certain *.xlsx file in Calc (see attachment) , the progress bar
moves to some 20% within a few seconds. Thereafter it stops, while the processor
load is about 100%. I waited for some 30 minutes, while memory consumption rises
steadily until all the physical memory (2GB) is used. Then I cancelled the program.

I tried deleting the two sheets with charts from the xlsx file, but it still
could not be opened.

I observed that some xlsx files can be opened without problem and in reasonable
time.
Comment 1 euklid2 2009-11-18 15:45:37 UTC 
Created attachment 66169 [details]
test file for issue
Comment 2 raal 2009-11-18 23:15:50 UTC 
I can reproduce on ubuntu 9.10, OOO320m5
Comment 3 teh 2012-11-26 14:16:43 UTC 
Created attachment 79951 [details]
price offer

when opening, it loads till some 20-25% percent then stops, and i need to end the process in order to use spreadsheet again. lookes like someone has the same problem.
when i convert the file to xls it works just fine.
i'm available for more details on problem if needed,ty
Comment 4 Rodrigo 2013-06-11 14:28:10 UTC 
I have problem with OpenOffice in open file *.xlsx... slowness to open
Comment 5 Rob Weir 2013-07-30 02:18:25 UTC 
Reset assignee on issues not touched by assignee in more than 2000 days.
Comment 6 msaum 2013-08-01 15:24:45 UTC 
This still occurs with 4.0.
Comment 7 msaum 2013-08-01 15:52:18 UTC 
My experience seems to be that of xlsx file that are large. Not sure where the line is drawn for "large". I am testing with a 3MB xlsx file.  This same file opens fine with LibreOffice 4.1 just fine.?? This has been a known issue for a while. Some seem to think that this issue started after OOO 3.3. I was waiting for the new AOO 4.0 in hopes that this wouldn't be a problem any more.  There is no reason for me to install 4.0 until this issue is resolved. I am running OOO3.4 in a terminal server environment(2008R2), so the installation is a little more challenging. Sorry to say but the question is "Should I switch to LibreOffice? or Wait until AOO4.1? I would like to stay with what I have but....  Unfortunately, we have to be able to open MS Office files. No way around it.
Comment 8 Edwin Sharp 2013-08-30 08:54:05 UTC 
Attachment 66169 [details] opens OK in Excel 2010.
Calc Rev. 1518439 not responding.
Win 7
Comment 9 francis.vaccarella 2013-11-29 19:46:14 UTC 
4.0.1 has the same issue. It hangs[will NOT load] an xlsx file over about 1 M.

NEED A SOLUTION otherwise will have to get office suite.