How to: Provide Custom Display Text for Data Cells

• Nov 13, 2018

The following example handles the ColumnView.CustomColumnDisplayText event to display empty strings within the “Discount” column’s cells if they contain zero values.

The result is shown below:

C#

using DevExpress.XtraGrid.Views.Base;

private void gridView1_CustomColumnDisplayText(object sender, 
CustomColumnDisplayTextEventArgs e) {
   if(e.Column.FieldName == "Discount")
      if(Convert.ToDecimal(e.Value) == 0) e.DisplayText = "";
}

VB.NET

Imports DevExpress.XtraGrid.Views.Base

Private Sub GridView1_CustomColumnDisplayText(ByVal sender As Object, _
ByVal e As CustomColumnDisplayTextEventArgs) Handles GridView1.CustomColumnDisplayText
   If e.Column.FieldName = "Discount" Then
      If e.Value = 0 Then e.DisplayText = ""
   End If
End Sub