We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Issue with "COUNTIF" Formula

Thread ID:

Created:

Updated:

Platform:

Replies:

79914 Mar 4,2009 03:15 AM Mar 5,2009 11:03 PM Windows Forms 2
loading
Tags: XlsIO
Harald Fielker
Asked On March 4, 2009 03:15 AM

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
Replied On March 4, 2009 03:23 AM

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 [Syncfusion]
Replied On March 5, 2009 11:03 PM

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


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;