PivotGridFieldOptionsFilter.PopupExcelFilterShowAllValues Property

Gets or sets whether or not filters applied to other fields affect filter values displayed for the current field in the Excel-style filter popup.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v21.2.dll

NuGet Packages: DevExpress.Win.Design, DevExpress.Win.PivotGrid

Declaration

C#

[DefaultValue(DefaultBoolean.Default)]
[XtraSerializableProperty]
public virtual DefaultBoolean PopupExcelFilterShowAllValues { get; set; }

VB.NET

<DefaultValue(DefaultBoolean.Default)>
<XtraSerializableProperty>
Public Overridable Property PopupExcelFilterShowAllValues As DefaultBoolean

Property Value

Type	Default	Description
DefaultBoolean	Default	A DefaultBoolean value that specifies whether or not filters applied to other fields affect filter values displayed for the current field in the Excel-style filter popup.

Available values:

Name	Description
True	true. DefaultBoolean.True has a constant value of 0, while the standard true value corresponds to a value of 1. In Visual Basic, do not use implicit conversion of Boolean values to DefaultBoolean, and vice versa, as the conversion may produce incorrect results.
False	false. DefaultBoolean.False has a constant value of 1, while the standard false value corresponds to a value of 0. In Visual Basic, do not use implicit conversion of Boolean values to DefaultBoolean, and vice versa, as the conversion may produce incorrect results.
Default	The default behavior determined by the control’s logic.

Property Paths

You can access this nested property as listed below:

Object Type	Path to PopupExcelFilterShowAllValues
PivotGridField	.OptionsFilter .PopupExcelFilterShowAllValues

Remarks

The PopupExcelFilterShowAllValues property allows you to simulate the group filter behavior without merging fields into a group. This property is not in effect when you open a filter window for grouped fields when the GroupFilterMode is List.

A sample Pivot Grid contains two row fields: Trademark and Name (‘fieldTrademark’ and ‘fieldName’ in code).

If you set the PopupExcelFilterShowAllValues property to DefaultBoolean.True for the Name field, its filter popup displays car models depending on the selected Trademark values.

C#

fieldName.OptionsFilter.PopupExcelFilterShowAllValues = DevExpress.Utils.DefaultBoolean.True;

VB.NET

fieldName.OptionsFilter.PopupExcelFilterShowAllValues = DevExpress.Utils.DefaultBoolean.True

Trademark	Name

If you set the PopupExcelFilterShowAllValues property to DefaultBoolean.False for the Name field, the popup displays all car models available in the underlying data source.

C#

fieldName.OptionsFilter.PopupExcelFilterShowAllValues = DevExpress.Utils.DefaultBoolean.False;

VB.NET

fieldName.OptionsFilter.PopupExcelFilterShowAllValues = DevExpress.Utils.DefaultBoolean.False

Trademark	Name