Hello,
When I run the following code:
public static void main(String[] someArgs) throws Exception
{
Workbook myWorkbook = new Workbook(“test/Test03.xls”);
myWorkbook.getSettings().setCalcMode(CalcModeType.MANUAL);
System.out.println(myWorkbook.getWorksheets().get(0).getCells().get(0, 0).getStringValue());
System.out.println(myWorkbook.getWorksheets().get(0).getCells().get(0, 1).getStringValue());
myWorkbook.calculateFormula();
System.out.println(myWorkbook.getWorksheets().get(0).getCells().get(0, 0).getStringValue());
System.out.println(myWorkbook.getWorksheets().get(0).getCells().get(0, 1).getStringValue());
}
on the attached spreadsheet (see xls attachment) which contains in cell A1 the value ‘-0.340277777777778’ formatted as a time, and in cell B1 the value ‘65432113’ formatted as a date (see png attachment), Aspose does not output anything from cell A1, but outputs a ‘#’ for cell B1. I would have expected (from cell A1) ‘#’ to be output as this would be consistent (with B1) and is also what Excel displays.