GrapeCity.Documents.Excel.ValueSortField.SortOn

SortOn Property

SortOn

Gets the sort type.

This value indicates that the sort field evaluates cells by values.

Declaration

public override SortOnType SortOn { get; }

Public Overrides ReadOnly Property SortOn As SortOnType

Overrides

SortFieldBase.SortOn

Implements

ISortField.SortOn

Examples

worksheet.Range["A1:A3"].Value = new object[,] {
    {"Name"},
    {"Bob"},
    {"Alice"}
};
IValueSortField sortField = new ValueSortField(worksheet.Range["A1:A3"], SortOrder.Ascending);
if (sortField.SortOn == SortOnType.Values)
{
    worksheet.Range["A1:A3"].Sort(SortOrientation.Columns, false, sortField);
}