[Libreoffice-bugs] [Bug 143976] Can't enter in Calc numbers consisting of more than 16 digits

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Aug 20 16:55:28 UTC 2021


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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #3 from Eike Rathke <erack at redhat.com> ---
Numeric input is converted to IEEE 754 double binary floating point numbers.
They can not hold more than 14-16 decimal digits. For numeric identifiers use
text input instead, either by assigning the Text number format to the cell
prior to input, or by preceding the input with an ' apostrophe single quote,
like

'111111111111111111

-- 
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/20210820/7f758f97/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list