Ask Your Question
1

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

asked 2013-12-17 12:24:38 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-01 21:21:57.987001

3 Answers

Sort by » oldest newest most voted
2

answered 2013-12-17 13:35:58 +0100

L-user gravatar image

updated 2013-12-17 13:51:07 +0100

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: https://en.wikipedia.org/wiki/LibreOffice_Calc 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.

edit flag offensive delete link more

Comments

1

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

moggi gravatar imagemoggi ( 2013-12-17 14:43:30 +0100 )edit

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.

L-user gravatar imageL-user ( 2013-12-17 18:37:41 +0100 )edit
1

answered 2013-12-18 13:21:25 +0100

Sugam Varshney gravatar image

updated 2013-12-18 20:24:19 +0100

L-user gravatar image

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?

edit flag offensive delete link more

Comments

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.

oweng gravatar imageoweng ( 2014-08-10 02:21:20 +0100 )edit
0

answered 2013-12-17 12:51:22 +0100

Both are unlimited in Libreoffice.

edit flag offensive delete link more

Comments

What is "both"? There were multiple questions...

L-user gravatar imageL-user ( 2013-12-17 13:52:55 +0100 )edit

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.

moggi gravatar imagemoggi ( 2013-12-17 14:42:24 +0100 )edit

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

L-user gravatar imageL-user ( 2013-12-17 18:38:11 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2013-12-17 12:24:38 +0100

Seen: 1,714 times

Last updated: Aug 10 '14