Author Topic: How to refresh summary row data  (Read 1924 times)

npdev13

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 21
    • View Profile
How to refresh summary row data
« on: September 06, 2019, 08:25:54 pm »
Hello,

I have pro version of pqgrid, and I have used "summaryData" and "formulas" option for sum of items in horizontally and vertically, See the attached fiddle.

http://jsfiddle.net/whj96qr0/1/

I have put top of grid left right navigation button to move cell data from left to right and vice versa for Column M1 to M6 and M6 to M1. This functionality working fine, But my problem is when I move left to right or right to left that bottom summary row total not moving.  I want to move it along with respective column or refresh it with new total. I have searched but not found any solution how to do it.

can you please help me on this critical stuff.

Thanks
« Last Edit: September 06, 2019, 08:28:38 pm by npdev13 »

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: How to refresh summary row data
« Reply #1 on: September 09, 2019, 08:54:20 am »
you need to use updateRow method to update data in rows rather than directly mutating the data rows.

https://paramquery.com/pro/api#method-updateRow