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

Popular posts from this blog

java - Date formats difference between yyyy-MM-dd'T'HH:mm:ss and yyyy-MM-dd'T'HH:mm:ssXXX -

c# - Get rid of xmlns attribute when adding node to existing xml -