LibreOffice Calc: Difference between revisions

Revision as of 05:08, 8 July 2025

Revision as of 05:10, 18 July 2025

Line 2:

{{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 = [[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">{{Cite web |title=Licenses |url=https://www.libreoffice.org/download/license/ |access-date=16 December 2015 |publisher=[[The Document Foundation]]}}</ref>

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

}}

'''LibreOffice Calc''' is the [[spreadsheet]] component of the [[LibreOffice]] suite.<ref name="CalcHome">{{Cite web |title=Calc, the LibreOffice spreadsheet program |url=https://www.libreoffice.org/discover/calc/ |access-date=8 September 2011 |publisher=[[The Document Foundation]]}}</ref><ref>{{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}}</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/ |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]]}}</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/ |access-date=21 June 2011 |publisher=[[The Document Foundation]]}}</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>{{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]]}}</ref><ref>{{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]]}}</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/ |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}}</ref>

== Features ==