https://bugs.freedesktop.org/show_bug.cgi?id=74525
Priority: medium
Bug ID: 74525
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Other: Calculates wrong value of expression starting
with minus sign
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: surendra_beni...@yahoo.co.in
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.2.0.4 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 93398
--> https://bugs.freedesktop.org/attachment.cgi?id=93398&action=edit
A spreadsheet Which shows the expected and wrong behaviour while evaluating the
expressions.
Problem description:
Whenever I put "=-(5)^2" in any cell (without quotes) and put enter, it
calculates the value as 25, which should be -25 instead. It appears that it
takes square of -5 instead of 5. If you try =-(5)^3 then it calculates -125,
which is trivially correct.
The problem encountered when I was generating a column of y values for given x
range, for y = 10*exp(-(x-11)^2/100)
Steps to reproduce:
1. .... Open Libreoffice Calc
2. ....Put "=-(5)^2" in any cell (without quotes) and press enter.
3. ....You should expect a value -25, but it shows 25 instead.
Current behavior: -(5)^2 >>> 25
Expected behavior: -(5)^2 >>> -25
Operating System: Ubuntu
Version: 4.2.0.4 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
