Issue 3505 - Problems with Large spread sheets
Summary: Problems with Large spread sheets
Status: CLOSED DUPLICATE of issue 3385
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 642
Hardware: PC Windows NT
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
Depends on:
Reported: 2002-03-15 13:15 UTC by skiani
Modified: 2003-09-08 16:55 UTC (History)
2 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description skiani 2002-03-15 13:15:24 UTC
I'm having problems with large spreadsheets that I use for data reduction. I'll
try to attach an example. Here are the problems:
1. Takes very long time to load, even when in native format and with quick
start. Excel(97) takes a couple seconds.
2. Memory usage is very great. 167mb verse 31mb for Excel.
3. Computational performance is about 10x slower than Excel (change the value in
the red cell from 3 to 2 and wait).
4. OOo hangs (with processor pegged) when closing.

Comment 1 skiani 2002-03-15 13:20:59 UTC
It won't let me attach such a large file. So download it from here:

I zipped it to make smaller (7mb).
Comment 2 frank 2002-03-15 15:46:02 UTC
Hi Sepeher,
a.) That's because Excel uses a special feature for storing formulas,
AFAIK we are not able to understand this feature fully, so we couldn't
use it in the filters.

b.) It's the same as above. Excel uses the memory in a better way.

c.) :-(((

d.) could not reproduce but will observe

As Cheryl in Issue 3385 submitted a similsr problem I've to set yours
as double.

Thanks for now.


*** This issue has been marked as a duplicate of 3385 ***
Comment 3 frank 2002-03-15 15:46:35 UTC
Closed as it's a double