You are here

Home » API reference » Loft Data Grids 6.2 » Logical.php

class PHPExcel_Calculation_Logical in Loft Data Grids 6.2

Same name and namespace in other branches
  1. 7.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Logical.php \PHPExcel_Calculation_Logical

PHPExcel_Calculation_Logical

@category PHPExcel @package PHPExcel_Calculation @copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)

Hierarchy

Expanded class hierarchy of PHPExcel_Calculation_Logical

5 string references to 'PHPExcel_Calculation_Logical'
LogicalTest::testAND in vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Calculation/LogicalTest.php
@dataProvider providerAND
LogicalTest::testIF in vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Calculation/LogicalTest.php
@dataProvider providerIF
LogicalTest::testIFERROR in vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Calculation/LogicalTest.php
@dataProvider providerIFERROR
LogicalTest::testNOT in vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Calculation/LogicalTest.php
@dataProvider providerNOT
LogicalTest::testOR in vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Calculation/LogicalTest.php
@dataProvider providerOR

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Logical.php, line 46

View source 
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 : (bool) 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);
  }

}

Members

Namesort descending Modifiers Type Description Overrides
PHPExcel_Calculation_Logical::FALSE public static function * FALSE * * Returns the boolean FALSE. * * Excel Function: * =FALSE() * * @access public * @category Logical Functions *
PHPExcel_Calculation_Logical::IFERROR public static function * IFERROR * * Excel Function: * =IFERROR(testValue,errorpart) * * @access public * @category Logical Functions *
PHPExcel_Calculation_Logical::LOGICAL_AND public static function * 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…
PHPExcel_Calculation_Logical::LOGICAL_OR public static function * 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…
PHPExcel_Calculation_Logical::NOT public static function * 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 …
PHPExcel_Calculation_Logical::STATEMENT_IF public static function * 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…
PHPExcel_Calculation_Logical::TRUE public static function * TRUE * * Returns the boolean TRUE. * * Excel Function: * =TRUE() * * @access public * @category Logical Functions *