.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

PivotViewOptions.MissingCaption Property

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

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v21.1.Core.dll

Declaration

string MissingCaption { get; set; }

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.

See Also