[Libreoffice-bugs] [Bug 108690] Incorrect result for len function for large numbers

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue Jun 27 15:04:34 UTC 2017


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

--- Comment #5 from Andy Champ <andycham+076 at amazon.co.uk> ---
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 :(

-- 
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/20170627/87e64e7d/attachment.html>


More information about the Libreoffice-bugs mailing list