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

GridFormulaCellModel engine parser fails on IF statement.

Thread ID:





47871 Aug 15,2006 05:24 PM UTC Aug 16,2006 04:45 PM UTC WinForms 4
Tags: GridControl
Kwabena Manu
Asked On August 15, 2006 05:24 PM UTC

The statement
IF(''P'' = ''P'', ''Put'', ''Call'')
fails in the Engine parser.
Can you please advise.


Administrator [Syncfusion]
Replied On August 15, 2006 07:28 PM UTC

An expression like:


works ok, but if the two operands on the equal sign are both constant strings, then it fails. We will look into why this is happening. If you make one of the constant operands a function call, then things also work as expected.

=IF(LEFT("P", 1)="P","Put","Call")

Administrator [Syncfusion]
Replied On August 15, 2006 11:11 PM UTC

This problem has been corrected in our code base, and the fix should be in the next release.

Kwabena Manu
Replied On August 16, 2006 04:31 PM UTC

>This problem has been corrected in our code base, and the fix should be in the next release.

Thanks for quick response.
Please let me know when the next release is out.

I have notice also the IF statement supports only double quotes (") but not single quotes ('') any reason why?

Administrator [Syncfusion]
Replied On August 16, 2006 04:45 PM UTC

We only have a single string delimiter and it is not publicly exposed.

private string TIC = "\""; //used to mark strings

If you wanted to try to change it, you could use reflection to change this private field, but we have not tested using anything other than double quotes as the string marker.


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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

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