- GrapeCity.CalcEngine Assembly
-
GrapeCity.Spreadsheet Assembly
- GrapeCity.CalcEngine
- GrapeCity.Core
- GrapeCity.Drawing
-
GrapeCity.Spreadsheet
- Classes
- Enums
-
Interfaces
- IAboveAverage
- IAlternatingStyles
- IAreas
- IArray<T>
- IAuthor
- IAutoFilter
- IAutoFilterOwner
- IBorder
- IBorders
- ICellEditor
- ICellRenderer
- ICellType
- ICharacters
- IColorPalette
- IColorScale
- IColorScaleCriteria
- IColorScaleCriterion
- IColorStops
- IColumnFooter
- IColumnHeader
- IComment
- IComments
- ICommentsThreaded
- ICommentThreaded
- IConditionValue
- IDatabar
- IDatabarBorder
- IDataManager
- IFilter
- IFilters
- IFont
- IFormatCondition
- IFormatConditions
- IFormatter
- IGradient
- IGraphic
- IHyperlink
- IHyperlinks
- IIconCriteria
- IIconCriterion
- IIconSetCondition
- IInterior
- IMedia
- IName
- INames
- INegativeBarFormat
- INumFmtSupportCellType
- IOutline
- IProtection
- IRange
- IReadonlyArray<T>
- IRowHeader
- ISheet
- ISheets
- ISheetView
- ISort
- ISortComparer
- ISortField
- ISortFields
- ISparkAxes
- ISparkColor
- ISparkHorizontalAxis
- ISparkline
- ISparklineGroup
- ISparklineGroups
- ISparkPoints
- ISparkVerticalAxis
- IStyle
- IStyles
- ITable
- ITableColumn
- ITableColumns
- ITableRow
- ITableRows
- ITables
- ITableStyle
- ITableStyleElement
- ITableStyleElements
- ITableStyles
- ITop10
- IUniqueValues
- IValidation
- IWorkbook
- IWorkbooks
- IWorkbookSet
- IWorksheet
- IWorksheets
- IWorksheetStyles
- IWorksheetView
- Structs
- GrapeCity.Spreadsheet.Charts
- GrapeCity.Spreadsheet.Commands
- GrapeCity.Spreadsheet.Data
- GrapeCity.Spreadsheet.Drawing
- GrapeCity.Spreadsheet.FormControls
- GrapeCity.Spreadsheet.IO
- GrapeCity.Spreadsheet.IO.OpenXml
- GrapeCity.Spreadsheet.Localization
- GrapeCity.Spreadsheet.Printing
- GrapeCity.Spreadsheet.UI
- GrapeCity.Wpf.SpreadSheet Assembly
- GrapeCity.Wpf.Spreadsheet.CellType Assembly
GrapeCity.Spreadsheet.ISort.SetRange
SetRange Method
SetRange(Reference)
Sets the range over which the sort occurs.
Declaration
void SetRange(Reference rng)Sub SetRange(rng As Reference)Parameters
| Type | Name | Description |
|---|---|---|
| Reference | rng | Specifies the range over which the sort represented by the ISort object occurs. |
Remarks
SetRange(Reference) can only be used when applying a sort to a sheet range, and cannot be used if the range is within a table.
SetRange(string)
Sets the range over which the sort occurs.
Declaration
void SetRange(string rng)Sub SetRange(rng As String)Parameters
| Type | Name | Description |
|---|---|---|
| string | rng | Specifies the range over which the sort represented by the ISort object occurs. |
Remarks
SetRange(Reference) can only be used when applying a sort to a sheet range, and cannot be used if the range is within a table.
SetRange(IRange)
Sets the range over which the sort occurs.
Declaration
void SetRange(IRange rng)Sub SetRange(rng As IRange)Parameters
| Type | Name | Description |
|---|---|---|
| IRange | rng | Specifies the range over which the sort represented by the ISort object occurs. |
Remarks
SetRange(Reference) can only be used when applying a sort to a sheet range, and cannot be used if the range is within a table.