[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

--- Comment #2 from Jonny Grant <jg at jguk.org> ---
(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.

-- 
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/20210117/2d675959/attachment-0001.htm>