Apple iWork 08 Provides

By Tiffany Maleshefski  |  Posted 2007-08-17 Print this article Print

Simple But Solid Spreadsheet App"> With each intelligent table, I could tweak column sizes, add and delete rows, and do pretty much anything I was able to do within the main spreadsheet. The end result was like having five different spreadsheets on one. Still, I did have trouble splitting rows, one of the features that should have allowed me to select a row of cells and then divide those in half horizontally. I also had a hard time getting the programs borders feature to work. For example, I tried several times to add a red border to one columns left edge. Though the red border did appear, the effect caused the column to lose its grid lines, something I wasnt able to get back, even after consulting Numbers Help function.
To read more about the desktop territory gained by iWork, click here.
I also had a hard time figuring out how to replicate a few of the de-sign elements from my Excel spreadsheet into Numbers. That said, Numbers pre-designed templates are very handy and applicable to both enterprise and consumer users. Unlike other templates Ive worked with, where I have felt that much of the design was irrelevant or overly complicated, the templates in Numbers strike the right balance of structure and flexibility. I also really liked the programs Chart function, which allowed me to select an area of information within the spreadsheet—say, from one of the intelligent tables. Then, by simply choosing a chart design, I could organize and sort the information into a pie chart or a bar graph. From there, I was able to further customize the charts look by selecting certain colors, lighting style and axis position. Numbers import and export functions didnt fare as well. When I used Numbers to open an Excel file created in Office 2003, the page dynamics didnt translate from Excel to Numbers. The Excel spreadsheet header converted incorrectly, and information such as date and title was rearranged differently. I next exported a file I created in Numbers. Users can export files as either a PDF or an Excel file. When I ex-ported the file as a PDF and then opened the file in Acrobat 7.0, the formatting of the original file stayed intact. However, when I attempted to export the Numbers-created file to Excel, a window notified me (and Im quoting exactly here) that an error had occurred and listed the following issues: Table names were hidden because Excel doesnt support displaying them on canvas; header and footer cells were exported as body cells, but will look the same; couldnt export pop-up menus because they arent supported in Excel (cell values were exported); and couldnt export shadow on text charts. When I then opened this exported file in Excel 2003, the tables that appeared on one spreadsheet in Numbers were now distributed over three separate Excel spreadsheets, which made for a confusing file. Technical Analyst Tiffany Maleshefski can be reached at Check out eWEEK.coms for the latest news, reviews and analysis about productivity and business solutions.


Submit a Comment

Loading Comments...
Manage your Newsletters: Login   Register My Newsletters

Rocket Fuel