<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:h.klene@gmx.de" title="Holger Klene <h.klene@gmx.de>"> <span class="fn">Holger Klene</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - UI: INDEX function returns #VALUE error when optional arguments are omitted."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=71325">bug 71325</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;">CC</td>
<td>
</td>
<td>h.klene@gmx.de
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - UI: INDEX function returns #VALUE error when optional arguments are omitted."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=71325#c13">Comment # 13</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - UI: INDEX function returns #VALUE error when optional arguments are omitted."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=71325">bug 71325</a>
from <span class="vcard"><a class="email" href="mailto:h.klene@gmx.de" title="Holger Klene <h.klene@gmx.de>"> <span class="fn">Holger Klene</span></a>
</span></b>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=140986" name="attach_140986" title="strange index value error">attachment 140986</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=140986&action=edit" title="strange index value error">[details]</a></span>
strange index value error
I'm having trouble to make the returned arrays intersect with the current row.
It works for non-empty cells, but fails on empty cells (red in the given
document).
I thought it is due to the strange behavior of the function wizard sometimes
giving the result as a preview or failing with a value error. So clicking
different locations inside the function wizard it will suck up parameters or
add spaces.
But trying to replicate this manually, I could not make it work. Only
explicitly giving row and column solved it.
Could you please have a look at my instructions in the given document, if you
can reproduce the strange screenshots also embedded in the document?
Thanx</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>