=-x^y is calculated as (-x)^y whereas it should be -(x^y)
Eg. -7^2 = -49 but is displayed as +49.
This may be the result intended by a user entering such a formula, but it is inaccurate - a calculator and Google both give the correct result of -49.
FYI gnumeric also displays +49 as the result but changes the formula in the background to =(-7)^2
Confirmed with v126.96.36.199 under mint 17.2 x64.
Confirmed with v3.3.4 under windows 7 x64.
If you type in -(7^2) then the outcome is -49.
I understand you but I let you read, if interested, the long debate about it on tdf#37271
*** This bug has been marked as a duplicate of bug 37271 ***
(In reply to Julien Nabet from comment #2)
> I understand you but I let you read, if interested, the long debate about it
> on tdf#37271
> *** This bug has been marked as a duplicate of bug 37271 ***
Thanks for the reply. Maybe it *should* be set as an enhancement for a newer version of the ODF standard (1.3 ?) which handles this correctly. And let users know that they should use () when using this, in order to avoid further bugreports.
Please see my comment (13) at