Version

Filter Dialog Interactions (UltraSpreadsheet)

Purpose

This topic explains what operations can be performed by the user with the control’s filter dialog to create complex filters in a column.

Required background

The following table lists the concept and topics required as a prerequisite to understanding this topic.

Topic Purpose

In this section you will find information that will help you to better understand the object model and the functionalities of the Infragistics Excel Engine .

This topic explains in details the features of the UltraSpreadsheet control from developer perspective.

This topic provides an overview of the visual elements of the UltraSpreadsheet control.

In this topic

This topic contains the following sections:

Introduction

xam Spreadsheet Filter Dialog.png

Filter dialog summary

The UltraSpreadsheet control provides a filter dialog which is opened by clicking on the dropdown button in the header row of either a loaded worksheet or created table. The filter dialog will change based on the field that was interacted with.

Filter Dialog for a Worksheet

Code Example

The following example code demonstrates how to show the filter dialog for the first column in a worksheet region at index of zero. Alternatively, the index specified needs to exist within region.

In C#:

...
this.Spreadsheet1.ShowFilterDialogForWorksheet(0, Infragistics.Controls.Grids.SpreadsheetFilterDialogOption.Custom);
...

In Visual Basic:

...
Me.Spreadsheet1.ShowFilterDialogForWorksheet(0, Infragistics.Controls.Grids.SpreadsheetFilterDialogOption.Custom)
...

Filter Dialog for a Table

Code Example

The following example code demonstrates how to show the filter dialog for the first column in a worksheet table, specified by it’s index.

In C#:

...
WorksheetTable Table1;
Table1 = this.Spreadsheet1.ActiveWorksheet.Tables[0];
this.Spreadsheet1.ShowFilterDialogForTable(Table1.Columns[0], Infragistics.Controls.Grids.SpreadsheetFilterDialogOption.Custom);
...

In Visual Basic:

...
Dim Table1 As WorksheetTable
Table1 = Me.Spreadsheet1.ActiveWorksheet.Tables(0)
Me.Spreadsheet1.ShowFilterDialogForTable(Table1.Columns(0), Infragistics.Controls.Grids.SpreadsheetFilterDialogOption.Custom)
...

Related Content

The following topics provide additional information related to this topic.

Topic Purpose

This topic explains the supported user actions when navigating the control’s cells.

This topic explains what action can be performed by the user when editing cells.

This topic explains what actions can be performed by the user when interacting with worksheet columns and rows.

This topic explains what actions can be performed by the user when interacting with the formula bar.

This topic explains the supported user actions when selecting cells, rows, or columns.

This topic explains what actions can be performed by the user when interacting with the worksheets.