Free Support Forum - aspose.com

Formula not same as in excel file

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

@Zeljko,

Thanks for the template file, sample code and screenshot.

After an initial test, I am able to observe the issue as you mentioned by using your sample code with your template file. I found that formulas are not retrieved the same as in MS Excel file. I have logged a ticket with an id “CELLSJAVA-42715” for your issue. We will look into it soon.

Once we have an update on it, we will let you know here.

@Zeljko,

This is to inform you that we have fixed your issue (logged earlier as “CELLSJAVA-42715”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

The issues you have found earlier (filed as CELLSJAVA-42715) have been fixed in Aspose.Cells for Java 18.9. You can also get the latest Aspose.Cells for Java version from Maven repos. with simple configurations. Please see the document for your reference: https://docs.aspose.com/display/cellsjava/Installation

This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi