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

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

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

add a comment

2

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

L-user
2877 ●33 ●45 ●64

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

Comments

1

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

moggi ( 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 ( 2013-12-17 18:37:41 +0100 )edit

add a comment

1

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

Sugam Varshney
28 ●6 ●8 ●12

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

L-user
2877 ●33 ●45 ●64

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

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 ( 2014-08-10 02:21:20 +0100 )edit

add a comment

0

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

moggi
611 ●5 ●12 http://mmohrhard.wordp...

Both are unlimited in Libreoffice.

edit flag offensive delete link

Comments

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

L-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 ( 2013-12-17 14:42:24 +0100 )edit

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

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

add a comment

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

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

Comments

Comments

Comments

Question Tools

Stats

Related questions

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

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

Comments

Comments

Comments

Question Tools

Stats

Related questions

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

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