Issue 108809

Summary: Many cell styles: Slow open and save spreadsheet
Product: Calc Reporter: Risto Jääskeläinen <rjaaskel>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P5 (lowest) CC: elish, issues, kclapper
Version: OOO320m11   
Target Milestone: ---   
Hardware: Unknown   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Slow file without data and lot of cell styles none

Description Risto Jääskeläinen 2010-02-01 09:41:39 UTC 
User of Calc ask help for very slow (10 minutes) opening of an ods-file.  I ask
him save in excel97 format and he was happy with much faster performance in
Calc. But this was not a solution I like so I ask the user send the file to me.
I find out that there was lot of cell styles in the document. Even I remove all
data from sheets it is still quite slow (minutes) to open or to save with just
one letter in one cell.

When I open this ods-file with excel 2010 beta it opens in few seconds.  So it
seems that there is some possibility to improve opening time even if file is in
ODF format.

My query in Issue Tracker doesn't result exactly same problem but in one slow
file operation issue for Calc there is also quite many cell styles in the large
document. Sorry I can't find that issue number anymore, but file name start with
"klapeto98x".

I try to attach empty file so that developers can check if there is easy way for
enchangement or if there is some bug in file.

Ystävällisesti
Risto J.
Comment 1 Risto Jääskeläinen 2010-02-01 09:45:25 UTC 
Created attachment 67496 [details]
Slow file without data and lot of cell styles
Comment 2 officechick007 2010-04-23 23:50:43 UTC 
I have a similar problem:

I have noticed a 25-30 second delay in opening a moderately sized ods file. If I
save it in .xls it opens within one second in Excel and about 10 seconds in
Calc. I would prefer to continue using the .ods and using Calc to open
documents, but it's really frustrating when trying to pull up spreadsheets to
show my supervisor and I have to wait awhile before it loads.

It hasn't always done this and I'm not really sure what caused the change or
exactly when it happened. I thought it might get better, but it hasn't. Please help!
Comment 3 Edwin Sharp 2013-08-21 05:43:56 UTC 
11 seconds to open in Rev. 1514603 Win 7.

Intel i3 2.93GHz 4GB RAM