igSpreadsheet Filter Dialog

Topic Overview

Purpose

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

Required background

To understand this topic you need to be familiar with the concept and topics related to the Infragistics JavaScript Excel Library and igSpreadsheet.

In this topic

This topic contains the following sections:

• Introduction
• Filter Dialog for Worksheet
• Filter Dialog for Table
• Related Links

Introduction

Filter dialog summary

The {SpreadsheetName} 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 Worksheet

Code Example

The following example code demonstrates how to show the filter dialog for the first relative column in a worksheet region's filter settings. A region can be assigned with the SetRegion method exposed from the Worksheet.FilterSettings.

var executed = $(".selector").igSpreadsheet("showFilterDialogForWorksheet", 0);

Filter Dialog for 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.

var executed = $(".selector").igSpreadsheet("showFilterDialogForTable", table.columns(0));

Related Links

• igSpreadsheet Overview
• igSpreadsheet Activation And Navigation Interaction
• igSpreadsheet Feature Overview
• igSpreadsheet API