To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=116359
Issue #|116359
Summary|Spreadsheet VLOOKUP funktion do not find number values
| as as search criterion
Component|Spreadsheet
Version|OOO320m18
Platform|Macintosh
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|editing
Assigned to|spreadsheet
Reported by|villejohansson
------- Additional comments from villejohans...@openoffice.org Sat Jan 8
10:44:41 +0000 2011 -------
When I put search criterion a number to VLOOKUP funktion, it will totally mess
up.
If there is not a number value it shows #N/A. With non number criterion it
works normally. And if there is
number it gives pretty random value from array.
Funktion is =VLOOKUP("1";A1:B2;2) A1=1, A2=2, B1=A and B2=B.
This should give A but it gives #N/A.
I can send template if it is needed.
Ville Johansson
---------------------------------------------------------------------
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: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
