Description: 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: 7.2.0.0.alpha0+ (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 Calc:
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 and 6,74316406200E-11 in A2 then 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
@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.