Golfing Andy
Level 1 (0 points)

Q: I want to reload numbers 09

I loaded Numbers 3.0 and don't like it, you can not sort multiple fields. I need to go back to 09

iMac (27-inch Mid 2011), OS X Mavericks (10.9)

Posted on Nov 24, 2013 1:29 PM

Close
Golfing Andy

Q: I want to reload numbers 09

  • All replies
  • Helpful answers

Previous Page 2

  • by SGIII,Helpful

    SGIII SGIII Nov 24, 2013 8:28 PM in response to Golfing Andy
    Level 6 (10,796 points)
    Mac OS X
    Nov 24, 2013 8:28 PM in response to Golfing Andy

    Hi Andy,

     

    I duplicated your setup here, and can reproduce the strange occurrence of 0's sorting to the bottom.

     

    Here's how I corrected it.  I added a new body row above row 4, and copied the Players, Playing, Handicap etc into that new body row.

     

    I then deleted all three green Header Rows.

     

    Then I converted the body row with the Players, Playing, etc. to a Header Row (via the triangle contextual menu on the left by the row number).

     

    I then added Header Rows above that (again via the contextual menu).  But no merged cells! They can cause strange problems in a table, not just in Numbers 3.  I believe that can happen in Numbers 2 as well.  Put Crow Creek in a text box instead or make it your table name (which you can style with bigger font) and put July in a cell.

     

    And generally you're probably better off without a blank Header Row just above the body rows.

     

    After those changes the sort works as expected on my machine.

     

    SG

  • by Golfing Andy,

    Golfing Andy Golfing Andy Nov 25, 2013 4:53 AM in response to SGIII
    Level 1 (0 points)
    Nov 25, 2013 4:53 AM in response to SGIII

    thanks for all the help and time you spent on this. I think I will go back to version 2 until this is fixed, I have 12 spreadsheet that I would have to rework and don't see any advantage in 3 for what I'm doing.

  • by SGIII,

    SGIII SGIII Nov 25, 2013 5:15 AM in response to Golfing Andy
    Level 6 (10,796 points)
    Mac OS X
    Nov 25, 2013 5:15 AM in response to Golfing Andy

    Hi Andy,

     

    Whichever works best for you. Numbers 2 is better if you need to print. Numbers 3 is better if you want to display on an iPad or put the spreadsheet online for others to look at and download.

     

    If you go back to 2 I'd be sure to clean up the spreadsheets anyway, as described. Merged cells are trouble. And I suspect Numbers isn't designed to expect a blank header row just above the body cells. You may have just been lucky it's been working. You can achieve the same look easily in other ways.

     

    SG

Previous Page 2