Free Support Forum -

Nested IF in SUMIF- calculation not done


Please find attached a sample workbook that is not correctly calculated with the workbook.calculateFormula(true) method.

Please check column G. Calculation within MS Excel gives values, but not with Aspose.Cells.

I am using the latest version 2.5.4 with latest dependencies.

Please have a look and let me know.



After an initial test using your template file, I got the issue. I found that calculation is not done fine, it always gives “0.0” for all the formulas in the G column’s cells.

I have logged an issue with an id: CELLSJAVA-30077. We will look into your issue and get back to you soon.

Thank you.


We have fixed this issue of calculating formulas. Please download: Aspose.Cells for Java v2.5.4.21

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

This message was posted using Notification2Forum from Downloads module by aspose.notifier.