I have to build lists of variable items.
is it possible to define codes that consist of few numbers or letters linked to text snippets and - upon entering the code in a cell have calc autocomplete accordingly? so you only have to type specific abbreviations to generate the full length text entry
a bit like ascii-code, I suppose, only with letters not numbers, i. e.:
enter ‘LST’ - long sleeved shirt
enter ‘vns’ - V-neck-Sweater
(this is just an example in order to make myself clear, the original purpose is somewhat different.
I would really need to enter several digit codes in one cell and have the cell next to it auto fill in the meaning.
I just want to check if this can be done with libre office and how)
Grateful for any pointers!