We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

vlookup and booleans

Thread ID:

Created:

Updated:

Platform:

Replies:

34332 Sep 7,2005 04:24 PM Sep 7,2005 08:55 PM Windows Forms 1
loading
Tags: Calculate
Greg
Asked On September 7, 2005 04:24 PM

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 [Syncfusion]
Replied On September 7, 2005 08:55 PM

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.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;