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

C#

bool ShowError { get; set; }

VB.NET

Property ShowError As Boolean

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.