This is a migrated thread and some comments may be shown as answers.

Edit/Update Cells data in Pivot Grid

1 Answer 286 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Astena
Top achievements
Rank 1
Astena asked on 23 Aug 2013, 12:25 PM
Hi,

I want to update the data in RadPivotGrid cells.How to customize the Pivot Grid and make it editable on click/double click.
Please suggest. 
Thanks!

1 Answer, 1 is accepted

Sort by
0
Rosen Vladimirov
Telerik team
answered on 26 Aug 2013, 03:50 PM
Hi,

I've already answered in your other thread, but I'm copying my answer here as well:

RadPivotGrid is not designed to edit the data in its cells. It is designed to show aggregated values. The problem with the editing is that the values in the cells are not single items in the ItemsSource. For example if you have Product "Copy Holder" in Promotion "Extra Discount", the cell will represent the aggregated value of all items in the source that match the product and promotion. But if you edit this value, how would you expect to change the values in the items source - add/subtract from each of the items or from a single item...

Of course, we have provided a way to modify cell template, so you can put TextBox in each cell, but modifying the value in the cell will not modify the items source and will not trigger new calculations in the Pivot Engine. In this case the calculated Totals will look incorrect. You can check this example in our sdk repository, which demonstrates how to modify cell template.

Hopefully this helps. Feel free to contact us in case you have any other problems or concerns.

Regards,
Rosen Vladimirov
Telerik
TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for WPF.
Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
Sign up for Free application insights >>
Tags
PivotGrid
Asked by
Astena
Top achievements
Rank 1
Answers by
Rosen Vladimirov
Telerik team
Share this question
or