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
Severity set to enhancement. Status set to NEW. The related AskLO thread is: http://ask.libreoffice.org/en/question/24712/design-suggestion-a-better-way-for-array-functions/ ... where I (oweng) propose an alternate notation and method of handling.