We are experiencing an issue when executing the CalculateFormula method on an Excel file that contains a COUNTIFS function in a formula. We are using version 18.104.22.168 of Aspose.Cells.
I found, the latest version is working fine.
Aspose.Cells for .NET v22.214.171.124
Will you please test it with the latest version? If the problem occurs, then please provide us your sample code
Below is my test code. I have also checked it by setting A1 and A2 equal. Please see the output file.
string filePath = @“F:\Shak-Data-RW\Downloads\MM02UM.xlsx”;
Workbook workbook = new Workbook(filePath);
workbook.Save(filePath + “.out.xlsx”);
unsupported function, external links, or other issues etc. It will calculate all the formulas except any formula which might throw exceptions or unsupported functions.