SpreadsheetSheetFilterSettingsColumnCriteriaBuilder

Methods

Operator(Kendo.Mvc.UI.SpreadsheetFilterOperator)

The criterion operator type.Supported types vary based on the inferred column data type (inferred): * Text * contains - the text contains the value * doesnotcontain - text does not contain the value * startswith - text starts with the value * endswith - text ends with the value * Date * eq - date is the same as the value * neq - date is not the same as the value * lt - date is before the value * gt - date is after the value * Number * eq - is equal to the value * neq - is not equal to the value * gte - is greater than or equal to the value * gt - is greater than the value * lte - is less than or equal to the value * lt - is less than the value

Parameters

value - SpreadsheetFilterOperator

The value that configures the operator.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Sheets(sheets =>
                        {
                            sheets.Add()
                                .Name("Food Order")
                                .Filter(filter => 
                                    filter.Columns(col => 
                                        col.CustomFilter(cf => 
                                            cf.Criteria(criteria => 
                                                criteria.Add(cr => 
                                                    cr.Operator(SpreadsheetFilterOperator.Contains))))));
                        })
            )

Value(System.String)

The value for the criteria operator.

Parameters

value - System.String

The value that configures the value.

Example

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

Value(System.DateTime)

The value for the criteria operator.

Parameters

value - System.DateTime

The value that configures the value.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Sheets(sheets =>
                        {
                            sheets.Add()
                                .Name("Food Order")
                                .Filter(filter => 
                                    filter.Columns(col => 
                                        col.CustomFilter(cf => 
                                            cf.Criteria(criteria => 
                                                criteria.Add(cr => 
                                                    cr.Value(new DateTime(2024, 4, 16)))))));
                        })
            )

Value(System.Double)

The value for the criteria operator.

Parameters

value - System.Double

The value that configures the value.

Example

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