To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=32345
User er changed the following:
What |Old value |New value
================================================================================
Status|CLOSED |REOPENED
--------------------------------------------------------------------------------
Issue type|FEATURE |DEFECT
--------------------------------------------------------------------------------
Resolution|FIXED |
--------------------------------------------------------------------------------
Summary|Allow a range as second pa|ODFF: Make LARGE() and SMA
|rameter of LARGE() and SMA|LL() return an array if th
|LL() |e second parameter is an a
| |rray.
--------------------------------------------------------------------------------
Subcomponent|ui |programming
--------------------------------------------------------------------------------
Target milestone|OOo 2.0 |OOo 3.x
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Wed May 28 14:43:12 +0000
2008 -------
Thanks for letting us know. Problem is that LARGE() and SMALL() do not return an
array in this case, but only a single value instead, as can also be seen with
=SUM(LARGE(A1:A10;{1;2;3})).
Note that in Excel =SUM(LARGE(A1:A10,B1:B3)) with B1:B3 containing {1,2,3} is
not the same and does not evaluate as an array, but generates an error instead.
In array evaluation also a 2D array is handled as second parameter, as can be
seen with =COLUMNS(LARGE(A1:A10,{1,2;3,4})) and =ROWS(LARGE(A1:A10,{1,2;3,4}))
Reopening this issue and adapting summary to reflect detail.
---------------------------------------------------------------------
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]
