https://bugs.documentfoundation.org/show_bug.cgi?id=134168
Bug ID: 134168
Summary: LibreOffice Calc wrong calculation
Product: LibreOffice
Version: 6.4.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: anonimou...@hotmail.com
Description:
A simple multiplication is giving me wrong results.
On the attached sheet, you can see below the "Total Investido" marked in red
the formula and checking the results, it is giving me wrong results, in many
repetitions.
Steps to Reproduce:
1. "Recursive" Formula: =IF(E36<0;G35;(G35*SUM(E$5:E35)+F36*E36)/SUM(E$5:E36))
2. Copy the value of last line of the "recursion"
3. Multiply it by another result from other formula (a simple SUM)
Actual Results:
Multiplication like 147*147.91 gives me 21742,53 while it should be 21742.77
123*189.88 = 23354,64 (expected 23355.24)
116.32*229 = 26638,12
Expected Results:
Wrong math resulted.
Reproducible: Always
User Profile Reset: No
Additional Info:
I'm not really sure how to report it under the "steps to reproduce" and
"results" because it seems to be a internal error on how the calculation is
done. Rounding?
I'm not really sure how to reproduce it, not using the formulas described on
the file attached.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
