Comparison of spreadsheet software
Spreadsheet is a class of application software design to analyze tabular data called "worksheets". A collection of worksheets is called a "workbook". Online spreadsheets do not depend on a particular operating system but require a standards-compliant web browser instead. 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
Operating system support
The operating systems the software can run on natively (without emulation ). Android and iOS apps can be optimized for Chromebooks and iPads which run the operating systems ChromeOS and iPadOS respectively, the operating optimizations include things like multitasking capabilities, large and multi-display support, better keyboard and mouse support.
This table gives a comparison of what file formats each spreadsheet can import and export. "Yes" means can both import and export.
Rows and Columns
Program
Rows (per sheet)
Columns (per sheet)
Total cells (per sheet)
Sheets
Total cells (per workbook)
Collabora Online 22.05, or later versions – Online, Desktop, Tablet, Mobile1,048,576[ 41]
16,384
17,179,869,184[ 42]
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 Calc 5.4.5 – 7.31,048,576
1,024
1,073,741,824
1,024
1,099,511,627,776
LibreOffice Calc 7.4, or later versions1,048,576[ 43]
16,384
17,179,869,184[ 44]
1,024
17,592,186,044,400
Lotus 1-2-3 [ 45] 65,536
256
16,777,216
256
4,294,967,296
Microsoft Excel 200365,536
256
16,777,216
65,531
1,099,427,741,696
Microsoft Excel 2007, or later versions[ 46] [ 47] [ 48] 1,048,576
16,384
17,179,869,184
Limited by available memory
Limited by available memory
OpenOffice.org Calc 2[ 49] 65,536
256
16,777,216
256
4,294,967,296
OpenOffice.org Calc 3.0, 3.1 and 3.2[ 50] [ 51] 65,536
1024
67,108,864
256
17,179,869,184
OpenOffice.org Calc 3.3[ 52] 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*
Sourcetable [ 53] 1,048,576
18,278
10,000,000
200
10,000,000
-* 32-bit addressable memory on Microsoft Windows, i.e. ~2.5 GB.
See also
Notes
^ a b c d The 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.
^ a b c Version 4.4.
^ Development started 2006.
^ a b c d Offline editing when used with Chrome or Edge web browser.
^ a b Offline editing when used with Chrome web browser.
^ Development started 1998.
^ Old versions.
^ Version 3.3. Development started 2010.
^ a b Development started 1988.
^ Started as Multiplan in 1982.
^ Development started 2009.
^ 1999 – 2009.
^ 2010 – 2011
^ Development started 2008.
^ Development started 2005.
^ Development started 1996.
^ Development started 2020.
References
^ "Announcing Apache OpenOffice 4.1.15" . 22 December 2023. Retrieved 25 February 2024 .^ "AppleWorks 6.2.9 for Mac" . 14 January 2004.^ "AppleWorks 6.2.2 for Windows" . 20 January 2004.^ https://github.com/KDE/calligra/releases/tag/v4.0.1 . ^ a b "Collabora Office" .^ a b "Collabora Office" .^ "Collabora Online 24.04 Release Notes" .^ a b c "Collabora Office 24.04 Release Notes" .^ "ChangeLog" . 22 November 2000. Archived from the original on 8 January 2001.^ "Gnumeric 1.12.57 aka "TBD" is now available" . 12 February 2024. Retrieved 15 February 2024 .^ "Productive BeOS" . Archived from the original on 2001-12-23.^ "Windows Release" . Archived from the original on 2002-02-04.^ "Gobe Corporation" . Archived from the original on 2003-10-04.^ "IBM Lotus Symphony - Buzz: Symphony 3.0.1 FIXPACK 2 is Now AVAILABLE" . 29 November 2012. Archived from the original on 29 January 2013.^ "IBM Lotus Symphony - Release Notes" . Archived from the original on 26 April 2011.^ https://wiki.documentfoundation.org/ReleaseNotes/24.2 . ^ "Microsoft Office finally available for all Chromebooks" . 2017-11-27. Retrieved 2022-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. Retrieved 2022-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. Archived from the original on 2024-08-17. Retrieved 2022-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. Archived from the original on 2022-12-02. Retrieved 2022-12-01 . ...Office 365 subscription is needed to edit as well as create documents. ^ "Microsoft Works - Microsoft Lifecycle" . Archived from the original on 23 January 2022.^ "Release 8.2.2" . 29 November 2024. Retrieved 26 December 2024 .^ "3.3.0 - Release Notes" .^ "Infos zu PlanMaker 97" . 1997-06-03. Archived from the original on 1997-06-03. Retrieved 2010-03-28 .^ Andy Updegrove (2006-07-05). "The Emerging ODF Environment, Part IV: Spotlight on SoftMaker Office 2006" . Archived from the original on 2016-12-23. Retrieved 2010-03-28 . ^ https://pypi.org/project/pyspread/ . ^ http://www.ibiblio.org/pub/Linux/apps/financial/spreadsheet/!INDEX.html . ^ "Siag Office 3.6.1" . 10 November 2006. Archived from the original on 23 April 2017.^ AI Spreadsheet. Sourcetable Inc., 2024. Retrieved 2024-11-14.^ "StarOffice Software" . Archived from the original on 27 September 2009.^ "StarOffice Patches" . Archived from the original on 22 September 2009.^ "StarOffice/StarSuite Updates" . Archived from the original on 23 September 2009.^ "Collabora Office on iOS and Android Just got Better!" . Adfinis . 2020-12-15. Retrieved 2021-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. Archived from the original on 2024-08-17. Retrieved 2022-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. Archived from the original on 2012-04-29. Retrieved 2012-05-06 .
^ Through extensions: "TexMaths" . 2021-03-14. Archived from the original on 2024-08-17. Retrieved 2021-08-09 .
^ Through extensions: "Writer2LaTeX" . 2018-10-19. Archived from the original on 2021-08-04. Retrieved 2021-08-09 .
^ Through extensions: "TexMaths" . 2021-03-14. Archived from the original on 2024-08-17. Retrieved 2021-08-09 .
^ Through extensions: "Writer2LaTeX" . 2018-10-19. Archived from the original on 2021-08-04. Retrieved 2021-08-09 .
^ AI Spreadsheet. Sourcetable Inc., 2024. Retrieved 2024-11-14.^ "16,777,216 row limit is a setting under experimental features" . Websetnet . 5 August 2020.^ "274,877,906,944 cells when the 16,777,216 experimental row limit is enabled" . documentfoundation.org . Archived from the original on 2024-08-17.^ "16,777,216 row limit is a setting under experimental features" . Websetnet . 5 August 2020.^ "274,877,906,944 cells when the 16,777,216 experimental row limit is enabled" . documentfoundation.org . Archived from the original on 2023-09-24.^ "Limitations of 1-2-3 for Windows" . IBM. Archived from the original on 2013-01-03. Retrieved 2008-04-10 .^ "Excel specifications and limits" . MS Office Support . Microsoft. Archived from the original on 2016-11-28. Retrieved 2016-11-28 .^ "Excel specifications and limits" . MS Office Support . Microsoft. Archived from the original on 2020-04-28. Retrieved 2016-11-28 .^ "Excel specifications and limits" . MS Office Support . Microsoft. Archived from the original on 2024-08-17. Retrieved 2016-11-28 .^ "What is the maximum number of cells in an OpenOffice.org spreadsheet?" . FAQ . OpenOffice.org. Archived from the original on 2008-04-05. Retrieved 2008-04-10 .^ "What's the maximum number of rows and cells for a spreadsheet file?" . Calc FAQ . OpenOffice.org. Archived from the original on 2009-05-04. Retrieved 2008-11-04 .^ "OpenOffice.org 3.0 New Features" . 3.0 Features . OpenOffice.org. Archived from the original on 2021-01-25. Retrieved 2008-11-10 .^ "OpenOffice.org 3.3 New Features" . 3.3 Features . OpenOffice.org. Archived from the original on 2024-08-17. Retrieved 2010-12-13 .^ AI Spreadsheet. Sourcetable Inc., 2024. Retrieved 2024-11-14.
