Bug 139306 - UI: numerical string in formula bar (input line) and cell editing truncated (to 20 digits)
Summary: UI: numerical string in formula bar (input line) and cell editing truncated (...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Calc-Formula-Bar
  Show dependency treegraph
Reported: 2020-12-29 17:00 UTC by b.
Modified: 2022-12-27 22:21 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description b. 2020-12-29 17:00:58 UTC
keying in '6,74316406210E-11' in a cell produces appr. display, but the input line shows '0,00000000006743164062' omitting the last digit '1', 

affecting plenty other figures in that range as well, only down from x,yE-15 the format for input line and cell edit change to scientific format and present all digits for editing, 

(assumption: somehow related to the number format limited to 16 significant digits and 4 fake zeroes, but in the past it was a 'relative' restriction and figures as '6,7431640621000E-12' could be handeled and edited starting with the 'real value', now it's an 'absolute' limit and everything behind the 20th decimal digit is chopped for the input line, for cell edit and e.g. copy and paste to other versions of calc, pasting to e.g. notepad works with more digits)

Steps to Reproduce:
1. key '6,74316406210E-11' into a cell, 
2. hit enter
3. observe input line showing truncated / rounded value, 
4. start editing the cell with 'F2', 
5. observe presented value for edit being truncated / rounded as well, 

Actual Results:
truncated / rounded string used, 

Expected Results:
full string or 'E-format'-string with all digits presented and editable, 

Reproducible: Always

User Profile Reset: Yes

Additional Info:
Version: (x64)
Build ID: 35e471bb4d1388cf5afcdcee214cf5111edf44e3
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win
Locale: de-DE (de_DE); UI: en-US
Comment 1 Jean-Baptiste Faure 2021-08-15 11:54:11 UTC
The last digit is not lost. You can see it if you use a scientific format with enough digits. If you paste
6,74316406210E-11 in A1
6,74316406200E-11 in A2
A3 = A1-A2
you get 9,9999E-22 = 1.E-21

The problem is that the last digits in A1 or A2 are not editable in scientific form. You can't copy and modify the content of A1 to fill A2.

Setting as NEW for that problem.

Best regards. JBF
Comment 2 b. 2021-08-15 15:54:07 UTC
@JBF: hmmm ... may be you missed the point ... e.g. 
            '6.74316406210123000000E-11' is shown as a cells value, but 
'0.00000000006743164062' is shown in the formula bar, and the same is offered for editing when i press F2. 
it's more than a problem of the last 'hidden digit', and not a problem of too few decimals for display. it's the step 'edit' in the cell and the formatting for display in the formula bar. 
reg. b.