SpreadsheetTopFilterBuilder

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.TopFilter(tf => tf.Index(1))));
                        })
            )

Type(Kendo.Mvc.UI.SpreadsheetTopFilterType)

The filter sub-type, if any.Applicable types according to the main filter. * TopNumber * TopPercent * BottomNumber * BottomPercent

Parameters

value - SpreadsheetTopFilterType

The value that configures the type.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Sheets(sheets =>
                        {
                            sheets.Add()
                                .Name("Food Order")
                                .Filter(filter => filter.Columns(col => col.TopFilter(tf => tf.Type(SpreadsheetTopFilterType.BottomNumber))));
                        })
            )

Value(System.Double)

The filter value for filters that require a single value, e.g. "top".

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.TopFilter(tf => tf.Value(100))));
                        })
            )