After forking from OpenOffice.org in 2010, LibreOffice Calc underwent a massive re-work of external reference handling to fix many defects in formula calculations involving external references, and to boost data caching performance, especially when referencing large data ranges.[8]
Calc is capable of opening and saving most spreadsheets in Microsoft Excel file format.[6] Calc is also capable of saving spreadsheets as PDF files.[6]
There is now a closed beta of LibreOffice on AmigaOS 4.1.[12]
Features
Capabilities of Calc include:
Ability to read/write OpenDocument (ODF), Microsoft Excel (XLSX), CSV,[13] and several other formats.[14][15]
Support for many functions, including those for imaginary numbers, as well as financial and statistical functions.[16][17]
Supports 1,048,576 rows and 16384 columns in a spreadsheet, making LibreOffice spreadsheets more suitable for heavier scientific or financial spreadsheets.[18] Version 7.0 introduced "very large spreadsheets" which can be enabled as an experimental feature.[19] Version 7.4 made very large spreadsheets default.[20]
Up to now, new functions such as IFS, Switch TEXT JOIN, MAXIFS, MINIFS functions, etc. were available only in Excel 2016 and later. LibreOffice Calc can use them.
Pivot Table
Originally called DataPilot,[8] Pivot Table provides similar functionality to the Pivot table found in Microsoft Excel. It is used for interactive table layout and dynamic data analysis.[21]
An advanced sort macro is included that allows data to be arranged or categorised based on either a user generated macro or one of several default included macros.[18]