Created attachment 66667 [details]
Test file in Excel 97-2003 format, it opens fine in LibreOffice Calc and Microsoft Excel 2010
Steps to reproduce:
1. Open specific xls file on scalc
2. Use Save As function, and try to save as ods file.
- Application hangs after a few seconds (Not responding on window tittle), never finishes the saving, the ods file is not created.
- The file should be saved in ods format and a new file created.
Platform (if different from the browser):
Windows 7 - 64bit
Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:15.0) Gecko/20100101 Firefox/15.0
[Reproducible] with reporter's sample and with "LibreOffice 188.8.131.52” German UI/ German Locale [Build-ID: 58f22d5] on German WIN7 Home Premium (64bit)
[Reproducible] with reporter's sample and with Server Installation of "LibreOffice 184.108.40.206 German UI/Locale [Build-ID: dc9775d-05ecbee-0851ad3-1586698-727bf66] on German WIN7 Home Premium (64bit)
[Reproducible] with reporter's sample and with Server Installation of "LibreOffice 3.3.3 German UI/Locale [OOO330m19 (Build:301) tag libreoffice-220.127.116.11] on German WIN7 Home Premium (64bit)
Also reproducible with AOOo 3.4.0, so problem seems inherited from OOo
All versions need several minutes (app 10, 3.3.3 and AOOo were the fastest) with maximum processor load when I try to save the document as .ods
OOo3.1.1 does the job within 1 minute, OOo 2.0.2 even faster
So it seems that the latest versions need the most time.
One characteristic of the document is that it uses lots of Styles, but I have on idea whether tat might be related.
Please set Status to ASSIGNED and add yourself to "Assigned To" if you accept this Bug or forward the Bug if it's not your turf (and remove others in team from CC).
Saving resulting .ods take long time (looks like hang) again, I doubt that that has to do with .xls
@Jhon H. Caicedo
"Bug 56384 - Slow calculation and FILESAVE of spreadsheets with formatted cells", what do you think?
Created attachment 69134 [details]
Shorter File - Test
Sample file, shorter (2 rows/10 columns)
Added another sample file, basically took the first sample file and deleted most of columns/rows, left only 2 rows, 10 columns.
- Tested with LibreOffice 18.104.22.168 (Build ID: da8c1e6)/Windows 7
- Cleared "direct formatting" on all cells.
- Same behavior, the file takes a long time to save in ods format.
- This file has a long list of styles, takes 8-10 seconds to open the Styles window list (F11)
- Saving the file in xls format using LibreOffice takes 3-4 seconds but works, issue is when saving to ods format.
- Another weird thing, text in cells D2/F2 shows blue, try clearing all format/change style but still shows blue.
I'm also having problems with incredibly slow save, but the most puzzling thing is that it is not always slow, even when just a few things change between save operations. So I suspect you couldn't immediately reproduce if i attach the file, nor I can trust testing saving to different format as it could be one of those times in which it saves fast.
I don't know if it's related but adding a column is also very slow and CPU consuming. We're talking about _minutes_ here, for a 68K ods file (two sheets, many cells)
Repeated test with Bug54550_Sample2.xls (Shorter File - Test attachment), running on LibreOffice 22.214.171.124 (BuildID: 2ef5aff) still same behaviour, it never finishes saving the file in ods format, opening the styles window (F11) take 12-13 seconds.
I can reproduce this in Calc 126.96.36.199, with the exception that is does not crash, but just takes a very long time to save.
I extracted the produced .ods file and the styles.xml file appears to be very large (~ 13 MB).
I loaded it in Excel 2013 and saved it to .ods; the syles file there is just 3 MB.
Created attachment 99692 [details]
Original file saved with Excel 2013 to .ods
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present on a currently supported version of LibreOffice (4.4.3 or later)
If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3)
2. Test your bug
3. Leave a comment with your results;
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword
Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa
Thank you for your help!
-- The LibreOffice QA Team This NEW Message was generated on: 2015-06-08
Repeated the tests with the sample files attached to this issue using a newer version of LibreOffice, the issue has been resolved, saving the files in ODS works correctly (and fast) for me.
OS: Windows 7 (x64)
LibreOffice Version: 188.8.131.52
Build ID: 88805f81e9fe61362df02b9941de8e38a9b5fd16
Setting status to RESOLVED - WORKSFORME
Migrating Whiteboard tags to Keywords: (perf)