[Libreoffice-bugs] [Bug 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=71325

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #12 from Eike Rathke <erack at redhat.com> ---
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.

-- 
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/20170712/e72784da/attachment.html>