Multivariable LINEST with X in not adjusted columns

[chameleon]

I am trying to do what title says.

I use the command

=INDEX(LINEST(B3:B10;MMULT(C3:E10;{1;0|0;0|0;1});1;1);1;1)

and I get Err:502

Lets decrypt the command:

LINEST:

y: B3:B10

x: C3:C10 and E3:E10

MMULT:

Matrix 1: C3:E10

Matrix 2: {1;0|0;0|0;1}

So result is the required from LINEST C3:C10 and E3:E10

System: Windows 7 x64

System specific list separator: “;”

System specific decimal separator: “,”

System specific thousand group: “.”

What is wrong?

If I replace

MMULT(C3:E10;{1;0|0;0|0;1})

with

MMULT(C3:E10;M10:N12)

it works.

But I don’t want to do this

Can you please help me?

By the way, example of Libreoffice MMULT gives me error:

MMULT({1;2;3};{4;5|6;7|8;9})

[chameleon]

Solved

On libreoffice Options->Calc->Formula->Separators says that array column separator is “.” and not “;” and row separator is “;” and not “|”.