To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=89550
------- Additional comments from [EMAIL PROTECTED] Fri May 16 14:53:09 +0000 2008 ------- Issue 66930 is about the returned value of INDEX when correctly entered in Calc. This issue is about how the formula is imported from .xls files, and is specific to the INDEX function because Calc doesn't allow optional parameters to be omitted in the middle of a parameter list. Given that it is not possible to change the global behaviour of optional parameters in Calc, the import function should be modified to insert sensible values (1 in this case), in place of the missing optional parameters from Excel. This is only required for single-row or single-column references: when Excel has a multi-row or multi-column reference, it needs both row and column parameters, just as Calc does. --------------------------------------------------------------------- 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]