PivotGridFieldBase.EmptyCellText Property
Gets the text displayed by an empty cell.
Namespace: DevExpress.XtraPivotGrid
Assembly: DevExpress.PivotGrid.v24.1.Core.dll
NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation
Declaration
[XtraSerializableProperty]
[XtraSerializablePropertyId(1)]
public string EmptyCellText { get; set; }Property Value
| Type | Description |
|---|---|
| String | 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.