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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #8 from Eike Rathke <erack at redhat.com> ---
Created attachment 168714
  --> https://bugs.documentfoundation.org/attachment.cgi?id=168714&action=edit
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.

-- 
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/20210106/5ccb830e/attachment-0001.htm>