calc does not show existing item in col when you start to type

I have a column of entries and when I start to type a new entry that is the same as one in the column Calc does not offer to do the entry. I must either type the whole thing or do a copy/paste. Is there a setting that controls this that I must tweak??

Is this related?

May be just Tools -> [ ] AutoInput not ticked.

That was it. Thanks

Please use the comments.