Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

PivotViewOptions.MissingCaption Property

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

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.2.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