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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Issue with "COUNTIF" Formula

Thread ID:

Created:

Updated:

Platform:

Replies:

79914 Mar 4,2009 08:15 AM UTC Mar 6,2009 04:03 AM UTC WinForms 2
loading
Tags: XlsIO
Harald Fielker
Asked On March 4, 2009 08:15 AM UTC

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 08:23 AM UTC

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 6, 2009 04:03 AM UTC

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.

Warning Icon 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.Close Icon

;