GrapeCity.Documents.Excel.SortDataOption

SortDataOption Enum

Specifies how text values are handled during sorting.

Use this enum with a value-based sort field to control whether text that looks like numbers is sorted as numeric data or whether numeric and text values are sorted separately.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum SortDataOption

Public Enum SortDataOption

Examples

worksheet.Range["A1:A4"].Value = new object[,] {
    {"Value"},
    {"10"},
    {"2"},
    {3}
};
ValueSortField sortField = new ValueSortField(worksheet.Range["A2:A4"]);
sortField.DataOption = SortDataOption.TextAsNumbers;

Fields

Name	Description
Normal	Sorts numeric and text data separately.
TextAsNumbers	Specifies to treat text as numeric data for the sort.