The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
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
ADAdministrator Syncfusion Team 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\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.