We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

List of supported excel functions in latest version

Hello,


I am using spose.cell 8.5.2 as per http://www.aspose.com/docs/display/cellsjava/Supported+Formula+Functions it did not mention WEIBULL.DIST as supported excel function. Where as 8.5.2 supports it.

Can you please provide latest list of supported excel functions for java as well as not supported excel functions list to avoid surprises at the time actual implementation.




Thanks
Najmuddin

Hi,

Thanks for your posting and using Aspose.Cells.

We have added WEIBULL.DIST in the list of supported functions. Please also see the following document. It enlists all the unsupported function and rest of other functions should be supported.

( http://www.aspose.com/docs/display/cellsnet/Supported+Formula+Functions )

Since WEIBULL.DIST is not in this list, so it is supposed to be among supported functions.

Also you can check any function if it is supported or not using the following code. If the pdf contains error instead of value, then that formula is not supported but if it contains a value, then that formula is supported. I have also attached the source excel file used in this code and the output pdf generated by it for your reference.

Java


String filePath = “F:\Shak-Data-RW\Downloads\Book1.xlsx”;


Workbook workbook = new Workbook(filePath);


workbook.calculateFormula();


workbook.save(filePath + “.out.pdf”);