<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:libreoffice@skewray.com" title="libreoffice@skewray.com">libreoffice@skewray.com</a>
</span> changed
<a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - Calc automatically evaluates arguments of if() function"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138393">bug 138393</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>INVALID
</td>
<td>---
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>RESOLVED
</td>
<td>REOPENED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - Calc automatically evaluates arguments of if() function"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138393#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - Calc automatically evaluates arguments of if() function"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138393">bug 138393</a>
from <span class="vcard"><a class="email" href="mailto:libreoffice@skewray.com" title="libreoffice@skewray.com">libreoffice@skewray.com</a>
</span></b>
<pre>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("<a href="http://alphavantage.co/">http://alphavantage.co/</a>....","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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>