The word completion-like feature in Openoffice.org Calc

I'm a big non-fan of word completion.

But when you go under Tools > AutoCorrect in Calc to turn off word completion in Calc, as you would in Writer, there's no Word Completion tab.

You need to choose Tools > Cell Contents > Autoinput to turn it off, or turn it on again later.

Comments

[John Drinkwater]

I tried really hard to find it, but must’ve missed it in the docs, how does one change the auto-completion to the next valid entry? (press tab or something to cycle)
I’ve been entering “People + phone number” into a spreadsheet, but for people with multiple numbers, it only selects the first entry it sees - a royal pain.

[Solveig]

Hi John,

I think it just takes the first, in alphabetical order, entry from the column it's in and you can't change it. If you can though it's hidden somewhere under Tools > Options.