Applies a Infragistics.Documents.Excel.Filtering.FontColorFilter to the column. Overload List
Applies a Infragistics.Documents.Excel.Filtering.IconFilter to the column. Syntax Parameters iconSet The icon set containing the icon.iconIndex The zero-based index of the icon in the set or null for NoCellIcon. Exceptions Exception Description System.ArgumentException If the icon set is not valid. System.Argument...
Applies a Infragistics.Documents.Excel.Filtering.IconFilter to the column. Overload List
Applies a Infragistics.Documents.Excel.Filtering.RelativeDateRangeFilter to the column. Syntax Parameters offset 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. Exceptions Exception Description Sys...
Applies a Infragistics.Documents.Excel.Filtering.TopOrBottomFilter to the column which will filter in the top 10 values in the list of sorted values. Syntax Exceptions Exception Description System.InvalidOperationException The WorksheetTable.IsFilterUIVisible value of the owning table is False. Filters cannot be a...
Applies a Infragistics.Documents.Excel.Filtering.TopOrBottomFilter to the column. Syntax Parameters type The type of the filter.value The number or percentage of value of values which should be filtered in. Exceptions Exception Description System.ComponentModel.InvalidEnumArgumentException type is not defined in t...
Applies a Infragistics.Documents.Excel.Filtering.TopOrBottomFilter to the column which will filter in the top 10 values in the list of sorted values. Overload List
Applies a Infragistics.Documents.Excel.Filtering.YearToDateFilter to the column. Syntax Exceptions Exception Description System.InvalidOperationException The WorksheetTable.IsFilterUIVisible value of the owning table is False. Filters cannot be applied when the header row or filter button is hidden. System.Invalid...
Gets the collection of formats used for each area of the column. Syntax Remarks The available areas of the column which can have a format set are the header, data, and totals areas. Applying a format to an area will apply the format to all cells in that area. If any area formats on the columns are set when the tab...
Removes the filter from the column if one is applied. Syntax Exceptions Exception Description System.InvalidOperationException If column was removed from the table.