<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</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;">Status</td>
<td>NEW
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</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#c12">Comment # 12</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:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span></b>
<pre>It's neither nor, you also don't need to enter it as array formula, but then it
depends on the position context. If not an array formula, whether the result is
#VALUE! depends on where (which cell) the formula is entered. What
=INDEX(A1:C3,1) does is it returns the cell range A1:C1, if not in array
context the implicit intersection of the formula position with the range is
taken as usual, this is the same as in =A1:C1, so if the formula is anywhere in
columns A:C then the value of row 1 in that column is the result, in any other
column the result is #VALUE! because there is no intersection with A1:C1.
Entered as array formula the result is an array with values of A1:C1, which can
be entered on any cell position, e.g. the same as {=A1:C1}
All this is normal cell range evaluation behaviour regarding scalar/array
context and not specific to the INDEX() function.
In the attached screenshot examples only results BLUE and RED work because only
for those the formula expression can determine exactly one cell.</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>