https://issues.apache.org/ooo/show_bug.cgi?id=125943
Issue ID: 125943
Issue Type: DEFECT
Summary: formula in text cell not resolved when cell format
changed to all/number
Product: Calc
Version: 4.1.0
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: editing
Assignee: [email protected]
Reporter: [email protected]
Formulae in text cells are not resolved when the cell format is changed to
all/number;
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)
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"
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
