[Libreoffice-bugs] [Bug 139095] New: incorrect calculation result

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 139095
           Summary: incorrect calculation result
           Product: LibreOffice
           Version: 7.0.4.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: pharmholz at gmail.com

Description:
I have a ODS file where I weekly put the recent status of my accounts and
investment portfolios. So I can check how they develop.
But when I calculate the difference of two weeks after I used the "sum"
function it shows a very small difference. Calc does not calculate correctly.
For example this week it is: 24852,02 - 24427,97 = 424,0500000000003 instead of
424,05 but I don't actually type in the numbers I refer to the cell like =
B167-B158 and within these cells I used =Summe(...:...)
As it is an overview of my bank accounts and investment portfolios I only use
two digit numbers.
I don't know where this problem comes from.

Steps to Reproduce:
1. set up two different tables with various numbers like an overview of your
accounts and you want to check how they develop
2. use the summerize function under both tables
3. calculate the difference of both sum ups

Actual Results:
424,0500000000003

Expected Results:
424,05


Reproducible: Always


User Profile Reset: No



Additional Info:
nothing

-- 
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/20201220/b8382a50/attachment.htm>