[Libreoffice-bugs] [Bug 132990] New: The sum of these specific numbers all of which have a maximum of two decimal places produces a wrong result that has 14

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 132990
           Summary: The sum of these specific numbers all of which have a
                    maximum of two decimal places produces a wrong result
                    that has 14
           Product: LibreOffice
           Version: 3.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: simsalternateemail at gmail.com

Description:
I pasted in a series of numbers from a CSV. When I added a SUM function to
calculate the total, the expected number was 5.31 (Produced in Google Sheets),
but LibreOffice produced 5.31000000000005 which in incorrect. This happened
regardless of which cells were used. Changing the third value (-699.26) to
something with a single decimal place seems to fix the issue, but using two
decimal places here seems to cause it.

The numbers are the following:
-10.19
108.47
-699.26
47.99
3.96
32.32
8.68
6.14
6.14
35.7
10.12
7.85
33.89
21.44
3.36
7.76
15.81
25.96
-7.76
51.8
146.89
32.75
23.98
31.63
59.88



Steps to Reproduce:
1.Paste in the sequence of numbers that were provided in the description onto a
single column
2.Add a sum function anywhere to calculate the total those numbers
3.

Actual Results:
LibreOffice calculated 5.31000000000005

Expected Results:
Should have calculated 5.31


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Please note that you have to expand the column for the whole number to be
visible. Looks alright when you have it at the default length

Happens both with and without OpenGL Enabled

Version: 6.3.4.2 (x64)
Build ID: 60da17e045e08f1793c57c00ba83cdfce946d0aa
CPU threads: 16; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: en-CA (en_CA); UI-Language: en-US
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/20200513/4288240c/attachment.htm>