setCompatibilityMode()

setCompatibilityMode(string  $compatibilityMode) : boolean

Set the Compatibility Mode

Parameters

Returns

(Success or Failure)

getCompatibilityMode()

getCompatibilityMode() : string

Return the current Compatibility Mode

Returns

Compatibility Mode Possible Return values are: PHPExcel_Calculation_Functions::COMPATIBILITY_EXCEL 'Excel' PHPExcel_Calculation_Functions::COMPATIBILITY_GNUMERIC 'Gnumeric' PHPExcel_Calculation_Functions::COMPATIBILITY_OPENOFFICE 'OpenOfficeCalc'

setReturnDateType()

setReturnDateType(string  $returnDateType) : boolean

Set the Return Date Format used by functions that return a date/time (Excel, PHP Serialized Numeric or PHP Object)

Parameters

Returns

Success or failure

getReturnDateType()

getReturnDateType() : string

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

Returns

Return Date Format Possible Return values are: PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC 'P' PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT 'O' PHPExcel_Calculation_Functions::RETURNDATE_EXCEL 'E'

DUMMY()

DUMMY() : string

DUMMY

Returns

Not Yet Implemented

DIV0()

DIV0() : string

DIV0

Returns

Not Yet Implemented

NA()

NA() : string

NA

Excel Function: =NA()

Returns the error value #N/A

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

Returns

N/A!

NaN()

NaN() : string

NaN

Returns the error value #NUM!

Returns

NUM!

NAME()

NAME() : string

NAME

Returns the error value #NAME?

Returns

NAME?

REF()

REF() : string

REF

Returns the error value #REF!

Returns

REF!

NULL()

NULL() : string

NULL

Returns the error value #NULL!

Returns

NULL!

VALUE()

VALUE() : string

VALUE

Returns the error value #VALUE!

Returns

VALUE!

isMatrixValue()

isMatrixValue(  $idx) 

Parameters

isValue()

isValue(  $idx) 

Parameters

isCellValue()

isCellValue(  $idx) 

Parameters

_ifCondition()

_ifCondition(  $condition) 

Parameters

ERROR_TYPE()

ERROR_TYPE(mixed  $value = '') : boolean

ERROR_TYPE

Parameters

Returns

IS_BLANK()

IS_BLANK(mixed  $value = NULL) : boolean

IS_BLANK

Parameters

Returns

IS_ERR()

IS_ERR(mixed  $value = '') : boolean

IS_ERR

Parameters

Returns

IS_ERROR()

IS_ERROR(mixed  $value = '') : boolean

IS_ERROR

Parameters

Returns

IS_NA()

IS_NA(mixed  $value = '') : boolean

IS_NA

Parameters

Returns

IS_EVEN()

IS_EVEN(mixed  $value = NULL) : boolean

IS_EVEN

Parameters

Returns

IS_ODD()

IS_ODD(mixed  $value = NULL) : boolean

IS_ODD

Parameters

Returns

IS_NUMBER()

IS_NUMBER(mixed  $value = NULL) : boolean

IS_NUMBER

Parameters

Returns

IS_LOGICAL()

IS_LOGICAL(mixed  $value = NULL) : boolean

IS_LOGICAL

Parameters

Returns

IS_TEXT()

IS_TEXT(mixed  $value = NULL) : boolean

IS_TEXT

Parameters

Returns

IS_NONTEXT()

IS_NONTEXT(mixed  $value = NULL) : boolean

IS_NONTEXT

Parameters

Returns

VERSION()

VERSION() : string

VERSION

Returns

Version information

N()

N(  $value = NULL) : \number

N

Returns a value converted to a number

Parameters

Returns

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

TYPE()

TYPE(  $value = NULL) : \number

TYPE

Returns a number that identifies the type of a value

Parameters

Returns

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

flattenArray()

flattenArray(array  $array) : array

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

Parameters

Returns

Flattened array

flattenArrayIndexed()

flattenArrayIndexed(array  $array) : array

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

Parameters

Returns

Flattened array

flattenSingleValue()

flattenSingleValue(mixed  $value = '') : mixed

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

Parameters

Returns