Software:LibreOffice Calc

From HandWiki
Short description: Spreadsheet component of LibreOffice
LibreOffice Calc
LibreOffice 7.5 Calc Icon.png
LibreOffice 7.2.4.1 Calc with csv screenshot.png
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
TypeSpreadsheet
LicenseMPLv2.0 (secondary license GPL, LGPLv3+ or Apache License 2.0)[2]
Websitewww.libreoffice.org/discover/calc/

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,

FoxPro

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. 1.0 1.1 https://www.libreoffice.org/download/download/
  2. "Licenses". The Document Foundation. https://www.libreoffice.org/download/license/. 
  3. 3.0 3.1 3.2 "Calc, the LibreOffice spreadsheet program". The Document Foundation. https://www.libreoffice.org/discover/calc/. 
  4. 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. 5.0 5.1 "3.4 New Features and Fixes". The Document Foundation. https://www.libreoffice.org/download/3-4-new-features-and-fixes/. 
  6. Cite error: Invalid <ref> tag; no text was provided for refs named SystemReq
  7. Cite error: Invalid <ref> tag; no text was provided for refs named FreeBSD
  8. "Licenses". The Document Foundation. https://www.libreoffice.org/download/license/. 
  9. "Collabora Office". Google Play. https://play.google.com/store/apps/details?id=com.collabora.libreoffice. 
  10. "Collabora Office". Apple App Store. 2023. https://apps.apple.com/us/app/collabora-office/id1440482071. 
  11. "New beta LibreOffice for AmigaOS 4.1". 28 February 2017. https://www.generationamiga.com/2017/02/28/new-beta-libreoffice-for-amigaos-4-1/. 
  12. "Importing and Exporting CSV Files". The Document Foundation. https://help.libreoffice.org/Calc/Importing_and_Exporting_CSV_Files. 
  13. "About Import and Export Filters". The Document Foundation. https://help.libreoffice.org/Common/About_Import_and_Export_Filters. 
  14. "The Document Foundation, LibreOffice and OOXML". The Document Foundation. https://wiki.documentfoundation.org/LibreOffice_OOXML. 
  15. "Financial Functions Part One". The Document Foundation. https://help.libreoffice.org/Calc/Financial_Functions_Part_One. 
  16. "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. 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/. 
  18. "50916 – Allow more than 1024 columns in calc". https://bugs.documentfoundation.org/show_bug.cgi?id=50916. 
  19. "LibreOffice 7.4 Community: Release Notes - The Document Foundation Wiki". https://wiki.documentfoundation.org/ReleaseNotes/7.4#General_Improvements_2. 
  20. "Pivot Table". The Document Foundation. https://help.libreoffice.org/Calc/Pivot_Table. 

External links