Spread Windows Forms 12.0 Product Documentation
Offset Method (IRange)


GrapeCity.Spreadsheet Assembly > GrapeCity.Spreadsheet Namespace > IRange Interface : Offset Method
The number of rows (positive, negative, or 0 (zero)) by which the range is to be offset. Positive values are offset downward, and negative values are offset upward. The default value is 0.
The number of columns (positive, negative, or 0 (zero)) by which the range is to be offset. Positive values are offset to the right, and negative values are offset to the left. The default value is 0.
Returns a IRange object that represents a translated range from the specified range.
Syntax
'Declaration
 
Function Offset( _
   Optional ByVal rowOffset As Integer, _
   Optional ByVal columnOffset As Integer _
) As IRange
'Usage
 
Dim instance As IRange
Dim rowOffset As Integer
Dim columnOffset As Integer
Dim value As IRange
 
value = instance.Offset(rowOffset, columnOffset)
IRange Offset( 
   int rowOffset,
   int columnOffset
)

Parameters

rowOffset
The number of rows (positive, negative, or 0 (zero)) by which the range is to be offset. Positive values are offset downward, and negative values are offset upward. The default value is 0.
columnOffset
The number of columns (positive, negative, or 0 (zero)) by which the range is to be offset. Positive values are offset to the right, and negative values are offset to the left. The default value is 0.

Return Value

IRange.
See Also

Reference

IRange Interface
IRange Members