<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - INDEX function behaviour inconsistent with function wizard and 'tooltip'" href="https://bugs.documentfoundation.org/show_bug.cgi?id=128800#c7">Comment # 7</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - INDEX function behaviour inconsistent with function wizard and 'tooltip'" href="https://bugs.documentfoundation.org/show_bug.cgi?id=128800">bug 128800</a> from <a class="email" href="mailto:oliver.brinzing@gmx.de" title="Oliver Brinzing <oliver.brinzing@gmx.de>"> Oliver Brinzing</a> <pre>Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=155861" name="attach_155861" title="INDEX_test1_with_semicolon.xlsx">attachment 155861</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=155861&action=edit" title="INDEX_test1_with_semicolon.xlsx">[details]</a> INDEX_test1_with_semicolon.xlsx (In reply to knittel from <a href="show_bug.cgi?id=128800#c6">comment #6</a>) > Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=155829" name="attach_155829" title="inconsistency in function wizard marked">attachment 155829</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=155829&action=edit" title="inconsistency in function wizard marked">[details]</a> > 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</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>