Summary of good 🙂 things (keep them coming).
Added since last update:
From Badunit: Another gain on conditional formatting:
The cell referencing in a conditional format can now be relative. As an example, if cell A2 has the format "make bold if equal to B2" you can copy (or combine) that format to cell A3 and the reference on that row will be to B3. In the prior versions it would have remained B2 and you would have to manually change it to B3.
From Papalapapp: Just found another useful new feature. When you format a cell as a drop down menu, you can now re-arrange the sort order of the menu items in the inspector. And you can define the first value or "empty" as default value.
Additionally, if you add items to the list in one of the cells, you can select the others and "combine" them just like it is in conditional formatting. By that you can apply the list to all cells without changing the current value.
Updated list:
The cell referencing in a conditional format can now be relative. As an example, if cell A2 has the format "make bold if equal to B2" you can copy (or combine) that format to cell A3 and the reference on that row will be to B3. In the prior versions it would have remained B2 and you would have to manually change it to B3.
Easily add or delete items in a pop-up menu using Format Inspector > Cell > Data Format. Reorder items by dragging in the Inspector. Define first value or "empty" as first value. Additionally, if you add items to the list in one of the cells, you can select the others and "combine" them just like it is in conditional formatting. By that you can apply the list to all cells without changing the current value.
Powerful real-time editing and sharing via iCloud with any computer that has a recent browser.
Share is now a button. Nice and intuitive.
Sort the contents of Sheets shown in Sheet tab pop-ups by selecting an object, Arrange > Send Backward or Bring Forward.
Better cross-platform sharing/collaboration (between OS X and iOS).
The alignment guides (for moving or resizing objects) remain. See Numbers > Preferences > Rulers.
New ability to rotate axis labels on graphs (Charts).
Improved management of custom templates from within Template Chooser (Rename and Delete).
Adding a shadow to a Table is now a workaround. (Hint: slide a shadowed rectangle behind the Table).
New ability to attach a comment to a Chart (graph), a Shape, or a Text Box (not just to Table Cells).
New Statistics Pane (Bar at bottom) with many new auto statistics. Click on gear wheel.
New Bubble charts.
New Cell Format "Star Rating"
Function Browser (with definition and examples as in Numbers '09) now appears in the panel on the right whenever you type = in a cell.
Copy and Paste now carries cell formatting (for example, cell borders) as well as cell content.
The Colours window remains and works as it did in Numbers '09. Menu > View > Show Colors, or shift command c. The full range of colours remains. Drag a colour from the patch at the top of a palette and drop it into a cell.
Press Command Right Arrow or Down Arrow to be taken to the last cell, and Shift Command Right/Down Arrow to select all remaining cells in a row/column.
In addition to Table filtering in the Filter Inspector, there is a basic Filter in the pop-up menu of each Column reference tab. Choose to show only those Rows that contain (in any Column) one of the values listed. More basic than the Filter Inspector, but quick.
Many more Chart types, including some interactive charts controlled by a slider and buttons.
Format Inspector > Cell > Data Format > Automatic or Number > Decimals, now allows Auto as well as the previous set number of decimal places.
Regards,
Ian.
P.S. When we all learn how to drive the new car, we will find that it still has four wheels.
Message was edited by: Yellowbox. Typo corrected.
