SortState.Sort(Int32, Fill, Boolean) Method

Sorts the specified column in the given order by the selected fill pattern.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void Sort(
    int columnIndex,
    Fill fill,
    bool descendingOrder
)

VB.NET

Sub Sort(
    columnIndex As Integer,
    fill As Fill,
    descendingOrder As Boolean
)

Parameters

Name	Type	Description
columnIndex	Int32	A zero-based index index of the column to sort.
fill	Fill	An object that contains fill pattern parameters.
descendingOrder	Boolean	true to sort in descending order; otherwise, false

Remarks

Example

C#

using DevExpress.Spreadsheet;

using (var workbook = new Workbook()) {
    workbook.LoadDocument("Document.xlsx");
    Worksheet worksheet = workbook.Worksheets["Regional sales"];
    workbook.Worksheets.ActiveWorksheet = worksheet;

    // Enable filtering for the "B2:E23" cell range.
    CellRange range = worksheet["B2:E23"];
    worksheet.AutoFilter.Apply(range);

    // Sort data in the "B2:E23" range
    // in descending order by column "C".
    Fill color = worksheet["C10"].Fill;
    worksheet.AutoFilter.SortState.Sort(1, color, false);
}

VB.NET

Imports DevExpress.Spreadsheet

Using workbook = New Workbook()
  workbook.LoadDocument("Document.xlsx")
  Dim worksheet As Worksheet = workbook.Worksheets("Regional sales")
  workbook.Worksheets.ActiveWorksheet = worksheet

  ' Enable filtering for the "B2:E23" cell range.
  Dim range As CellRange = worksheet("B2:E23")
  worksheet.AutoFilter.Apply(range)

  ' Sort data in the "B2:E23" range
  ' in descending order by column "C".
  Dim color As Fill = worksheet("C10").Fill
  worksheet.AutoFilter.SortState.Sort(1, color, False)
End Using