To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98298
------- Additional comments from [email protected] Tue Jan 27 07:30:03 +0000 2009 ------- I read documentation again and you probably mean SortOrder/Mode (the last, optional, argument to VLOOKUP) with exact. If yes, I still don't see a bug here. Your VLOOKUP has Mode set to 1 and according to documentation, lookup column must be sorted (which is) and If mode is 0 or FALSE, the left column of datatable may be unordered, and the first exact match is found (searching from the top). And: If there is an exact match, that is the row found; if there is more than one exact match, *** the row found is not necessarily nearest the top *** So, what's wrong? I don't see the bug and still thinks that this issue is INVALID. --------------------------------------------------------------------- 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]
