Bug 51200 - Saving xls files originally created in Excel 2003 causes considerable increase of file size
Summary: Saving xls files originally created in Excel 2003 causes considerable increas...
Status: RESOLVED DUPLICATE of bug 51878
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.5.1 rc
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-06-18 03:33 UTC by andis.lazdins
Modified: 2012-07-24 01:38 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
compressed large .xls file saved initially by Libreoffice 3.5.5.1 (825.94 KB, application/x-zip-compressed)
2012-06-18 03:33 UTC, andis.lazdins
Details
The same file saved by Openoffice.org 3.4 after Libreoffice 3.5.5.1 (84.50 KB, application/vnd.ms-excel)
2012-06-18 03:34 UTC, andis.lazdins
Details
The same file saved by Libreoffice 3.5.5.1 after saving with Openoffice.org 3.4 (84.50 KB, application/vnd.ms-excel)
2012-06-18 03:35 UTC, andis.lazdins
Details
Initial large .xls file saved by Libreoffice 3.5.5.1 as ods (39.05 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-06-18 03:36 UTC, andis.lazdins
Details

Note You need to log in before you can comment on or make changes to this bug.
Description andis.lazdins 2012-06-18 03:33:30 UTC
Created attachment 63167 [details]
compressed large .xls file saved initially by Libreoffice 3.5.5.1

I found this problem trying to work with time sheets originally created and edited with Excel 2003. The file originally having size of about 100 KB after saving in LibreOffice as .xls increases in size to 7.6 MB. After saving the same file as .xls with OpenOffice.org 3.4 file size goes down to some 80 KB. The same happens if previously created large .xls file is saved as .ods with Libreoffice 3.5.5.1. 

If I reopen .xls file saved in Openoffice.org with Libreoffice 3.5.5.1 and save it again as .xls, file size is not increasing, however saving is very slow.

Sample files follows in attachment:
Large xls file size.xls.zip - compressed large .xls file saved initially by Libreoffice 3.5.5.1
Large xls file size.ods - the same file saved by by Libreoffice 3.5.5.1 as .ods
Large xls file size ooo.xls - large xls file saved as xls by Openoffice.org 3.4
Large xls file size ooo + lo.xls - the same file saved by Libreoffice 3.5.5.1 after saving in Openoffice.org
Comment 1 andis.lazdins 2012-06-18 03:34:51 UTC
Created attachment 63168 [details]
The same file saved by Openoffice.org 3.4 after Libreoffice 3.5.5.1
Comment 2 andis.lazdins 2012-06-18 03:35:54 UTC
Created attachment 63169 [details]
The same file saved by Libreoffice 3.5.5.1 after saving with Openoffice.org 3.4
Comment 3 andis.lazdins 2012-06-18 03:36:53 UTC
Created attachment 63170 [details]
Initial large .xls file saved by Libreoffice 3.5.5.1 as ods
Comment 4 Markus Mohrhard 2012-07-05 20:33:31 UTC
Should be fixed in 3.5.5.2 and 3.6.0.1
Comment 5 andis.lazdins 2012-07-05 21:39:33 UTC
The bug is fixed now in 3.5.5.2.
Comment 6 ZenekB 2012-07-14 14:23:07 UTC
Problem still exist in version 3.5.5.3, xls files with a size of 40KB stores increased to 1.3MB.
Comment 7 andis.lazdins 2012-07-14 18:21:18 UTC
Yes, I found the same that some xls files considerably increase in size after saving with 3.5.5.3, however, not the same published here before, but also some kind of EC time sheets and relevant documents
Comment 8 Rainer Bielefeld Retired 2012-07-16 12:39:25 UTC
I think new Version is wrong
<http://wiki.documentfoundation.org/BugReport_Details#Version>

@Markus:
I am pretty sure that Bug 52141 is a DUP what confirms that the problem still exists in 3.5.5.3
Comment 9 Markus Mohrhard 2012-07-16 13:00:01 UTC

*** This bug has been marked as a duplicate of bug 51878 ***
Comment 10 Markus Mohrhard 2012-07-16 13:01:20 UTC
So no this was not a duplicate but another problem with our xls export filter. This time not introduced by me!

Same problem exists for xlsx export and is already tracked by another bug report.
Comment 12 Brian Gregory [UK] 2012-07-24 01:38:17 UTC
I am getting huge XLS files when saving spreadsheets as XLS with spreadsheets
that previously were similar size or slightly smaller in XLS form than in ODS
form.
Now the XLS file is well over 50 times bigger than the ODS file!!!
This is with V 3.5.5.3 on WINDOWS.