Previous 1 7 8 9 10 11 Next 289 Replies Latest reply: Jul 25, 2014 9:56 AM by fitopia Go to original post Branched to a new discussion.
  • Hymercar322 Level 1 Level 1 (0 points)

    Thanks SG I will try it in Excel, but that will be on the morrow now. Would I be right in thinking that if it doesnt work as described I would achieve the result I want with pivot tables in Excel?

  • SGIII Level 5 Level 5 (6,610 points)

    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

  • maxximus Level 1 Level 1 (5 points)

    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!

  • E_Mertens Level 1 Level 1 (5 points)

    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.

  • Jacodb Level 1 Level 1 (0 points)

    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.

  • Milindrode Level 1 Level 1 (0 points)

    Steve Steve Steve !!

     

    We all miss you here !!!

     

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

  • solariane Level 1 Level 1 (0 points)

    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.
  • Jerrold Green1 Level 7 Level 7 (29,945 points)

    EM,

     

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

     

    Jerry

  • medelegant Level 1 Level 1 (0 points)

    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.

  • Jerrold Green1 Level 7 Level 7 (29,945 points)

    M,

     

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

     

    Jerry

  • Rhodesb3 Level 1 Level 1 (0 points)

    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.

  • papalapapp Level 1 Level 1 (80 points)

    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.

  • Bbenelux Level 1 Level 1 (0 points)

    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

  • sitryd Level 1 Level 1 (5 points)

    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.

  • papalapapp Level 1 Level 1 (80 points)

    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.

Previous 1 7 8 9 10 11 Next