Gnumeric

Last updated

Gnumeric
Original author(s) Miguel de Icaza
Developer(s) The GNOME Project
Initial release31 December 2001;21 years ago (2001-12-31)
Stable release
1.12.55 [1] [2]   OOjs UI icon edit-ltr-progressive.svg / 3 February 2023
Preview release None [±]
Repository
Written in C
Operating system Unix-like
Platform GTK 3
Type Spreadsheet
License GPL-2.0-only or GPL-3.0-only [3]
Website gnumeric.org

Gnumeric is a spreadsheet program that is part of the GNOME Free Software Desktop Project. Gnumeric version 1.0 was released on 31 December 2001. Gnumeric is distributed as free software under the GNU General Public License; it is intended to replace proprietary spreadsheet programs like Microsoft Excel. Gnumeric was created and developed by Miguel de Icaza, [4] but he has since moved on to other projects. The maintainer as of 2002 was Jody Goldberg. [5]

Contents

Features

Gnumeric has the ability to import and export data in several file formats, including CSV, Microsoft Excel (write support for the more recent .xlsx format is incomplete [6] ), Microsoft Works spreadsheets (.wks), [7] HTML, LaTeX, Lotus 1-2-3, OpenDocument and Quattro Pro; its native format is the Gnumeric file format (.gnm or .gnumeric), an XML file compressed with gzip. [8] It includes all of the spreadsheet functions of the North American edition of Microsoft Excel and many functions unique to Gnumeric. [9] Pivot tables and Visual Basic for Applications macros are not yet supported. [10]

Gnumeric's accuracy has helped it to establish a niche for statistical analysis and other scientific tasks. [11] [12] For improving the accuracy of Gnumeric, the developers are cooperating with the R Project.

Gnumeric has an interface for the creation and editing of graphs different from other spreadsheet software. For editing a graph, Gnumeric displays a window where all the elements of the graph are listed. Other spreadsheet programs typically require the user to select the individual elements of the graph in the graph itself in order to edit them.

See also

Related Research Articles

<span class="mw-page-title-main">Microsoft Excel</span> Spreadsheet editor, part of Microsoft Office

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, iOS and iPadOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). Excel forms part of the Microsoft 365 suite of software.

<span class="mw-page-title-main">Miguel de Icaza</span> Mexican free software developer

Miguel de Icaza is a Mexican programmer, best known for starting the GNOME, Mono, and Xamarin projects.

<span class="mw-page-title-main">Spreadsheet</span> Computer application for organization, analysis, and storage of data in tabular form

A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form. Spreadsheets were developed as computerized analogs of paper accounting worksheets. The program operates on data entered in cells of a table. Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells. The term spreadsheet may also refer to one such electronic document.

<span class="mw-page-title-main">Calligra Sheets</span> Calculation and spreadsheet application for KDE desktop environment

Calligra Sheets is a free software spreadsheet application that is part of Calligra Suite, an integrated graphic art and office suite developed by KDE.

The Open Document Format for Office Applications (ODF), also known as OpenDocument, is an open file format for word processing documents, spreadsheets, presentations and graphics and using ZIP-compressed XML files. It was developed with the aim of providing an open, XML-based file format specification for office applications.

<span class="mw-page-title-main">NeoOffice</span> macOS office suite

NeoOffice is an office suite for the macOS operating system developed by Planamesa Inc. It is a commercial fork of the free and open source LibreOffice office suite, including a word processor, spreadsheet, presentation program and graphics program, it adds some features not present in the macOS versions of LibreOffice and Apache OpenOffice. Current versions are based on LibreOffice 4.4, which was released mid-2014.

gretl

gretl is an open-source statistical package, mainly for econometrics. The name is an acronym for GnuRegression, Econometrics and Time-seriesLibrary.

<span class="mw-page-title-main">Microsoft Office 2007</span> Version of Microsoft Office

Microsoft Office 2007 is an office suite for Windows, developed and published by Microsoft. It was officially revealed on March 9, 2006 and was the 12th version of Microsoft Office. It was released to manufacturing on November 3, 2006; it was subsequently made available to volume license customers on November 30, 2006, and later to retail on January 30, 2007, shortly after the completion of Windows Vista. The ninth major release of Office for Windows, Office 2007 was preceded by Office 2003 and succeeded by Office 2010. The Mac OS X equivalent, Microsoft Office 2008 for Mac, was released on January 15, 2008.

This is an overview of software support for the OpenDocument format, an open document file format for saving and exchanging editable office documents.

OpenFormula is an open standard for exchanging recalculated formulae in spreadsheets. OpenFormula is included in version 1.2 of the OpenDocument standard. OpenFormula was initially proposed and drafted by David A. Wheeler.

Office Open XML is a zipped, XML-based file format developed by Microsoft for representing spreadsheets, charts, presentations and word processing documents. Ecma International standardized the initial version as ECMA-376. ISO and IEC standardized later versions as ISO/IEC 29500.

<span class="mw-page-title-main">GNU Oleo</span> Spreadsheet program

GNU Oleo is a discontinued lightweight free software spreadsheet originally designed as a text-based spreadsheet using the curses library. The last development version of Oleo, 1.99.16, was released in 2001.

OpenOffice.org XML is an open XML-based file format developed as an open community effort by Sun Microsystems in 2000–2002. The open-source software application suite OpenOffice.org 1.x and StarOffice 6 and 7 used the format as their native and default file format for saving files. The OpenOffice.org XML format is no longer widely used, but it is still supported in recent versions of OpenOffice.org-descended software.

The Microsoft Office XML formats are XML-based document formats introduced in versions of Microsoft Office prior to Office 2007. Microsoft Office XP introduced a new XML format for storing Excel spreadsheets and Office 2003 added an XML-based format for Word documents.

The Office Open XML format (OOXML), is an open and free document file format for saving and exchanging editable office documents such as text documents, spreadsheets, charts, and presentations.

<span class="mw-page-title-main">FarPoint Spread</span> Computer software

This article refers to the last FarPoint Edition of the Spread Product line. Spread is now developed by GrapeCity, Inc. Since the acquisition, Spread for Biztalk Server has been removed from the product line and SpreadJS, a JavaScript version, has been added.

Microsoft Office shared tools are software components that are included in all Microsoft Office products.

References

  1. "Gnumeric 1.12.55 aka "TBD" is now available". 3 February 2023. Retrieved 4 February 2023.
  2. "GNUMERIC_1_12_55". 3 February 2023. Retrieved 4 February 2023.
  3. "COPYING".
  4. "The Gnumeric spreadsheet". Gnumeric. Retrieved 6 September 2010. Gnumeric has been coded mainly by Miguel de Icaza, with help from other intrepid hackers that have contributed code, bug fixes and documentation.
  5. Rick Lehrbaum (11 January 2002). "DesktopLinux.com interviews Gnumeric project leader Jody Goldberg". desktoplinux.com archive. Archived from the original on 7 February 2013. Retrieved 26 April 2017.
  6. "Gnumeric v1.10 manual, file formats".
  7. The file formats which Gnumeric can read. Projects.gnome.org. Retrieved 2013-12-09.
  8. "Gnumeric XML File Format". The Gnumeric Manual, version 1.8. GNOME Documentation Project. November 2007. Retrieved 31 January 2010.
  9. "The Gnumeirc Manual, version 1.12". help.gnome.org. Retrieved 27 June 2021.
  10. "Things we plan to do in Gnumeric". Gnumeric. Retrieved 3 January 2013.
  11. McCullough, B. D. (4 June 2004). "Fixing Statistical Errors in Spreadsheet Software: The Cases of Gnumeric and Excel" (PDF). Computational Statistics & Data Analysis. Archived from the original (PDF) on 23 April 2009. Retrieved 31 January 2010. The most recent versions given a full analysis in this report (available without charge) are Microsoft Excel XP and Gnumeric 1.1.2, and the author has more-limited data on then-new Excel 2003.
  12. McCullough, B. D.; Wilson, Berry (15 June 2005). "On the accuracy of statistical procedures in Microsoft Excel 2003" (PDF). Computational Statistics & Data Analysis. 49 (4): 1244–1252. CiteSeerX   10.1.1.455.5508 . doi:10.1016/j.csda.2004.06.016. ISSN   0167-9473. Archived from the original (PDF) on 7 June 2011. Retrieved 31 January 2010. In this journal article, after a more complete analysis of Excel 2003, McCullough concludes that Excel 2003 is an improvement over previous versions, but not enough has been done that its use for statistical purposes can be recommended