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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sun Aug 15 11:54:11 UTC 2021


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

Jean-Baptiste Faure <jbfaure at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jbfaure at libreoffice.org
         Whiteboard| QA:needsComment            |
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW

--- Comment #1 from Jean-Baptiste Faure <jbfaure at libreoffice.org> ---
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

-- 
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/20210815/b3e0feed/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list