https://bugs.freedesktop.org/show_bug.cgi?id=58524
--- Comment #4 from [email protected] --- 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, <[email protected]> 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 > [email protected] * > > 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. > > -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
