To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=49539
Issue #:|49539
Summary:|vlookup fails when using unsorted list and values
|with brackets
Component:|Spreadsheet
Version:|current
Platform:|PC
URL:|
OS/Version:|Windows XP
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|code
Assigned to:|spreadsheet
Reported by:|adw
------- Additional comments from [EMAIL PROTECTED] Thu May 19 12:35:07 -0700
2005 -------
The issue is incorrect behavoir of the vlookup function when using an unsorted
list (no sort order) and values which contain brackets "(", ")", "[" or "]".
To reproduce the problem open OpenOffice.org Calc and on a blank sheet -
Enter some values to make up a lookup table, for example:
A10: "A" B10: "1"
A11: "(A)" B11: "2"
A12: "[A]" B12: "3"
A13: "{A}" B13: "4"
A14: "(B)" B14: "5"
(without the quotes)
Enter the formula in another cell, for example:
B1: "=VLOOKUP(A1;A10:B14;2;0)"
(Search criteron: A1, array: A10:B14 (above), index: 2, sort order: none)
In A1, type in each of the values in the lookup table:
A1: "A" results in B1: "1" (CORRECT)
A1: "(A)" results in B1: "1" (INCORRECT) (should be "2")
A1: "[A]" results in B1: "1" (INCORRECT) (should be "3")
A1: "{A}" results in B1: "4" (CORRECT)
A1: "(B)" results in B1: "#N/A" (INCORRECT) (should be "5")
This example file is attached. There is no problem using the "{" or "}"
parenthesis just "(", ")", "[" and "]".
All the versions I have tested have this problem (including 1.9m100 and
1.9m104).
---------------------------------------------------------------------
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]
