Issue 23028 - VLOOKUP and HLOOKUP sort order parameter misinterpreted
Summary: VLOOKUP and HLOOKUP sort order parameter misinterpreted
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1 RC5
Hardware: PC Windows 98
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-11-30 02:35 UTC by efcis
Modified: 2003-12-01 09:43 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description efcis 2003-11-30 02:35:06 UTC 
Using FALSE as sort order parameter (optional), as stated in the help file gives
a #NAME error. Using 0 instead is working...
Comment 1 frank 2003-12-01 09:43:32 UTC 
Hi,

if you want to use FALSE in the formula you have to use the function
FALSE(), otherwise you only place a string in there and the formula
interpreter needs either the value 0 or the logical function FALSE().

So this is not a bug of the spreasheet, just place the opening and
closing brackets after your FALSE and it will work.

I close it as worksforme.

Frank
Comment 2 frank 2003-12-01 09:43:54 UTC 
closed wfm