We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Formula error in 8.6.3.0

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.

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.

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.

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.