[Libreoffice-bugs] [Bug 134549] New: Strange/wrong sum in Calc

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 134549
           Summary: Strange/wrong sum in Calc
           Product: LibreOffice
           Version: 6.2.5.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: jacekwr at poczta.onet.pl

Description:
I have summed up some numbers (expenses and income from few operations and as a
result I have rceived a number with a strange rest behind zero (I've double
checked, all the summed up values were limited to 2 digits):
-500,00000000000000000000       
-500,00000000000000000000       
560,27000000000000000000        
2515,76000000000000000000       
700,00000000000000000000        
-27,31000000000000000000        
-700,00000000000000000000       
-2076,03000000000000000000      
-27,30999999999990000000        Sum

Strange....

Steps to Reproduce:
1. Write down following numbers in subsequent cells (vertical): 
-500
-500
560,27
2515,76
700
-27,31
-700
-2076,03
2. Create SUM function below, or simply add-up (both give same results)
3. Increase column width and increase number of digits.
4. Have fun. ;)
5. Tip: Removing ANY number from the list makes sum correct. But that's not a
solution.

Actual Results:
-27,3099999999999

Expected Results:
-27,31


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Wersja: 6.2.5.2 (x64)
Build ID: 1ec314fa52f458adc18c4f025c545a4e8b22c159
Wątki CPU: 8; OS:Windows 10.0; UI render:domyślny; VCL: win; 
Ustawienia regionalne: pl-PL (pl_PL); Język interfejsu: pl-PL
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/20200706/fa9e112a/attachment-0001.htm>