https://bugs.documentfoundation.org/show_bug.cgi?id=153490
Bug ID: 153490
Summary: Floating point error
Product: LibreOffice
Version: 6.0.7.3 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
LibreOffice Calc is making a floating point error.
Takes a list of values "xx,xx", insert average function, calculates the
difference between each value and average, then try to sum the differences
(which must be "0"): "9,76996261670138E-15"
Steps to Reproduce:
1.Write this values in a single column:2,72
-2,28
-3,28
4,72
-0,28
2,72
-5,28
-1,28
3,72
6,72
5,72
1,72
-3,28
-0,28
1,72
4,72
-3,28
-3,28
-8,28
-0,28
0,72
-4,28
-0,28
-1,28
1,72
2. Insert SUM function
3.
Actual Results:
9,76996261670138E-15
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 6.0.7.3
Build ID: 1:6.0.7-0ubuntu0.18.04.12
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: x11;
Locale: es-AR (es_AR.UTF-8); Calc: group
--
You are receiving this mail because:
You are the assignee for the bug.
