What are the limits and API differences between Apache OpenOffice and LibreOffice?

I Have been using OpenOffice APIs for a long time and now trying to switch to LibraOffice. What are the differences of maximum limits like

Number of rows in worksheet - 1 million
Number of columns in worksheet - 1024 columns
Number of worksheets in workbook - 10000 worksheets
-am I right?
what are the other limits of
Number of rules in Conditional Formatting (3 in OpenOffice)
Number of filter criteria that can be applied

Number of rows per sheet: 1048676

Number of columns per sheet: 1024

Number of worksheets in workbook: I don’t know (many)

Number of rules in Conditional Formatting: unlimited

Number of filter criteria that can be applied: What do you mean by this? Data | Filter | Standard Filter? The answer is 8.


On web page: LibreOffice Calc - Wikipedia press CTRL+F and search for “limit” word.


Also see LibreOffice vs. Microsoft Office comparison (a lot of useful info): https://wiki.documentfoundation.org/Feature_Comparison:LibreOffice-_Microsoft_Office


In general: LibreOffice and Apache OpenOffice both have the same origin in OpenOffice.org project so maximum limits are for sure not less then at the time of OpenOffice.org. So you don’t need to worry to have less maximum limits.

Number of sheets 10000. Theoretically up to 32000 but disabled due to problems with memory usage on 32 bit systems.

I always wondered if someone is needing more then 10000 sheets in a document and someone needs more then million rows per sheet then this someone is doing something wrong. For this mass of data the database software should be used and not spreadsheets.

Thanks for the answers, After some research and trails I found that these are the limitations


Number of rows per sheet: 1048676 (1 million)

Number of columns per sheet: 1024 (Excel’s limit is 16384)

Number of worksheets in workbook: 10000 (Theoretically up to 32000 but disabled due to problems with memory usage on 32 bit systems)

Number of rules in Conditional Formatting: Unlimited

Number of filter criteria that can be applied: NU API allows Unlimited numbers

Doesn’t allow LaTeX Import and export OO allows export




BTW what are the other calc differences in limitations of LibreOffice and OpenOffice. Is it a good idea to use LibreOffice APIs instead of OO?

There are no API changes listed in the release notes for v3.x. I would advise checking the notes under the API heading for each of the release notes in the v4.x series as there have been API changes e.g., v4.0. To what degree LO API changes have been propagated to Apache OpenOffice will require a developer to confirm.

Both are unlimited in Libreoffice.

What is “both”? There were multiple questions…

He asked for the number of rules in conditional formatting and the number of filter entries. I just saw that we forgot to adapt the dialog for filter entries but at least the UN API should allow an unlimited number of filter entries.

Yes, actually you are right, there were only two questions.