Frequently asked questions - Calc
From The Document Foundation Wiki
How to suppress the auto-completion of words
After each keystroke, Calc searches automatically for a word beginning with the same letters that are already entered in the column. If you do not want this behavior, uncheck AutoInput in the ▸ menu .