https://bugs.documentfoundation.org/show_bug.cgi?id=129220
Bug ID: 129220
Summary: I'm getting a repeatable error with the SUM() function
Product: LibreOffice
Version: 6.2.8.2 release
Hardware: Other
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: andrew...@biagionelli.com
Description:
The sum of 12 numbers using the SUM() function should be exactly 0.11, but
instead comes out to be: 0.10999999999999900000
Doing an individual sum (A2+A3+...A13) gives the correct 0.11
Worse, the difference between these two gives: 0.00000000000000056899 instead
of the expected 0.00000000000000100000
Details of the actual numbers used is below, in "steps to reproduce".
Detailed version & equipment info:
- Calc reports:
Version: 6.2.8.2 (x64)
Build ID: f82ddfca21ebc1e222a662a32b25c0c9d20169ee
CPU threads: 8; OS: Windows 10.0; UI render: default; VCL: win;
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
- Windows reports:
Processor: Intel Core i5-8265U @ 1.60GHz 1.80 GHz
Steps to Reproduce:
1. In cells A2:A13 I have the following exact numbers (NOT formulas):
-37.12
0
18.56
0
0
0
0
0
18.56
0.11
2. In cell A15 I have:
=IF(A16="","",SUM(A2:A13))
3. In cell A16 I have:
=A2+A3+A4+A5+A6+A7+A8+A9+A10+A11+A12+A13
4. In cell A17 I have:
=IF(A15=A16,"",A16-A15)
5. Now, cells A15-A17 show the following values:
A15: 0.10999999999999900000
A16: 0.11000000000000000000
A17: 0.00000000000000056899
I tried this in a new spreadsheet (cell A1 is empty).
Actual Results:
A15: 0.10999999999999900000
A16: 0.11000000000000000000
A17: 0.00000000000000056899
Expected Results:
A15: 0.11000000000000000000
A16: 0.11000000000000000000
A17: 0.00000000000000000000
Reproducible: Always
User Profile Reset: Yes
Additional Info:
- LibreOffice Calc Help -> About reports:
Version: 6.2.8.2 (x64)
Build ID: f82ddfca21ebc1e222a662a32b25c0c9d20169ee
CPU threads: 8; OS: Windows 10.0; UI render: default; VCL: win;
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
- Windows 10 Settings -> About reports:
Processor: Intel Core i5-8265U @ 1.60GHz 1.80 GHz
Windows 10 Home
Version 1903
OS Build 18362.476
--
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
