[ Index ]

PHP Cross Reference of Unnamed Project

title

Body

[close]

/lib/phpexcel/PHPExcel/Calculation/ -> Functions.php (summary)

(no description)

File Size: 762 lines (21 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 1 class

PHPExcel_Calculation_Functions:: (37 methods):
  setCompatibilityMode()
  getCompatibilityMode()
  setReturnDateType()
  getReturnDateType()
  DUMMY()
  DIV0()
  NA()
  NaN()
  NAME()
  REF()
  NULL()
  VALUE()
  isMatrixValue()
  isValue()
  isCellValue()
  ifCondition()
  ERROR_TYPE()
  IS_BLANK()
  IS_ERR()
  IS_ERROR()
  IS_NA()
  IS_EVEN()
  IS_ODD()
  IS_NUMBER()
  IS_LOGICAL()
  IS_TEXT()
  IS_NONTEXT()
  VERSION()
  N()
  TYPE()
  flattenArray()
  flattenArrayIndexed()
  flattenSingleValue()
  acosh()
  asinh()
  atanh()
  mb_str_replace()


Class: PHPExcel_Calculation_Functions  - X-Ref

PHPExcel_Calculation_Functions

Copyright (c) 2006 - 2015 PHPExcel

This library is free software; you can redistribute it and/or
modify it under the terms of the GNU Lesser General Public
License as published by the Free Software Foundation; either
version 2.1 of the License, or (at your option) any later version.

This library is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
Lesser General Public License for more details.

You should have received a copy of the GNU Lesser General Public
License along with this library; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA

setCompatibilityMode($compatibilityMode)   X-Ref
Set the Compatibility Mode

param: string        $compatibilityMode        Compatibility Mode
return: boolean    (Success or Failure)

getCompatibilityMode()   X-Ref
Return the current Compatibility Mode

return: string        Compatibility Mode

setReturnDateType($returnDateType)   X-Ref
Set the Return Date Format used by functions that return a date/time (Excel, PHP Serialized Numeric or PHP Object)

param: string    $returnDateType            Return Date Format
return: boolean                            Success or failure

getReturnDateType()   X-Ref
Return the current Return Date Format for functions that return a date/time (Excel, PHP Serialized Numeric or PHP Object)

return: string        Return Date Format

DUMMY()   X-Ref
DUMMY

return: string    #Not Yet Implemented

DIV0()   X-Ref
DIV0

return: string    #Not Yet Implemented

NA()   X-Ref
NA

Excel Function:
=NA()

Returns the error value #N/A
#N/A is the error value that means "no value is available."

return: string    #N/A!

NaN()   X-Ref
NaN

Returns the error value #NUM!

return: string    #NUM!

NAME()   X-Ref
NAME

Returns the error value #NAME?

return: string    #NAME?

REF()   X-Ref
REF

Returns the error value #REF!

return: string    #REF!

NULL()   X-Ref
NULL

Returns the error value #NULL!

return: string    #NULL!

VALUE()   X-Ref
VALUE

Returns the error value #VALUE!

return: string    #VALUE!

isMatrixValue($idx)   X-Ref
No description

isValue($idx)   X-Ref
No description

isCellValue($idx)   X-Ref
No description

ifCondition($condition)   X-Ref
No description

ERROR_TYPE($value = '')   X-Ref
ERROR_TYPE

param: mixed    $value    Value to check
return: boolean

IS_BLANK($value = null)   X-Ref
IS_BLANK

param: mixed    $value    Value to check
return: boolean

IS_ERR($value = '')   X-Ref
IS_ERR

param: mixed    $value    Value to check
return: boolean

IS_ERROR($value = '')   X-Ref
IS_ERROR

param: mixed    $value    Value to check
return: boolean

IS_NA($value = '')   X-Ref
IS_NA

param: mixed    $value    Value to check
return: boolean

IS_EVEN($value = null)   X-Ref
IS_EVEN

param: mixed    $value    Value to check
return: boolean

IS_ODD($value = null)   X-Ref
IS_ODD

param: mixed    $value    Value to check
return: boolean

IS_NUMBER($value = null)   X-Ref
IS_NUMBER

param: mixed    $value        Value to check
return: boolean

IS_LOGICAL($value = null)   X-Ref
IS_LOGICAL

param: mixed    $value        Value to check
return: boolean

IS_TEXT($value = null)   X-Ref
IS_TEXT

param: mixed    $value        Value to check
return: boolean

IS_NONTEXT($value = null)   X-Ref
IS_NONTEXT

param: mixed    $value        Value to check
return: boolean

VERSION()   X-Ref
VERSION

return: string    Version information

N($value = null)   X-Ref
N

Returns a value converted to a number

param: value        The value you want converted
return: number        N converts values listed in the following table

TYPE($value = null)   X-Ref
TYPE

Returns a number that identifies the type of a value

param: value        The value you want tested
return: number        N converts values listed in the following table

flattenArray($array)   X-Ref
Convert a multi-dimensional array to a simple 1-dimensional array

param: array    $array    Array to be flattened
return: array    Flattened array

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

param: array    $array    Array to be flattened
return: array    Flattened array

flattenSingleValue($value = '')   X-Ref
Convert an array to a single scalar value by extracting the first element

param: mixed        $value        Array or scalar value
return: mixed

acosh($x)   X-Ref
No description

asinh($x)   X-Ref
No description

atanh($x)   X-Ref
No description

mb_str_replace($search, $replace, $subject)   X-Ref
No description



Generated: Thu Aug 11 10:00:09 2016 Cross-referenced by PHPXref 0.7.1