# tablepress/3.4/libraries/vendor/PhpSpreadsheet/Calculation/TextData/CharacterConvert.php

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

- Page: https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Calculation/TextData/CharacterConvert.php
- Raw: https://pluginprobe.com/plugins/tablepress/3.4/raw/libraries/vendor/PhpSpreadsheet/Calculation/TextData/CharacterConvert.php
- Modified: 2026-02-17T04:58:24+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/TextData/CharacterConvert.php#L10-L20`.

```php
<?php

namespace TablePress\PhpOffice\PhpSpreadsheet\Calculation\TextData;

use TablePress\PhpOffice\PhpSpreadsheet\Calculation\ArrayEnabled;
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Exception as CalcExp;
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Functions;
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Information\ExcelError;
use TablePress\PhpOffice\PhpSpreadsheet\Shared\StringHelper;

class CharacterConvert
{
	use ArrayEnabled;

	private static string $oneByteCharacterSet = 'Windows-1252';

	/**
	 * CHAR.
	 *
	 * @param mixed $character Integer Value to convert to its character representation
	 *                              Or can be an array of values
	 *
	 * @return array<mixed>|string The character string
	 *         If an array of values is passed as the argument, then the returned result will also be an array
	 *            with the same dimensions
	 */
	public static function character($character)
	{
		if (is_array($character)) {
			return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $character);
		}

		return self::characterBoth($character, true);
	}

	/** @return array<mixed>|string
				 * @param mixed $character */
				public static function characterUnicode($character)
	{
		if (is_array($character)) {
			return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $character);
		}

		return self::characterBoth($character, false);
	}

	/**
				 * @param mixed $character
				 */
				private static function characterBoth($character, bool $ansi = true): string
	{
		try {
			$character = Helpers::validateInt($character, true);
		} catch (CalcExp $e) {
			return $e->getMessage();
		}

		if ($ansi && $character === 219 && self::$oneByteCharacterSet[0] === 'M') {
			return '€';
		}

		$min = Functions::getCompatibilityMode() === Functions::COMPATIBILITY_OPENOFFICE ? 0 : 1;
		if ($character < $min || ($ansi && $character > 255) || $character > 0x10FFFF) {
			return ExcelError::VALUE();
		}
		if ($character > 0x10FFFD) { // last assigned
			return ExcelError::NA();
		}
		if ($ansi) {
			$result = chr($character);

			return (string) iconv(self::$oneByteCharacterSet, 'UTF-8//IGNORE', $result);
		}

		return mb_chr($character, 'UTF-8');
	}

	/**
	 * CODE.
	 *
	 * @param mixed $characters String character to convert to its ASCII value
	 *                              Or can be an array of values
	 *
	 * @return array<mixed>|int|string A string if arguments are invalid
	 *         If an array of values is passed as the argument, then the returned result will also be an array
	 *            with the same dimensions
	 */
	public static function code($characters)
	{
		if (is_array($characters)) {
			return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $characters);
		}
		if (is_bool($characters) && Functions::getCompatibilityMode() === Functions::COMPATIBILITY_OPENOFFICE) {
			$characters = $characters ? '1' : '0';
		}

		return self::codeBoth(StringHelper::convertToString($characters, true, '', true), true);
	}

	/** @return array<mixed>|int|string
				 * @param mixed $characters */
				public static function codeUnicode($characters)
	{
		if (is_array($characters)) {
			return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $characters);
		}
		if (is_bool($characters) && Functions::getCompatibilityMode() === Functions::COMPATIBILITY_OPENOFFICE) {
			$characters = $characters ? '1' : '0';
		}

		return self::codeBoth(StringHelper::convertToString($characters, true, '', true), false);
	}

	/**
				 * @return int|string
				 */
				private static function codeBoth(string $characters, bool $ansi = true)
	{
		try {
			$characters = Helpers::extractString($characters, true);
		} catch (CalcExp $e) {
			return $e->getMessage();
		}

		if ($characters === '') {
			return ExcelError::VALUE();
		}

		$character = $characters;
		if (mb_strlen($characters, 'UTF-8') > 1) {
			$character = mb_substr($characters, 0, 1, 'UTF-8');
		}
		if ($ansi && $character === '€' && self::$oneByteCharacterSet[0] === 'M') {
			return 219;
		}

		$result = mb_ord($character, 'UTF-8');
		if ($ansi) {
			$result = iconv('UTF-8', self::$oneByteCharacterSet . '//IGNORE', $character);

			return ($result !== '') ? ord("$result") : 63; // question mark
		}

		return $result;
	}

	public static function setWindowsCharacterSet(): void
	{
		self::$oneByteCharacterSet = 'Windows-1252';
	}

	public static function setMacCharacterSet(): void
	{
		self::$oneByteCharacterSet = 'MAC';
	}
}

```