Posted 3 November 2021, 9:14 pm EST
Hey guys!
I have a custom formula which works without parameters and gets a number depending on the value in first cell of the same row. Whenever I insert/delete a row, every cell that is underneath this row that has this custom formula, recalculates. If I insert a row under the cells that include this formula, they don’t recalculate.
Also, if I already inserted 1 row, then afterwards the formulas don’t recalculate anymore if I keep inserting/deleting new rows, but if I delete the newly added rows so that the amount of rows is the same as in the beginning, the formulas recalculate again.
I have tried commenting out everything I have in the following events that are being triggered (rangeChanged, rowChanged) and other possible problematic code but it still does this.
Thank you a ton for the answer!
PS: In the attached video, you can see the recalculate happening while flickering between loaded data and ‘Loading…’ as a default value.