SpreadsheetGear 2017
Offset Method (IRange)






SpreadsheetGear Namespace > IRange Interface : Offset Method
The number of rows to offset by (may be negative).
The number of columns to offset by (may be negative).
Returns a copy of the current IRange which is offset by the specified number of rows and columns.
Syntax
'Declaration
 
Function Offset( _
   ByVal rowOffset As System.Integer, _
   ByVal columnOffset As System.Integer _
) As IRange
'Usage
 
Dim instance As IRange
Dim rowOffset As System.Integer
Dim columnOffset As System.Integer
Dim value As IRange
 
value = instance.Offset(rowOffset, columnOffset)
IRange Offset( 
   System.int rowOffset,
   System.int columnOffset
)
function Offset( 
    rowOffset: System.Integer;
    columnOffset: System.Integer
): IRange; 
function Offset( 
   rowOffset : System.int,
   columnOffset : System.int
) : IRange;
IRange* Offset( 
   System.int rowOffset,
   System.int columnOffset
) 
IRange^ Offset( 
   System.int rowOffset,
   System.int columnOffset
) 

Parameters

rowOffset
The number of rows to offset by (may be negative).
columnOffset
The number of columns to offset by (may be negative).

Return Value

A copy of the current IRange which is offset by the specified number of rows and columns.
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

IRange Interface
IRange Members
Intersect Method
Subtract Method
Union Method