I Load a TSV file, which Calc can't load more than 1M rows Then I save as XLS, and there is a popup error saying the format can't handle the number of rows, and is truncated. Can the error popup specify how many rows were output, and how many were dropped? Could even suggest to save as ODS.
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.
(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.
(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
Hi Even better is a dialog offering: "XLS File format does not support saving all 1,048,576 rows click [OK] to save a truncated 65,536 rows, or [Cancel] to change to another format"
Note, if this bug can be implemented, it would be worth adding the same for TSV or CSV loading, if those are truncated too.