Bug 42947

Summary:	Matrix functions broken
Product:	LibreOffice	Reporter:	Oliver Brinzing <oliver.brinzing>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	CLOSED NOTABUG
Severity:	major	CC:	gerard.fargeot, rb.henschel
Priority:	high
Version:	3.5.0 RC1
Hardware:	All
OS:	All
See Also:	https://issues.apache.org/ooo/show_bug.cgi?id=117806
Whiteboard:
Crash report or crash signature:		Regression By:

Description Oliver Brinzing 2011-11-15 05:14:36 UTC

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

Comment 1 Florian Reisinger 2012-01-22 00:13:11 UTC

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

Comment 2 GerardF 2012-01-22 01:46:27 UTC

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.

Comment 3 Regina Henschel 2017-05-25 20:03:51 UTC

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.