Free Support Forum - aspose.com

Nested IF in SUMIF- calculation not done

Hi,

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.

Regards
VR

Hi,


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.

Hi,

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.