February 22, 2019

The StartX Files: Gnumeric 1.0 Proves Stable and Fast - page 3

How Gnumeric Came to Be

  • January 7, 2002
  • By Brian Proffitt

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

Most Popular LinuxPlanet Stories