LibreOffice Calc
| Company type | Free and open-source software |
|---|---|
| Industry | Software / Office suite |
| Predecessor | OpenOffice.org Calc |
| Founded | 2010 |
| Products | Spreadsheet application |
| Owner | The Document Foundation |
| Website | www |
LibreOffice Calc serves as the spreadsheet application within the LibreOffice suite.
Following its separation from OpenOffice.org in 2010, LibreOffice Calc made notable advancements in managing external references, addressing formula calculation errors, and optimizing data caching efficiency, especially when working with extensive datasets.
Calc provides compatibility for opening and saving a wide range of spreadsheet formats, including those used by Microsoft Excel file format, and supports exporting spreadsheets directly to PDF documents.
As a component of the LibreOffice suite, Calc is accessible on various operating systems such as Linux, macOS, Microsoft Windows, and FreeBSD. Licensed under the Mozilla Public License, it is distributed as free and open-source software. Additionally, community-supported builds extend availability to other platforms. The ecosystem partner Collabora utilizes LibreOffice's core codebase to develop applications for Android, iOS, iPadOS, and ChromeOS. LibreOffice Online delivers a web-based office suite that includes Writer, Calc, and Impress, forming the foundation for commercial offerings like Collabora Online.
A closed beta release of LibreOffice is also accessible for AmigaOS 4.1.
Features
Calc includes:
- Support for numerous file standards such as OpenDocument (ODF), Microsoft Excel (XLSX), CSV, among others.
- A broad array of functions encompassing financial calculations, statistical analysis, and operations involving imaginary numbers.
- Capability to handle spreadsheets with up to 1,048,576 rows and 16,384 columns, accommodating large-scale scientific or financial data. The experimental "very large spreadsheets" feature debuted in version 7.0 and became standard with version 7.4.
- Inclusion of sophisticated functions like IFS, SWITCH, TEXTJOIN, MAXIFS, and MINIFS that were previously exclusive to Excel versions from 2016 onward.
Pivot Table
Previously called DataPilot, the Pivot Table functionality facilitates interactive table arrangements and dynamic data summarization similar to pivot tables found in Microsoft Excel.
An enhanced sorting macro is available to organize or classify data sets using either preset or user-created macros.
Supported file formats
| File format | Extension | Read/Write | Notes | |
|---|---|---|---|---|
| Apple Numbers | NUMBERS | Template:Yes2 | ||
| Comma-separated values | CSV | Yes | ||
| Data Interchange Format | DIF | Yes | ||
| DBase, Clipper, VP-Info, FoxPro | DBF | Yes | ||
| Gnumeric | GNM, GNUMERIC | Template:Partial | ||
| 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 | Template:Yes2 | ||
| 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 | Template:Yes2 | ||
| SYLK | SLK | Yes |