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
(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?''' <...)
 
 
(2 intermediate revisions by 2 users 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 sceanrios,
 
−
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
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/FAQ/Calc/Miscellaneous/What%27s_the_maximum_number_of_rows_and_cells_for_a_spreadsheet_file%3F&oldid=240294"
Personal tools