Issue 108809 - Many cell styles: Slow open and save spreadsheet
Summary: Many cell styles: Slow open and save spreadsheet
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOO320m11
Hardware: Unknown All
: P5 (lowest) Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2010-02-01 09:41 UTC by Risto Jääskeläinen
Modified: 2013-08-21 05:43 UTC (History)
3 users (show)

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

Slow file without data and lot of cell styles (72.08 KB, text/plain)
2010-02-01 09:45 UTC, Risto Jääskeläinen
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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

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.

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