GridFormulaCellModel engine parser fails on IF statement.

[Kwabena Manu]

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

Thanks

[Administrator]

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]

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

[Kwabena Manu]

>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]

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.