Take any dataset and apply Autofilter to it. (Data > Filter > Autofilter).
Then click on any column head, and select "Standard Filter" option.
The Standard Filter GUI pops up.
Set any condition (does not matter what), and press OK.
Now re-open the standard filter GUI.
How would you reset the filter?
1. Provide a "Reset" button at bottom, which clears the entries.
2. Provide a X button against each row of filter, to delete it.
(When all rows are deleted, the filter is effectively reset)
Hi @narayanaras, thanks for reporting.
You are right, it is not too much obvious.
Go to the field of the first condition and select -non- at the top.
You can use the same way to delete from any particular condition the rest of condition.
Change the status to New, and the importance from normal to enhancement.
Created attachment 148318 [details]
Demo of the reset button in my patch.
Created attachment 148319 [details]
Demo of the "X" buttons in my patch.
I am working on this. Above I have attached a demo of the reset ("Clear") button and the "X" buttons in my patch.
I hope to check this with the design team later today.