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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

vlookup and booleans

Thread ID:





34332 Sep 7,2005 08:24 PM UTC Sep 8,2005 12:55 AM UTC WinForms 1
Tags: Calculate
Asked On September 7, 2005 08:24 PM UTC

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 (haven''t connected my downloaded 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 8, 2005 12:55 AM UTC

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\\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.


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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon 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.Close Icon