After forking from OpenOffice.org in 2010, LibreOffice Calc underwent a massive re-work of external reference handling to fix a large number of defects in formula calculations involving external references, and to boost data caching performance especially when referencing large data ranges.
Additionally Calc now supports 1 million rows in a spreadsheet with macro references to each cell.
Calc is capable of opening and saving most spreadsheets in Microsoft Excel file format. Calc is also capable of saving spreadsheets as PDF files.
Ability to read/write OpenDocument (ODF), Excel (XLS), CSV and several other formats.
Support for a large number of functions, including those for imaginary numbers, as well as financial and statistical functions.
Supports 1 million rows in a spreadsheet, making LibreOffice spreadsheets more suitable for heavier scientific or financial spreadsheets. However, the number of columns is restricted to at most 1024, much lower than Excel's limit of 16384.
In its internal data structure, Calc until version 4.1 relies on cells as the base class throughout, which has been blamed for "extreme memory use, slow computation, and difficult code". Version 4.2 (scheduled for release in January 2014) addresses these issues by instead storing the data in arrays where possible.
Originally called DataPilot, Pivot Table provides similar functionality to the Pivot table found in Microsoft Excel. It is used for interactive table layout and dynamic data analysis.
Pivot table has support for an unlimited number of fields. Previously Pivot Table only supported up to 8 column/row/data fields and up to 10 page fields.
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.
Calc has continued to diverge since the fork from its parent OpenOffice with new features being added and code cleanups taking place.
Versions for LibreOffice Calc include the following:
Documents drawn with the UNO api can be inserted in calc.
New options for CSV (Comma-Separated Value) importation in Calc, allowing the import of custom delimited files common in engineering scenarios.
Support for 3 different formula syntaxes: Calc A1, Excel A1 and Excel R1C1.
1 million rows in a spreadsheet in Calc, making Calc more suitable for heavier scientific or financial spreadsheets.
Re-work of the drawing layer, to improve precision on re-positioning and re-sizing of drawing objects.
Support for unlimited number of fields: Previously DataPilot only supported up to 8 column/row/data fields and up to 10 page fields. 3.4 has lifted this restriction to allow unlimited number of fields in each field type.
Previously, Calc only supported named ranges in global scope, that is, all named ranges were made available for the entire document regardless of the current sheet. In 3.4 Calc now supports named ranges that are local to a sheet. The named range dialog (Insert->Names->Define) has been modified to reflect this change.
Now preserves OLE links to other Excel documents when importing an Excel document. OLE links get converted to external references upon import. *Previously, Calc ignored OLE links and cells containing OLE links resulted in error upon import.
Multiple subtotals on a single sheet: It is now possible to define more than one subtotal range in a single sheet via Data->Subtotals. Previously, setting a second subtotal range removed the first one if they were on the same sheet.