What has been lost in Numbers 3.0 upgrade?

Hard to say without specifics. Pivot tables can be really convenient to extract and display data.

But I understand the sorting behavior in Numbers 3 is closer to Excel than the old Numbers was. So if you're having a problem with sorting in Numbers 3 the chances are you will see the same behavior in Excel too, which may not be what you want.

SG

You're right. Sadly I'm disappointed... not all people use documents just in the cloud and on a screen. Some of us need to print real world invoices, and for me page layout view is a big miss!

Please Apple... some of us just like to see how a page will look before going to print.

It's back to Numbers '09 for me!

How to get back all the features of Pages 4.3

Go to Finder -> Applications.

Check if folder iWork ’09 is present and it has underneath it Numbers.app, Numbers.app and Pages.app

Before starting these apps take note that you will be asked to update them, do not do this.

If you start them you should find that they are version 4.3 for Pages, Numbers 2.3, Numbers 5.3.

So you are almost good to go, al the features that have been deleted in the new version are restored.

To prevent accidentally starting the wrong version it is best to delete the new version, you will keep a version in the app store.

Deleting Keynote, delete following files:

~/Applications/Keynote.app

~/Library/Preference/com.apple.iWork.Keynote.LSSharedFileList.plist

~/Library/Preference/com.apple.iWork.Keynote.LSSharedFileList.plist.lockfile

~/Library/Preference/com.apple.iWork.Keynote.plist

~/Library/Preference/com.apple.iWork.Keynote.FDD243F-9456-561F-8CC1-D2A25C47016. plist

~/Library/Caches/com.apple.helpd/Generated/com.apple.iWork.Keynote.help

~/Library/Caches/com.apple.helpd/Generated/com.apple.iWork.Keynote.remote.help

~/Library/Saved Application State/com.apple.iWork.Keynote.savedState

Deleting Numbers, delete following files:

~/Applications/Numbers.app

~/Library/Preference/com.apple.iWork.Numbers.LSSharedFileList.plist

~/Library/Preference/com.apple.iWork.Numbers.LSSharedFileList.plist.lockfile

~/Library/Preference/com.apple.iWork.Numbers.plist

~/Library/Preference/com.apple.iWork.Numbers.FDD243F-9456-561F-8CC1-D2A25C47016. plist

~/Library/Caches/com.apple.helpd/Generated/com.apple.iWork.Numbers.help

~/Library/Caches/com.apple.helpd/Generated/com.apple.iWork.Numbers.remote.help

~/private/var/folders/2j/v7g55k2n7p74gd9jyxyw3c5r0000gn/C/com.apple.iWork.Number s

~/private/var/folders/2j/v7g55k2n7p74gd9jyxyw3c5r0000gn/T/com.apple.iWork.Number s

~/Library/Saved Application State/com.apple.iWork.Numbers.savedState

~/Library/Containers/com.apple.iWork.Numbers

Deleting Pages, delete following files:

~/Applications/Pages.app

~/Library/Preference/com.apple.iWork.Pages.LSSharedFileList.plist

~/Library/Preference/com.apple.iWork.Pages.LSSharedFileList.plist.lockfile

~/Library/Preference/com.apple.iWork.Pages.plist

~/Library/Preference/com.apple.iWork.Pages.plist.lockfile

~/Library/Preference/com.apple.iWork.Pages.FDD243F-9456-561F-8CC1-D2A25C47016.pl ist

~/Library/Caches/com.apple.iWork.Pages

~/Library/Caches/com.apple.helpd/Generated/com.apple.iWork.Pages.help

~/Library/Caches/com.apple.helpd/Generated/com.apple.iWork.Pages.remote.help

~/private/var/folders/2j/v7g55k2n7p74gd9jyxyw3c5r0000gn/C/com.apple.iWork.Pages

~/private/var/folders/2j/v7g55k2n7p74gd9jyxyw3c5r0000gn/T/com.apple.iWork.Pages

~/Library/Saved Application State/com.apple.iWork.Pages.savedState

~/Library/Containers/com.apple.iWork.Pages

If you can’t find all these files, the .app files are the ones that matter.

Conditional Highlighting Rules have been changed. In iWork '09 I was able to add highlighting rules on the condition of another cell's contents, now I can only add rules for the current selected cell's contents.

Steve Steve Steve !!

We all miss you here !!!

Look at these idiots at Apple... they have screwed the iWork !! 😠

Adding to the list :

• self-referential cell no longer allowed - for example : A1 = some_to_other_cell / NBVAL(A1:A10 )
• don't know the exact translation : mark a row / column to be moved ( cmd-shift-X / cmd-shift-V ) ...still possible via drag and drop, but not via menu or keyboard shortcut => slow on the same page, impossible between pages.
• page / tables navigation - was super useful to reorganise tables between pages + to simply comprehend the logic of the documents - now hidden in the navigation menu at the top.
• list of formulas in a given page...come in handy when analysing complex tables

Missing Features :

• a context panel for formulas ( as the format / filter panel [ inspector ] ) or a magic key : This one of the strength of Numbers - rapidly visualizing on what cells the current one depends on => it could be nice to have the reverse : highlight the cells that depends on the current one ( ? option clicking on the current cell would dim “ancestors” and highlight “descendants” ? ) + a clickable list of ancestors / descendants on the right panel when a new “formula inspector” is chosen.
• cells in formula bar should a least be clickable to allow a quicker navigation between cells
• with the format inspector / panel shown, clicking on a function name in a formula should select this function in the function list and not the ABS function.

EM,

Might be a good idea to post your Pages 5 removal instructions in the Pages Discussion area.

Jerry

I have found that the new Numbers creates a problem for me with respect to page margins. I need to be able to print a multi page table maintaining a margin to allow for three hole punching the pages for binding purposes.

I can not find any easy way to do this at all.

M,

You could possibly use a Ruler Guide to run a line down the left edge for alignment.

Jerry

Yes, they've removed the 'print view'. Appaling!

I have noticed that you can still open iwork 09 and use the previous version of pages and numbers.

Jacodb wrote:

Conditional Highlighting Rules have been changed. In iWork '09 I was able to add highlighting rules on the condition of another cell's contents, now I can only add rules for the current selected cell's contents.

Jacob, it works for me. When you click inside the field to enter your criteria, click on the little blue button to the right. Then you can select a cell. However, you can't enter formulas.

Ok Then ... can someone can give me a way to get back to my 09 version of iworks as I deleted my numbers 2 and can't stand the 3 version without the autofill ...

thanks for your help

One addition that I haven't seen mentioned (though, in fairness, I also haven't read all nine pages):

Numbers 2.3 had a feature I *loved* that let you use formulas to define the range for a chart. I used this on several charts in my biggest spreadsheet that were pulling data from the same table - one chart looked at a number of variables by month, another by season, and another by year. You could set the X-axis values by something using an INDIRECT formula and reference rows corresponding to the first and last dates for that range. It was awesome, and very useful.

I dont know why they would have taken it away - it wasnt a feature that "confusing" to your average user, because unless you spontaneously decided to try programming the chart you wouldnt even see it was there. But in it's absence, I've had to create three copies of the table referenced, which is quite frustrating.

Adding missing feature: When expanding a filtered list, the tables underneath don't move down. Result: overlapping tables. If you have transparent tables, you get an instant mess.

Well said, I can't agree more. I'll be right behind you. Numbers is the only thing that I need my Mac for. I really don't want to try and do what I do on Office (I think I'd have to use Adobe too), but the bullet may be bitten very soon.