https://bugs.documentfoundation.org/show_bug.cgi?id=146604
Bug ID: 146604
Summary: Calc - calculation error at last two digits with big
numbers (15 digits)
Product: LibreOffice
Version: 7.1.1.2 release
Hardware: Other
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
when I make a sum of two big numbers with 15 digits each, the last two digits
are not calculated correctly.
No matter if the last two digits are decimal places or not.
Steps to Reproduce:
#1
1. enter the number 5,629,499,534,213.13 in cell A1
2. double the number in A2 with =2*A1
or
#2
1. enter the number 4,503,599,627,370,496 in cell A1
2. enter the same number 4,503,599,627,370,496 in cell A2
3. in A3 sum the two above with =SUM(A1:A2)
Actual Results:
#1
11,258,999,068,426.30
#2
9,007,199,254,740,990
Expected Results:
#1
11,258,999,068,426.26
#2
9,007,199,254,740,992
Reproducible: Always
User Profile Reset: No
Additional Info:
if you go on doubling the numbers, the results are always wrong.
--
You are receiving this mail because:
You are the assignee for the bug.
