[Libreoffice-bugs] [Bug 111887] New: Nested functions return wrong values

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 111887
           Summary: Nested functions return wrong values
           Product: LibreOffice
           Version: 5.3.1.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: nemtudokolvasni at gmail.com

Created attachment 135627
  --> https://bugs.documentfoundation.org/attachment.cgi?id=135627&action=edit
Example test case

Nested ISNUMBER(), LEN(), TRUNC() functions are evaluated improperly. According
to function wizard, it's possible to get:
 * Err:502 or Err:504,
 * #VALUE!,
 * wrong type (e.g. ISNUMBER(12.16) = 5),
 * wrong value (e.g. TRUNC(12.16) = 5).

Functions can mistakenly return the result of another functions. Breaking apart
such a formula is the only solution.

-- 
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/20170817/db442e24/attachment.html>