reginaldojunior /
winners
| @@ 1442-1453 (lines=12) @@ | ||
| 1439 | * #NUM! error value. |
|
| 1440 | * @return string |
|
| 1441 | */ |
|
| 1442 | public static function HEXTODEC($x) { |
|
| 1443 | $x = PHPExcel_Calculation_Functions::flattenSingleValue($x); |
|
| 1444 | ||
| 1445 | if (is_bool($x)) { |
|
| 1446 | return PHPExcel_Calculation_Functions::VALUE(); |
|
| 1447 | } |
|
| 1448 | $x = (string) $x; |
|
| 1449 | if (strlen($x) > preg_match_all('/[0123456789ABCDEF]/',strtoupper($x),$out)) { |
|
| 1450 | return PHPExcel_Calculation_Functions::NaN(); |
|
| 1451 | } |
|
| 1452 | return hexdec($x); |
|
| 1453 | } // function HEXTODEC() |
|
| 1454 | ||
| 1455 | ||
| 1456 | /** |
|
| @@ 1575-1586 (lines=12) @@ | ||
| 1572 | * #NUM! error value. |
|
| 1573 | * @return string |
|
| 1574 | */ |
|
| 1575 | public static function OCTTODEC($x) { |
|
| 1576 | $x = PHPExcel_Calculation_Functions::flattenSingleValue($x); |
|
| 1577 | ||
| 1578 | if (is_bool($x)) { |
|
| 1579 | return PHPExcel_Calculation_Functions::VALUE(); |
|
| 1580 | } |
|
| 1581 | $x = (string) $x; |
|
| 1582 | if (preg_match_all('/[01234567]/',$x,$out) != strlen($x)) { |
|
| 1583 | return PHPExcel_Calculation_Functions::NaN(); |
|
| 1584 | } |
|
| 1585 | return octdec($x); |
|
| 1586 | } // function OCTTODEC() |
|
| 1587 | ||
| 1588 | ||
| 1589 | /** |
|
