[precise] Saving xls files originally created in Excel 2003 causes considerable increase of file size
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
LibreOffice |
Fix Released
|
Medium
|
|||
libreoffice (Ubuntu) |
Fix Released
|
Medium
|
Unassigned | ||
Precise |
Fix Released
|
Medium
|
Björn Michaelsen |
Bug Description
WORKAROUND: -> https:/
This is a regression in upstream between 3.5.4 and 3.5.5.
[Impact]
when opening a received xls created by Microsoft Excel 2003, then saving as xls again by LibreOffice,
file size becomes considerably larger.
i.e. 32KB -> 1.4MB (40x larger)
[Test Case]
A. to confirm the regression is fixed
1. open the xls file(32KB) attached in upstream bug
https:/
2. save it as xls in LibreOffice Calc
3. confirm that the file size becomes almost 1.4MB
4. update to -proposed
5. open the file in the upstream bug again and save it as xls
6. confirm that the file size is almost the same as the original(32KB)
B. to confirm not happening another regression
1. create a new document in LibreOffice Calc
2. make the height of A5 cell 50mm
3. focus to A5 cell
4. save as xls and close the document
5. open the xls file again
6. confirm that the height of A5 cell is 50mm, the height of other rows stay default height.
above steps of B1.-6. should be tested with both current and -proposed version
Note: with 3.5.4 or lower version, when opening the xls file again in step 5, the height of all cells becomes 50mm.
[Regression Potential]
the patch causing this regression was intended to fix fdo#50304.
https:/
to prevent fdo#50304 from happening again by this SRU, additional test case is described above.
ProblemType: BugDistroRelease: Ubuntu 12.04
Package: libreoffice-calc 1:3.5.7-0ubuntu4
ProcVersionSign
Uname: Linux 3.5.0-23-generic x86_64
ApportVersion: 2.0.1-0ubuntu17.1
Architecture: amd64
CasperVersion: 1.315.1
Date: Wed Jun 26 06:35:48 2013
LiveMediaBuild: Ubuntu 12.04.2 LTS "Precise Pangolin" - Release amd64 (20130213)
MarkForUpload: True
ProcEnviron:
TERM=xterm
PATH=(custom, no user)
LANG=ja_JP.UTF-8
SHELL=
UpgradeStatus: No upgrade log present (probably fresh install)
Changed in df-libreoffice: | |
importance: | Unknown → Medium |
status: | Unknown → Invalid |
Changed in df-libreoffice: | |
importance: | Medium → Unknown |
status: | Invalid → Unknown |
Changed in df-libreoffice: | |
importance: | Unknown → Medium |
status: | Unknown → Fix Released |
description: | updated |
Changed in libreoffice (Ubuntu): | |
importance: | Undecided → Medium |
Changed in libreoffice (Ubuntu Precise): | |
assignee: | nobody → Björn Michaelsen (bjoern-michaelsen) |
importance: | Undecided → Medium |
Changed in libreoffice (Ubuntu): | |
status: | New → Fix Released |
description: | updated |
Created attachment 63167
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