Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||open XLSX file: hangs and consumes all memory|
|Component:||open-import||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||elish, francis.vaccarella, issues, msaum, raal, rcstudo, tehniclugoj|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
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 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.