https://bugs.documentfoundation.org/show_bug.cgi?id=138393
--- Comment #8 from Eike Rathke <er...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
