In le calc
should evaluate to ~0.28. But it evaluates to ~3.5.
It can be 'fixed' by adding a "1*":
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.
User Profile Reset: No
What's the value of A25 ?
Please attach a sample document, as this makes it easier for us to verify the bug.
(Please note that the attachment will be public, remove any sensitive information before attaching it.
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
-5^2 is evaluate in Calc (& Excel) as (-5)^2 and not -(5^2).
The minus sign apply to the following number, not to the whole calculation.
It is not a bug.
@ Xisco Faulí
A25 is just 1.
Sorry forgot to replace it.
Thanks, that seems to be it.
Confusing, but apparently not a but...