What's the maximum number of rows and cells for a spreadsheet file?

From Apache OpenOffice Wiki
Jump to: navigation, search


What's the maximum number of rows and cells for a spreadsheet file?


1.1.x

The OpenOffice.org 1.1.x versions were able to handle a maximum of 32,000 rows. Update to the current version to solve this issue.

2.x

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 cells per file: 4,294,967,296

3.x

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.


Personal tools