Formula with CountIf not evaluated correctly

Aspose.Cells Product Family
1

Hi,

I have a worksheet with a number of CountIf formulas. When I call the CalculateFormula method on the Workbook, it appears that the cells with the CountIf formulas are not calculated.

I have attached a Workbook with the CountIf formulas. They are in Column B.

Below is sample test code that fails.

var workbook = new Workbook(“BaseReport.xls”);
workbook.CalculateFormula(false);
Assert.AreEqual(“abc”, workbook.Worksheets[0].Cells[25, 1].StringValue); //this Assertion fails

Is this a bug?

Harry

2

Hi Harry,

I think, CountIf is not supported, but still, I will let you know after investigation.

Please see this Supported Formulas/Functions

3

Hi,

The CountIf formula should be supported as the list shared by Shakeel Faiz does not contain this formula. For your information the formulas that are not listed in the list are considered as Supported.

I have found the issue regarding CountIf formula as you have mentioned. I have logged an issue with an id: CELLSNET-24034. We will figure your issue out soon.

Thank you.

4

Hi,

We have fixed this issue. Please download Aspose.Cells for .NET 5.2.2.3.

5

The fixed worked.

Thanks

Harry

6

The issues you have found earlier (filed as 24034) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.