I'm a big fan of spreadsheets, but I've never liked how spreadsheets including LibreOffice Calc handle functions with multiple cell outputs.
Here's what I imagine.
Where A2:A5 are the input cells and B2:E2 are the transposed output cells. I'm not sure what the cell itself should show, maybe something to indicate whether the procedure completed successfully.
Where A2:A5 are the input cells and B2:B5 are the sorted output cells.
=linear.regression(A2:B10, C1, C2, C3)
C1=slope, C2=intercept, C3=r²
I think this sort of design would be far more intuitive than the current standard.
BTW: Thanks for all the work you guys do. It is appreciated.
Operating System: Windows 8
Severity set to enhancement. Status set to NEW. The related AskLO thread is:
... where I (oweng) propose an alternate notation and method of handling.