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