VLOOKUP formula isn't resolved by Aspose.Cells even though MS Excel does resolve it

Aspose.Cells Product Family
1

Hi,

We have an Excel file with a VLOOKUP formula ( the cell “C2” in the attached file) that is not resolved by Aspose - In MS Excel it is resolved to 1. Aspose considers that there is an error in the formula.
This is the code to reproduce this is:

var workbook = new Workbook(@“C:\xl1.xlsx”);
var cell = workbook.Worksheets[“Sheet1”].Cells[“C2”];
workbook.CalculateFormula();
var valueAfter = cell.Value;

Regards,
Lucian Nistor
IBM Romania.

2

Hi Lucian,

Thanks for your posting and using Aspose.Cells.

We were able to replicate this issue using the latest version: Aspose.Cells
for .NET v7.7.0.4. We have logged this issue in our database. We will look into it and resolve this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-42284.

3

Hi Lucian,

Thanks for using Aspose.Cells.

We have fixed this issue.

Please download and try this fix: Aspose.Cells for .NET v7.7.1.1 and let us know your feedback.

BTW, the parameter range_lookup of the function VLOOKUP should be a boolean
value not a range.

4

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

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.