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 184.108.40.206 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: 220.127.116.11.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
Created attachment 172600 [details]
Calc choose not the most used word, but it choose the near alphabetic letter.
There was a commit for bug 142214, https://git.libreoffice.org/core/commit/f8039c6d645acb015a6c4e45000bbfd1311bfea3
It changed the behaviour, so the result in the description of this report no longer occurs.
Quoting from the commit message:
show autocompletion only if there is exactly one match
Picking one from many matches by any logic requires the user to pay
attention to the auto completed match and see if it the one they wanted.
Instead show autocomplete only when there is exactly one match with what
the user has already typed.
*** This bug has been marked as a duplicate of bug 142214 ***
That makes some sense from the cognitive perspective, but it's not very helpful if you have a long string that is unique at the end. For example,
I think the more intelligent approach would be to look for the matches, finding the nearest-proximity one in the same column.