Free Support Forum - aspose.com

Issue with COUNTA and INDIRECT

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.

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.

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.