GrapeCity.Documents.Excel.IValueSortField.CustomValues

CustomValues Property

CustomValues

Gets or sets the custom value list, such as 3,2,5,1.

If this property is not an empty string, the sort order is determined by the custom values list.

Declaration

string CustomValues { get; set; }

Property CustomValues As String

Examples

worksheet.Range["A1:A5"].Value = new object[,] {
    {"Value"},
    {3},
    {2},
    {5},
    {1}
};
IValueSortField sortField = new ValueSortField(worksheet.Range["A2:A5"], "3,2,5,1");
sortField.CustomValues = "5,3,2,1";
string customValues = sortField.CustomValues;