Grid FilterType Excel not clickable when setting columns

[Semper]

Hi,

I have an excel type filter on my ASP grid

When the grid populates the columns automatically, the filter icon (in the header, next to header text) is clickable, but when i add etc to the grid, the filter icon is no longer clickable and i get the following console error when clicking on it:

Uncaught TypeError: Cannot read property 'width' of null

the error is on this line of the js

dlgWidth = this._isExcelFilter ? this._excelFilter._dialogContainer.width() : dlgWidth;

Any help appriciated.

[Seeni Sakthi Kumar Seeni Raj]

Hi Semper, 

We are able to reproduce the problem at our end after binding empty dataSource to the Grid. The Grid will define the column type based on the value present in the first record of the data bound to the Grid.  We have already discussed about this problem and its solution in the following KB. 

https://www.syncfusion.com/kb/3539/error-in-filter-menu-number-date-and-boolean-columns-have-incorrect-operators 

Refer to the following code example and define the column type if the dataSource bound to the Grid is empty. 

 

    <ej:Grid ID="FlatGrid" runat="server" AllowScrolling="true" AllowFiltering="true" AllowSorting="true" AllowTextWrap="true"> 

       <FilterSettings FilterType="Excel"></FilterSettings> 

        <Columns> 

            <ej:Column Field="OrderID" Type="number" HeaderText="Order ID" TextAlign="Right" Width="90" /> 

            <ej:Column Field="CustomerID" Type="string" HeaderText="Customer ID" Width="150" /> 

            <ej:Column Field="EmployeeID" Type="number"  HeaderText="Employee ID" TextAlign="Right" Width="100" /> 

 . . . . . . 

        </Columns> 

    </ej:Grid> 

        protected void Page_Load(object sender, EventArgs e) 

        { 

            

        } 

We have prepared a sample that can be downloaded from the following location. 

Sample: http://www.syncfusion.com/downloads/support/forum/125554/ze/F1255541385890711.zip 

If you are still facing any problem, please share the following information to replicate the issue. 

1)      You have mentioned the columns were dynamically. Can you please explain scenario and code for dynamic render of Columns? 

2)      Code example of Grid and customized scripts 

3)      If possible, modify the attached sample and replicate the issue. 

Regards, 

Seeni Sakthi Kumar S.