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.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

bool ShowMissing { get; set; }

VB.NET

Property ShowMissing As Boolean

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.