PivotViewOptions.ShowMissing Property

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

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

C#
VB.NET

csharp

bool ShowMissing { get; set; }

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.