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
Created attachment 174450 [details] Example demonstrating wrong behaviour of long numbers
Created attachment 174451 [details] Scctreenshot of what I see in attached sample file
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