ILIAS  release_5-3 Revision v5.3.23-19-g915713cf615
PHPExcel_Calculation_Functions Class Reference
+ 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.

References PHPExcel_Calculation\_wrapResult(), array, 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().

309  {
311  if (!isset($condition{0}))
312  $condition = '=""';
313  if (!in_array($condition{0},array('>', '<', '='))) {
314  if (!is_numeric($condition)) { $condition = PHPExcel_Calculation::_wrapResult(strtoupper($condition)); }
315  return '='.$condition;
316  } else {
317  preg_match('/([<>=]+)(.*)/',$condition,$matches);
318  list(,$operator,$operand) = $matches;
319 
320  if (!is_numeric($operand)) {
321  $operand = str_replace('"', '""', $operand);
322  $operand = PHPExcel_Calculation::_wrapResult(strtoupper($operand));
323  }
324 
325  return $operator.$operand;
326  }
327  } // function _ifCondition()
static flattenSingleValue($value='')
Convert an array to a single scalar value by extracting the first element.
Definition: Functions.php:662
static _wrapResult($value)
Wrap string values in quotes.
Create styles array
The data for the language used.
+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ DIV0()

◆ DUMMY()

static PHPExcel_Calculation_Functions::DUMMY ( )
static

Definition at line 189 of file Functions.php.

Referenced by FunctionsTest\testDUMMY().

189  {
190  return '#Not Yet Implemented';
191  } // function DUMMY()
+ Here is the caller graph for this function:

◆ ERROR_TYPE()

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

ERROR_TYPE.

Parameters
mixed$valueValue to check
Returns
boolean

Definition at line 336 of file Functions.php.

References $errorCode, and $i.

336  {
337  $value = self::flattenSingleValue($value);
338 
339  $i = 1;
340  foreach(self::$_errorCodes as $errorCode) {
341  if ($value === $errorCode) {
342  return $i;
343  }
344  ++$i;
345  }
346  return self::NA();
347  } // function ERROR_TYPE()
$errorCode
$i
Definition: disco.tpl.php:19

◆ flattenArray()

static PHPExcel_Calculation_Functions::flattenArray (   $array)
static

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

Parameters
array$arrayArray to be flattened
Returns
array Flattened array

Definition at line 598 of file Functions.php.

References array.

Referenced by PHPExcel_Worksheet_AutoFilter\_calculateTopTenValue(), PHPExcel_Calculation_Statistical\_checkTrendArrays(), PHPExcel_Calculation\_processTokenStack(), PHPExcel_Calculation\_showTypeDetails(), PHPExcel_Calculation\_showValue(), PHPExcel_Calculation_Statistical\AVERAGEIF(), PHPExcel_Calculation\calculateCellValue(), PHPExcel_Calculation_LookupRef\CHOOSE(), PHPExcel_Calculation_TextData\CONCATENATE(), PHPExcel_Calculation_Statistical\COUNTA(), PHPExcel_Calculation_Statistical\COUNTBLANK(), PHPExcel_Calculation_Statistical\COUNTIF(), PHPExcel_Calculation_Financial\FVSCHEDULE(), PHPExcel_Calculation_MathTrig\GCD(), PHPExcel_Calculation_Statistical\GEOMEAN(), PHPExcel_Calculation_Statistical\GROWTH(), PHPExcel_Calculation_Statistical\HARMEAN(), PHPExcel_Calculation_Engineering\IMPRODUCT(), PHPExcel_Calculation_Engineering\IMSUM(), PHPExcel_Calculation_Financial\IRR(), PHPExcel_Calculation_Financial\ISPMT(), PHPExcel_Calculation_Statistical\LARGE(), PHPExcel_Calculation_MathTrig\LCM(), PHPExcel_Calculation_Statistical\LINEST(), PHPExcel_Calculation_Statistical\LOGEST(), PHPExcel_Calculation_Logical\LOGICAL_AND(), PHPExcel_Calculation_Logical\LOGICAL_OR(), PHPExcel_Calculation_LookupRef\MATCH(), PHPExcel_Calculation_Statistical\MAX(), PHPExcel_Calculation_Statistical\MAXA(), PHPExcel_Calculation_Statistical\MAXIF(), PHPExcel_Calculation_Statistical\MEDIAN(), PHPExcel_Calculation_Statistical\MIN(), PHPExcel_Calculation_Statistical\MINA(), PHPExcel_Calculation_Statistical\MINIF(), PHPExcel_Calculation_Financial\MIRR(), PHPExcel_Calculation_Statistical\MODE(), PHPExcel_Calculation_MathTrig\MULTINOMIAL(), PHPExcel_Calculation_DateTime\NETWORKDAYS(), PHPExcel_Calculation_Financial\NPV(), PHPExcel_Calculation_Statistical\PERCENTILE(), PHPExcel_Calculation_Statistical\PERCENTRANK(), PHPExcel_Calculation_MathTrig\PRODUCT(), PHPExcel_Calculation_Statistical\QUARTILE(), PHPExcel_Calculation_MathTrig\QUOTIENT(), PHPExcel_Calculation_Statistical\RANK(), PHPExcel_Chart_DataSeriesValues\refresh(), PHPExcel_Calculation_MathTrig\SERIESSUM(), PHPExcel_Chart_DataSeriesValues\setDataValues(), PHPExcel_Calculation_Statistical\SMALL(), PHPExcel_Calculation_MathTrig\SUBTOTAL(), PHPExcel_Calculation_MathTrig\SUM(), PHPExcel_Calculation_MathTrig\SUMIF(), PHPExcel_Calculation_MathTrig\SUMPRODUCT(), PHPExcel_Calculation_MathTrig\SUMSQ(), PHPExcel_Calculation_MathTrig\SUMX2MY2(), PHPExcel_Calculation_MathTrig\SUMX2PY2(), PHPExcel_Calculation_MathTrig\SUMXMY2(), PHPExcel_Calculation_Statistical\TREND(), PHPExcel_Calculation_Statistical\TRIMMEAN(), PHPExcel_Calculation_Statistical\VARFunc(), PHPExcel_Calculation_Statistical\VARP(), PHPExcel_Calculation_DateTime\WORKDAY(), PHPExcel_Calculation_Financial\XIRR(), and PHPExcel_Calculation_Financial\XNPV().

598  {
599  if (!is_array($array)) {
600  return (array) $array;
601  }
602 
603  $arrayValues = array();
604  foreach ($array as $value) {
605  if (is_array($value)) {
606  foreach ($value as $val) {
607  if (is_array($val)) {
608  foreach ($val as $v) {
609  $arrayValues[] = $v;
610  }
611  } else {
612  $arrayValues[] = $val;
613  }
614  }
615  } else {
616  $arrayValues[] = $value;
617  }
618  }
619 
620  return $arrayValues;
621  } // function flattenArray()
Create styles array
The data for the language used.
+ 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$arrayArray to be flattened
Returns
array Flattened array

Definition at line 630 of file Functions.php.

References array.

Referenced by PHPExcel_Calculation_Statistical\AVEDEV(), PHPExcel_Calculation_Statistical\AVERAGE(), PHPExcel_Calculation_Statistical\AVERAGEA(), PHPExcel_Calculation_Statistical\COUNT(), PHPExcel_Calculation_Statistical\DEVSQ(), PHPExcel_Calculation_Statistical\KURT(), PHPExcel_Calculation_Statistical\SKEW(), PHPExcel_Calculation_Statistical\STDEV(), PHPExcel_Calculation_Statistical\STDEVA(), PHPExcel_Calculation_Statistical\STDEVP(), PHPExcel_Calculation_Statistical\STDEVPA(), PHPExcel_Calculation_Statistical\VARA(), PHPExcel_Calculation_Statistical\VARPA(), and PHPExcel_Calculation_Statistical\ZTEST().

630  {
631  if (!is_array($array)) {
632  return (array) $array;
633  }
634 
635  $arrayValues = array();
636  foreach ($array as $k1 => $value) {
637  if (is_array($value)) {
638  foreach ($value as $k2 => $val) {
639  if (is_array($val)) {
640  foreach ($val as $k3 => $v) {
641  $arrayValues[$k1.'.'.$k2.'.'.$k3] = $v;
642  }
643  } else {
644  $arrayValues[$k1.'.'.$k2] = $val;
645  }
646  }
647  } else {
648  $arrayValues[$k1] = $value;
649  }
650  }
651 
652  return $arrayValues;
653  } // function flattenArrayIndexed()
Create styles array
The data for the language used.
+ 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$valueArray or scalar value
Returns
mixed

Definition at line 662 of file Functions.php.

References $key, $r, $ret, $s, $x, and array.

Referenced by PHPExcel_Calculation_Database\__fieldExtract(), _ifCondition(), PHPExcel_Calculation\_processTokenStack(), PHPExcel_Calculation\_showValue(), PHPExcel_Calculation_Financial\ACCRINT(), PHPExcel_Calculation_Financial\ACCRINTM(), PHPExcel_Calculation_Financial\AMORDEGRC(), PHPExcel_Calculation_Financial\AMORLINC(), PHPExcel_Calculation_TextData\ASCIICODE(), PHPExcel_Calculation_MathTrig\ATAN2(), PHPExcel_Calculation_Engineering\BESSELI(), PHPExcel_Calculation_Engineering\BESSELJ(), PHPExcel_Calculation_Engineering\BESSELK(), PHPExcel_Calculation_Engineering\BESSELY(), PHPExcel_Calculation_Statistical\BETADIST(), PHPExcel_Calculation_Statistical\BETAINV(), PHPExcel_Calculation_Statistical\BINOMDIST(), PHPExcel_Calculation_Engineering\BINTODEC(), PHPExcel_Calculation_Engineering\BINTOHEX(), PHPExcel_Calculation_Engineering\BINTOOCT(), PHPExcel_Calculation_MathTrig\CEILING(), PHPExcel_Calculation_LookupRef\CELL_ADDRESS(), PHPExcel_Calculation_TextData\CHARACTER(), PHPExcel_Calculation_Statistical\CHIDIST(), PHPExcel_Calculation_Statistical\CHIINV(), PHPExcel_Calculation_MathTrig\COMBIN(), PHPExcel_Calculation_Engineering\COMPLEX(), PHPExcel_Calculation_Statistical\CONFIDENCE(), PHPExcel_Calculation_Engineering\CONVERTUOM(), PHPExcel_Calculation_Financial\COUPDAYBS(), PHPExcel_Calculation_Financial\COUPDAYS(), PHPExcel_Calculation_Financial\COUPDAYSNC(), PHPExcel_Calculation_Financial\COUPNCD(), PHPExcel_Calculation_Financial\COUPNUM(), PHPExcel_Calculation_Financial\COUPPCD(), PHPExcel_Calculation_Statistical\CRITBINOM(), PHPExcel_Calculation_Financial\CUMIPMT(), PHPExcel_Calculation_Financial\CUMPRINC(), PHPExcel_Calculation_DateTime\DATE(), PHPExcel_Calculation_DateTime\DATEDIF(), PHPExcel_Calculation_DateTime\DATEVALUE(), PHPExcel_Calculation_DateTime\DAYOFMONTH(), PHPExcel_Calculation_DateTime\DAYOFWEEK(), PHPExcel_Calculation_DateTime\DAYS360(), PHPExcel_Calculation_Financial\DB(), PHPExcel_Calculation_Financial\DDB(), PHPExcel_Calculation_Engineering\DECTOBIN(), PHPExcel_Calculation_Engineering\DECTOHEX(), PHPExcel_Calculation_Engineering\DECTOOCT(), PHPExcel_Calculation_Engineering\DELTA(), PHPExcel_Calculation_Financial\DISC(), PHPExcel_Calculation_TextData\DOLLAR(), PHPExcel_Calculation_Financial\DOLLARDE(), PHPExcel_Calculation_Financial\DOLLARFR(), PHPExcel_Calculation_DateTime\EDATE(), PHPExcel_Calculation_Financial\EFFECT(), PHPExcel_Calculation_DateTime\EOMONTH(), PHPExcel_Calculation_Engineering\ERF(), PHPExcel_Calculation_Engineering\ERFC(), PHPExcel_Calculation_MathTrig\EVEN(), PHPExcel_Calculation_Statistical\EXPONDIST(), PHPExcel_Calculation_MathTrig\FACT(), PHPExcel_Calculation_MathTrig\FACTDOUBLE(), PHPExcel_Calculation_Statistical\FISHER(), PHPExcel_Calculation_Statistical\FISHERINV(), PHPExcel_Calculation_TextData\FIXEDFORMAT(), PHPExcel_Calculation_MathTrig\FLOOR(), PHPExcel_Calculation_Statistical\FORECAST(), PHPExcel_Calculation_Financial\FV(), PHPExcel_Calculation_Financial\FVSCHEDULE(), PHPExcel_Calculation_Statistical\GAMMADIST(), PHPExcel_Calculation_Statistical\GAMMAINV(), PHPExcel_Calculation_Statistical\GAMMALN(), PHPExcel_Calculation_Engineering\GESTEP(), PHPExcel_Calculation_Statistical\GROWTH(), PHPExcel_Calculation_Engineering\HEXTOBIN(), PHPExcel_Calculation_Engineering\HEXTODEC(), PHPExcel_Calculation_Engineering\HEXTOOCT(), PHPExcel_Calculation_LookupRef\HLOOKUP(), PHPExcel_Calculation_DateTime\HOUROFDAY(), PHPExcel_Calculation_LookupRef\HYPERLINK(), PHPExcel_Calculation_Statistical\HYPGEOMDIST(), PHPExcel_Calculation_Logical\IFERROR(), PHPExcel_Calculation_Engineering\IMABS(), PHPExcel_Calculation_Engineering\IMAGINARY(), PHPExcel_Calculation_Engineering\IMARGUMENT(), PHPExcel_Calculation_Engineering\IMCONJUGATE(), PHPExcel_Calculation_Engineering\IMCOS(), PHPExcel_Calculation_Engineering\IMDIV(), PHPExcel_Calculation_Engineering\IMEXP(), PHPExcel_Calculation_Engineering\IMLN(), PHPExcel_Calculation_Engineering\IMLOG10(), PHPExcel_Calculation_Engineering\IMLOG2(), PHPExcel_Calculation_Engineering\IMPOWER(), PHPExcel_Calculation_Engineering\IMREAL(), PHPExcel_Calculation_Engineering\IMSIN(), PHPExcel_Calculation_Engineering\IMSQRT(), PHPExcel_Calculation_Engineering\IMSUB(), PHPExcel_Calculation_LookupRef\INDIRECT(), PHPExcel_Calculation_MathTrig\INT(), PHPExcel_Calculation_Financial\INTRATE(), PHPExcel_Calculation_Financial\IPMT(), PHPExcel_Calculation_Financial\IRR(), PHPExcel_Calculation_TextData\LEFT(), PHPExcel_Calculation_Statistical\LINEST(), PHPExcel_Calculation_MathTrig\LOG_BASE(), PHPExcel_Calculation_Statistical\LOGEST(), PHPExcel_Calculation_Statistical\LOGINV(), PHPExcel_Calculation_Statistical\LOGNORMDIST(), PHPExcel_Calculation_LookupRef\LOOKUP(), PHPExcel_Calculation_TextData\LOWERCASE(), PHPExcel_Calculation_LookupRef\MATCH(), PHPExcel_Calculation_TextData\MID(), PHPExcel_Calculation_DateTime\MINUTEOFHOUR(), PHPExcel_Calculation_Financial\MIRR(), PHPExcel_Calculation_MathTrig\MOD(), PHPExcel_Calculation_DateTime\MONTHOFYEAR(), PHPExcel_Calculation_MathTrig\MROUND(), PHPExcel_Calculation_Statistical\NEGBINOMDIST(), PHPExcel_Calculation_DateTime\NETWORKDAYS(), PHPExcel_Calculation_Financial\NOMINAL(), PHPExcel_Calculation_Statistical\NORMDIST(), PHPExcel_Calculation_Statistical\NORMINV(), PHPExcel_Calculation_Statistical\NORMSDIST(), PHPExcel_Calculation_Logical\NOT(), PHPExcel_Calculation_Financial\NPER(), PHPExcel_Calculation_Engineering\OCTTOBIN(), PHPExcel_Calculation_Engineering\OCTTODEC(), PHPExcel_Calculation_Engineering\OCTTOHEX(), PHPExcel_Calculation_MathTrig\ODD(), PHPExcel_Calculation_LookupRef\OFFSET(), PHPExcel_Calculation_Statistical\PERCENTRANK(), PHPExcel_Calculation_Statistical\PERMUT(), PHPExcel_Calculation_Financial\PMT(), PHPExcel_Calculation_Statistical\POISSON(), PHPExcel_Calculation_MathTrig\POWER(), PHPExcel_Calculation_Financial\PPMT(), PHPExcel_Calculation_Financial\PRICE(), PHPExcel_Calculation_Financial\PRICEDISC(), PHPExcel_Calculation_Financial\PRICEMAT(), PHPExcel_Calculation_TextData\PROPERCASE(), PHPExcel_Calculation_Financial\PV(), PHPExcel_Calculation_MathTrig\RAND(), PHPExcel_Calculation_Statistical\RANK(), PHPExcel_Calculation_Financial\RATE(), PHPExcel_Calculation_Financial\RECEIVED(), PHPExcel_Calculation_TextData\REPLACE(), PHPExcel_Calculation_TextData\RETURNSTRING(), PHPExcel_Calculation_TextData\RIGHT(), PHPExcel_Calculation_MathTrig\ROMAN(), PHPExcel_Calculation_MathTrig\ROUNDDOWN(), PHPExcel_Calculation_MathTrig\ROUNDUP(), PHPExcel_Calculation_TextData\SEARCHINSENSITIVE(), PHPExcel_Calculation_TextData\SEARCHSENSITIVE(), PHPExcel_Calculation_DateTime\SECONDOFMINUTE(), PHPExcel_Calculation_MathTrig\SIGN(), PHPExcel_Calculation_Financial\SLN(), PHPExcel_Calculation_MathTrig\SQRTPI(), PHPExcel_Calculation_Statistical\STANDARDIZE(), PHPExcel_Calculation_Logical\STATEMENT_IF(), PHPExcel_Calculation_TextData\STRINGLENGTH(), PHPExcel_Calculation_TextData\SUBSTITUTE(), PHPExcel_Calculation_Financial\SYD(), PHPExcel_Calculation_Financial\TBILLEQ(), PHPExcel_Calculation_Financial\TBILLPRICE(), PHPExcel_Calculation_Financial\TBILLYIELD(), PHPExcel_Calculation_Statistical\TDIST(), PHPExcel_Calculation_TextData\TEXTFORMAT(), PHPExcel_Calculation_DateTime\TIME(), PHPExcel_Calculation_DateTime\TIMEVALUE(), PHPExcel_Calculation_Statistical\TINV(), PHPExcel_Calculation_Statistical\TREND(), PHPExcel_Calculation_TextData\TRIMNONPRINTABLE(), PHPExcel_Calculation_TextData\TRIMSPACES(), PHPExcel_Calculation_MathTrig\TRUNC(), PHPExcel_Calculation_TextData\UPPERCASE(), PHPExcel_Calculation_TextData\VALUE(), PHPExcel_Calculation_LookupRef\VLOOKUP(), PHPExcel_Calculation_DateTime\WEEKOFYEAR(), PHPExcel_Calculation_Statistical\WEIBULL(), PHPExcel_Calculation_DateTime\WORKDAY(), PHPExcel_Calculation_Financial\XIRR(), PHPExcel_Calculation_Financial\XNPV(), PHPExcel_Calculation_DateTime\YEAR(), PHPExcel_Calculation_DateTime\YEARFRAC(), PHPExcel_Calculation_Financial\YIELDDISC(), PHPExcel_Calculation_Financial\YIELDMAT(), and PHPExcel_Calculation_Statistical\ZTEST().

662  {
663  while (is_array($value)) {
664  $value = array_pop($value);
665  }
666 
667  return $value;
668  } // 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.

Referenced by PHPExcel_Calculation\_executeBinaryComparisonOperation(), PHPExcel_Calculation\_executeNumericBinaryOperation(), PHPExcel_Calculation_DateTime\_getDateValue(), PHPExcel_Calculation_Financial\_validFrequency(), PHPExcel_Calculation_TextData\ASCIICODE(), PHPExcel_Calculation_Statistical\AVEDEV(), PHPExcel_Calculation_Statistical\AVERAGE(), PHPExcel_Calculation_Engineering\BINTODEC(), PHPExcel_Calculation_Engineering\BINTOHEX(), PHPExcel_Calculation_Engineering\BINTOOCT(), PHPExcel_Calculation_MathTrig\CEILING(), PHPExcel_Calculation_Statistical\CHIDIST(), PHPExcel_Calculation_TextData\CONCATENATE(), PHPExcel_Calculation_Statistical\COUNT(), PHPExcel_Calculation_DateTime\DAYOFWEEK(), PHPExcel_Calculation_Financial\DB(), PHPExcel_Calculation_Financial\DDB(), PHPExcel_Calculation_Engineering\DECTOBIN(), PHPExcel_Calculation_Engineering\DECTOHEX(), PHPExcel_Calculation_Engineering\DECTOOCT(), PHPExcel_Calculation_Statistical\DEVSQ(), PHPExcel_Calculation_MathTrig\FACT(), PHPExcel_Calculation_MathTrig\FLOOR(), PHPExcel_Calculation_DateTime\HOUROFDAY(), PHPExcel_Calculation_DateTime\MINUTEOFHOUR(), PHPExcel_Calculation_Statistical\NEGBINOMDIST(), PHPExcel_Calculation_DateTime\SECONDOFMINUTE(), PHPExcel_Calculation_Statistical\STDEV(), PHPExcel_Calculation_Statistical\STDEVP(), PHPExcel_Calculation_Financial\TBILLEQ(), PHPExcel_Calculation_Financial\TBILLPRICE(), PHPExcel_Calculation_Financial\TBILLYIELD(), and PHPExcel_Calculation_DateTime\TIMEVALUE().

138  {
139  return self::$compatibilityMode;
140  } // function getCompatibilityMode()
+ Here is the caller graph for this function:

◆ getReturnDateType()

◆ IS_BLANK()

static PHPExcel_Calculation_Functions::IS_BLANK (   $value = NULL)
static

IS_BLANK.

Parameters
mixed$valueValue to check
Returns
boolean

Definition at line 356 of file Functions.php.

356  {
357  if (!is_null($value)) {
358  $value = self::flattenSingleValue($value);
359  }
360 
361  return is_null($value);
362  } // function IS_BLANK()

◆ IS_ERR()

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

IS_ERR.

Parameters
mixed$valueValue to check
Returns
boolean

Definition at line 371 of file Functions.php.

371  {
372  $value = self::flattenSingleValue($value);
373 
374  return self::IS_ERROR($value) && (!self::IS_NA($value));
375  } // function IS_ERR()

◆ IS_ERROR()

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

IS_ERROR.

Parameters
mixed$valueValue to check
Returns
boolean

Definition at line 384 of file Functions.php.

Referenced by PHPExcel_Calculation_Logical\IFERROR().

384  {
385  $value = self::flattenSingleValue($value);
386 
387  if (!is_string($value))
388  return false;
389  return in_array($value, array_values(self::$_errorCodes));
390  } // function IS_ERROR()
+ Here is the caller graph for this function:

◆ IS_EVEN()

static PHPExcel_Calculation_Functions::IS_EVEN (   $value = NULL)
static

IS_EVEN.

Parameters
mixed$valueValue to check
Returns
boolean

Definition at line 412 of file Functions.php.

References NULL().

412  {
413  $value = self::flattenSingleValue($value);
414 
415  if ($value === NULL)
416  return self::NAME();
417  if ((is_bool($value)) || ((is_string($value)) && (!is_numeric($value))))
418  return self::VALUE();
419  return ($value % 2 == 0);
420  } // function IS_EVEN()
+ Here is the call graph for this function:

◆ IS_LOGICAL()

static PHPExcel_Calculation_Functions::IS_LOGICAL (   $value = NULL)
static

IS_LOGICAL.

Parameters
mixed$valueValue to check
Returns
boolean

Definition at line 462 of file Functions.php.

462  {
463  $value = self::flattenSingleValue($value);
464 
465  return is_bool($value);
466  } // function IS_LOGICAL()

◆ IS_NA()

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

IS_NA.

Parameters
mixed$valueValue to check
Returns
boolean

Definition at line 399 of file Functions.php.

399  {
400  $value = self::flattenSingleValue($value);
401 
402  return ($value === self::NA());
403  } // function IS_NA()

◆ IS_NONTEXT()

static PHPExcel_Calculation_Functions::IS_NONTEXT (   $value = NULL)
static

IS_NONTEXT.

Parameters
mixed$valueValue to check
Returns
boolean

Definition at line 488 of file Functions.php.

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

◆ IS_NUMBER()

static PHPExcel_Calculation_Functions::IS_NUMBER (   $value = NULL)
static

IS_NUMBER.

Parameters
mixed$valueValue to check
Returns
boolean

Definition at line 446 of file Functions.php.

446  {
447  $value = self::flattenSingleValue($value);
448 
449  if (is_string($value)) {
450  return False;
451  }
452  return is_numeric($value);
453  } // function IS_NUMBER()

◆ IS_ODD()

static PHPExcel_Calculation_Functions::IS_ODD (   $value = NULL)
static

IS_ODD.

Parameters
mixed$valueValue to check
Returns
boolean

Definition at line 429 of file Functions.php.

References NULL().

429  {
430  $value = self::flattenSingleValue($value);
431 
432  if ($value === NULL)
433  return self::NAME();
434  if ((is_bool($value)) || ((is_string($value)) && (!is_numeric($value))))
435  return self::VALUE();
436  return (abs($value) % 2 == 1);
437  } // function IS_ODD()
+ Here is the call graph for this function:

◆ IS_TEXT()

static PHPExcel_Calculation_Functions::IS_TEXT (   $value = NULL)
static

IS_TEXT.

Parameters
mixed$valueValue to check
Returns
boolean

Definition at line 475 of file Functions.php.

475  {
476  $value = self::flattenSingleValue($value);
477 
478  return (is_string($value) && !self::IS_ERROR($value));
479  } // function IS_TEXT()

◆ isCellValue()

static PHPExcel_Calculation_Functions::isCellValue (   $idx)
static

◆ isMatrixValue()

static PHPExcel_Calculation_Functions::isMatrixValue (   $idx)
static

Definition at line 294 of file Functions.php.

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

294  {
295  return ((substr_count($idx,'.') <= 1) || (preg_match('/\.[A-Z]/',$idx) > 0));
296  }
+ Here is the caller graph for this function:

◆ isValue()

static PHPExcel_Calculation_Functions::isValue (   $idx)
static

Definition at line 299 of file Functions.php.

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

299  {
300  return (substr_count($idx,'.') == 0);
301  }
+ 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
valueThe 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.

518  {
519  while (is_array($value)) {
520  $value = array_shift($value);
521  }
522 
523  switch (gettype($value)) {
524  case 'double' :
525  case 'float' :
526  case 'integer' :
527  return $value;
528  break;
529  case 'boolean' :
530  return (integer) $value;
531  break;
532  case 'string' :
533  // Errors
534  if ((strlen($value) > 0) && ($value{0} == '#')) {
535  return $value;
536  }
537  break;
538  }
539  return 0;
540  } // function N()

◆ NA()

◆ NAME()

static PHPExcel_Calculation_Functions::NAME ( )
static

Definition at line 247 of file Functions.php.

Referenced by FunctionsTest\testNAME().

247  {
248  return self::$_errorCodes['name'];
249  } // function NAME()
+ Here is the caller graph for this function:

◆ NaN()

static PHPExcel_Calculation_Functions::NaN ( )
static

Definition at line 233 of file Functions.php.

Referenced by PHPExcel_Calculation_Financial\_daysPerYear(), PHPExcel_Calculation_Engineering\_nbrConversionFormat(), PHPExcel_Calculation\_unwrapResult(), PHPExcel_Calculation\_wrapResult(), PHPExcel_Calculation_Financial\ACCRINT(), PHPExcel_Calculation_Financial\ACCRINTM(), PHPExcel_Shared_JAMA_Matrix\arrayRightDivide(), PHPExcel_Shared_JAMA_Matrix\arrayTimesEquals(), PHPExcel_Calculation_Statistical\AVEDEV(), PHPExcel_Calculation_Engineering\BESSELI(), PHPExcel_Calculation_Engineering\BESSELJ(), PHPExcel_Calculation_Engineering\BESSELK(), PHPExcel_Calculation_Engineering\BESSELY(), PHPExcel_Calculation_Statistical\BETADIST(), PHPExcel_Calculation_Statistical\BETAINV(), PHPExcel_Calculation_Statistical\BINOMDIST(), PHPExcel_Calculation_Engineering\BINTODEC(), PHPExcel_Calculation_Engineering\BINTOHEX(), PHPExcel_Calculation_Engineering\BINTOOCT(), PHPExcel_Calculation\calculateCellValue(), PHPExcel_Calculation_MathTrig\CEILING(), PHPExcel_Calculation_Statistical\CHIDIST(), PHPExcel_Calculation_MathTrig\COMBIN(), PHPExcel_Calculation_Statistical\CONFIDENCE(), PHPExcel_Calculation_Financial\COUPDAYBS(), PHPExcel_Calculation_Financial\COUPDAYS(), PHPExcel_Calculation_Financial\COUPDAYSNC(), PHPExcel_Calculation_Financial\COUPNCD(), PHPExcel_Calculation_Financial\COUPNUM(), PHPExcel_Calculation_Financial\COUPPCD(), PHPExcel_Calculation_Statistical\CRITBINOM(), PHPExcel_Calculation_Financial\CUMIPMT(), PHPExcel_Calculation_Financial\CUMPRINC(), PHPExcel_Calculation_DateTime\DATE(), PHPExcel_Calculation_DateTime\DATEDIF(), PHPExcel_Calculation_DateTime\DAYOFMONTH(), PHPExcel_Calculation_DateTime\DAYOFWEEK(), PHPExcel_Calculation_Financial\DB(), PHPExcel_Calculation_Financial\DDB(), PHPExcel_Calculation_Engineering\DECTOBIN(), PHPExcel_Calculation_Statistical\DEVSQ(), PHPExcel_Calculation_Database\DGET(), PHPExcel_Calculation_Financial\DISC(), PHPExcel_Calculation_TextData\DOLLAR(), PHPExcel_Calculation_Financial\DOLLARDE(), PHPExcel_Calculation_Financial\DOLLARFR(), PHPExcel_Calculation_Financial\EFFECT(), PHPExcel_Calculation_Statistical\EXPONDIST(), PHPExcel_Calculation_MathTrig\FACT(), PHPExcel_Calculation_MathTrig\FACTDOUBLE(), PHPExcel_Calculation_Statistical\FISHER(), PHPExcel_Calculation_TextData\FIXEDFORMAT(), PHPExcel_Calculation_MathTrig\FLOOR(), PHPExcel_Calculation_Financial\FV(), PHPExcel_Calculation_Statistical\GAMMADIST(), PHPExcel_Calculation_Statistical\GAMMAINV(), PHPExcel_Calculation_Statistical\GAMMALN(), PHPExcel_Calculation_MathTrig\GCD(), PHPExcel_Calculation_Statistical\GEOMEAN(), PHPExcel_Calculation_Statistical\HARMEAN(), PHPExcel_Calculation_Engineering\HEXTOBIN(), PHPExcel_Calculation_Engineering\HEXTODEC(), PHPExcel_Calculation_Engineering\HEXTOOCT(), PHPExcel_Calculation_DateTime\HOUROFDAY(), PHPExcel_Calculation_Statistical\HYPGEOMDIST(), PHPExcel_Calculation_Engineering\IMDIV(), PHPExcel_Calculation_Engineering\IMLN(), PHPExcel_Calculation_Engineering\IMLOG10(), PHPExcel_Calculation_Engineering\IMLOG2(), PHPExcel_Calculation_Engineering\IMPRODUCT(), PHPExcel_Calculation_Engineering\IMSUB(), PHPExcel_Calculation_Financial\INTRATE(), PHPExcel_Calculation_Financial\IPMT(), PHPExcel_Calculation_Statistical\LARGE(), PHPExcel_Calculation_MathTrig\LCM(), PHPExcel_Calculation_MathTrig\LOG_BASE(), PHPExcel_Calculation_Statistical\LOGEST(), PHPExcel_Calculation_Statistical\LOGINV(), PHPExcel_Calculation_Statistical\LOGNORMDIST(), PHPExcel_Calculation_Statistical\MEDIAN(), PHPExcel_Shared_JAMA_Matrix\minusEquals(), PHPExcel_Calculation_DateTime\MINUTEOFHOUR(), PHPExcel_Calculation_DateTime\MONTHOFYEAR(), PHPExcel_Calculation_MathTrig\MROUND(), PHPExcel_Calculation_MathTrig\MULTINOMIAL(), PHPExcel_Calculation_Statistical\NEGBINOMDIST(), PHPExcel_Calculation_Financial\NOMINAL(), PHPExcel_Calculation_Statistical\NORMDIST(), PHPExcel_Calculation_Statistical\NORMINV(), PHPExcel_Calculation_Financial\NPER(), PHPExcel_Calculation_Engineering\OCTTOBIN(), PHPExcel_Calculation_Engineering\OCTTODEC(), PHPExcel_Calculation_Engineering\OCTTOHEX(), PHPExcel_Calculation_Statistical\PERCENTILE(), PHPExcel_Calculation_Statistical\PERCENTRANK(), PHPExcel_Calculation_Statistical\PERMUT(), PHPExcel_Shared_JAMA_Matrix\plusEquals(), PHPExcel_Calculation_Financial\PMT(), PHPExcel_Calculation_Statistical\POISSON(), PHPExcel_Calculation_MathTrig\POWER(), PHPExcel_Shared_JAMA_Matrix\power(), PHPExcel_Calculation_Financial\PPMT(), PHPExcel_Calculation_Financial\PRICE(), PHPExcel_Calculation_Financial\PRICEDISC(), PHPExcel_Calculation_Financial\PRICEMAT(), PHPExcel_Calculation_Financial\PV(), PHPExcel_Calculation_Statistical\QUARTILE(), PHPExcel_Calculation_Financial\RECEIVED(), PHPExcel_Calculation_DateTime\SECONDOFMINUTE(), PHPExcel_Calculation_Financial\SLN(), PHPExcel_Calculation_Statistical\SMALL(), PHPExcel_Calculation_MathTrig\SQRTPI(), PHPExcel_Calculation_Statistical\STANDARDIZE(), PHPExcel_Calculation_Financial\SYD(), PHPExcel_Calculation_Financial\TBILLPRICE(), PHPExcel_Calculation_Financial\TBILLYIELD(), PHPExcel_Calculation_Statistical\TDIST(), FunctionsTest\testNaN(), PHPExcel_Calculation_DateTime\TIME(), PHPExcel_Calculation_Statistical\TRIMMEAN(), PHPExcel_Calculation_DateTime\WEEKOFYEAR(), PHPExcel_Calculation_Statistical\WEIBULL(), PHPExcel_Calculation_Financial\XIRR(), PHPExcel_Calculation_Financial\XNPV(), PHPExcel_Calculation_DateTime\YEAR(), PHPExcel_Calculation_Financial\YIELDDISC(), and PHPExcel_Calculation_Financial\YIELDMAT().

233  {
234  return self::$_errorCodes['num'];
235  } // 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.

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

275  {
276  return self::$_errorCodes['null'];
277  } // function NULL()
+ Here is the caller graph for this function:

◆ REF()

static PHPExcel_Calculation_Functions::REF ( )
static

◆ setCompatibilityMode()

static PHPExcel_Calculation_Functions::setCompatibilityMode (   $compatibilityMode)
static

Definition at line 116 of file Functions.php.

References $compatibilityMode.

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

116  {
117  if (($compatibilityMode == self::COMPATIBILITY_EXCEL) ||
118  ($compatibilityMode == self::COMPATIBILITY_GNUMERIC) ||
119  ($compatibilityMode == self::COMPATIBILITY_OPENOFFICE)) {
120  self::$compatibilityMode = $compatibilityMode;
121  return True;
122  }
123  return False;
124  } // function setCompatibilityMode()
+ Here is the caller graph for this function:

◆ setReturnDateType()

static PHPExcel_Calculation_Functions::setReturnDateType (   $returnDateType)
static

Definition at line 155 of file Functions.php.

Referenced by PHPExcel_Worksheet_AutoFilter\_dynamicFilterDateRange(), PHPExcel_Calculation_DateTime\_getDateValue(), PHPExcel_Calculation_DateTime\_getTimeValue(), PHPExcel_Writer_Excel5\save(), PHPExcel_Writer_Excel2007\save(), DateTimeTest\testDATEtoPHP(), DateTimeTest\testDATEtoPHPObject(), DateTimeTest\testDATEVALUEtoPHP(), DateTimeTest\testDATEVALUEtoPHPObject(), DateTimeTest\testEDATEtoPHP(), DateTimeTest\testEDATEtoPHPObject(), DateTimeTest\testEOMONTHtoPHP(), DateTimeTest\testEOMONTHtoPHPObject(), DateTimeTest\testTIMEtoPHP(), DateTimeTest\testTIMEtoPHPObject(), DateTimeTest\testTIMEVALUEtoPHP(), DateTimeTest\testTIMEVALUEtoPHPObject(), and PHPExcel_Calculation_TextData\VALUE().

155  {
156  if (($returnDateType == self::RETURNDATE_PHP_NUMERIC) ||
157  ($returnDateType == self::RETURNDATE_PHP_OBJECT) ||
158  ($returnDateType == self::RETURNDATE_EXCEL)) {
159  self::$ReturnDateType = $returnDateType;
160  return True;
161  }
162  return False;
163  } // 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
valueThe 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.

References NULL().

557  {
558  $value = self::flattenArrayIndexed($value);
559  if (is_array($value) && (count($value) > 1)) {
560  $a = array_keys($value);
561  $a = array_pop($a);
562  // Range of cells is an error
563  if (self::isCellValue($a)) {
564  return 16;
565  // Test for Matrix
566  } elseif (self::isMatrixValue($a)) {
567  return 64;
568  }
569  } elseif(empty($value)) {
570  // Empty Cell
571  return 1;
572  }
573  $value = self::flattenSingleValue($value);
574 
575  if (($value === NULL) || (is_float($value)) || (is_int($value))) {
576  return 1;
577  } elseif(is_bool($value)) {
578  return 4;
579  } elseif(is_array($value)) {
580  return 64;
581  } elseif(is_string($value)) {
582  // Errors
583  if ((strlen($value) > 0) && ($value{0} == '#')) {
584  return 16;
585  }
586  return 2;
587  }
588  return 0;
589  } // function TYPE()
+ Here is the call graph for this function:

◆ VALUE()

static PHPExcel_Calculation_Functions::VALUE ( )
static

Definition at line 289 of file Functions.php.

Referenced by PHPExcel_Calculation\_executeNumericBinaryOperation(), PHPExcel_Calculation_DateTime\_getDateValue(), PHPExcel_Calculation_TextData\_uniord(), PHPExcel_Calculation_Financial\ACCRINT(), PHPExcel_Calculation_Financial\ACCRINTM(), PHPExcel_Calculation_TextData\ASCIICODE(), PHPExcel_Calculation_MathTrig\ATAN2(), PHPExcel_Calculation_Engineering\BESSELI(), PHPExcel_Calculation_Engineering\BESSELJ(), PHPExcel_Calculation_Engineering\BESSELK(), PHPExcel_Calculation_Engineering\BESSELY(), PHPExcel_Calculation_Statistical\BETADIST(), PHPExcel_Calculation_Statistical\BETAINV(), PHPExcel_Calculation_Statistical\BINOMDIST(), PHPExcel_Calculation_Engineering\BINTODEC(), PHPExcel_Calculation_Engineering\BINTOHEX(), PHPExcel_Calculation_Engineering\BINTOOCT(), PHPExcel_Calculation\calculateCellValue(), PHPExcel_Calculation_MathTrig\CEILING(), PHPExcel_Calculation_LookupRef\CELL_ADDRESS(), PHPExcel_Calculation_TextData\CHARACTER(), PHPExcel_Calculation_Statistical\CHIDIST(), PHPExcel_Calculation_Statistical\CHIINV(), PHPExcel_Calculation_LookupRef\CHOOSE(), PHPExcel_Calculation_LookupRef\COLUMNS(), PHPExcel_Calculation_MathTrig\COMBIN(), PHPExcel_Calculation_Engineering\COMPLEX(), PHPExcel_Calculation_Statistical\CONFIDENCE(), PHPExcel_Calculation_Engineering\CONVERTUOM(), PHPExcel_Calculation_Statistical\CORREL(), PHPExcel_Calculation_Financial\COUPDAYBS(), PHPExcel_Calculation_Financial\COUPDAYS(), PHPExcel_Calculation_Financial\COUPDAYSNC(), PHPExcel_Calculation_Financial\COUPNCD(), PHPExcel_Calculation_Financial\COUPNUM(), PHPExcel_Calculation_Financial\COUPPCD(), PHPExcel_Calculation_Statistical\COVAR(), PHPExcel_Calculation_Statistical\CRITBINOM(), PHPExcel_Calculation_Financial\CUMIPMT(), PHPExcel_Calculation_Financial\CUMPRINC(), PHPExcel_Calculation_DateTime\DATE(), PHPExcel_Calculation_DateTime\DATEDIF(), PHPExcel_Calculation_DateTime\DATEVALUE(), PHPExcel_Calculation_DateTime\DAYOFMONTH(), PHPExcel_Calculation_DateTime\DAYOFWEEK(), PHPExcel_Calculation_DateTime\DAYS360(), PHPExcel_Calculation_Financial\DB(), PHPExcel_Calculation_Financial\DDB(), PHPExcel_Calculation_Engineering\DECTOBIN(), PHPExcel_Calculation_Engineering\DECTOHEX(), PHPExcel_Calculation_Engineering\DECTOOCT(), PHPExcel_Calculation_Financial\DISC(), PHPExcel_Calculation_DateTime\EDATE(), PHPExcel_Calculation_DateTime\EOMONTH(), PHPExcel_Calculation_Engineering\ERF(), PHPExcel_Calculation_Engineering\ERFC(), PHPExcel_Calculation_MathTrig\EVEN(), PHPExcel_Calculation_Statistical\EXPONDIST(), PHPExcel_Calculation_MathTrig\FACT(), PHPExcel_Calculation_MathTrig\FACTDOUBLE(), PHPExcel_Calculation_Statistical\FISHER(), PHPExcel_Calculation_Statistical\FISHERINV(), PHPExcel_Calculation_MathTrig\FLOOR(), PHPExcel_Calculation_Statistical\FORECAST(), PHPExcel_Calculation_Statistical\GAMMADIST(), PHPExcel_Calculation_Statistical\GAMMAINV(), PHPExcel_Calculation_Statistical\GAMMALN(), PHPExcel_Calculation_MathTrig\GCD(), PHPExcel_Calculation_Engineering\HEXTOBIN(), PHPExcel_Calculation_Engineering\HEXTODEC(), PHPExcel_Calculation_Engineering\HEXTOOCT(), PHPExcel_Calculation_LookupRef\HLOOKUP(), PHPExcel_Calculation_DateTime\HOUROFDAY(), PHPExcel_Calculation_Statistical\HYPGEOMDIST(), PHPExcel_Calculation_Engineering\IMPOWER(), PHPExcel_Calculation_Engineering\IMSUM(), PHPExcel_Calculation_LookupRef\INDEX(), PHPExcel_Calculation_MathTrig\INT(), PHPExcel_Calculation_Statistical\INTERCEPT(), PHPExcel_Calculation_Financial\INTRATE(), PHPExcel_Calculation_Financial\IPMT(), PHPExcel_Calculation_Financial\IRR(), PHPExcel_Calculation_Statistical\LARGE(), PHPExcel_Calculation_MathTrig\LCM(), PHPExcel_Calculation_TextData\LEFT(), PHPExcel_Calculation_Statistical\LINEST(), PHPExcel_Calculation_MathTrig\LOG_BASE(), PHPExcel_Calculation_Statistical\LOGEST(), PHPExcel_Calculation_Logical\LOGICAL_AND(), PHPExcel_Calculation_Logical\LOGICAL_OR(), PHPExcel_Calculation_Statistical\LOGINV(), PHPExcel_Calculation_Statistical\LOGNORMDIST(), PHPExcel_Calculation_MathTrig\MDETERM(), PHPExcel_Calculation_TextData\MID(), PHPExcel_Calculation_DateTime\MINUTEOFHOUR(), PHPExcel_Calculation_MathTrig\MINVERSE(), PHPExcel_Calculation_Financial\MIRR(), PHPExcel_Calculation_MathTrig\MMULT(), PHPExcel_Calculation_DateTime\MONTHOFYEAR(), PHPExcel_Calculation_MathTrig\MROUND(), PHPExcel_Calculation_MathTrig\MULTINOMIAL(), PHPExcel_Calculation_Statistical\NEGBINOMDIST(), PHPExcel_Calculation_DateTime\NETWORKDAYS(), PHPExcel_Calculation_Statistical\NORMDIST(), PHPExcel_Calculation_Statistical\NORMINV(), PHPExcel_Calculation_Logical\NOT(), PHPExcel_Calculation_Engineering\OCTTOBIN(), PHPExcel_Calculation_Engineering\OCTTODEC(), PHPExcel_Calculation_Engineering\OCTTOHEX(), PHPExcel_Calculation_MathTrig\ODD(), PHPExcel_Calculation_Statistical\PERCENTILE(), PHPExcel_Calculation_Statistical\PERMUT(), PHPExcel_Calculation_Statistical\POISSON(), PHPExcel_Calculation_Financial\PPMT(), PHPExcel_Calculation_Financial\PRICE(), PHPExcel_Calculation_Financial\PRICEDISC(), PHPExcel_Calculation_Financial\PRICEMAT(), PHPExcel_Calculation_Statistical\QUARTILE(), PHPExcel_Calculation_Financial\RECEIVED(), PHPExcel_Calculation_TextData\RIGHT(), PHPExcel_Calculation_MathTrig\ROMAN(), PHPExcel_Calculation_MathTrig\ROUNDDOWN(), PHPExcel_Calculation_MathTrig\ROUNDUP(), PHPExcel_Calculation_LookupRef\ROWS(), PHPExcel_Calculation_Statistical\RSQ(), PHPExcel_Calculation_TextData\SEARCHINSENSITIVE(), PHPExcel_Calculation_TextData\SEARCHSENSITIVE(), PHPExcel_Calculation_DateTime\SECONDOFMINUTE(), PHPExcel_Calculation_MathTrig\SERIESSUM(), PHPExcel_Calculation_MathTrig\SIGN(), PHPExcel_Calculation_Financial\SLN(), PHPExcel_Calculation_Statistical\SLOPE(), PHPExcel_Calculation_Statistical\SMALL(), PHPExcel_Calculation_MathTrig\SQRTPI(), PHPExcel_Calculation_Statistical\STANDARDIZE(), PHPExcel_Calculation_Statistical\STEYX(), PHPExcel_Shared_Date\stringToExcel(), PHPExcel_Calculation_MathTrig\SUBTOTAL(), PHPExcel_Calculation_MathTrig\SUMPRODUCT(), PHPExcel_Calculation_Financial\SYD(), PHPExcel_Calculation_Financial\TBILLEQ(), PHPExcel_Calculation_Financial\TBILLPRICE(), PHPExcel_Calculation_Financial\TBILLYIELD(), PHPExcel_Calculation_Statistical\TDIST(), FunctionsTest\testVALUE(), PHPExcel_Calculation_DateTime\TIME(), PHPExcel_Calculation_DateTime\TIMEVALUE(), PHPExcel_Calculation_Statistical\TINV(), PHPExcel_Calculation_Statistical\TRIMMEAN(), PHPExcel_Calculation_MathTrig\TRUNC(), PHPExcel_Calculation_TextData\VALUE(), PHPExcel_Calculation_Statistical\VARA(), PHPExcel_Calculation_Statistical\VARPA(), PHPExcel_Calculation_LookupRef\VLOOKUP(), PHPExcel_Calculation_DateTime\WEEKOFYEAR(), PHPExcel_Calculation_Statistical\WEIBULL(), PHPExcel_Calculation_DateTime\WORKDAY(), PHPExcel_Calculation_Financial\XIRR(), PHPExcel_Calculation_Financial\XNPV(), PHPExcel_Calculation_DateTime\YEAR(), PHPExcel_Calculation_DateTime\YEARFRAC(), PHPExcel_Calculation_Financial\YIELDDISC(), and PHPExcel_Calculation_Financial\YIELDMAT().

289  {
290  return self::$_errorCodes['value'];
291  } // 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.

498  {
499  return 'PHPExcel 1.8.1, 2015-04-30';
500  } // 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 setCompatibilityMode().

◆ $ReturnDateType

PHPExcel_Calculation_Functions::$ReturnDateType = self::RETURNDATE_EXCEL
staticprotected

Definition at line 85 of file Functions.php.

◆ COMPATIBILITY_EXCEL

◆ COMPATIBILITY_GNUMERIC

◆ COMPATIBILITY_OPENOFFICE

◆ RETURNDATE_EXCEL

◆ RETURNDATE_PHP_NUMERIC

◆ RETURNDATE_PHP_OBJECT


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