LibreOffice Calc: Difference between revisions

Revision as of 09:22, 14 September 2024

Latest revision as of 05:16, 18 July 2025

(5 intermediate revisions by 5 users not shown)

Line 6:

| name = LibreOffice Calc

| logo = LibreOffice 7.5 Calc Icon.svg

| logo size 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)

| collapsible =

| developer = [[The Document Foundation]]

| collapsiblever layout = stacked

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

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

| latest release date =

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

| operating system = [[Linux]], [[macOS]], [[Windows]]<ref name="SystemReq">{{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.}}</ref> and [[FreeBSD]]<ref name="FreeBSD">[http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/desktop-productivity.html FreeBSD Handbook, 7.3.5 LibreOffice]</ref> and via ecosystem partners: [[Android_(operating_system)|Android]], [[iOS]], [[iPadOS]], [[ChromeOS]] and [[Online]].

| operating system = [[Cross platform]]

| genre = [[Spreadsheet]]

| license = [[Mozilla Public License|MPLv2.0]] (secondary license [[GNU General Public License|GPL]], [[GNU Lesser General Public License|LGPLv3+]] or [[Apache License 2.0]])<ref name="About">{{citeCite web |title=Licenses |url=https://www.libreoffice.org/download/license/ |access-date=16 December 2015 |publisher=[[The Document Foundation]]}}</ref>

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

| title = Licenses

| url = https://www.libreoffice.org/download/license/

| publisher = [[The Document Foundation]]

| access-date = 16 December 2015}}

</ref>

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

}}

'''LibreOffice Calc''' is the [[spreadsheet]] component of the [[LibreOffice]] software package.<ref name="CalcHome">{{Cite web|url=https://www.libreoffice.org/discover/calc/|title=Calc, the LibreOffice spreadsheet program|publisher=[[The Document Foundation]]|access-date=8 September 2011}}</ref><ref>{{cite book | first1=Richard | last1=Petersen | year=2011 | page=170 | title=Ubuntu 11. 04 Desktop Handbook | publisher=Surfing Turtle Press | isbn=978-1-936280-28-5 | url=https://books.google.com/books?id=CS7txn0x8OEC&pg=PA170 }}</ref>

'''LibreOffice Calc''' is the [[spreadsheet]] component of the [[LibreOffice]] software packagesuite.<ref name="CalcHome">{{Cite web |title=Calc, the LibreOffice spreadsheet program |url=https://www.libreoffice.org/discover/calc/ |titleaccess-date=Calc,8 theSeptember LibreOffice2011 spreadsheet program|publisher=[[The Document Foundation]]|access-date=8 September 2011}}</ref><ref>{{citeCite book | first1=Richard | last1last=Petersen | yearfirst=2011Richard | pageurl=170https://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 | urlpage=https://books.google.com/books?id=CS7txn0x8OEC&pg=PA170 170}}</ref>

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 [[Cache (computing)|data caching]] performance, especially when referencing large data ranges.<ref name="34FF">{{Cite web|url=https://www.libreoffice.org/download/3-4-new-features-and-fixes/|title=3.4 New Features and Fixes|publisher=[[The Document Foundation]]|archive-url=https://web.archive.org/web/20131214213702/https://www.libreoffice.org/download/3-4-new-features-and-fixes/|archive-date=14 December 2013|url-status=|access-date=8 September 2011}}</ref>

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 [[Cache (computing)|data caching]] performance, especially when referencing large data ranges.<ref name="34FF">{{Cite web |title=3.4 New Features and Fixes |url=https://www.libreoffice.org/download/3-4-new-features-and-fixes/|title=3.4 New Features and Fixes|publisher=[[The Document Foundation]]|archive-url=https://web.archive.org/web/20131214213702/https://www.libreoffice.org/download/3-4-new-features-and-fixes/ |archive-date=14 December 2013|url-status= |access-date=8 September 2011 |publisher=[[The Document Foundation]]}}</ref>

Calc is capable of opening and saving most spreadsheets in [[Microsoft Excel file format]].<ref name="CalcHome" /> Calc is also capable of saving spreadsheets as [[PDF]] files.<ref name="CalcHome" />

As with the entire LibreOffice suite, Calc is available for a variety of platforms, including [[Linux]], [[macOS]], [[Microsoft Windows]],<ref name="SystemReq">{{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.}}</ref> and [[FreeBSD]].<ref name="FreeBSD">[http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/desktop-productivity.html FreeBSD Handbook, 7.3.5 LibreOffice]</ref> Available under the [[Mozilla Public License]], Calc is [[free and open-source software]].<ref name="Lic">{{Cite web |title=Licenses |url=https://www.libreoffice.org/download/license/ |titleaccess-date=Licenses21 June 2011 |publisher=[[The Document Foundation]]|access-date=21 June 2011}}</ref> There are community builds for many other platforms. Ecosystem partner [[Collabora]] uses LibreOffice upstream code and provides apps for [[Android (operating system)|Android]], [[iOS]], [[iPadOS]] and [[ChromeOS]].<ref>{{citeCite web |urltitle=Collabora Office |url=https://play.google.com/store/apps/details?id=com.collabora.libreoffice|title= Collabora Office|accessurl-datestatus=live 7 May 2023|work= [[Google Play]]|archive-url= https://archive.today/20221231145049/https://play.google.com/store/apps/details?id=com.collabora.libreoffice |archive-date= 31 December 2022 |urlaccess-statusdate=7 liveMay 2023 |website=[[Google Play]]}}</ref><ref>{{citeCite web |urlyear=2023 |title=Collabora Office |url=https://apps.apple.com/us/app/collabora-office/id1440482071|title= Collabora Office|accessurl-datestatus=live 7 May 2023|work= [[Apple App Store]]|year= 2023|archive-url= https://archive.today/20201005085449/https://apps.apple.com/us/app/collabora-office/id1440482071 |archive-date= 5 October 2020 |urlaccess-statusdate=7 liveMay 2023 |website=[[Apple App Store]]}}</ref> LibreOffice Online is an online office suite which includes the applications [[LibreOffice Writer|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.<ref>{{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/|title=New beta LibreOffice for AmigaOS 4.1|date=28 February 2017|website=GenerationAmiga.com|accessurl-datestatus=12dead December 2018|archive-date=2 December 2019|archive-url=https://web.archive.org/web/20191202060646/http://www.generationamiga.com/2017/02/28/new-beta-libreoffice-for-amigaos-4-1/ |urlarchive-statusdate=dead2 December 2019 |access-date=12 December 2018 |website=GenerationAmiga.com}}</ref>

== Features ==

Capabilities of Calc include:

* Ability to read/write [[OpenDocument]] (ODF), Microsoft Excel (XLSX), [[Comma-separated values|CSV]],<ref name="CSV">{{Cite web |title=Importing and Exporting CSV Files |url=https://help.libreoffice.org/Calc/Importing_and_Exporting_CSV_Files |titleaccess-date=Importing8 andSeptember Exporting2011 CSV Files|website=LibreOffice Help |publisher=[[The Document Foundation]]|access-date=8 September 2011}}</ref> and several other formats.<ref name="OtherFormats">{{Cite web |title=About Import and Export Filters |url=https://help.libreoffice.org/Common/About_Import_and_Export_Filters |titleaccess-date=About8 ImportSeptember and2011 Export Filters|website=LibreOffice Help |publisher=[[The Document Foundation]]|access-date=8 September 2011}}</ref><ref name="OOXML">{{Cite web |title=The Document Foundation, LibreOffice and OOXML |url=https://wiki.documentfoundation.org/LibreOffice_OOXML |titleaccess-date=The8 DocumentSeptember Foundation,2011 LibreOffice and OOXML|website=The Document Foundation Wiki |publisher=[[The Document Foundation]]|access-date=8 September 2011}}</ref>

* Support for many functions, including those for [[imaginary number]]s, as well as financial and statistical functions.<ref name="Financial">{{Cite web |title=Financial Functions Part One |url=https://help.libreoffice.org/Calc/Financial_Functions_Part_One |titleaccess-date=Financial8 FunctionsSeptember Part2011 One|website=LibreOffice Help |publisher=[[The Document Foundation]]|access-date=8 September 2011}}</ref><ref name="Imaginary">{{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 |titleaccess-date=Add-in8 Functions,September List2011 of Analysis Functions Part Two|website=LibreOffice Help |publisher=[[The Document Foundation]]|access-date=8 September 2011}}</ref>

* Supports 1,048,576 rows and 16384 columns in a spreadsheet, making LibreOffice spreadsheets more suitable for heavier scientific or financial spreadsheets.<ref name="LOFF331" /> Version 7.0 introduced "very large spreadsheets" which can be enabled as an experimental feature.<ref>{{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}}</ref> Version 7.4 made very large spreadsheets default.<ref>{{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}}</ref>

*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,<ref name="34FF" /> Pivot Table provides similar functionality to the [[Pivot table]] found in [[Microsoft Excel]]. It is used for interactive table layout and dynamic data analysis.<ref name="PivotTable">{{Cite web |title=Pivot Table |url=https://help.libreoffice.org/Calc/Pivot_Table |titleaccess-date=Pivot13 November 2011 Table|website=LibreOffice Help |publisher=[[The Document Foundation]]|access-date=13 November 2011}}</ref>

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

== Supported file formats ==

Line 67 ⟶ 64:

|

|-

|[[DBase]], [[Clipper (programming language)|Clipper]], [[VP-Info]],

[[FoxPro]]

|DBF

Line 94 ⟶ 91:

|

|-

|Microsoft Excel 2007-20212007–2021

|XLSX, XLTX, XLSM,

XLTM

Line 146 ⟶ 143:

|}

== See also ==

{{Portal|Free and open-source software}}

* [[LibreOffice Writer]]

Line 153 ⟶ 150:

{{-}}

== References ==

{{Reflist|30em}}

== External links ==

{{commonsCommons category|Screenshots of LibreOffice Calc}}

* {{Official website|https://www.libreoffice.org/discover/calc/}}