Collaboration diagram for PHPExcel_Calculation_Functions:

Static Public Member Functions
static	setCompatibilityMode ($compatibilityMode)

static	getCompatibilityMode ()

static	setReturnDateType ($returnDateType)

static	getReturnDateType ()

static	DUMMY ()

static	DIV0 ()

static	NA ()

static	NaN ()

static	NAME ()

static	REF ()

static	NULL ()

static	VALUE ()

static	isMatrixValue ($idx)

static	isValue ($idx)

static	isCellValue ($idx)

static	_ifCondition ($condition)

static	ERROR_TYPE ($value='')
	ERROR_TYPE. More...

static	IS_BLANK ($value=NULL)
	IS_BLANK. More...

static	IS_ERR ($value='')
	IS_ERR. More...

static	IS_ERROR ($value='')
	IS_ERROR. More...

static	IS_NA ($value='')
	IS_NA. More...

static	IS_EVEN ($value=NULL)
	IS_EVEN. More...

static	IS_ODD ($value=NULL)
	IS_ODD. More...

static	IS_NUMBER ($value=NULL)
	IS_NUMBER. More...

static	IS_LOGICAL ($value=NULL)
	IS_LOGICAL. More...

static	IS_TEXT ($value=NULL)
	IS_TEXT. More...

static	IS_NONTEXT ($value=NULL)
	IS_NONTEXT. More...

static	VERSION ()
	VERSION. More...

static	N ($value=NULL)
	N. More...

static	TYPE ($value=NULL)
	TYPE. More...

static	flattenArray ($array)
	Convert a multi-dimensional array to a simple 1-dimensional array. More...

static	flattenArrayIndexed ($array)
	Convert a multi-dimensional array to a simple 1-dimensional array, but retain an element of indexing. More...

static	flattenSingleValue ($value='')
	Convert an array to a single scalar value by extracting the first element. More...

Data Fields
const	COMPATIBILITY_EXCEL = 'Excel'
	constants More...

const	COMPATIBILITY_GNUMERIC = 'Gnumeric'

const	COMPATIBILITY_OPENOFFICE = 'OpenOfficeCalc'

const	RETURNDATE_PHP_NUMERIC = 'P'

const	RETURNDATE_PHP_OBJECT = 'O'

const	RETURNDATE_EXCEL = 'E'

Static Protected Attributes
static	$compatibilityMode = self::COMPATIBILITY_EXCEL

static	$ReturnDateType = self::RETURNDATE_EXCEL

static	$_errorCodes

Detailed Description

Definition at line 59 of file Functions.php.

Member Function Documentation

◆ _ifCondition()

static PHPExcel_Calculation_Functions::_ifCondition ( $condition )

static

Definition at line 309 of file Functions.php.

                                                        {
                $condition      = PHPExcel_Calculation_Functions::flattenSingleValue($condition);
                if (!isset($condition{0}))
                        $condition = '=""';
                if (!in_array($condition{0},array('>', '<', '='))) {
                        if (!is_numeric($condition)) { $condition = PHPExcel_Calculation::_wrapResult(strtoupper($condition)); }
                        return '='.$condition;
                } else {
                        preg_match('/([<>=]+)(.*)/',$condition,$matches);
                        list(,$operator,$operand) = $matches;
 
                        if (!is_numeric($operand)) {
                                $operand = str_replace('"', '""', $operand);
                                $operand = PHPExcel_Calculation::_wrapResult(strtoupper($operand));
                        }
 
                        return $operator.$operand;
                }
        }       //      function _ifCondition()

References PHPExcel_Calculation\_wrapResult(), and flattenSingleValue().

Referenced by PHPExcel_Calculation_Database\__filter(), PHPExcel_Calculation_Statistical\AVERAGEIF(), PHPExcel_Calculation_Statistical\COUNTIF(), PHPExcel_Calculation_Statistical\MAXIF(), PHPExcel_Calculation_Statistical\MINIF(), and PHPExcel_Calculation_MathTrig\SUMIF().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ DIV0()

static PHPExcel_Calculation_Functions::DIV0 ( )

static

Definition at line 201 of file Functions.php.

                                      {
                return self::$_errorCodes['divisionbyzero'];
        }       //      function DIV0()

Here is the caller graph for this function:

◆ DUMMY()

static PHPExcel_Calculation_Functions::DUMMY ( )

static

Definition at line 189 of file Functions.php.

                                       {
                return '#Not Yet Implemented';
        }       //      function DUMMY()

Referenced by FunctionsTest\testDUMMY().

Here is the caller graph for this function:

◆ ERROR_TYPE()

static PHPExcel_Calculation_Functions::ERROR_TYPE ( $value = '' )

static

ERROR_TYPE.

Parameters

mixed $value Value to check

Returns: boolean

Definition at line 336 of file Functions.php.

                                                       {
                $value  = self::flattenSingleValue($value);
 
                $i = 1;
                foreach(self::$_errorCodes as $errorCode) {
                        if ($value === $errorCode) {
                                return $i;
                        }
                        ++$i;
                }
                return self::NA();
        }       //      function ERROR_TYPE()

References flattenSingleValue(), and NA().

Here is the call graph for this function:

◆ flattenArray()

static PHPExcel_Calculation_Functions::flattenArray ( $array )

static

Convert a multi-dimensional array to a simple 1-dimensional array.

Parameters

array $array Array to be flattened

Returns: array Flattened array

Definition at line 598 of file Functions.php.

                                                    {
                if (!is_array($array)) {
                        return (array) $array;
                }
 
                $arrayValues = array();
                foreach ($array as $value) {
                        if (is_array($value)) {
                                foreach ($value as $val) {
                                        if (is_array($val)) {
                                                foreach ($val as $v) {
                                                        $arrayValues[] = $v;
                                                }
                                        } else {
                                                $arrayValues[] = $val;
                                        }
                                }
                        } else {
                                $arrayValues[] = $value;
                        }
                }
 
                return $arrayValues;
        }       //      function flattenArray()

Here is the caller graph for this function:

◆ flattenArrayIndexed()

static PHPExcel_Calculation_Functions::flattenArrayIndexed ( $array )

static

Convert a multi-dimensional array to a simple 1-dimensional array, but retain an element of indexing.

Parameters

array $array Array to be flattened

Returns: array Flattened array

Definition at line 630 of file Functions.php.

                                                           {
                if (!is_array($array)) {
                        return (array) $array;
                }
 
                $arrayValues = array();
                foreach ($array as $k1 => $value) {
                        if (is_array($value)) {
                                foreach ($value as $k2 => $val) {
                                        if (is_array($val)) {
                                                foreach ($val as $k3 => $v) {
                                                        $arrayValues[$k1.'.'.$k2.'.'.$k3] = $v;
                                                }
                                        } else {
                                                $arrayValues[$k1.'.'.$k2] = $val;
                                        }
                                }
                        } else {
                                $arrayValues[$k1] = $value;
                        }
                }
 
                return $arrayValues;
        }       //      function flattenArrayIndexed()

Here is the caller graph for this function:

◆ flattenSingleValue()

static PHPExcel_Calculation_Functions::flattenSingleValue ( $value = '' )

static

Convert an array to a single scalar value by extracting the first element.

Parameters

mixed $value Array or scalar value

Returns: mixed

Definition at line 662 of file Functions.php.

                                                               {
                while (is_array($value)) {
                        $value = array_pop($value);
                }
 
                return $value;
        }       //      function flattenSingleValue()

Here is the caller graph for this function:

◆ getCompatibilityMode()

static PHPExcel_Calculation_Functions::getCompatibilityMode ( )

static

Definition at line 138 of file Functions.php.

                                                      {
                return self::$compatibilityMode;
        }       //      function getCompatibilityMode()

References $compatibilityMode.

Here is the caller graph for this function:

◆ getReturnDateType()

static PHPExcel_Calculation_Functions::getReturnDateType ( )

static

Definition at line 177 of file Functions.php.

                                                   {
                return self::$ReturnDateType;
        }       //      function getReturnDateType()

References $ReturnDateType.

Here is the caller graph for this function:

◆ IS_BLANK()

static PHPExcel_Calculation_Functions::IS_BLANK ( $value = NULL )

static

IS_BLANK.

Parameters

mixed $value Value to check

Returns: boolean

Definition at line 356 of file Functions.php.

                                                       {
                if (!is_null($value)) {
                        $value  = self::flattenSingleValue($value);
                }
 
                return is_null($value);
        }       //      function IS_BLANK()

References flattenSingleValue().

Here is the call graph for this function:

◆ IS_ERR()

static PHPExcel_Calculation_Functions::IS_ERR ( $value = '' )

static

IS_ERR.

Parameters

mixed $value Value to check

Returns: boolean

Definition at line 371 of file Functions.php.

                                                   {
                $value          = self::flattenSingleValue($value);
 
                return self::IS_ERROR($value) && (!self::IS_NA($value));
        }       //      function IS_ERR()

References flattenSingleValue(), IS_ERROR(), and IS_NA().

Here is the call graph for this function:

◆ IS_ERROR()

static PHPExcel_Calculation_Functions::IS_ERROR ( $value = '' )

static

IS_ERROR.

Parameters

mixed $value Value to check

Returns: boolean

Definition at line 384 of file Functions.php.

                                                     {
                $value          = self::flattenSingleValue($value);
 
                if (!is_string($value))
                        return false;
                return in_array($value, array_values(self::$_errorCodes));
        }       //      function IS_ERROR()

References flattenSingleValue().

Referenced by PHPExcel_Calculation_Logical\IFERROR(), and IS_ERR().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ IS_EVEN()

static PHPExcel_Calculation_Functions::IS_EVEN ( $value = NULL )

static

IS_EVEN.

Parameters

mixed $value Value to check

Returns: boolean

Definition at line 412 of file Functions.php.

                                                      {
                $value = self::flattenSingleValue($value);
 
                if ($value === NULL)
                        return self::NAME();
                if ((is_bool($value)) || ((is_string($value)) && (!is_numeric($value))))
                        return self::VALUE();
                return ($value % 2 == 0);
        }       //      function IS_EVEN()

References flattenSingleValue(), NAME(), NULL(), and VALUE().

Here is the call graph for this function:

◆ IS_LOGICAL()

static PHPExcel_Calculation_Functions::IS_LOGICAL ( $value = NULL )

static

IS_LOGICAL.

Parameters

mixed $value Value to check

Returns: boolean

Definition at line 462 of file Functions.php.

                                                         {
                $value          = self::flattenSingleValue($value);
 
                return is_bool($value);
        }       //      function IS_LOGICAL()

References flattenSingleValue().

Here is the call graph for this function:

◆ IS_NA()

static PHPExcel_Calculation_Functions::IS_NA ( $value = '' )

static

IS_NA.

Parameters

mixed $value Value to check

Returns: boolean

Definition at line 399 of file Functions.php.

                                                  {
                $value          = self::flattenSingleValue($value);
 
                return ($value === self::NA());
        }       //      function IS_NA()

References flattenSingleValue().

Referenced by IS_ERR().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ IS_NONTEXT()

static PHPExcel_Calculation_Functions::IS_NONTEXT ( $value = NULL )

static

IS_NONTEXT.

Parameters

mixed $value Value to check

Returns: boolean

Definition at line 488 of file Functions.php.

                                                         {
                return !self::IS_TEXT($value);
        }       //      function IS_NONTEXT()

References IS_TEXT().

Here is the call graph for this function:

◆ IS_NUMBER()

static PHPExcel_Calculation_Functions::IS_NUMBER ( $value = NULL )

static

IS_NUMBER.

Parameters

mixed $value Value to check

Returns: boolean

Definition at line 446 of file Functions.php.

                                                        {
                $value          = self::flattenSingleValue($value);
 
                if (is_string($value)) {
                        return False;
                }
                return is_numeric($value);
        }       //      function IS_NUMBER()

References flattenSingleValue().

Here is the call graph for this function:

◆ IS_ODD()

static PHPExcel_Calculation_Functions::IS_ODD ( $value = NULL )

static

IS_ODD.

Parameters

mixed $value Value to check

Returns: boolean

Definition at line 429 of file Functions.php.

                                                     {
                $value = self::flattenSingleValue($value);
 
                if ($value === NULL)
                        return self::NAME();
                if ((is_bool($value)) || ((is_string($value)) && (!is_numeric($value))))
                        return self::VALUE();
                return (abs($value) % 2 == 1);
        }       //      function IS_ODD()

References flattenSingleValue(), NAME(), NULL(), and VALUE().

Here is the call graph for this function:

◆ IS_TEXT()

static PHPExcel_Calculation_Functions::IS_TEXT ( $value = NULL )

static

IS_TEXT.

Parameters

mixed $value Value to check

Returns: boolean

Definition at line 475 of file Functions.php.

                                                      {
                $value          = self::flattenSingleValue($value);
 
                return (is_string($value) && !self::IS_ERROR($value));
        }       //      function IS_TEXT()

References flattenSingleValue().

Referenced by IS_NONTEXT().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ isCellValue()

static PHPExcel_Calculation_Functions::isCellValue ( $idx )

static

Definition at line 304 of file Functions.php.

                                                 {
                return (substr_count($idx,'.') > 1);
        }

Referenced by PHPExcel_Calculation_Statistical\AVEDEV(), PHPExcel_Calculation_Statistical\AVERAGE(), PHPExcel_Calculation_Statistical\COUNT(), PHPExcel_Calculation_Statistical\DEVSQ(), PHPExcel_Calculation_Statistical\STDEV(), and PHPExcel_Calculation_Statistical\STDEVP().

Here is the caller graph for this function:

◆ isMatrixValue()

static PHPExcel_Calculation_Functions::isMatrixValue ( $idx )

static

Definition at line 294 of file Functions.php.

                                                   {
                return ((substr_count($idx,'.') <= 1) || (preg_match('/\.[A-Z]/',$idx) > 0));
        }

Referenced by PHPExcel_Calculation_Statistical\AVERAGEA(), PHPExcel_Calculation_Statistical\KURT(), PHPExcel_Calculation_Statistical\SKEW(), PHPExcel_Calculation_Statistical\STDEVA(), PHPExcel_Calculation_Statistical\STDEVPA(), PHPExcel_Calculation_Statistical\VARA(), and PHPExcel_Calculation_Statistical\VARPA().

Here is the caller graph for this function:

◆ isValue()

static PHPExcel_Calculation_Functions::isValue ( $idx )

static

Definition at line 299 of file Functions.php.

                                             {
                return (substr_count($idx,'.') == 0);
        }

Referenced by PHPExcel_Calculation_Statistical\VARA(), and PHPExcel_Calculation_Statistical\VARPA().

Here is the caller graph for this function:

◆ N()

static PHPExcel_Calculation_Functions::N ( $value = NULL )

static

N.

Returns a value converted to a number

Parameters

value The value you want converted

Returns: number N converts values listed in the following table If value is or refers to N returns A number That number A date The serial number of that date TRUE 1 FALSE 0 An error value The error value Anything else 0

Definition at line 518 of file Functions.php.

                                                {
                while (is_array($value)) {
                        $value = array_shift($value);
                }
 
                switch (gettype($value)) {
                        case 'double'   :
                        case 'float'    :
                        case 'integer'  :
                                return $value;
                                break;
                        case 'boolean'  :
                                return (integer) $value;
                                break;
                        case 'string'   :
                                //      Errors
                                if ((strlen($value) > 0) && ($value{0} == '#')) {
                                        return $value;
                                }
                                break;
                }
                return 0;
        }       //      function N()

◆ NA()

static PHPExcel_Calculation_Functions::NA ( )

static

Definition at line 219 of file Functions.php.

                                    {
                return self::$_errorCodes['na'];
        }       //      function NA()

Here is the caller graph for this function:

◆ NAME()

static PHPExcel_Calculation_Functions::NAME ( )

static

Definition at line 247 of file Functions.php.

                                      {
                return self::$_errorCodes['name'];
        }       //      function NAME()

Referenced by IS_EVEN(), IS_ODD(), and FunctionsTest\testNAME().

Here is the caller graph for this function:

◆ NaN()

static PHPExcel_Calculation_Functions::NaN ( )

static

Definition at line 233 of file Functions.php.

                                     {
                return self::$_errorCodes['num'];
        }       //      function NaN()

Here is the caller graph for this function:

◆ NULL()

static PHPExcel_Calculation_Functions::NULL ( )

static

Definition at line 275 of file Functions.php.

                                      {
                return self::$_errorCodes['null'];
        }       //      function NULL()

Referenced by PHPExcel_Calculation_Statistical\_inverse_ncdf(), IS_EVEN(), IS_ODD(), FunctionsTest\testNULL(), and TYPE().

Here is the caller graph for this function:

◆ REF()

static PHPExcel_Calculation_Functions::REF ( )

static

Definition at line 261 of file Functions.php.

                                     {
                return self::$_errorCodes['reference'];
        }       //      function REF()

Referenced by PHPExcel_Calculation\_processTokenStack(), PHPExcel_Calculation\extractNamedRange(), PHPExcel_Calculation_LookupRef\HLOOKUP(), PHPExcel_Calculation_LookupRef\HYPERLINK(), PHPExcel_Calculation_LookupRef\INDEX(), PHPExcel_Calculation_LookupRef\INDIRECT(), PHPExcel_Calculation_LookupRef\OFFSET(), FunctionsTest\testREF(), and PHPExcel_Calculation_LookupRef\VLOOKUP().

Here is the caller graph for this function:

◆ setCompatibilityMode()

static PHPExcel_Calculation_Functions::setCompatibilityMode ( $compatibilityMode )

static

Definition at line 116 of file Functions.php.

                                                                        {
                if (($compatibilityMode == self::COMPATIBILITY_EXCEL) ||
                        ($compatibilityMode == self::COMPATIBILITY_GNUMERIC) ||
                        ($compatibilityMode == self::COMPATIBILITY_OPENOFFICE)) {
                        self::$compatibilityMode = $compatibilityMode;
                        return True;
                }
                return False;
        }       //      function setCompatibilityMode()

References $compatibilityMode.

Referenced by DateTimeTest\setUp(), EngineeringTest\setUp(), FinancialTest\setUp(), FunctionsTest\setUp(), LogicalTest\setUp(), LookupRefTest\setUp(), MathTrigTest\setUp(), TextDataTest\setUp(), CalculationTest\setUp(), and CalculationTest\testBinaryComparisonOperation().

Here is the caller graph for this function:

◆ setReturnDateType()

static PHPExcel_Calculation_Functions::setReturnDateType ( $returnDateType )

static

Definition at line 155 of file Functions.php.

                                                                  {
                if (($returnDateType == self::RETURNDATE_PHP_NUMERIC) ||
                        ($returnDateType == self::RETURNDATE_PHP_OBJECT) ||
                        ($returnDateType == self::RETURNDATE_EXCEL)) {
                        self::$ReturnDateType = $returnDateType;
                        return True;
                }
                return False;
        }       //      function setReturnDateType()

Here is the caller graph for this function:

◆ TYPE()

static PHPExcel_Calculation_Functions::TYPE ( $value = NULL )

static

TYPE.

Returns a number that identifies the type of a value

Parameters

value The value you want tested

Returns: number N converts values listed in the following table If value is or refers to N returns A number 1 Text 2 Logical Value 4 An error value 16 Array or Matrix 64

Definition at line 557 of file Functions.php.

                                                   {
                $value  = self::flattenArrayIndexed($value);
                if (is_array($value) && (count($value) > 1)) {
                        $a = array_keys($value);
                        $a = array_pop($a);
                        //      Range of cells is an error
                        if (self::isCellValue($a)) {
                                return 16;
                        //      Test for Matrix
                        } elseif (self::isMatrixValue($a)) {
                                return 64;
                        }
                } elseif(empty($value)) {
                        //      Empty Cell
                        return 1;
                }
                $value  = self::flattenSingleValue($value);
 
                if (($value === NULL) || (is_float($value)) || (is_int($value))) {
                                return 1;
                } elseif(is_bool($value)) {
                                return 4;
                } elseif(is_array($value)) {
                                return 64;
                } elseif(is_string($value)) {
                        //      Errors
                        if ((strlen($value) > 0) && ($value{0} == '#')) {
                                return 16;
                        }
                        return 2;
                }
                return 0;
        }       //      function TYPE()

References flattenArrayIndexed(), flattenSingleValue(), and NULL().

Here is the call graph for this function:

◆ VALUE()

static PHPExcel_Calculation_Functions::VALUE ( )

static

Definition at line 289 of file Functions.php.

                                       {
                return self::$_errorCodes['value'];
        }       //      function VALUE()

Here is the caller graph for this function:

◆ VERSION()

static PHPExcel_Calculation_Functions::VERSION ( )

static

VERSION.

Returns: string Version information

Definition at line 498 of file Functions.php.

                                         {
                return 'PHPExcel 1.8.1, 2015-04-30';
        }       //      function VERSION()

Field Documentation

◆ $_errorCodes

PHPExcel_Calculation_Functions::$_errorCodes

staticprotected

Initial value:

= array( 'null'                         => '#NULL!',
                                                                                         'divisionbyzero'       => '#DIV/0!',
                                                                                         'value'                        => '#VALUE!',
                                                                                         'reference'            => '#REF!',
                                                                                         'name'                         => '#NAME?',
                                                                                         'num'                          => '#NUM!',
                                                                                         'na'                           => '#N/A',
                                                                                         'gettingdata'          => '#GETTING_DATA'
                                                                                   )

Definition at line 93 of file Functions.php.

◆ $compatibilityMode

PHPExcel_Calculation_Functions::$compatibilityMode = self::COMPATIBILITY_EXCEL

staticprotected

Definition at line 77 of file Functions.php.

Referenced by getCompatibilityMode(), and setCompatibilityMode().

◆ $ReturnDateType

PHPExcel_Calculation_Functions::$ReturnDateType = self::RETURNDATE_EXCEL

staticprotected

Definition at line 85 of file Functions.php.

Referenced by getReturnDateType().

◆ COMPATIBILITY_EXCEL

const PHPExcel_Calculation_Functions::COMPATIBILITY_EXCEL = 'Excel'

constants

Definition at line 62 of file Functions.php.

Referenced by PHPExcel_Calculation_DateTime\DAYOFWEEK(), DateTimeTest\setUp(), EngineeringTest\setUp(), FinancialTest\setUp(), FunctionsTest\setUp(), LogicalTest\setUp(), LookupRefTest\setUp(), MathTrigTest\setUp(), TextDataTest\setUp(), CalculationTest\setUp(), and CalculationTest\testBinaryComparisonOperation().

◆ COMPATIBILITY_GNUMERIC

const PHPExcel_Calculation_Functions::COMPATIBILITY_GNUMERIC = 'Gnumeric'

Definition at line 63 of file Functions.php.

◆ COMPATIBILITY_OPENOFFICE

const PHPExcel_Calculation_Functions::COMPATIBILITY_OPENOFFICE = 'OpenOfficeCalc'

Definition at line 64 of file Functions.php.

◆ RETURNDATE_EXCEL

const PHPExcel_Calculation_Functions::RETURNDATE_EXCEL = 'E'

Definition at line 68 of file Functions.php.

◆ RETURNDATE_PHP_NUMERIC

const PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC = 'P'

Definition at line 66 of file Functions.php.

Referenced by PHPExcel_Worksheet_AutoFilter\_dynamicFilterDateRange(), PHPExcel_Calculation_DateTime\DATE(), PHPExcel_Calculation_DateTime\DATENOW(), PHPExcel_Calculation_DateTime\DATETIMENOW(), PHPExcel_Calculation_DateTime\DATEVALUE(), PHPExcel_Calculation_DateTime\EDATE(), PHPExcel_Calculation_DateTime\EOMONTH(), DateTimeTest\testDATEtoPHP(), DateTimeTest\testDATEVALUEtoPHP(), DateTimeTest\testEDATEtoPHP(), DateTimeTest\testEOMONTHtoPHP(), DateTimeTest\testTIMEtoPHP(), DateTimeTest\testTIMEVALUEtoPHP(), PHPExcel_Calculation_DateTime\TIME(), PHPExcel_Calculation_DateTime\TIMEVALUE(), and PHPExcel_Calculation_DateTime\WORKDAY().

◆ RETURNDATE_PHP_OBJECT

const PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT = 'O'

Definition at line 67 of file Functions.php.

The documentation for this class was generated from the following file:

libs/composer/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Functions.php

Static Public Member Functions

Data Fields

Static Protected Attributes

Detailed Description

Member Function Documentation

◆ _ifCondition()

◆ DIV0()

◆ DUMMY()

◆ ERROR_TYPE()

◆ flattenArray()

◆ flattenArrayIndexed()

◆ flattenSingleValue()

◆ getCompatibilityMode()

◆ getReturnDateType()

◆ IS_BLANK()

◆ IS_ERR()

◆ IS_ERROR()

◆ IS_EVEN()

◆ IS_LOGICAL()

◆ IS_NA()

◆ IS_NONTEXT()

◆ IS_NUMBER()

◆ IS_ODD()

◆ IS_TEXT()

◆ isCellValue()

◆ isMatrixValue()

◆ isValue()

◆ N()

◆ NA()

◆ NAME()

◆ NaN()

◆ NULL()

◆ REF()

◆ setCompatibilityMode()

◆ setReturnDateType()

◆ TYPE()

◆ VALUE()

◆ VERSION()

Field Documentation

◆ $_errorCodes

◆ $compatibilityMode

◆ $ReturnDateType

◆ COMPATIBILITY_EXCEL

◆ COMPATIBILITY_GNUMERIC

◆ COMPATIBILITY_OPENOFFICE

◆ RETURNDATE_EXCEL

◆ RETURNDATE_PHP_NUMERIC

◆ RETURNDATE_PHP_OBJECT