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

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

- Page: https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Reader/Xlsx/DataValidations.php
- Raw: https://pluginprobe.com/plugins/tablepress/3.4/raw/libraries/vendor/PhpSpreadsheet/Reader/Xlsx/DataValidations.php
- Modified: 2025-03-25T06:12: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/Xlsx/DataValidations.php#L10-L20`.

```php
<?php

namespace TablePress\PhpOffice\PhpSpreadsheet\Reader\Xlsx;

use TablePress\PhpOffice\PhpSpreadsheet\Cell\Coordinate;
use TablePress\PhpOffice\PhpSpreadsheet\Cell\DataValidation;
use TablePress\PhpOffice\PhpSpreadsheet\Reader\Xlsx;
use TablePress\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
use SimpleXMLElement;

class DataValidations
{
	private Worksheet $worksheet;

	private SimpleXMLElement $worksheetXml;

	public function __construct(Worksheet $workSheet, SimpleXMLElement $worksheetXml)
	{
		$this->worksheet = $workSheet;
		$this->worksheetXml = $worksheetXml;
	}

	public function load(): void
	{
		foreach ($this->worksheetXml->dataValidations->dataValidation as $dataValidation) {
			// Uppercase coordinate
			$range = strtoupper((string) $dataValidation['sqref']);
			$rangeSet = explode(' ', $range);
			foreach ($rangeSet as $range) {
				if (preg_match('/^[A-Z]{1,3}\d{1,7}/', $range, $matches) === 1) {
					// Ensure left/top row of range exists, thereby
					// adjusting high row/column.
					$this->worksheet->getCell($matches[0]);
				}
			}
		}
		foreach ($this->worksheetXml->dataValidations->dataValidation as $dataValidation) {
			// Uppercase coordinate
			$range = strtoupper((string) $dataValidation['sqref']);
			$docValidation = new DataValidation();
			$docValidation->setType((string) $dataValidation['type']);
			$docValidation->setErrorStyle((string) $dataValidation['errorStyle']);
			$docValidation->setOperator((string) $dataValidation['operator']);
			$docValidation->setAllowBlank(filter_var($dataValidation['allowBlank'], FILTER_VALIDATE_BOOLEAN));
			// showDropDown is inverted (works as hideDropDown if true)
			$docValidation->setShowDropDown(!filter_var($dataValidation['showDropDown'], FILTER_VALIDATE_BOOLEAN));
			$docValidation->setShowInputMessage(filter_var($dataValidation['showInputMessage'], FILTER_VALIDATE_BOOLEAN));
			$docValidation->setShowErrorMessage(filter_var($dataValidation['showErrorMessage'], FILTER_VALIDATE_BOOLEAN));
			$docValidation->setErrorTitle((string) $dataValidation['errorTitle']);
			$docValidation->setError((string) $dataValidation['error']);
			$docValidation->setPromptTitle((string) $dataValidation['promptTitle']);
			$docValidation->setPrompt((string) $dataValidation['prompt']);
			$docValidation->setFormula1(Xlsx::replacePrefixes((string) $dataValidation->formula1));
			$docValidation->setFormula2(Xlsx::replacePrefixes((string) $dataValidation->formula2));
			$this->worksheet->setDataValidation($range, $docValidation);
		}
	}
}

```