ig.excel.SortSettings`1
Dependencies
-
caseSensitive
- .caseSensitive( );
- Return Type:
- boolean
- Return Type Description:
- True to sort strings case-sensitively; False to ignore case.
Gets the value which indicates whether strings should be compared case-sensitively when they are sorted.
Remarks
This is only applicable to sort conditions which sort strings.
-
caseSensitive
- .caseSensitive( value:boolean );
- Return Type:
- boolean
- Return Type Description:
- True to sort strings case-sensitively; False to ignore case.
Sets the value which indicates whether strings should be compared case-sensitively when they are sorted.
- value
- Type:boolean
Remarks
This is only applicable to sort conditions which sort strings.
-
sortConditions
- .sortConditions( );
Gets the collection of sort conditions to use when sorting the region of data.
Remarks
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.
-
sortConditions
- .sortConditions( sortableItem:ig.excel.T );
Gets the sort condition for the specified sort-able item.
- sortableItem
- Type:ig.excel.T
- The sort-able item for which to get or set the sort condition.
Exceptions
Exception Description ig.ArgumentNullException sortableItem is null. ig.InvalidOperationException The sort-able item is not already in the collection and there are already 64 sort conditions in the collection. -
sortConditions
- .sortConditions( sortableItem:ig.excel.T, value:ig.excel.SortCondition );
Sets the sort condition for the specified sort-able item.
- sortableItem
- Type:ig.excel.T
- The sort-able item for which to get or set the sort condition.
- value
- Type:ig.excel.SortCondition
Exceptions
Exception Description ig.ArgumentNullException sortableItem is null. ig.InvalidOperationException The sort-able item is not already in the collection and there are already 64 sort conditions in the collection. -
sortConditions
- .sortConditions( index:number );
Gets the pair of item and sort condition at the specified index.
- index
- Type:number
- The index at which to get the pair of item and sort condition.
Exceptions
Exception Description ig.ArgumentNullException The Key or Value of the assigned value is null. ig.InvalidOperationException The Key of the assigned value already in the collection at a different index. -
sortConditions
- .sortConditions( index:number, value:ig.KeyValuePair`2 );
Sets the pair of item and sort condition at the specified index.
- index
- Type:number
- The index at which to get the pair of item and sort condition.
- value
- Type:ig.KeyValuePair`2
Exceptions
Exception Description ig.ArgumentNullException The Key or Value of the assigned value is null. ig.InvalidOperationException The Key of the assigned value already in the collection at a different index.