Editing Gnumeric (section)

==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.