Q: Cómo crear categorías de tablas

Categories View is not supported in Version 3.0.

Jerry

#@&$!  What!  Column categorization was what made Numbers so unique and extremely powerful.  This is a terrible miss on Apple.  I'm not happy at all. 

Quite a few features have gone missing in the redesign.

Here's my current list...

Jerry

1. Applescript support has been greatly reduced (To be improved by  May 2014 - full restoration not mentioned)
2. Automatic Format does not recognize YYYY-MM-DD as a date input.
3. Can’t open Numbers 08 documents
4. Categories View gone
5. Cell border custom line weight is sometimes lost when using Filter Rows
6. Character Styles are limited to 7, no way to create more. (There is a plus-button but it is inactive)
7. Charted Dates don’t display properly when used as X-Axis values - hope this is just a bug
8. Chart Linking, Charts in Pages Updated from Tables in Numbers, is gone
9. Charts, when Copied to the Clipboard, are low resolution bit map images, not vector graphics as in previous version of Numbers.
10. Comments can’t be Printed
11. Comments can’t be repositioned
12. Comments can’t be resized
13. Comments only display as Tool Tips now, can’t be static displays
14. Conditional Format of Logic State (TRUE/FALSE) in 2.3 is converted to Numeric Value of 0 or 1 when document is opened by 3.0. Yet the only way to write such a conditional format in 3.0 requires a Text condition of TRUE/FALSE. Any attempt to edit the converted document’s conditional format results in a loss of the logic state conditional format that was imported.
15. Conditional Format with Dates doesn’t support all date formats (perhaps just a bug)
16. Contacts; Drag and Drop into Numbers from Contacts no longer supported
17. 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
18. Custom Formats gone
19. Date Format Options represent only US English norms and do not change with Country Settings
20. Filter action no longer moves content below the table up or down to account fo the length of the table being filtered.
21. Filter, Show Rows that Match, no longer treats a null string as a Blank Cell
22. Find and Replace Results Pane is gone - was a great navigation tool
23. Find and Replace can no longer be used to modify formulas
24. 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
25. Formulas and Functions user guide PDF, easily searchable, is gone, replaced by web help page
26. Formula List is Gone
27. Formula entry bug prevents direct entry of cell range in which the second column reference begins with the same letter as any function name.
28. Functions Tool has lost the ability to insert a row containing a statistics function, acting on a selected range, including multiple column ranges
29. 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
30. Hyperlink click no longer takes user directly to URL. Instead user must first click, then choose Edit or Open.
31. INDEX function no longer recognizes a Table Name as a Range
32. Insert > Date and Time is gone
33. Insert > Filename is gone
34. Keyboard Shortcut reminders have been removed from Drop-Down Row and Column menus
35. Media Browser no longer includes a Search field
36. Move and Mark for Move are gone from the Edit Menu
37. Numbers User Guide PDF is gone, replaced by web help page
38. Page Headers and Footers are gone (To be restored May 2014)
39. Page Margins can’t be adjusted
40. Print Preview view not available while editing (Zoom and Windowing to be improved in some way by May 2014 - Editing in Print Preview View not mentioned)
41. Pop-Up Menu Format no longer expands with a click of the Spacebar
42. QFX Financial File Exchange, bank and brokerage files, import is no longer supported
43. Reorganize Panel gone, no multi-level sort. (Multilevel Sort to be restored by May 2014)
44. Return key option to set the behavior while editing a cell is gone
45. Services are curtailed. Devon Wordservice services are absent in Numbers 3.0.
46. 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.
47. Show Autocompletion List in Table Columns is gone (To be restored May 2014)
48. Sort Selected Rows is gone (To be restored May 2014)
49. Sorting detector now stops cell references from following the sort movement. This loss a PLUS.
50. Split Cells is gone
51. Table Fills are not supported
52. Text Boxes can not be Copied to the Clipboard, therefore can not be converted to a PDF in Preview via the Command-N route
53. Toolbar Editor(add, delete, rearrange tool icons) is gone. (To be restored May 2014)
54. Trendline Equation and R-Squared values are fixed in place now - formerly were movable.
55. Values sometimes replace expressions when V2 documents are opened in V3

Hi Jerry,

Like you and the OP and Ltnjzz I miss categories, though I do know there are other ways (not quite as convenient) to reach the same end.

But what are all those unrelated items on this big, unsorted laundry list doing here?  Aside from these items being unrelated, some inaccuracies may have crept in. That is, I suppose, a hazard associated with making a list as long and formidable as possible.

2. Numbers 3.0 recognizes YYYY-MM-DD as a date input Automatic Format on my machine. I believe you can change some of the date formats in System Preferences>Language & Region if you want that. (Numbers 3.0 seems to be buggy with dates and your observations in item 19 on dates seem accurate. But this in particular does not seem to be one of the problems, at least not on my machine).

17. Not entirely accurate. File>Open csv works just fine too. It's only pasting comma-separated into a table that is broken (pasting tab-separated into a table works fine).

25. Ignores a very convenient feature of 3.0: context-aware formula help right there in the right panel.

37. There's no English pdf, but there is a lot more multi-lingual documentation than before, I believe. How that can somehow be thought to be a loss of function will escape the many non-English-speaking users of Numbers.

45. These are third-party OS X services created years ago, before Apple's push for more security on the Mac. As far as I can tell, they are essentially abandon-ware; the  developer (which makes fine software) hasn't updated these so they are recognized as being from an "identified developer." And since they are third party, it would be accurate to say they are also "Absent in Numbers 2.3".

38, 47, 48. Has Apple announced it will restore features "May 2014"? Or possibly some before in the coming months, as seems to be suggested in its support document on the features to be restored?

Meanwhile, there are good workarounds for a number of the items on the laundry list.

There are also new features and improved features in Numbers 3.0, including some that I suspect will be significant productivity enhancements for a large number of new and some old users.  They have been for me.

SG

SG,

Here's the bottom line; I'm not trying to exaggerate the omissions, just to document. I'm not making excuses for Numbers 3.0 and I'm not explaining workarounds. This is a collaborative effort to help anyone who may be puzzled by why they can't get Numbers 3.0 to do what they are used to doing in Numbers 2.3. I've tried to organize the list by putting a word that indicates the functional area first in the description and then alphabetizing on that word.

I will make corrections to any items in the list that are convincingly refuted. You may not have noticed that I identified which items are slated for early updates.

You and Wayne are doing a fine job of describing Additions and Workarounds. Keep up the good work. I have a short list of items that I haven't checked out yet, but probably will add to my list if the case is solid.

Jerry

Hi Jerry,

No worries. This useful list is obviously dynamic and expands as more information comes in. With your explanation, I can see a little better the logic in the order.  Still, perhaps a good time to tighten it up, organize it a little more, and present it in context so users can get a balanced view of Numbers 3.0.

What do you need to deem Item 2 "convincingly refuted" and 17 not entirely accurate?  Screenshots?  And will you consider taking out or modifying the "absolute" references "to be restored May 2014"?

Ian is the big contributor on features gained and workarounds. Wayne is doing his usual job of providing constructive responses to questions, often with examples that are very helpful to me, but I don't think he has had time to contribute to the gained and workarounds threads.

SG

In the list that I keep, on Numbers 3.0, I have modified the wording on the CSV issues to be more in line with your description, and also including the issue that Badunit makes about not being to drag a CSV file to a Table.

Jerry