I have the following code, listed below, it seems like for some formulas, the result that appears in the cell when I open the XLS is #NAME?.. if I go to the cell, click fx then click the tick, it fixes this, but it’s a bit laborious to do this for each cell. Can you tell me what’s causing it?

Can’t aspose just accept it’s a formula and set it as a formula?

Is there any workaround?

I’m using Java Cells version 17.10

Here’s my code, I’ve attached the resultant file below.

public static void main(String[] args) throws Exception{

Workbook excel = new Workbook();

Cells cells = excel.getWorksheets().get(0).getCells();

Cell cell = cells.get(0, 0);

cell.putValue(“Hello”);

cell = cells.get(“B1”);

cell.putValue(12);

cell = cells.get(0, 2);

cell.putValue(-1.234);

cell = cells.get(“D1”);

cell.setFormula("=B1 + C1");

Cell c1 = cells.get(“b2”);

c1.setFormula("=EXPON.DIST(4,5,TRUE)");

excel.calculateFormula(true);

Object v1=c1.getValue();

Cell c2 = cells.get(“b3”);

c2.setFormula("=SUM(AVERAGE(b1,c1), b1)");

excel.calculateFormula(true);

Object v2=c2.getValue();

```
try {
excel.save("numberone.xls", SaveFormat.XLSX);
```

}

catch(Exception ex){

String g=“error”;

}

}