Edit Cells in pivot grid

[harald]

Hello,
i want to display a matrix that holds a weighted graph, so for example:
               Point A   Point B    Point C
Point A     10             1          15
Point B     15             8           8
Point C     5               10         1

The pivot control looks very nice and it is also possible to create categories and collapse them, 
but how can i edit the cells? 
It would be enough to double click on a cell and edit it in another window ...
thanks!

[harald]

nobody an idea 

[Rosen Vladimirov]

Hi Harald,

You are not able to edit the value in the cells. You can use a custom CellTemplate and put TextBox in it. This way you'll be able to edit the cells, but the changes will not be applied to the ItemsSource and the GrandTotals.
For example if you have:

	A	B	Grand Total
C	1	2	3
D	3	4	7
Grand Total	4	6	10

And you change the value in cell A-C from 1 to 2, the Grand Total will not change. RadPivotGrid is used to aggregate values, if you want to edit the values, I suggest you to use RadGridView.

Hopefully this helps.

Greetings,
Rosen Vladimirov
the Telerik team