 | This articlerelies excessively onreferences toprimary sources. Please improve this article by addingsecondary or tertiary sources. Find sources: "LibreOffice Calc" – news ·newspapers ·books ·scholar ·JSTOR(June 2013) (Learn how and when to remove this message) |
| LibreOffice Calc | |
|---|---|
 | |
 LibreOffice Calc 7.2.4 (released in December 2021, running onLinux andKDE Plasma 5 with the Breeze icon set) | |
| Developer | The Document Foundation |
| Stable release(s) | |
| Repository | |
| Operating system | Cross platform |
| Type | Spreadsheet |
| License | MPLv2.0 (secondary licenseGPL,LGPLv3+ orApache License 2.0)[3] |
| Website | libreoffice |
LibreOffice Calc is thespreadsheet component of theLibreOffice suite.[4][5]
After forking fromOpenOffice.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 boostdata caching performance, especially when referencing large data ranges.[6]
Calc is capable of opening and saving most spreadsheets inMicrosoft Excel file format.[4] Calc is also capable of saving spreadsheets asPDF files.[4]
As with the entire LibreOffice suite, Calc is available for a variety of platforms, includingLinux,macOS,Microsoft Windows,[7] andFreeBSD.[8] Available under theMozilla Public License, Calc isfree and open-source software.[9] There are community builds for many other platforms. Ecosystem partnerCollabora uses LibreOffice upstream code and provides apps forAndroid,iOS,iPadOS andChromeOS.[10][11] LibreOffice Online is an online office suite which includes the applicationsWriter, Calc and Impress and provides an upstream for projects such as commercialCollabora Online.
There is now a closed beta of LibreOffice onAmigaOS 4.1.[12]
Capabilities of Calc include:
Originally called DataPilot,[6] Pivot Table provides similar functionality to thePivot table found inMicrosoft 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, writeup to 3.6 | |
| SYLK | SLK | Yes |
| Applications |
|  | ||||||
|---|---|---|---|---|---|---|---|---|
| Technologies | ||||||||
| Organisations | ||||||||
