javascript - handsontable formula returning #NEED_UPDATE -
i have handsontable, example:
+---+------+-------+-------+ | | | b | c | +---+------+-------+-------+ | 1 | 10 | 20 | 30 | +---+------+-------+-------+ | 2 | 5 |=0.5+a3|=0.5+b3| +---+------+-------+-------+ | 3 |=a1+a2|=b1+b2 |=c1+c2 | +---+------+-------+-------+ when table loaded, b2 , c2 has value of #need_update instead of calculation result of formula. how handle issue?
nevermind, solved this. add afterrender callback:
afterrender: function(){ this.setdataatcell(row, col, formula); } this automatically update cell right.
Comments
Post a Comment