To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=67436
Issue #|67436
Summary|LOOKUP Functions errors
Component|Spreadsheet
Version|OOo 2.0.3
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P1
Subcomponent|code
Assigned to|spreadsheet
Reported by|7kaltoid
------- Additional comments from [EMAIL PROTECTED] Sun Jul 16 16:22:49 -0700
2006 -------
OS: Windows 2000 Pro running in Win4Lin 6.x or native on a laptop
SuSE Linux 10.0 and 10.1 (different machines)
The behaviors described below have been observed in OOo2.0.3 for Windows and in
SuSE version OOo 2.0.2.15 and on three different computers all with similar
software configurations. I am reasonably confident that if I were to install
OOo 2.0.3 from the OOo website in SuSE Linux (10.1 currently running), nothing
would change.
First, the documentation for HLOOKUP, VLOOKUP, and LOOKUP is useless. There are
no examples and the acceptable (ranges of) values for INDEX and SORTED are
undefined. Any value other than "1" for Index in HLOOKUP returns a 502 error.
With "1" as the value of Index, the function returns the value being searched
which is of very limited usefulness. I didn't try VLOOKUP. Also, in the case of
the syntax definition for LOOKUP, the use of the term VECTOR in lieu of Range or
Array is nonsensical and inconsistent with the terminology applied to the other
lookup functions.
For the value of SORTED for HLOOKUP and VLOOKUP, using the Function Wizard, any
value that is entered (blank, 0, 1, -1, T, F, True, False) is rejected with one
of #NAME?, 502 or 511 error codes being returned. These results are unchanged
whether or not the data are sorted. As a result, HLOOKUP and VLOOKUP cannot be
made to work. No useful change was observed when the cell contents were typed
directly in the formula box.
---------------------------------------------------------------------
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]
