New to Telerik UI for ASP.NET MVC? Download free 30-day trial

SpreadsheetSheetFilterSettingsColumnFactory

Methods

ValueFilter(System.Action)

Configures the value filter of the sheet

Parameters

configuration - System.Action<SpreadsheetValueFilterBuilder>

The value filter configuration.

Example


             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Sheets(sheets =>
                        {
                            sheets.Add()
                                .Name("Food Order")
                                .Filter(filter => filter.Columns(col => col.ValueFilter(vf => vf.Index(1))));
                        })
            )

TopFilter(System.Action)

Configures the top filter of the sheet

Parameters

configuration - System.Action<SpreadsheetTopFilterBuilder>

The top filter configuration.

Example


             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Sheets(sheets =>
                        {
                            sheets.Add()
                                .Name("Food Order")
                                .Filter(filter => filter.Columns(col => col.TopFilter(vf => vf.Index(1))));
                        })
            )

DynamicFilter(System.Action)

Configures the dynamic filter of the sheet

Parameters

configuration - System.Action<SpreadsheetDynamicFilterBuilder>

The dynamic filter configuration.

Example


             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Sheets(sheets =>
                        {
                            sheets.Add()
                                .Name("Food Order")
                                .Filter(filter => filter.Columns(col => col.DynamicFilter(vf => vf.Index(1))));
                        })
            )

CustomFilter(System.Action)

Configures the custom filter of the sheet

Parameters

configuration - System.Action<SpreadsheetCustomFilterBuilder>

The custom filter configuration.

Example


             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Sheets(sheets =>
                        {
                            sheets.Add()
                                .Name("Food Order")
                                .Filter(filter => filter.Columns(col => col.CustomFilter(vf => vf.Index(1))));
                        })
            )

In this article
Not finding the help you need?