To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=40763 Issue #:|40763 Summary:|VLOOKUP behavior has changed for a sorted list. Component:|Spreadsheet Version:|680m69 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|code Assigned to:|spreadsheet Reported by:|pitonyak
------- Additional comments from [EMAIL PROTECTED] Sun Jan 16 19:48:11 -0800 2005 ------- If I search a sorted list using VLOOKUP searching with sort_order set to 0, the behavior is unchanged and the first row that matches is returned. If I search a sorted list using VLOOKUP searching with sort_order set to 1, the behavior is changed and the last (1.95.69 behavior) row that matches is returned rather than the first (1.1.4 behavior). Load the attached document using 1.1.4 and 1.95.69 and see the difference. Very simple! I do not care if this is not really a bug, I just desire to document the behavior. --------------------------------------------------------------------- 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]
