[Libreoffice-bugs] [Bug 139306] New: UI: numerical string in formula bar (input line) and cell editing truncated (to 20 digits)

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 139306
           Summary: UI: numerical string in formula bar (input line) and
                    cell editing truncated (to 20 digits)
           Product: LibreOffice
           Version: 7.1.0.0.alpha0+
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: newbie-02 at gmx.de

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:

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