[data grid] Excel column filters

[satra2806]

Summary 💡

Hi team, is it possible to create filter like Handsontable:

https://handsontable.com/docs/column-filter/#basic-configuration

Google Spreadsheet

https://www.ag-grid.com/javascript-data-grid/filter-set/

Motivation 🔦

No response

Order ID 💳 (optional)

No response

[m4theushw]

Not natively, #670 should implement it. Although, I was playing with a custom column menu and it's indeed possible to embedded a filter form inside the column menu. Here's the CodeSandbox: https://codesandbox.io/s/datagrid-v5-quick-start-forked-de2m6?file=/src/App.tsx

The only problem with this example is that when the filter runs the menu is closed. This happens because the rowsScroll event is fired every time that the number of visible rows changes. If the CodeSandbox satisfy what you're looking for, we could add a prop to disable the default behavior of closing the menu during scroll.

[oliviertassinari]

Interesting, I have added more benchmarks in the issues' description: It sounds like #670