Your search did not match any results.

Sorting and AutoFilter

The ASP.NET Core Spreadsheet control allows you to sort data against column values. Use the commands located on the Data tab or a table header’s dropdown menu to sort column data or change column sort order (from ascending to descending, and vice versa).

The auto filter allows end-users to filter data by columns and to display only rows that meet specific conditions. Use the commands located on the Data tab or a table header’s dropdown menu to activate or reapply the filter, or completely remove all filters in a worksheet.

@inject IHostingEnvironment env @{ var documentPath = System.IO.Path.Combine( env.ContentRootPath, DirectoryManagmentUtils.GetDocumentSampleFolderPath(Context), "AutoFilter.xlsx"); } @(Html.DevExpress() .Spreadsheet("spreadsheet") .Height("500px") .Width("100%") .Ribbon(ribbon => ribbon.ActiveTabIndex(3)) .ConfirmOnLosingChanges(confirm => confirm.Enabled(false)) .DocumentRequestHandlerUrl(Url.Action("DxDocumentRequest")) .Open(documentPath) )
using DevExpress.AspNetCore.Spreadsheet; using DevExpress.Spreadsheet; using DevExpress.XtraSpreadsheet.Export; using Microsoft.AspNetCore.Hosting; using Microsoft.AspNetCore.Mvc; using System; using System.IO; using System.Linq; using System.Text; namespace AspNetCoreDemos.Spreadsheet { [Route("[action]")] public class DemosController : Controller { public ActionResult Tables() { return View(); } } }