Issue 107004 - open XLSX file: hangs and consumes all memory
Summary: open XLSX file: hangs and consumes all memory
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOO320m4
Hardware: PC Windows XP
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-11-18 15:41 UTC by euklid2
Modified: 2013-11-29 19:46 UTC (History)
7 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
test file for issue (472.59 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2009-11-18 15:45 UTC, euklid2 		no flags Details
price offer (912.13 KB, application/octet-stream)
2012-11-26 14:16 UTC, teh 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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.