Free Support Forum - aspose.com

CEILING.PRECISE Formula not calculating

We’ve been having trouble with celing.precise. Does anyone know if more recent versions of aspose.cells can manage sucha a formula?

Hi,


Thanks for your query.

Yes, it looks like the Ceiling.Precise (MS Excel 2010) formula is not supported by Aspose.Cells formula calculation engine at the moment. I have tested your scenario/ case using a simple template file (attached) and sample code below:
e.g
Sample code:

Workbook workbook = new Workbook(“Bk_ceiling1.xlsx”);
System.out.println(workbook.getWorksheets().get(0).getCells().get(“B1”).getStringValue());
workbook.calculateFormula();
System.out.println(workbook.getWorksheets().get(0).getCells().get(“B1”).getStringValue()); //#NAME?

I have logged a ticket with an id “CELLSJAVA-41382” for your issue. We will look into it and enhance the formula calculation engine soon.

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

Thank you.