When I run the following code against the attached file:
Workbook workbook = new Workbook("Test.xls");
workbook.getSettings().setCalcMode(CalcModeType.MANUAL);
int sheet = 0;
int row = 1;
int col = 1;
System.out.println(workbook.getWorksheets().get(sheet).getCells().get(row, col).getStringValue());
workbook.calculateFormula();
System.out.println(workbook.getWorksheets().get(sheet).getCells().get(row, col).getStringValue());
workbook.save("Test-result.xlsx", FileFormatType.XLSX);
The output is as follows:
1/1/2005
#VALUE!
The spreadsheet being recalculated contains a simple array formula. The formula calculates OK in Excel, but when the spreadsheet is loaded in Aspose and recalculated, the result is #VALUE!. If the output spreadsheet is loaded in Excel the #VALUE! can been seen, but the formula is correctly calculated again when F9 is pressed.
We are seeing issues like this throughout a large number of our spreadsheets that contain array formulas.