Hello
I have some formulas that link to previous rows. When I change the cell values the formulas update.
However when I press delete button, I have an afterChange event to set the default value to zero. But the formula row shows as #VALUE. I have to click and then press enter for the formula to update.
I tried render but the formulas are not refreshing. Is there a hook to update the values before running the formula cycle ? Or is there a formula refresh event ?