GridFormulaCellModel engine parser fails on IF statement.

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

Thanks


4 Replies

AD Administrator Syncfusion Team August 15, 2006 07:28 PM UTC

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")


AD Administrator Syncfusion Team 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.


KM Kwabena Manu 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?


AD Administrator Syncfusion Team 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.

Loader.
Up arrow icon