Software:LibreOffice Calc
 | |
 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 | |
| Type | Spreadsheet |
| License | MPLv2.0 (secondary license GPL, LGPLv3+ or Apache License 2.0)[2] |
| Website | www |
LibreOffice Calc is the spreadsheet component of the LibreOffice software package.[3][4]
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.[5]
Calc is capable of opening and saving most spreadsheets in Microsoft Excel file format.[3] Calc is also capable of saving spreadsheets as PDF files.[3]
As with the entire LibreOffice suite, Calc is available for a variety of platforms, including Linux, macOS, Microsoft Windows,[6] and FreeBSD.[7] Available under the Mozilla Public License, Calc is free and open-source software.[8] There are community builds for many other platforms. Ecosystem partner Collabora uses LibreOffice upstream code and provides apps for Android, iOS, iPadOS and ChromeOS.[9][10] 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.[11]
Features
Capabilities of Calc include:
- Ability to read/write OpenDocument (ODF), Microsoft Excel (XLSX), CSV,[12] and several other formats.[13][14]
- Support for many functions, including those for imaginary numbers, as well as financial and statistical functions.[15][16]
- Supports 1,048,576 rows and 16384 columns in a spreadsheet, making LibreOffice spreadsheets more suitable for heavier scientific or financial spreadsheets.[17] Version 7.0 introduced "very large spreadsheets" which can be enabled as an experimental feature.[18] Version 7.4 made very large spreadsheets default.[19]
- Up to now, new functions such as IFS, Switch TEXT JOIN, MAXIFS, MINIFS functions, etc. were available only in Excel 2016 and later. LibreOffice Calc can use them.
Pivot Table
Originally called DataPilot,[5] Pivot Table provides similar functionality to the Pivot table found in Microsoft Excel. It is used for interactive table layout and dynamic data analysis.[20]
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.[17]
Supported file formats
| 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 |
See also
References
- ↑ 1.0 1.1 https://www.libreoffice.org/download/download/
- ↑ "Licenses". The Document Foundation. https://www.libreoffice.org/download/license/.
- ↑ 3.0 3.1 3.2 "Calc, the LibreOffice spreadsheet program". The Document Foundation. https://www.libreoffice.org/discover/calc/.
- ↑ Petersen, Richard (2011). Ubuntu 11. 04 Desktop Handbook. Surfing Turtle Press. p. 170. ISBN 978-1-936280-28-5. https://books.google.com/books?id=CS7txn0x8OEC&pg=PA170.
- ↑ 5.0 5.1 "3.4 New Features and Fixes". The Document Foundation. https://www.libreoffice.org/download/3-4-new-features-and-fixes/.
- ↑ Cite error: Invalid
<ref>tag; no text was provided for refs namedSystemReq - ↑ Cite error: Invalid
<ref>tag; no text was provided for refs namedFreeBSD - ↑ "Licenses". The Document Foundation. https://www.libreoffice.org/download/license/.
- ↑ "Collabora Office". Google Play. https://play.google.com/store/apps/details?id=com.collabora.libreoffice.
- ↑ "Collabora Office". Apple App Store. 2023. https://apps.apple.com/us/app/collabora-office/id1440482071.
- ↑ "New beta LibreOffice for AmigaOS 4.1". 28 February 2017. https://www.generationamiga.com/2017/02/28/new-beta-libreoffice-for-amigaos-4-1/.
- ↑ "Importing and Exporting CSV Files". The Document Foundation. https://help.libreoffice.org/Calc/Importing_and_Exporting_CSV_Files.
- ↑ "About Import and Export Filters". The Document Foundation. https://help.libreoffice.org/Common/About_Import_and_Export_Filters.
- ↑ "The Document Foundation, LibreOffice and OOXML". The Document Foundation. https://wiki.documentfoundation.org/LibreOffice_OOXML.
- ↑ "Financial Functions Part One". The Document Foundation. https://help.libreoffice.org/Calc/Financial_Functions_Part_One.
- ↑ "Add-in Functions, List of Analysis Functions Part Two". The Document Foundation. https://help.libreoffice.org/Calc/Add-in_Functions,_List_of_Analysis_Functions_Part_Two#IMAGINARY.
- ↑ 17.0 17.1 "3.3 New Features and Fixes". The Document Foundation. 2011. https://www.libreoffice.org/download/3-3-new-features-and-fixes/.
- ↑ "50916 – Allow more than 1024 columns in calc". https://bugs.documentfoundation.org/show_bug.cgi?id=50916.
- ↑ "LibreOffice 7.4 Community: Release Notes - The Document Foundation Wiki". https://wiki.documentfoundation.org/ReleaseNotes/7.4#General_Improvements_2.
- ↑ "Pivot Table". The Document Foundation. https://help.libreoffice.org/Calc/Pivot_Table.
External links
 |  |
