Bug 42947 - Matrix functions broken
Summary: Matrix functions broken
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.5.0 RC1
Hardware: All All
: high major
Assignee: Not Assigned
Depends on:
Reported: 2011-11-15 05:14 UTC by Oliver Brinzing
Modified: 2017-05-25 20:03 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
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


this bug (with same root cause?) seems to be fixed in lo3.4.4:

data validity: criteria cellrange formating is broken
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

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.