PivotGridField.EmptyCellText Property

Gets the text displayed by an empty cell. This is a dependency property.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v23.2.dll

NuGet Package: DevExpress.Wpf.PivotGrid

Declaration

C#

public string EmptyCellText { get; set; }

VB.NET

Public Property EmptyCellText As String

Property Value

Type	Description
String	A string which is the text displayed by an empty data cell.

Remarks

Each data cell in the DXPivotGrid control displays the result of a summary calculated for a group of records against a data field. When the control’s underlying data source doesn’t contain records which correspond to a specific cell, this cell doesn’t display anything. A data field’s EmptyCellText property allows you to specify the text that should be displayed within empty cells that correspond to this data field. For instance, it can be set to ‘0’ to display zeros.

To dynamically customize the display text of any cell (including the empty ones) the PivotGridControl.CustomCellDisplayText event can be handled.