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

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

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.