auto-completenumbers
It would appear that my documents in Numbers (since upgrading to 3.0 with Mavericks) no longer auto-complete cells.
I've Googled for "turn on auto-complete in Numbers" and found plenty of questions on how to turn it off, all of which point to a simple check box in Preferences -> General. However, that check box no longer seems to be present in the new version.
Is there a way to turn auto-complete back on?
_complete_open() {
COMPREPLY=()
local cur="${COMP_WORDS[$COMP_CWORD]}"
local prev="${COMP_WORDS[COMP_CWORD-1]}"
[[ "$cur" == -* || "$prev" != '-a' ]] && return
apps="$(mdfind kMDItemKind==Application -onlyin /Applications -onlyin ~/Applications -onlyin /Developer -onlyin ~/Developer | grep -v '/.*/.*/.*/.*/' | sed -E 's|.*/||g;s|\.app$||g' | uniq)"$'Finder\nArchive Utility\nCharacterPalette\nKeyboardViewer'
local IFS=$'\n'
if [[ "${cur:0:1}" = '"' || "${cur:0:1}" = "'" ]]; then
quote="${cur:0:1}"
cur="${cur:1}"
fi
local found="$(grep -i "^$cur" <<< "$apps")"
if [[ "$quote" == '"' ]]; then
found="$(sed "s|^|\"|g;s|$|\"|g" <<< "$found")"
elif [[ "$quote" == "'" ]]; then
found="$(sed "s|^|'|g;s|$|'|g" <<< "$found")"
else
found="$(sed 's| |\\ |g' <<< "$found")"
fi
COMPREPLY=($found)
}
complete -o default -F _complete_open open
Third version, which should now both be case insensitive and work within quotes.
Go to Insert > Date & Time.
Double-click the date and format to taste. Make sure "Automatically update on open" isn't ticked.
Best Answer
Not right now, but the feature is coming back in a future release within the next six months. Apple has documented the missing features in iWork '13 in a new KB titled About the new iWork for Mac: Features and compatibility, where auto-complete for Numbers is listed as one of the features that will be re-introduced.