LibreOffice Calc is the spreadsheet component of the LibreOffice software package.
Wiki English | |
Wiki English | |
Developer(s) | The Document Foundation |
---|---|
Stable release | |
Operating system | Linux, macOS, Microsoft Windows and FreeBSD |
Type | Spreadsheet |
License | MPLv2.0 (secondary license GPL, LGPLv3+ or Apache License 2.0) |
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.
Calc is capable of opening and saving most spreadsheets in Microsoft Excel file format. Calc is also capable of saving spreadsheets as PDF files.
As with the entire LibreOffice suite, Calc is available for a variety of platforms, including Linux, macOS, Microsoft Windows, and FreeBSD. Available under the Mozilla Public License, Calc is free and open-source software. There are community builds for many other platforms. Ecosystem partner Collabora uses LibreOffice upstream code and provides apps for Android, iOS, iPadOS and ChromeOS. 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.
Capabilities of Calc include:
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.
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.
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 |
This article uses material from the Wikipedia English article LibreOffice Calc, which is released under the Creative Commons Attribution-ShareAlike 3.0 license ("CC BY-SA 3.0"); additional terms may apply (view authors). Content is available under CC BY-SA 4.0 unless otherwise noted. Images, videos and audio are available under their respective licenses.
®Wikipedia is a registered trademark of the Wiki Foundation, Inc. Wiki English (DUHOCTRUNGQUOC.VN) is an independent company and has no affiliation with Wiki Foundation.