Projects / Gnumeric

Gnumeric

Gnumeric is a powerful and easy to use spreadsheet using GNOME. Its goal is to provide a full featured spreadsheet and a smooth migration path for people and organizations currently using proprietary applications. It provides more sheet functions and greatly improved accuracy when compared to Microsoft's Excel. A plugin system lets you extend Gnumeric, adding functions, I/O formats, and real time data capabilities. The existing Python, Guile, and Perl plugins let you define complex functions. Gnumeric is capable of reading and writing MS Excel (XLS and Office Open XML), and reading Lotus, Applix, Quattro Pro, OpenCalc (ODF), XBase, DIF, SYLK, HTML, Psion, MPS, oleo, sc, misc. text formats, and its native XML. It can also generate Latex, HTML, and others.

Tags
Licenses

Recent releases

  •  07 Feb 2011 19:31

    Release Notes: Calculates residuals when using the regression tool. Permits data entry by-passing autocorrection. Works around OpenOffice date formatting bugs. ODF import and export fixes. Adds EEK support to EURO and EUROCONVERT. Fixes locale-specific sorting, advanced filter, documentation of ATAN2, arrows and line object position when zoomed, series lines color export to .xls, sheet objects position on zoomed sheets, an array intersection problem with IF, a number-match issue regarding fraction, and problems with pivot reading from XLS. Allows version-agnostic template files.

    •  07 Feb 2011 12:04

      Release Notes: Fixes were made for selection, printing, button sensitivity in the sort dialog, ODF export, import of dib format images in XLS, the maximum for col/row number in the sheet resize dialog, image bounds in zoomed sheets, a crash related to broken xls, analysis tools problems when "as values" is chosen, a crash with large tooltips, text object clipping, a disappearing window for empty file, and ranges-in-expression criticals. An argument was added to FOURIER to separate parts. The TREND function was extend to handle multiple regression. Glade usage was eliminated. Sheet object lists and combos, sc import, key combos, and the quit dialog were improved.

      •  07 Feb 2011 07:55

        Release Notes: Image-fill, pattern, and gradient export were fixed. Fixes were made for reformatting of cells on expression entry. An ssconvert crash on form controls was fixed. Several problems highlighted by LLVM/clang were fixed. Date entry and inter-process paste were fixed. Improvements were made to ODF chart import and export, reading tab colors from OOo configuration in ODF files, importing and exporting all sheet objects from and to ODF files, multiple selection in the manage sheet dialog, ctrl-click specification of sort columns, printing of the form controls, reading and writing cell comments from and to OpenXML, the ssconvert man page, user-defined templates, and the test suite.

        •  09 Sep 2010 16:23

          Release Notes: Significantly improved chart export and import to/from ODF. Improved handling of corrupted ODF files. Fixes: percentage style import from ODF, INTERPOLATION documentation, button sensitivity in the sort dialog, some interpolation and periodogram issues, graph scalar data editor behavior, some confusion of char vs. xmlChar, elapsed-time entry, problems with limits for date axes, and errors in function docs. An improved warnings dialog in ODF import. Importer leaks plugged: sylk, XML, and ODF. This release extends the domain of IMPOWER. It allows the use of glib's memory profiler, and improves the function docs self-test.

          •  06 Sep 2010 19:54

            Release Notes: This release fixed WORKDAY, NETWORKDAY, and ODF import (including graphs), auto-correction when entering in ranges, width and height adjustments when entering in ranges and on paste, auto-fitting on data entry, scroll when selecting a merged cell, object dragging when zoomed, control point behavior when zooming, in-cell editing when zoom is less than 100%, a Win32 random problem, and an IMPOWER problem. Handling of corrupted ODF and malformed XML files was improved. Guppi graphs from Gnumeric 1.0.x can be imported.

            Recent comments

            01 Jun 2008 13:29 katelin

            Gnumeric is the best
            Gnumeric is probably the best piece of software on the Linux desktop to date. Compliments to the devs on their hard work; especially for the amount of polish that has gone into it!

            02 Nov 2005 07:28 jsikorski

            Wow.
            Version 1.6 is a huge step forward for Gnumeric. Barring any undiscovered bugs that may prohibit me from using it, it's now my spreadsheet of choice under Linux. I'm especially impressed with the added configurability of the chart plugin.

            Cheers.

            23 Jun 2004 10:00 jdassen

            Re: Disappointed... just a toy (yet)

            > I am using 1.0.8 (in Debian 3.0 stable),


            That version is slightly over two years old (I uploaded 1.0.8-1t1 on Jun 18 2002). As much as I love Debian stable for a server system, it is unsuitable for many desktop users as its components are simply too old.

            For a desktop system, Debian testing (http://wiki.debian.net/index.cgi?DebianTesting) or unstable (http://wiki.debian.net/index.cgi?DebianUnstable) are better choices (provided you understand and accept the caveats). If you absolutely must run Debian stable, there's a GNOME 2.2 backport (http://gnome22.alioth.debian.org/) for it which includes a gnumeric 1.2.x package.

            15 Apr 2004 12:20 telcontar

            Disappointed... just a toy (yet)
            I am using 1.0.8 (in Debian 3.0 stable), and while gnumeric can sometimes fill an important gap in the Linux desktop, I'm overall disappointed by its shocking incompleteness. I would *never* give such a project the "one dot oh" monicker.

            First, a fatal bug prevents using any non-ASCII characters. With each save, these characters get garbled more, so after saving and loading the spreadsheet, it is completely useless.

            Then, there is still no function reference(!) in 1.0! The link to the web page shows a useless page with no direct link to a user manual or reference! The "alphabetical list of functions" that one can find using a web search is in fact not alphabetical!

            There are other minor issues, which are not crucial. However, if such issues as the ones mentioned above are not resolved, it is not suprising that people dismiss Linux office applications as toys.

            01 Aug 2001 09:02 martinmv

            Printing ISO Latin2 characters
            There (http://www.penguin.cz/~martinmv/index_eng.html) is a script for printing ISO Latin2 characters.

            Screenshot

            Project Spotlight

            OpenStack4j

            A Fluent OpenStack client API for Java.

            Screenshot

            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.