To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90628 Issue #|90628 Summary|LOOKUP: forced array parameters, as in ODFF & Excel Component|Spreadsheet Version|OOo 2.4.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|drking
------- Additional comments from [EMAIL PROTECTED] Wed Jun 11 18:29:49 +0000 2008 ------- ODFF defines the Searched and Results parameters as 'Forced Array'. Calc doesn't seem to handle for example =LOOKUP(4; A1:C1*2; A3:C3) where A1:C1*2 should be evaluated as an array formula. Gives error 504: function parameter is not valid. Excel does handle this OK. [It's possible that this could be added to issue 81214 ? ] --------------------------------------------------------------------- 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]