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
| platform = GTK 3
| operating system = Unix-like
| language =
| genre = Spreadsheet
| license = GPL-2.0-only or GPL-3.0-only{{cite web| url = https://git.gnome.org/browse/gnumeric/tree/COPYING| title = COPYING| date = 28 March 2012}}
| 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 spreadsheet programs like Microsoft Excel. Gnumeric was created and developed by Miguel de Icaza,{{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.}} but he has since moved on to other projects. The maintainer {{as of|2002|lc=y}} was Jody Goldberg.{{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}}
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{{cite web| url = http://projects.gnome.org/gnumeric/doc/sect-file-formats.shtml| title = Gnumeric v1.10 manual, file formats}}), Microsoft Works spreadsheets (.wks),[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. 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.{{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}} It includes all of the spreadsheet functions of the North American edition of Microsoft Excel and many functions unique to Gnumeric.{{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}} Pivot tables and Visual Basic for Applications macros are not yet supported.{{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}}
Gnumeric's accuracy has helped it to establish a niche for statistical analysis and other scientific tasks.{{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}}{{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}} 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
{{Portal|Free and open-source software}}
- EditGrid – was an on-line spreadsheet which used Gnumeric as its 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:Business software for Linux
Category:Cross-platform software
Category:Free software programmed in C
Category:Free spreadsheet software