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

From Apache OpenOffice Wiki
< Documentation‎ | FAQ‎ | Calc‎ | Files
Jump to: navigation, search


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


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


Personal tools