https://bugs.documentfoundation.org/show_bug.cgi?id=108783
Bug ID: 108783
Summary: wrong display of 2^47 .. 2^53 when fractional digits
are 16 .. 20
Product: LibreOffice
Version: 5.3.1.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 134284
--> https://bugs.documentfoundation.org/attachment.cgi?id=134284&action=edit
powers of 2 (2^0 .. 2^64) with fractional digits 0 .. 20, err in R49 .. V55
wrong display of powers of 2 from 2^47 until 2^53
when fractional digits are between 16 and 20
example:
type in A1: =2^47, you get correctly: 140737488355328
press repeatedly the '0.00+' button to increase fractional digits, you get:
15 digits: 140737488355328.000000000000000 RIGHT
16 digits: 14073748835532.8000000000000000 WRONG
17 digits: 1407374883553.28000000000000000 WRONG
18 digits: 140737488355.328000000000000000 WRONG
19 digits: 14073748835.5328000000000000000 WRONG
20 digits: 1407374883.55328000000000000000 WRONG
the wrong values are not only displayed on screen
but also written out when you save in .csv format
--
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
