PRECISION
PRECISION = 8.88E-16
setCompatibilityMode(string $compatibilityMode) : boolean
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) : boolean
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_PHP_NUMERIC 'P' Functions::RETURNDATE_PHP_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_PHP_NUMERIC 'P' Functions::RETURNDATE_PHP_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
isFormula(mixed $cellReference = '', \PhpOffice\PhpSpreadsheet\Cell\Cell $pCell = null) : boolean|string
ISFORMULA.
| mixed | $cellReference | The cell to check |
| \PhpOffice\PhpSpreadsheet\Cell\Cell | $pCell | The current cell (containing this formula) |