https://bugs.documentfoundation.org/show_bug.cgi?id=162411
Bug ID: 162411
Summary: LibreOffice Calc - sum to zero results in error
Product: LibreOffice
Version: 24.2.4.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
when using a formula such as =SUM(C116-0.05) and the result should be 0, it
results in an error 9.39526234589039E-15
Steps to Reproduce:
Create a simple cursing counter.
a1 =1
a2 =sum(a1-.05)
a3 ...
when it should read 0 on a20, it produces an such as 9.39526234589039E-15
Actual Results:
when it should read 0 on a20, it produces an such as 9.39526234589039E-15
Expected Results:
a20 should evaluate as 0
Reproducible: Always
User Profile Reset: Yes
Additional Info:
N/A
--
You are receiving this mail because:
You are the assignee for the bug.
