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.

GridFormulaCellModel engine parser fails on IF statement.

Thread ID:

Created:

Updated:

Platform:

Replies:

47871 Aug 15,2006 01:24 PM Aug 16,2006 12:45 PM Windows Forms 4
loading
Tags: GridControl
Kwabena Manu
Asked On August 15, 2006 01:24 PM

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

Thanks


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

An expression like:

=IF(A1="P","Put","Call")

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 07:11 PM

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 12:31 PM



>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 12:45 PM

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.

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.

;