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.
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:
~/Library/Saved Application State/com.apple.iWork.Keynote.savedState
Deleting Numbers, delete following files:
~/Library/Saved Application State/com.apple.iWork.Numbers.savedState
Deleting Pages, delete following files:
~/Library/Saved Application State/com.apple.iWork.Pages.savedState
If you can’t find all these files, the .app files are the ones that matter.
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.
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.
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.