StructuredReference
implements
Operand
Interfaces, Classes and Traits
- Operand
Table of Contents
-
NAME
= 'Structured Reference'
-
CLOSE_BRACE
= ']'
-
ITEM_SPECIFIER_ALL
= '#All'
-
ITEM_SPECIFIER_DATA
= '#Data'
-
ITEM_SPECIFIER_HEADERS
= '#Headers'
-
ITEM_SPECIFIER_ROWS_SET
= [self::ITEM_SPECIFIER_ALL, self::ITEM_SPECIFIER_HEADERS, self::ITEM_SPECIFIER_DATA, self::ITEM_SPECIFIER_TOTALS]
-
ITEM_SPECIFIER_THIS_ROW
= '#This Row'
-
ITEM_SPECIFIER_TOTALS
= '#Totals'
-
OPEN_BRACE
= '['
-
TABLE_REFERENCE
= '/([\p{L}_\\][\p{L}\p{N}\._]+)?(\[(?:[^\]\[]+|(?R))*+\])/miu'
-
$columns
: array<string|int, mixed>
-
$firstDataRow
: int
-
$headersRow
: int|null
-
$lastDataRow
: int
-
$reference
: string
-
$table
: Table
-
$tableName
: string
-
$totalsRow
: int|null
-
$value
: string
-
__construct()
: mixed
-
fromParser()
: self
-
parse()
: string
-
value()
: string
-
adjustRowReference()
: string
-
fullData()
: string
-
getColumnReference()
: string
-
getColumns()
: array<string|int, mixed>
-
getColumnsForColumnReference()
: string
-
getMaximumRow()
: int
-
getMinimumRow()
: int
-
getRowReference()
: string
-
getRowsForColumnReference()
: array<int, int>
-
getTableByName()
: Table
-
getTableForCell()
: Table
-
getTableStructure()
: void
-
isRowReference()
: bool
-
validateParsedReference()
: string
NAME
public
mixed
NAME
= 'Structured Reference'
CLOSE_BRACE
private
mixed
CLOSE_BRACE
= ']'
ITEM_SPECIFIER_ALL
private
mixed
ITEM_SPECIFIER_ALL
= '#All'
ITEM_SPECIFIER_DATA
private
mixed
ITEM_SPECIFIER_DATA
= '#Data'
private
mixed
ITEM_SPECIFIER_HEADERS
= '#Headers'
ITEM_SPECIFIER_ROWS_SET
private
mixed
ITEM_SPECIFIER_ROWS_SET
= [self::ITEM_SPECIFIER_ALL, self::ITEM_SPECIFIER_HEADERS, self::ITEM_SPECIFIER_DATA, self::ITEM_SPECIFIER_TOTALS]
ITEM_SPECIFIER_THIS_ROW
private
mixed
ITEM_SPECIFIER_THIS_ROW
= '#This Row'
ITEM_SPECIFIER_TOTALS
private
mixed
ITEM_SPECIFIER_TOTALS
= '#Totals'
OPEN_BRACE
private
mixed
OPEN_BRACE
= '['
TABLE_REFERENCE
private
mixed
TABLE_REFERENCE
= '/([\p{L}_\\][\p{L}\p{N}\._]+)?(\[(?:[^\]\[]+|(?R))*+\])/miu'
$columns
private
array<string|int, mixed>
$columns
$firstDataRow
private
int
$firstDataRow
private
int|null
$headersRow
$lastDataRow
private
int
$lastDataRow
$reference
private
string
$reference
$table
private
Table
$table
$tableName
private
string
$tableName
$totalsRow
private
int|null
$totalsRow
$value
private
string
$value
__construct()
public
__construct(string $structuredReference) : mixed
Parameters
-
$structuredReference
: string
-
Return values
mixed
—
fromParser()
public
static fromParser(string $formula, int $index, array<string|int, mixed> $matches) : self
Parameters
-
$formula
: string
-
-
$index
: int
-
-
$matches
: array<string|int, mixed>
-
Return values
self
—
parse()
public
parse(Cell $cell) : string
Parameters
-
$cell
: Cell
-
-
throws
-
Exception
-
throws
-
Exception
Return values
string
—
value()
public
value() : string
Return values
string
—
adjustRowReference()
private
adjustRowReference(string $columnName, string $reference, Cell $cell, string $columnId) : string
Parameters
-
$columnName
: string
-
-
$reference
: string
-
-
$cell
: Cell
-
-
$columnId
: string
-
Return values
string
—
fullData()
private
fullData(int $startRow, int $endRow) : string
Parameters
-
$startRow
: int
-
-
$endRow
: int
-
Return values
string
—
getColumnReference()
private
getColumnReference() : string
-
throws
-
Exception
-
throws
-
Exception
Return values
string
—
getColumns()
private
getColumns(Cell $cell, array<string|int, mixed> $tableRange) : array<string|int, mixed>
Parameters
-
$cell
: Cell
-
-
$tableRange
: array<string|int, mixed>
-
Return values
array<string|int, mixed>
—
getColumnsForColumnReference()
private
getColumnsForColumnReference(string $reference, int $startRow, int $endRow) : string
Parameters
-
$reference
: string
-
-
$startRow
: int
-
-
$endRow
: int
-
Return values
string
—
getMaximumRow()
private
getMaximumRow(string $reference) : int
Parameters
-
$reference
: string
-
Return values
int
—
getMinimumRow()
private
getMinimumRow(string $reference) : int
Parameters
-
$reference
: string
-
Return values
int
—
getRowReference()
private
getRowReference(Cell $cell) : string
Parameters
-
$cell
: Cell
-
Return values
string
—
getRowsForColumnReference()
private
getRowsForColumnReference(string &$reference, int $startRow, int $endRow) : array<int, int>
Parameters
-
$reference
: string
-
-
$startRow
: int
-
-
$endRow
: int
-
Return values
array<int, int>
—
getTableByName()
private
getTableByName(Cell $cell) : Table
Parameters
-
$cell
: Cell
-
-
throws
-
Exception
-
throws
-
Exception
Return values
Table
—
getTableForCell()
private
getTableForCell(Cell $cell) : Table
Parameters
-
$cell
: Cell
-
-
throws
-
Exception
-
throws
-
Exception
Return values
Table
—
getTableStructure()
private
getTableStructure(Cell $cell) : void
Parameters
-
$cell
: Cell
-
-
throws
-
Exception
-
throws
-
Exception
Return values
void
—
isRowReference()
private
isRowReference() : bool
Return values
bool
—
validateParsedReference()
private
validateParsedReference(string $reference) : string
Parameters
-
$reference
: string
-
-
throws
-
Exception
-
throws
-
Exception
Return values
string
—