Back to Devexpress

PivotViewOptions.ShowMissing Property

officefileapi-devexpress-dot-spreadsheet-dot-pivotviewoptions-15960b3b.md

latest1.9 KB
Original Source

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.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
bool ShowMissing { get; set; }
vb
Property ShowMissing As Boolean

Property Value

TypeDescription
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 TypePath 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

MissingCaption

PivotViewOptions Interface

PivotViewOptions Members

DevExpress.Spreadsheet Namespace