https://bugs.documentfoundation.org/show_bug.cgi?id=40389
Buovjaga <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|WORKSFORME |NOTABUG --- Comment #23 from Buovjaga <[email protected]> --- (In reply to andréb from comment #0) > 1. Enter any value in A1 > 2. Ensure that A2 is formatted as numeric (explicitly or by default) > 3. Enter "=A1" in A2. > 4. A2 displays contents of A1. > 5. Re-format A2 as text. > 6. A2 still displays contents of A1. It should display "=A1". I still reproduce this, but contrary to my comment in 2015, I now think this is not a bug. To get the literal =A1 we can enter '=A1, but a change in formatting is not supposed to alter a cell reference. -- You are receiving this mail because: You are the assignee for the bug.
