I am only experiencing this when I have a cell which references a cell below it and that cell references yet another but basically what is happening is it’s always one step behind. So if I have a table like this (column B tells you the formula in column C)…
and I update A1 to equal 100 I get this…
if I update it again I get this…
I can’t replicate this in jsFiddle so it might be something I’m doing wrong in the load but I don’t even know where to start looking! I looked into recalculateFull() and recalculateOptimized() but I don’t think that had anything to do with it. Do you know what could be causing this to happen?
Recalculate not working when referencing cells below
I ended up adding _this2.onAfterSetDataAtCell.apply(_this2, arguments) to the addHook function for ‘afterSetDataAtCell’ which appears to have fixed it. Hopefully it doesn’tr cause performance issues.