Skip to main content
Row

PivotViewOptions.MissingCaption Property

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

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

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