PRECISION
PRECISION = 8.88E-16
$compatibilityMode : string
Compatibility mode to use for error checking and responses.
$returnDateType : string
Data Type to use when returning date values.
$errorCodes : array
List of error codes.
setCompatibilityMode(string $compatibilityMode) : bool
Set the Compatibility Mode.
string | $compatibilityMode | Compatibility Mode Permitted values are: Functions::COMPATIBILITY_EXCEL 'Excel' Functions::COMPATIBILITY_GNUMERIC 'Gnumeric' Functions::COMPATIBILITY_OPENOFFICE 'OpenOfficeCalc' |
(Success or Failure)
setReturnDateType(string $returnDateType) : bool
Set the Return Date Format used by functions that return a date/time (Excel, PHP Serialized Numeric or PHP Object).
string | $returnDateType | Return Date Format Permitted values are: Functions::RETURNDATE_UNIX_TIMESTAMP 'P' Functions::RETURNDATE_PHP_DATETIME_OBJECT 'O' Functions::RETURNDATE_EXCEL 'E' |
Success or failure
getReturnDateType() : string
Return the current Return Date Format for functions that return a date/time (Excel, PHP Serialized Numeric or PHP Object).
Return Date Format Possible Return values are: Functions::RETURNDATE_UNIX_TIMESTAMP 'P' Functions::RETURNDATE_PHP_DATETIME_OBJECT 'O' Functions::RETURNDATE_EXCEL 'E'
n(null|mixed $value = null) : \PhpOffice\PhpSpreadsheet\Calculation\number
N.
Returns a value converted to a number
null|mixed | $value | The value you want converted |
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(null|mixed $value = null) : \PhpOffice\PhpSpreadsheet\Calculation\number
TYPE.
Returns a number that identifies the type of a value
null|mixed | $value | The value you want tested |
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