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 | Desktop Environment GNOME Office/Business Financial Spreadsheet |
|---|---|
| Licenses | GPL |
Recent releases
- 23 Apr 2009 09:01
Changes: Semantic changes in GTK+ 2.16 were worked around. Potential crashes were fixed, and LaTeX export, XLS export, translation of argument names for empty names, printing of rotated text, multi-head issues, PFACTOR, dialogs, desktop files, sheet-ordering by dragging, a string problem with broken XLS files, and setting of radio button objects' text were fixed. Various improvements were made, including date entry.
- 28 Feb 2009 08:01
Changes: This release fixed crashes in exporting an empty contour plot to .xls, XLS import, RANDDISCRETE, GROWTH/TREND, multi-view mode, inter-process paste, undo for inter-workbook operations, and dbf import. The sheet manage dialog, seealso links in the function browser, Kaplan-Meier tool, regression tool output, Win32, and encoding detection on HTML paste were improved, and drag of whole sheets was implemented. A vulnerability in Python was worked around. Leaks, OOo, CSV, and STF import and XLS export, auto filters, SUMIF, IF VLOOKUP, HLOOKUP, and BASE SERIESSUM, were fixed.
- 30 Jan 2009 12:37
Changes: New features were added for importing and exporting. New functions include OPT_RGW, phyper, BESSELI, BESSELK, EDATE, EOMONTH, GROWTH, NETWORKDAYS, WORKDAY, DDB, DAYS360, NETWORKDAYS, MATCH, CODE, and fn-financial. An attribute order problem while loading, a dependency problem with constructed ranges, mnemonics for the quit dialog, range highlighting while editing, highlighting of merged cells, an openoffice -pedantic problem, and a bogus-xls problem were fixed. A workaround was made for a pango bug.
- 25 Oct 2008 20:52
Changes: Fixes and improvements were made to printing, analysis tools, the regression tool, the sampling tool, the moving averages tool, the exponential smoothing tool, dialogs, hyperlinks, documentation, the ssgrep tool, OpenOffice.org style import, XLSX themed colors, solid fills in XLSX conditions, import of XLS files containing images in an older format, import of CSV or STF documents containing a byte-order marker, and array formulas. Various crash and leak fixes were made.
- 03 Sep 2008 05:30
Changes: Fixes were made for printing of footer lines, an attribute order issue while loading, a simulation error message, distcheck, ODS import on Win32, the cursor in tab labels, EOMONTH, a phyper hang, an openoffice -pedantic problem, a bogus-xls problem, problems with invalid dates in fn-financial, a MATCH problem with singletons, DDB problems, date entry, entry of error constants, and odd renaming of some long file names on Windows. The name guru defaults to absolute references. ssgrep was made a lot more grep-like. Functions that work on sorted ranges were unified.
- All comments
Recent commentsGnumeric 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!
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.
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.
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.
Printing ISO Latin2 characters
There (http://www.penguin.cz/~martinmv/index_eng.html) is a script for printing ISO Latin2 characters.