The operator preference between sign (-/+) and power (^) is incorrect. The pow operator shall have higher preference than the sign operator: Scenario example: =-7^2 The result is -7*7 = -49 The shown result is (-7)*(-7) = 49, which is wrong. Note: If you compare with excel, it has also this issue. Other software like Wolframalpha manage it correctly.
*** This bug has been marked as a duplicate of bug 44076 ***
Bah, sorry, it's not a duplicate of that one.. but I'm almost sure we have that already somewhere, if not then from old OOo times. Maybe we could change input of =-x^y to =(-x)^y to clarify that this is what will be calculated.
(In reply to Adrian Maire from comment #0) > Note: If you compare with excel, it has also this issue. > Other software like Wolframalpha manage it correctly. Always good for interesting discussions ;)
(In reply to Eike Rathke from comment #2) > Bah, sorry, it's not a duplicate of that one.. but I'm almost sure we have > that already somewhere, if not then from old OOo times. > > Maybe we could change input of =-x^y to =(-x)^y to clarify that this is what > will be calculated. Dup of tjis one ; https://bugs.documentfoundation.org/show_bug.cgi?id=37271 *** This bug has been marked as a duplicate of bug 37271 ***
*** Bug 50596 has been marked as a duplicate of this bug. ***