Problem description: MS Office Excel files become HUGE when saved with libreoffice. Steps to reproduce: 1. Open an office excel file in Calc 2. Save it in office format 3. Watch the file size quadruple Current behavior: A 17 kb file turns into a 1300 kb file. Expected behavior: I expect A 17 kb file to stay at 17 kb when only 1 or 2 lines are edited. In fact, if I save the file in libreoffice form instead, it's only 16 kb! Operating System: Windows 7 Version: 3.5.7.2 release
Hi @arviddivran, thanks for report. Can you attach a sample file?, so someone can verify the issue. And what is the excel file format do you use to save?
Created attachment 71857 [details] Original small file This is one of the small files I have. If you open this file in libre office, edit it, and then hit save, libre office will ask if you are sure you want to save it in office form. Hit yes, and it becomes 1300 kb. Alternatively, use Save As and choose office form.
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 saving 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.
I already solved this issue by saving it in libreoffice form (we didn't need to use office format in this case), but thanks anyway. I'm sure other people will find this useful. On Wed, Mar 20, 2013 at 7:21 PM, <bugzilla-daemon@freedesktop.org> wrote: > *Comment # 3 <https://bugs.freedesktop.org/show_bug.cgi?id=58524#c3> on bug > 58524 <https://bugs.freedesktop.org/show_bug.cgi?id=58524> from > jw.hendy@gmail.com * > > 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 saving 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. > > ------------------------------ > You are receiving this mail because: > > - You reported the bug. > >
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/FDO/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team
Hello QA Admin. I could close this issue because we now have a workaround, thanks to user jw.hendy@gmail.com. However, this is a workaround, not a fix. This bug most likely still exists and should be fixed by the creators of libreoffice. How should we proceed? Should we close this issue and let the bug stay in libreoffice until the heat death of the universe or should we somehow make them notice this bug report? If you, QA Admin, think we should close this issue then you can go ahead and do so when you see this response.
Oh derp me. I didn't notice you said to mark it as uncomfirmed. But is that really correct? Since other users have also noticed this bug, not just me. But okay I'll mark it as unconfirmed.
I confirm bug with LibO 3.5.7 under Win7 64bit test .xls file changes size from 17K to 1.27 MB after saving it with minor edits. Bug is not reproducibile in LibO 4.1.3 the file size stays almost the same after editing and saving. It seems the bug has been fixed meanwhile. marking this as RESOLVED WORKSFORME. feel free to reopen if bug still persists.