vlookup and booleans

[Greg]

I can fill a CalcSheet object and calculate the first example of Excel''s VLookup, but have only received exceptions when trying to provide the boolean required for the remaining examples.

I am using a 1 for true and a zero for false, which works in Excel. I do not get the exception when filling the CalcSheet, but I do receive it when executing cs.Engine.ComputeVLookUp()

I am using Calculate version 3.0.1.0 (haven''t connected my downloaded 3.3.0.0 up yet).

As a second issue, from the Exception I receive during such computes, I cannot see any useful information as to what the equivalent Excel error code might be. That would be useful information to have.

Thanks,
Greg

[Administrator]

Here is a little sample loads an excel spreadsheet with the vlookup sample from the excel help file.

http://www.syncfusion.com/Support/user/uploads/CalculateTest2_b4a4b7f4.zip

Run the sample and load book1.xls. Then you can change the Output cell to Sheet1!a12 and click the GetOutPut to retrieve the value of a12. You can repeat with Sheet1!a13 and Sheet1!a14 and so on to see additional values. It shows the same values as excel except for sheet1!a15. Excel returns NA and the Calculate returns the first value in the list. We will treak the calculate code so it returns the same as excel. (The GridFormulaEngine does do get the same values as excel for all 4 cells. You can see this in the Syncfusion\Essential Studio\3.3.0.0\Windows\Grid.Windows\Samples\In Depth\FormulaValueTest sample).

If you can upload a sample with the problem you are seeing, we can try to look at it here.