LibreOffice Calc: Difference between revisions

Revision as of 20:02, 26 September 2022

Revision as of 10:34, 20 November 2022

Line 25:

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>

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|access-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" />

Line 38 ⟶ 36:

* 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]]|access-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]]|access-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]]|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|url=https://help.libreoffice.org/Calc/Financial_Functions_Part_One|title=Financial Functions Part One|website=LibreOffice Help|publisher=[[The Document Foundation]]|access-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]]|access-date=8 September 2011}}</ref>

* Supports 1 million rows and 16384 columns in a spreadsheet, making LibreOffice spreadsheets more suitable for heavier scientific or financial spreadsheets.<ref name="LOFF331" /> 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> However, versionVersion 7.0 introduced "very large spreadsheets" (which includes 16 million rows and 16384 columns) 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>

*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.

In its internal data structure, Calc until version 4.1 relies on cells as the [[base class]] throughout, which has been blamed for "extreme memory use, slow computation, and difficult code". Version 4.2 (released in January 2014) addresses these issues by instead storing the data in [[Array data structure|arrays]] where possible.<ref>{{Cite web|url=https://lwn.net/Articles/571291/|title=A LibreOffice Update|last=Corbet|first=Jonathan|date=23 October 2013|website=[[LWN.net]]}}</ref>

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

Line 99 ⟶ 93:

|

|-

|Microsoft Excel 2007-20162021

|XLSX, XLTX, XLSM,

XLTM