https://bugs.freedesktop.org/show_bug.cgi?id=71175
Priority: medium
Bug ID: 71175
Assignee: [email protected]
Summary: Other: "Enhancement Bug", Design Suggestion, A More
Intuitive Syntax for Array Outputs
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: unspecified
Component: Spreadsheet
Product: LibreOffice
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.
or
=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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
