Difference between revisions of "Documentation/FAQ/Calc/Miscellaneous/What's the maximum number of rows and cells for a spreadsheet file?"
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc | Miscellaneous
(New page: {{DISPLAYTITLE: What's the maximum number of rows and cells for a spreadsheet file?}} <section begin=question/> '''What's the maximum number of rows and cells for a spreadsheet file?''' <...) |
(No difference)
|
Revision as of 13:55, 4 November 2008
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 sceanrios,
hidden helper sheets are created that reduce the available number of sheets and consequently cells.
