CellReferenceHelper
Table of Contents
Properties
-
$beforeCellAddress
: string
-
$beforeColumn
: int
-
$beforeRow
: int
-
$numberOfColumns
: int
-
$numberOfRows
: int
Methods
-
__construct()
: mixed
-
beforeCellAddress()
: string
-
cellAddressInDeleteRange()
: bool
-
refreshRequired()
: bool
-
updateCellReference()
: string
-
updateColumnReference()
: string
-
updateRowReference()
: string
$beforeCellAddress
protected
string
$beforeCellAddress
$beforeColumn
protected
int
$beforeColumn
$beforeRow
protected
int
$beforeRow
$numberOfColumns
protected
int
$numberOfColumns
$numberOfRows
protected
int
$numberOfRows
__construct()
public
__construct([string $beforeCellAddress = 'A1' ][, int $numberOfColumns = 0 ][, int $numberOfRows = 0 ]) : mixed
Parameters
-
$beforeCellAddress
: string
= 'A1'
-
-
$numberOfColumns
: int
= 0
-
-
$numberOfRows
: int
= 0
-
beforeCellAddress()
public
beforeCellAddress() : string
cellAddressInDeleteRange()
public
cellAddressInDeleteRange(string $cellAddress) : bool
Parameters
-
$cellAddress
: string
-
refreshRequired()
public
refreshRequired(string $beforeCellAddress, int $numberOfColumns, int $numberOfRows) : bool
Parameters
-
$beforeCellAddress
: string
-
-
$numberOfColumns
: int
-
-
$numberOfRows
: int
-
updateCellReference()
public
updateCellReference([string $cellReference = 'A1' ][, bool $includeAbsoluteReferences = false ][, bool $onlyAbsoluteReferences = false ]) : string
Parameters
-
$cellReference
: string
= 'A1'
-
-
$includeAbsoluteReferences
: bool
= false
-
-
$onlyAbsoluteReferences
: bool
= false
-
updateColumnReference()
protected
updateColumnReference(int $newColumnIndex, string $absoluteColumn) : string
Parameters
-
$newColumnIndex
: int
-
-
$absoluteColumn
: string
-
updateRowReference()
protected
updateRowReference(int $newRowIndex, string $absoluteRow) : string
Parameters
-
$newRowIndex
: int
-
-
$absoluteRow
: string
-