(incubating) | The Free and Open Productivity Suite

This page is outdated. You will be redirected to http://wiki.services.openoffice.org /wiki/Documentation/FAQ shortly.

Documentation / User FAQ / Calc / Previous-Next

Can I use a spreadsheet file with more than 32,000 rows?

The current stable releases of Calc allow a maximum of 65536 rows. However, with the 1.1.x release, this is well known, and it is a limitation in comparison to Microsoft Office 2000.

So, if you use 1.1.x, the 32000 limit may a real problem for your application. Nonetheless, there are a few options to consider. Frequently when you are hitting the row limit, it is a symptom of a spreadsheet design which could be improved:

Restructure the rows. Split the data into several files or several spreadsheets within one file.
Use a real database. This is the most frequent thing people are trying to accomplish by having such a large number of rows in a sheet.

Documentation / User FAQ / Calc / Previous-Next

Apache OpenOffice is an effort undergoing incubation at The Apache Software Foundation (ASF), sponsored by the Apache Incubator. Incubation is required of all newly accepted projects until a further review indicates that the infrastructure, communications, and decision making process have stabilized in a manner consistent with other successful ASF projects. While incubation status is not necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF.

Copyright & License
Apache and the Apache feather logos are trademarks of The Apache Software Foundation. OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.