Skip to main content

PivotGridFieldBase.EmptyCellText Property

Gets the text displayed by an empty cell.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v22.2.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Dashboard.Design


public string EmptyCellText { get; set; }

Property Value

Type Default Description
String String.Empty

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