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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Menu filter and excel filter in one grid

Thread ID:





124991 Jul 13,2016 07:53 AM UTC Feb 19,2018 10:34 AM UTC JavaScript 5
Tags: ejGrid
Pawel Klimczyk
Asked On July 13, 2016 07:53 AM UTC

Is it possible to have both "menu filter" and "excel filter" in one grid?
For example "menu filter" for Column A and "excel filter" for Column B.

Mani Sankar Durai [Syncfusion]
Replied On July 14, 2016 10:25 AM UTC

Hi Pawel, 

Thanks for contacting Syncfusion support, 

Yes, we can enable both excel and menu filter for different columns. We can achieve it by using the FilterType property of columns as either menu or excel for the particular column.  

For your convenience please refer the below code example, 

                    allowFiltering: true, 
                    filterSettings: { filterType: "excel" }, 
                    columns: [ 
                            { field: "OrderID", isPrimaryKey: true, headerText: "Order ID", textAlign: ej.TextAlign.Right, width: 75 }, 
                            { field: "CustomerID", filterType: "menu", headerText: "Customer ID", width: 120 }, 

We have also prepared a sample that can be downloaded from the below link, 

Please let us know if you need further assistance. 

Manisankar Durai. 

Vishal Manghnani
Replied On August 5, 2016 04:20 PM UTC

Hi Could you post a sample for doing this without javascript?
I tried it by setting the grid property .AllowFiltering() and then set FilterType property of a column as col.Field(p => p.ClientName).HeaderText("Client Name").FilterType(FilterOption.Excel).Add(); 
The column client name still showed as a Text box rather than an excel type drop down


Mani Sankar Durai [Syncfusion]
Replied On August 8, 2016 10:48 AM UTC

Hi Pawel, 
We have analyzed your query and found the cause of the issue. You have initialized the filterType as excel for one column and not initialized the filterSettings to have the filterType as menu for other columns. This is the cause of the issue. If you enable the filterType as filterBar which is common for all columns and set the filterType as excel or menu for particular columns it will show as filterBar (Textbox). So we suggest you to mention the filterSettings to render the filterType as either menu or excel for other columns. 
Please refer the below code example, 
        .FilterSettings(filter => { filter.FilterType(FilterType.Menu); }) 
        .Columns(col => 
col.Field("Freight").HeaderText("Client Name").FilterType(FilterOption.Excel).Add();  

We have also prepared a sample that can be downloaded from the below link, 

Please let us know if you need further assistance 
Manisankar Durai 

Replied On February 17, 2018 05:19 PM UTC


Is it possible to have FilterBar as grid filtering option and Excel or Menu for specific columns ?


Balasubramanian Masilamani [Syncfusion]
Replied On February 19, 2018 10:34 AM UTC

Hi Clovis, 

Thanks for contacting Syncfusion support. 

We have checked your query and found that you want to use filterBar as grid filterType and with Menu or Excel filter as filterType for specific columns. Since it is not feasible by setting the menu or excel as column filterType when the grid contains the filterType as filterBar . If you need to use either Menu filter or excel filter for specific columns, we suggest you to use Menu filter or Excel filter as grid filterType. 

Please let us know if you need further assistance. 
Balasubramanian Masilamani 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon 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.Close Icon