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.
Syncfusion Feedback

Grid FilterType Excel not clickable when setting columns

Thread ID:

Created:

Updated:

Platform:

Replies:

125554 Aug 24,2016 01:50 PM UTC Aug 25,2016 09:13 AM UTC ASP.NET Web Forms 1
loading
Tags: Grid
Semper
Asked On August 24, 2016 01:50 PM UTC

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 [Syncfusion]
Replied On August 25, 2016 09:13 AM UTC

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. 


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. 


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. 


CONFIRMATION

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.

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

;