PivotViewOptions.ShowError Property

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

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

C#
VB.NET

csharp

bool ShowError { get; set; }

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.