Issue 23028

Summary:	VLOOKUP and HLOOKUP sort order parameter misinterpreted
Product:	Calc	Reporter:	efcis <laurenthaas>
Component:	ui	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED IRREPRODUCIBLE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 1.1 RC5
Target Milestone:	---
Hardware:	PC
OS:	Windows 98
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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