workbook.CalculateFormula() return zero where the source value is 469,972,890

Aspose.Cells Product Family
1

Hi,

Workbook.CalculateFormula() doesn’t work and it’s returning always zero when retriving the data from a formular field. The strange is that it retrieves zero when the source value used in the excel formula is 469,972,890. If we change the source value to 469,972,891 the field is retrieved correctly after calling calculateFormula().

The excel formula of the field is =IF(ISERR((1+IRR(D101:BL101,0))^12-1),0,(1+IRR(D101:BL101,0))^12-1)

The Aspose.Cells.dll version used in the code is 19.7.0.0 but I tried also with the latest version (20.1.0.0) and it ocurs the same issue.

I will appreciate your help on this.

Thanks,
Ma. Emilia

2

@mvilas,

Thanks for the details.

Please try using our latest version/fix: Aspose.Cells for .NET v20.2.

If you still find the issue with v20.2.x, kindly do zip the file and provide us, we will check it soon.