Documentation

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


        
On this page

Search results