Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index

m.a.riosv wrote:

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
the sheet.

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
of it.

Miguel Ángel.

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 <>
PGP key: [8DAE142BE17999C4]

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.