Formula error in 8.6.3.0

Aspose.Cells Product Family
1

While doing the comparison between ASPOSE 8.6.3.0 and 8.4.1.2 version, I found the following issue with the latest version.



Formulae : ROWS(INDIRECT(VLOOKUP(K6,$K$2:$L$3,2,0)))

Result in Aspose 8.6.3.0 -> #VALUE!

Result in Aspose 8.4.1.2 -> 201



I have attached the excel sheet for this issue.

2

Hi,


Thanks for the template file and details.

After an initial test, I observed the issue as you mentioned. I found an issue with calculating formula “ROWS(INDIRECT(VLOOKUP(K6,$K$2:$L$3,2,0)))” by Aspose.Cells formula calculation engine. I used the following sample code with your template file:
e.g
Sample code:

var excelDocument = new Workbook(“e:\test2\Aspose+Tester+8.6.3.0.xls”);
var worksheet = excelDocument.Worksheets[0];
var cellValue = worksheet.Cells[“B2”];
Console.WriteLine("before CalculateFormula() " + cellValue.Value);//201
excelDocument.CalculateFormula();//#VALUE!
Console.WriteLine("after CalculateFormula() " + cellValue.Value);
Console.ReadLine();

I have logged a ticket with an id “CELLSNET-44256” for your issue. We will look into it soon.

Once we have any update on it, we will let you know here.

Thank you.
3

Hi,

Thanks for using Aspose.Cells.

Please download and try the latest fix:
Aspose.Cells for .NET v8.7.1.1 and let us know your feedback.

4

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

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