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
(update max rows https://svn.apache.org/viewvc/openoffice/trunk/main/sc/inc/address.hxx?view=markup#l80 and change style) |
|||
Line 8: | Line 8: | ||
* maximum number of sheets: 256 | * maximum number of sheets: 256 | ||
<section end=answer/> | <section end=answer/> | ||
− | {{ | + | {{Note| |
* When referencing to external documents in formulas or when creating scenarios, hidden helper sheets are created that reduce the available number of sheets.}} | * When referencing to external documents in formulas or when creating scenarios, hidden helper sheets are created that reduce the available number of sheets.}} | ||
− | {{ | + | {{Note| |
* versions before Openoffice.org 3.3 support only 65,536 rows and 1024 columns | * versions before Openoffice.org 3.3 support only 65,536 rows and 1024 columns | ||
* versions before Openoffice.org 3.0 support only 65,536 rows and 256 columns | * versions before Openoffice.org 3.0 support only 65,536 rows and 256 columns | ||
* versions before Openoffice.org 1.1.x support only 32,000 rows and 256 columns}} | * versions before Openoffice.org 1.1.x support only 32,000 rows and 256 columns}} | ||
[[Category:Documentation/FAQ/Calc/Miscellaneous]] | [[Category:Documentation/FAQ/Calc/Miscellaneous]] |
Latest revision as of 13:24, 6 July 2018
What's the maximum number of rows and cells for a spreadsheet file?
The limitations of Apache OpenOffice Calc are
- maximum number of rows: 1,048,576
- maximum number of columns: 1,024
- maximum number of sheets: 256