https://bugs.documentfoundation.org/show_bug.cgi?id=128800
--- Comment #7 from Oliver Brinzing <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
