Microsoft Excel - One millions rows should be enough for....
"This is a mess with hugely serious implications"
www.thecanary.co
The Excel spreadsheet reached its maximum file size, which stopped new names being added in an automated process, the PA news agency understands.
The files have now been split into smaller multiple files to prevent the issue happening again.
So.. yeah. Why not CSV or XML? Who knows!
I compared MS Excel with LibreOffice, and they both still only offer only one million rows.
In Excel 2010, the maximum worksheet size is 1,048,576 rows by 16,384 columns. In this article, find all workbook, worksheet, and feature specifications and limits.
support.microsoft.com
Learn about the maximum number of rows, columns in LibreOffice Calc so that you can easily understand the limitations.
www.libreofficehelp.com
Excel Total number of rows and columns on a worksheet: 1,048,576 rows by 16,384 columns
LibreOffice same:
- Maximum number of Columns per worksheet = 1024 (Col A to AMJ).
- Maximum number of Rows per worksheet = 1,048,576 (2^20).
gnumeric.h does not go above 65536 rows
but you can edit the constants and recompile your own version to have them:
Lines 8 and 9 of this file are:
#define SHEET_MAX_ROWS (16*16*16*16) /* 0, 1, ... */
#define SHEET_MAX_COLS (4*4*4*4) /* 0, 1, ... */
Google spreadsheet can lower the amount of columns to get more rows
Having 14
columns (A-M), the maximum row is 142 857, which is a total of 1 999 998 cells. cute.
Others I checked: Quattro Pro 2020 (could not find the data)