[Libreoffice-bugs] [Bug 127746] New: Computation error with negative sign in some instances

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=127746

            Bug ID: 127746
           Summary: Computation error with negative sign in some instances
           Product: LibreOffice
           Version: 6.0.7.3 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: oliver.schib at gmx.ch

Description:
Hi

In le calc
the expression
=EXP(-(LOG(A25)-LOG(0.08))^2/(2*0.69^2))
should evaluate to ~0.28. But it evaluates to ~3.5.
It can be 'fixed' by adding a "1*":
=EXP(-1*(LOG(A25)-LOG(0.08))^2/(2*0.69^2))
So the negative sign seems to be the problem.
However it is not clear (to me at least), why this happens here and not
elsewhere. E.g. exp(-5) and exp(-(5)) evaluate correctly.

Steps to Reproduce:
1. Enter =EXP(-1*(LOG(A25)-LOG(0.08))^2/(2*0.69^2)) into a cell and hit Enter
key.
2.
3.

Actual Results:
3.53817919028921


Expected Results:
0.282631247943737



Reproducible: Always


User Profile Reset: No



Additional Info:

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190924/4b727bee/attachment.html>