Editing Gnumeric

{{Short description|Free and open-source spreadsheet software}}
{{Primary sources|date=June 2024}}
{{Use dmy dates|date=August 2021}}

{{Infobox software
| name                   = Gnumeric
| logo                   = Gnumeric.svg
| screenshot             = Gnumeric 1.12.9.png
| caption                = A screenshot of Gnumeric 1.12.9 running under [[Ubuntu MATE]]
| author                 = [[Miguel de Icaza]]
| developer              = [[The GNOME Project]]
| released               = {{Start date and age|2001|12|31|df=yes}}
| latest release version = {{wikidata|property|preferred|references|edit|Q220993|P348|P548=Q2804309}}
| latest release date    = {{wikidata|qualifier|preferred|single|Q220993|P348|P548=Q2804309|P577}}
| latest preview version = {{wikidata|property|preferred|references|edit|Q220993|P348|P548=Q51930650}}
| latest preview date    = {{wikidata|qualifier|preferred|single|Q220993|P348|P548=Q51930650|P577}}
| programming language   = [[C (programming language)|C]]
| platform               = [[GTK]] 3
| operating system       = [[Unix-like]]
| language               = 
| genre                  = [[Spreadsheet]]
| license                = [[GNU General Public License|GPL-2.0-only]] or [[GNU General Public License|GPL-3.0-only]]<ref>{{cite web| url = https://git.gnome.org/browse/gnumeric/tree/COPYING| title = COPYING| date = 28 March 2012}}</ref>
| website                = {{URL|http://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 software|proprietary]] spreadsheet programs like [[Microsoft Excel]]. Gnumeric was created and developed by [[Miguel de Icaza]],<ref>{{cite web | url = https://www.gnu.org/software/gnumeric/gnumeric.html | title = The Gnumeric spreadsheet | work = Gnumeric | access-date =6 September 2010 | quote = ''Gnumeric has been coded mainly by Miguel de Icaza, with help from other intrepid hackers that have contributed code, bug fixes and documentation.''}}</ref> but he has since moved on to other projects. The maintainer {{as of|2002|lc=y}} was Jody Goldberg.<ref>{{cite web|archive-url=https://web.archive.org/web/20130207085717/http://desktoplinux.com/articles/AT3642020036.html|url=http://desktoplinux.com/articles/AT3642020036.html|archive-date=7 February 2013|title=DesktopLinux.com interviews Gnumeric project leader Jody Goldberg|website=desktoplinux.com archive|date=11 January 2002|author=Rick Lehrbaum|access-date=26 April 2017|url-status=dead}}</ref>

==Features==
Gnumeric has the ability to import and export data in several file formats, including [[Comma-separated values|CSV]], Microsoft Excel (write support for the more recent <code>.xlsx</code> format is incomplete<ref>{{cite web| url = http://projects.gnome.org/gnumeric/doc/sect-file-formats.shtml| title = Gnumeric v1.10 manual, file formats}}</ref>), [[Microsoft Works]] spreadsheets (<code>.wks</code>),<ref>[http://projects.gnome.org/gnumeric/doc/sect-file-open-formats.shtml The file formats which Gnumeric can read]. Projects.gnome.org. Retrieved 2013-12-09.</ref> [[HTML]], [[LaTeX]], [[Lotus 1-2-3]], [[OpenDocument]] and [[Quattro Pro]]; its native format is the ''Gnumeric file format'' (<code>.gnm</code> or <code>.gnumeric</code>), an [[XML]] file compressed with [[gzip]].<ref>{{cite web|url=http://projects.gnome.org/gnumeric/doc/file-format-gnumeric.shtml|title=''Gnumeric'' XML File Format|date=November 2007|work=The Gnumeric Manual, version 1.8|publisher=GNOME Documentation Project|access-date=31 January 2010}}</ref> It includes all of the [[Subroutine|spreadsheet function]]s of the [[North America]]n edition of Microsoft Excel and many functions unique to Gnumeric.<ref>{{cite web |title=The Gnumeric Manual, version 1.12 |url=https://help.gnome.org/users/gnumeric/stable/chapter-welcome.html.en|website=help.gnome.org|access-date=5 January 2025}}</ref> [[Pivot table]]s and [[Visual Basic for Applications]] macros are not yet supported.<ref>{{cite web|title=Things we plan to do in Gnumeric|url=http://projects.gnome.org/gnumeric/to-do.shtml|publisher=Gnumeric|access-date=3 January 2013}}</ref>

Gnumeric's accuracy has helped it to establish a niche for [[statistical analysis]] and other [[scientific]] tasks.<ref>{{cite web |url=http://www.csdassn.org/software_reports/gnumeric.pdf |title=Fixing Statistical Errors in Spreadsheet Software: The Cases of Gnumeric and Excel |last=McCullough |first=B. D. |date=4 June 2004 |work=Computational Statistics & Data Analysis |access-date=31 January 2010 |quote=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. |url-status=dead |archive-url=https://web.archive.org/web/20090423202057/http://www.csdassn.org/software_reports/gnumeric.pdf |archive-date=23 April 2009}}</ref><ref>{{cite journal|last=McCullough|first=B. D.|author2=Wilson, Berry|date=15 June 2005|title=On the accuracy of statistical procedures in Microsoft Excel 2003|journal=Computational Statistics & Data Analysis|volume=49|issue=4|pages=1244–1252|issn=0167-9473|url=http://arc.nucapt.northwestern.edu/~karnesky/sdarticle.pdf|access-date=31 January 2010|quote=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|doi=10.1016/j.csda.2004.06.016|citeseerx=10.1.1.455.5508|archive-date=7 June 2011|archive-url=https://web.archive.org/web/20110607005202/http://arc.nucapt.northwestern.edu/~karnesky/sdarticle.pdf|url-status=dead}}</ref> For improving the accuracy of Gnumeric, the developers are cooperating with the [[R programming language|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==
{{Portal|Free and open-source software}}
* [[EditGrid]] – was an on-line spreadsheet which used Gnumeric as its [[Front-end and back-end|back-end]]
* [[List of open source spreadsheet software]]
* [[Comparison of spreadsheet software]]

==References==
{{Reflist}}

==External links==
{{Commons category}}
* {{Official website|http://gnumeric.org/}}
* [https://help.gnome.org/users/gnumeric/stable/gnumeric.html#sect-file-formats ''Gnumeric'' XML File Format]
* [https://web.archive.org/web/20120205193211/http://www.open-mag.com/features/Vol_92/gnumeric/gnumeric.htm Open Mag interviews Jody Goldberg on Gnumeric]. Nancy Cohen, 17 February 2004; archived 2012
* [http://www.troubleshooters.com/lpm/200306/200306.htm Linux Productivity Magazine Volume 2 Issue 6, June 2003]: full issue on Introduction to Gnumeric
{{Spreadsheets}}
{{GTK}}

[[Category:2001 software]]
[[Category:Business software for Linux]]
[[Category:Cross-platform software]]
[[Category:Free software programmed in C]]
[[Category:Free spreadsheet software]]
[[Category:Office software that uses GTK]]
[[Category:Plotting software]]