-
All replies
-
Helpful answers
-
Oct 23, 2013 9:49 AM in response to msrodriguesby Linda Menkhorst,Luckily I can still open my documents with the old versions of Pages and Numbers, so I hope I didnt convert the wrong ones.
-
Oct 23, 2013 12:04 PM in response to msrodriguesby GreatWhiteNorthFanboy,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!
-
Oct 23, 2013 7:54 PM in response to Jerrold Green1by habeebhashim,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.
-
Oct 24, 2013 1:08 AM in response to msrodriguesby Mattias Lindberg,I use Categories for every document I have. To catogorize by year, month or whatever!
Did an angry feedback post from the link above.
-
Oct 24, 2013 6:21 AM in response to msrodriguesby Wolfii,Hi all,
besides to leaving a feedback on the apple website, maybe you could also leave a feedback in the App store ...
-
Oct 24, 2013 7:00 AM in response to msrodriguesby BrunoOrlando,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!
-
Oct 24, 2013 2:00 PM in response to msrodriguesby webnessa,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.
-
Oct 25, 2013 8:25 PM in response to msrodriguesby jhroy,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
-
Oct 26, 2013 4:58 AM in response to GreatWhiteNorthFanboyby jhroy,Feedback form filled.
Hopefully, it'll be brought back!
JHR
MTL, QC
-
Oct 26, 2013 5:36 AM in response to jhroyby maczx,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
-
Oct 28, 2013 4:04 AM in response to msrodriguesby Knastrasa,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!
-
Oct 28, 2013 6:16 AM in response to Knastrasaby doswebdev,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.
-
Oct 28, 2013 1:31 PM in response to msrodriguesby Menno06,I really don't understand that they took it out !
(going back to the old Numbers.....)
-
Oct 29, 2013 5:57 AM in response to Menno06by tomogden,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.
- Create a new table to summarize your data.
- Add a header column with the list of categories you want to summarize.
- In the header row, add the cross referencing information you want to summarize with.
- In the cells, place SUMIFS or similar functions to generate your data.
- 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.
-
Oct 29, 2013 7:18 AM in response to tomogdenby Mattias Lindberg,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.
