Recalculate not working when referencing cells below

Tags: #<Tag:0x00007f0b033ef340>

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?

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.

Thank you for an update @tbenjamin

I’m glad that you’ve found a fix.