Issue 107004 - open XLSX file: hangs and consumes all memory
Summary: open XLSX file: hangs and consumes all memory
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:
Depends on:
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: ---

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

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