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@lists.freedesktop.org
Reporter: knit...@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._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
