Static $tStatic nextGets or sets the value which indicates whether strings should be compared case-sensitively when they are sorted.
This is only applicable to sort conditions which sort strings.
True to sort strings case-sensitively; False to ignore case.Determines whether columns or rows will be sorted within the region. 'Rows' is the default.
Sets the region where the filter settings should be applied
The Workbook.cellReferenceMode of the workbook will be used to parse the region address.
Note: setting the region will clear any applied filters or sort criteria.
InvalidOperationException If the region intersects with a table of other reserved area in the worksheet.
The address of the new region.
Sets the region where the filter settings should be applied
Note: setting the region will clear any applied filters or sort criteria.
InvalidOperationException If the region intersects with a table of other reserved area in the worksheet.
The address of the new region.
The reference to use the parse the address.
Gets or sets the sort condition for the specified sort-able item.
ArgumentNullException 'sortableItem' is null.
InvalidOperationException The sort-able item is not already in the collection and there are already 64 sort conditions in the collection.
The sort-able item for which to get or set the sort condition.
Gets or sets the pair of item and sort condition at the specified index.
ArgumentNullException The Key or Value of the assigned value is null.
InvalidOperationException The Key of the assigned value already in the collection at a different index.
The index at which to get the pair of item and sort condition.
Gets the collection of sort conditions to use when sorting the region of data.
If these settings are used in a WorksheetTable, each sort condition in the collection applies to a WorksheetTableColumn.
This collection is ordered based on precedence. The first sort condition in the collection has the highest sort precedence.
Static compareStatic compareStatic equalsStatic equalsStatic getStatic getStatic getStatic reference
Exposes methods to identify a region in the wroksheet and to apply sort criteria to that region.