PivotViewOptions.MissingCaption Property

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

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

C#
VB.NET

csharp

string MissingCaption { get; set; }

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.