iWork 09 [MAC] full review
In August 2007, Apple’s iWork productivity suite gained a new stablemate—Numbers, a new take on the traditional spreadsheet application. In our review of iWork ’08, we found it to be easy to use with an elegant interface, but suffering from some limited graphing options, slow speed with large spreadsheets, and lack of AppleScript support.
Tuesday’s release of iWork ‘09 jumps Numbers’ version number up to 2.0, and brings a slew of new features to Apple’s alternative to Microsoft Excel. The first thing you’ll notice when launching Numbers ’09 is that the template chooser is now displayed against a pitch black background, instead of the prior version’s neutral gray.
Once your eyes adjust to this bold change, you’ll find that there are 12 new templates to pick from, including nine in a brand-new Personal Finance category. These new templates cover everything from budgeting to net worth to tracking your weight loss.
Also new in the theme chooser is a simple theme preview function—as you mouse over each image in the theme chooser, you’ll see samples of the theme’s spreadsheet and chart layout.
The new template chooser
One of the features that I found difficult to use in Numbers ’08 was the formula creation tool. When you inserted a formula using the tool, it would be inserted with word placeholders, as in =DATE(year, month, day). You would then have to erase the word placeholders before entering a value (cell pointer or fixed value).
In the new version of Numbers, the variables in the formula appear in colored circles, as seen in the image at right. To replace a variable with a value or cell reference, click once on the variable to make it active, then either type a value or click in a cell on the table to insert a cell reference. This makes formula entry much simpler—which is a good thing, as Numbers now has over 250 functions to choose from.
There’s also a very convenient Formula List button on the toolbar that will display every function on your tables. For each function, you can see its location, results, and formula. You can even search this list, and do find-and-replace operations on the formulas.
Charting, one of the areas called out in our initial review, is greatly improved in Numbers 2.0. There’s a new mixed chart format that allows you to overlay one data set on another in the same graph (i.e. a line graph on a bar chart), as well as a two-axis chart for graphing data with differing units and/or scales on one graph. You could, for instance, plot both rainfall amounts and wind speed over time on one graph, with differing axes for each data set.
Scientists and financial types will welcome the ability to add trend lines (using one of six different fitting equations) and error bars (positive, negative, or both, using four pre-defined types or your own custom settings) to their graphs—this was a key shortcoming of charts in the 1.0 version of Numbers.
While Numbers still doesn’t support pivot tables, a common method of working with tabular data available in most every other mainstream spreadsheet application, Numbers ’09 adds a feature Apple calls Table Categories. Table Categories provide much of the power of pivot tables, while bypassing most of the complexity of setting up pivot tables. You can create categories and sub-categories for your columnar data (group by state, then by product type), and easily reorder the tables (group by product type first, then state) with a couple of mouse clicks.
Another welcome change in Numbers ’09 is the ability to link live Numbers’ charts in Pages and Keynote documents—a linked chart can be updated with a simple button click (though the process is manual, not automatic). Unfortunately, you can’t embed raw tabular data, just charts. Finally, AppleScript support has been added, so you can now do things like (for example) take the selection from a Numbers table and turn it into a Keynote bullet slide, all via AppleScript.