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

Expression cells displaying NAN - Can I display something else

Is there a way to display something other than NAN when a formula does not compute on a cell. Perhaps leaving the cell blank or setting some other text would be nice. How would I accomplish this?

2 Replies

AD Administrator Syncfusion Team November 16, 2004 09:37 PM UTC

Is this a GridControl? If so, you can handle the DrawCellDisplayText. If e.DisplayText is NaN, then set e.DisplayText to what you want to see.

AD Administrator Syncfusion Team November 16, 2004 09:40 PM UTC

If you are using a GridGroupingControl, then use TableControlDrawCellDisplayText and e.Inner.DisplayText.

Live Chat Icon For mobile
Up arrow icon