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	Database
class	DateTime
class	Engineering
class	Exception
class	ExceptionHandler
class	Financial
class	FormulaParser
class	FormulaToken
class	Functions
class	Logical
class	LookupRef
class	MathTrig
class	Statistical
class	TextData
class	Web

Functions
static	evaluateArrayArguments (callable $method,... $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,... $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,... $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,... $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, ... )

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().

Parameters

mixed

...$arguments

evaluateArrayArgumentsIgnore()

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

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.

Parameters

mixed

...$arguments

evaluateArrayArgumentsSubset()

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

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.

Parameters

mixed

...$arguments

evaluateArrayArgumentsSubsetFrom()

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

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.

Parameters

mixed

...$arguments

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 ArrayArgumentHelper $arrayArgumentHelper