Content deleted Content added
VulcanSphere (talk | contribs) Updating screenshot |
Reverting edit(s) by 72.53.206.5 (talk) to rev. 1299399561 by GoingBatty: Unexplained content removal (UV 0.1.6) |
||
| (37 intermediate revisions by 23 users not shown) | |||
Line 1:
{{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
| logo
| 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">{{
| 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/ |
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/ |
== Features ==
Capabilities of Calc include:
* Ability to read/write [[OpenDocument]] (ODF), Microsoft Excel (
* 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 |
* Supports 1
*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 |access-date=13 November 2011 |website=LibreOffice Help |publisher=[[The Document Foundation]]}}</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/ |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]]}}</ref>
== Supported file formats ==
Line 59 ⟶ 51:
|[[Apple Numbers]]
|NUMBERS
|{{yes2|From 5.0}}
|
|-
|[[Comma-separated values]]
|CSV
| {{Yes}}
|
|-
|[[Data Interchange Format]]
|DIF
| {{Yes}}
|
|-
|[[DBase]], [[Clipper (programming language)|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
|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}}
|
|-
|[[SYmbolic LinK (SYLK)|SYLK]]
|SLK
| {{Yes}}
|
|}
== See also ==
{{Portal|Free and open-source software}}
* [[LibreOffice Writer]]
* [[List of spreadsheet software]]
* [[Comparison of spreadsheet software]]
{{-}}
== References ==
{{Reflist|30em}}
== External links ==
{{
* {{Official website|https://www.libreoffice.org/discover/calc/}}
{{LibreOffice}}
{{Spreadsheets}}
| |||