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.
Created attachment 186470 [details] example ODS with Data Validation from cell range Still relevant in: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 5cc29848b78b6c5ab01aa7a66b1dd7caff5f9385 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Note another linked problem: 1. Start typing a string that matches an allowed value (e.g. "by" in example document) 2. Use the keyboard shortcut Alt + Down to expand the list of allowed options Result: error message "Invalid value". Pressing OK then expands the list. Expected: list expands, and first matching value is pre-selected.
No autocomplete either in OOo 3.3, so inherited.
*** Bug 98953 has been marked as a duplicate of this bug. ***
*** Bug 114393 has been marked as a duplicate of this bug. ***
*** Bug 152936 has been marked as a duplicate of this bug. ***
*** Bug 113237 has been marked as a duplicate of this bug. ***