LibreOffice Calc: Difference between revisions

Revision as of 23:02, 28 January 2023

Revision as of 23:12, 28 January 2023

Line 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,048,576 rows and 16384 columns in a spreadsheet, making LibreOffice spreadsheets more suitable for heavier scientific or financial spreadsheets.<ref name="LOFF331" /> Version 7.0 introduced "very large spreadsheets" which includes 16 million rows and 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> Version 7.4 made very large spreadsheets 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.