LibreOffice Calc

{{Short description|Spreadsheet component of LibreOffice}}

{{Use dmy dates|date=March 2023}}

{{Use American English|date=March 2023}}

{{primary sources|date=June 2013}}

{{Infobox software

| name = LibreOffice Calc

| logo = LibreOffice 7.5 Calc Icon.svg

| logo upright = 0.3

| screenshot = LibreOffice 7.2.4.1 Calc with csv screenshot.png

| caption = LibreOffice Calc 7.2.4 (released in December 2021, running on Linux and KDE Plasma 5 with the Breeze icon set)

| developer = The Document Foundation

| ver layout = stacked

| latest release version = {{Latest stable software release/LibreOffice}}

| latest preview version = {{wikidata|property|preferred|Q10135|P348|P548=Q51930650}}

| latest preview date = {{wikidata|qualifier|preferred|references|edit|Q10135|P348|P548=Q51930650|P577}}

| operating system = Cross platform

| genre = Spreadsheet

| license = MPLv2.0 (secondary license GPL, LGPLv3+ or Apache License 2.0){{Cite web |title=Licenses |url=https://www.libreoffice.org/download/license/ |access-date=16 December 2015 |publisher=The Document Foundation}}

| website = {{URL|libreoffice.org/discover/calc}}

}}

LibreOffice Calc is the spreadsheet component of the LibreOffice suite.{{Cite web |title=Calc, the LibreOffice spreadsheet program |url=https://www.libreoffice.org/discover/calc/ |access-date=8 September 2011 |publisher=The Document Foundation}}{{Cite book |last=Petersen |first=Richard |url=https://books.google.com/books?id=CS7txn0x8OEC&pg=PA170 |title=Ubuntu 11. 04 Desktop Handbook |publisher=Surfing Turtle Press |year=2011 |isbn=978-1-936280-28-5 |page=170}}

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.{{Cite web |title=3.4 New Features and Fixes |url=https://www.libreoffice.org/download/3-4-new-features-and-fixes/ |archive-url=https://web.archive.org/web/20131214213702/https://www.libreoffice.org/download/3-4-new-features-and-fixes/ |archive-date=14 December 2013 |access-date=8 September 2011 |publisher=The Document Foundation}}

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,{{Cite web|url = https://www.libreoffice.org/get-help/system-requirements/|title = System Requirements|access-date = 8 September 2011|last = The Document Foundation|author-link = The Document Foundation|year = n.d.}} and FreeBSD.[http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/desktop-productivity.html FreeBSD Handbook, 7.3.5 LibreOffice] Available under the Mozilla Public License, Calc is free and open-source software.{{Cite web |title=Licenses |url=https://www.libreoffice.org/download/license/ |access-date=21 June 2011 |publisher=The Document Foundation}} There are community builds for many other platforms. Ecosystem partner Collabora uses LibreOffice upstream code and provides apps for Android, iOS, iPadOS and ChromeOS.{{Cite web |title=Collabora Office |url=https://play.google.com/store/apps/details?id=com.collabora.libreoffice |url-status=live |archive-url=https://archive.today/20221231145049/https://play.google.com/store/apps/details?id=com.collabora.libreoffice |archive-date=31 December 2022 |access-date=7 May 2023 |website=Google Play}}{{Cite web |year=2023 |title=Collabora Office |url=https://apps.apple.com/us/app/collabora-office/id1440482071 |url-status=live |archive-url=https://archive.today/20201005085449/https://apps.apple.com/us/app/collabora-office/id1440482071 |archive-date=5 October 2020 |access-date=7 May 2023 |website=Apple App Store}} 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.{{Cite web |date=28 February 2017 |title=New beta LibreOffice for AmigaOS 4.1 |url=https://www.generationamiga.com/2017/02/28/new-beta-libreoffice-for-amigaos-4-1/ |url-status=dead |archive-url=https://web.archive.org/web/20191202060646/http://www.generationamiga.com/2017/02/28/new-beta-libreoffice-for-amigaos-4-1/ |archive-date=2 December 2019 |access-date=12 December 2018 |website=GenerationAmiga.com}}

Features

Capabilities of Calc include:

  • Ability to read/write OpenDocument (ODF), Microsoft Excel (XLSX), CSV,{{Cite web |title=Importing and Exporting CSV Files |url=https://help.libreoffice.org/Calc/Importing_and_Exporting_CSV_Files |access-date=8 September 2011 |website=LibreOffice Help |publisher=The Document Foundation}} and several other formats.{{Cite web |title=About Import and Export Filters |url=https://help.libreoffice.org/Common/About_Import_and_Export_Filters |access-date=8 September 2011 |website=LibreOffice Help |publisher=The Document Foundation}}{{Cite web |title=The Document Foundation, LibreOffice and OOXML |url=https://wiki.documentfoundation.org/LibreOffice_OOXML |access-date=8 September 2011 |website=The Document Foundation Wiki |publisher=The Document Foundation}}
  • Support for many functions, including those for imaginary numbers, as well as financial and statistical functions.{{Cite web |title=Financial Functions Part One |url=https://help.libreoffice.org/Calc/Financial_Functions_Part_One |access-date=8 September 2011 |website=LibreOffice Help |publisher=The Document Foundation}}{{Cite web |title=Add-in Functions, List of Analysis Functions Part Two |url=https://help.libreoffice.org/Calc/Add-in_Functions,_List_of_Analysis_Functions_Part_Two#IMAGINARY |access-date=8 September 2011 |website=LibreOffice Help |publisher=The Document Foundation}}
  • Supports 1,048,576 rows and 16384 columns in a spreadsheet, making LibreOffice spreadsheets more suitable for heavier scientific or financial spreadsheets. Version 7.0 introduced "very large spreadsheets" which can be enabled as an experimental feature.{{Cite web |title=50916 – Allow more than 1024 columns in calc |url=https://bugs.documentfoundation.org/show_bug.cgi?id=50916 |access-date=2022-05-04 |website=bugs.documentfoundation.org}} Version 7.4 made very large spreadsheets default.{{Cite web |title=LibreOffice 7.4 Community: Release Notes – The Document Foundation Wiki |url=https://wiki.documentfoundation.org/ReleaseNotes/7.4#General_Improvements_2 |access-date=2023-01-28 |website=wiki.documentfoundation.org}}
  • 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, Pivot Table provides similar functionality to the Pivot table found in Microsoft Excel. It is used for interactive table layout and dynamic data analysis.{{Cite web |title=Pivot Table |url=https://help.libreoffice.org/Calc/Pivot_Table |access-date=13 November 2011 |website=LibreOffice Help |publisher=The Document Foundation}}

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.{{Cite web |year=2011 |title=3.3 New Features and Fixes |url=https://www.libreoffice.org/download/3-3-new-features-and-fixes/ |archive-url=https://web.archive.org/web/20140227184750/https://www.libreoffice.org/download/3-3-new-features-and-fixes/ |archive-date=27 February 2014 |access-date=29 July 2011 |website=LibreOffice |publisher=The Document Foundation}}

Supported file formats

class="wikitable" style="text-align:left"

!File format

!Extension

!Read/Write

!Notes

Apple Numbers

|NUMBERS

|{{yes2|From 5.0}}

|

Comma-separated values

|CSV

| {{Yes}}

|

Data Interchange Format

|DIF

| {{Yes}}

|

DBase, Clipper, VP-Info,

FoxPro

|DBF

| {{Yes}}

|

Gnumeric

|GNM, GNUMERIC

|{{partial|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

|{{yes2|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

|{{yes2|Dropped in 4.0 then

added back in 5.3, write

up to 3.6}}

|

SYLK

|SLK

| {{Yes}}

|

See also

References

{{Reflist|30em}}