see https://issues.apache.org/ooo/show_bug.cgi?id=117806: > In Calc select cells A1:C1, insert =sin({1;2;3}) > and press shift-ctrl-enter to make a matrixformular > => all cells shows the same content btw: this bug (with same root cause?) seems to be fixed in lo3.4.4: data validity: criteria cellrange formating is broken https://issues.apache.org/ooo/show_bug.cgi?id=118125
Ok, how should it look like: 1) sin(1) in A1, sin(2) in B1, sin(3) in C1 If so , I can condirm, it does not look like that 2) 0,841470985 in A1 Well, that is what I see and that is no matrix --Confirm-- Win 7 LibO 3,5Rc1
Hi, In LibreOffice, constant array separators are : row separator ; column separator . (or , with locale using . as decimal separator) so SIN({1;2;3}) produce an column array. (A1:A3) if you want an row array, use SIN({1.2.3}) for cells A1:C1 Closed not a bug.
I have written bug 1088090 for the request to improve the help to give more information about the separators in inline array. I close this one.