You are here

public static function PHPExcel_Calculation_Engineering::DECTOBIN in Loft Data Grids 6.2

Same name and namespace in other branches
  1. 7.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php \PHPExcel_Calculation_Engineering::DECTOBIN()

* DECTOBIN * * Return a decimal value as binary. * * Excel Function: * DEC2BIN(x[,places]) * * @access public * @category Engineering Functions *

Parameters

string $x The decimal integer you want to convert. If number is negative,: * valid place values are ignored and DEC2BIN returns a 10-character * (10-bit) binary number in which the most significant bit is the sign * bit. The remaining 9 bits are magnitude bits. Negative numbers are * represented using two's-complement notation. * If number < -512 or if number > 511, DEC2BIN returns the #NUM! error * value. * If number is nonnumeric, DEC2BIN returns the #VALUE! error value. * If DEC2BIN requires more than places characters, it returns the #NUM! * error value. * @param integer $places The number of characters to use. If places is omitted, DEC2BIN uses * the minimum number of characters necessary. Places is useful for * padding the return value with leading 0s (zeros). * If places is not an integer, it is truncated. * If places is nonnumeric, DEC2BIN returns the #VALUE! error value. * If places is zero or negative, DEC2BIN returns the #NUM! error value. * @return string

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php, line 1228

Class

PHPExcel_Calculation_Engineering
PHPExcel_Calculation_Engineering

Code

public static function DECTOBIN($x, $places = NULL) {
  $x = PHPExcel_Calculation_Functions::flattenSingleValue($x);
  $places = PHPExcel_Calculation_Functions::flattenSingleValue($places);
  if (is_bool($x)) {
    if (PHPExcel_Calculation_Functions::getCompatibilityMode() == PHPExcel_Calculation_Functions::COMPATIBILITY_OPENOFFICE) {
      $x = (int) $x;
    }
    else {
      return PHPExcel_Calculation_Functions::VALUE();
    }
  }
  $x = (string) $x;
  if (strlen($x) > preg_match_all('/[-0123456789.]/', $x, $out)) {
    return PHPExcel_Calculation_Functions::VALUE();
  }
  $x = (string) floor($x);
  $r = decbin($x);
  if (strlen($r) == 32) {

    //	Two's Complement
    $r = substr($r, -10);
  }
  elseif (strlen($r) > 11) {
    return PHPExcel_Calculation_Functions::NaN();
  }
  return self::_nbrConversionFormat($r, $places);
}