Hi,
when I check formula of some cells in first sheet using aspose, it doesn’t show same value as in excel file. I attached excel file and screenshot from excel file which shows how formula looks like in excel. Can you help me with this? I tested it with aspose.cells for java 18.8 (latest version)
Workbook workbook = new Workbook("array-formula-type-change-de-DE.xls");
Worksheet worksheet = workbook.getWorksheets().get(0);
Cells cells = worksheet.getCells();
Cell cell = cells.get("F6");
assertEquals("='T_Db Verj.'!B4:F4", cell.getFormula());
cell = cells.get("F7");
assertEquals("='T_Db Verj.'!B5:F5", cell.getFormula());
cell = cells.get("F8");
assertEquals("='T_Db Verj.'!B6:F6", cell.getFormula());
cell = cells.get("F9");
assertEquals("='T_Db Verj.'!B7:F7", cell.getFormula());
cell = cells.get("F10");
assertEquals("='T_Db Verj.'!B8:F8", cell.getFormula());
cell = cells.get("F11");
assertEquals("='T_Db Verj.'!B9:F9", cell.getFormula());
cell = cells.get("F12");
assertEquals("='T_Db Verj.'!B10:F10", cell.getFormula());
array-formula-type-change-de-DE.xls.zip (23.9 KB)
Regards,
Zeljko