Indirect
in package
Table of Contents
Methods
- INDIRECT() : array<string|int, mixed>|string
- INDIRECT.
Methods
INDIRECT()
INDIRECT.
public
static INDIRECT(array<string|int, mixed>|string $cellAddress, mixed $a1fmt, Cell $cell) : array<string|int, mixed>|string
Returns the reference specified by a text string. References are immediately evaluated to display their contents.
Excel Function: =INDIRECT(cellAddress, bool) where the bool argument is optional
Parameters
- $cellAddress : array<string|int, mixed>|string
-
$cellAddress The cell address of the current cell (containing this formula)
- $a1fmt : mixed
-
Expect bool Helpers::CELLADDRESS_USE_A1 or CELLADDRESS_USE_R1C1, but can be provided as numeric which is cast to bool
- $cell : Cell
-
The current cell (containing this formula)
Return values
array<string|int, mixed>|string —An array containing a cell or range of cells, or a string on error