|
|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-01-25
| 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
|
* 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-14
| 3.5<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
|
* 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
|
* 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
|
* 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
|
* 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
|
* 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
|
* 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
|
* 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" />
|-
| 2016-02-10
| 5.1
|
|-
| 2016-08-03
| 5.2
|
|-
| 2017-02-01
| 5.3
|
|-
| 2017-07-28
| 5.3
|
|-
| 2018-01-31
| 6.0
|
* Added ability to export images from a range selection or selected group of shapes.<ref name=":0">{{Cite web|title=LibreOffice 6.0: Release Notes {{!}} Calc|url=https://wiki.documentfoundation.org/ReleaseNotes/6.0#Calc|url-status=live|access-date=2021-12-30|website=The Document Foundation Wiki}}</ref>
* Added pasting unformatted text command.<ref name=":0" />
* Added new command to select unprotected cells on protected or unprotected sheet.<ref name=":0" />
* Fixes for pivot table interop.<ref name=":0" />
* New spreadsheet functions.<ref name=":0" />
|-
| 2018-08-18
| 6.1
|
|-
| 2019-02-07
| 6.2
|
|-
| 2019-08-08
| 6.3
|
|-
| 2020-01-29
| 6.4
|
|-
| 2020-08-05
| 7.0
|
* Performance improvements.<ref name=":1">{{Cite web|title=LibreOffice 7.0: Release Notes {{!}} Calc|url=https://wiki.documentfoundation.org/ReleaseNotes/7.0#Calc|url-status=live|access-date=2021-12-30|website=The Document Foundation Wiki}}</ref>
* New spreadsheet functions.<ref name=":1" />
* Changed spreadsheet functions.<ref name=":1" />
|-
| 2021-02-03
| 7.1
|
|-
| 2021-08-19
| 7.2
|
|-
| 2022-02-03
| 7.3
|
|-
| 2022-08-18
| 7.4
|
|-
| 2023-02-02
| 7.5
|
|-
| 2023-08
| 7.6
|
|}
| 