PivotViewOptions.ShowMissing Property
In This Article
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.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
#Declaration
#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 Show |
---|---|
Pivot |
|
#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