[AjitAryaParticipant]

Hi Dimitar,

If not that kind of date filtering then at least excel filtermode should be able to support date range filtertype, right? but I didn’t see that either.

That Cascade filtering is what I was looking for. Thanks for sharing that. I hope the clear filter functionality of the excel filtermode clear button will still work as expected even with this cascade filter.

Thanks
Ajit

[AjitAryaParticipant]

Hi Dimitar,

Thanks for replying. Before I posted here, I had already tried setting the flitertype: ‘checklist’, and what happened was that the filterrow showed dropdowns on each column with data and checkboxes but for some reason didn’t gave the filter and clear buttons like the filtermode: ‘excel’ had and my client didn’t liked those drop downs and a separate row to use filtering.

It would be great if MS Excel style ‘DATE’ filtering can be done with ‘excel’ filtermode.

Another thing I noticed is that in the excel filtermode, the filter menu for date columns (automatically shows checkedlist when showfilterrow was false) didn’t apply the date formatting ‘d’ that I had applied on the grid cells. I do understand that the cellsformat: ‘d’ is only meant for cells but this would have also been helpful as per a user perspective if the cells formatting could have taken into account on the filter menu items as well. Coz right now the values in the cells display in a different format and in the filter menu they look different.

Do you know if both of these things + cascade filtering are in the pipeline for any future releases?

Or if there is a workaround.

Thanks

[AjitAryaParticipant]

Any update on this?

I want to use the filtermode: ‘excel’ on all columns except the date columns (I got 5) with filtertype: ‘range’.

What should I do?

On enabling the filter row, all the columns start to show text boxes in the filter row and excel like filtering is lost.

EDIT:

Important Note: I have empty cells as well in the date columns. Not sure how the range filtering would work with that. Please help.

[Author]

Posts