Skip navigation

What has been lost in Numbers 3.0 upgrade?

36819 Views 288 Replies Latest reply: Jan 2, 2014 10:31 AM by Zzyzx239 RSS Branched to a new discussion.
  • BrianSince84 Calculating status...
    Currently Being Moderated
    Oct 26, 2013 10:01 AM (in response to Dirwrecktor)

    Thanks - I got it to work.

     

    The key is the image is a Fill, not Data, in the cell

     

    Copy and paste works if you select a cell, BUT, do not click  it as if you were going to edit the contents.  If you do that, it doesn't work.

     

    There is a new image Fill set of formating tools.

     

    Also, the table that got trashed was in Pages, not Numbers - sorry.

  • Jeanrene Bouvier Calculating status...
    Currently Being Moderated
    Oct 27, 2013 2:19 AM (in response to sjlawton)

    Is there a way to complain to Apple in an official way?

  • mombasadon Level 1 Level 1 (0 points)
    Currently Being Moderated
    Oct 27, 2013 2:35 AM (in response to Jeanrene Bouvier)

    Jeanrene,

     

    Go here...

     

    http://www.apple.com/feedback/numbers.html

     

    Regards,

     

    Don

  • Jeanrene Bouvier Level 1 Level 1 (0 points)
    Currently Being Moderated
    Oct 27, 2013 2:39 AM (in response to mombasadon)

    Thanks !

  • papalapapp Level 1 Level 1 (70 points)
    Currently Being Moderated
    Oct 27, 2013 4:11 AM (in response to sjlawton)

    We should also add that you can't sort selected rows but only the entire table or nothing.

  • SGIII Level 4 Level 4 (3,290 points)
    Currently Being Moderated
    Oct 27, 2013 5:49 AM (in response to papalapapp)

    papalapapp wrote:

     

    We should also add that you can't sort selected rows but only the entire table or nothing.

     

    Hi papalapp,

     

    With a combination of filters and sort you can do pretty well, though, to get different views of your data.

     

    Screen Shot 2013-10-27 at 8.39.50 AM.png

     

    Screen Shot 2013-10-27 at 8.40.18 AM.png

     

    SG

  • Jerrold Green1 Level 7 Level 7 (28,135 points)
    Currently Being Moderated
    Oct 27, 2013 6:07 AM (in response to sjlawton)

    SJ,

     

    I've made a few corrections and additions to the list since I last posted it. The most recent item to come to my attention is the elimination of Mark for Move and Move in the Edit menu.

     

    In the past day or two the rate of discovery of "features gone missing" has slowed to a crawl and I must say that I've become a bit more comfortable with V3. You know, Necessity being the Mother of Invention as it is. Wait, maybe I'm just numb...

     

    Here's the latest update...

     

    J.

     

    Function or feature or issue

    • Applescript support seems to have been reduced; Applescript Dictionary for Numbers 3.0 hasn't been found, many Numbers 2.3 scripts don't work, but some scripts do work with Numbers 3.0
    • Can’t open Numbers 08 documents
    • Categories View gone
    • Cell border custom line weight is sometimes lost when using Filter Rows
    • Charted Dates don’t display properly when used as X-Axis values - hope this is just a bug
    • Comments can’t be repositioned
    • Comments can’t be resized
    • Comments only display as Tool Tips now, can’t be static displays
    • Contacts; Drag and Drop into Numbers from Contacts no longer supported
    • CSV file import seems to be limited to dragging a CSV file to the Numbers Dock Icon. Pasting to a table or the canvas is gone
    • Custom Formats gone
    • Share Menu is gone, and Export to PDF not longer has the option to make a PDF in Sheet View mode with no page breaks.
    • Find and Replace Results Pane is gone - was a great navigation tool
    • 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
    • Formulas and Functions user guide PDF, easily searchable, is gone, replaced by web help page
    • Graphics Inspector no longer treats a Table as an Object that can be formatted by the Graphics Inspector tools. Or, looking at it from the Table perspective, there is no way to add Shadow effect to a Table’s outline.
    • Insert > Date and Time is gone
    • Keyboard Shortcut reminders have been removed from Drop-Down Row and Column menus
    • Move and Mark for Move are gone from the Edit Menu
    • Numbers User Guide PDF is gone, replaced by web help page
    • Page Headers and Footers are gone
    • Page Margins can’t be adjusted
    • Print Preview view not available while editing
    • Pop-Up Menu Format no longer expands with a click of the Spacebar
    • QFX Financial File Exchange, bank and brokerage files, import is no longer supported
    • Reorganize Panel gone, no multi-level sort.
    • Return key option to set the behavior while editing a cell is gone
    • Show Autocompletion List in Table Columns is gone
    • Sort Selected Rows is gone
    • Sorting detector now stops cell references from following the sort movement. This loss a PLUS.
    • Split Cells is gone
    • Table Fills are not supported (that's in the table background, not the cell backgrounds)
    • Toolbar Editor(add, delete, rearrange tool icons) is gone.
  • Jeffrey Swartz Calculating status...
    Currently Being Moderated
    Oct 27, 2013 9:08 AM (in response to sjlawton)

    Wow. Numbers was well on it's way to becoming a serious business app, we use it all the time in our day to day work. But now? If they don't fix these missing features, we'll be limited to the old versions or switch over to Microsoft. Ugh.

     

    Many of Apple's design choices of late with its mobile/desktop software seem to be made in a vacuum, with little regard to prior functionality, actual user needs or competitive concerns.

  • Hymercar322 Calculating status...
    Currently Being Moderated
    Oct 27, 2013 10:53 AM (in response to sjlawton)

    Numbers 3 Sorting Ascend/Descend: this function does not work when sorting a column that contains data drawn from a row in another table. This is a retrograde step and coannot be considered and upgrade.

  • papalapapp Level 1 Level 1 (70 points)
    Currently Being Moderated
    Oct 27, 2013 11:40 AM (in response to Hymercar322)

    Wow, this is a big one. Most certainly a bug.

  • QCB Calculating status...
    Currently Being Moderated
    Oct 27, 2013 2:33 PM (in response to Jerrold Green1)

    I am just flat-out angry about this ...

     

    I have spent the last year, transition my business to All Things Mac, with MS Office being the last to go (switch from Word to Pages, from Excel to Numbers, from Powerpoint to Keynote).  This was a commitment on my part, not merely because I was already competent on MS Office, but because most of my clients use MS Office.  I was (and at least currently remain) "all in."  I have to imagine that is how Apple executives and employees and shareholders wanted it ... Loved the hardware, stayed for the software.

     

    So what in the world IS this?  It is not an upgrade ... The new iWorks software is a DOWNGRADE.  It is less useful, less intuitive, and less effective than the prior iWorks.  If I did not know better, I would think that Apple was trying to destroy these products and discourage customers from using it.

     

    It is bad, pathetic really, that the only "good news" in this entire debacle is that I was able to remove Numbers 3.0 and open my prior Numbers ... I breathed a giant sigh of relief to see my templates (with headers and sideview on all sheets and so one).  Apple, you blew it.  Read this customer's list and GET BACK TO WORK.

     

    Signed, One Angry Mac User

  • SGIII Level 4 Level 4 (3,290 points)
    Currently Being Moderated
    Oct 27, 2013 3:04 PM (in response to Hymercar322)

    Hymercar322 wrote:

     

    Numbers 3 Sorting Ascend/Descend: this function does not work when sorting a column that contains data drawn from a row in another table.

     

    Are you sure about this?

     

    Table 1 here is drawing data from data in table 2:

    Screen Shot 2013-10-27 at 5.48.19 PM.png

     

     

    I sort:

    Screen Shot 2013-10-27 at 5.48.45 PM.png

     

    This is the result:

    Screen Shot 2013-10-27 at 5.49.18 PM.png

    And if you've got cells with relative references, sorting now seems to behave exactly like Excel.

     

     

    SG

  • Sorcerous Calculating status...
    Currently Being Moderated
    Oct 27, 2013 3:41 PM (in response to sjlawton)

    I used the previous version and it was pretty good. v3 I dont understand why they dumbed it down and took out most of the features. Maybe Apple doesnt want to support this anymore, and its now an oppportunity for someone to create a Mac spreadsheet.

  • Hymercar322 Level 1 Level 1 (0 points)
    Currently Being Moderated
    Oct 27, 2013 4:06 PM (in response to SGIII)

    Agree that your example works but that is only sorting in columns across tables.  I am totalling across a table so the totals appear in a row. I am then setting up a second table where the totals are listed by referencing the relevant cell so the totals appear in a column which I then wish to rank. This worked fine in previous numbers but fails in numbers 3

  • SGIII Level 4 Level 4 (3,290 points)
    Currently Being Moderated
    Oct 27, 2013 4:12 PM (in response to Hymercar322)

    Hi Hymercar,

     

    My guess is you're using relative referencing and have run afoul of the fact that Numbers 3.0 behavior has been changed to more closely match that of Excel.

     

    If you can give me a simple example I'll check it out in Excel (assuming you don't have Excel there).

     

    SG

1 ... 6 7 8 9 10 ... 20 Previous Next

Actions

More Like This

  • Retrieving data ...

Bookmarked By (7)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.