SpreadsheetDynamicFilterBuilder

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("Sheet1").Filter(filter => filter.Columns(fc => fc.DynamicFilter(df => df.Index(1))));
                        })
            )

Type(Kendo.Mvc.UI.SpreadsheetDynamicFilterType)

The filter sub-type, if any.Applicable types according to the main filter. * aboveAverage * belowAverage * tomorrow * today * yesterday * nextWeek * thisWeek * lastWeek * nextMonth * thisMonth * lastMonth * nextQuarter * thisQuarter * lastQuarter * nextYear * thisYear * lastYear * yearToDate

Parameters

value - SpreadsheetDynamicFilterType

The value that configures the type.

Example

             @( Html.Kendo().Spreadsheet()
                        .Name("spreadsheet")
                        .Sheets(sheets =>
                        {
                            sheets.Add().Name("Sheet1").Filter(filter => filter.Columns(fc => fc.DynamicFilter(df => df.Type(SpreadsheetDynamicFilterType.ThisMonth))));
                        })
            )