Skip navigation.

Gnumeric turns 5, now supports 100% of XL worksheet functions

Gnumeric
Gnumeric

Jody Goldberg wrote:

Five years ago today, Miguel committed the first code to Gnumeric [1].
In a testament to the quality of the code several lines are still in
use [2]. Since that time the project has grown to more than 300,000
lines and now supports all 325 worksheet functions in MS Excel, plus
almost 100 more
[3].
This seemed like a good time to thank all the people who have
contributed to Gnumeric over the years. We're about to start the
run up to the the next stable release which will be out in a few
weeks. We look forward to continuing work with the GNOME community
to produce the most powerful spreadsheet in the world.

[1]
revision 1.1
date: 1998/07/02 22:51:55; author: unammx; state: Exp;
Stuff for today

[2]
1.1 (unammx 02-Jul-98): Sheet *
1.472 (jody 11-Mar-01): sheet_new (Workbook *wb, char const *name)
1.1 (unammx 02-Jul-98): {
1.1 (unammx 02-Jul-98): Sheet *sheet;
...
1.1 (unammx 02-Jul-98): sheet = g_new0 (Sheet, 1);
1.1 (unammx 02-Jul-98): return sheet;
1.1 (unammx 02-Jul-98): }

[3]
http://www.gnome.org/projects/gnumeric/functions.shtml

VBA Support

Definitely. I can't say that this is actually under development, but it is being researched. There is already some code in libgsf to decompress the source code in MS Office files. We're not clear how to find the offset to the offset of the compressed source, but then again neither are the OO folk. Once we've got the source, a mono plugin with its VB support my just do the trick. For now we're at least smart enough to round trip the macros in a file so that they're still there when we save as xls, even without being able to parse them.

From the other direction, there has been alot of interest in getting the scripting interface enabled. Initially via python.