public static function PHPExcel_Calculation_Engineering::HEXTODEC 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::HEXTODEC()

* HEXTODEC * * Return a hex value as decimal. * * Excel Function: * HEX2DEC(x) * * @access public * @category Engineering Functions *

Parameters

string $x The hexadecimal number you want to convert. This number cannot: * contain more than 10 characters (40 bits). The most significant * bit of number is the sign bit. The remaining 39 bits are magnitude * bits. Negative numbers are represented using two's-complement * notation. * If number is not a valid hexadecimal number, HEX2DEC returns the * #NUM! error value. * @return string

File

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

Class

PHPExcel_Calculation_Engineering

PHPExcel_Calculation_Engineering

Code

public static function HEXTODEC($x) {
  $x = PHPExcel_Calculation_Functions::flattenSingleValue($x);
  if (is_bool($x)) {
    return PHPExcel_Calculation_Functions::VALUE();
  }
  $x = (string) $x;
  if (strlen($x) > preg_match_all('/[0123456789ABCDEF]/', strtoupper($x), $out)) {
    return PHPExcel_Calculation_Functions::NaN();
  }
  return hexdec($x);
}