https://bugs.freedesktop.org/show_bug.cgi?id=58524

--- Comment #3 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 are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to