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. Image for the cookie policy date

Excel-Like Filter Error In Grid, Does not display menu for only one Field

I am having an error with one of  the fields in my Grid Control. All other fields create the Excel-Like Filtering menus when the Column Filter Icon is pressed, but one filter does not display the menu, but instead creates input boxes and blank buttons below the Grid.
It look like this:
Show rows where

Attached is an image of what is created after clicking the Column Filter

Attachment: Excel_Menu_Filter_Error_39d500fd.zip

3 Replies

VN Vignesh Natarajan Syncfusion Team April 16, 2019 11:26 AM UTC

Hi Levi, 
Thanks for contacting Syncfusion Support. 
Query: “ but instead creates input boxes and blank buttons below the Grid. 
From your query, we understand that you are facing issue while opening a excel filter dialog for certain column.The reported issue may occur when there is no record in ejGrid. Or Initially rendering the Grid with empty data and later updated the dataSource. By default Grid column will assign its type based on first record.  But when we bind empty dataSource to Grid, values will be null and column type will not be assigned. Hence the reported issue occur.  
To overcome the reported issue, we suggest you to specify Type property of the column to perform the filtering operation.   
Refer to the code example:- 
<ej:Grid ID="Grid1" runat="server" AllowPaging="true"> 
            <ej:Column Field="OrderID" /> 
            <ej:Column Field="CustomerID" Type="string" /> 
            <ej:Column Field="EmployeeID" Type="number" /> 
            .   .    . 
Refer our UG and KB document fr your reference 
Please get back to us if you need any further assistance. 
Vignesh Natarajan. 

LL Levi Leonards April 17, 2019 05:15 PM UTC

Specifying the type fixed my error...thanks!

VN Vignesh Natarajan Syncfusion Team April 18, 2019 05:34 AM UTC

Hi Levi, 

Thanks for the update. 

We are glad to hear that your query has been resolved by our solution.  

Please get back to us if you have further queries. 

Vignesh Natarajan.  

Live Chat Icon For mobile
Up arrow icon