Comment 2 for bug 1011564

Revision history for this message
Chris B (billington-chris) wrote :

On further experimentation I found that restricting the print area does NOT remove the error message.

However, in the document used for testing, a template file prepared as follows gives the error, tested with Libreoffice 3.5.4_2 from PPA and 3.5.3:

- new document
- fill column A with data using fill/increment for a hundred or so rows.
- Select column header and give all cells borders (which extend the to the rows limit), or perform other formatting to the entire column, such as background fill
- save as .xls format

Result: unsupported rows

If the cell formatting is restricted to the active area, the error message does not show.

It appears that the range of formatted cells is not truncated by the Excel export filter, giving rise to an error for the formatting over 64k rows.

Unfortunately this technique of cell formatting is in common use by spreadsheet users to avoid selecting a specific area in their document.