# tablepress/3.4/libraries/vendor/PhpSpreadsheet/Reader/Xml/DataValidations.php

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

- Page: https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Reader/Xml/DataValidations.php
- Raw: https://pluginprobe.com/plugins/tablepress/3.4/raw/libraries/vendor/PhpSpreadsheet/Reader/Xml/DataValidations.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/Reader/Xml/DataValidations.php#L10-L20`.

```php
<?php

namespace TablePress\PhpOffice\PhpSpreadsheet\Reader\Xml;

use TablePress\PhpOffice\PhpSpreadsheet\Cell\AddressHelper;
use TablePress\PhpOffice\PhpSpreadsheet\Cell\Coordinate;
use TablePress\PhpOffice\PhpSpreadsheet\Cell\DataValidation;
use TablePress\PhpOffice\PhpSpreadsheet\Reader\Xlsx\Namespaces;
use TablePress\PhpOffice\PhpSpreadsheet\Spreadsheet;
use SimpleXMLElement;

class DataValidations
{
	private const OPERATOR_MAPPINGS = [
		'between' => DataValidation::OPERATOR_BETWEEN,
		'equal' => DataValidation::OPERATOR_EQUAL,
		'greater' => DataValidation::OPERATOR_GREATERTHAN,
		'greaterorequal' => DataValidation::OPERATOR_GREATERTHANOREQUAL,
		'less' => DataValidation::OPERATOR_LESSTHAN,
		'lessorequal' => DataValidation::OPERATOR_LESSTHANOREQUAL,
		'notbetween' => DataValidation::OPERATOR_NOTBETWEEN,
		'notequal' => DataValidation::OPERATOR_NOTEQUAL,
	];

	private const TYPE_MAPPINGS = [
		'textlength' => DataValidation::TYPE_TEXTLENGTH,
	];

	private int $thisRow = 0;

	private int $thisColumn = 0;

	/** @param string[] $matches */
	private function replaceR1C1(array $matches): string
	{
		return AddressHelper::convertToA1($matches[0], $this->thisRow, $this->thisColumn, false);
	}

	public function loadDataValidations(SimpleXMLElement $worksheet, Spreadsheet $spreadsheet): void
	{
		$xmlX = $worksheet->children(Namespaces::URN_EXCEL);
		$sheet = $spreadsheet->getActiveSheet();
		/** @var callable $pregCallback */
		$pregCallback = [$this, 'replaceR1C1'];
		foreach ($xmlX->DataValidation as $dataValidation) {
			$combinedCells = '';
			$separator = '';
			$validation = new DataValidation();

			// set defaults
			$validation->setShowDropDown(true);
			$validation->setShowInputMessage(true);
			$validation->setShowErrorMessage(true);
			$validation->setShowDropDown(true);
			$this->thisRow = 1;
			$this->thisColumn = 1;

			foreach ($dataValidation as $tagName => $tagValue) {
				$tagValue = (string) $tagValue;
				$tagValueLower = strtolower($tagValue);
				switch ($tagName) {
					case 'Range':
						foreach (explode(',', $tagValue) as $range) {
							$cell = '';
							if (preg_match('/^R(\d+)C(\d+):R(\d+)C(\d+)$/', (string) $range, $selectionMatches) === 1) {
								// range
								$firstCell = Coordinate::stringFromColumnIndex((int) $selectionMatches[2])
									. $selectionMatches[1];
								$cell = $firstCell
									. ':'
									. Coordinate::stringFromColumnIndex((int) $selectionMatches[4])
									. $selectionMatches[3];
								$this->thisRow = (int) $selectionMatches[1];
								$this->thisColumn = (int) $selectionMatches[2];
								$sheet->getCell($firstCell);
								$combinedCells .= "$separator$cell";
								$separator = ' ';
							} elseif (preg_match('/^R(\d+)C(\d+)$/', (string) $range, $selectionMatches) === 1) {
								// cell
								$cell = Coordinate::stringFromColumnIndex((int) $selectionMatches[2])
									. $selectionMatches[1];
								$sheet->getCell($cell);
								$this->thisRow = (int) $selectionMatches[1];
								$this->thisColumn = (int) $selectionMatches[2];
								$combinedCells .= "$separator$cell";
								$separator = ' ';
							} elseif (preg_match('/^C(\d+)(:C(]\d+))?$/', (string) $range, $selectionMatches) === 1) {
								// column
								$firstCol = $selectionMatches[1];
								$firstColString = Coordinate::stringFromColumnIndex((int) $firstCol);
								$lastCol = $selectionMatches[3] ?? $firstCol;
								$lastColString = Coordinate::stringFromColumnIndex((int) $lastCol);
								$firstCell = "{$firstColString}1";
								$cell = "$firstColString:$lastColString";
								$this->thisColumn = (int) $firstCol;
								$sheet->getCell($firstCell);
								$combinedCells .= "$separator$cell";
								$separator = ' ';
							} elseif (preg_match('/^R(\d+)(:R(]\d+))?$/', (string) $range, $selectionMatches)) {
								// row
								$firstRow = $selectionMatches[1];
								$lastRow = $selectionMatches[3] ?? $firstRow;
								$firstCell = "A$firstRow";
								$cell = "$firstRow:$lastRow";
								$this->thisRow = (int) $firstRow;
								$sheet->getCell($firstCell);
								$combinedCells .= "$separator$cell";
								$separator = ' ';
							}
						}

						break;
					case 'Type':
						$validation->setType(self::TYPE_MAPPINGS[$tagValueLower] ?? $tagValueLower);

						break;
					case 'Qualifier':
						$validation->setOperator(self::OPERATOR_MAPPINGS[$tagValueLower] ?? $tagValueLower);

						break;
					case 'InputTitle':
						$validation->setPromptTitle($tagValue);

						break;
					case 'InputMessage':
						$validation->setPrompt($tagValue);

						break;
					case 'InputHide':
						$validation->setShowInputMessage(false);

						break;
					case 'ErrorStyle':
						$validation->setErrorStyle($tagValueLower);

						break;
					case 'ErrorTitle':
						$validation->setErrorTitle($tagValue);

						break;
					case 'ErrorMessage':
						$validation->setError($tagValue);

						break;
					case 'ErrorHide':
						$validation->setShowErrorMessage(false);

						break;
					case 'ComboHide':
						$validation->setShowDropDown(false);

						break;
					case 'UseBlank':
						$validation->setAllowBlank(true);

						break;
					case 'CellRangeList':
						// FIXME missing FIXME

						break;
					case 'Min':
					case 'Value':
						$tagValue = (string) preg_replace_callback(AddressHelper::R1C1_COORDINATE_REGEX, $pregCallback, $tagValue);
						$validation->setFormula1($tagValue);

						break;
					case 'Max':
						$tagValue = (string) preg_replace_callback(AddressHelper::R1C1_COORDINATE_REGEX, $pregCallback, $tagValue);
						$validation->setFormula2($tagValue);

						break;
				}
			}

			$sheet->setDataValidation($combinedCells, $validation);
		}
	}
}

```