Bug 94513

Summary:	editing: Improvement: text completion should include validity values
Product:	LibreOffice	Reporter:	palmierivinc.ent
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	79045_79045, fairwarning332, fathoni.id, gerard.fargeot, ilmari.lauhakangas, regeirs.forum, stephane.guillou
Priority:	medium
Version:	Inherited From OOo
Hardware:	All
OS:	All
URL:	https://ask.libreoffice.org/t/data-validation-cell-range-needs-full-text-search/85920
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	103341, 108988
Attachments:	example ODS with Data Validation from cell range

Description palmierivinc.ent 2015-09-25 20:25:25 UTC

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.

Comment 1 Buovjaga 2015-09-28 09:13:16 UTC

Sounds reasonable -> NEW.

Comment 2 GerardF 2015-09-28 09:45:15 UTC

(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.

Comment 3 Stéphane Guillou (stragu) 2023-04-04 11:36:59 UTC

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.

Comment 4 Stéphane Guillou (stragu) 2023-04-04 11:39:37 UTC

No autocomplete either in OOo 3.3, so inherited.

Comment 5 Stéphane Guillou (stragu) 2023-04-04 11:40:29 UTC

*** Bug 98953 has been marked as a duplicate of this bug. ***

Comment 6 Stéphane Guillou (stragu) 2023-04-04 22:39:12 UTC

*** Bug 114393 has been marked as a duplicate of this bug. ***

Comment 7 Stéphane Guillou (stragu) 2023-04-04 22:57:30 UTC

*** Bug 152936 has been marked as a duplicate of this bug. ***