Apache OpenOffice (AOO) Bugzilla – Issue 106083
Error message "too many rows" when saving XLS file with new file name (save as)
Last modified: 2017-05-20 11:41:48 UTC
All documents mentioned within this issue have been provided directly to Daniel Renz. I cannot add them because they're confidential The document is a XLS file, this file generate an error message (second file) when saving the document. To reproduce the problem : 1. open the file 2. save it as 3. In the dialog, choose a name and type it 4. don't change the format!!! 5. confirm saving by clicking on the "save" button in the dialog You get the error message (see screenshot provided) Root cause are the print ranges on second and following sheets. These are defined to span the whole sheet area (65536 rows, 256 columns, A1:IV65536) in Excel. On import into Calc, these ranges are expanded to Calc's full sheet area (1024 columns, A1:AMJ65536). The export filter does not shrink them accordingly but detects a cell range overflow and thus shows a warning.
fixed
back to QA Solution is to not warn about print ranges that are too big. If there is some real cell content that is truncated on export, this will be warned by the code skipping these cells.
verified in internal build
*** Issue 103215 has been marked as a duplicate of this issue. ***