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

            Bug ID: 138393
           Summary: Calc automatically evaluates arguments of if()
                    function
           Product: LibreOffice
           Version: 7.0.2.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

The if() function evaluates all its arguments, regardless of the value of the
first argument. This is bad.

An example of badness is if(A1,webservice(),"-"). If A1 is false, the URL
should not be accessed. URL sites can and often changes state on access.

Fix: The second two arguments of if() should only be evaluated depending on the
state of the first argument, rather than evaluating both and then choosing.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to