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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
