Free Support Forum - aspose.com

Aspose.cells can not calcalute correct result when excel use formula Iferror

hi,Team:
I am using Aspose Framework (Aspose.Cells for .NET 17.7.0.0)
When excel use formula iferror,I call the Aspose.Cell method CalculateFormula , the excel can calculate correct result with iferror,but aspose can’t correct

formula in excel below:
=IFERROR($F10SUMPRODUCT(($J$6:$CJ$6=AH$6)($J$7:$CJ$7=AH$7)*($E$2:$E$4=$H10),$J$2:$CJ$4)AH97/SUMPRODUCT(($E$2:$E$4=$H10)($J97:$CJ97=1),$J$2:$CJ$4),0)

Please provide solution to this problem

@frank.shen,
Please share your template file and runnable code snippet with us for our testing. We will reproduce the problem and provide our feedback after analysis.