The StartX Files: Gnumeric 1.0 Proves Stable and Fast
Looking at Gnumeric

Brian Proffitt
Monday, January 7, 2002 12:06:06 PM
When you start Gnumeric up, the first thing
you are going to notice is speed, and lots of it. Say what you will about Calc,
but that it one darn slow application to start up. This is definitely not the
case with Gnumeric, which practically leaps onto the screen.
Gnumeric's
interface is not particularly cluttered with a lot of toolbars and the attendant
buttons, which is good. There is such a thing as too many buttons and
gimcracks. This application is clearly made for a no-frills kind of user.
The interfaces for Gnumeric are all standard stuff, with nothing that will
throw a user a curve. Cells, rows, and columns are all easily configured with
their respective pop-up menus. Cell formatting was robust, and I was easily able
to make some sharp-looking spreadsheets.
The function library was very
well-stocked, with 300+ functions made available. Manual and cursor-entered
creation of formulas is allowed, a standard feature in most spreadsheet
applications.
Not so standard in similar applications was the presence of
some nifty little tools that lend some real power to Gnumeric, such as the
goal-seeking tool that allows you to calculate break-even points on loans and
revenue models. It took me a couple of false starts to get this modeling tool
running right (mostly because I was confused on the problem setup in my own
head) but once the lightbulb went on, it all worked well.
Also included
in Gnumeric are 18 very sophisticated data modeling tools, including analysis
of variance (ANOVA), histogram, and exponential smoothing -- just to name a few.
All of these tools used straightforward dialog boxes to allow you to configure
the models as you want. I found the execution of all of these tools to be
flawless and only my limited knowledge of statistics probably kept me from
enjoying them more.
The only glitch I had running this application, and
it was easily fixed, was that fact that you need to have GNOME's Guppi installed
if you want to use the graphing tool. Once installed, it all worked like a
charm, but I would hope that this is installed by default in later packages.
I have lots of positive things to say about Gnumeric. As a stand-alone
application, it is an excellent program. It's not afraid of a lot of data,
either. Each sheet holds 65,536 rows and 256 columns of data, which makes for
16,777,216 cells of data to manage. I created some workbooks with all of these
cells full of data and there were no stability problems at all.
If you want
to use Gnumeric for file sharing, Gnumeric also offers a nice array of XML,
HTML, text, and even Excel import and export filters. Curiously, the
Excel formats are listed as Excel 95 on the Import and Save functions, but
Gnumeric was easily able read Excel 2000 formatted workbooks. Gnumeric read my
Excel files flawlessly and without a noticeable dip in speed.
And that's
something I kept coming back to in this application. No matter what I threw at
it, whether over-formatted Excel files or huge workbooks full of data, Gnumeric
never faltered or slowed. It's stability and speed in GNOME was excellent. It
even clipped right along in KDE, too.
At the very least, this spreadsheet application is equal to Calc or Excel in terms of
tool-sets and data management. But, frankly, I think it's better, in that this is one
very fast app to run. The Gnumeric team is to be highly commended for their work
on this program, because the quality really shows.
Gnumeric makes a very fine
addition to GNOME Office. Indeed, based on what I've seen thus far, it is
currently the crown jewel in that suite of applications. It is certainly worth a
new look if you have been away from it for a while.
Available from: http://www.gnome.org/projects/gnu
meric/
Version reviewed: Gnumeric 1.0.0-1
License: GPL
Cost:
Free
« Back: How Gnumeric Came to Be