PivotViewOptions.MissingCaption Property

Gets or sets the text to be displayed in cells with no values.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

string MissingCaption { get; set; }

VB.NET

Property MissingCaption As String

Property Value

Type	Description
String	A String value that specifies the custom string to be displayed in empty cells.

Property Paths

You can access this nested property as listed below:

Object Type	Path to MissingCaption
PivotTable	.View .MissingCaption

Remarks

Use the MissingCaption property to fill blank values in a PivotTable report. Note that the MissingCaption property takes effect only when the PivotViewOptions.ShowMissing property is set to true.