recalc after changing column types formula

Suite and Optimus Suite 5
#1

Hi,

Is there a way to recalculate the entire grid after I change the formula of a column (not a cell) via JS?

i.e. if I have
myGrid.setColTypes(‘edn,edn,price,ro[=c1-10]’);

then change it using :
myGrid.setColTypes(‘edn,edn,price,ro[=c1-20]’);

Is there a process like myGrid.recalc(); which will update the grid values?
At the moment I have to reload the data, which blanks the grid and takes a while to render large data sets.

Since I’m using a data connector too, i dont really want to cycle through all the rows and mark c1 as changed which will fire off an update request.

#2

Unfortunately it’s not available to change the math formula in the column dynamically.