After filter or Sort the Pivot Grid data is refreshed. Is there an event that I can use to determine when the refresh is completed?

[George Busby]

I want to do some additional changes to the format of cells after the pivot grid is refreshed after a sort or filter so I need to find an event that I can put the code into

[Duraimurugan Vedagiri]

Hi George,

Thanks for using syncfusion products.

Query : Is there an event that I can use to determine when the refresh is completed?

Yes, with help of PivotGridControl.TableControl.DataRefreshed event handler, you can determine when PivotGrid refresh is finished.

Please refer the following documentation it will help further

https://help.syncfusion.com/windowsforms/pivot-grid/data-binding#events

Regards,
Durai

[George Busby]

That sort of worked but there is an issue. The DataRefreshed event is triggered 2 times after a Sort and  a Filter ( using the drop down filter and removing a row) is executed. 

Trying to see if there is an event I have in my code that is causing the second call , but have not been able to find it. Is there something in the controls that is causing the event to be triggered 2 times?

[Duraimurugan Vedagiri]

Hi George

Thanks for your update.

We have analyzed the reported query "DataRefreshed event is trigged two times while sorting and filtering". Please understood that we are handling the DataRefreshed event for our internal purpose, so event is trigged two times. Since, the first time onwards the PivotGrid refreshing get finished based on your filtering or sorting action.

Please let us know if you need any further assistance.

Regards,
Durai