Edit cell capability

6 posts, 0 answers
  1. Chris Fitch
    Chris Fitch avatar
    4 posts
    Member since:
    Mar 2010

    Posted 24 Oct 2012 Link to this post

    While many pivot tables are aggregates, there is plenty of usefullness to have the 3-d format of a pivot and still be able to handle if the user would like to update a cell value in the aggregate section. Is there anyway to do this?
  2. Tsvetoslav
    Admin
    Tsvetoslav avatar
    1823 posts

    Posted 26 Oct 2012 Link to this post

    Hi Samuel,

    RadPivotGrid does not support this feature since the very concept of pivot data does not allow for it - you will getting wrong calculations and hence misleading reports.


    Regards, Tsvetoslav
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Chris Fitch
    Chris Fitch avatar
    4 posts
    Member since:
    Mar 2010

    Posted 26 Oct 2012 Link to this post

    How does the concept prohibit this? When selecting a cell, you should be able to edit the values behind that cell. I think you would call this 'drilling down'? Anyhow, I still dont see why Telerik Devs have assumed that there would be no good reason to select cells. It's not good practice for the designers to be so restrictive of functionality. It's a grid for goodness sake, it makes sense to allow for cell/row/column 'selection' at the least.

    If you ask me, it's better practice to leave the restricting up to the end users, while the devs focus on giving the tools diverse functionality.
  5. Tsvetoslav
    Admin
    Tsvetoslav avatar
    1823 posts

    Posted 29 Oct 2012 Link to this post

    Hi Samuel,

    Pivot grid is used to display results not edit them because those results come as the product of certain calculations. That's what I meant by the concept of pivot tables. If, for example, you need the quarter cost of a given company product for the current year, RadPivotGrid will display the result but what would be the use of editing that result when it is a calculated value not a raw one?


    Greetings, Tsvetoslav
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  6. Chris Fitch
    Chris Fitch avatar
    4 posts
    Member since:
    Mar 2010

    Posted 31 Oct 2012 Link to this post

    I think I see what you're saying.
    I understand that the cells themselves do not house the 'raw data' but are aggregates. Still, I'm hoping for some way to edit the cells that compose the aggregate.

    • Ex.
      Double clicking a cell would pop-up the table of cells that compose the data aggregate. this could be done recursively until you hit 'raw data' in which case a double click would allow you to change that certain cell's value.

    I still think there is benefit to selecting even aggregated cells. This way, due to call back functions associated with this sort of functionality, at the very least the end user could devise some sort of edit form, or further desired functionality using the selected value.

    Editing aggregated cells data aside, please make a point to bring up the versatility that would come with having single + multi/cell selection (along with the call backs associated with them) in the RadPivotGrid.

  7. Tsvetoslav
    Admin
    Tsvetoslav avatar
    1823 posts

    Posted 01 Nov 2012 Link to this post

    Hello Samuel,

    Thanks for the clarification.

    Please, use PITS (public issue tracking system) to make this feature suggestion for RadPivotGrid. You should be able to find the issue tracker from your customer's account.


    Regards, Tsvetoslav
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017