LibreOffice Calc: Difference between revisions

Revision as of 17:20, 28 December 2020

Revision as of 04:35, 7 February 2021

Line 13:

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

| latest release date =

| operating system = [[Linux]], [[macOS]], [[Microsoft Windows]]<ref name="SystemReq">{{Cite web|url = https://www.libreoffice.org/get-help/system-requirements/|title = System Requirements|accessdateaccess-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>

| 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

Line 19:

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

| publisher = [[The Document Foundation]]

| accessdateaccess-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]]|accessdateaccess-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>

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=|accessdateaccess-date=8 September 2011}}</ref>

Additionally, Calc now supports 1 million rows in a spreadsheet<ref name="PaulFeb11">{{Cite web|url=https://arstechnica.com/information-technology/2011/01/the-document-foundation-announces-first-release-of-libreoffice/|title=First release of LibreOffice arrives with improvements over OOo|last=Paul|first=Ryan|date=25 January 2011|work=[[Ars Technica]]|archive-url=https://web.archive.org/web/20181127022527/https://arstechnica.com/information-technology/2011/01/the-document-foundation-announces-first-release-of-libreoffice/|archive-date=27 November 2018|url-status=live|accessdateaccess-date=8 September 2011}}</ref> with macro references to each [[Cell (spreadsheet)|cell]].

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"/> and [[FreeBSD]].<ref name="FreeBSD"/> Available under the [[Mozilla Public License]], Calc is [[free and open-source software]].<ref name="Lic">{{Cite web|url=https://www.libreoffice.org/download/license/|title=Licenses|publisher=[[The Document Foundation]]|accessdateaccess-date=21 June 2011}}</ref>

There is now a closed beta of LibreOffice on [[AmigaOS]] 4.1.<ref>{{Cite web|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}}</ref>

Line 36:

==Features==

Capabilities of Calc include:

* Ability to read/write [[OpenDocument]] (ODF), Excel (XLS), [[Comma-separated values|CSV]],<ref name="CSV">{{Cite web|url=https://help.libreoffice.org/Calc/Importing_and_Exporting_CSV_Files|title=Importing and Exporting CSV Files|website=LibreOffice Help|publisher=[[The Document Foundation]]|accessdateaccess-date=8 September 2011}}</ref> and several other formats.<ref name="OtherFormats">{{Cite web|url=https://help.libreoffice.org/Common/About_Import_and_Export_Filters|title=About Import and Export Filters|website=LibreOffice Help|publisher=[[The Document Foundation]]|accessdateaccess-date=8 September 2011}}</ref><ref name="OOXML">{{Cite web|url=https://wiki.documentfoundation.org/LibreOffice_OOXML|title=The Document Foundation, LibreOffice and OOXML|website=The Document Foundation Wiki|publisher=[[The Document Foundation]]|accessdateaccess-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|url=https://help.libreoffice.org/Calc/Financial_Functions_Part_One|title=Financial Functions Part One|website=LibreOffice Help|publisher=[[The Document Foundation]]|accessdateaccess-date=8 September 2011}}</ref><ref name="Imaginary">{{Cite web|url=https://help.libreoffice.org/Calc/Add-in_Functions,_List_of_Analysis_Functions_Part_Two#IMAGINARY|title=Add-in Functions, List of Analysis Functions Part Two|website=LibreOffice Help|publisher=[[The Document Foundation]]|accessdateaccess-date=8 September 2011}}</ref>

* Supports 1 million rows in a spreadsheet, making LibreOffice spreadsheets more suitable for heavier scientific or financial spreadsheets.<ref name="LOFF331" /> However, the number of columns is restricted to at most 1024, much lower than Excel's limit of 16384.<ref>[https://bugs.freedesktop.org/show_bug.cgi?id=50916 Bug 50916 - Allow more than 1024 columns in calc]</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.

Line 44:

===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|url=https://help.libreoffice.org/Calc/Pivot_Table|title=Pivot Table|website=LibreOffice Help|publisher=[[The Document Foundation]]|accessdateaccess-date=13 November 2011}}</ref>

Pivot table has support for an unlimited number of fields. Previously Pivot Table only supported up to 8 column/row/data fields and up to 10 page fields.<ref name="34FF" />

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|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=|accessdateaccess-date=29 July 2011}}</ref>

==Release history==

Calc has continued to diverge since the fork from its parent OpenOffice with new features being added and code cleanups taking place.<ref name="Noyes03Jun11">{{Cite web|url=https://www.pcworld.com/article/229353/despite_oracles_antics_libreoffice_gets_a_big_update.html|title=Despite Oracle's Antics, LibreOffice Gets a Big Update|last=Noyes|first=Katherine|date=3 June 2011|work=[[PC World (magazine)|PC World]]|accessdateaccess-date=8 September 2011}}</ref>

[[File:Libreoffice Calc in Linux.png|thumb|Screenshot of Libre Office Calc in Linux ([[Ubuntu]])]]

'''Versions for LibreOffice Calc include the following:'''

Line 63:

| 3.3.3

|

* More-familiar default key bindings.<ref name="McAllister16Feb11">{{Cite web|url=http://www.infoworld.com/print/151716/|title=Open office dilemma: OpenOffice.org vs. LibreOffice|last=McAllister|first=Neil|date=16 February 2011|work=[[InfoWorld]]|accessdateaccess-date=8 September 2011|archive-url=https://archive.today/20131001035953/http://www.infoworld.com/print/151716|archive-date=1 October 2013|url-status=live}}</ref>

* Toolbar icon for toggling sheet grids in Calc similar to Excel.<ref name="LOFF331" />

* Improved Excel interoperability.<ref name="LOFF331" />

Line 93:

| 3.6.0

|

* Improved OOXML and ODF1.2 support<ref name="ReleaseNotes36">{{Cite web|url=https://wiki.documentfoundation.org/ReleaseNotes/3.6|title=LibreOffice 3.6: Release Notes|website=The Document Foundation Wiki|publisher=[[The Document Foundation]]|accessdateaccess-date=3 November 2013}}</ref>

* Improved CSV file import<ref name="ReleaseNotes36" />

* Added a "Save cell formulas instead of calculated values" option to CSV export<ref name="ReleaseNotes36" />

Line 104:

| 4.0.0

|

* Improved performance<ref name="ReleaseNotes40">{{Cite web|url=https://wiki.documentfoundation.org/ReleaseNotes/4.0|title=LibreOffice 4.0: Release Notes|website=The Document Foundation Wiki|publisher=[[The Document Foundation]]|accessdateaccess-date=3 November 2013}}</ref>

* Increased size limit on (uncompressed) ODF documents<ref name="ReleaseNotes40" />

* Easier XML import<ref name="ReleaseNotes40" />

Line 114:

| 4.1.0

|

* Embedding fonts in a Calc spreadsheet<ref name="ReleaseNotes41">{{Cite web|url=https://wiki.documentfoundation.org/ReleaseNotes/4.1|title=LibreOffice 4.1: Release Notes|website=The Document Foundation Wiki|publisher=[[The Document Foundation]]|accessdateaccess-date=3 November 2013}}</ref>

* Add a Stepped Lines line type to Line and XY (Scatter) graphs<ref name="ReleaseNotes41" />

* Count the number of selected cells<ref name="ReleaseNotes41" />

Line 125:

| 4.2.0

|

* New spreadsheet functions<ref name="ReleaseNotes42">{{Cite web|url=https://wiki.documentfoundation.org/ReleaseNotes/4.2|title=LibreOffice 4.2: Release Notes|website=The Document Foundation Wiki|publisher=[[The Document Foundation]]|accessdateaccess-date=3 January 2014}}</ref>

*[[Random number generation]] (non-dynamic)<ref name="ReleaseNotes42" />

* Statistics toolkit<ref name="ReleaseNotes42" />

Line 133:

| 4.3.0

|

* Smarter highlighting of cell in formula<ref name="ReleaseNotes43">{{Cite web|url=https://wiki.documentfoundation.org/ReleaseNotes/4.3#Calc|title=LibreOffice 4.3: Release Notes {{!}} Calc|website=The Document Foundation Wiki|publisher=[[The Document Foundation]]|accessdateaccess-date=14 April 2015}}</ref>

* Number of selected rows and columns shown in the status bar<ref name="ReleaseNotes43" />

* Allow starting of cell edit with the content of the cell above it as its initial content.<ref name="ReleaseNotes43" />

Line 146:

| 4.4.0

|

* Added three Statistics Wizard options.<ref name="ReleaseNotes44">{{Cite web|url=https://wiki.documentfoundation.org/ReleaseNotes/4.4#Calc|title=LibreOffice 4.4: Release Notes {{!}} Calc|website=The Document Foundation Wiki|publisher=[[The Document Foundation]]|accessdateaccess-date=14 April 2015}}</ref>

* Add direct conversion of formulas to static values.<ref name="ReleaseNotes44" />

* Add one new spreadsheet function.<ref name="ReleaseNotes44" />

Line 155:

| 5.0.0

|

* Added optional ability to repeat pivot table item labels.<ref name="ReleaseNotes50">{{Cite web|url=https://wiki.documentfoundation.org/ReleaseNotes/5.0#Calc|title=LibreOffice 5.0: Release Notes {{!}} Calc|website=The Document Foundation Wiki|publisher=[[The Document Foundation]]|accessdateaccess-date=6 August 2015}}</ref>

* Added additional conditional formatting options.<ref name="ReleaseNotes50" />

* Improvements to XLSX import and export.<ref name="ReleaseNotes50" />