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. Image for the cookie policy date

problem doing string equality check in if stmt

I need to have the value of a NamedRange be a string, and use the NamedRange key in an if stmt like this: engine.AddNamedRange("Y","B12"); engine.AddNamedRange("X","if(D0=Y,A0+B0,(A0))"); But this D0=Y evals to false. Following works: engine.AddNamedRange("X","if(D0=\"B12\",A0+B0,(A0))"); So this looks like a bug.

2 Replies

AD Administrator Syncfusion Team July 14, 2005 11:38 PM UTC

>>engine.AddNamedRange("Y","B12"); This makes the namedrange Y refer to the cell B12. If you want the namedrange Y to refer to the string B12, then try: engine.AddNamedRange("Y","\"B12\"");

BT Byron Tate July 15, 2005 01:41 AM UTC

thanks! quick help as usual.

Live Chat Icon For mobile
Up arrow icon