Applies a RelativeDateRangeFilter to the column. Syntax Parameters relativeColumnIndex A zero based column index relative to the Regionoffset The offset of relative filter. This combined with the duration determines the full range of accepted dates.duration The duration of the full range of accepted dates. Excepti...
Applies a TopOrBottomFilter to the column which will filter in the top 10 values in the list of sorted values. Syntax Parameters relativeColumnIndex A zero based column index relative to the Region Exceptions Exception Description System.InvalidOperationException If the Region was not set. System.ArgumentOutOfRang...
Applies a TopOrBottomFilter to the column. Syntax Parameters relativeColumnIndex A zero based column index relative to the Regiontype The type of the filter.value The number or percentage of value of values which should be filtered in. Exceptions Exception Description System.ComponentModel.InvalidEnumArgumentExcep...
Applies a TopOrBottomFilter to the column which will filter in the top 10 values in the list of sorted values. Overload List
Applies a YearToDateFilter to the column. Syntax Parameters relativeColumnIndex A zero based column index relative to the Region Exceptions Exception Description System.InvalidOperationException If the Region was not set. System.ArgumentOutOfRangeException If the relativeColumnIndex is outside of the Region.
Clears the filter that is applied to a specific column. Syntax Parameters relativeColumnIndex A zero based column index relative to the Region Exceptions Exception Description System.InvalidOperationException If the Region was not set. System.ArgumentOutOfRangeException If the relativeColumnIndex is outside of the...
Clears all previously applied filters Syntax
Clears the region as well as any existing filters and sort criteria Syntax
Gets the filter that is applied to a specific column. Syntax Parameters relativeColumnIndex A zero based column index relative to the Region Return Value The apllied filter or null if no filter was applied to this column. Exceptions Exception Description System.InvalidOperationException If the Region was not set. ...
Re-filters all data cells in the filter region based on the applied filters. Syntax Remarks Filters are not constantly evaluated as data within the region changes. Filters are applied to the region only when they are added or removed or when the ReapplyFilters method is called. If no filters are applied this metho...