Getting issue with Workbook calculate formula with IFERROR formula with range

Aspose.Cells Product Family
1

Getting issue with Workbook calculate formula with IFERROR formula with range, it is getting stuck in evaluating in workbook calculate formula.

Range : Sheet1!AM:AR.

=IFERROR(SUMIF(Sheet1!AM:AR,F2,Sheet1!AR:AR),0)

2

@sr2989
Would you like to provide sample file and testing code? We have created a sample file and tested it using the following code in the latest version v23.11, and we can obtain the correct results. Please check the attachment (14.5 KB).

The sample code as follows:

Workbook book = new Workbook(filePath + "sample.xlsx");
Cells cells = book.Worksheets[0].Cells;
Console.WriteLine(cells["C7"].StringValue);
book.CalculateFormula();
Console.WriteLine(cells["C7"].StringValue);
book.Save(filePath + "out_net.xlsx");