msrodrigues

Q: No more categories in numbers 3.0?

I have a worksheet full of categories. Now I have a bunch o useless tables.

OS X Mavericks (10.9)

Posted on Oct 22, 2013 8:57 PM

Close

Q: No more categories in numbers 3.0?

  • All replies
  • Helpful answers

Previous Page 2 of 6 last Next
  • by Linda Menkhorst,

    Linda Menkhorst Linda Menkhorst Oct 23, 2013 9:49 AM in response to msrodrigues
    Level 1 (4 points)
    Oct 23, 2013 9:49 AM in response to msrodrigues

    Luckily I can still open my documents with the old versions of Pages and Numbers, so I hope I didnt convert the wrong ones.

  • by GreatWhiteNorthFanboy,

    GreatWhiteNorthFanboy GreatWhiteNorthFanboy Oct 23, 2013 12:04 PM in response to msrodrigues
    Level 1 (4 points)
    iPhone
    Oct 23, 2013 12:04 PM in response to msrodrigues

    Since this discussion topic now has a second page, I'm restating the following:

    Please request that Categories be restored to Numbers 3.0 via the Numbers Feedback site. Thanks!

  • by habeebhashim,

    habeebhashim habeebhashim Oct 23, 2013 7:54 PM in response to Jerrold Green1
    Level 1 (0 points)
    Oct 23, 2013 7:54 PM in response to Jerrold Green1

    Opt-Arrow was always my method to add rows or column. In a newly created v3 file, it works as before. In ver 2 files, adding rows only works on some files.

     

    In ver 2 files which had Categories, its completely greyed out. No keyboard shortcut. No right click mouse. No Menu bar option. No chance to add row at end of table or in between. But adding columns isn't a problem anywhere...

     

    I gave up trying to work around the problem after 3 hours. Recovered the old apps using Time Machine. Used file versioning to revert back to old files before they were "destroyed" by ver 3.

  • by Mattias Lindberg,

    Mattias Lindberg Mattias Lindberg Oct 24, 2013 1:08 AM in response to msrodrigues
    Level 1 (15 points)
    Oct 24, 2013 1:08 AM in response to msrodrigues

    I use Categories for every document I have. To catogorize by year, month or whatever!

     

    Did an angry feedback post from the link above.

  • by Wolfii,

    Wolfii Wolfii Oct 24, 2013 6:21 AM in response to msrodrigues
    Level 1 (5 points)
    Oct 24, 2013 6:21 AM in response to msrodrigues

    Hi all,

     

    besides to leaving a feedback on the apple website, maybe you could also leave a feedback in the App store ...

  • by BrunoOrlando,

    BrunoOrlando BrunoOrlando Oct 24, 2013 7:00 AM in response to msrodrigues
    Level 1 (0 points)
    Oct 24, 2013 7:00 AM in response to msrodrigues

    They've probably simplified / cut a some features to integrate the iOS + OS platforms...

    I was taken aback by this new positioning, and CATEGORIES was by far the thing I needed the most...

     

    Another feature that no longer exists: Links!

     

    On iWork 09 when you cut a table from Numbers and Paste it on Keynote or Pages, it was referenced to the original numbers file.

     

    It was a pretty powerful feature and I miss that as well!

  • by webnessa,

    webnessa webnessa Oct 24, 2013 2:00 PM in response to msrodrigues
    Level 1 (4 points)
    Wireless
    Oct 24, 2013 2:00 PM in response to msrodrigues

    Uuuugh, Apple... what were you thinking!!! Categories were one of the many, but perhaps the best, reason for not using Microsoft. So far, not impressed at all with the new suite. Sending feedback to Apple.

  • by jhroy,

    jhroy jhroy Oct 25, 2013 8:25 PM in response to msrodrigues
    Level 1 (4 points)
    Wireless
    Oct 25, 2013 8:25 PM in response to msrodrigues

    I teach journalism.

     

    I used to teach Numbers along with Excel (and OpenOffice Calc too), mentioning that Categories were much simpler to use than Pivot Tables.

     

    But with the Categories features stripped out of Numbers 3.0, there is no need to mention Numbers to my students. I'll recommend that they DO NOT buy it, since it is now useless for what journalists need to do with a spreadsheet.

     

    Jean-Hugues Roy

    École des médias

    Université du Québec à Montréal

  • by jhroy,

    jhroy jhroy Oct 26, 2013 4:58 AM in response to GreatWhiteNorthFanboy
    Level 1 (4 points)
    Wireless
    Oct 26, 2013 4:58 AM in response to GreatWhiteNorthFanboy

    Feedback form filled.

    Hopefully, it'll be brought back!

    JHR

    MTL, QC

  • by maczx,

    maczx maczx Oct 26, 2013 5:36 AM in response to jhroy
    Level 1 (0 points)
    Oct 26, 2013 5:36 AM in response to jhroy

    If there is functionality missing in Numbers 3.0 that you really miss can I suggest besides submitting feedback that people submit a product rating/review via the App Store

  • by Knastrasa,

    Knastrasa Knastrasa Oct 28, 2013 4:04 AM in response to msrodrigues
    Level 1 (0 points)
    Oct 28, 2013 4:04 AM in response to msrodrigues

    Yes this is one of a few disastrous choices in the new version. Embarrasing.

     

    I quote: Message to everyone who views this: Please request that Categories be restored to Numbers 3.0 via the Numbers Feedback site. Thanks!

  • by doswebdev,

    doswebdev doswebdev Oct 28, 2013 6:16 AM in response to Knastrasa
    Level 1 (10 points)
    Oct 28, 2013 6:16 AM in response to Knastrasa

    Less is not always more.

     

    There are some functions that should never be removed without a viable replacement. This one is so basic to business spreadsheet use that it will be utterly impossible for anyone to take iWork seriously without it.

     

    I don't care if Apple kills Categories, but please, please replace it with pivot tables or something that lets us aggregate data.

  • by Menno06,

    Menno06 Menno06 Oct 28, 2013 1:31 PM in response to msrodrigues
    Level 1 (0 points)
    Oct 28, 2013 1:31 PM in response to msrodrigues

    I really don't understand that they took it out !

    (going back to the old Numbers.....)

     

     

     

     

  • by tomogden,

    tomogden tomogden Oct 29, 2013 5:57 AM in response to Menno06
    Level 1 (0 points)
    Oct 29, 2013 5:57 AM in response to Menno06

    I suspect Categories was removed because the Categories feature was hindering the use of the functions that were designed to provide the same functionality in a cleaner, richer, more flexible way.

     

    The proper method is to use the SUMIFS, the COUNTIFS and the AVERAGEIFS functions and others like them to build your pivot tables.

     

    1. Create a new table to summarize your data.
    2. Add a header column with the list of categories you want to summarize.
    3. In the header row, add the cross referencing information you want to summarize with.
    4. In the cells, place SUMIFS or similar functions to generate your data.
    5. Make sure to check the "Preserve Collumn" option for each argument in the formula and the "Preserve Row" option where it references your header row.

     

    See this example.

    Screen Shot 2013-10-26 at 1.06.22 PM.png

  • by Mattias Lindberg,

    Mattias Lindberg Mattias Lindberg Oct 29, 2013 7:18 AM in response to tomogden
    Level 1 (15 points)
    Oct 29, 2013 7:18 AM in response to tomogden

    1) You can do that in old Numbers too, can't you?

    2) Does this in any way replace a row with a flip up/down functionality?

     

    Example: A list of transactions categorized by month for easy overview.

Previous Page 2 of 6 last Next