What's the maximum number of rows and cells for a spreadsheet file?
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc | Miscellaneous
What's the maximum number of rows and cells for a spreadsheet file?
1.1.x
The OpenOffice.org 1.1.x versions were able to handle a maximum of 32,000 rows. Update to the current version to solve this issue.
2.x
The limitations of the OpenOffice.org 2.x Calc versions are
- maximum number of rows: 65,536
- maximum number of columns: 256
- maximum number of cells per sheet: 16,777,216
- maximum number of sheets: 256
- maximum number of cells per file: 4,294,967,296
3.x
The limitations of the OpenOffice.org 3.x Calc versions are
- maximum number of rows: 65,536
- maximum number of columns: 1024
- maximum number of cells per sheet: 67,108,864
Notes:
- When referencing to external documents in formulas or when creating scenarios, hidden helper sheets are created that reduce the available number of sheets and consequently cells.