PHPExcel_Calculation_Logical Class Reference

Collaboration diagram for PHPExcel_Calculation_Logical:

Static Public Member Functions
static	TRUE ()
static	FALSE ()
static	LOGICAL_AND ()
static	LOGICAL_OR ()
static	NOT ($logical=FALSE)
static	STATEMENT_IF ($condition=TRUE, $returnIfTrue=0, $returnIfFalse=FALSE)
static	IFERROR ($testValue='', $errorpart='')

Detailed Description

Definition at line 46 of file Logical.php.

Member Function Documentation

FALSE()

static PHPExcel_Calculation_Logical::FALSE ( )

static

Definition at line 77 of file Logical.php.

Referenced by LOGICAL_AND(), LOGICAL_OR(), NOT(), STATEMENT_IF(), and LogicalTest\testFALSE().

                                       {
                return FALSE;
        }       //      function FALSE()

Here is the caller graph for this function:

IFERROR()

static PHPExcel_Calculation_Logical::IFERROR (   $testValue = '',   $errorpart = ''  )

static

Definition at line 281 of file Logical.php.

References PHPExcel_Calculation_Functions\flattenSingleValue(), and PHPExcel_Calculation_Functions\IS_ERROR().

                                                                         {
                $testValue      = (is_null($testValue)) ? '' :  PHPExcel_Calculation_Functions::flattenSingleValue($testValue);
                $errorpart      = (is_null($errorpart)) ? '' :  PHPExcel_Calculation_Functions::flattenSingleValue($errorpart);

                return self::STATEMENT_IF(PHPExcel_Calculation_Functions::IS_ERROR($testValue), $errorpart, $testValue);
        }       //      function IFERROR()

Here is the call graph for this function:

LOGICAL_AND()

static PHPExcel_Calculation_Logical::LOGICAL_AND ( )

static

Definition at line 103 of file Logical.php.

References FALSE(), PHPExcel_Calculation_Functions\flattenArray(), PHPExcel_Calculation\getFALSE(), PHPExcel_Calculation\getTRUE(), TRUE(), and PHPExcel_Calculation_Functions\VALUE().

                                             {
                // Return value
                $returnValue = TRUE;

                // Loop through the arguments
                $aArgs = PHPExcel_Calculation_Functions::flattenArray(func_get_args());
                $argCount = -1;
                foreach ($aArgs as $argCount => $arg) {
                        // Is it a boolean value?
                        if (is_bool($arg)) {
                                $returnValue = $returnValue && $arg;
                        } elseif ((is_numeric($arg)) && (!is_string($arg))) {
                                $returnValue = $returnValue && ($arg != 0);
                        } elseif (is_string($arg)) {
                                $arg = strtoupper($arg);
                                if (($arg == 'TRUE') || ($arg == PHPExcel_Calculation::getTRUE())) {
                                        $arg = TRUE;
                                } elseif (($arg == 'FALSE') || ($arg == PHPExcel_Calculation::getFALSE())) {
                                        $arg = FALSE;
                                } else {
                                        return PHPExcel_Calculation_Functions::VALUE();
                                }
                                $returnValue = $returnValue && ($arg != 0);
                        }
                }

                // Return
                if ($argCount < 0) {
                        return PHPExcel_Calculation_Functions::VALUE();
                }
                return $returnValue;
        }       //      function LOGICAL_AND()

Here is the call graph for this function:

LOGICAL_OR()

static PHPExcel_Calculation_Logical::LOGICAL_OR ( )

static

Definition at line 158 of file Logical.php.

References FALSE(), PHPExcel_Calculation_Functions\flattenArray(), PHPExcel_Calculation\getFALSE(), PHPExcel_Calculation\getTRUE(), TRUE(), and PHPExcel_Calculation_Functions\VALUE().

                                            {
                // Return value
                $returnValue = FALSE;

                // Loop through the arguments
                $aArgs = PHPExcel_Calculation_Functions::flattenArray(func_get_args());
                $argCount = -1;
                foreach ($aArgs as $argCount => $arg) {
                        // Is it a boolean value?
                        if (is_bool($arg)) {
                                $returnValue = $returnValue || $arg;
                        } elseif ((is_numeric($arg)) && (!is_string($arg))) {
                                $returnValue = $returnValue || ($arg != 0);
                        } elseif (is_string($arg)) {
                                $arg = strtoupper($arg);
                                if (($arg == 'TRUE') || ($arg == PHPExcel_Calculation::getTRUE())) {
                                        $arg = TRUE;
                                } elseif (($arg == 'FALSE') || ($arg == PHPExcel_Calculation::getFALSE())) {
                                        $arg = FALSE;
                                } else {
                                        return PHPExcel_Calculation_Functions::VALUE();
                                }
                                $returnValue = $returnValue || ($arg != 0);
                        }
                }

                // Return
                if ($argCount < 0) {
                        return PHPExcel_Calculation_Functions::VALUE();
                }
                return $returnValue;
        }       //      function LOGICAL_OR()

Here is the call graph for this function:

NOT()

static PHPExcel_Calculation_Logical::NOT (   $logical = FALSE )

static

Definition at line 212 of file Logical.php.

References FALSE(), PHPExcel_Calculation_Functions\flattenSingleValue(), PHPExcel_Calculation\getFALSE(), PHPExcel_Calculation\getTRUE(), TRUE(), and PHPExcel_Calculation_Functions\VALUE().

                                                   {
                $logical = PHPExcel_Calculation_Functions::flattenSingleValue($logical);
                if (is_string($logical)) {
                        $logical = strtoupper($logical);
                        if (($logical == 'TRUE') || ($logical == PHPExcel_Calculation::getTRUE())) {
                                return FALSE;
                        } elseif (($logical == 'FALSE') || ($logical == PHPExcel_Calculation::getFALSE())) {
                                return TRUE;
                        } else {
                                return PHPExcel_Calculation_Functions::VALUE();
                        }
                }

                return !$logical;
        }       //      function NOT()

Here is the call graph for this function:

STATEMENT_IF()

static PHPExcel_Calculation_Logical::STATEMENT_IF (   $condition = TRUE,   $returnIfTrue = 0,   $returnIfFalse = FALSE  )

static

Definition at line 260 of file Logical.php.

References FALSE(), PHPExcel_Calculation_Functions\flattenSingleValue(), and TRUE().

                                                                                                          {
                $condition              = (is_null($condition))         ? TRUE :        (boolean) PHPExcel_Calculation_Functions::flattenSingleValue($condition);
                $returnIfTrue   = (is_null($returnIfTrue))      ? 0 :           PHPExcel_Calculation_Functions::flattenSingleValue($returnIfTrue);
                $returnIfFalse  = (is_null($returnIfFalse))     ? FALSE :       PHPExcel_Calculation_Functions::flattenSingleValue($returnIfFalse);

                return ($condition) ? $returnIfTrue : $returnIfFalse;
        }       //      function STATEMENT_IF()

Here is the call graph for this function:

TRUE()

static PHPExcel_Calculation_Logical::TRUE ( )

static

Definition at line 60 of file Logical.php.

Referenced by LOGICAL_AND(), LOGICAL_OR(), NOT(), STATEMENT_IF(), and LogicalTest\testTRUE().

                                      {
                return TRUE;
        }       //      function TRUE()

Here is the caller graph for this function:

---

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

• libs/composer/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Logical.php