New to Telerik UI for ASP.NET MVC? Download free 30-day trial

Sorting and Filtering

The Spreadsheeto for ASP.NET MVC allows you to set predefinged sort and filter settings.

Sorting

You can set the Sorting configuration via the Sort() option. Set the reference over which the sorting will be applied via the Ref() configuration and define further sorting settings via the Columns() configuration option.

.Sheets(sheets =>
    {
        sheets.Add()
            .Name("Sheet1")
            .Sort(sort => sort
                .Ref("A3:G49")
                .Columns(columns => { 
                    columns.Add().Index(3).Ascending(false); 
                })
            )
            //additional sheet configuration options
    })

Filtering

You can set the Filtering configuration via the Filter() option. Set the reference over which the filtering will be applied via the Ref() configuration and define further filtering settings via the Columns() configuration option. You will need to set a Filter and the additional parameters for each filter.

The supported filters are:

  • ValueFilter - Represents a filter applied to a column of a given range. Used to filter a column by a predefined set of values.
  • TopFilter - Represents a filter applied to a column of a given range. It may be used to filter the top X items (top X percent, bottom X percent, top X number, bottom X number).
  • DynamicFilter - Represents a filter applied to a column of a given range. It may be used to filter dates and numbers for relative values, like belowAverage, yesterday, etc.
  • CustomFilter - Represents a filter applied to a column of a given range. It may specify one or two criterion, comparison operator (equals, starts with, greater than etc.), and logical operator (and, or).
.Sheets(sheets =>
    {
        sheets.Add()
            .Name("Sheet1")
            .Filter(filter => filter
                .Ref("A3:G49")
                .Columns(columns => { columns
                    .Add()
                    .Index(0)
                    .Filter("custom")
                    .Criteria(criteria=>criteria
                        .Add()
                        .Operator(SpreadsheetFilterOperator.GreaterThan)
                        .Value(10227)); 
                }))
    //additional sheet configuration options
})

See Also

In this article
Not finding the help you need? Improve this article