[data grid] Excel-like filters behavior

[paillave]

• I have searched the issues of this repository and believe that this is not a duplicate.

Request based on the purposal of @dtassone in the context of #201 (comment)

Summary 💡

Most of grid components have either a too complex/ugly filtering system, either, way too simple. Unfortunately, the default behavior that is planned for your grid seems to follow these paths (according to my humble opinion).

As I believe that you guys are the best, and that it is not possible to make better than the others by doing the same, you should mimic Excel, the sole filter ergonomic that actually proved its efficiency and who received the full approval of hundreds millions of end users for decades. (You must note here that I'm talking about end users and not developers or business analysts)

Examples 🌈

Excel permits to have a straight forward combination of filter on columns. Of course, the checkbox list part is not a must, even if it is a really, really, really... terrific feature (in case of more than xxx rows, you can disable it to maintain good performances or if data if filtered/sorted in a controlled way). My point here is to put the finger on the spirit of what seems to make the success of Excel.

Motivation 🔦

What seems to be planed as a default behavior in the grid so far is one of these usual intimidating, complex, click consuming business intelligence like forms to make a filter. Well, for sure every possible and impossible demand will be full filled with this. But my opinion is that 99% of end users don't have such a high standard. Simple needs that represent 99% of situations MUST be done in an EXTREMELY simple and straightforward way by end users. Or course, the business intelligence-like filter system shall be done for every developer to be satisfied, but for sure, an Excel like filter will satisfy end users more.

Similar issue

• [data grid] Excel column filters #3571

[satra2806]

this one completed?

[gffhammes]

any updates on this issue?