Expression cells displaying NAN - Can I display something else

Question

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?

Administrator · Answer

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.

Administrator · Answer

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