Comparison of spreadsheet software

Online versus desktop

Web-based spreadsheets do not in general depend on a particular operating system or similar constraints and are therefore generally more portable by their nature than desktop applications.

Collaborative spreadsheets

Generally, online spreadsheets offer spreadsheet sharing and public sharing as part of their features which enables collaboration between multiple users.

Remote data update

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.

Gnumeric (listed below as a desktop spreadsheet) is also used as the "back-end" processor in at least one on-line spreadsheet application (Editgrid).

Online spreadsheets

The following tables only provide a comparison of desktop spreadsheet applications.

For a list and links to comparisons of online (web-based) spreadsheets, see List of online spreadsheets.

There is currently no list for online mainframe software such as the Works Records System.

Desktop spreadsheets

General

Screenshot Creator Development started First public release Latest stable version Cost (USD) License
Calligra Sheets KOffice KSpread Team 2.9.11 (3 February 2016 (2016-02-03)[1]) [±] Free LGPL
Gnumeric GNOME community 1998 1998 1.12.27 (February 7, 2016 (2016-02-07)[2]) [±] Free GPL
IBM Lotus Symphony IBM 2008 1.3 / 2009 Free Proprietary
LibreOffice Calc The Document Foundation 2010 3.3 / 2011-01-25
  • "Fresh" version:
    5.1.2 (April 7, 2016 (2016-04-07)[3]) [±]
  • "Still" version:
    5.0.5 (February 15, 2016 (2016-02-15)[3]) [±]
Free LGPL
Mariner Calc Mariner Software 1988 1989 5.6.0 $49.95 Proprietary
Microsoft Excel Microsoft 1982 1985 15(64-bit) / January 2013 $239 (Standalone price; also can be purchased in various Microsoft Office bundles with varying prices) Proprietary
Numbers Apple, Inc. August 7, 2007 3.5 / October 16, 2014 $19.99 Proprietary
OpenOffice Calc Oracle Corporation 2000 Build 638c / October 2001 4.1.2[4] (October 28, 2015 (2015-10-28)) [±] Free Apache License v2
PlanMaker SoftMaker Software GmbH 1994[5][6] 2012 Free - 1 Month Test Version SoftMaker Office 2012,
or € 69.95 - SoftMaker Office 2012
Proprietary
Pyspread Martin Manns 2008 2008 1.0.2 / 2016-01-15 Free GPL
Quantrix Quantrix Early 1990s 6.0.1 / Q1 2016 Free 30 day fully featured trial. Proprietary
Quattro Pro Corel 1988 1988 X7 not separately from Corel WordPerfect Office Proprietary
Resolver One Resolver Systems 2005 2008-01-16 1.9 / 2010-06-04 Free as part of an open source project or to create open source spreadsheet systems or $99 open source / Proprietary
Siag Ulric Eriksson 1996 3.6.1 / 2006 Free GPL
Screenshot Creator Development started First public release Latest stable version Cost (USD) License

Operating system support

The operating systems the software can run on natively (without emulation).

Windows Mac OS X Linux BSD Unix
Gnumeric No Yes Yes Yes Yes
IBM Lotus Symphony Yes Yes Yes No No
KSpread beta beta Yes Yes Yes
LibreOffice Calc Yes Yes Yes Yes Yes
Mariner Calc No Yes No No No
Microsoft Excel Yes Yes No No No
Numbers No Yes No No No
OpenOffice Calc Yes Yes Yes Yes Yes
PlanMaker Yes No Yes No No
Pyspread Yes Unsupported Yes Yes Yes
Quantrix Yes Yes No No No
Quattro Pro Yes No No No No
Resolver One Yes No No No No
Siag No Yes Yes Yes Yes
Windows Mac OS X Linux BSD Unix

Import/export capabilities

This table gives a comparison of what file formats each spreadsheet can import and export. "Yes" means can both import and export.

CSV Excel
(xls)
HTML LaTeX ODF
(ods)
OOXML
(xlsx)
PDF DIF OpenOffice.org XML
(sxc)
Gnumeric Yes Yes Yes Export Yes Yes Export Import Import
IBM Lotus Symphony Yes Yes Export No Yes Import Export Yes
KSpread Yes Import Export Export Yes No Export Yes
LibreOffice Calc Yes Yes Yes No Yes Yes Export Yes Yes
Mariner Calc Yes Yes No No No No Export No
Microsoft Excel Yes Yes Partial No Yes Yes Export Import No
Numbers Yes Yes No No Import Import Export No
OpenOffice Calc Yes Yes Yes Export[7] Yes Import Export Yes Yes
Quantrix Yes Yes Yes No Datalink Datalink Export Datalink
Quattro Pro Yes Yes Yes No No Import Export No
PlanMaker Yes Yes Export No No Import Export No
Pyspread Yes Yes No No No Import Export No
Resolver One Yes Yes No No No No No No
Siag Yes Import partial Yes Export No No Export Import partial
CSV XLS HTML LaTeX ODF .ods OOXML .xlsx PDF DIF OpenOffice.org XML

See also

References

  1. "Calligra 2.9.11 Released: Calligra Suite".
  2. "Gnumeric 1.12.27 aka "TBD" is now available.". Retrieved 2016-02-07.
  3. 1 2 "Release Notes". The Document Foundation. April 7, 2016. Retrieved April 8, 2016.
  4. "Announcing Apache OpenOffice 4.1.2". The Apache OpenOffice Blog. Apache Software Foundation. 28 October 2015.
  5. "Infos zu PlanMaker 97". 1997-06-03. Archived from the original on 1997-06-03. Retrieved 2010-03-28.
  6. Andy Updegrove (2006-07-05). "The Emerging ODF Environment, Part IV: Spotlight on SoftMaker Office 2006". Retrieved 2010-03-28.
  7. Through extensions: "Calc2LaTeX". 2009-07-15. Retrieved 2012-05-06.
This article is issued from Wikipedia - version of the Friday, April 22, 2016. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.