How to make an vocabulary for autocomplete entries in Calc
I fill in in my sheet repetitive entries, I would like the autocomplete future to offer me an autofill entry from a list of these repetitive entries. In my rather new version of libreffice calc (6.2.4.2) there is no tab for modifying this autocomplete feature (such as the guides I found online suggested, under the autocorrect options) and the only control I have is to check or uncheck this feature altogether. Was it move somewhere? Is there a workaround?
What you are talking about seems to me is "AutoInput" feature (entries from the current column being edited) in LibreOffice Calc terminology. Have you checked
Tools -> [x] AutoInput
? AutoCorrect is a different thing, since it is not a helper to add certain entries, but to correct "incorrect" (whatever is determined incorrect) entries.If you want to define valid entries, we start to talk about
Data -> Validity
, which allows to define valid values.