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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #7 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
Created attachment 155861
  --> https://bugs.documentfoundation.org/attachment.cgi?id=155861&action=edit
INDEX_test1_with_semicolon.xlsx

(In reply to knittel from comment #6)
> Created attachment 155829 [details]
> inconsistency in function wizard marked
> 
> marked important stuff with red circles ;)

i checked with excel 2016:
F9:H9   =INDEX(range2;1) -> {1,1,1}
B9:D9   =INDEX(range1;1) -> REF!
D17:D19 =INDEX(range1;1) -> REF!

but i think i found the root case:

excel needs a trailing semicolon:
F9:H9   =INDEX(range2;1;) -> {1,2,3}
B9:D9   =INDEX(range1;1;) -> {1,2,3}
D17:D19 =INDEX(range1;1;) -> {1,1,1}

and adding a ";" in LO makes F9:H9 work too:
F9:H9 =INDEX(range2;1;)  -> {1,2,3}

@eike: you might be interested in this

-- 
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/20191115/4ad4820e/attachment.html>