https://bugs.documentfoundation.org/show_bug.cgi?id=173147
Bug ID: 173147
Summary: Miscalculation in subtration
Product: LibreOffice
Version: 26.2.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I encountered this odd behavior in Calc that adds a value at the 12th decimal
point when I copied the result and pasted it into another app. So far, I could
reproduce it by subtraction numbers around 19000-19999. It disappears with
numbers larger than ~20600.
Please see the examples below:
19755.7000000000000 A
19623.4200000000000 B
132.2800000000030 A – B
19475.7000000000000 A
19847.5000000000000 B
-371.7999999999990 A – B
19999.7500000000000 A
19623.5300000000000 B
376.2200000000010 A – B
19893.4500000000000 A
19623.8300000000000 B
269.6199999999990 A – B
19975.7000000000000 A
19847.5000000000000 B
128.2000000000010 A – B
20409.5600000000000 A
19623.2800000000000 B
786.2800000000030 A – B
20589.3100000000000 A
19623.5300000000000 B
965.7800000000020 A – B
Steps to Reproduce:
1. Subtracting 19623.83 from 19893.45 generates 269.619999999999 instead of
269.62
2. Subtracting 19847.50 from 19475.70 generates -371.799999999999 instead of
-371.80
3. Subtracting 19623.53 from 20589.31 generates 965.780000000002 instead of
965.78
Actual Results:
Please see examples above.
Expected Results:
The extra values should not be added.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
The odd thing is that these minor errors in calculation happen in other
spreadsheet apps as well, such as MS Excel, OnlyOffice, and Google Sheets. What
is going on?
--
You are receiving this mail because:
You are the assignee for the bug.
