Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Thanks for the answers, After some research and trails I 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?

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?

click to hide/show revision 3
No.3 Revision

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



Number of rows per sheet: 1048676 (1 million) million)
Number of columns per sheet: 1024 (Excel's limit is 16384) 16384)
Number of worksheets in workbook: 10000 (Theoretically up to 32000 but disabled due to problems with memory usage on 32 bit systems) systems)
Number of rules in Conditional Formatting: Unlimited Unlimited
Number of filter criteria that can be applied: NU API allows Unlimited numbers 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?