Gnumeric is a
spreadsheet
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 ce ...
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
Free software or libre software is computer software distributed under terms that allow users to run the software for any purpose as well as to study, change, and distribute it and any adapted versions. Free software is a matter of liberty, ...
under the
GNU General Public License
The GNU General Public License (GNU GPL or simply GPL) is a series of widely used free software licenses that guarantee end user
In product development, an end user (sometimes end-user) is a person who ultimately uses or is intended to ulti ...
; it is intended to replace
proprietary spreadsheet programs like
Microsoft Excel
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for ...
. Gnumeric was created and developed by
Miguel de Icaza, but he has since moved on to other projects. The maintainer was Jody Goldberg.
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),
Microsoft Works
Microsoft Works was a productivity software suite developed by Microsoft and sold from 1987 to 2009. Its core functionality included a word processor, a spreadsheet and a database management system. Later versions had a calendar application and ...
spreadsheets (
.wks
),
HTML
The HyperText Markup Language or HTML is the standard markup language for documents designed to be displayed in a web browser. It can be assisted by technologies such as Cascading Style Sheets (CSS) and scripting languages such as JavaScri ...
,
LaTeX
Latex is an emulsion (stable dispersion) of polymer microparticles in water. Latexes are found in nature, but synthetic latexes are common as well.
In nature, latex is found as a milky fluid found in 10% of all flowering plants (angiosper ...
,
Lotus 1-2-3
Lotus 1-2-3 is a discontinued spreadsheet program from Lotus Software (later part of IBM). It was the first killer application of the IBM PC, was hugely popular in the 1980s, and significantly contributed to the success of IBM PC-compatible ...
,
OpenDocument
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 ...
and
Quattro Pro; its native format is the ''Gnumeric file format'' (
.gnm
or
.gnumeric
), an
XML
Extensible Markup Language (XML) is a markup language and file format for storing, transmitting, and reconstructing arbitrary data. It defines a set of rules for encoding documents in a format that is both human-readable and machine-readable. ...
file compressed with
gzip. It includes all of the
spreadsheet functions of the
North American edition of Microsoft Excel and many functions unique to Gnumeric.
Pivot tables and
Visual Basic for Applications macros are not yet supported.
Gnumeric's accuracy has helped it to establish a niche for
statistical analysis
Statistical inference is the process of using data analysis to infer properties of an underlying distribution of probability.Upton, G., Cook, I. (2008) ''Oxford Dictionary of Statistics'', OUP. . Inferential statistical analysis infers propertie ...
and other
scientific
Science is a systematic endeavor that builds and organizes knowledge in the form of testable explanations and predictions about the universe.
Science may be as old as the human species, and some of the earliest archeological evidence ...
tasks. 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.
Gnumeric is available in Version 1.12.50.
Gnumeric under Microsoft Windows
Gnumeric releases were ported to
Microsoft Windows until August 2014 (the latest versions were 1.10.16 and 1.12.17).
Use of current version of Gnumeric on Windows is possible with MSYS2 with experienced know-how of a Linux/Unix user. After GTK+ 2.24.10 and 3.6.4, development of Windows version was closed by GNOME. Creation of Windows version was complicated by bugs in old Windows versions of GTK+.
Installation of MSYS2 on Windows is a good way to use current GTK software. GTK+ 2.24.10 and 3.6.4 are available on-line. Versions of GTK for 64-bit Windows are prepared by Tom Schoonjans – current examples are 2.24.32 and 3.24.23.
This could be also a new start for a new native 64-bit Windows version of Gnumeric.
See also
*
EditGrid – was an on-line spreadsheet which used Gnumeric as its
back-end
*
List of spreadsheet software
*
Comparison of spreadsheet software
References
External links
*
''Gnumeric'' XML File Format Nancy Cohen, 17 February 2004; archived 2012
full issue on Introduction to Gnumeric
{{GTK
2001 software
Business software for Linux
Cross-platform software
Free software programmed in C
Free spreadsheet software
Office software that uses GTK
Plotting software