Offset(Int32,Int32,Int32,Int32,Boolean,Boolean) Method

Get a new expression with specific offset.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function Offset( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal endRow As Integer, _
   ByVal endColumn As Integer, _
   Optional ByVal offsetAbsolute As Boolean, _
   Optional ByVal offsetRelative As Boolean _
) As CalcSheetRangeExpression

'Usage
 
Dim instance As CalcSheetRangeExpression
Dim row As Integer
Dim column As Integer
Dim endRow As Integer
Dim endColumn As Integer
Dim offsetAbsolute As Boolean
Dim offsetRelative As Boolean
Dim value As CalcSheetRangeExpression
 
value = instance.Offset(row, column, endRow, endColumn, offsetAbsolute, offsetRelative)

public CalcSheetRangeExpression Offset( 
   int row,
   int column,
   int endRow,
   int endColumn,
   bool offsetAbsolute,
   bool offsetRelative
)

Parameters

row: the row offset
column: the column offset
endRow: the end row offset
endColumn: the end column offset
offsetAbsolute: true if offset the absolute indexes.
offsetRelative: true if offset the relative indexes.

Return Value

Return a CalcExpression which offset from current expression.

Reference

CalcSheetRangeExpression Class
CalcSheetRangeExpression Members
Overload List