Created attachment 127347 [details] CSV file containing exactly 1048576 records LibreOffice Calc warns "The data could not be loaded completely because the maximum number of rows per sheet was exceeded." when importing a CSV file containing exactly 1048576 records. If I remove one record from the CSV file so it has 1048575 records, LibreOffice Calc imports the file without any warnings. Once imported, I can descend to row 1048576 and enter a value there. I don't think LibreOffice Calc should be giving a warning when importing exactly 1048576 rows.
Confirmed, with as early as v3.3.0. In addition, after saving the file as ODT, loading it takes forever, which seems to be a performance issue.
Aron Budea committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=451c7de9d750f8a2f1348b1eae1bcd8ee042563d tdf#102216: move row overflow check after EoF check (CSV import) It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
That should get rid of the warning when there are exactly 1048576 records. The fix will be part of 5.3.