https://bugs.documentfoundation.org/show_bug.cgi?id=114879
Bug ID: 114879
Summary: Calc: comparison "=" of two large numbers incorrect
Product: LibreOffice
Version: 5.1.6.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Comparison of two large numbers (using the operator "=") within a function
gives wrong result.
Example: two cells contain a big natural, different only by 1:
A1 := 1 330 207 388 348 513
A2 := 1 330 207 388 348 514
A third cell compares them:
=IF(A1=A2;"yes";"no")
==> result "yes"
The result is wrong.
Steps to Reproduce:
1. see example in "Description"
Actual Results:
The comparison gives wrong result. There is no warning that the numbers are too
big to be handled by LibreOffice Calc.
Expected Results:
The comparison should state correctly that the two numbers are *different*.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 5.1.6.2
Build ID: 1:5.1.6~rc2-0ubuntu1~xenial2
CPU Threads: 2; OS Version: Linux 4.4; UI Render: default;
Locale: fr-FR (en_GB.UTF-8); Calc: group
User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:57.0) Gecko/20100101
Firefox/57.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
