To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81155
User fst changed the following: What |Old value |New value ================================================================================ Status|UNCONFIRMED |RESOLVED -------------------------------------------------------------------------------- Resolution| |INVALID -------------------------------------------------------------------------------- ------- Additional comments from [EMAIL PROTECTED] Fri Aug 31 10:36:40 +0000 2007 ------- Hi, this is not a bug. You're looking up the whole cell content which in case of K23 contains a space but the searched column has the value without the space making it correctly a none match. For your second problem it's just the missing parameter for the sort order. If this parameter is true or not given, the search column has to be sorted in ascending order which clearly is not the case in your example. So this is not a bug and closed invalid. 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]