Difference between revisions of "Documentation/FAQ/Calc/Files/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
(New page: {{DISPLAYTITLE: A large Calc spreadsheet was converted from another application. Some of my rows are missing! What happened?}} <section begin=question/> '''A large Calc spreadsheet was co...) |
m |
||
Line 6: | Line 6: | ||
<section begin=answer/> | <section begin=answer/> | ||
+ | {{WW2x}} | ||
OpenOffice.org spreadsheets supports a maximum of 65,536 rows (32,000 in releases 1.1.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. | Spreadsheets converted from other applications that contain more than 65,536 rows will be truncated. | ||
Line 12: | Line 13: | ||
* 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 | * 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 | ||
+ | {{Note| | ||
+ | * 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<!-- 4.1.2 --> are | ||
+ | * maximum number of rows: 1,048,576 | ||
+ | * maximum number of columns: 1,024 | ||
+ | * maximum number of sheets: 256 | ||
<section end=answer/> | <section end=answer/> | ||
[[Category:Documentation/FAQ/Calc/Files]] | [[Category:Documentation/FAQ/Calc/Files]] |
Latest revision as of 09:49, 6 October 2021
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
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