Apache OpenOffice (AOO) Bugzilla – Issue 108809
Many cell styles: Slow open and save spreadsheet
Last modified: 2013-08-21 05:43:56 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.
Created attachment 67496 [details] Slow file without data and lot of cell styles
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!
11 seconds to open in Rev. 1514603 Win 7. Intel i3 2.93GHz 4GB RAM