Issue with COUNTA and INDIRECT

Aspose.Cells Product Family
1

Hello,


When I run the following program:

public static void main(String[] someArgs) throws Exception
{
Workbook myWorkbook = new Workbook(“test/Test04.xls”);
myWorkbook.getSettings().setCalcMode(CalcModeType.MANUAL);

System.out.println(myWorkbook.getWorksheets().get(0).getCells().get(0, 0).getStringValue());

myWorkbook.calculateFormula();

System.out.println(myWorkbook.getWorksheets().get(0).getCells().get(0, 0).getStringValue());

}

with the attached spreadsheet (also see png), which contains a formula consisting of COUNTA and INDIRECT, I get the following result:

5
1

I would expect the result ‘5’ both times.
2

Hi,


Thanks for the sample file.

After an initial test, I can notice the issue as you have mentioned as per your output console by running your code with your template file.

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

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

Thank you.
3

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

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