<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Incorrect result for len function for large numbers"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108690">bug 108690</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Incorrect result for len function for large numbers"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108690#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Incorrect result for len function for large numbers"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108690">bug 108690</a>
from <span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span></b>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>