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
Jump to: navigation, search
(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/>
{{Documentation/Note|
+
{{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.}}
{{Documentation/Note|
+
{{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
Documentation note.png
  • 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.png
  • 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
Personal tools