Bug 152936 - Feature Request: Consider adding autocomplete (with full-text search) to cell validation
Summary: Feature Request: Consider adding autocomplete (with full-text search) to cell...
Status: RESOLVED DUPLICATE of bug 94513
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL: https://ask.libreoffice.org/t/data-va...
Depends on:
Blocks: AutoCorrect-Complete Cell-Validity
  Show dependency treegraph
Reported: 2023-01-09 00:02 UTC by Roberto
Modified: 2023-04-04 22:57 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Roberto 2023-01-09 00:02:12 UTC
When utilizing cell validation based on cell range (with drop-down), to consider:

- Activating autocomplete triggered by typing directly into the cell. 
  - (Currently requires first to mouse-click drop-down arrow or Alt + down before will respond to typing)

- Autocomplete leveraging a full-text search of the data in the cell range. 
  - (e.g. if user types in part of the cell content that is at the end of the cell, it will still find the item from the drop-down).
Comment 1 V Stuart Foote 2023-01-09 14:04:47 UTC
I guess possibly perform full text "search" finding target midspan and at endings of cell contents. 

But the progressive "bash like" auto complete of bug 145198 is pretty functional already.
Comment 2 Heiko Tietze 2023-01-10 08:21:58 UTC
There is a momentum in bug 142214 (which I use as duplicate; please reopen if this request has a substantial different direction). Another potential duplicate is bug 133494.

*** This bug has been marked as a duplicate of bug 142214 ***
Comment 3 Shantanu 2023-01-10 09:34:58 UTC
This is about full text autocomplete that is different than the bug 142214 or 133494.

Comment 4 V Stuart Foote 2023-01-10 12:08:05 UTC
I'd forgotten about the .uno:DataSelect (<Alt>=<Down> shortcut) improvements suggested in bug 133494, work on that framework would be appropriate for the ask here.

Bug 142214 got off track and discussion there of not sectioning the searched ranges are not helpful to this ask for completion against partial string match in any position.

Thusfar the .uno:DataSelect provides *only* the full listbox of previous column entries without any filtering. Also does not seem to provide for searching cells by row.

For Columns, what is needed is for user to make some entry into the target cell, using that in the UNO as the string to match on previous cell values--regardless of position in cell(s)--and filter the listbox choices accordingly. 

Comment 5 V Stuart Foote 2023-01-10 12:26:22 UTC
s/<Alt>=<Down> shortcut/<Alt>+<Down> shortcut/
Comment 6 Heiko Tietze 2023-01-11 07:46:58 UTC
My understanding of the STR:

1. Create a validity list with a couple of similar options like "Position 1, Position 2, Position 3"
2. Type "1" in the cell => expectation is to autocomplete as "Position 1" (picking the item from a very long list is tedious)

Valid enhancement
See also 
* bug 94513 (autocompletion is based on the sheet content not the validity list)
* bug 98953 (type to find => DUP)
* bug 113237 (duplicate, Cor?)
* bug 114393 (duplicate, Roman?)
* bug 137113 (DUP of bug 94513)

Stéphane, something to consolidate?
Comment 7 Stéphane Guillou (stragu) 2023-04-04 22:57:30 UTC
Consolidating into near-identical bug 94513.

*** This bug has been marked as a duplicate of bug 94513 ***