Formula ref is not working addhook after change

Tags: #<Tag:0x00007f8b19953ea8> #<Tag:0x00007f8b19953d68>
#1

"I’ve created a fiddle where the 3rd row updates when values in the 1st and 2nd rows change, and the 4th row contains formulas like =A3 to reference the 3rd row’s values. However, the 4th row isn’t updating as expected when the 3rd row changes. I’m looking for help to identify the error in my setup.

You can access the fiddle here: Fiddle Link"

#2

Hi @santhusakalabathula

I recommend using setDataAtCell() (official method to alter data) instead of initialData[2][col] = updatedValue;. Handsontable does not support this kind of dataset alteration.

Hre’s the setDataAtCell() documentation: https://handsontable.com/docs/javascript-data-grid/api/core/#setdataatcell

#3