Gets or sets the value which indicates whether strings should be compared case-sensitively when they are sorted. Syntax Property Value True to sort strings case-sensitively; False to ignore case. Remarks This is only applicable to sort conditions which sort strings.
Gets the collection of sort conditions to use when sorting the region of data. Syntax Remarks If these settings are used in a Infragistics.Documents.Excel.WorksheetTable, each sort condition in the collection applies to a Infragistics.Documents.Excel.WorksheetTableColumn. This collection is ordered based on preced...
Exposes methods to identify a region in the wroksheet and to apply sort criteria to that region. Syntax
Public Properties Public Methods
Public Methods
Public Properties
Clears the region as well as any existing sort criteria Syntax
Re-sorts all data cells in the region based on the sort conditions. Syntax
Returns the region that the filter settings is applied to (read-only). Syntax
Sets the region where the filter settings should be applied Syntax Parameters address The address of the new region. Exceptions Exception Description System.InvalidOperationException If the region intersects with a table of other reserved area in the worksheet. Remarks The CellReferenceMode of the workbook will be...