Previous 1 2 3 Next 289 Replies Latest reply: Jul 25, 2014 9:56 AM by fitopia Branched to a new discussion.
sjlawton Level 1 Level 1

Has anyone got a list of features that has been lost in the new version of Numbers?

 

I am aware (and disappointed) that the useful Categories feature has gone (I have requested this feature back on relevant Apple page). I think I also saw that Print view had disappeared.

 

What else has gone? I make extensive use of filtering and sorting - if those features have been watered down then I think I may not bother updataing.

 

Thanks in advance,

 

Simon.


MacBook Pro (15-inch Mid 2010), OS X Mavericks (10.9)
Solved by Jerrold Green1 on Oct 24, 2013 8:52 AM Solved

Here's my updated list. I'd really appreciate it if anyone who knows how to do the things in this list with Version 3 would reply with an explanation. I checked all these reports out as well as I could, but I certainly could have missed something.

 

J.

 

Function or feature or issue

 

Reorganize Panel gone, no multi-level sort.

 

Categories View gone

 

References now don’t follow sorted rows as they did before.

 

Table Fills are not supported

 

German user can’t use decimal points from numeric keypad.

 

Split Cells is gone

 

Sheet View seems to be the only view available during editing. Page view only available in the Print dialog.

 

Page Headers and Footers are gone

 

Edit Toolbar (add, delete, rearrange tool icons) is gone.

 

Scatter Charts no longer can accept Dates on X axis

 

Dates can’t be used for X-Axis values in Scatter Charts

 

Custom Formats gone

 

Ability to set margins gone

 

Cell border custom line weight is sometimes lost when using Filter Rows

 

Ability to sort selected rows is gone

 

Header text is used in cell references and you can’t turn this “feature” off

 

Can’t set Page Margins; they default to about 1” all around

 

Formula Bar is gone, replaced by a field at the bottom of the Numbers window in which the expression is displayed but can not be edited

 

Graphics Inspector no longer treats a Table as an Object that can be formatted by the Graphics Inspector tools

 

Comments only display as Tool Tips now, can’t be static displays

 

Can’t open Numbers 08 documents

Reply by Jerrold Green1 on Oct 23, 2013 7:43 AM Helpful

SJ,

 

Here's my list as of 10:30 EDT:

 

Function or feature or issue

 

Reorganize Panel gone

 

Categories View gone

 

References now don’t follow sorted rows as they did before.  (Now like Excel)

 

Table Fills not supported

 

German user can’t use decimal point from numeric keypad.

 

Split Cells is gone

 

Sheet View seems to be the only view available during editing. Page view only available in the Print dialog.

 

Page Headers and Footers are gone

 

Edit Toolbar (add, delete, rearrange tool icons) is gone.

 

That's it from here at this time, but I think I have just scratched the surface. Would love to hear from others who are keeping a list.

 

Jerry

Reply by Barry on Oct 23, 2013 10:14 AM Helpful

Hi Simon,

 

VLOOKUP examines the data in cells, not the cell address. Logically, that should continue to work. The only use of cell addresses in VLOOKUP is in specifying the range of cells containing the lookup table. Placing the lookup table on a separate table, and specifying the range using only the column addresses should remove any likelihood of failure due to a sort.

 

Regards,

Barry

 

Note: I have not yet migrated to Mavericks/Numbers 3.0.

All replies

  • Jerrold Green1 Level 7 Level 7

    SJ,

     

    Here's my list as of 10:30 EDT:

     

    Function or feature or issue

     

    Reorganize Panel gone

     

    Categories View gone

     

    References now don’t follow sorted rows as they did before.  (Now like Excel)

     

    Table Fills not supported

     

    German user can’t use decimal point from numeric keypad.

     

    Split Cells is gone

     

    Sheet View seems to be the only view available during editing. Page view only available in the Print dialog.

     

    Page Headers and Footers are gone

     

    Edit Toolbar (add, delete, rearrange tool icons) is gone.

     

    That's it from here at this time, but I think I have just scratched the surface. Would love to hear from others who are keeping a list.

     

    Jerry

  • sjlawton Level 1 Level 1

    Thanks Jerrold - here's me thinking that new versions improved old ones...

     

    Perhaps you can help with a couple of supplementary questions:

     

    1. I have a spreadsheet that needs filters. I.e. "Show rows that match any of the following"; Column A is True; Column B is Not Blank.

     

    Can you still do this?

     

    Also, I have another spreadsheet that makes extensive use of references to cells in tables on the same sheet and on different sheets. These tables are regularly resorted. I'm concerned about your comment that references don't follow sorted rows. If a cell is referenced by Column name:: Row name (so sales:: 'UK' :: 'Product type' as opposed to just referencing B2, for example) will those references be preserved after a sort? I have an awful lot of VLOOKUP functions that use this approach.

     

    Thanks again,

     

    Simon.

  • Barry Level 7 Level 7

    Hi Simon,

     

    VLOOKUP examines the data in cells, not the cell address. Logically, that should continue to work. The only use of cell addresses in VLOOKUP is in specifying the range of cells containing the lookup table. Placing the lookup table on a separate table, and specifying the range using only the column addresses should remove any likelihood of failure due to a sort.

     

    Regards,

    Barry

     

    Note: I have not yet migrated to Mavericks/Numbers 3.0.

  • SGIII Level 6 Level 6
    expertise.macosx
    Mac OS X

    AppleScript support gone (at least it doesn't show up in the AppleScript dictionary whereas Numbers '09 does).

     

    SG

  • msrodrigues Level 1 Level 1

    I will ad to the list: Custom format

     

    I use that a lot!

     

    I think this is all because Apple wanted to integrate all versions (iOs an OS X), but please, don't take useful features. I am very sad about this move. I actually think this version is worse than v2. The features added are less important then the features taken.

  • sjlawton Level 1 Level 1

    Thanks Barry.

     

    Agree - logically it should continue to work. Still a bit nervous about committing to an update though.

     

    I might try to install it on a second machine and test copies of my prized spreadsheets on that. If they don't work as I like can anyone tell me if it is possible to roll back to the previous version?

     

    Cheers,

     

    Simon.

  • Mississippimudd Level 1 Level 1

    Do apple developers actually use this program at home?? How is anyone supposed to move items around so they look right with out a page view that allows you to actually see how it is going to look before you actually go into print view.... This is stupid.

  • SGIII Level 6 Level 6
    expertise.macosx
    Mac OS X

    Ability to place an image into the background of a table cell appears to be gone.

     

    SG

  • Linda Menkhorst Level 1 Level 1

    numbers 5 is installed next to 4.3, so you will have both, but make sure you keep an original version of your document, so you can continue with 4.3

  • SGIII Level 6 Level 6
    expertise.macosx
    Mac OS X

    Correction. After a few tries got the image into the cell.

     

    SG

  • papalapapp Level 1 Level 1
    expertise.iwork
    iWork

    Lost features (or I can't find them any more)

     

    • The formula input-bar
    • Table background fill (new is text background fill, but it won't convert from '09 documents)
    • OS X Spotlight infos (same warning as if you opened it on the iPhone)
    • No more table styles (only 6 built-in ones)
    • Print Layout view mode
    • No custom colour filling for cells  (only pre-defined colours, can't use your own colours)

     

    On the upside, Numbers now supports text styles. Yay.

  • SGIII Level 6 Level 6
    expertise.macosx
    Mac OS X

    And also on the upside Numbers now supports bubble charts and sharing, just what I was yearning for!

     

    Well, it's a little of the "you get what you pay for" syndrome, I guess. No wonder they didn't want to charge us existing users to "upgrade." The bet probably is that the new users coming in via iOS or new Macs won't much miss many Numbers features they didn't know were there before anyway.  Meanwhile, we've still got the old version, which seems to run quite happily right alongside the new. Best of both worlds?

     

    SG

  • Jerrold Green1 Level 7 Level 7

    Yea, Bubble Charts, that's what I've been waiting for. I just didn't know it.

     

    Jerry

  • SGIII Level 6 Level 6
    expertise.macosx
    Mac OS X

    And you probably didn't know you really, really wanted those iOS-style concave function names and closing "crescent moons" as Barry dubbed them in a recent thread.  The floating formula input area has to be "dragged wider" just about every time I want to take off the "training wheels" and just type in a formula. I see the formula is displayed down at the bottom of the page. But unlike the old formula bar up top, it's off limits to editing. But, really, what lovely concavities and crescent moons! Who wants mere parentheses when you can have those?

     

    SG

Previous 1 2 3 Next