Bug 114393 - Filter entries in Validity drop-down list by typed input
Summary: Filter entries in Validity drop-down list by typed input
Status: RESOLVED DUPLICATE of bug 94513
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.0.0.alpha0+
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Validity
  Show dependency treegraph
 
Reported: 2017-12-10 20:27 UTC by Roman Kuznetsov
Modified: 2023-04-04 22:39 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 Roman Kuznetsov 2017-12-10 20:27:01 UTC
Description:
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
Comment 4 Stéphane Guillou (stragu) 2023-04-04 22:39:12 UTC
Very similar to what is suggested in bug 94513. Even though they are a slight bit different, I am marking as a duplicate as an ideal solution is best discussed in one single report.

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