https://issues.apache.org/ooo/show_bug.cgi?id=120099
Priority: P3
Bug ID: 120099
Assignee: [email protected]
Summary: While a number is larger than 2 to the power of 48,it
will return incorrect result while compare with
adjacent number in formula.
Severity: normal
Issue Type: DEFECT
Classification: Application
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: AOO340
Component: editing
Product: spreadsheet
Build info: AOO3.4.1_r1351960
Steps:
1. Create a Spreadsheet file.
2. Input a number which is larger than 2^48 (281474976710656) into A1.
Say, 281474976710657.
3. Input a adjacent number into A2. Say, 281474976710656.
4. Write a formula to compare the two numbers. Such as, "=A2-A1". or "=A2>A1".
Issue:
The two number will be regarded as equal numbers.
A2-A1 will return 0, and A2>A1 will return FALSE.
--
You are receiving this mail because:
You are the assignee for the bug.
