Handsontable公式返回#NEED_UPDATE [英] handsontable formula returning #NEED_UPDATE

问题描述

例如，我有一个handontable:

I have a handsontable, for example:

+---+------+-------+-------+
|   |  A   |  B    |  C    | 
+---+------+-------+-------+
| 1 |  10  | 20    |  30   |
+---+------+-------+-------+
| 2 |  5   |=0.5+A3|=0.5+B3|
+---+------+-------+-------+
| 3 |=A1+A2|=B1+B2 |=C1+C2 |
+---+------+-------+-------+

在加载表时，B2和C2的值为#NEED_UPDATE，而不是其公式的计算结果.该如何处理?

when the table is loaded, B2 and C2 has value of #NEED_UPDATE instead of calculation result of its formula. how to handle this issue?

推荐答案

没关系，我解决了这个问题.添加afterRender回调:

Nevermind, I solved this. add afterRender callback:

afterRender: function(){
    this.setDataAtCell(ROW, COL, FORMULA);
}

这将自动更新右侧的所有单元格.

this will automatically update all cell to the right.

这篇关于Handsontable公式返回#NEED_UPDATE的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！