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

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 108690
           Summary: Incorrect result for len function for large numbers
           Product: LibreOffice
           Version: 5.3.3.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: andycham+076 at amazon.co.uk

Description:
I was checking my arithmetic on the length of string needed to hold the decimal
representation of a large number. I found Calc's view differed from mine. On
investigation there is a jump in the result of len for large integers.

Steps to Reproduce:
1.Create new spreadsheet
2.Format cell A1 as "number, -1235" (format code 0)
3.Paste the value 1801439850948200 into cell A1
4. Increase the width of column 1 until the whole number can be seen (not ###)
5. Insert the formula =len(a1) into cell B2
6. Observe the result 16 in B2.
7. Append a zero to the number in cell A1.
8. Observe the new length 20 in B2.

Actual Results:  
20 (see step 8 above)

Expected Results:
17


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:54.0) Gecko/20100101
Firefox/54.0

-- 
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/20170622/9991ea7b/attachment-0001.html>