Description: -(A1)^2 yielded (A1)^2 instead of -((A1)^2) Steps to Reproduce: 1.type a value in A1 2.type somewhere =-(A1)^2 3. Actual Results: (A1)^2 Expected Results: -((A1)^2) Reproducible: Always User Profile Reset: No Additional Info: caramba
see https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#__RefHeading__711840_826425813 section 5.5 Operators Note 1: Prefix “-” has a higher precedence than “^”, “^” is left-associative, and reference intersection has a higher precedence than reference union. So, if I understand correctly, not a bug.
*** This bug has been marked as a duplicate of bug 114929 ***