Content deleted Content added
Mac OS X is now officially called macOS Tags: Mobile edit Mobile app edit Android app edit |
→Features: Fixed typo Tags: Mobile edit Mobile app edit Android app edit |
||
Line 39:
* 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]]|accessdate=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]]|accessdate=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.
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>
| |||