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