![]() | |
![]() LibreOffice Calc 7.2.4 (released in December 2021, running on Linux and KDE Plasma 5 with the Breeze icon set) | |
Developer(s) | The Document Foundation |
---|---|
Stable release(s) | |
Preview release(s) | |
Operating system | Cross platform |
Type | Spreadsheet |
License | MPLv2.0 (secondary license GPL,LGPLv3+ or Apache License 2.0) [4] |
Website | libreoffice |
LibreOffice Calc is the spreadsheet component of the LibreOffice suite. [5] [6]
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. [7]
Calc is capable of opening and saving most spreadsheets in Microsoft Excel file format. [5] Calc is also capable of saving spreadsheets as PDF files. [5]
As with the entire LibreOffice suite,Calc is available for a variety of platforms,including Linux,macOS,Microsoft Windows, [8] and FreeBSD. [9] Available under the Mozilla Public License,Calc is free and open-source software. [10] There are community builds for many other platforms. Ecosystem partner Collabora uses LibreOffice upstream code and provides apps for Android,iOS,iPadOS and ChromeOS. [11] [12] LibreOffice Online is an online office suite which includes the applications Writer,Calc and Impress and provides an upstream for projects such as commercial Collabora Online.
There is now a closed beta of LibreOffice on AmigaOS 4.1. [13]
Capabilities of Calc include:
Originally called DataPilot, [7] Pivot Table provides similar functionality to the Pivot table found in Microsoft Excel. It is used for interactive table layout and dynamic data analysis. [22]
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. [19]
File format | Extension | Read/Write | Notes |
---|---|---|---|
Apple Numbers | NUMBERS | From 5.0 | |
Comma-separated values | CSV | Yes | |
Data Interchange Format | DIF | Yes | |
DBase,Clipper,VP-Info, | DBF | Yes | |
Gnumeric | GNM,GNUMERIC | From 5.1,cannot write | |
Lotus 1-2-3 | 123,WKS,WKS1,WK2, WK3,WK4 | Yes | |
Microsoft Excel 4/5/95 | XLS,XLW,XLT | Yes,writing up to 3.6 | |
Microsoft Excel 97–2003 | XLS,XLW,XLT | Yes | |
Microsoft Excel 2007–2021 | XLSX,XLTX,XLSM, XLTM | Yes | |
Microsoft Excel 2003 XML | XML | Yes | |
Microsoft Excel Web Query File | IQY | From 5.4 | |
Microsoft Pocket Excel | PXL | Yes | Requires Java |
OpenDocument (spreadsheet) | ODS,FODS,OTS, | Yes | |
OpenOffice.org XML (spreadsheet) | SXC,STC | Yes | |
Quattro Pro 6.0 | WB2,WQ1,WQ2 | Yes | |
StarOffice StarCalc 3/4/5 | SDC,VOR | Dropped in 4.0 then added back in 5.3,write up to 3.6 | |
SYLK | SLK | Yes |
{{cite web}}
: CS1 maint: numeric names: authors list (link){{cite web}}
: CS1 maint: year (link)