ExternalRangeExpression Method

Represents a cell range reference expression.

Syntax

Javascript (Usage)
Javascript (Specification)

var value; // Type: any
value = GcSpread.Sheets.Calc.Expressions.ExternalRangeExpression(source,
                                                                 startRow,
                                                                 startColumn,
                                                                 endRow,
                                                                 endColumn,
                                                                 startRowRelative,
                                                                 startColumnRelative,
                                                                 endRowRelative,
                                                                 endColumnRelative);

function ExternalRangeExpression( 
   source : object,
   startRow : number,
   startColumn : number,
   endRow : number,
   endColumn : number,
   startRowRelative : boolean,
   startColumnRelative : boolean,
   endRowRelative : boolean,
   endColumnRelative : boolean
) : any;

Parameters

source: The owner of the cell range.
startRow: The starting row coordinate of the range.
startColumn: The starting column coordinate of the range.
endRow: The ending row coordinate of the range.
endColumn: The ending column coordinate of the range.
startRowRelative: Whether the starting row coordinate is relative or absolute.
startColumnRelative: Whether the starting column coordinate is relative or absolute.
endRowRelative: Whether the ending row coordinate is relative or absolute.
endColumnRelative: Whether the ending column coordinate is relative or absolute.

Reference

Expressions type