[Libreoffice-bugs] [Bug 128312] New: Calculation involing some decimals return incorrect floats with 12 d.p.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 128312
           Summary: Calculation involing some decimals return incorrect
                    floats with 12 d.p.
           Product: LibreOffice
           Version: 6.3.2.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: sergeroz at gmail.com

Description:
Simple subtraction calculation with 2 decimals produces an ugly looking float
result with 12 decimal places and lots of 9's.

Steps to Reproduce:
1. Enter the following cell values:
B1: 31000.99
B2: 32000.12

2. Enter the following cell formula:
B4: =B1-B2

Expected value in B4: -999.13
Actual value in B4: -999.129999999997


Actual Results:
Actual value in B4: -999.129999999997

Expected Results:
Expected value in B4: -999.13


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.3.2.2 (x64)
Build ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: en-AU (en_AU); UI-Language: en-GB
Calc: CL

-- 
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/20191022/15cfbfef/attachment.html>