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

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

- Page: https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Calculation/TextData/Concatenate.php
- Raw: https://pluginprobe.com/plugins/tablepress/3.4/raw/libraries/vendor/PhpSpreadsheet/Calculation/TextData/Concatenate.php
- Modified: 2026-04-07T08:40:50+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/Concatenate.php#L10-L20`.

```php
<?php

namespace TablePress\PhpOffice\PhpSpreadsheet\Calculation\TextData;

use TablePress\PhpOffice\PhpSpreadsheet\Calculation\ArrayEnabled;
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Calculation;
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Functions;
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Information\ErrorValue;
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Information\ExcelError;
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Internal\ExcelArrayPseudoFunctions;
use TablePress\PhpOffice\PhpSpreadsheet\Cell\Cell;
use TablePress\PhpOffice\PhpSpreadsheet\Cell\DataType;
use TablePress\PhpOffice\PhpSpreadsheet\Shared\StringHelper;

class Concatenate
{
	use ArrayEnabled;

	/**
	 * This implements the CONCAT function, *not* CONCATENATE.
	 *
	 * @param mixed $args data to be concatenated
	 */
	public static function CONCATENATE(...$args): string
	{
		$returnValue = '';

		// Loop through arguments
		$aArgs = Functions::flattenArray($args);

		foreach ($aArgs as $arg) {
			$value = Helpers::extractString($arg);
			if (ErrorValue::isError($value, true)) {
				$returnValue = $value;

				break;
			}
			$returnValue .= Helpers::extractString($arg);
			if (StringHelper::countCharacters($returnValue) > DataType::MAX_STRING_LENGTH) {
				$returnValue = ExcelError::CALC();

				break;
			}
		}

		return $returnValue;
	}

	/**
	 * This implements the CONCATENATE function.
	 *
	 * @param mixed $args data to be concatenated
	 *
	 * @return array<string>|string
	 */
	public static function actualCONCATENATE(...$args)
	{
		$useSingle = false;
		$cell = null;
		$count = count($args);
		if ($args[$count - 1] instanceof Cell) {
			/** @var Cell */
			$cell = array_pop($args);
			$type = (($nullsafeVariable1 = $cell->getWorksheet()->getParent()) ? $nullsafeVariable1->getCalculationEngine()->getInstanceArrayReturnType() : null) ?? Calculation::getArrayReturnType();
			$useSingle = $type === Calculation::RETURN_ARRAY_AS_VALUE;
		}
		if (Functions::getCompatibilityMode() === Functions::COMPATIBILITY_GNUMERIC) {
			return self::CONCATENATE(...$args);
		}
		$result = '';
		foreach ($args as $operand2) {
			if ($useSingle && $cell instanceof Cell && is_array($operand2)) {
				$temp = Functions::convertArrayToCellRange($operand2);
				if ($temp !== '') {
					$operand2 = ExcelArrayPseudoFunctions::single($temp, $cell);
				}
			}
			/** @var null|array<mixed>|bool|float|int|string $operand2 */
			$result = self::concatenate2Args($result, $operand2);
			if (ErrorValue::isError($result, true) === true) {
				break;
			}
		}

		return $result;
	}

	/**
	 * @param array<string>|string $operand1
	 * @param null|array<mixed>|bool|float|int|string $operand2
	 *
	 * @return array<string>|string
	 */
	private static function concatenate2Args($operand1, $operand2)
	{
		if (is_array($operand1) || is_array($operand2)) {
			$operand1 = Calculation::boolToString($operand1);
			$operand2 = Calculation::boolToString($operand2);
			[$rows, $columns] = Calculation::checkMatrixOperands($operand1, $operand2, 2);
			$errorFound = false;
			for ($row = 0; $row < $rows && !$errorFound; ++$row) {
				for ($column = 0; $column < $columns; ++$column) {
					/** @var string[][] $operand2 */
					if (ErrorValue::isError($operand2[$row][$column])) {
						return $operand2[$row][$column];
					}
					/** @var string[][] $operand1 */
					$operand1[$row][$column]
						= StringHelper::convertToString($operand1[$row][$column], true, '', true)
						. StringHelper::convertToString($operand2[$row][$column], true, '', true);
					if (mb_strlen($operand1[$row][$column]) > DataType::MAX_STRING_LENGTH) {
						$operand1 = ExcelError::CALC();
						$errorFound = true;

						break;
					}
				}
			}
		} elseif (ErrorValue::isError($operand2, true) === true) {
			$operand1 = (string) $operand2;
		} else {
			$operand1 .= StringHelper::convertToString($operand2, true, '', true);
			if (mb_strlen($operand1) > DataType::MAX_STRING_LENGTH) {
				$operand1 = ExcelError::CALC();
			}
		}
		/** @var array<string>|string $operand1 */

		return $operand1;
	}

	/**
	 * TEXTJOIN.
	 *
	 * @param null|string|string[] $delimiter The delimiter to use between the joined arguments
	 *                         Or can be an array of values
	 * @param null|bool|bool[] $ignoreEmpty true/false Flag indicating whether empty arguments should be skipped
	 *                         Or can be an array of values
	 * @param mixed $args The values to join
	 *
	 * @return array<mixed>|string The joined string
	 *         If an array of values is passed for the $delimiter or $ignoreEmpty arguments, then the returned result
	 *            will also be an array with matching dimensions
	 */
	public static function TEXTJOIN($delimiter = '', $ignoreEmpty = true, ...$args)
	{
		if (is_array($delimiter) || is_array($ignoreEmpty)) {
			return self::evaluateArrayArgumentsSubset(
				[self::class, __FUNCTION__],
				2,
				$delimiter,
				$ignoreEmpty,
				...$args
			);
		}

		$delimiter ??= '';
		$ignoreEmpty ??= true;
		/** @var mixed[] */
		$aArgs = Functions::flattenArray($args);
		$returnValue = self::evaluateTextJoinArray($ignoreEmpty, $aArgs);

		/** @var string[] $aArgs */
		$returnValue ??= implode($delimiter, $aArgs);
		if (StringHelper::countCharacters($returnValue) > DataType::MAX_STRING_LENGTH) {
			$returnValue = ExcelError::CALC();
		}

		return $returnValue;
	}

	/** @param mixed[] $aArgs */
	private static function evaluateTextJoinArray(bool $ignoreEmpty, array &$aArgs): ?string
	{
		foreach ($aArgs as $key => &$arg) {
			$value = Helpers::extractString($arg);
			if (ErrorValue::isError($value, true)) {
				return $value;
			}

			if ($ignoreEmpty === true && ((is_string($arg) && trim($arg) === '') || $arg === null)) {
				unset($aArgs[$key]);
			} elseif (is_bool($arg)) {
				$arg = Helpers::convertBooleanValue($arg);
			}
		}

		return null;
	}

	/**
	 * REPT.
	 *
	 * Returns the result of builtin function round after validating args.
	 *
	 * @param mixed $stringValue The value to repeat
	 *                         Or can be an array of values
	 * @param mixed $repeatCount The number of times the string value should be repeated
	 *                         Or can be an array of values
	 *
	 * @return array<mixed>|string The repeated string
	 *         If an array of values is passed for the $stringValue or $repeatCount arguments, then the returned result
	 *            will also be an array with matching dimensions
	 */
	public static function builtinREPT($stringValue, $repeatCount)
	{
		if (is_array($stringValue) || is_array($repeatCount)) {
			return self::evaluateArrayArguments([self::class, __FUNCTION__], $stringValue, $repeatCount);
		}

		$stringValue = Helpers::extractString($stringValue);

		if (!is_numeric($repeatCount) || $repeatCount < 0) {
			$returnValue = ExcelError::VALUE();
		} elseif (ErrorValue::isError($stringValue, true)) {
			$returnValue = $stringValue;
		} else {
			$returnValue = str_repeat($stringValue, (int) $repeatCount);
			if (StringHelper::countCharacters($returnValue) > DataType::MAX_STRING_LENGTH) {
				$returnValue = ExcelError::VALUE(); // note VALUE not CALC
			}
		}

		return $returnValue;
	}
}

```