Grid Excel filter is giving error

[Preity]

Excel filter is giving an error. I am using version 18.4.0.34. When I click the filter it gives the below error in console:

Uncaught TypeError: Cannot read property 'parentsUntil' of undefined

    at HTMLDivElement.openExcelDialog (excelFilter.js:15)

openExcelDialog @ excelFilter.js:15

[Rahul Narayanasamy]

Hi Preity, 

Greetings from Syncfusion. 

Query: Grid Excel filter is giving error  

We have validated your query and we need more details regarding the reported problem. Could you please share the below details. It will be helpful to validate and provide a better solution. 

• Full Grid code snippets?
• We might suspect that you have customized the filtering operation in the Grid. Whether did you performed any customization in the Grid?
• Video demonstration of the problem.
• Share a simple reproduceable sample if possible.

Regards, 

Rahul 

[Preity]

Hi Rahul,

Sorry I totally forgot to mention the customization.

Yes, there is customization in the grid. I wanted a control to bulk edit the columns and you guys suggested some javascript code and I'm using that. Below is the forum link of that

https://www.syncfusion.com/forums/151772/controls-to-update-all-the-filtered-rows

And because of this customization, it renders the custom filter area(which I'm using for bulk editing) and excel filter both as you can see in the screenshot in my last post.

Please find the attached code for the same. I recently upgraded to version 18.4.0.34 and after that only I'm getting this error.

Attachment: BlazorApp_ExcelFilterError_a7b43359.zip

[Preity]

Hi There,

I really need to solve this as soon as possible. Can you please check the Excel java script which I'm using in the code(attached in my last reply) and tell me what do I need to change for the filters to work again?

[Rahul Narayanasamy]

Hi Preity, 

Sorry for the inconvenience. 

We have validated your query with the provided details and we can able to reproduce the problem in the customized sample. We have improved most of the features and operations in our latest release. So most of the operations and features works without using Javascript intervention. Due to this improvements, you have faced this problem in the previously provided customized solution. 

We have considered this requirement as an usability improvement feature and logged the improvement report for the same. Thank you for taking the time to request this improvement “Need to provide support for opening the filter popup using C# method” and helping us improve our product. At Syncfusion, we are committed to fixing all validated defects (subject to technological feasibility and Product Development Life Cycle ) and including the improvement feature in our upcoming weekly release which is expected to be rolled out on or before mid of March 2021. Until then we appreciate your patience.  

  

You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link.      

  

https://www.syncfusion.com/feedback/22104/need-to-provide-support-for-opening-the-filter-popup-using-c-method 

After including this feature, we will customize the sample to achieve your requirement. We will render the filter icon in Grid header using HeaderTemplate instead rendered using Javascript(like previously shared solution). 

Regards, 

Rahul 

[Vignesh Natarajan]

Hi Preity,  

 

We would like to inform you that we are unable to include the usability improvement “Need to provide support for opening the filter popup using C# method” as promised. At the planning stage for every release cycle, we review all open features and identify features for implementation based on specific parameters including product vision, technological feasibility, and customer interest.  

  

You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link.          

  

https://www.syncfusion.com/feedback/16743/improve-support-to-draganddrop-between-different-model-grids  

 

We do not have immediate plan to implement this feature and it will be included in any of our upcoming releases. Please cast your vote to make it count. So that we will prioritize the features for every release based on demands.  

 

Please let us know if you have any concerns. 

 

Regards, 

Vignesh Natarajan