Loading AI tools
Spreadsheet component of LibreOffice From Wikipedia, the free encyclopedia
LibreOffice Calc is the spreadsheet component of the LibreOffice software package.[6][7]
![]() | |
![]() 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 | |
Operating system | Linux, macOS, Microsoft Windows[3] and FreeBSD[4] |
Type | Spreadsheet |
License | MPLv2.0 (secondary license GPL, LGPLv3+ or Apache License 2.0)[5] |
Website | www |
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]
As with the entire LibreOffice suite, Calc is available for a variety of platforms, including Linux, macOS, Microsoft Windows,[3] and FreeBSD.[4] Available under the Mozilla Public License, Calc is free and open-source software.[9] There are community builds for many other platforms. Ecosystem partner Collabora uses LibreOffice upstream code and provides apps for Android, iOS, iPadOS and ChromeOS.[10][11] 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.[12]
Capabilities of Calc include:
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]
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 |
Seamless Wikipedia browsing. On steroids.
Every time you click a link to Wikipedia, Wiktionary or Wikiquote in your browser's search results, it will show the modern Wikiwand interface.
Wikiwand extension is a five stars, simple, with minimum permission required to keep your browsing private, safe and transparent.