Hello,
I am currently evaluating Aspose.Cells for java and I’ve found a difference in its behaviour when compared to Excel. When I run the following code:
public static void main(String[] someArgs) throws Exception
{
Workbook myWorkbook = new Workbook(“test/Test02.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());
System.out.println(myWorkbook.getWorksheets().get(0).getCells().get(0, 0).getDisplayStringValue());
}
On the attached xls spreadsheet (which contains in cell Sheet1!A1 a date formatted as ‘Wednesday, 30 June 10’ - see png attachment) I get the following output:
30 June 2010
30 June 2010
30 June 2010
Basically the format of the date in the spreadsheet is different when extracted using getStringValue() or getDisplayStringValue().