To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=87268
------- Additional comments from [EMAIL PROTECTED] Thu Mar 20 17:15:56 +0000
2008 -------
With a column headed Result containing {9|4|16}:
{=SQRT('Result')}
will return an array {3|2|4}
The trouble is that if you then add a number onto the end of the column, Result
is a different size, but the output array size of course remains unchanged.
It's horribly messy from a user's viewpoint - are you really *really* sure you
want to attack this? ;)
You might consider simply not allowing labels in array formulae - is that what
Excel does? The whole concept of arrays seems to me to be inelegant and messy
(yes, we can blame 'the other spreadsheet'), so there has to be a realistic
limit on what the user can expect from them.
David
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
