Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Design Suggestion: A better way for multiple output functions?

I'm a big fan of spreadsheets, but I've never like how spreadsheets including LibreOffice Calc handle functions with multiple cell outputs.

Here's what I imagine.

=transpose(A2:A5, B2:E2)

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.

or

=sort(A2:A5, B2:B5)

Where Where A2:A5 are the input cells and B2:B5 are the sorted output cells.

or maybe

=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.

Design Suggestion: A better way for multiple output functions?

I'm a big fan of spreadsheets, but I've never like how spreadsheets including LibreOffice Calc handle functions with multiple cell outputs.

Here's what I imagine.

=transpose(A2:A5, B2:E2)

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.

or

=sort(A2:A5, B2:B5)

Where Where A2:A5 are the input cells and B2:B5 are the sorted output cells.

or maybe

=linear.regression(A2:B10, C1, C2, C3) C3)

C1=slope, C2=intercept, C3=r²

I think this sort of design would be far more intuitive than the current standard.

click to hide/show revision 3
No.3 Revision

Design Suggestion: A better way for multiple output array functions?

I'm a big fan of spreadsheets, but I've never like how spreadsheets including LibreOffice Calc handle functions with multiple cell outputs.

Here's what I imagine.

=transpose(A2:A5, B2:E2)

B2:E2)

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.

or

=sort(A2:A5, B2:B5)

B2:B5)

Where Where A2:A5 are the input cells and B2:B5 are the sorted output cells.

or maybe

=linear.regression(A2:B10, C1, C2, C3)

C3)

C1=slope, C2=intercept, C3=r²

I think this sort of design would be far more intuitive than the current standard.