Why does autocomplete in Open Office Calc not work for older entries?

1

I have a number of words in a Calc column that I update occasionally. When I type a new word in a cell, it will autocomplete if I already have one higher up in the column. This is useful so I don't make duplicate entries.

However, this doesn't work for older entries (words that I've entered a longer time ago). How can I make it check the entire column, including old words?

Mark

Posted 2009-11-07T21:19:56.610

Reputation:

So you should close this question. – DaveParillo – 2009-11-08T01:43:45.583

Post your findings as to why it can't as an answer itself. Then accept it a couple of days later. No need to delete. – random – 2009-11-08T09:27:01.833

Answers

0

Update from author of question, moved from question to this answer:

I've found that it only remembers the last 200 entries.

Tamara Wijsman

Posted 2009-11-07T21:19:56.610

Reputation: 54 163

Asked: 2009-11-07T21:19:56.610

Viewed: 788 times

Active: 2012-08-19T00:02:31.423