constructor

• new SpreadsheetCellRange(firstRow, firstColumn): SpreadsheetCellRange

• Parameters

  • firstRow: number

  • firstColumn: number

  Returns SpreadsheetCellRange

• new SpreadsheetCellRange(firstRow, firstColumn, lastRow, lastColumn): SpreadsheetCellRange

• Parameters

  • firstRow: number

  • firstColumn: number

  • lastRow: number

  • lastColumn: number

  Returns SpreadsheetCellRange

• new SpreadsheetCellRange(address): SpreadsheetCellRange

• Parameters

  • address: string

  Returns SpreadsheetCellRange

• new SpreadsheetCellRange(): SpreadsheetCellRange

• Returns SpreadsheetCellRange

• new SpreadsheetCellRange(..._rest): SpreadsheetCellRange

• Parameters

  • Rest ..._rest: any[]

  Returns SpreadsheetCellRange

Static $t

Static empty

firstColumn

• get firstColumn(): number

• Returns the index of the first column in the range.

  Returns number

firstRow

• get firstRow(): number

• Returns the index of the first row in the range.

  Returns number

isEmpty

• get isEmpty(): boolean

• Returns a boolean indicating if the structure represents a valid range.

  Returns boolean

isSingleCell

• get isSingleCell(): boolean

• Returns a boolean indicating if the range represents a single cell.

  Returns boolean

lastColumn

• get lastColumn(): number

• Returns the index of the last column in the range.

  Returns number

lastRow

• get lastRow(): number

• Returns the index of the last row in the range.

  Returns number

contains

• contains(cell): boolean

• Returns a boolean indicating if the specified cell is within the range.

  Parameters

  • cell: SpreadsheetCell

    The cell to evaluate

  Returns boolean

• contains(range): boolean

• Returns a boolean indicating if the specified range is completely within this range.

  Parameters

  • range: SpreadsheetCellRange

    The range to evaluate

  Returns boolean

• contains(row, column): boolean

• Returns a boolean indicating if the specified cell is within the range.

  Parameters

  • row: number

    The row to evaluate

  • column: number

    The column to evaluate

  Returns boolean

equals

• equals(other): boolean

• Compares the value of this SheetCellRange instance to the specified [[SpreadsheetCellRange]].

  Parameters

  • other: SpreadsheetCellRange

    The instance of the [[SpreadsheetCellRange]] to compare

  Returns boolean

• equals(obj): boolean

• Compares the specified [[SpreadsheetCellRange]] to this instance's values.

  Parameters

  • obj: any

    The object to compare to the current instance

  Returns boolean

equals1

• equals1(obj): boolean

• Compares the specified [[SpreadsheetCellRange]] to this instance's values.

  Parameters

  • obj: any

    The object to compare to the current instance

  Returns boolean

getHashCode

• getHashCode(): number

• Returns a hash value for the [[SpreadsheetCellRange]]

  Returns number

intersect

• intersect(range): SpreadsheetCellRange

• Returns a range that represents the common area within the current and specified range.

  Parameters

  • range: SpreadsheetCellRange

    The range to intersect with.

  Returns SpreadsheetCellRange

intersectsWith

• intersectsWith(range): boolean

• Returns a boolean indicating if the current and specified range overlap.

  Parameters

  • range: SpreadsheetCellRange

    The range to compare with.

  Returns boolean

toString

• toString(): string

• Returns a string representation of the [[SpreadsheetCellRange]]

  Returns string

• toString(mode): string

• Returns a string representation of the range using the specified mode.

  Parameters

  • mode: CellReferenceMode

    An enumeration used to indicate how references are represented

  Returns string

union

• union(range): SpreadsheetCellRange

• Returns a range that contains the contains the current and specified range.

  Parameters

  • range: SpreadsheetCellRange

    The range to combine with.

  Returns SpreadsheetCellRange

Static staticInit

• staticInit(): void

• Returns void