Different COUNTIF behavior from Excel

[Derrick Gunter]

This works differently in XlsIO and Excel:

=COUNTIF(B1:B4, "1, 2")

In Excel it counts the cell if it has exactly "1, 2".

In XlsIO it counts the cell if it has either "1" or " 2".

Tested with Syncfusion.XlsIO.Net.Core version 24.1.41

Anyone know why the difference in behavior?

[Karthika Santhana Krishnan]

Hi Derrick,

 

We have attached a working sample that addresses the reported issue. Please review it and let us know if the issue resolved on your end. If issue still persists, please modify the attached sample to reproduce the issue and share it back with us for further investigation.

 

Regards,

Karthika

Attachment: CountIFFormulaBlazor_c83158be.zip