[Libreoffice-bugs] [Bug 143976] New: 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 15:24:14 UTC 2021


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

            Bug ID: 143976
           Summary: Can't enter in Calc numbers consisting of more than 16
                    digits
           Product: LibreOffice
           Version: 7.2.0.4 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: andis.lazdins at gmail.com

Description:
I'm made list of fuel cards and realized that I can't enter any number longer
than 16 digits. Fuel card number contains 18 digits. All numbers consisting
from more than 16 digits are recognized as scientific decimal number. This
behavior is appears in Libreoffice 7.1 and 7.2.


Steps to Reproduce:
1.Open empty sheet in calc (example is attached).
2.In any cell, e.g. A1 enter 111111111111111111 (at least 17 digits)
3.Press Enter and, if necessary, change number format to Number > '-1235'

Actual Results:
111111111111111000 appears instead of 111111111111111111 and the number is
recognized as large scientific decimal number.

Expected Results:
111111111111111111 appears on a screen and is recognized as number


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
I tried to change language settings to EN, but it didn't changed the behavior.

Version: 7.2.0.4 / LibreOffice Community
Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: lv-LV (en_US.UTF-8); UI: en-US
Calc: CL

-- 
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/a98040c9/attachment.htm>


More information about the Libreoffice-bugs mailing list