SpreadsheetSheetFilterSettingsColumnBuilder
Defines the fluent API for configuring SpreadsheetSheetFilterSettingsColumn
Methods
Criteria(System.Action)
An array of filter criteria for custom filters.
Parameters
configurator - System.Action<SpreadsheetSheetFilterSettingsColumnCriteriaFactory>
The configurator for the criteria setting.
Filter(System.String)
The filter that will apply to this column.The supported filters are: value - Filters based on unique values.; custom - Applies custom filtering criteria.; top - Filters the top or bottom records. or dynamic - Filters based on dynamic criteria..
Parameters
value - System.String
The value for Filter
Index(System.Double)
The index of the column relative to the filter range.
Parameters
value - System.Double
The value for Index
Logic(System.String)
The logical operator that will apply to filter criteria.The supported values are: and or or.
Parameters
value - System.String
The value for Logic
Type(System.String)
The filter sub-type, if any.The applicable types according to the main filter are: toptopNumbertopPercentbottomNumberbottomPercent or dynamicaboveAveragebelowAveragetomorrowtodayyesterdaynextWeekthisWeeklastWeeknextMonththisMonthlastMonthnextQuarterthisQuarterlastQuarternextYearthisYearlastYearyearToDate.
Parameters
value - System.String
The value for Type
Value(System.Double)
The filter value for filters that require a single value, for example, top.
Parameters
value - System.Double
The value for Value
Values(System.Object[])
The filter values for filters that support multiple values.
Parameters
value - System.Object[]
The value for Values