none
Update JS Grid totals row on cell edit RRS feed

  • Question

  • Hi all,

    We would like to create a page with pivoted JS grid which displays group rows and enables editing cells (got this far), and now we want to display subtotal values within the group rows. Any idea how we can achieve such behavior?

    Roy


    Royg
    Tuesday, June 14, 2011 8:32 AM

Answers

  • Hello Royg,

    I guess that you can use OnCellEditCompleted event in Jsgrid & on this event , You can get the sum of the values for a specific columns in JSgrid. This event occurs on a page refresh (an onLoad event).


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    • Marked as answer by Roy.G Tuesday, June 14, 2011 9:58 PM
    Tuesday, June 14, 2011 10:37 AM

All replies

  • Hello Royg,

    I guess that you can use OnCellEditCompleted event in Jsgrid & on this event , You can get the sum of the values for a specific columns in JSgrid. This event occurs on a page refresh (an onLoad event).


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    • Marked as answer by Roy.G Tuesday, June 14, 2011 9:58 PM
    Tuesday, June 14, 2011 10:37 AM
  • Thanks for the reply Amit,

    I used that approach exactly and finally got it working.

    I guess I assumed there would be an easier way to accomplish that but I think that the documentation for JSGrid programming is currently lacking examples and details about the methods and events and we'll have to wait a bit longer for that.

    Regards,

    Roy


    Royg
    • Marked as answer by Roy.G Tuesday, June 14, 2011 9:57 PM
    • Unmarked as answer by Roy.G Tuesday, June 14, 2011 9:58 PM
    Tuesday, June 14, 2011 9:55 PM
  • Hello Roy,

    Could you please explain, how did you enable cell editing in pivoted grid?

    Thanks,

    Sandy

    Monday, July 4, 2016 5:09 PM