Bug With Vlookup and wildcard

Aspose.Cells Product Family
1
Hello, when i use the following formula with the wild card in a vlookup and open my workbook through aspose and calculate it returns an N/A. Attached is the screen capture of the workbook while open in c# and the test.xlsx that was used.

Formula in question:
=VLOOKUP("VIC"&"*",INDIRECT(B2),2,FALSE)

Aspose Returns N/A
Excel Returns 3

It works fine in Excel. The issue is with the * character in the search string. This is legal in Excel, but Aspose would not run this formula.

We have hard-coded a formula to get around the problem for now, but it creates a potential maintenance issue since we'll have to remember to change the formula.

Thanks,
Mark
2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

I was able to replicate this bug using the latest version:
Aspose.Cells for .NET v7.2.0.7 with the following code.

We have logged this issue in our database. Development team will look into this issue and once the issue is fixed or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-40674.

C#


string filePath = @“F:\Shak-Data-RW\Downloads\test.xlsx”;


Workbook wb = new Workbook(filePath);


Worksheet worksheet = wb.Worksheets[0];


wb.CalculateFormula();


var strValue = worksheet.Cells[“A1”].StringValue;


Debug.WriteLine(strValue);


Output:
#N/A
3

Hi,

We have fixed this issue.

Please download and try the latest fix: Aspose.Cells for .NET v7.2.0.8

4

Thanks that worked perfectly!

5

The issues you have found earlier (filed as CELLSNET-40674) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.