Wikipedia

LibreOffice Calc: Difference between revisions

Browse history interactively
← Previous edit
Content deleted Content added
VisualWikitext
KuiperDash (talk | contribs)
199 edits
m Added info to the page...
Reverting edit(s) by 72.53.206.5 (talk) to rev. 1299399561 by GoingBatty: Unexplained content removal (UV 0.1.6)
 
(43 intermediate revisions by 26 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 67.15 Calc Icon.svg
| logo size upright = 52px0.3
| screenshot = LibreOffice Calc 67.2.4.1 Calc with csv screenshot.png
| caption = LibreOffice Calc 7.2.4 (released in December 2021, running on [[UbuntuLinux]] and [[KDE Plasma 5]] with the Breeze icon set)
| collapsible =
| 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 release date =
| latest preview date = {{wikidata|qualifier|preferred|references|edit|Q10135|P348|P548=Q51930650|P577}}
| operating system = [[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>
| 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|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]] 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|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/ |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>
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" />
 
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]]}}</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=217 JuneMay 20112023 |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/ |titleurl-status=Newdead |archive-url=https://web.archive.org/web/20191202060646/http://www.generationamiga.com/2017/02/28/new-beta-libreoffice-for-amigaos-4-1/ LibreOffice|archive-date=2 forDecember AmigaOS2019 4.1|access-date=2812 FebruaryDecember 2018 2017|website=GenerationAmiga.com}}</ref>
 
== Features ==
Capabilities of Calc include:
* Ability to read/write [[OpenDocument]] (ODF), Microsoft Excel (XLSXLSX), [[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, LibreOffice2011 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 million,048,576 rows and 16384 columns in a spreadsheet, making LibreOffice spreadsheets more suitable for heavier scientific or financial spreadsheets.<ref name="LOFF331" /> However,Version the7.0 numberintroduced of"very columnslarge isspreadsheets" restrictedwhich tocan atbe mostenabled 1024,as muchan lowerexperimental feature.<ref>{{Cite web |title=50916 – Allow more than Excel's1024 limitcolumns ofin 16384.<ref>[calc |url=https://bugs.freedesktopdocumentfoundation.org/show_bug.cgi?id=50916 Bug|access-date=2022-05-04 50916|website=bugs.documentfoundation.org}}</ref> - AllowVersion more7.4 thanmade 1024very columnslarge inspreadsheets calc]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 ===
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>
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>
===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>
 
== Supported file formats ==
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>
 
== Supported files ==
{| class="wikitable" style="text-align:left"
!File format
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 2007-20162007–2021
|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}}
 
up to 3.6
|
|-
|[[SYmbolic LinK (SYLK)|SYLK]]
|SLK
| {{Yes}}
|
|}
 
==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]]|access-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:'''
{| class="wikitable"
|-
! Year Released
! Version
! Comments
|-
| 2011-06-16
| 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]]|access-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" />
* Documents drawn with the UNO api can be inserted in calc.<ref name="LOFF331" />
* New options for CSV (Comma-Separated Value) importation in Calc, allowing the import of custom delimited files common in engineering scenarios.
* Support for 3 different formula syntaxes: Calc A1, Excel A1 and Excel R1C1.<ref name="LOFF331" />
* 1 million rows in a spreadsheet in Calc, making Calc more suitable for heavier scientific or financial spreadsheets.<ref name="LOFF331" />
|-
| 2011-06-03
| 3.4.0
|
* Re-work of the drawing layer, to improve precision on re-positioning and re-sizing of drawing objects.<ref name="34FF" />
* Support for unlimited number of fields: Previously DataPilot only supported up to 8 column/row/data fields and up to 10 page fields. 3.4 has lifted this restriction to allow unlimited number of fields in each field type.<ref name="34FF" />
* Previously, Calc only supported named ranges in global scope, that is, all named ranges were made available for the entire document regardless of the current sheet. In 3.4 Calc now supports named ranges that are local to a sheet. The named range dialog (Insert->Names->Define) has been modified to reflect this change.<ref name="34FF" />
* Now preserves OLE links to other Excel documents when importing an Excel document. OLE links get converted to external references upon import. *Previously, Calc ignored OLE links and cells containing OLE links resulted in error upon import.<ref name="34FF" />
* Multiple subtotals on a single sheet: It is now possible to define more than one subtotal range in a single sheet via Data->Subtotals. Previously, setting a second subtotal range removed the first one if they were on the same sheet.<ref name="34FF" />
|-
| 2012-02-15
| 3.5.0<ref name="DF14Feb12">{{cite web|url=https://blog.documentfoundation.org/blog/2012/02/14/the-document-foundation-announces-libreoffice-3-5-the-best-free-office-suite-ever/|title=The Document Foundation announces LibreOffice 3.5: "the best free office suite ever"|last=Vignoli|first=Italo|date=14 February 2012|publisher=[[The Document Foundation]]}}</ref>
|
* support for up to 10,000 sheets<ref name="DF14Feb12" />
* a new multi-line input area<ref name="DF14Feb12" />
* new Calc functions conforming to the ODF OpenFormula specifications<ref name="DF14Feb12" />
* better performance when importing files from other office suites<ref name="DF14Feb12" />
* multiple selections in autofilter<ref name="DF14Feb12" />
* unlimited number of rules for conditional formatting<ref name="DF14Feb12" /><ref>{{Cite web|url=https://www.libreoffice.org/download/3-5-new-features-and-fixes/|archive-url=https://web.archive.org/web/20131124100155/https://www.libreoffice.org/download/3-5-new-features-and-fixes/|url-status=dead|archive-date=2013-11-24|title=3.5 New Features and Fixes|publisher=[[The Document Foundation]]}}</ref>
|-
| 2012-08-08
| 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]]|access-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" />
* New spreadsheet functions<ref name="ReleaseNotes36" />
* GUI improvements<ref name="ReleaseNotes36" />
* Remove the limitation to 3 sort entries in calc<ref name="ReleaseNotes36" />
* Improved performance<ref name="ReleaseNotes36" />
|-
| 2013-02-07
| 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]]|access-date=3 November 2013}}</ref>
* Increased size limit on (uncompressed) ODF documents<ref name="ReleaseNotes40" />
* Easier XML import<ref name="ReleaseNotes40" />
* Improved conditional formats<ref name="ReleaseNotes40" />
* initial support for the file format of [[gnumeric]]<ref name="ReleaseNotes40" />
* New spreadsheet functions<ref name="ReleaseNotes40" />
|-
| 2013-07-25
| 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]]|access-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" />
* Import large HTML documents with more than 64k table cells<ref name="ReleaseNotes41" />
* New spreadsheet functions<ref name="ReleaseNotes41" />
* Improved hyphenation<ref name="ReleaseNotes41" />
 
|-
| 2014-01-30
| 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]]|access-date=3 January 2014}}</ref>
*[[Random number generation]] (non-dynamic)<ref name="ReleaseNotes42" />
* Statistics toolkit<ref name="ReleaseNotes42" />
* Other features: Redesign of data structures and Calc core to use OpenCL, threading and dynamic data storage
|-
| 2014-07-30
| 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]]|access-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" />
* User selectable text conversion models.<ref name="ReleaseNotes43" />
* Pivot Table layout improvement.<ref name="ReleaseNotes43" />
* Add 34 new spreadsheet functions.<ref name="ReleaseNotes43" />
* Enable [https://projects.coin-or.org/CoinMP CoinMP] solver for additional options to previously enabled [[Linear programming#Solvers and scripting (programming) languages|LpSolve]].<ref name="ReleaseNotes43" />
* Added three Statistics Wizard options.<ref name="ReleaseNotes43" />
* Additional functionality to random number generator.<ref name="ReleaseNotes43" />
|-
| 2015-01-29
| 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]]|access-date=14 April 2015}}</ref>
* Add direct conversion of formulas to static values.<ref name="ReleaseNotes44" />
* Add one new spreadsheet function.<ref name="ReleaseNotes44" />
* Toolbar improvements<ref name="ReleaseNotes44" />
* Add sheet context menu.<ref name="ReleaseNotes44" />
|-
| 2015-08-05
| 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]]|access-date=6 August 2015}}</ref>
* Added additional conditional formatting options.<ref name="ReleaseNotes50" />
* Improvements to XLSX import and export.<ref name="ReleaseNotes50" />
* Additional engineering notation options<ref name="ReleaseNotes50" />
* Improvements to table structured references.<ref name="ReleaseNotes50" />
* New spreadsheet functions and improvements to function import and export.<ref name="ReleaseNotes50" />
* Added capabilities in references of entire column/row (A:A / 1:1).<ref name="ReleaseNotes50" />
* Added ability to crop, change, and save an image.<ref name="ReleaseNotes50" />
* Toolbar improvements.<ref name="ReleaseNotes50" />
|}
 
== See also ==
{{Portal|Free and open-source software}}
* [[LibreOffice Writer]]
* [[List of spreadsheet software]]
* [[Comparison of spreadsheet software]]
{{-}}
 
== References ==
{{Reflist|30em}}
 
== External links ==
{{commonsCommons category|Screenshots of LibreOffice Calc}}
* {{Official website|https://www.libreoffice.org/discover/calc/}}
 
{{LibreOffice}}
{{Spreadsheets}}
 
Retrieved from "https://en.wikipedia.org/wiki/LibreOffice_Calc"