Created attachment 62233 [details]
a sample ods sheet 481 rows
when saving a spreadsheet in ods format, then in xls format, to distribute, I get the message saying:
"Warnig saving the document xxx:"
"the document contains more rows than supported in the selected format."
"Additional rows were not saved"
which is not true, both files have the same number of rows 481.
If I re-open the xls file, make a change and save, I get no warning.
both files saved as csv and compared are identical.
Steps to reproduce:
1. open myfile.ods
2. make a change, save as ods
3. save as xls Excel 97
Warning only if this is true ;-)
Platform (if different from the browser):
Browser: Mozilla/5.0 (Windows NT 5.1; rv:12.0) Gecko/20100101 Firefox/12.0
confirmed by dupe/downstream bug
Is this a regression? Did this work in 3.4/3.3?
The attached file has all cells of columns C to IN explicitly formatted with white background down to row 1048576. Binary xls 97 file format supports only 64k rows, so the message is correct.
Thinking this over, the expected behavior might be that extraneous attributed-only rows are ignored in this case. Import of xls 97 already handles that by expanding the attributed range. Actually LibO 3.4 treated this differently and did not show the message on export.
(In reply to comment #4)
> Thinking this over, the expected behavior might be that extraneous
> attributed-only rows are ignored in this case. Import of xls 97 already handles
> that by expanding the attributed range. Actually LibO 3.4 treated this
> differently and did not show the message on export.
I had to change the export of attribute only rows because without the row height information which are part of the attributes we misplace cell anchored objects.
(In reply to comment #5)
Well, yes, but it should work to export the full range that is supported by the target format and truncate the extraneous rows that are only attributed. Or am I missing something?
That sounds sane.
Looks like this was confirmed but never taken up by anyone - moving to NEW.