Autocomplete only on demand in OpenOffice Calc
In Open-/Libreoffice Calc, it is possible to enable the auto-completion of cells. That means the cell is filled e.g. with a string that starts with the characters already typed. This may give unwanted effects so I'd like to disable this option.
Is there (for example) a shortcut that completes the text in the current cell when auto-completion is disabled globally?
Solution 1:
Almost a solution:
You can map a key to toggle AutoInput. Then you can press that key while entering data, and the next character typed will trigger the completion. Press the mapped key again to turn AutoInput back off. This is much faster than going through the menu each time.
I tried it and it seems to work well enough, although it would be nice to have AutoInput turn off automatically after pressing ‹enter›. Perhaps that would be possible through a macro, but that's not my expertise.
To those needing to know how to map a key:
Tools > Customize > Keyboard
Function > Options > AutoInput
Shortcut keys > scroll and select desired key > Modify
I thought ‹control›‹insert› was logical, and it was previously undefined.