Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I agree, at least in part. I would use the term "array" in deference to "multiple output". The entire manner in which arrays are handled in Calc is inelegant, including the CTRL+SHIFT+ENTER entry method, the non-editable / hidden bracket / control characters nature, and non-conformant notation. I would have thought:

=TRANSPOSE({A1:B2})
=TRANSPOSE({name_of_range})

... to be more sensible and conforming with existing array notation in other languages than the current:

{=TRANSPOSE(A1:B2)}
{=TRANSPOSE(name_of_range)}

... which has to be entered in a non-standard manner. The proposed examples should be able to be entered in the usual manner i.e., using ENTER.

I'm not sure what the cell itself should show, maybe something to indicate whether the procedure completed successfully.

I think is the single biggest drawback to the method / notation indicated in the question. All current functions are entered in the cell they output to. I think so long as the main entry cell (i.e., top left) is somehow marked and the formula remains editable, that it is better to keep the required parameters as simple as possible.

Please file an enhancement bug and provide as much information about this new feature as possible. Don't forget to mark your bug as an 'enhancement'. The QA team will be happy to help you triage your feature request in the bugtracker.

Please post a link to any bugs you file in a comment below using the format "fdo#123456".

Thanks!

I agree, at least in part. I would use the term "array" in deference to "multiple output". It is also worth noting that this type of change would likely be dependent upon a change to the ODF specification, so it may not happen quickly.

The entire manner in which arrays are handled in Calc is inelegant, including the CTRL+SHIFT+ENTER entry method, the non-editable / hidden bracket / control characters nature, and non-conformant notation. I would have thought:

=TRANSPOSE({A1:B2})
=TRANSPOSE({name_of_range})

... to be more sensible and conforming with existing array notation in other languages than the current:

{=TRANSPOSE(A1:B2)}
{=TRANSPOSE(name_of_range)}

... which has to be entered in a non-standard manner. The proposed examples should be able to be entered in the usual manner i.e., using ENTER.

I'm not sure what the cell itself should show, maybe something to indicate whether the procedure completed successfully.

I think is the single biggest drawback to the method / notation indicated in the question. All current functions are entered in the cell they output to. I think so long as the main entry cell (i.e., top left) is somehow marked and the formula remains editable, that it is better to keep the required parameters as simple as possible.

Please file an enhancement bug and provide as much information about this new feature as possible. Don't forget to mark your bug as an 'enhancement'. The QA team will be happy to help you triage your feature request in the bugtracker.

Please post a link to any bugs you file in a comment below using the format "fdo#123456".

Thanks!