Edit/Update Cells data in Pivot Grid

2 posts, 0 answers
  1. Astena
    Astena avatar
    1 posts
    Member since:
    Dec 2012

    Posted 23 Aug 2013 Link to this post


    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. 
  2. Rosen Vladimirov
    Rosen Vladimirov avatar
    640 posts

    Posted 26 Aug 2013 Link to this post


    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.

    Rosen Vladimirov
    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 >>
Back to Top