https://issues.apache.org/ooo/show_bug.cgi?id=125943
--- Comment #2 from mroe <[email protected]> --- This isn't a bug; it is the right behaviour. > 1. Open Calc > 2. create an arbitrary formula in A1 (eg "=A2") > 3. format cell B1 as text (right click on B1 - format cells - category - text) > 4. select A1 - select A1 text - copy and paste A1 text to B1 > Resultant behaviour: B1 is rendered as "=A2" (the formula is not resolved in > B1) No problem: you've copied text, you inserted text => it is text. > Expected implementation: > a) LOWPRIORITY: I would have thought an escape character (eg "\=") would have > to be used if an '=' (equals symbol) is needed to be positioned as the first > character of a text cell > b) What is more of a problem is that changing the cell format back from text > to all/number does not resolve the formula; the cell remains rendered as "=A2" That's clear. You've entered text and it stays as text. No matter which format you impose on. Calc only knows 3 input types: text, number, formulae. Any *number formatting* changes only the view of a number or a (numerical) result of a formulae. But a formatting changes never the saved input! 3 ways to enter text: 1. first character is a non-decimal 2. first (escape) character is ' 3. cell is formatted as Text -- You are receiving this mail because: You are the assignee for the issue. You are watching all issue changes.
