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.v19.2.dll
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 |
|---|---|
| True | Corresponds to a Boolean value of true. |
| False | Corresponds to a Boolean value of false. |
| Default | The value is determined by the current object’s parent object setting (e.g., a control setting). |
Property Paths
You can access this nested property as listed below:
| Object Type | Path to PopupExcelFilterShowAllValues |
|---|---|
| PivotGridField |
|
Remarks
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.
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.
fieldName.OptionsFilter.PopupExcelFilterShowAllValues = DevExpress.Utils.DefaultBoolean.False;
| Trademark | Name |
|---|---|
|
 |