FORMULATEXT is not supported

Workbook workbook = new Workbook("C:/f.xlsx");
Cells cells = workbook.getWorksheets().get(0).getCells();
cells.get("A1").setFormula("5*6+3");
workbook.calculateFormula();
System.out.println(cells.get("A2").getValue());
workbook.save("C:/f.html");


FORMULATEXT is new function in Excel 2013.

Hi Xiong,


Thank you for contacting Aspose support.

We have evaluated the presented scenario while using the latest revision of Aspose.Cells for Java 8.7.0.2 and we have received #NAME! error after evaluation of FORMULATEXT. In order to further investigate the matter, we have logged this incident as CELLSJAVA-41747. Please spare us little time to analyze this case and get back to you with updates in this regard.

Hi again,


This is to update you that we have resolved the problem logged earlier as CELLSJAVA-41747. We will shortly provide the fix here after ensuring the quality and incorporating other enhancements.

The issues you have found earlier (filed as CELLSJAVA-41747) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.