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. -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1011564 Title: [upstream] "the document contains more rows than supported in the selected format." Status in LibreOffice Productivity Suite: Unknown Status in “libreoffice” package in Ubuntu: Confirmed Bug description: Obtained result: When saving a Calc spreadsheet in Excel format, the message "Warning saving the document xxx:" "the document contains more rows than supported in the selected format." "Additional rows were not saved" appears. However, the document only has 1100-or-so rows. Expected result: no error message - A similar bug has been reported upstream https://bugs.freedesktop.org/show_bug.cgi?id=50471 but not actioned. - There is an older bug https://issues.apache.org/ooo/show_bug.cgi?id=106083 reported against Openoffice.org which states this issue is caused by sheets that have undefined Print Ranges, which are not truncated properly by the Excel export filter. - I confirmed that the error message does not show if the print ranges are manually sized to the area of active cells. - It appears that the issue returned in 3.5.3 having previously been fixed. Can this bug be reported upstream by Ubuntu, as this report may carry more weight than the single report on the freedesktop.org site? ProblemType: Bug DistroRelease: Ubuntu 12.04 Package: libreoffice-calc 1:3.5.3-0ubuntu1 ProcVersionSignature: Ubuntu 3.2.0-25.40-generic-pae 3.2.18 Uname: Linux 3.2.0-25-generic-pae i686 ApportVersion: 2.0.1-0ubuntu9 Architecture: i386 Date: Mon Jun 11 12:20:09 2012 InstallationMedia: Ubuntu 10.04 LTS "Lucid Lynx" - Release i386 (20100429) SourcePackage: libreoffice UpgradeStatus: Upgraded to precise on 2012-02-22 (109 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1011564/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
