[Libreoffice-bugs] [Bug 139706] Saving as XLS should say how many rows dropped

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=139706

Jean-Baptiste Faure <jbfaure at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
                 CC|                            |jbfaure at libreoffice.org
           Severity|normal                      |enhancement
             Status|UNCONFIRMED                 |NEW

--- Comment #3 from Jean-Baptiste Faure <jbfaure at libreoffice.org> ---
(In reply to Jonny Grant from comment #2)
> (In reply to Uwe Auer from comment #1)
> > If I understand the description correctly the calculation is simple:
> > 
> > Loading TSV file gets cut to 1048576 rows on import. Hence you have 1048576
> > row in the document while application is running. Now you save to XLS (not
> > XLSX!), which has a row limit of 2^16=65536 rows. Hence 1048576 - 65536 =
> > 983040 rows have been skipped.
> 
> Yes, that's what I calculated myself.
> 
> Can the error be clearly displayed with the information?
> 
> "XLS File format does not support saving all 1,048,576 rows, therefore only
> 65,536 rows have been saved. 983,040 have been skipped. Please consider
> choosing ODS format to preserve all rows.

Good point.

Set status to NEW and importance to enhancement.

Best regards. JBF

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210812/82f530ac/attachment.htm>