SpreadsheetValueFilterBuilder

Methods

Index(System.Double)

The index of the column relative to the filter range.

Parameters

value - System.Double

The value that configures the index.

Example

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

Values(System.Object[])

The filter values for filters that support multiple values.

Parameters

value - System.Object[]

The value that configures the values.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Sheets(sheets =>
                        {
                            sheets.Add()
                                .Name("Food Order")
                                .Filter(filter => filter.Columns(col => col.ValueFilter(vf => vf.Values(new int[] { 100, 200 }))))
                        })
            )