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

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


bool ShowMissing { get; set; }

Property Value

Type Description

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


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