Issue 3385 - Xcl Exp: Performance saving large spreadsheet
Summary: Xcl Exp: Performance saving large spreadsheet
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 641
Hardware: PC Windows 95
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 3505 3627 25657 (view as issue list)
Depends on:
Reported: 2002-03-07 15:13 UTC by cbelch
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Issue Type: TASK
Latest Confirmation in: ---
Developer Difficulty: ---

Large Excel file takes ages to save in OO (6.57 MB, application/octet-stream)
2002-03-13 14:03 UTC, cbelch
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description cbelch 2002-03-07 15:13:43 UTC
My colleague has received a MSOffice 2000/XP file (5,000 KB) that has 27,165 
rows and 5 columns of data (mostly formulas).  He has tried opening the file in 
MSOffice 95 but the Excel 95 only has 16,384 rows in total.  As we are 
currently trialing the OO software we thought we would try to open it in the OO 
Spreadsheet application.  So far so good ...... BUT when we make any amendments 
and try to re-save the file the application hangs.  Is there a problem working 
with large files in the Open Office Spreadsheet application?
Cheryl Belch
Comment 1 frank 2002-03-07 15:53:17 UTC
Hi Cheryl,

to assign this Issue to the responsible person I need some more Infos.

How much memory and what a CPU is used in this WIN95 machine, do want
to save to Excel 97/2000/XP format or to the Calc format ? How long
have you been waiting before you considered the whole application hangs ?

A 5 MB Excel file containing a lot of formulas can cause OOo to
consume a lot of time for saving, also the file size of the saved
Excel file will increase. It's a problem with Excels shared formulas.

Best regards 
Comment 2 frank 2002-03-12 09:46:20 UTC
Hi Cheryl,

is your problem solved ?

If not, please attach such a document to this Issue.


Comment 3 cbelch 2002-03-12 10:05:39 UTC
Hi Frank,
Sorry for the delay ... I need to do further tests with my W95 user 
who has been out of the office.  Should be this afternoon so I will 
get back to you later today with results.

By the way the PC in question is W95, 700 MHZ, 128 RAM, 10 GB!

Kind regards,
Comment 4 cbelch 2002-03-12 16:45:31 UTC
Hi Frank,
I have completed further tests on the large spreadsheet.  The file 
did finaly save ... I think I was trying to close too soon when the 
file hadn't finished saving BUT is it possible for the saving to be 
made faster?  It took 5 minutes to save the document (in MS Excel it 
takes 2 seconds).

Any further comments?

Thanks, Cheryl.
Comment 5 frank 2002-03-13 12:10:36 UTC
Hi Cheryl,

maybe we can make it faster, but not on the short term. If it's
possible please attach such a big Excel file to this Issue using the
'Create a new attachment' Link on the Issue page. File size limtation
is 10 MB so it should not be a problem. 

Please keep in mind that this bug tracking system is open to the
public, so please do not post any confidential data. If possible
change the numbers to randomly generated ones and change the text
fields to x values to keep your companies secrets.

Best regards


PS reassigned to Daniel who keeps this as performance task
Comment 6 cbelch 2002-03-13 14:03:54 UTC
Created attachment 1200 [details]
Large Excel file takes ages to save in OO
Comment 7 cbelch 2002-03-13 14:10:41 UTC
Hi Frank,

I have attached the spreadsheet (data changed for confidentiality) as 


ps. it states that you can only attach files less than 1MB, I took 
your word for it and attached a 6MB file.  Hope it's okay!
Comment 8 frank 2002-03-13 15:21:13 UTC
Hi Cheryl,

thanks for the document, and yes it comes through well.

Daniel will check where he can increase the performance.

Thanks and have nice day

Comment 9 frank 2002-03-15 15:46:02 UTC
*** Issue 3505 has been marked as a duplicate of this issue. ***
Comment 10 oc 2002-03-22 14:10:05 UTC
*** Issue 3627 has been marked as a duplicate of this issue. ***
Comment 11 daniel.rentz 2002-04-18 11:06:52 UTC
Comment 12 cbelch 2002-06-17 12:44:53 UTC
Accepted ???

What does this mean?  Are you still looking into this problem or have 
you just accepted that nothing can be done about it?
Comment 13 daniel.rentz 2002-06-17 13:09:28 UTC
I think there is the possibility to make the export faster. The issue is on my list which 
contains about 25 IssueZilla bugs and a lot more internal bugs... Please be patient, I 
will not forget this issue.
Comment 14 daniel.rentz 2003-01-13 16:07:31 UTC
Comment 15 fa 2003-02-04 17:26:09 UTC

Just to note, we are experience this same problem on Mac OS X of course.  Using an
8.5MB Excel spreadsheet (not "Large File.xls"), the following benchmarks were observed by a tester:
Initial Open of Excel file:  25s
Save as OOo Calc File:  6min
OOo Calc File Size:  5.5MB
Open of OOo Calc File:  6m 28s

Office v.X Excel:-----------------
Open same Excel File:  6s
Save same Excel File:   7.7s with Large File.xls:---
Open Original Excel file:  12s
Save as OOo Calc File:  2m 7s
Open OOo Calc File:  2m 36s

Powerbook G4 800 mhz, OS X 10.2.3, 1GB ram

Comment 16 terryt 2004-02-19 08:09:57 UTC
*** Issue 25657 has been marked as a duplicate of this issue. ***
Comment 17 frank 2004-05-04 14:52:44 UTC
Due to limited time ressources I re-Target this one to OOo Later
Comment 18 redndahead 2005-09-16 14:33:22 UTC
3385 I believe is a duplicate of 1905.  Can someone mark as such and close this.
Comment 19 stp 2006-05-06 23:24:47 UTC
As of 2.0.2 the attached file doesn't seem to bother OOo much. Please confirm.