Edit Cells in pivot grid

3 posts, 0 answers
  1. harald
    harald avatar
    3 posts
    Member since:
    Oct 2010

    Posted 03 May 2013 Link to this post

    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!

  2. harald
    harald avatar
    3 posts
    Member since:
    Oct 2010

    Posted 06 May 2013 Link to this post

    nobody an idea 
  3. UI for WPF is Visual Studio 2017 Ready
  4. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 07 May 2013 Link to this post

    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  3
     D  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

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

Back to Top