PhpOffice\PhpSpreadsheet\Calculation Namespace Reference

  More...

Namespaces
namespace	Database
namespace	DateTimeExcel
namespace	Engine
namespace	Engineering
namespace	Financial
namespace	Information
namespace	Internal
namespace	Logical
namespace	LookupRef
namespace	MathTrig
namespace	Statistical
namespace	TextData
namespace	Token
namespace	Web

Classes
class	BinaryComparison
class	Calculation
class	Category
class	Exception
class	ExceptionHandler
class	FormulaParser
class	FormulaToken
class	Functions

Functions
static	evaluateArrayArguments (callable $method, mixed ... $arguments)
	Handles array argument processing when the function accepts multiple arguments, and any of them can be an array argument.
static	evaluateArrayArgumentsIgnore (callable $method, int $ignore, mixed ... $arguments)
	Handles array argument processing when the function accepts multiple arguments, and any of them can be an array argument except for the one specified by ignore.
static	evaluateArrayArgumentsSubset (callable $method, int $limit, mixed ... $arguments)
	Handles array argument processing when the function accepts multiple arguments, but only the first few (up to limit) can be an array arguments.
static	evaluateArrayArgumentsSubsetFrom (callable $method, int $start, mixed ... $arguments)
	Handles array argument processing when the function accepts multiple arguments, but only the last few (from start) can be an array arguments.
static	evaluateSingleArgumentArray (callable $method, array $values)
	Handles array argument processing when the function accepts a single argument that can be an array argument.

Variables
trait	ArrayEnabled

Detailed Description

 

Function Documentation

evaluateArrayArguments()

static PhpOffice\PhpSpreadsheet\Calculation\evaluateArrayArguments ( callable $method, mixed ... $arguments )

staticprotected

Handles array argument processing when the function accepts multiple arguments, and any of them can be an array argument.

Example use for: ROUND() or DATE().

evaluateArrayArgumentsIgnore()

static PhpOffice\PhpSpreadsheet\Calculation\evaluateArrayArgumentsIgnore ( callable $method, int $ignore, mixed ... $arguments )

staticprotected

Handles array argument processing when the function accepts multiple arguments, and any of them can be an array argument except for the one specified by ignore.

Example use for: HLOOKUP() and VLOOKUP(), where argument 1 is a matrix that needs to be treated as a database rather than as an array argument.

evaluateArrayArgumentsSubset()

static PhpOffice\PhpSpreadsheet\Calculation\evaluateArrayArgumentsSubset ( callable $method, int $limit, mixed ... $arguments )

staticprotected

Handles array argument processing when the function accepts multiple arguments, but only the first few (up to limit) can be an array arguments.

Example use for: NETWORKDAYS() or CONCATENATE(), where the last argument is a matrix (or a series of values) that need to be treated as a such rather than as an array arguments.

evaluateArrayArgumentsSubsetFrom()

static PhpOffice\PhpSpreadsheet\Calculation\evaluateArrayArgumentsSubsetFrom ( callable $method, int $start, mixed ... $arguments )

staticprotected

Handles array argument processing when the function accepts multiple arguments, but only the last few (from start) can be an array arguments.

Example use for: Z.TEST() or INDEX(), where the first argument 1 is a matrix that needs to be treated as a dataset rather than as an array argument.

evaluateSingleArgumentArray()

static PhpOffice\PhpSpreadsheet\Calculation\evaluateSingleArgumentArray ( callable $method, array $values )

staticprotected

Handles array argument processing when the function accepts a single argument that can be an array argument.

Example use for: DAYOFMONTH() or FACT().

Variable Documentation

ArrayEnabled

trait PhpOffice::PhpSpreadsheet::Calculation\ArrayEnabled

Initial value:

{
    private static bool $initializationNeeded = true