Subversion Repositories eFlore/Applications.cel

Rev

Rev 3857 | Blame | Compare with Previous | Last modification | View Log | RSS feed

<?php
/**
 * PHPExcel
 *
 * Copyright (c) 2006 - 2013 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
 *
 * @category    PHPExcel
 * @package             PHPExcel_Calculation
 * @copyright   Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel)
 * @license             http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt   LGPL
 * @version             ##VERSION##, ##DATE##
 */


/** PHPExcel root directory */
if (!defined('PHPEXCEL_ROOT')) {
        /**
         * @ignore
         */
        define('PHPEXCEL_ROOT', dirname(__FILE__) . '/../../');
        require(PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php');
}


/**
 * PHPExcel_Calculation_Logical
 *
 * @category    PHPExcel
 * @package             PHPExcel_Calculation
 * @copyright   Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel)
 */
class PHPExcel_Calculation_Logical {

        /**
         * TRUE
         *
         * Returns the boolean TRUE.
         *
         * Excel Function:
         *              =TRUE()
         *
         * @access      public
         * @category Logical Functions
         * @return      boolean         True
         */
        public static function TRUE() {
                return TRUE;
        }       //      function TRUE()


        /**
         * FALSE
         *
         * Returns the boolean FALSE.
         *
         * Excel Function:
         *              =FALSE()
         *
         * @access      public
         * @category Logical Functions
         * @return      boolean         False
         */
        public static function FALSE() {
                return FALSE;
        }       //      function FALSE()


        /**
         * LOGICAL_AND
         *
         * Returns boolean TRUE if all its arguments are TRUE; returns FALSE if one or more argument is FALSE.
         *
         * Excel Function:
         *              =AND(logical1[,logical2[, ...]])
         *
         *              The arguments must evaluate to logical values such as TRUE or FALSE, or the arguments must be arrays
         *                      or references that contain logical values.
         *
         *              Boolean arguments are treated as True or False as appropriate
         *              Integer or floating point arguments are treated as True, except for 0 or 0.0 which are False
         *              If any argument value is a string, or a Null, the function returns a #VALUE! error, unless the string holds
         *                      the value TRUE or FALSE, in which case it is evaluated as the corresponding boolean value
         *
         * @access      public
         * @category Logical Functions
         * @param       mixed           $arg,...                Data values
         * @return      boolean         The logical AND of the arguments.
         */
        public static function LOGICAL_AND() {
                // 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()


        /**
         * LOGICAL_OR
         *
         * Returns boolean TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE.
         *
         * Excel Function:
         *              =OR(logical1[,logical2[, ...]])
         *
         *              The arguments must evaluate to logical values such as TRUE or FALSE, or the arguments must be arrays
         *                      or references that contain logical values.
         *
         *              Boolean arguments are treated as True or False as appropriate
         *              Integer or floating point arguments are treated as True, except for 0 or 0.0 which are False
         *              If any argument value is a string, or a Null, the function returns a #VALUE! error, unless the string holds
         *                      the value TRUE or FALSE, in which case it is evaluated as the corresponding boolean value
         *
         * @access      public
         * @category Logical Functions
         * @param       mixed           $arg,...                Data values
         * @return      boolean         The logical OR of the arguments.
         */
        public static function LOGICAL_OR() {
                // 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()


        /**
         * NOT
         *
         * Returns the boolean inverse of the argument.
         *
         * Excel Function:
         *              =NOT(logical)
         *
         *              The argument must evaluate to a logical value such as TRUE or FALSE
         *
         *              Boolean arguments are treated as True or False as appropriate
         *              Integer or floating point arguments are treated as True, except for 0 or 0.0 which are False
         *              If any argument value is a string, or a Null, the function returns a #VALUE! error, unless the string holds
         *                      the value TRUE or FALSE, in which case it is evaluated as the corresponding boolean value
         *
         * @access      public
         * @category Logical Functions
         * @param       mixed           $logical        A value or expression that can be evaluated to TRUE or FALSE
         * @return      boolean         The boolean inverse of the argument.
         */
        public static function NOT($logical=FALSE) {
                $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()

        /**
         * STATEMENT_IF
         *
         * Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE.
         *
         * Excel Function:
         *              =IF(condition[,returnIfTrue[,returnIfFalse]])
         *
         *              Condition is any value or expression that can be evaluated to TRUE or FALSE.
         *                      For example, A10=100 is a logical expression; if the value in cell A10 is equal to 100,
         *                      the expression evaluates to TRUE. Otherwise, the expression evaluates to FALSE.
         *                      This argument can use any comparison calculation operator.
         *              ReturnIfTrue is the value that is returned if condition evaluates to TRUE.
         *                      For example, if this argument is the text string "Within budget" and the condition argument evaluates to TRUE,
         *                      then the IF function returns the text "Within budget"
         *                      If condition is TRUE and ReturnIfTrue is blank, this argument returns 0 (zero). To display the word TRUE, use
         *                      the logical value TRUE for this argument.
         *                      ReturnIfTrue can be another formula.
         *              ReturnIfFalse is the value that is returned if condition evaluates to FALSE.
         *                      For example, if this argument is the text string "Over budget" and the condition argument evaluates to FALSE,
         *                      then the IF function returns the text "Over budget".
         *                      If condition is FALSE and ReturnIfFalse is omitted, then the logical value FALSE is returned.
         *                      If condition is FALSE and ReturnIfFalse is blank, then the value 0 (zero) is returned.
         *                      ReturnIfFalse can be another formula.
         *
         * @access      public
         * @category Logical Functions
         * @param       mixed   $condition              Condition to evaluate
         * @param       mixed   $returnIfTrue   Value to return when condition is true
         * @param       mixed   $returnIfFalse  Optional value to return when condition is false
         * @return      mixed   The value of returnIfTrue or returnIfFalse determined by condition
         */
        public static function STATEMENT_IF($condition = TRUE, $returnIfTrue = 0, $returnIfFalse = FALSE) {
                $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()


        /**
         * IFERROR
         *
         * Excel Function:
         *              =IFERROR(testValue,errorpart)
         *
         * @access      public
         * @category Logical Functions
         * @param       mixed   $testValue      Value to check, is also the value returned when no error
         * @param       mixed   $errorpart      Value to return when testValue is an error condition
         * @return      mixed   The value of errorpart or testValue determined by error condition
         */
        public static function IFERROR($testValue = '', $errorpart = '') {
                $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()

}       //      class PHPExcel_Calculation_Logical