[Libreoffice-bugs] [Bug 138393] New: Calc automatically evaluates arguments of if() function

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at skewray.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201121/3cd22327/attachment.htm>