Bug 494741 - LOOKUP function does not work as expected on unsorted search vector
Summary: LOOKUP function does not work as expected on unsorted search vector
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: Red Hat Enterprise Linux 5
Classification: Red Hat
Component: openoffice.org
Version: 5.2
Hardware: i386
OS: Linux
low
medium
Target Milestone: rc
: ---
Assignee: Caolan McNamara
QA Contact: desktop-bugs@redhat.com
URL:
Whiteboard:
: 583490 (view as bug list)
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2009-04-07 23:07 UTC by Dmitri Pal
Modified: 2010-04-19 07:54 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2009-04-08 15:36:17 UTC
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)
demo using hlookup (8.98 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-04-08 15:33 UTC, Caolan McNamara 		no flags Details
View All

Comment 4 Caolan McNamara 2009-04-08 15:33:17 UTC 
Created attachment 338732 [details]
demo using hlookup
Comment 5 Caolan McNamara 2009-04-08 15:36:17 UTC 
"The search vector for the LOOKUP must be sorted ascending, otherwise the search will not return any usable results."

Which is also the case for Excel (which presumably is where this misery originated), and 
Low
Medium
High
Giant
is not in alphabetical order.

This can be pulled off with HLOOKUP and the flag for "don't sort" as in the attached example, but LOOKUP requires a sorted search vector.
Comment 7 Caolan McNamara 2010-04-19 07:54:56 UTC 
*** Bug 583490 has been marked as a duplicate of this bug. ***
Note You need to log in before you can comment on or make changes to this bug.