Gets or sets the duration of the full range of accepted dates. Syntax Exceptions Exception Description System.ComponentModel.InvalidEnumArgumentException The value assigned is not defined in the RelativeDateRangeDuration enumeration.
Gets or sets the offset of relative filter (previous, current, or next). Syntax Exceptions Exception Description System.ComponentModel.InvalidEnumArgumentException The value assigned is not defined in the RelativeDateRangeOffset enumeration. Remarks Type combined with Duration determines the relative date range to...
Represents the various relative date offsets which can be filtered by the RelativeDateRangeFilter. Syntax Members Member Description Current Filter in values in the current duration relative to the filters creation date. Next Filter in values in the next duration relative to the filters creation date. Previous Fil...
Represents a filter which can filter in cells in the upper or lower portion of the sorted values. Syntax
Represents the various filter types available for the TopOrBottomFilter. Syntax Members Member Description BottomPercentage Filter in the bottom N percent of values the sorted list of values. BottomValues Filter in the bottom N values in the sorted list of values. TopPercentage Filter in the top N percent of value...
Public Properties
Public Properties
Gets or sets the type of the filter. Syntax Property Value TopValues or BottomValues to filter in the top or bottom N value in the list of sorted values; TopPercentage or BottomPercentage to filter in the top or bottom N percentage of values in the list of sorted values. Exceptions Exception Description System.Com...
Gets or sets the number or percentage of value of values which should be filtered in. Syntax Property Value The number or percentage of items which should be filtered in. Exceptions Exception Description System.ArgumentOutOfRangeException The value assigned is less than 1 or greater than 500. Remarks When Type is ...
Exposes methods to identify a region in the wroksheet and to apply filters and optionally sort criteria to that region. Syntax