https://bugs.documentfoundation.org/show_bug.cgi?id=162448
Bug ID: 162448
Summary: Sums in Calc are not correct
Product: LibreOffice
Version: 24.2.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
In this sheet i noticed that deciml are wrong.
How i can send Calc file?
413,60000000000000000 +
485,80000000000000000 +
-898,60000000000000000 +
0,00000000000000000 +
0,00000000000000000 =
0,80000000000001100
1.072,81300000000000000 +
364,35000000000000000 +
453,29700000000000000 +
0,00000000000000000 +
0,00000000000000000 +
1.890,46000000000000000 -
1.809,94800000000000000 =
-80,511999999999900
Steps to Reproduce:
A1: 413,60000000000000000 +
A2: 485,80000000000000000 +
A3: -898,60000000000000000 +
A4: 0,00000000000000000 +
A5: 0,00000000000000000 =
SUM(A1:A5)= 0,80000000000001100
A1+A2+A3+A4+A5 = 0,80000000000006800
413,60000000000000000
485,80000000000000000
-898,60000000000000000
0,00000000000000000
0,00000000000000000
=SOMMA(A1:A5)
=+A1+A2+A3+A4+A5
Actual Results:
SUM(A1:A5)= 0,80000000000001100
A1+A2+A3+A4+A5 = 0,80000000000006800
Expected Results:
0,8000000000000000000000
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 24.2.5.2 (X86_64) / LibreOffice Community
Build ID: bffef4ea93e59bebbeaf7f431bb02b1a39ee8a59
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: it-IT (it_IT); UI: it-IT
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
