[Libreoffice-bugs] [Bug 108783] New: wrong display of 2^47 .. 2^53 when fractional digits are 16 .. 20

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: carlo.verre at gmail.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170626/43fb7b6a/attachment.html>