OpenOffice Calc
=ABS(-13)
Specifications
Calc can store a maximum of 65,536 rows with 1024 OOoo columns in each sheet, with a maximum of 256 sheets.[1] There is a way to increase these limits, but it is only suitable for ODF and text-based formats, as there is a risk of data turning unusable for binary formats such as Microsoft Excel's file format.[2] Version 2 of Calc was able to store a maximum of 65,536 rows with 256 columns in each sheet, with a maximum of 256 sheets.[3] Prior to V2.0, the limit on the number of rows was 32,0000.[4]
| Program | Rows (per sheet) | Columns (per sheet) | Total Cells (per sheet) | Sheets |
|---|---|---|---|---|
OpenOffice.org Calc 3+[1][5] |
1,048,576 | 1024 | 1,073,741,824 | 256 |
LibreOffice Calc[6] |
1,048,576 | 16,384 | 1,073,741,824 | 10,000 |
| Microsoft Excel 2007+[7] |
1,048,576 | 16,384 | 17,179,869,184 | Available Memory [8] |
Gnumeric |
16,777,216[9] | 16,384[9] | 274,877,906,944 | Available memory[10] |
KSpread |
32,767 | 32,767 | 1,073,676,289 | ? |
Special abilities
Abilities of Calc include:
- Open source software
- Available on many operating systems, including Microsoft Windows,Mac OS X, Linux, Unix, etc.
- Ability to read/write OpenDocument, Excel .xls, CSV, and several other file formats.
- Able to handle dates on or before 1900 correctly (many spreadsheet applications, including Microsoft Excel, have a year 1900 bug and cannot handle dates before January 1, 1900).
- Support for a large number of functions, including those for imaginary numbers, as well as financial statistical functions.
Missing features
In some cases, Calc lacks a GUI to access certain advanced features that other spreadsheet software have, such as statistical abilities like error bar support on graphs, and polynomial regression analysis, however, many of these calculations can still be performed by manually entering the functions. Another FOSS application called Gnumeric provides easier access to these statistical analysis features by showing them to users with a wizard.
References
- ↑ 1.0 1.1 "What's the maximum number of rows and cells for a spreadsheet file?". OpenOffice.org FAQ. Archived from the original on 2009-05-04. Retrieved 2008-11-04.
- ↑ "Calc/hacks/number of rows - OpenOffice.org Wiki". Retrieved 2008-06-03.
- ↑ Cite error: The named reference
max_cellswas used but no text was provided for refs named (see the help page). - ↑ "What is the maximum number of cells in an OpenOffice.org spreadsheet?". OpenOffice.org FAQ. Retrieved 2008-04-10.
- ↑ "OpenOffice.org 3.0 New Features". OpenOffice.org 3.0 Features. Retrieved 2008-11-10.
- ↑ "Frequently asked questions - Calc". The Document Foundation. Retrieved 2017-07-15.
- ↑ "The "Big Grid" and Increased Limits in Excel 2007". Microsoft.com. Retrieved 2008-04-10.
- ↑ "Excel specifications and limits". Retrieved 2008-07-08.
- ↑ 9.0 9.1 "GNOME Help - Worksheet display". Retrieved 2020-05-15.
- ↑ "Gnumeric Mailing List - Re: Maximum number of sheet, cell, and column". Retrieved 2020-05-15.