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”];
var valueAfter = cell.Value;
Thanks for your posting and using Aspose.Cells.
We were able to replicate this issue using the latest version: Aspose.Cells
for .NET v220.127.116.11. 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.
Thanks for using Aspose.Cells.
We have fixed this issue.
Please download and try this fix: Aspose.Cells for .NET v18.104.22.168 and let us know your feedback.
BTW, the parameter range_lookup of the function VLOOKUP should be a boolean
value not a range.