Apache OpenOffice (AOO) Bugzilla – Issue 13178
Calc uses too much memory (was: Calc hangs after loading a large Excel Spreadsheet)
Last modified: 2013-02-07 22:42:53 UTC
Under http://www.technosis.de/uploads/calc-hangs.zip I have provided a large Excel Spreadsheet. Loading this in OOo 1.1 beta takes about 3 minutes on my 850MHz P3 under W2K fp3 (nothing wrong with that per se -- after all the spreadsheet _is_ large and does indeed contain quite a lot of conditional formatting etc.) When I start browsing through the various sheets, scrolling etc. eventually OOo 1.1 beta simply hangs. The application does no longer react to any input and does not update the screen anymore. The only way around this is terminating via the taskmanager. A friend of mine reports a similar behavior under OOo 1.0.1 but I have not verified that. The spreadsheet had been created using Excel and working with it there does not dispose any problems. Best, Michael
Created attachment 5532 [details] The zipped spreadsheet that should display the reported problem
Hi Michael, I can't reproduce it. Is it possible that your machine simply ran out of memory ? I have to close it as worksforme. Reopen if you could reproduce this behavior on your and on another machine. Best regards Frank
closed worksforme
I have done some more testing and it seems indeed as if the initially reported behaviour (i.e. OOo hanging after loading) is related to running out of virtual memory. However: The XLS-File has a size of 23MB. When loading into Excel it uses about 40MB of virtual memory. It also load relativly fast. When loaded into OOo it takes up about 250MB (both under W2K and Linux). Loading takes considerably longer, probably due to the time it takes to allocate 250MB of internal structures. In direct comparison the Spreadsheet in question is fairly workable in Excel while it is a pain to work with in OOo due to a much longer load time as well as apparently highly "less effective" memory usage. If I'd quadrouple the size of the spreadsheet in Excel (would be a simple task - just add some more timeseries for analytics) I'd end up with about 160MB usage in Excel (still way below what OOo uses on the current one) while OOo probably would no longer be able to load this on most machines in use out there. Bottomline: AFAICT OOo Calc uses way too much memory for its internal structures. This should be improved.
Hi Bettina, 1 4 u. Maybe it's related to Excels shared formulas or different handling of cell styles. Frank
enhanced summary, set keywords and reassigned issue according to RFE process
I can confirm this bug in 1.1.4 AND 1.9.79 - loading a 22MB .xls hangs OOo and then crashes it.
OpenOffice.org Issue Tracker - Feedback Request. The Issue you raised is currently assigned to 'Requirements' pending review, but has not been updated within the last 3 years. Please consider re-testing with one of the latest versions of OOo, as the problem(s) may have already been addressed. Either use the recent stable version: http://download.openoffice.org/index.html or consider trying the new OOo 3 BETA (still in testing): http://download.openoffice.org/3.0beta/ Please report back the outcome so this Issue may be Closed or Progressed as necessary - otherwise it may be Resolved as Invalid in the future. You may also wish to search for (and note) any duplicates of this Issue that may have advanced further by checking the Issue Tracker: http://www.openoffice.org/issues/query.cgi Many thanks, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html