Filter by value type ahead functionality?

Getting help Questions
1

After some poking around it seems the only available filter options are ‘filter_by_condition’, filter_by_value’, ‘filter_action_bar’ -

When I enter text in the Filter By Value textbox the list of values in the filter menu is filtered as I type. Say I have a column with state abbreviations. When I first open the filter all available states are selected. If I type NJ in the search box the list is filtered down to NJ which is already selected. If I then click OK I would expect the grid to filter for states with only NJ but in reality nothing happens. This seems like a bug, if not it’s just not very intuitive and/or useful as is. ?

2

Hi @it1

Here’s a demo that shows our example: Handsontable example - JSFiddle - Code Playground
If you would like to filter all states besides NJ you have to firstly clear the rest of boxes.

3

yes, I realize that you would first need to clear, my point was that it doesn’t seem intuitive.

4

Maybe you’re right @it1
I’m not sure if we would want to change the default behavior but thank you very much for sharing your opinion. Maybe some default settings have to be changed after all.

5
  • This is a very critical feature for our product as our end-users are Power users of MS Excel
  • Besides, this workflow of clearing filters before applying new one is not intuitive
  • I understand that your developers wanted a WYSISWYG approach to filters but its little hard to wrap our mind around it as everyone has already created a mental model for column filtering
  • All that we need to do is change the definition of “Clear”. Instead of setting all checkbox values to “False” it should remove filtering on given column and display all values (just like in Excel)

Its been one year since this was last discussed. Can you please let me know if its in the roadmap for 2017?

6

Hi @optym

We have made some changes to the Filters plugin, the new version should be released next week.

You can find our Trello Roadmap at: https://trello.com/b/PztR4hpj/handsontable-roadmap-2017-login-to-vote
The current tasks for Q3 this year are:

  • Angular 2 wrapper
  • key-value cells
  • unifying GET methods
  • localization
  • a new way of handling fixed bottom rows