ig.excel.WorksheetSortSettings
Dependencies
-
clearRegion
- .clearRegion( );
Clears the region as well as any existing sort criteria
-
reapplySortConditions
- .reapplySortConditions( );
Re-sorts all data cells in the region based on the sort conditions.
-
region
- .region( );
- Return Type:
- ig.excel.WorksheetRegion
- Return Type Description:
- Returns a WorksheetRegion.
Returns the region that the filter settings is applied to (read-only).
-
setRegion
- .setRegion( address:string );
Sets the region where the filter settings should be applied
- address
- Type:string
- The address of the new region.
Exceptions
Exception Description ig.InvalidOperationException If the region intersects with a table of other reserved area in the worksheet. Remarks
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.
-
setRegion
- .setRegion( address:string, cellReferenceMode:ig.excel.CellReferenceMode );
Sets the region where the filter settings should be applied
- address
- Type:string
- The address of the new region.
- cellReferenceMode
- Type:ig.excel.CellReferenceMode
- The reference to use the parse the address.
Exceptions
Exception Description ig.InvalidOperationException If the region intersects with a table of other reserved area in the worksheet. Remarks
Note: setting the region will clear any applied filters or sort criteria.
-
sortType
- .sortType( );
- Return Type:
- ig.excel.WorksheetSortType
- Return Type Description:
- Returns a WorksheetSortType.
Determines whether columns or rows will be sorted within the region. 'Rows' is the default.
Remarks
Note: when this property is changed all existing sort conditions will be cleared so this property should be set before sort conditions are added. See Also
-
sortType
- .sortType( value:ig.excel.WorksheetSortType );
- Return Type:
- ig.excel.WorksheetSortType
- Return Type Description:
- Returns a WorksheetSortType.
Determines whether columns or rows will be sorted within the region. 'Rows' is the default.
- value
- Type:ig.excel.WorksheetSortType
Remarks
Note: when this property is changed all existing sort conditions will be cleared so this property should be set before sort conditions are added. See Also