PivotGridFieldBase.EmptyCellText Property

Gets the text displayed by an empty cell.

Namespace: DevExpress.XtraPivotGrid

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

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation

Declaration

C#

[DefaultValue("")]
public string EmptyCellText { get; set; }

VB.NET

<DefaultValue("")>
Public Property EmptyCellText As String

Property Value

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

Remarks

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.