Exposes methods to identify a region in the wroksheet and to apply sort criteria to that region.
Inheritance
object
SortSettings<RelativeIndex>
Properties
Section titled "Properties"Region
Section titled "Region"Returns the region that the filter settings is applied to (read-only).
public WorksheetRegion Region { get; }SortType
Section titled "SortType"Determines whether columns or rows will be sorted within the region. 'Rows' is the default.
public WorksheetSortType SortType { get; set; }Methods
Section titled "Methods"ClearRegion()
Section titled "ClearRegion()"Clears the region as well as any existing sort criteria
public void ClearRegion()Returns any
InitializeRegion()
Section titled "InitializeRegion()"Initializes the region to null
protected override void InitializeRegion()Returns any
ReapplySortConditions()
Section titled "ReapplySortConditions()"Re-sorts all data cells in the region based on the sort conditions.
public void ReapplySortConditions()Returns any
SetRegion(string)
Section titled "SetRegion(string)"Sets the region where the filter settings should be applied
public void SetRegion(string address)Parameters
- address:
string
Returns any
SetRegion(string, CellReferenceMode)
Section titled "SetRegion(string, CellReferenceMode)"Sets the region where the filter settings should be applied
public void SetRegion(string address, CellReferenceMode cellReferenceMode)Parameters
- address:
string - cellReferenceMode:
CellReferenceMode