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.ShowError Property

Gets or sets a value indicating whether to show custom error messages in cells.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

bool ShowError { get; set; }

#Property Value

Type Description
Boolean

true, to show a custom error string in cells containing errors; otherwise, false.

#Property Paths

You can access this nested property as listed below:

Object Type Path to ShowError
PivotTable
.View .ShowError

#Remarks

Use the ShowError property to hide error values in a PivotTable report, or change text displayed in error cells. Set the ShowError property to true, and then utilize the PivotViewOptions.ErrorCaption property to specify a custom string for error cells. If the PivotViewOptions.ErrorCaption property is not set, all errors will be displayed as blank values.

See Also