Categories
Blog News

Apple iWork updates : Numbers becomes slightly more useful

Some new iWork updates this morning on my Mac Mini : KeyNotes, Pages and Numbers can now save password protected documents, can now display charts based on time series, more compatibility with MS Office Documents.

iOs Keynote Apps have received similar updates.

You can now do some things with Numbers that Office Excel already can since ages : sort on multiple columns, chart on time series… Progress!

All in all a good update, but frankly, this is late in coming, and the updates should continue coming to get even more functionality in there. I understand that this is a from-the-ground-up-rewrite, but these functionalities are what people expect from the start, not delivered 6 months or more waiting for it.

Now if only with the new version I could figure out how to updating an existing chart line with a new entry that is in the same column as 4 other chart lines…

I have one column of numbers that has a monthly entry for each measurement. Multiple years in one column. I want to graph each year in this column separately. This works, but when I add a new monthly measurement at the end of the column and try to update the appropriate graph line, this results in a mess of graph lines.

So far, I haven’t found it, except redoing the whole thing from scratch. Somehow I expected a more intuitive process on doing this, but perhaps my intuition is failing me on this, or I have been brainwashed too much by Excel 🙂

Also, what is really bothering me is importing a csv file that has “,” separated values instead of “;” separated values. This results in the whole line being imported into the first cell, as Numbers expects “;” for csv. Nothing else.

I can’t even *FIND* the “import” command, you can only OPEN a CSV file in the regular way, and there are no options possible to indicate HOW you want to open the file / import it. Very disappointing.

Apple, please keep the updates coming, and make Numbers something worthwhile to use. Meanwhile, I have to write little scripts to do my work for me.