Version

Search Results

WorksheetFilterSettings Class Members

Public Properties Public Methods

ApplyAverageFilter Method (WorksheetFilterSettings)

Applies an AverageFilter to the column. Syntax Parameters relativeColumnIndex A zero based column index relative to the Regiontype The value indicating whether to filter in values below or above the average of the data range. Exceptions Exception Description System.InvalidOperationException If the Region was not s...

ApplyCustomFilter(Int32,CustomFilterCondition) Method

Applies a CustomFilter to the column. Syntax Parameters relativeColumnIndex A zero based column index relative to the Regioncondition The condition which must pass for the data to be filtered in. Exceptions Exception Description System.ArgumentNullException condition is null. System.InvalidOperationException If th...

ApplyCustomFilter(Int32,CustomFilterCondition,CustomFilterCondition,ConditionalOperator) Method

Applies a CustomFilter to the column. Syntax Parameters relativeColumnIndex A zero based column index relative to the Regioncondition1 The first condition used to filter the data.condition2 The second condition used to filter the data.conditionalOperator The operator which defines how to logically combine conditio...

ApplyCustomFilter Method (WorksheetFilterSettings)

Applies a CustomFilter to the column. Overload List

ApplyDatePeriodFilter Method (WorksheetFilterSettings)

Applies an DatePeriodFilter to the column. Syntax Parameters relativeColumnIndex A zero based column index relative to the Regiontype The type of date period to filter in.value The 1-based value of the month or quarter to filter in. Exceptions Exception Description System.InvalidOperationException If the Region wa...

ApplyFillFilter Method (WorksheetFilterSettings)

Applies a FillFilter to the column. Syntax Parameters relativeColumnIndex A zero based column index relative to the Regionfill A Infragistics.Documents.Excel.CellFill by which the cells should be filtered. Exceptions Exception Description System.ArgumentNullException fill is null. System.InvalidOperationException ...

ApplyFixedValuesFilter(Int32,Boolean,CalendarType,FixedDateGroup[]) Method

Applies a FixedValuesFilter to the column. Syntax Parameters relativeColumnIndex A zero based column index relative to the RegionincludeBlanks The value which indicates whether blank cells should be filtered in.calendarType The calendar type used to interpret values in the dateGroups collection.dateGroups The coll...