Launchpad has imported 9 comments from the remote bug at https://bugs.documentfoundation.org/show_bug.cgi?id=50471.
If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. ------------------------------------------------------------------------ On 2012-05-29T10:46:50+00:00 Alain-desgeorge wrote: Created attachment 62233 a sample ods sheet 481 rows Problem description: 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 Current behavior: Warning Expected behavior: 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 Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1011564/comments/0 ------------------------------------------------------------------------ On 2012-06-11T05:12:38+00:00 Björn Michaelsen wrote: confirmed by dupe/downstream bug Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1011564/comments/2 ------------------------------------------------------------------------ On 2012-06-11T05:14:30+00:00 Björn Michaelsen wrote: Is this a regression? Did this work in 3.4/3.3? Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1011564/comments/3 ------------------------------------------------------------------------ On 2012-06-11T05:37:13+00:00 Eike Rathke wrote: 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. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1011564/comments/4 ------------------------------------------------------------------------ On 2012-06-11T06:35:07+00:00 Eike Rathke wrote: 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. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1011564/comments/5 ------------------------------------------------------------------------ On 2012-06-11T06:46:28+00:00 Markus Mohrhard wrote: (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. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1011564/comments/6 ------------------------------------------------------------------------ On 2012-06-11T07:27:17+00:00 Eike Rathke wrote: (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? Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1011564/comments/7 ------------------------------------------------------------------------ On 2012-06-11T07:39:26+00:00 Markus Mohrhard wrote: That sounds sane. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1011564/comments/8 ------------------------------------------------------------------------ On 2014-11-06T20:54:08+00:00 Jmadero-dev wrote: Looks like this was confirmed but never taken up by anyone - moving to NEW. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1011564/comments/21 ** Changed in: df-libreoffice Status: Unknown => Confirmed ** Changed in: df-libreoffice Importance: Unknown => Wishlist -- 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: Confirmed Status in libreoffice package in Ubuntu: Incomplete 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 : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
