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.