[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

libreoffice at skewray.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|INVALID                     |---
             Status|RESOLVED                    |REOPENED

--- Comment #3 from libreoffice at skewray.com ---
Here is where I see this potential bug:

The website Alpha Vantage (alphavantage.co) allows five stock quotes per
minute.
I have a spreadsheet with several instances of
if(<VAR>,webservice("http://alphavantage.co/....","no-quote-yet") and the <VAR>
cells set to zero. As soon as I turn on "Allow Updating", the five Alpha
Vantage quotes are consumed. This means that turning on "Allow Updating"
evaluated the second "webservice()" argument, regardless of the value of the
first argument.

-- 
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/20201129/4e3bad7c/attachment-0001.htm>