The HELP Array-functions mentions semicolons and pipes as separators; default is different; no info on options Tools > Options > Calc > Formula has the following separators arrow column: . array row: ; The HELP examples use arrow column: ; array row: | Apparently the options have been added later on. (mentioned in https://bugs.documentfoundation.org/show_bug.cgi?id=32570#c0 by the way)
Duplicate to bug 108090?
*** This bug has been marked as a duplicate of bug 108090 ***