The following is a list of spreadsheets.
Many spreadsheet software products, such as Microsoft Excel (versions prior to 2007) and OpenOffice.org Calc (versions prior to 2008), have a capacity limit of 65,536 rows by 256 columns (2 16 and 2 8 respectively). This can present a problem for people using very large datasets, and may result in data loss. Spreadsheets A Quick and Easy Guide to Spreadsheets. A spreadsheet is a software program you use to easily perform mathematical calculations on statistical data and totaling long columns of numbers or determining percentages and averages. The Apache Software Foundation Celebrates 20 Years of OpenOffice® 17 May 2020: Apache OpenOffice needs your help 22 October 2019: 1.6 million downloads of Apache OpenOffice 4.1.7 21 September 2019: Announcing Apache OpenOffice 4.1.7 18 November 2018: Announcing Apache OpenOffice 4.1.6 31 January 2018: Over 3.2 million downloads of Apache. Spreadsheetsoftware is an independent software company based in Maastricht, the Netherlands. Our core business is creating powerful Excel add-in software and building and reviewing spreadsheets for all sorts of industries and clients. Our team has a background in real estate, finance and business analysis with more than 60 years combined Excel. Introducing Microsoft 365 (formerly Microsoft Office 365).
Free and open-source software[edit]
Cloud and on-line spreadsheets[edit]
- Collabora Online Calc — Enterprise-ready LibreOffice.[1]
- Sheetster – 'Community Edition' is available under the Affero GPL
- Tiki Wiki CMS Groupware includes a spreadsheet since 2004 and migrated to jQuery.sheet in 2010.[2]
Spreadsheets that are parts of suites[edit]
- Collabora Online Calc — Enterprise-ready LibreOffice, web based application.
- Gnumeric — for Linux. Started as the GNOME desktop spreadsheet. Reasonably lightweight but has very advanced features.
- KSpread — following the fork of the Calligra Suite from KOffice in mid-2010, superseded by KCells in KOffice and Sheets in the Calligra Suite.[3]
- LibreOfficeCalc — developed for MS Windows, Linux, BSD and Apple Macintosh (Mac) operating systems by The Document Foundation. The Document Foundation was formed in mid-2010 by several large organisations such as Google, Red Hat, Canonical (Ubuntu) and Novell along with the OpenOffice.org community (developed by Sun) and various OpenOffice.org forks, notably Go-oo. Go-oo had been the 'OpenOffice' used in Ubuntu and elsewhere. Started as StarOffice in the late 1990s, it became OpenOffice under Sun and then LibreOffice in mid-2010. The Document Foundation works with external organisations such as NeoOffice and Apache Foundation to help drive all three products forward.[4]
- NeoOffice Calc — for Mac. Started as an OpenOffice.org port to Mac, but by using the Mac-specific Aquauser interface, instead of the more widely used X11 windowing server, it aimed to be far more stable than the normal ports of other suites.[5]
- OpenOffice.orgCalc — for MS Windows, Linux and the Apple Macintosh. Started as StarOffice. Sun changed the name to OpenOffice.org and developed a community of developers (and others) between the late 1990s and mid-2010. Oracle gave it to the Apache Foundation in 2011. IBM contributed their fork of OpenOffice.org, IBM Lotus Symphony, to Apache a few weeks later.[6]
- Siag — for Linux, OpenBSD and Apple Mac OS X. A simple old spreadsheet, part of Siag Office.[7]
- Sheets — for MS Windows, Linux, FreeBSD, Apple Mac OS X and Haiku. Part of the extensive Calligra Suite. Possibly still mainly for Linux, but ports have been developed for other operating systems.[8]
Standalone spreadsheets[edit]
Proprietary software[edit]
Google Sheets
Online spreadsheets[edit]
Spreadsheet Software Mac
- EditGrid – access, collaborate and share spreadsheets online, with API support; discontinued since 2014
- Google Sheets – as part of Google Docs
- Zoho Sheet Spreadsheet on the cloud that allows real-time collaboration and more, for free
- iRows – closed since 31 December 2006
- JotSpot Tracker – acquired by Google Inc.
- Smartsheet – Online spreadsheet for project management, interactive Gantt, file sharing, integrated with Google Apps[9]
- ThinkFree Online Calc – as part of the ThinkFree Office online office suite, using Java
- Airtable - a spreadsheet-database hybrid, with the features of a database but applied to a spreadsheet.
Spreadsheets that are parts of suites[edit]
- Ability Office Spreadsheet – for MS Windows.
- Apple iWorkNumbers, included with Apple's iWork '08 suite exclusively for Mac OS X v10.4 or higher.
- AppleWorks – for MS Windows and Macintosh. This is a further development of the historical Claris Works Office suite.
- WordPerfect OfficeQuattro Pro – for MS Windows. Was one of the big three spreadsheets (the others being Lotus 123 and Excel).
- EasyOffice EasySpreadsheet – for MS Windows. No longer freeware, this suite aims to be more user friendly than competitors.
- Framework – for MS Windows. Historical office suite still available and supported. It includes a spreadsheet.
- IBM Lotus Symphony – freeware for MS Windows, Apple Mac OS X and Linux.
- Kingsoft Office Spreadsheets 2012 – For MS Windows. Both free and paid versions are available. It can handle Microsoft Excel .xls and .xlsx files, and also produce other file formats such as .et, .txt, .csv, .pdf, and .dbf. It supports multiple tabs, VBA macro and PDF converting.[10]
- Lotus SmartSuiteLotus 123 – for MS Windows. In its MS-DOS (character cell) version, widely considered to be responsible for the explosion of popularity of spreadsheets during the 80s and early 90s.[citation needed]
- MarinerPak Mariner Calc – for Apple Macintosh. Full featured and light weight.
- Microsoft OfficeExcel – for MS Windows and Apple Macintosh. The proprietary spreadsheet leader.
- Microsoft Works Spreadsheet – for MS Windows (previously MS-DOS and Apple Macintosh). Only allows one sheet at a time.
- PlanMaker – for MS Windows, Linux, MS Windows Mobile and CE; part of SoftMaker Office
- Quattro Pro – part of WordPerfect Office
- StarOffice Calc – Cross-platform. StarOffice was originally developed by the German company Star Division which was purchased by Sun in 1998. The code was made open source and became OpenOffice.org. Sun continues developing the commercial version which periodically integrates the open source code with their own and third party code to make new low price versions.
Stand alone spreadsheets[edit]
- As-Easy-As – from Trius, Inc.; unsupported; last MS-DOS and Windows versions available with free full license key.
Multi-dimensional spreadsheets[edit]
Spreadsheets on different paradigms[edit]
[clarification needed]
- DADiSP – Combines the numerical capability of MATLAB with a spreadsheet like interface.
- Resolver One – a business application development tool that represents spreadsheets as IronPython programs, created and executed in real time and allowing the spreadsheet flow to be fully programmed
Spreadsheet-related developmental software[edit]
- ExtenXLS – Java Spreadsheet Toolkit.
Specifications[edit]
Program | Rows (per sheet) | Columns (per sheet) | Total cells (per sheet) | Sheets | Total cells (per workbook) |
---|---|---|---|---|---|
Collabora Online Calc | 1,048,576 | 1,024[11] | 1,073,741,824 | 1,024 | 1,099,511,627,776 |
Gnumeric | 16,777,216 | 16,384 | 274,877,906,944 | 142,648 | 603,103 |
KSpread | 32,767 | 32,767 | 1,073,676,289 | 130,645 | 953,923 |
LibreOffice Calc 6.0 - 6.4, 7.0 and 5.4.5 | 1,048,576 | 1,024 | 1,073,741,824 | 1,024 | 1,099,511,627,776 |
Lotus 1-2-3[12] | 65,536 | 256 | 16,777,216 | 256 | 4,294,967,296 |
Microsoft Excel 2003 | 65,536 | 256 | 16,777,216 | 65,531 | 1,099,427,741,696 |
Microsoft Excel 2007, or later versions[13][14][15] | 1,048,576 | 16,384 | 17,179,869,184 | Limited by available memory | Limited by available memory |
OpenOffice.org Calc 2[16] | 65,536 | 256 | 16,777,216 | 256 | 4,294,967,296 |
OpenOffice.org Calc 3.0, 3.1 and 3.2[17][18] | 65,536 | 1024 | 67,108,864 | 256 | 17,179,869,184 |
OpenOffice.org Calc 3.3[19] | 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-bit addressable memory on Microsoft Windows, i.e. ~2.5 GB.
Historical[edit]
- VisiCalc The first widely used normal spreadsheet with A1 notation etc.
- Lotus 1-2-3 Took the market from Visicalc in the early 1980s.
- Lotus Improv Novel design that went beyond A1 notation.
- Multiplan Early version of Excel.
- 20/20 Multiplatform competitor to 1-2-3 with database integration and real-time data updating.
- 3D-Calc multi-dimensional spreadsheet for Atari ST[20]
- SuperCalc – CP/M-80 Included with early Osborne computers. It also was ported to MS-DOS and to Microsoft Windows.
- Dynacalc — from Computer Systems Center, similar to VisiCalc. It was designed to run on Microware's OS-9, a Unix-like operating system.[21]
- VP Planner – Similar in look and feel to Lotus 1-2-3, but included 5 level multi-dimensional database[22]
- Wingz Multi Dimensional Spreadsheet from Informix (1988)
- Boeing Calc – was a spreadsheet package written by subsidiary of aviation manufacturer Boeing (1985).
Spreadsheet Software List
See also[edit]
Spreadsheet Software Programs
References[edit]
- ^Bärwaldt, Erik (2020). 'Collaborative online office solutions'. Admin Network and Security. ADMIN 60/2020.
- ^Spreadsheet, Tiki.
- ^The KOffice Project, archived from the original on 2005-12-31, retrieved 2006-03-02.
- ^LibreOffice.
- ^NeoOffice.
- ^OpenOffice.org.
- ^'Scheme In A Grid'. NU: Siag. 2000-12-07. Retrieved 7 March 2017.
- ^The Calligra Suite.
- ^Apps Marketplace Profile, Google.
- ^Spreadsheets, Kingsoft.
- ^'16384 columns limit is a setting under experimental features'. documentfoundation.org.
- ^'Limitations of 1-2-3 for Windows'. IBM. Archived from the original on 2013-01-03. Retrieved 2008-04-10.CS1 maint: discouraged parameter (link)
- ^'Excel specifications and limits'. MS Office Support. Microsoft. Retrieved 2016-11-28.CS1 maint: discouraged parameter (link)
- ^'Excel specifications and limits'. MS Office Support. Microsoft. Retrieved 2016-11-28.CS1 maint: discouraged parameter (link)
- ^'Excel specifications and limits'. MS Office Support. Microsoft. Retrieved 2016-11-28.CS1 maint: discouraged parameter (link)
- ^'What is the maximum number of cells in an OpenOffice.org spreadsheet?'. FAQ. OpenOffice.org. Retrieved 2008-04-10.CS1 maint: discouraged parameter (link)
- ^'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.CS1 maint: discouraged parameter (link)
- ^'OpenOffice.org 3.0 New Features'. 3.0 Features. OpenOffice.org. Retrieved 2008-11-10.CS1 maint: discouraged parameter (link)
- ^'OpenOffice.org 3.3 New Features'. 3.3 Features. OpenOffice.org. Retrieved 2010-12-13.CS1 maint: discouraged parameter (link)
- ^Frank Schoonjans, '3D-Calc', Atari ST.
- ^'Dynacalc'(PDF) (manual). Tandy. Retrieved April 13, 2015.CS1 maint: discouraged parameter (link)
- ^Stephenson, James; Brothers, Kent; Mitchell, Dave (December 1, 1986). VP-Planner: Spreadsheet Flexibility with Database Powe. Paperback Software International, Stephenson Software. ISBN0-87142021-X.