This problem occurs when a cell has a list or a range of cells as validity criteria:
I've seen many people trying to type the first letters, expecting the good text to appear by completion. It works fine if the text has already been typed in another place and is in the history. Otherwise, users open the dropdown list, but the cursor position in the list is not related to the first letters typed.
I've seen several people disturbed by this and give up, saying "it's odd" or "it doesn't work".
It can be improved by two non-exclusive ways:
1. When a cell has a list or a range of cells as validity criteria, add this range/list to the texts available by completion
2. When a cell has a list or a range of cells as validity criteria, when the user opens the dropdown list after having typed some letters, the dropdown list's cursor should be at the closest item to the typed text.
Sounds reasonable -> NEW.
(In reply to palmierivinc.ent from comment #0)
> 2. When a cell has a list or a range of cells as validity criteria, when the
> user opens the dropdown list after having typed some letters, the dropdown
> list's cursor should be at the closest item to the typed text.
Note that the reverse works :
1. Open the drop down list (with mouse or Alt + ↓
2. type the first letters.
The 1st item beginning with these letters is preselected.