Can you please make the filter box in Handsontable behave like the one in Excel? Currently, when I use the filter search box, I have to manually uncheck all values, search for the one I want, and then check it again. This process is a bit overwhelming and not intuitive for regular customers. In Excel, when you search and click OK, it automatically filters and shows only the searched value. I’d like to achieve the same behavior in Handsontable if possible.
please find the attached image
in both image, when I click ok in excel will display only the value I search for while in handsontable will display all the result