12 April 2014: The OpenOffice Wiki is not, and never was, affected by the heartbleed bug. Users' passwords are safe and wiki users do not need take any actions.

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