https://bugs.documentfoundation.org/show_bug.cgi?id=172516
Robert Lacroix <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|NOTABUG |--- Ever confirmed|0 |1 Status|RESOLVED |REOPENED --- Comment #5 from Robert Lacroix <[email protected]> --- (In reply to Werner Tietz from comment #4) > you copy&paste a formula with a relative reference to »one row above« into > B1 … but in Cell B1 there exists no »one row above« so the #REF-error is > triggered! > > > ⇒ NAB Sure that is the expected result. But when the zombie condition arises, the #REF! cell value disappears and B1 shows an actual number even though the formula contains #REF!. That's part 1. B1 is supposed to show #REF! as the result but instead it shows a number. Part 2 is: B2:B101 do not contain formula dependencies to B1. In fact the formula for B2 still shows as '=(A2-A1)^2'. However the calculated in B2 behaves like A1 is 0 instead of 1. Note that A1 is the constant 1 *not a formula*. -- You are receiving this mail because: You are the assignee for the bug.
