[Libreoffice-bugs] [Bug 128800] New: INDEX function behaviour inconsistent with function wizard and 'tooltip'

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 128800
           Summary: INDEX function behaviour inconsistent with function
                    wizard and 'tooltip'
           Product: LibreOffice
           Version: 6.2.8.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: knittel at mailbox.org

Created attachment 155815
  --> https://bugs.documentfoundation.org/attachment.cgi?id=155815&action=edit
inconsistentcy in function wizard

Single row/column range with the INDEX function behave inconsistent.

When selecting a single row/column range the documentation states:
"If reference is a one-dimensional column vector, column
is optional or can be omitted. If reference is a one-
dimensional row vector, row is optional, which effectively
makes row act as the column offset into the vector, or can
be omitted."

But the real behaviour is that the optional column/row parameters 'have' to be
omitted. When entering the function manually or in the function wizard and
specify '1' as the row(/column) in a single row(/column) array the value gets
used as the column(/row) index instead. (see screenshot)

try: 
B1:B2 {=INDEX(A1:A2,1)}

real behaviour: the target area gets filled with the content of first cell of
the source array. B1=A1 B2=A1
expected behaviour (option1): the target area gets filled with the first row of
the source array: B1=A1 B2=A2
expected behaviour (option2): the function wizard and the tooltip detect that
the source range/array is a single column/row and reflect that in the interface
somehow. (this may be hard if the source range has to be calculated)

-- 
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/20191114/172567b6/attachment.html>