Cell formula won't be calculated after Clear()

Tags: #<Tag:0x00007efc609ceb28>
#1

https://jsfiddle.net/5zjkd7rm/

Why D5 cell is being ‘#VALUE!’ ?

I was expecting to see D5 to be ‘21’, but cell formula isn’t calculated.

I intend to refresh table data using server side logic (ex: from data to data2),
then I decided to use Clear() to make sure all cells are cleared before setting new values.

My questions would be:

  1. Is my usage for Clear() correct?
  2. What is the best coding practice when refreshing table data from server side logic?
#2

Welcome @kazuya.okamoto

Thank you for sharing this issue.

It looks like the clear() method is causing it. If we comment it out the formula is counted perfectly and the result is the same https://jsfiddle.net/zwvp8g4b/
You can load new data without using clear() the loadData(new_data) should work (and it works in the example) just perfectly.

#3

I reported the bug on our Github board https://github.com/handsontable/handsontable/issues/6248 and will inform you as soon as we get it fixed.

1 Like
#4

Hi @kazuya.okamoto

I’m writing to inform you that the issue is no longer replicable using Handsontable v9 (with the new HyperFormula engine).

Here are the changes https://github.com/handsontable/handsontable/releases/tag/9.0.0

#5