Is it possible to deselect "Select All" check box for Grid Excel Like filter Pop up Initial render?

[steve]

Hi, 

I am using DataGrid with Excel Like Filtering.

When I click on filter icon to show the Filter Popup for a particular column, I would like to have the popup show that the "Select All" checkbox be "unchecked" and all the possible filter items should be shown, but also "unchecked".

This should only happen when there is no filter applied.

Is this possible?

Thanks,

Steve

[Guhanathan Ramanathan]

Hi Steve ,

 

The DataGrid component is configured to emulate Microsoft Excel-style filtering behavior for consistency and user familiarity. In Microsoft Excel, when no filter is applied to a column, the filter popup displays all available items with their corresponding checkboxes selected by default—including the "Select All" option. This visual state indicates that no filtering is currently active and all data is visible.

To align with this standard, our implementation follows the same logic. Modifying the default behavior to display all items as unchecked when no filter is applied would deviate from the expected Excel-like experience and is not supported by the built-in filtering mechanism.

Please refer to the screenshot below, which shows how Microsoft Excel presents its filter popup when no filter is applied:

Regards,

Guhanathan R

[steve]

Hi, Guhanathan,

You have clearly explained why the functionality is so.

But, that was not my question.

I do not want you to change it.

I just wanted to know if there was a work around.

For my users, it just meant one less mouse click (EVERYTIME FIRST CLICK SELECT ALL, THEN CLICK THE ITEMS YOU WANT)

Anyway, that's the feedback I got

Thanks for your efforts...

[Guhanathan Ramanathan]

Hi Steve,

From your query, we understand that you are trying to achieve this through a workaround, but it is not possible due to certain reasons. If users open the filter dialog and press Enter with all values unchecked, the grid will display no records, which is not desirable. Additionally, we persist checkbox selections by default; for example, if a user selects 5 out of 10 records and applies the filter, reopening the dialog will show those 5 checked and the remaining 5 unchecked. In your requested scenario, where all checkboxes including ‘Select All are unchecked on every open, the system cannot differentiate between a cleared state and a persisted state, leading to ambiguity and incorrect behavior. Therefore, this cannot be achieved through a workaround.

Regards,

Guhanathan R