Bug 71175 - Other: "Enhancement Bug", Design Suggestion, A More Intuitive Syntax for Array Outputs
Summary: Other: "Enhancement Bug", Design Suggestion, A More Intuitive Syntax for Arra...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: Other Windows (All)
: medium enhancement
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Blocks: Calc-UX Calc-Function
  Show dependency treegraph
Reported: 2013-11-02 23:38 UTC by David Elm
Modified: 2019-02-16 20:14 UTC (History)
0 users

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 David Elm 2013-11-02 23:38:51 UTC
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.

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


=sort(A2:A5, B2:B5)

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.

BTW: Thanks for all the work you guys do.  It is appreciated.
Operating System: Windows 8
Version: unspecified
Comment 1 Owen Genat (retired) 2013-11-03 01:18:00 UTC
Severity set to enhancement. Status set to NEW. The related AskLO thread is:


... where I (oweng) propose an alternate notation and method of handling.