Comparison of spreadsheet software
This article mayrequirecleanupto meet Wikipedia'squality standards.The specific problem is:wikidata references are not displaying properly.(August 2023) |
Spreadsheetis a class ofapplication softwaredesign to analyze tabular data called "worksheets". A collection of worksheets is called a "workbook".Online spreadsheetsdo not depend on a particular operating system but require a standards-compliantweb browserinstead. One of the incentives for the creation of online spreadsheets was offering worksheet sharing and public sharing or workbooks as part of their features which enables collaboration between multiple users. Some on-line spreadsheets provide remote data update, allowing data values to be extracted from other users' spreadsheets even though they may be inactive at the time.
General
[edit]Name | Developer | Initial release | Platform | Latest release | License | |
---|---|---|---|---|---|---|
Version | Date | |||||
Apache OpenOffice Calc | Apache Software Foundation | 2012-05-08 | GNU/Linux | 4.1.15[1] | 2023-12-22 | Apache-2.0 |
macOS | ||||||
Windows | ||||||
AppleWorks | Apple Inc. | 1991 | macOS | 6.2.9[2] | 2004-01-14 | Proprietary |
Windows | 6.2.2[3] | 2004-01-20 | ||||
Calligra Sheets | KOfficeKSpread Team | BSD | 3.2.1[4] | 2020-05-14 | LGPL | |
GNU/Linux | ||||||
macOS | ||||||
Windows | ||||||
Collabora Online Calc | Collabora | 2019[a] | Android | 23.05[5] | 2023-09-21 | MPL-2.0 |
2021[b] | BSD | Build your own | Build your own | |||
2019[a] | ChromeOS | 23.05[5] | 2023-09-21 | |||
2019[a] | iOS | 23.05[6] | 2024-01-29 | |||
2019[a] | iPadOS | 23.05[6] | 2024-01-29 | |||
2016[c] | Linux | Online server: 24.04.4.4[7] | 2024-07-08 | |||
2015[d] | Desktop app: 24.04[8] | 2024-05-30 | ||||
2015[d] | macOS | 24.04[8] | 2024-05-30 | |||
2015[d] | Windows | 24.04[8] | 2024-05-30 | |||
Google Sheets | 2006[e] | Android[f] | Rolling | Rolling | Proprietary | |
ChromeOS[g] | ||||||
iOS[f] | ||||||
Linux[g] | ||||||
macOS[f] | ||||||
Windows[f]} | ||||||
GNU Oleo | Tom Lord | 1992 | GNU/Linux | 1.6.16[9] | 1999-03-10 | GPL-3.0-or-later |
Gnumeric | GNOMEcommunity | 1998[h] | BSD | 1.12.57[10] | 2024-02-12 | GPL-2.0-only or GPL-3.0-only |
GNU/Linux | ||||||
macOS | ||||||
Windows[i] | ||||||
Gobe Productive | Gobe Software | 1998-08 | BeOS | 2.0.1[11] | 2000-02-29 | Proprietary |
2001-12-12[12] | Windows | 3.04[13] | 2003-07-08 | |||
IBM Lotus Symphony | IBM | 2008 | GNU/Linux | 3.0.1 FP2[14][15] | 2012-11-29 | Proprietary |
macOS | ||||||
Windows | ||||||
LibreOffice Calc | The Document Foundation | 2011-01-25[j] | BSD | 24.2[16] | 2024-01-31 | MPL-2.0 |
GNU/Linux | ||||||
macOS | ||||||
Unix | ||||||
Windows | ||||||
Mariner Calc | Mariner Software | 1989[k] | iOS? | 5.6.0 | Dropped | Proprietary |
Microsoft Excel[l] | Microsoft | 2015-06-25 | Android | 16.0.15128.20206 | 2022-09-30 | Proprietary |
2017-11[17] | ChromeOS | ? | Dropped 2021-09-18[18] | |||
2013-06[19] | iOS | 2.66 | 2022-10-10 | |||
2014-02[20] | iPadOS | ? | ? | |||
1985 | macOS | 16.65 | 2022-09-13 | |||
1989 | OS/2 | 3.0 | Dropped | |||
1987 | Windows | 2209 | 2022-09-26 | |||
Microsoft Works | Microsoft | 1987-09-14 | DOS | 3.0b | 1993 | Proprietary |
1988 | macOS | 4.0b | 1994 | |||
1991 | Windows | 9[21] | 2007-09-28 | |||
Numbers | Apple, Inc. | 2010-01-27 | iOS | 12.1 | 2022-06-21 | Proprietary |
2007-08-07 | macOS | 12.1 | 2022-06-21 | |||
OnlyOffice | Ascensio System SIA | 2014[m] | GNU/Linux | 8.1.0[22] | 2024-06-20 | AGPL-3.0-only |
macOS | ||||||
Windows | ||||||
OpenOffice.org Calc | Sun Microsystems[n] Oracle Corporation[o] |
2002-05 | BSD | 3.3.0[23] | 2011-01-17 | Apache-2.0 |
GNU/Linux | ||||||
macOS | ||||||
Solaris/Illumos | ||||||
Unix | ||||||
Windows | ||||||
PlanMaker | SoftMaker Software GmbH | 1994[24][25] | Android | 2024 | 2023-06-20 | Proprietary |
GNU/Linux | ||||||
macOS | ||||||
Windows | ||||||
Pyspread | Martin Manns | 2008[p] | BSD | 2.2.3[26] | 2023-12-22 | GPL-3.0-or-later |
GNU/Linux | ||||||
Unix | ||||||
Windows | ||||||
Quattro Pro | Corel | 1988[k] | Windows | 2020 | 2020 | Proprietary |
Resolver One | Resolver Systems | 2008-01-16[q] | Windows | 1.9 | 2010-06-04 | Proprietary |
sc | James Gosling et al | 1981 | 7.16[27] | 2002-09-20 | Public domain | |
Siag | Ulric Eriksson | [r] | BSD | 3.6.1[28] | 2006-11-10 | GPL-2.0-or-later |
GNU/Linux | ||||||
Unix | ||||||
Windows | ||||||
StarOffice StarCalc | Sun Microsystems | 1994 | GNU/Linux | 9.0U3[29][30][31] | 2009-09-09 | Proprietary |
macOS | ||||||
Windows | ||||||
WPS Office | Kingsoft | 2012-03-23 | Android | 16.3.7 | 2022-07-22 | Proprietary |
1988 | DOS | Dropped | ||||
2014 | GNU/Linux | 11.1.0.11664 | 2022-06-08 | |||
2014 | iOS | 11.24.1 | 2022-07-14 | |||
2019 | macOS | 4.2.1 | 2022-07-15 | |||
1995? | Windows | 11.2.0.11191 | 2022-07-05 | |||
Name | Developer | Initial release | Platform | Latest release | License | |
Version | Date |
Operating system support
[edit]Theoperating systemsthe software can run on natively (withoutemulation). Android and iOS apps can be optimized forChromebooksandiPadswhich run the operating systemsChromeOSandiPadOSrespectively, the operating optimizations include things like multitasking capabilities, large and multi-display support, better keyboard and mouse support.
Name | Windows | macOS | GNU/Linux | BSD | Unix | Android | ChromeOSoptimized | iOS | iPadOSoptimized |
---|---|---|---|---|---|---|---|---|---|
Apache OpenOffice Calc | Yes | Yes | Yes | No | No | No | No | No | No |
Calligra Sheets | Yes | Yes | Yes | Yes | No | No | No | No | No |
Collabora Online Calc | Yes | Yes | Yes | Yes | Yes | Yes | Yes[32] | Yes | Yes |
Google Sheets | Yes | Yes | Yes | No | No | Yes | Yes | Yes | Yes |
Gnumeric | Old versions | No | Yes | Yes | Yes | No | No | No | No |
IBM Lotus Symphony | Yes | Yes | Yes | No | No | No | No | No | No |
LibreOffice Calc | Yes | Yes | Yes | Yes | Yes | No | No | No | No |
Mariner Calc | No | Unsupported | No | No | No | No | No | Yes | No |
Microsoft Excel | Yes | Yes | No | No | No | Yes | Dropped 2021-09-18[33] | Yes | Yes |
Numbers | No | Yes | No | No | No | No | No | Yes | Yes |
PlanMaker | Yes | Yes | Yes | No | No | Yes | ? | No | No |
Pyspread | Yes | Unsupported | Yes | Yes | Yes | No | No | No | No |
Quattro Pro | Yes | No | No | No | No | No | No | No | No |
Resolver One | Yes | No | No | No | No | ? | ? | ? | ? |
Siag | No | Yes | Yes | Yes | Yes | No | No | No | No |
WPS Office | Yes | Yes | Yes | No | No | Yes | ? | Yes | ? |
Supported file formats
[edit]This table gives a comparison of whatfile formatseach spreadsheet can import and export. "Yes" means can both import and export.
Name | CSV | Excel (xls) |
HTML | LaTeX | ODF (ods) |
OOXML (xlsx) |
DIF | OpenOffice.org XML (sxc) | |
---|---|---|---|---|---|---|---|---|---|
Apache OpenOffice Calc | Yes | Yes | Yes | Export[34] | Yes | Import | Export | Yes | Yes |
Calligra Sheets | Yes | Import | Export | Export | Yes | No | Export | ? | Yes |
Collabora Online Calc - online and mobile | Yes | Yes | No | No | Yes | Yes | Export | No | No |
Collabora Online Calc - desktop | Yes | Yes | Yes | Export[35][36] | Yes | Yes | Export | Yes | Yes |
Google Sheets | Import | Import | No | No | Yes | Yes | Export | No | No |
Gnumeric | Yes | Yes | Yes | Export | Yes | Yes | Export | Import | Import |
IBM Lotus Symphony | Yes | Yes | Export | No | Yes | Import | Export | Yes | |
LibreOffice Calc | Yes | Yes | Yes | Export[37][38] | Yes | Yes | Export | Yes | Yes |
Mariner Calc | Yes | Yes | No | No | No | No | Export | No | |
Microsoft Excel | Yes | Yes | Partial | No | Yes | Yes | Export | Yes | No |
WPS Office | Yes | Yes | Partial | No | Yes | Yes | Export | Import | No |
Numbers | Yes | Yes | No | No | Import | Import | Export | No | |
Quattro Pro | Yes | Yes | Yes | No | No | Yes | Export | No | |
PlanMaker | Yes | Yes | Export | No | No | Yes | Export | No | |
Pyspread | Yes | Yes | No | No | Import | Import | Export | No | |
Resolver One | Yes | Yes | No | No | No | No | No | No | |
Siag | Yes | Import partial | Yes | Export | No | No | Export | Import partial |
Rows and Columns
[edit]Program | Rows(per sheet) | Columns(per sheet) | Total cells(per sheet) | Sheets | Total cells(per workbook) |
---|---|---|---|---|---|
Collabora Online22.05, or later versions – Online, Desktop, Tablet, Mobile | 1,048,576[39] | 16,384 | 17,179,869,184[40] | 1,024 | 17,592,186,044,400 |
Gnumeric | 16,777,216 | 16,384 | 274,877,906,944 | 142,648 | 603,103 |
Google Sheets | 1,048,576 | 18,278 | 10,000,000 | 200 | 10,000,000 |
KSpread | 32,767 | 32,767 | 1,073,676,289 | 130,645 | 953,923 |
LibreOffice Calc5.4.5 – 7.3 | 1,048,576 | 1,024 | 1,073,741,824 | 1,024 | 1,099,511,627,776 |
LibreOffice Calc7.4, or later versions | 1,048,576[41] | 16,384 | 17,179,869,184[42] | 1,024 | 17,592,186,044,400 |
Lotus 1-2-3[43] | 65,536 | 256 | 16,777,216 | 256 | 4,294,967,296 |
Microsoft Excel2003 | 65,536 | 256 | 16,777,216 | 65,531 | 1,099,427,741,696 |
Microsoft Excel2007, or later versions[44][45][46] | 1,048,576 | 16,384 | 17,179,869,184 | Limited by available memory | Limited by available memory |
OpenOffice.org Calc2[47] | 65,536 | 256 | 16,777,216 | 256 | 4,294,967,296 |
OpenOffice.org Calc3.0, 3.1 and 3.2[48][49] | 65,536 | 1024 | 67,108,864 | 256 | 17,179,869,184 |
OpenOffice.org Calc3.3[50] | 1,048,576 | 1024 | 1,073,741,824 | 256 | 274,877,906,944 |
Pyspread | ~80 000 000 (limited by sum of row heights) | ~30 000 000 (limited by sum of column widths) | Limited by available memory | Limited by available memory | Limited by available memory |
Resolver One | limited by machine memory* | limited by machine memory* | limited machine memory* | limited by machine memory* | limited by machine memory* |
-*32-bitaddressable memory on Microsoft Windows, i.e. ~2.5 GB.
See also
[edit]Notes
[edit]- ^abcdThe app uses LibreOffice kit technology and is based on Collabora Online for which development started in 2013.
- ^Version 21.11. Using LibreOffice kit technology, development started in 2013.
- ^Version 1.0. Using LibreOffice kit technology, development started in 2013.
- ^abcVersion 4.4.
- ^Development started 2006.
- ^abcdOffline editing when used with Chrome or Edge web browser.
- ^abOffline editing when used with Chrome web browser.
- ^Development started 1998.
- ^Old versions.
- ^Version 3.3. Development started 2010.
- ^abDevelopment started 1988.
- ^Started asMultiplanin 1982.
- ^Development started 2009.
- ^1999 – 2009.
- ^2010 – 2011
- ^Development started 2008.
- ^Development started 2005.
- ^Development started 1996.
References
[edit]- ^"Announcing Apache OpenOffice 4.1.15".22 December 2023.Retrieved25 February2024.
- ^"AppleWorks 6.2.9 for Mac".14 January 2004.
- ^"AppleWorks 6.2.2 for Windows".20 January 2004.
- ^"Calligra 3.2.1".
- ^ab"Collabora Office for Android and iOS 23.05 – Release Notes".
- ^ab"App Store Preview for Collabora Office".
- ^"Collabora Online 24.04 Release Notes".
- ^abc"Collabora Office 24.04 Release Notes".
- ^"ChangeLog".22 November 2000. Archived fromthe originalon 8 January 2001.
- ^"Gnumeric 1.12.57 aka" TBD "is now available".12 February 2024.Retrieved15 February2024.
- ^"Productive BeOS".Archived fromthe originalon 2001-12-23.
- ^"Windows Release".Archived fromthe originalon 2002-02-04.
- ^"Gobe Corporation".Archived fromthe originalon 2003-10-04.
- ^"IBM Lotus Symphony - Buzz: Symphony 3.0.1 FIXPACK 2 is Now AVAILABLE".29 November 2012. Archived fromthe originalon 29 January 2013.
- ^"IBM Lotus Symphony - Release Notes".Archived fromthe originalon 26 April 2011.
- ^https://wiki.documentfoundation.org/ReleaseNotes/24.2.
{{cite web}}
:Missing or empty|title=
(help) - ^"Microsoft Office finally available for all Chromebooks".2017-11-27.Retrieved2022-12-01.
...Without any fanfare, Microsoft finally made Word, Excel, Outlook, and PowerPoint available for (apparently) all Chromebooks.
- ^"Office apps for Chromebook to be stopped".2021-08-31.Retrieved2022-12-01.
...it's too expensive to support Office apps on the larger screen Chromebook devices which are rivalling Windows in some markets.
- ^"Microsoft launches Office iOS app but no iPad version yet".2013-06-15.Retrieved2022-12-01.
...Requires active Office 365 subscription to edit Word, Excel and PowerPoint files, but no iPad version for now.
- ^"Microsoft announces Office for iPad, extending productivity to all iOS devices".2014-02-27.Retrieved2022-12-01.
...Office 365 subscription is needed to edit as well as create documents.
- ^"Microsoft Works - Microsoft Lifecycle".Archived fromthe originalon 23 January 2022.
- ^"Release 8.1.0".20 June 2024.Retrieved22 June2024.
- ^"3.3.0 - Release Notes".
- ^"Infos zu PlanMaker 97".1997-06-03. Archived fromthe originalon 1997-06-03.Retrieved2010-03-28.
- ^Andy Updegrove (2006-07-05)."The Emerging ODF Environment, Part IV: Spotlight on SoftMaker Office 2006".Retrieved2010-03-28.
- ^https://pypi.org/project/pyspread/.
{{cite web}}
:Missing or empty|title=
(help) - ^http:// ibiblio.org/pub/Linux/apps/financial/spreadsheet/!INDEX.html.
{{cite web}}
:Missing or empty|title=
(help) - ^"Siag Office 3.6.1".10 November 2006. Archived fromthe originalon 23 April 2017.
- ^"StarOffice Software".Archived fromthe originalon 27 September 2009.
- ^"StarOffice Patches".Archived fromthe originalon 22 September 2009.
- ^"StarOffice/StarSuite Updates".Archived fromthe originalon 23 September 2009.
- ^"Collabora Office on iOS and Android Just got Better!".Adfinis.2020-12-15.Retrieved2021-01-15.
...touch optimized interfaces: one for tablets and one for phone screens....(iOS, iPadOS, Chrome OS, Android).
- ^"Office apps for Chromebook to be stopped".2021-08-31.Retrieved2022-12-01.
...it's too expensive to support Office apps on the larger screen Chromebook devices which are rivalling Windows in some markets.
- ^Through extensions:"Calc2LaTeX".2009-07-15.Retrieved2012-05-06.
- ^Through extensions:"TexMaths".2021-03-14.Retrieved2021-08-09.
- ^Through extensions:"Writer2LaTeX".2018-10-19.Retrieved2021-08-09.
- ^Through extensions:"TexMaths".2021-03-14.Retrieved2021-08-09.
- ^Through extensions:"Writer2LaTeX".2018-10-19.Retrieved2021-08-09.
- ^"16,777,216 row limit is a setting under experimental features".websetnet.net.
- ^"274,877,906,944 cells when the 16,777,216 experimental row limit is enabled".documentfoundation.org.
- ^"16,777,216 row limit is a setting under experimental features".websetnet.net.
- ^"274,877,906,944 cells when the 16,777,216 experimental row limit is enabled".documentfoundation.org.
- ^"Limitations of 1-2-3 for Windows".IBM. Archived fromthe originalon 2013-01-03.Retrieved2008-04-10.
- ^"Excel specifications and limits".MS Office Support.Microsoft.Retrieved2016-11-28.
- ^"Excel specifications and limits".MS Office Support.Microsoft.Retrieved2016-11-28.
- ^"Excel specifications and limits".MS Office Support.Microsoft.Retrieved2016-11-28.
- ^"What is the maximum number of cells in an OpenOffice.org spreadsheet?".FAQ.OpenOffice.org.Retrieved2008-04-10.
- ^"What's the maximum number of rows and cells for a spreadsheet file?".Calc FAQ.OpenOffice.org. Archived fromthe originalon 2009-05-04.Retrieved2008-11-04.
- ^"OpenOffice.org 3.0 New Features".3.0 Features.OpenOffice.org.Retrieved2008-11-10.
- ^"OpenOffice.org 3.3 New Features".3.3 Features.OpenOffice.org.Retrieved2010-12-13.