- Drop Down Button
- WPF Ribbon, Toolbar and Menus
- DropDownButton Class
- Excel-style Drop-down Filter
- Drop-down Menu
Drop Down ButtonEnd users can use a field's filter drop-down to build a simple filter criterion and apply it to a field. To invoke a filter drop-down, click a field's filter button. The filter drop-down contains unique field values. Use the PivotGridField. GetUniqueValues method to get these values in code. To create complex filter criteria, use the Filter Editor. End-users cannot filter data fields. To hide filter buttons from all field headers, set the PivotGridControl. AllowFilter property to false. For individual fields, set the PivotGridField. This does not affect filtering in code. Excel-style filter drop-down does not work with OLAP data sources. FilterPopupMode property. FieldFilterPopupMode property. The Filter Rules tab displays a drop-down list of valid operators for the current field type. This allows you to construct a filter criterion. The Filter Values tab contains a checklist with the filter values. The shaded numbers in parentheses are record counts. Demo : Excel Style Filtering. Requires the installation of a WPF Subscription. The drop-down displays a list of values in a checked list box. It is based on the ListBoxEdit control. To implement a new custom filter and use it instead of the built-in filter drop-down, create a data template and assign it to the The PivotGridField. All docs. General Information. NET Subscription Overview. Common Tools Project Converter. Assembly Deployment Tool. Localization Service.
WPF Ribbon, Toolbar and Menus
The GridControl provides an Excel-style drop-down filter:. Demo : Excel Style Filtering. Requires installation of WPF Subscription. Starting from v ExcelSmart mode. In the previous versions, use the FilterPopupMode. Excel mode instead. The Filter Rules tab shows a list of operators the selected column accepts. A user should select an operator and specify operand values. The Filter Values tab shows an Excel-style checklist with the filter values. Record counts are displayed next to the filter values. The built-in search panel allows users to find filter values. You can group filter values in the Filter Values tab to allow users to filter data by multiple columns. Set the ColumnBase. FilterPopupGroupFields property to names of the fields by which filter values should be grouped. Separate names by comma, semicolon, or space. The order of field names determines the hierarchy in the group. The code sample below shows how to display the available models below each trademark in the Trademark column's drop-down filter:. The customized column's values are displayed at the root level by default; you can omit its name "Trademark". The code sample below has the same effect:. The code sample below shows how to display the available models below each trademark in the Model column's drop-down filter:. The customized column's values are not displayed at the root level in this case, its name "Model" cannot be omitted. You can filter data by applying Conditional Formatting rules. The Excel-style Drop-down Filter displays available rules and indicates the number of records that meet rule conditions:. Demo : Conditional Formatting. Requires a WPF Subscription.
Data Grid. Data Binding. Paging and Scrolling. Filtering and Sorting. Row Drag-and-Drop. Data Summaries. Pivot Grid. Field Chooser. Tree List. Column Customization. Html Editor CTP. Diagram CTP. Document Features. Custom Shapes. Area Charts. Bar Charts. Doughnut Charts. Financial Charts. Line Charts. Pie Charts. Point Charts. Polar and Radar Charts. Range Charts. Sparkline Charts. Tree Map. Funnel and Pyramid Charts. More Features. Gantt CTP. Bar Gauge. Circular Gauge. Linear Gauge.
Excel-style Drop-down Filter
GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together. If nothing happens, download GitHub Desktop and try again. If nothing happens, download Xcode and try again. If nothing happens, download the GitHub extension for Visual Studio and try again. We've modified this code example by using the DevExpress control version There is no need to create custom classes to resolve this problem. You can accomplish this task by using the Grid control in the TreeView mode as a popup content template of the LookUpEdit control. This way is more efficient and clear than the way used in this example for old versions of DevExpress controls. Skip to content. Dismiss Join GitHub today GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together. Sign up. C Branch: Find file. Sign in Sign up. Go back. Launching Xcode If nothing happens, download Xcode and try again. Latest commit Fetching latest commit…. Files to look at : MainWindow. Update version You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window.