Filter as you type

[aaronbeall]

Description

The default behavior of filter_by_value is that when you type in the search value it does not filter anything. You have to press "Clear" first, then search, then filter. I know this is the behavior of Google Sheets but it has come up in user testing as confusing. Excel, by contrast, will filter out items immediately as you type -- basically it automatically deselects items that don't match what you've searched for. Is there a way to modify the filter_by_value to behave this way to implement a filter_by_search that does this?

Steps to reproduce

1. Turn on filter_by_value
2. Open dropdown, enter search term, press OK
3. No filter is applied

Demo

http://jsfiddle.net/upo1uLgs/

Your environment

• Handsontable version: pro-1.18.1
• Browser Name and version: Chrome 65
• Operating System: MacOS High Sierra

[AMBudnik]

Hi,

yes, that is an intended behavior as all the data is visible in the table they are also visible/checked in the filter_by_value list.

If you would like to clear the values here's how to do it http://jsfiddle.net/handsoncode/3gz93neb/ but still, you'll need to check the checkbox of a searched/result query.

I will add this topic to the feature request list. Thanks for sharing the idea @aaronbeall

[aaronbeall]

Thanks. That's pretty close but if you don't interact with the filter and press OK then it actually clears everything.

The desired behavior would be like Excel:

Even if it didn't update the filter live and you still had to press OK to apply the filter, the main difference is that if you type a search value it automatically down-filters to items that match the search value. This is a lot easier to use that the current implementation, which we got confused feedback from users during testing (users who are used to Excel).

It'd be awesome if there was an option that made the filter_by_value do the same "deselect unmatched values" would be really useful.

[AMBudnik]

That is definitely a cool idea. There's something similar here http://jsfiddle.net/rjb9p8b3/ when we use column headers.

[AMBudnik]

As mentioned in the #5424 I am temporarily closing this issue