To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=51460
User fst changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Tue Jul 12 02:43:19 -0700
2005 -------
Hi,
I've opened this Excel file with Excel 2k3 and got also wrong results !
This is because the search vector $AE$70:$AH$91 isn't sorted. To get correct
results this must be sorted or the unsorted parameter in the VLOOKUP statement
has to be set.
Please keep in mind that brackets and slashes can be interpreted by Calc as
regular expressions and therefore can give unexpected results if regular
expressions for formulas is activated under tools options spreadsheet calculate.
Frank
---------------------------------------------------------------------
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]
