The filtering function is invalid when the pane is frozen

[kk]

 I tried to reproduce the problem with sample:

• When I freeze the first row, the filtered data comes out, but the new data does not re-render the table, so I see all the data before the filtering. As shown in the figure, I just want to see 'Sufficient' but it is not displayed.

Attachment: spreadsheetBug.docx_af397d6f.zip

[kk]

Chrome browser: Version 94.0.4606.81（Official Build） (arm64)

[Mohan Kumar Ramasamy]

Hi KK, 

We have checked your reported query. We would like to let you know that Spreadsheet freeze pane support has some limitations. Please check the below link.  

Documentation link: https://ej2.syncfusion.com/vue/documentation/spreadsheet/freeze-pane/#limitations  

However, we have already considered this as an improvement and the fix will be available our Essential studio Volume 4 main release, which is scheduled to be rolled out on December 17th, 2021. We appreciate your patience until then.  

  

You can also track the status of this improvement by using our feedback portal link below.  

 

Feedback: https://www.syncfusion.com/feedback/29037/filter-sort-merge-and-hide-of-columns-with-freeze-pane  

 

Please get back to us, if you need further assistance.   

 

Regards,  

Mohan kumar R 

[Thaneegairaj Sankar]

Hi KK,

We are sorry for the delay. 

We are currently working on this improvement with high priority, and we need to ensure all the possible cases. So, we have planned to include this in our 12^th January ,2022 patch release. We appreciate your patience until then.

You can also track the status of this bug by using below feedback portal link.    

Feedback Link: https://www.syncfusion.com/feedback/29037/improvement-of-freezepanes-with-filter-sort-merge-and-hide-row-column-features

Regards,            

Thaneegairaj S

[Thaneegairaj Sankar]

Hi KK,

We are currently working on this improvement with high priority, and we need to include all the possible cases. So, we have planned to include this in our Essential studio volume 4 SP release, which is scheduled to be rolled out on the month of February 2022. We appreciate your patience until then.

You can also track the status of this by using below feedback portal link.    

Feedback Link: https://www.syncfusion.com/feedback/29037/improvement-of-freezepanes-with-filter-sort-merge-and-hide-row-column-features

Regards,            

Thaneegairaj S

[Thaneegairaj Sankar]

Hi KK, 

 

We are glad to announce that our weekly patch release (19.4.50) is rolled out. We have improved filtering, sorting, show/hide rows and columns functionalities for spreadsheet freeze pane in this release. So, we suggest you upgrade our Syncfusion packages to our latest version. (19.4.50). 

 

Package Link: https://www.npmjs.com/package/@syncfusion/ej2-angular-spreadsheet/v/19.4.50 

 

Feedback Link: https://www.syncfusion.com/feedback/29037/improvement-of-freezepanes-with-filter-sort-merge-and-hide-row-column-features 

 

Regards, 

Thaneegairaj S