Great thanks guys - I would like to have a look at this. Will do so today and reach out with any questions.

Have only had a quick chance to try this out - will look more closely, and compare with Excel - but I ran into a usability issue pretty quick where I wanted to search for and select multiple values that required different searches to find.

E.g. using Toolbox's primary grid filtering example, let's say:

• I want to filter on two companies - Anderson LLC and Batz Group
• Open Company col filter
• Type "anderson" - list and grid filters down to a collection of matches
• Click header to uncheck all, then check only Anderson LLC - first company now showing as desired - leave col filter open
• Clear search within filter dialog, then type "batz" to find and select my second company
• All "batz" results are now selected, and I've lost my Anderson filter.

Seems problematic, no? Will be interested to see how the Excel model we are looking to track handles this same "search for and filter this then that" use case.

Well, I see Excel (on my Mac) doing something very similar - to be honest, it feels just as confusing if not more in Excel, not sure how to feel about it but a good thing in terms of our goal of replicating Excel.

It's surprising how difficult I find it to intuit how this control works (or how I want it to work, speaking about the Excel version just as much as ours). But wanted to chat back here quick to confirm what you say above re. this working much like Excel

One thing to note - on Excel for Mac there is a user-driven "auto-apply" toggle in the control itself. I wonder if we need this, given how differently the filtering works between commitOnChange true/false.

Previously we've thought about that as something a developer sets based on (I think) the volume of expected data, thinking about how fast or slow or disruptive "eager" filtering might be.

Now I wonder if it should be something the user can control right here, while filtering. Specifically so they could untick it if they wanted to build up the multi-step filter described above - seeing that if commitOnChange:false we get the "add selection to current filter" option.

Note Excel here choosing to simply disable "Apply" button when checked:

I'm going to switch now to looking at Excel on Windows - they are different, and admittedly the Windows version always more important to us.

OK - last comment for now - very helpful to try on Windows, as that's clearly (and correctly!) the version that matches the behavior we're implementing with this change.

Note that Excel for Windows does not show the "auto apply" checkbox we see on Mac above. I was wondering what the default commitOnChange value was for our control - the docs say true but it didn't look like that to me scanning the code, could you please confirm?

I am thinking it should be false

The default commit on change is True, should I make the change to have it false and update the documentation?