AutorÃa | Ultima modificación | Ver Log |
<?phpnamespace PhpOffice\PhpSpreadsheet\Calculation\MathTrig;use PhpOffice\PhpSpreadsheet\Calculation\ArrayEnabled;use PhpOffice\PhpSpreadsheet\Calculation\Exception;use PhpOffice\PhpSpreadsheet\Calculation\Information\ExcelError;class Base{use ArrayEnabled;/*** BASE.** Converts a number into a text representation with the given radix (base).** Excel Function:* BASE(Number, Radix [Min_length])** @param mixed $number expect float* Or can be an array of values* @param mixed $radix expect float* Or can be an array of values* @param mixed $minLength expect int or null* Or can be an array of values** @return array|string the text representation with the given radix (base)* If an array of numbers is passed as an argument, then the returned result will also be an array* with the same dimensions*/public static function evaluate(mixed $number, mixed $radix, mixed $minLength = null): array|string{if (is_array($number) || is_array($radix) || is_array($minLength)) {return self::evaluateArrayArguments([self::class, __FUNCTION__], $number, $radix, $minLength);}try {$number = (float) floor(Helpers::validateNumericNullBool($number));$radix = (int) Helpers::validateNumericNullBool($radix);} catch (Exception $e) {return $e->getMessage();}return self::calculate($number, $radix, $minLength);}private static function calculate(float $number, int $radix, mixed $minLength): string{if ($minLength === null || is_numeric($minLength)) {if ($number < 0 || $number >= 2 ** 53 || $radix < 2 || $radix > 36) {return ExcelError::NAN(); // Numeric range constraints}$outcome = strtoupper((string) base_convert("$number", 10, $radix));if ($minLength !== null) {$outcome = str_pad($outcome, (int) $minLength, '0', STR_PAD_LEFT); // String padding}return $outcome;}return ExcelError::VALUE();}}