PivotGridFieldBase.EmptyCellText Property

Gets the text displayed by an empty cell.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v21.1.Core.dll


public string EmptyCellText { get; set; }

Property Value

Type Default Description


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


Each data cell in the XtraPivotGrid 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.

See Also