Description of problem: 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! Links to the fix on the Freedesktop.org bug reports: https://bugs.freedesktop.org/show_bug.cgi?id=51200 https://bugs.freedesktop.org/show_bug.cgi?id=50304 Version-Release number of selected component (if applicable): V 3.5.5.3 How reproducible: Allways, this bug is valid for Mageia 2 The bug is fixed in Libreoffice 3.6 Steps to Reproduce: 1. Open a spreadsheet ODS 2. Save spreadsheet as XLS file 3.
btw: there is libreoffice 3.5.6 in testing maybe you can test it, don't how to check if the fix is here too
Keywords: (none) => PATCH, UPSTREAM
thank you! i tested version 3.5.6 from testing and the bug is still valid. in fact, as i read in one of the links i gave above, this bug is fixed only in version 3.6.x
ok, dmorgan can you backport the patch ?
Assignee: bugsquad => dmorganec
hi there! no solution for this bug?
this bug is still valid in 3.5.7.2
ok, since there is no reaction here i installed the newest libreoffice packages from libreoffice.org. I think in the future I will limit my bug reports to a very minimun ... And please stay consequent and don't answer on this post. Thanks!
I recently experienced this and think I have an idea about what's going on. Information: $ uname -a Linux hostname 3.8.3-2-ARCH #1 SMP PREEMPT Sun Mar 17 13:04:22 CET 2013 x86_64 GNU/Linux $ libreoffice --version LibreOffice 4.0.1.2 I believe that for some reason, some cell in distant rows/columns gets registered as containing a value, despite being blank. When exporting to xlsx, I think Libreoffice is storing some sort of value in all columns/rows up to that distant cell, or potentially storing some sort of data in all blank rows/columns instead of just leaving them absent. I suspect this, as on a hunch I selected the first blank column of my data and did Ctrl + Shift + Right Arrow. This selects all columns up to AMJ. Then right click and choose "Delete columns." Repeat for rows and do Ctrl + Shift + Down Arrow and delete all blank rows. I then did "Save as..." from .ods -> .xlsx successfully. Before doing this a ~20kb .ods was creating a 3.4mb .xlsx. After deleting blank rows/columns as described above, I get a ~21kb .xlsx.
CC: (none) => jw.hendy
This should be reported upstream then. But I suspect they won't fix anything on 3.5.x branch. Can you upgrade to Mageia3 and check if it's OK with libreoffice-4.0?
Keywords: (none) => NEEDINFOCC: (none) => thierry.vignaud
It's ok with libreoffice-4.0 in Mageia 3
Closing a
Status: NEW => RESOLVEDResolution: (none) => WONTFIX
s wontfix for mga2 as upstream will probably not touch 3.5.x