A large Calc spreadsheet was converted from another application. Some of my rows are missing! What happened?

A large Calc spreadsheet was converted from another application. Some of my rows are missing! What happened?

2.x

OpenOffice.org spreadsheets supports a maximum of 65,536 rows (32,000 in releases 1.1.x). Spreadsheets converted from other applications that contain more than 65,536 rows will be truncated.

Notes:

• Split large spreadsheets from other applications into smaller worksheets, so that each has fewer than 65,536 rows prior to converting them. A range containing fewer than 65,536 rows will convert correctly in OpenOffice.org 2.x

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

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