Issue 13178 - Calc uses too much memory (was: Calc hangs after loading a large Excel Spreadsheet)
Summary: Calc uses too much memory (was: Calc hangs after loading a large Excel Spread...
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 1.1 Beta
Hardware: PC Windows 2000
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: ms_interoperability, rfe_eval_ok, usability
Depends on: 15222
  Show dependency tree
Reported: 2003-04-08 19:53 UTC by mgd
Modified: 2013-02-07 22:42 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

The zipped spreadsheet that should display the reported problem (4.57 MB, application/zip)
2003-04-08 20:01 UTC, mgd
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description mgd 2003-04-08 19:53:40 UTC
Under 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.


Comment 1 mgd 2003-04-08 20:01:57 UTC
Created attachment 5532 [details]
The zipped spreadsheet that should display the reported problem
Comment 2 frank 2003-04-09 11:39:05 UTC
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

Comment 3 frank 2003-04-09 11:39:22 UTC
closed worksforme
Comment 4 mgd 2003-04-12 17:42:08 UTC
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.

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.

AFAICT OOo Calc uses way too much memory for its internal structures. 
This should be improved.
Comment 5 frank 2003-04-14 09:06:19 UTC
Hi Bettina,

1 4 u.

Maybe it's related to Excels shared formulas or different handling of
cell styles.

Comment 6 erwin.tenhumberg 2004-10-28 10:31:17 UTC
enhanced summary, set keywords and reassigned issue according to RFE process
Comment 7 triceo 2005-03-03 10:02:11 UTC
I can confirm this bug in 1.1.4 AND 1.9.79 - loading a 22MB .xls hangs OOo and
then crashes it.
Comment 8 ace_dent 2008-05-16 00:39:44 UTC 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:
or consider trying the new OOo 3 BETA (still in testing):
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:
Many thanks,
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~