Gnumeric

Gnumeric
GPL · source
Name	Gnumeric
Developer	GNOME Foundation; originally Miguel de Icaza and Jody Goldberg
Released	2001
Programming language	C (programming language); GTK; GLib
Operating system	Linux, Unix-like, Microsoft Windows
Genre	Spreadsheet
License	GNU General Public License

Gnumeric Gnumeric is a spreadsheet application developed as part of the GNOME project. It aims to provide an accurate Microsoft Excel-compatible alternative on Linux, FreeBSD, and Unix-like systems, with ports to Microsoft Windows and integration with KDE. The project emphasizes numerical accuracy, open-source licensing, and interoperability with formats from OpenOffice.org Calc, LibreOffice Calc, and proprietary suites.

History

The project's origins trace to early 2000s discussions within the GNOME Foundation community and contributions by developers such as Miguel de Icaza and Jody Goldberg, intersecting with broader movements including OpenOffice.org and the Free Software Foundation. During the decade that followed, Gnumeric evolved alongside projects like KOffice and AbiWord, influenced by benchmarking efforts conducted by groups linked to University of Cambridge and the European Union research initiatives. The timeline overlapped with releases of GNOME 1, GNOME 2, and later GNOME 3, and responded to interoperability challenges posed by Microsoft Office file formats after decisions by Microsoft Corporation such as those affecting Office Open XML. Community involvement included contributors from organizations like Red Hat, Novell, Canonical (company), and volunteers aligned with Debian, Fedora (operating system), openSUSE, and Arch Linux packaging teams. Gnumeric's roadmap reflected changes in underlying technologies including GTK+, GLib, and evolving build systems used across Free Software projects.

Features

Gnumeric offers a range of capabilities comparable with mainstream spreadsheet software used in institutions such as NASA, CERN, and academic labs at Massachusetts Institute of Technology and Stanford University. Key features include extensive function libraries influenced by standards set by ISO/IEC, statistical routines similar to those in R (programming language), and plotting facilities reminiscent of Gnuplot and Matplotlib. It supports cell formatting, conditional formatting workflows familiar to users of Lotus 1-2-3, StarOffice, and Corel WordPerfect Office, pivot-like tables comparable to features in Microsoft Excel and LibreOffice Calc, and scripting via interfaces akin to Python (programming language) and Perl. Gnumeric's formula engine emphasizes accuracy and deterministic behavior celebrated in scientific communities including members of American Statistical Association and repositories like arXiv. Visualization integrates with libraries and concepts used in projects such as GTK, Cairo (graphics) and aligns with usability principles advocated by Jakob Nielsen and Don Norman.

File formats and compatibility

Gnumeric reads and writes multiple formats to interoperate with suites such as Microsoft Office, OpenOffice.org, LibreOffice, KOffice, and cloud services from Google LLC. Supported import/export includes Excel Binary File Format, Office Open XML, OpenDocument Format, CSV, HTML, and XML-based interchange formats. Efforts to maintain compatibility have required analysis of specifications from bodies like Ecma International and International Organization for Standardization, and created test suites comparable to validation work by W3C and IETF. Compatibility discussions often reference implementations in Apache POI, libreofficekit, and converters used by Dropbox (service) and Google Drive. Packaging and distribution across ecosystems involve metadata norms from Freedesktop.org and policies from distributions including Debian, Ubuntu, and Fedora (operating system).

Architecture and development

The codebase is written primarily in C (programming language) using GTK and GLib libraries, following build practices seen in projects like GIMP and Evolution (software). Its modular architecture separates the user interface, formula evaluator, and import/export modules, echoing design patterns used in GNOME Core Applications and KDE Applications. Development practices include version control workflows historically managed with CVS and Subversion and later migrated to systems such as Git hosted on platforms akin to GitLab and Savannah (software); contributions have come from individuals affiliated with Red Hat, Canonical (company), IBM, and independent maintainers. Continuous integration and packaging adopt approaches similar to Jenkins pipelines and Debian Continuous Integration, while localization leverages frameworks like gettext and community resources including Transifex and Launchpad. The project follows licensing norms of the GNU General Public License and interacts with legal precedents involving organizations like the Free Software Foundation.

Reception and adoption

Gnumeric has been cited in reviews by outlets such as Linux Journal, ZDNet, CNET, and technical blogs from contributors to Stack Overflow and forums like Reddit. It has been adopted in academic settings at institutions including University of Oxford, Harvard University, and Yale University for coursework and research reproducibility, and used in government-related open-source initiatives in municipalities influenced by policies from the European Commission and agencies modeled after United Nations open data efforts. Comparative evaluations against Microsoft Excel, LibreOffice Calc, and R libraries highlighted Gnumeric's numerical fidelity and lightweight footprint, leading to inclusion in distributions such as Ubuntu, Debian, and Fedora. Notable endorsements have come from maintainers of scientific packages and independent analysts associated with Phoronix and LWN.net, while critiques often cite feature parity and GUI polish compared to large commercial suites produced by Microsoft Corporation and Apple Inc..

Category:Spreadsheet software Category:GNOME