<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Calc automatically evaluates arguments of if() function" href="https://bugs.documentfoundation.org/show_bug.cgi?id=138393#c8">Comment # 8</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Calc automatically evaluates arguments of if() function" href="https://bugs.documentfoundation.org/show_bug.cgi?id=138393">bug 138393</a> from <a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> Eike Rathke</a> <pre>Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=168714" name="attach_168714" title="IF() with LOGGER() function">attachment 168714</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=168714&action=edit" title="IF() with LOGGER() function">[details]</a> IF() with LOGGER() function The claim is simply not true, the paths in IF() are not evaluated unconditionally. Attached is a document with a BASIC macro function LOGGER() that increments a static variable each call and returns the value. In cell A1 is a formula =IF(B1;LOGGER();"no") where if B1 is 0 or empty LOGGER() is not called and "no" is returned, otherwise (numeric B1 <> 0) LOGGER() is called and the overall call count is returned by IF(). With B1 0 or empty hit F9 a few times on cell A1 or reinput 0 in B1 repeatedly, then enter 1 in B1 and see A1 is incremented by just one of the previous value; toggle and repeat. However, a call to WEBSERVICE() accesses the URI more than once, for example once with an OPTIONS request, then with a HEAD request and finally the GET request. If Alphavantage counts each request against your quota and not only the GET request there's nothing we can do about that.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>