[Libreoffice-bugs] [Bug 134168] New: LibreOffice Calc wrong calculation

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: anonimou_eu at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200620/64477849/attachment.htm>