https://bugs.documentfoundation.org/show_bug.cgi?id=108690
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG
--- Comment #3 from Eike Rathke <[email protected]> ---
Note that after step 7 above (appending a zero), going back to cell A1 the
input line changed to 1.8014398509482E+016 which is the length calculated in B2
as LEN() always calculates the "raw" input number, not the formatted number.
The reason is that with appending a zero digit the number runs into a magnitude
where the double floating point loses precision, ie. it can not be
distinguished between 18014398509482000 and 18014398509482001, for example.
However, the display format for A1 forces the number to be displayed using a
non-exponential notation, note that it will display 18014398509482000 also for
18014398509482009 ...
The maximum representable integer is (2^53)-1 or 9007199254740991.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
