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?''' <...) |
m |
||
| Line 25: | Line 25: | ||
'''Notes:''' | '''Notes:''' | ||
| − | * When referencing to external documents in formulas or when creating | + | * 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. |
| − | hidden helper sheets are created that reduce the available number of sheets and consequently cells. | + | |
<section end=answer/> | <section end=answer/> | ||
[[Category:Documentation/FAQ/Calc/Miscellaneous]] | [[Category:Documentation/FAQ/Calc/Miscellaneous]] | ||
Revision as of 14:07, 26 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 scenarios, hidden helper sheets are created that reduce the available number of sheets and consequently cells.
