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?

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.