I think Piet have pointed to the source of the problem.
Seems in several sheet there are cells formatted out data range. Sheet
'Análisis Pisos' seems empty but has a lot of empty comments, better delete
For a first cleaning, to do in every sheet:
- Ctrl+End goes to bottom-right corner of range with data in a sheet.
- Use Ctrl-M to clear any direct format for the columns right and rows down
I did some more experimenting with Sheet 7 (ANALISIS PISOS IMPORTADOS).
First I selected all columns from M to the end and deleted all cells (everything) in it. That
But then I saw that several rows (3723, 3897, 3972-3984, 4040-4046, 4090. 8375, 8378, 10415-10417,
10238) still had all their cells listed individually. It appears that these complete rows have the
font set to "Times New Roman 10pt", whereas the default font is Arial. So I also dir a Ctrl-M on
these columns and that dramatically decreased the size of Sheet 7.
The file saved by MS Excel has special commands to set the format/style of a row, so that it does
not have to specify each individual cell. So that is an optimisation that the exporter misses for
some reason. I also tried this with a small file and there it did optimize it.
I guess if you do this for all the sheets the file may become much smaller.
That still leaves improvement possibilities in the exporter.
Piet van Oostrum <firstname.lastname@example.org>
PGP key: [8DAE142BE17999C4]
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion? · James Knott
- Re: [libreoffice-users] [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion? (continued)
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy