.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

PivotViewOptions.ShowMissing Property

Gets or sets a value indicating whether to display a custom string in cells that contain no values.

Namespace: DevExpress.Spreadsheet

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

Declaration

bool ShowMissing { get; set; }

Property Value

Type Description
Boolean

true, to show a custom message in empty cells; otherwise, false.

The default value is true.

Property Paths

You can access this nested property as listed below:

Object Type Path to ShowMissing
PivotTable
.View.ShowMissing

Remarks

To specify a custom string to be displayed in empty cells, use the PivotViewOptions.MissingCaption property. If the ShowMissing property is false, the PivotViewOptions.MissingCaption property value is ignored, and zeros are displayed in cells with no values.

See Also