CellReferenceHelper
Table of Contents
Properties
-
$beforeCellAddress
: string
-
$beforeColumn
: int
-
$beforeColumnAbsolute
: bool
-
$beforeColumnString
: string
-
$beforeRow
: int
-
$beforeRowAbsolute
: bool
-
$numberOfColumns
: int
-
$numberOfRows
: int
Methods
-
__construct()
: mixed
-
beforeCellAddress()
: string
-
cellAddressInDeleteRange()
: bool
-
computeNewColumnIndex()
: int
-
computeNewRowIndex()
: int
-
refreshRequired()
: bool
-
updateCellReference()
: string
-
updateColumnReference()
: string
-
updateRowReference()
: string
$beforeCellAddress
protected
string
$beforeCellAddress
$beforeColumn
protected
int
$beforeColumn
$beforeColumnAbsolute
protected
bool
$beforeColumnAbsolute
= false
$beforeColumnString
protected
string
$beforeColumnString
$beforeRow
protected
int
$beforeRow
$beforeRowAbsolute
protected
bool
$beforeRowAbsolute
= false
$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
-
computeNewColumnIndex()
public
computeNewColumnIndex(int $newColumnIndex, bool|null $topLeft) : int
Parameters
-
$newColumnIndex
: int
-
-
$topLeft
: bool|null
-
computeNewRowIndex()
public
computeNewRowIndex(int $newRowIndex, bool|null $topLeft) : int
Parameters
-
$newRowIndex
: int
-
-
$topLeft
: bool|null
-
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 ][, bool|null $topLeft = null ]) : string
Parameters
-
$cellReference
: string
= 'A1'
-
-
$includeAbsoluteReferences
: bool
= false
-
-
$onlyAbsoluteReferences
: bool
= false
-
-
$topLeft
: bool|null
= null
-
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
-