# SpreadsheetSheetFilterSettingsBuilder

## Methods

### Columns(System.Action)

An array which defines the filter configuration of individual columns.

#### Parameters

##### configurator - System.Action<[SpreadsheetSheetFilterSettingsColumnFactory](https://www.telerik.com/aspnet-core-ui/documentation/api/kendo.mvc.ui.fluent/spreadsheetsheetfiltersettingscolumnfactory)>

The configurator for the columns setting.

#### RETURNS

Returns the current instance of [SpreadsheetSheetFilterSettingsBuilder](https://www.telerik.com/aspnet-core-ui/documentation/api/kendo.mvc.ui.fluent/spreadsheetsheetfiltersettingsbuilder) .

### Ref(System.String)

The active range for the filter, for example, B1:D8.

#### Parameters

##### value - `System.String`

The value for Ref

#### RETURNS

Returns the current [SpreadsheetSheetFilterSettingsBuilder](https://www.telerik.com/aspnet-core-ui/documentation/api/kendo.mvc.ui.fluent/spreadsheetsheetfiltersettingsbuilder) instance.