Bug 94513 - editing: Improvement: text completion should include validity values
Summary: editing: Improvement: text completion should include validity values
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.1.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Validity
  Show dependency treegraph
 
Reported: 2015-09-25 20:25 UTC by palmierivinc.ent
Modified: 2017-07-06 11:55 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.