Hi,
Users use MS Excel for report’s building and they have Russian format in Windows OS applied.
According to these settings localized format is used in Excel TEXT function (e.g. “ГГГГ” instead of English “YYYY”). English format cannot be used in reports as MS Excel works in compliance with OS format.
I have attached screenshots and sample report to review the details. We load the reports using Aspose as templates and use the following code:
@Test
public void recalcBook() {
try {
Workbook wb = new Workbook("D:\\in.xlsx");
Cell cell = wb.getWorksheets().get(0).getCells().get(0,0);
System.out.println("Before calculation");
System.out.println(wb.getWorksheets().get(0).getCells().get(1,1).getStringValue());
System.out.println(wb.getWorksheets().get(0).getCells().get(1,1).getFormula());
cell.setValue(new Date());
wb.calculateFormula(true);
System.out.println("\nAfter calculation");
System.out.println(wb.getWorksheets().get(0).getCells().get(1,1).getStringValue());
System.out.println(wb.getWorksheets().get(0).getCells().get(1,1).getFormula());
} catch (Exception e) {
System.out.println("Error");
e.printStackTrace();
}
}
The output looks as follows:
Before calculation
2011
=TEXT(A1,"ГГГГ")
After calculation
ГГГГ
=TEXT(A1,"ГГГГ")
Calculation break the result of TEXT function (correct outcome is "2014" instead of "ГГГГ"). There is no resource in Aspose to define localized formats.
Could you scrutinize this issue and provide the solution of this problem?
Thanks.
that typed by users as MS Excel saves not localized data in Spread sheet Open XML file. It looks as follows in the provided report: