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
m
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
{{DISPLAYTITLE: What's the maximum number of rows and cells for a spreadsheet file?}}
 
 
 
<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/>
{{WW11x}}
+
The limitations of Apache OpenOffice Calc<!-- 4.1.2 --> are
The OpenOffice.org 1.1.x versions were able to handle a maximum of 32,000 rows.
+
* maximum number of rows: 1,048,576
Update to the [http://download.openoffice.org/index.html current version] to solve this issue.
+
* maximum number of columns: 1,024
 
+
{{WW2x}}
+
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 sheets: 256
* maximum number of cells per file: 4,294,967,296
 
 
{{WW3x}}
 
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.
 
 
 
<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.}}
 +
{{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]]

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