Editing using DexExpress PivotGridControl

Question

I have a WinForm with a PivotGridControl bound to a DataTable. There is one field on the datatable that I want to allow the user to update.

I have figured out how to associate an editor with the field. When the user clicks on the cell, the editor appears, the user edits the value, and hits Enter, my EditValueChanged event handler is called and I am able to save value.

but problem comes after value is saved. my function is completed in less than a min but some how process is not completed and my UI is hanged for 50-60 seconds.

I suspect pivot grid do some calculation after editing is done, may updating total/sub total values.

I tried with switching off all type of total but no luck.

My UI become unresponsive after my function for editvalueChanged event is completed.

Can anyone help me to understand why grid is taking that much time and how can I by pass it.

void pivotGridControl_EditValueChanged(object sender, EditValueChangedEventArgs e) {
            PivotDrillDownDataSource ds = e.CreateDrillDownDataSource();
            for (int j = 0; j < ds.RowCount; j++) {
                ds[j][e.DataField] = Convert.ChangeType(e.Editor.EditValue, ds[j][e.DataField].GetType());
            }
        }

I am using Devex v14.1.

Whenever I make change in grid EditValueChanged event fired. So we can say we made change in one cell at a time this event will be fired once and will be ds.rowCount =1.

Also my method completed in less than 1 second. once the method is completed UI is hanged to 50-60 secs. There is no code in my solution which is executing during this 50-60 secs.

I have around 300 MB of data in grid.