Q: Workarounds in Numbers 3.0?
Dear Fellow Numbers 3.0 Users,
In Numbers 3.0, some features have been lost that were in Numbers 2.3. However, I have seen some creative ideas in this forum for ways to work around the loss of features yet maintaining the functionality.
Example 1:
http://discussions.apple.com/message/23612026?ac_cid=tw123456#23612026
In the new Numbers, where did autofill drop down menus go and how do I get them back? See the replies from SGIII and Smirhcfa
Autofill has gone. Workaround: enter your most used values into a column. Select all body cells in that Column and change the Cell format to pop-up. The pop-up will now contain choices for filling in other Rows.
Another workaround could be to use a lookup table of frequently used entries (each with a unique first character). Type the first character of an entry in one Column. The next Column fills in the full entry from a lookup table. After all, is this not how Autofill works?
Example 2:
Numbers 3.0 does not show dates in a Chart. Workaround: convert the dates to a Duration (day or week from the starting time) or even a number to represent time elapsed.
Some workarounds may seem to be clunky, but in Numbers 2 we also need workarounds!
Please keep this thread positive. By now, I think we have heard enough about features and functionality that seem to be lost.
Workarounds, anyone?
Regards,
Ian.
MacBook Pro (13-inch Mid 2012), OS X Mavericks (10.9), Numbers 2.3 & 3.0, Pages'09
Posted on Nov 1, 2013 6:16 AM
Insert Date menu pick is gone in Numbers 3.0. Workaround: create an Automator Service that retrieves the date and time from the system clock and pastes it into the selected cell in Numbers. This service can be accessed via Numbers>Services in the menu or can be assigned to a keyboard shortcut. For details see this thread. Thanks to alexhax and slypix for refinements.
(You may need to remove 'Day of the week' from your "Full" date format in System Preferences>Language & Region for it to give you the desired result.)
SG
Posted on Nov 10, 2013 8:30 AM





