Calc: LINEST formula stopped working - {1,2,3} gets replaced with #NAME?

[THX11384EB]

I am having a problem with an array formula in Calc. It seemed to work once, then I accidentally messed it up and when I tried to repeat what I did earlier, it no longer worked the same.

All I want is the first row of output from the array formula =LINEST(C1:F1,C3:F3^{1;2;3},1). I put the formula into a cell and then select the cell along with the following four cells where I want the data. Then I press CTRL + F2 to open the Formula Wizard. I check/tick the “Array” box and hit RETURN or click on OK. Then {1;2;3} in my formula turns into #NAME? and I get #NUM! and #N/A instead of the expected numerical values.

The expected values are a, b, c and d for the formula y = ax^3 + bx^2 + cx + d which is determined by linear regression and translates the values in C3:F3 into the values in C1:F1. Like I say, it worked the first time. Thanks for any help.

[newbie-02]

likely you have messed around with the delimiters or locale settings? tested “=LINEST(C1:F1;C3:F3^{1;2;3};;1)” with calc 7.0 and it worked (german locale, observe three “;” instead of “,” assume you are on english and need to use “{1,2,3}”)

[erAck]

Formula Wizard. I check/tick the “Array” box and hit RETURN or click on OK. Then {1;2;3} in my formula turns into #NAME?

That was a bug in the API the Function Wizard uses, tdf#132173, which will be fixed for LibreOffice 6.4.5 and 7.0

For the time being until then don’t use the Function Wizard with expressions containing inline arrays.