BangRangeExpression Method

Represents a cell range reference on the current sheet.

Syntax

Javascript (Usage)
Javascript (Specification)

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

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

Parameters

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