We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

How to do Excel filtering for the grouped columns when showGroupedColumn is false

How to do Excel filtering for the grouped columns when showGroupedColumns is false.

 

This Knowledge Base explains the way of how to perform excel filtering for the grouped columns when showGroupedColumn is false.

HTML

 

JS

 

Razor

 

C#

 

 

ASPX

 

We can achieve this by rendering the filter icon in the Using actionComplete event in grid, render the excel filter icon for groupgrouped columns in group header cell when showGroupedColumns is false using actionComplete event of grid.

When clicking the filter icon for the grouped columns in the group drop area, the corresponding column Excel filter dialog gets rendered opened and we can perform the filtering operations. Through this we can perform filtering action after grouped the particular which is done as like usual Excel filtering.

This filtering process is done for the grouped column when showGroupedColumn is false.

 

C:\Users\Manisankar.durai\Desktop\sshot-1.png

Figure 1: Rendered the Excel filter for the grouped columns which is in group drop area

 

C:\Users\Manisankar.durai\Desktop\sshot-2.png

 

Figure 2: Excel filter dialog for the grouped columns (Ship Country column)

C:\Users\Manisankar.durai\Desktop\sshot-3.png

 

Figure 3: Sshows the filtered columns for Ship Country and changed the filter icon.

Article ID: Published Date: Last Revised Date: Platform: Control:
7175 12/16/2016 12/16/2016 JavaScript ejGrid
Tags:
Did you find this information helpful?
Add Comment
You must log in to leave a comment

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.