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 System.Integer, _
   ByVal column As System.Integer, _
   ByVal endRow As System.Integer, _
   ByVal endColumn As System.Integer, _
   Optional ByVal offsetAbsolute As System.Boolean, _
   Optional ByVal offsetRelative As System.Boolean _
) As CalcSheetRangeExpression

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

public CalcSheetRangeExpression Offset( 
   System.int row,
   System.int column,
   System.int endRow,
   System.int endColumn,
   System.bool offsetAbsolute,
   System.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