Static
$tStatic
nextGets or sets the calendar type used to interpret values in the dateGroups collection.
InvalidEnumArgumentException The value assigned is not defined in the calendarType enumeration.
Gets or sets the value which indicates whether blank cells should be filtered in.
InvalidOperationException The value is set to False and both dateGroups and displayValues contain no values. This would prevent the filter from including any values, which is not allowed for a FixedValuesFilter.
Gets or sets the fixed date group at the specified index.
ArgumentOutOfRangeException 'index' is less than 0 or greater than or equal to count.
ArgumentNullException The value assigned is null.
ArgumentException The value assigned is already in the collection.
The 0-based index of the value to get or set.
Gets or sets the display text value at the specified index.
ArgumentOutOfRangeException 'index' is less than 0 or greater than or equal to count.
ArgumentNullException The value assigned is null.
ArgumentException The value assigned matches another value in the collection. Values are compared case-insensitively.
The 0-based index of the value to get or set.
Gets the collection of cell text values which should be filtered in.
Text values are compared case-insensitively.
Note: If any text values are longer than 255 characters in length and the workbook is saved in one of the 2003 formats, the correct rows will be hidden in the saved file, but the filter may be missing from the column or reapplying the filter may hide some of the matching cells.
Static
compareStatic
compareStatic
equalsStatic
equalsStatic
getStatic
getStatic
getStatic
reference
Represents a filter which can filter cells based on specific, fixed values, which are allowed to display.
See