Hi Todor

thanks a lot for prompt response! It's basically exactly what I needed, however, the cells still won't get updated. I still need to collapse/expand some cells or switch to compact layout in order to see the changed cells. I checked the IG source code for "AllowCompactLayout" and it just calls PivotGrid.ArrangeLayout(), too. This is now really nagging me, I just don't get it.

Anyhow, I found another solution: I use the result changed event to update the cells, exactly the same way as previously attempted in CellControlAttached, and things work now as expected.

Thanks a lot for your help!

Frank

Hi

You can use PivotGrid.ArrangeLayout() to enforce layout update.

Todor

Could someone please have a look at my previous question?

Asked in a more condensed way. How can I refresh the Pivot Grid in a way that its CellControlAttached event is fired, in order to intercept what's displayed in a cell, with an immediate update of the cell UI parts to reflect the changes?

Thanks, Frank

Normal 0 21 false false false DE-CH X-NONE X-NONE Hi Petar

Thanks again for this info. I hope this feature request becomes a popular one then, and it will be included soon :-)

Meanwhile I was able to calculate the percentages using some of the info you suggested. However, I still have a problem with updating the grid's data.

I use the grid's CellControlAttached event to obtain a cell's data and update it according to my logic:

this.PivotGrid.DataSource.Result.Cells[rowIndex, columnIndex].SetValue(percentageVal, formattedVal, displayVal);

I added a ContextMenu to the grid which lets me trigger the different presentation modes. In a menu items' click handler, I set a "presentation mode" flag which controls how the data should be formatted in the grid cells. I then trigger the CellControlAttached event by a call to  this.PivotGrid.DataSource.RefreshGrid();

The event obviously gets fired for every cell and I can see in my watch/debug window that the value was correctly updated. The UI however does  not update itself. If I switch between compact layout and normal grid mode the values then are correctly displayed. I think I miss the part to trigger a repainting of the grid cells. I do not want to refresh the data source again since that would trigger CellControlAttached event again.

Would you have an idea what I am missing here?

Thanks a lot!

Frank