vlookup function

[Guest]

Using an earlier version of xlsreadwrite (1.15.x) I was able to pass the word FALSE as the last parameter to the vlookup function.

ie: vlookup(B7, sheetx!$A$6:$E$18, 5, FALSE)

In version 3.00.07 the above statement returns a runtime error of "Unknown name FALSE". I was able to get around the problem by passing 0 instead of FALSE. To be consistant with Excel will you be putting the ability to pass TRUE/FALSE back in?

Mark
(Using XLSReadWriteII 3.0 with Delphi 7.)

[larsa]

Hello

Yes, it will be fixed in the next update.
In the mean time, you can set these variables to TRUE and FALSE. This must be done before the XLSReadWriteII object is created.

G_StrTRUE := 'TRUE';
G_StrFALSE := 'FALSE';

Lars Arvidsson