Flexsheet Grouprow in column footer is not working in column with custom footer

Flexsheet Grouprow in column footer is not working in column with custom footer

Posted by: trupti.rathod on 21 May 2019, 8:29 pm EST

• 

  trupti.rathod

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 21 May 2019, 8:29 pm EST - Updated 3 October 2022, 11:01 am EST

  Hi Guys,

  I am facing trouble in adding group row in flexsheet footer. I had added below code in my solution which is working fine with number column but not with formula column

  var row = new wjcGrid.GroupRow();
  
  s.columnFooters.rows.push(row);
  
  s.bottomLeftCells.setCellData(0, 0, ‘\u03A3’);

  For formula column, it sets aggregation value as 0.
  
  

  

  1053×261 10.6 KB

  Please help.

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 22 May 2019, 9:08 pm EST

  Hi,

  The formula column is showing 0 because it is a string type column and the aggregate sum of string column will be 0. The formula inside the column gets evaluated and the result is shown on the column, but the actual data stored in that column is still a string.

  In order to show the subtotal of the formula column, you can use the evaluate method of Flexsheet control and set the result on the group row. Please refer to the sample below:
  
  https://jsfiddle.net/j16mzfa0/

  ~sharad

• 

  trupti.rathod

  • Post Options:
  • Link
    Copy

  Posted 5 June 2019, 11:25 pm EST

  Hi Sharad,

  The solution worked like a charm. I was able to fix another FlexGrid filter-related issue with this solution. Like catching two fishes with one worm!

  Thank you so much.