<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<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#c5">Comment # 5</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:andycham+076@amazon.co.uk" title="Andy Champ <andycham+076@amazon.co.uk>"> <span class="fn">Andy Champ</span></a>
</span></b>
<pre>I could wish I hadn't started this... I also have access to MS Excel (Pro Plus,
2013) and that also has odd behaviour.
But different...
Excel gives len as 16,17,18,19,19,19... as the number grows, and
len(text(a1,"0")) as 16,17,18,19,21,22,23. (no 20!)
Which unfortunately means that the len(text workaround that works for Calc
doesn't work for Excel :(</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>