SpreadsheetSheetFilterSettingsColumnFactory

Properties

Spreadsheet - Spreadsheet

The background CSS color of the cell.

Methods

ValueFilter(System.Action)

Configures the value filter of the sheet

Parameters

configuration - System.Action<SpreadsheetValueFilterBuilder>

The value filter configuration.

Example

Razor

 
             @( 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

Razor

 
             @( 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

Razor

 
             @( 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

Razor

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

Add()

Adds an item to the collection

RETURNS

Returns a SpreadsheetSheetFilterSettingsColumnBuilder with the available configuration options.