wpdatatables / lib / phpoffice / phpspreadsheet / src / PhpSpreadsheet / Calculation / TextData / CharacterConvert.php

CharacterConvert.php in wpDataTables – WordPress Data Table, Dynamic Tables & Table Charts Plugin 6.5.1.7, at lib/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/TextData/CharacterConvert.php

82 lines 2.5 KB

Raw Download Zip

1	<?php
2
3	namespace PhpOffice\PhpSpreadsheet\Calculation\TextData;
4
5	use PhpOffice\PhpSpreadsheet\Calculation\ArrayEnabled;
6	use PhpOffice\PhpSpreadsheet\Calculation\Functions;
7	use PhpOffice\PhpSpreadsheet\Calculation\Information\ExcelError;
8
9	class CharacterConvert
10	{
11	use ArrayEnabled;
12
13	/**
14	* CHAR.
15	*
16	* @param mixed $character Integer Value to convert to its character representation
17	* Or can be an array of values
18	*
19	* @return array\|string The character string
20	* If an array of values is passed as the argument, then the returned result will also be an array
21	* with the same dimensions
22	*/
23	public static function character($character)
24	{
25	if (is_array($character)) {
26	return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $character);
27	}
28
29	$character = Helpers::validateInt($character);
30	$min = Functions::getCompatibilityMode() === Functions::COMPATIBILITY_OPENOFFICE ? 0 : 1;
31	if ($character < $min \|\| $character > 255) {
32	return ExcelError::VALUE();
33	}
34	$result = iconv('UCS-4LE', 'UTF-8', pack('V', $character));
35
36	return ($result === false) ? '' : $result;
37	}
38
39	/**
40	* CODE.
41	*
42	* @param mixed $characters String character to convert to its ASCII value
43	* Or can be an array of values
44	*
45	* @return array\|int\|string A string if arguments are invalid
46	* If an array of values is passed as the argument, then the returned result will also be an array
47	* with the same dimensions
48	*/
49	public static function code($characters)
50	{
51	if (is_array($characters)) {
52	return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $characters);
53	}
54
55	$characters = Helpers::extractString($characters);
56	if ($characters === '') {
57	return ExcelError::VALUE();
58	}
59
60	$character = $characters;
61	if (mb_strlen($characters, 'UTF-8') > 1) {
62	$character = mb_substr($characters, 0, 1, 'UTF-8');
63	}
64
65	return self::unicodeToOrd($character);
66	}
67
68	private static function unicodeToOrd(string $character): int
69	{
70	$retVal = 0;
71	$iconv = iconv('UTF-8', 'UCS-4LE', $character);
72	if ($iconv !== false) {
73	$result = unpack('V', $iconv);
74	if (is_array($result) && isset($result[1])) {
75	$retVal = $result[1];
76	}
77	}
78
79	return $retVal;
80	}
81	}
82