Issue with "COUNTIF" Formula

[Harald Fielker]

I detected an issue with the "COUNTIF" expresion in XlsIO.

I am trying to count the occurence of the character "x" in column A1:A20.

In MS-Excel 2007 this can be done with:
=COUNTIF(A1:A20;"x")

However when setting the formula to XlsIO, i get a parse error:

sheet.Range["B5"].Formula="COUNTIF(A1:A20;\"x\")";

[Harald Fielker]

Thinking about this problem i came to this conclusion:

There might be a bug in the expression parser of syncfusion. The string "x" should be looked up in the given range, evaluated. Then the result should be checked.

I don't think this will be an easy fix.

[Geetha M]

Hi Harald,

Thank you for the details.

I was able to see the problem if I set a different regional format other than English(en-US). From the code snippet, I understand that you are using a different culture. In order to make use of the formula, please set the separators for the workbook as shown below:

workbook.SetSeparators(';', ';');

Please try this and let me know if you have any questions.

Regards,
Geetha