calculateFormula() does not work for INDEX function

Aspose.Cells Product Family
1

When running

calculateFormula();

on the attached excel sheet the reference to L25 in row 25 is producing #N/A, The expected value should be 0. We suspect that maybe it is due to array formula again? (even 7.5.3 claimed a fix on related issue)

Aspose version : Both 7.5.3 and 7.5.2.2


2

Hi,

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

We were able to replicate this issue using the following with your source file. We tested it with the latest version: Aspose.Cells for Java v7.5.3.2. The cell L25 returns #N/A. We have logged this issue in our database. We will look into it and fix 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 CELLSJAVA-40624.

Java


String filePath = “F:\Shak-Data-RW\Downloads\testSenario\DailyGasV4.xls”;


Workbook workbook = new Workbook(filePath);

workbook.calculateFormula();


Worksheet worksheet = workbook.getWorksheets().get(0);

Cell cell = worksheet.getCells().get(“L25”);


System.out.println(cell.getStringValue());

3

Hi,

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

We have fixed this issue.

Please download and try this fix: Aspose.Cells for Java (Latest Version) and let us know your feedback.

4

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

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