Bug 114393 - Filter entries in Validity drop-down list by typed input
Summary: Filter entries in Validity drop-down list by typed input
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Cell-Validity
  Show dependency treegraph
Reported: 2017-12-10 20:27 UTC by Roman Kuznetsov
Modified: 2017-12-19 19:01 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description Roman Kuznetsov 2017-12-10 20:27:01 UTC
add filter in Validity drop-down list while entering value to cell. 
If I have over 100 value in cells and I use them in Validity (cell range), then i must long scroll this long long drop-down list to find need item.
I offer add filter while entering value to cell with Validity, that make less list of variants 

Steps to Reproduce:
1. Create Validity , variant - cell range for any cell in spreadsheet
2. Use many cells with values for this cell range
3. Select your cell with Validity and open drop-down list
4. Find value needed to you. Good, if this value was in begin of list. And if not? You must scroll long list and carefully see to values to find needed value to you =(

Actual Results:  
we have long list of values in cell with Validity and there isn't filtering for it

Expected Results:
we can begin entering of value in the cell and we'll have short list of values in our list

Reproducible: Always

User Profile Reset: No

Additional Info:

User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:58.0) Gecko/20100101 Firefox/58.0
Comment 1 m.a.riosv 2017-12-11 15:34:25 UTC Comment hidden (obsolete)
Comment 2 Mike Kaganski 2017-12-12 06:50:42 UTC
This is not a duplicate of bug 96741. That is about filtering validity drop-down list while typing into the controlled cell; that one is about using mouse when specifying validity criteria in dialog.
Comment 3 Buovjaga 2017-12-19 19:01:59 UTC
Ok -> NEW