[Libreoffice-bugs] [Bug 113260] New: FORMATTING Adding decimal place display incorrect value

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=113260

            Bug ID: 113260
           Summary: FORMATTING Adding decimal place display incorrect
                    value
           Product: LibreOffice
           Version: 5.4.2.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: cleyfaye+bugzilla at gmail.com

Description:
Adding lots of decimal places using the toolbar button cause the displayed
formatted value to be incorrect, although the real cell value remain correct.

Steps to Reproduce:
1. Open a new calc document
2. Put 111111111111111 in a cell
3. Add 16 decimal places using the toolbar button "Add decimal places"

Actual Results:  
The cell display "11111111111111.1000000000000000"

Expected Results:
Expected the cell to display "111111111111111.000000000000000"
Not getting any '1' on the right of the decimal separator was the expected
result.


Reproducible: Always

User Profile Reset: Yes, completely deleted ~/.config/libreoffice/4 before
reproducing, and changed locale to C.

Additional Info:
Same thing happen with french locale (using ',' as a decimal separator).
It doesn't happen with 14 digits, so it might be related to storage of integer
and double.


User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/61.0.3163.100 Safari/537.36

-- 
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/20171019/fe98de9e/attachment-0001.html>