# tablepress/3.4/libraries/vendor/PhpSpreadsheet/Calculation/Engine/FormattedNumber.php

TablePress – Tables in WordPress made easy, version 3.4. 140 lines.

- Page: https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Calculation/Engine/FormattedNumber.php
- Raw: https://pluginprobe.com/plugins/tablepress/3.4/raw/libraries/vendor/PhpSpreadsheet/Calculation/Engine/FormattedNumber.php
- Modified: 2025-08-26T04:06:14+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Calculation/Engine/FormattedNumber.php#L10-L20`.

```php
<?php

namespace TablePress\PhpOffice\PhpSpreadsheet\Calculation\Engine;

use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Calculation;
use TablePress\PhpOffice\PhpSpreadsheet\Shared\StringHelper;

class FormattedNumber
{
	/**    Constants                */
	/**    Regular Expressions        */
	private const STRING_REGEXP_FRACTION = '~^\s*(-?)((\d*)\s+)?(\d+\/\d+)\s*$~';

	private const STRING_REGEXP_PERCENT = '~^(?:(?: *(?<PrefixedSign>[-+])? *\% *(?<PrefixedSign2>[-+])? *(?<PrefixedValue>[0-9]+\.?[0-9*]*(?:E[-+]?[0-9]*)?) *)|(?: *(?<PostfixedSign>[-+])? *(?<PostfixedValue>[0-9]+\.?[0-9]*(?:E[-+]?[0-9]*)?) *\% *))$~i';

	// preg_quoted string for major currency symbols, with a %s for locale currency
	private const CURRENCY_CONVERSION_LIST = '\$€£¥%s';

	/**
	 * Identify whether a string contains a formatted numeric value,
	 * and convert it to a numeric if it is.
	 *
	 * @param float|string $operand string value to test
	 */
	public static function convertToNumberIfFormatted(&$operand): bool
	{
		return self::convertToNumberIfNumeric($operand)
			|| self::convertToNumberIfFraction($operand)
			|| self::convertToNumberIfPercent($operand)
			|| self::convertToNumberIfCurrency($operand);
	}

	/**
	 * Identify whether a string contains a numeric value,
	 * and convert it to a numeric if it is.
	 *
	 * @param float|string $operand string value to test
	 */
	public static function convertToNumberIfNumeric(&$operand): bool
	{
		$thousandsSeparator = preg_quote(StringHelper::getThousandsSeparator(), '/');
		$value = preg_replace(['/(\d)' . $thousandsSeparator . '(\d)/u', '/([+-])\s+(\d)/u'], ['$1$2', '$1$2'], trim("$operand"));
		$decimalSeparator = preg_quote(StringHelper::getDecimalSeparator(), '/');
		$value = preg_replace(['/(\d)' . $decimalSeparator . '(\d)/u', '/([+-])\s+(\d)/u'], ['$1.$2', '$1$2'], $value ?? '');

		if (is_numeric($value)) {
			$operand = (float) $value;

			return true;
		}

		return false;
	}

	/**
	 * Identify whether a string contains a fractional numeric value,
	 * and convert it to a numeric if it is.
	 *
	 * @param string $operand string value to test
	 */
	public static function convertToNumberIfFraction(&$operand): bool
	{
		if (is_string($operand) && preg_match(self::STRING_REGEXP_FRACTION, $operand, $match)) {
			$sign = ($match[1] === '-') ? '-' : '+';
			$wholePart = ($match[3] === '') ? '' : ($sign . $match[3]);
			$fractionFormula = '=' . $wholePart . $sign . $match[4];
			/** @var string */
			$operandx = Calculation::getInstance()->_calculateFormulaValue($fractionFormula);
			$operand = $operandx;

			return true;
		}

		return false;
	}

	/**
	 * Identify whether a string contains a percentage, and if so,
	 * convert it to a numeric.
	 *
	 * @param float|string $operand string value to test
	 */
	public static function convertToNumberIfPercent(&$operand): bool
	{
		$thousandsSeparator = preg_quote(StringHelper::getThousandsSeparator(), '/');
		$value = preg_replace('/(\d)' . $thousandsSeparator . '(\d)/u', '$1$2', trim("$operand"));
		$decimalSeparator = preg_quote(StringHelper::getDecimalSeparator(), '/');
		$value = preg_replace(['/(\d)' . $decimalSeparator . '(\d)/u', '/([+-])\s+(\d)/u'], ['$1.$2', '$1$2'], $value ?? '');

		$match = [];
		if ($value !== null && preg_match(self::STRING_REGEXP_PERCENT, $value, $match, PREG_UNMATCHED_AS_NULL)) {
			//Calculate the percentage
			$sign = ($match['PrefixedSign'] ?? $match['PrefixedSign2'] ?? $match['PostfixedSign']) ?? '';
			$operand = (float) ($sign . ($match['PostfixedValue'] ?? $match['PrefixedValue'])) / 100;

			return true;
		}

		return false;
	}

	/**
	 * Identify whether a string contains a currency value, and if so,
	 * convert it to a numeric.
	 *
	 * @param float|string $operand string value to test
	 */
	public static function convertToNumberIfCurrency(&$operand): bool
	{
		$currencyRegexp = self::currencyMatcherRegexp();
		$thousandsSeparator = preg_quote(StringHelper::getThousandsSeparator(), '/');
		$value = preg_replace('/(\d)' . $thousandsSeparator . '(\d)/u', '$1$2', "$operand");

		$match = [];
		if ($value !== null && preg_match($currencyRegexp, $value, $match, PREG_UNMATCHED_AS_NULL)) {
			//Determine the sign
			$sign = ($match['PrefixedSign'] ?? $match['PrefixedSign2'] ?? $match['PostfixedSign']) ?? '';
			$decimalSeparator = StringHelper::getDecimalSeparator();
			//Cast to a float
			$intermediate = (string) ($match['PostfixedValue'] ?? $match['PrefixedValue']);
			$intermediate = str_replace($decimalSeparator, '.', $intermediate);
			if (is_numeric($intermediate)) {
				$operand = (float) ($sign . str_replace($decimalSeparator, '.', $intermediate));

				return true;
			}
		}

		return false;
	}

	public static function currencyMatcherRegexp(): string
	{
		$currencyCodes = sprintf(self::CURRENCY_CONVERSION_LIST, preg_quote(StringHelper::getCurrencyCode(), '/'));
		$decimalSeparator = preg_quote(StringHelper::getDecimalSeparator(), '/');

		return '~^(?:(?: *(?<PrefixedSign>[-+])? *(?<PrefixedCurrency>[' . $currencyCodes . ']) *(?<PrefixedSign2>[-+])? *(?<PrefixedValue>[0-9]+[' . $decimalSeparator . ']?[0-9*]*(?:E[-+]?[0-9]*)?) *)|(?: *(?<PostfixedSign>[-+])? *(?<PostfixedValue>[0-9]+' . $decimalSeparator . '?[0-9]*(?:E[-+]?[0-9]*)?) *(?<PostfixedCurrency>[' . $currencyCodes . ']) *))$~ui';
	}
}

```