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
(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:
−
{{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/>
−
 
+
{{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

Template:Documentation/Note Template:Documentation/Note

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=237160"
Personal tools