# tablepress/3.4/libraries/vendor/PhpSpreadsheet/Style/Conditional.php

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

- Page: https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Style/Conditional.php
- Raw: https://pluginprobe.com/plugins/tablepress/3.4/raw/libraries/vendor/PhpSpreadsheet/Style/Conditional.php
- Modified: 2025-08-28T14:52:54+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/Style/Conditional.php#L10-L20`.

```php
<?php

namespace TablePress\PhpOffice\PhpSpreadsheet\Style;

use TablePress\PhpOffice\PhpSpreadsheet\IComparable;
use TablePress\PhpOffice\PhpSpreadsheet\Style\ConditionalFormatting\ConditionalColorScale;
use TablePress\PhpOffice\PhpSpreadsheet\Style\ConditionalFormatting\ConditionalDataBar;
use TablePress\PhpOffice\PhpSpreadsheet\Style\ConditionalFormatting\ConditionalIconSet;

class Conditional implements IComparable
{
	// Condition types
	const CONDITION_NONE = 'none';
	const CONDITION_BEGINSWITH = 'beginsWith';
	const CONDITION_CELLIS = 'cellIs';
	const CONDITION_COLORSCALE = 'colorScale';
	const CONDITION_CONTAINSBLANKS = 'containsBlanks';
	const CONDITION_CONTAINSERRORS = 'containsErrors';
	const CONDITION_CONTAINSTEXT = 'containsText';
	const CONDITION_DATABAR = 'dataBar';
	const CONDITION_ENDSWITH = 'endsWith';
	const CONDITION_EXPRESSION = 'expression';
	const CONDITION_NOTCONTAINSBLANKS = 'notContainsBlanks';
	const CONDITION_NOTCONTAINSERRORS = 'notContainsErrors';
	const CONDITION_NOTCONTAINSTEXT = 'notContainsText';
	const CONDITION_TIMEPERIOD = 'timePeriod';
	const CONDITION_DUPLICATES = 'duplicateValues';
	const CONDITION_UNIQUE = 'uniqueValues';
	const CONDITION_ICONSET = 'iconSet';

	private const CONDITION_TYPES = [
		self::CONDITION_BEGINSWITH,
		self::CONDITION_CELLIS,
		self::CONDITION_COLORSCALE,
		self::CONDITION_CONTAINSBLANKS,
		self::CONDITION_CONTAINSERRORS,
		self::CONDITION_CONTAINSTEXT,
		self::CONDITION_DATABAR,
		self::CONDITION_DUPLICATES,
		self::CONDITION_ENDSWITH,
		self::CONDITION_EXPRESSION,
		self::CONDITION_NONE,
		self::CONDITION_NOTCONTAINSBLANKS,
		self::CONDITION_NOTCONTAINSERRORS,
		self::CONDITION_NOTCONTAINSTEXT,
		self::CONDITION_TIMEPERIOD,
		self::CONDITION_UNIQUE,
		self::CONDITION_ICONSET,
	];

	// Operator types
	const OPERATOR_NONE = '';
	const OPERATOR_BEGINSWITH = 'beginsWith';
	const OPERATOR_ENDSWITH = 'endsWith';
	const OPERATOR_EQUAL = 'equal';
	const OPERATOR_GREATERTHAN = 'greaterThan';
	const OPERATOR_GREATERTHANOREQUAL = 'greaterThanOrEqual';
	const OPERATOR_LESSTHAN = 'lessThan';
	const OPERATOR_LESSTHANOREQUAL = 'lessThanOrEqual';
	const OPERATOR_NOTEQUAL = 'notEqual';
	const OPERATOR_CONTAINSTEXT = 'containsText';
	const OPERATOR_NOTCONTAINS = 'notContains';
	const OPERATOR_BETWEEN = 'between';
	const OPERATOR_NOTBETWEEN = 'notBetween';

	const TIMEPERIOD_TODAY = 'today';
	const TIMEPERIOD_YESTERDAY = 'yesterday';
	const TIMEPERIOD_TOMORROW = 'tomorrow';
	const TIMEPERIOD_LAST_7_DAYS = 'last7Days';
	const TIMEPERIOD_LAST_WEEK = 'lastWeek';
	const TIMEPERIOD_THIS_WEEK = 'thisWeek';
	const TIMEPERIOD_NEXT_WEEK = 'nextWeek';
	const TIMEPERIOD_LAST_MONTH = 'lastMonth';
	const TIMEPERIOD_THIS_MONTH = 'thisMonth';
	const TIMEPERIOD_NEXT_MONTH = 'nextMonth';

	/**
	 * Condition type.
	 */
	private string $conditionType = self::CONDITION_NONE;

	/**
	 * Operator type.
	 */
	private string $operatorType = self::OPERATOR_NONE;

	/**
	 * Text.
	 */
	private string $text = '';

	/**
	 * Stop on this condition, if it matches.
	 */
	private bool $stopIfTrue = false;

	/**
	 * Condition.
	 *
	 * @var (bool|float|int|string)[]
	 */
	private array $condition = [];

	private ?ConditionalDataBar $dataBar = null;

	private ?ConditionalColorScale $colorScale = null;

	private ?ConditionalIconSet $iconSet = null;

	private Style $style;

	private bool $noFormatSet = false;

	private int $priority = 0;

	/**
	 * Create a new Conditional.
	 */
	public function __construct()
	{
		// Initialise values
		$this->style = new Style(false, true);
	}

	public function getPriority(): int
	{
		return $this->priority;
	}

	public function setPriority(int $priority): self
	{
		$this->priority = $priority;

		return $this;
	}

	public function getNoFormatSet(): bool
	{
		return $this->noFormatSet;
	}

	public function setNoFormatSet(bool $noFormatSet): self
	{
		$this->noFormatSet = $noFormatSet;

		return $this;
	}

	/**
	 * Get Condition type.
	 */
	public function getConditionType(): string
	{
		return $this->conditionType;
	}

	/**
	 * Set Condition type.
	 *
	 * @param string $type Condition type, see self::CONDITION_*
	 *
	 * @return $this
	 */
	public function setConditionType(string $type)
	{
		$this->conditionType = $type;

		return $this;
	}

	/**
	 * Get Operator type.
	 */
	public function getOperatorType(): string
	{
		return $this->operatorType;
	}

	/**
	 * Set Operator type.
	 *
	 * @param string $type Conditional operator type, see self::OPERATOR_*
	 *
	 * @return $this
	 */
	public function setOperatorType(string $type)
	{
		$this->operatorType = $type;

		return $this;
	}

	/**
	 * Get text.
	 */
	public function getText(): string
	{
		return $this->text;
	}

	/**
	 * Set text.
	 *
	 * @return $this
	 */
	public function setText(string $text)
	{
		$this->text = $text;

		return $this;
	}

	/**
	 * Get StopIfTrue.
	 */
	public function getStopIfTrue(): bool
	{
		return $this->stopIfTrue;
	}

	/**
	 * Set StopIfTrue.
	 *
	 * @return $this
	 */
	public function setStopIfTrue(bool $stopIfTrue)
	{
		$this->stopIfTrue = $stopIfTrue;

		return $this;
	}

	/**
	 * Get Conditions.
	 *
	 * @return (bool|float|int|string)[]
	 */
	public function getConditions(): array
	{
		return $this->condition;
	}

	/**
	 * Set Conditions.
	 *
	 * @param bool|(bool|float|int|string)[]|float|int|string $conditions Condition
	 *
	 * @return $this
	 */
	public function setConditions($conditions)
	{
		if (!is_array($conditions)) {
			$conditions = [$conditions];
		}
		$this->condition = $conditions;

		return $this;
	}

	/**
	 * Add Condition.
	 *
	 * @param bool|float|int|string $condition Condition
	 *
	 * @return $this
	 */
	public function addCondition($condition)
	{
		$this->condition[] = $condition;

		return $this;
	}

	/**
				 * Get Style.
				 * @param mixed $cellData
				 */
				public function getStyle($cellData = null): Style
	{
		if ($this->conditionType === self::CONDITION_COLORSCALE && $cellData !== null && $this->colorScale !== null && is_numeric($cellData)) {
			$style = new Style(false, true);
			$style->getFill()->setFillType(Fill::FILL_SOLID);
			$style->getFill()->getStartColor()->setARGB($this->colorScale->getColorForValue((float) $cellData));

			return $style;
		}

		return $this->style;
	}

	/**
	 * Set Style.
	 *
	 * @return $this
	 */
	public function setStyle(Style $style)
	{
		$this->style = $style;

		return $this;
	}

	public function getDataBar(): ?ConditionalDataBar
	{
		return $this->dataBar;
	}

	/**
				 * @return static
				 */
				public function setDataBar(ConditionalDataBar $dataBar)
	{
		$this->dataBar = $dataBar;

		return $this;
	}

	public function getColorScale(): ?ConditionalColorScale
	{
		return $this->colorScale;
	}

	/**
				 * @return static
				 */
				public function setColorScale(ConditionalColorScale $colorScale)
	{
		$this->colorScale = $colorScale;

		return $this;
	}

	public function getIconSet(): ?ConditionalIconSet
	{
		return $this->iconSet;
	}

	/**
				 * @return static
				 */
				public function setIconSet(ConditionalIconSet $iconSet)
	{
		$this->iconSet = $iconSet;

		return $this;
	}

	/**
	 * Get hash code.
	 *
	 * @return string Hash code
	 */
	public function getHashCode(): string
	{
		return md5(
			$this->conditionType
				. $this->operatorType
				. implode(';', $this->condition)
				. $this->style->getHashCode()
				. __CLASS__
		);
	}

	/**
	 * Implement PHP __clone to create a deep clone, not just a shallow copy.
	 */
	public function __clone()
	{
		$vars = get_object_vars($this);
		foreach ($vars as $key => $value) {
			if (is_object($value)) {
				$this->$key = clone $value;
			} else {
				$this->$key = $value;
			}
		}
	}

	/**
	 * Verify if param is valid condition type.
	 */
	public static function isValidConditionType(string $type): bool
	{
		return in_array($type, self::CONDITION_TYPES);
	}
}

```