SpreadsheetCustomFilterBuilder

Methods

Criteria(System.Action)

An array of filter criteria for custom filters.

Parameters

configurator - System.Action<SpreadsheetSheetFilterSettingsColumnCriteriaFactory>

The action that configures the criteria.

Example

Razor

 
             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Sheets(sheets =>
                        {
                            sheets.Add()
                                .Name("Food Order")
                                .Filter(filter => filter.Columns(cols => cols.CustomFilter(cf => cf.Criteria(criteria => criteria.Add(add => add.Value(DateTime.Now))))));
                        })
            )
             

Index(System.Double)

The index of the column relative to the filter range.

Parameters

value - System.Double

The value that configures the index.

Example

Razor

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

Logic(Kendo.Mvc.UI.SpreadsheetFilterLogic)

The logical operator to apply to filter criteria.Possible values are and, or.

Parameters

value - SpreadsheetFilterLogic

The value that configures the logic.

Example

Razor

 
             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Sheets(sheets =>
                        {
                            sheets.Add()
                                .Name("Food Order")
                                .Filter(filter => filter.Columns(cols => cols.CustomFilter(cf => cf.Logic(SpreadsheetFilterLogic.Or))))
                        })
            )