auto complete logic simply suggest the first possible item in alphabetical order.
This means that, if in the same column i have "aztec" (100 time inserted) and "albert" (only 1 time inserted), if i press "a", Calc will suggest "albert" for auto-complete instead of "aztec". Off course, if i've inserted aztec 100 times and albert only one time, there are chance that i want to insert another "aztec" item instead of "albert"...
Steps to reproduce:
1. write n time aztec in a column (n>1)
2. write 1 time albert in the same column
3. press a
Current behavior: Calc suggest albert
Expected behavior: Calc suggest aztec (the most used item)
Platform (if different from the browser):
Browser: Mozilla/5.0 (X11; Linux x86_64; rv:8.0) Gecko/20100101 Firefox/8.0
Thanks for new idea
In 3.5.2 not implemented yet.
IMHO in described situation will useful even just remember last variant, selected by user for this column and propose it again next time. It will hit more often than miss.
for disable this functionality use Tools->Cell contents->Autoinput
LibreOffice 220.127.116.11 for windows.
In the help it says you can use the Tab key to scroll through the auto-complete entries and Shift-Tab to go backwards through the entries. I've tried it several times but just leaves what is selected in auto-complete in the cell and moves to the next cell over.
> In the help it says
May be there written about Writer
*** Bug 117344 has been marked as a duplicate of this bug. ***
*** Bug 78545 has been marked as a duplicate of this bug. ***
See bug 78545 for another idea
Bug not reproducible in version
Version: 18.104.22.168.alpha0+ (x64)
Build ID: 0f25a3c36f27fd51453b9a9115f236b83c143684
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win;
TinderBox: Win-x86_64@42, Branch:master, Time: 2018-11-27_20:06:55
Locale: zh-TW (zh_TW); UI-Language: en-US