I was playing around with formulas to try to detect them in their cells when I got this weird result:
You can see that if I evaluate whether a row is blank and then try to put a number (I tested with many numbers) the cell returns a reference to itself.
Here’s what happens if I add rows:
And then if I force reload:
Why does this happen? I expected it to return “5” because (excluding itself) the row was blank.
Interestingly, by viewing details we can then get this bug by continuously hovering over the #r1 reference (is that what we call them?)
I don’t know if this is related to the above problem or not