Represents a filter which can filter cells based on specific, fixed values, which are allowed to display. Syntax
Public Properties
Public Properties
Gets or sets the calendar type used to interpret values in the DateGroups collection. Syntax Exceptions Exception Description System.ComponentModel.InvalidEnumArgumentException The value assigned is not defined in the CalendarType enumeration.
Gets the collection of fixed date groups which should be filtered in. Syntax
Gets the collection of cell text values which should be filtered in. Syntax Remarks 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 ...
Gets or sets the value which indicates whether blank cells should be filtered in. Syntax Exceptions Exception Description System.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...
Represents a filter which will filter cells based on their font colors. Syntax Remarks This filter specifies a single color. Cells with this color font will be visible in the data range. All other cells will be hidden.
Public Properties
Public Properties