startfastoperations and math cells (sum) in treegrid

Discontinued products Uncategorized discussions
#1

Hello



We have a Treegrid with math-cells to auto-calculate the sums of the trees leaves/children.



If we add some rows and set values within startfastoperations() and stopfastoperations() the sums are not updated, the footer on the other hand is. How do we redraw/recalculate the grid after stopfastoperations()?



Thanks



#2

Unfortunately it’s impossible to force math operation if you are adding rows in treeGrid with fast operations. To make math operation work you should not use fast operations when adding rows.

#3

Maybe it should be possible to tell the Grid/Treegrid to recalculate itself after fast operations are completed. The Formulaes are still there (but wrong) but the Footers are displaying the “right” values.


#4

If you have formulas in some specific column. After adding all rows, and calling stopfastoperations you can use a code similar to the next

grid.forEachRow(function(id){
var cell = grid.cells(id,index).cell;
grid._calcSCL(cell);
});

where index - index of the column for which math need to be reapplied

#5

If you need trigger [=sum] recalculation, you can call
grid.callEvent(“onXLE”,[]);