(Showing Draft Content)

IValueFiterSetting Interface

IValueFiterSetting Interface

The value filter setting.


  • IValueFiterSetting



dataMap: DataMap

The DataMap used to convert raw values into display values shown when editing this filter.


exclusiveValueSearch: boolean

Gets or sets a value that determines whether the filter should include only values selected by the filterText property.

This property is set to true by default, which matches Excel's behavior.

Set it to false to disable this behavior, so searching only affects which items are displayed on the list and not which items are included in the filter.

Optional maxValues

maxValues: number

The maximum number of elements on the list of display values.

Optional sortValues

sortValues: boolean

A value that determines whether the values should be sorted

Optional uniqueValues

uniqueValues: any[]

An array containing the unique values to be displayed on the list.