Skip to main content

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

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.v24.2.dll

NuGet Package: DevExpress.Win.PivotGrid

#Declaration

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

#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 Return Value
True

The value is true.

0

False

The value is false.

1

Default

The value is specified by a global option or a higher-level object.

2

#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).

ShowOnlyAvailableItems_PivotExample

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.

fieldName.OptionsFilter.PopupExcelFilterShowAllValues = DevExpress.Utils.DefaultBoolean.True;
Trademark Name
PivotGridField_ShowOnlyAvailableItems PivotGridField_ShowOnlyAvailableItems_true

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.

fieldName.OptionsFilter.PopupExcelFilterShowAllValues = DevExpress.Utils.DefaultBoolean.False;
Trademark Name
PivotGridField_ShowOnlyAvailableItems PivotGridField_ShowOnlyAvailableItems_false
See Also