# tablepress/3.4/libraries/vendor/PhpSpreadsheet/Style/ConditionalFormatting/MergedCellStyle.php

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

- Page: https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Style/ConditionalFormatting/MergedCellStyle.php
- Raw: https://pluginprobe.com/plugins/tablepress/3.4/raw/libraries/vendor/PhpSpreadsheet/Style/ConditionalFormatting/MergedCellStyle.php
- Modified: 2026-02-17T04:58:24+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/ConditionalFormatting/MergedCellStyle.php#L10-L20`.

```php
<?php

namespace TablePress\PhpOffice\PhpSpreadsheet\Style\ConditionalFormatting;

use TablePress\PhpOffice\PhpSpreadsheet\Style\Fill;
use TablePress\PhpOffice\PhpSpreadsheet\Style\Style;
use TablePress\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;

class MergedCellStyle
{
	private bool $matched = false;

	/**
	 * Indicate whether the last call to getMergedStyle found
	 * any conditional or table styles affecting the cell in question.
	 */
	public function getMatched(): bool
	{
		return $this->matched;
	}

	/**
	 * Return a style that combines the base style for a cell
	 * with any conditional or table styles applicable to the cell.
	 *
	 * @param bool $tableFormats True/false to indicate whether
	 *        custom table styles should be considered.
	 *        Note that builtin table styles are not supported.
	 * @param bool $conditionals True/false to indicate whether
	 *        conditional styles should be considered.
	 */
	public function getMergedStyle(Worksheet $worksheet, string $coordinate, bool $tableFormats = true, bool $conditionals = true, ?bool $builtInTableStyles = null): Style
	{
		$builtInTableStyles ??= $tableFormats;
		$this->matched = false;
		$styleMerger = new StyleMerger($worksheet->getStyle($coordinate));
		if ($tableFormats) {
			$this->assessTables($worksheet, $coordinate, $styleMerger);
		}
		if ($builtInTableStyles) {
			$this->assessBuiltinTables($worksheet, $coordinate, $styleMerger);
		}
		if ($conditionals) {
			$this->assessConditionals($worksheet, $coordinate, $styleMerger);
		}

		return $styleMerger->getStyle();
	}

	private function assessTables(Worksheet $worksheet, string $coordinate, StyleMerger $styleMerger): void
	{
		$tables = $worksheet->getTablesWithStylesForCell($worksheet->getCell($coordinate));
		foreach ($tables as $ts) {
			$dxfsTableStyle = $ts->getStyle()->getTableDxfsStyle();
			if ($dxfsTableStyle !== null) {
				$tableRow = $ts->getRowNumber($coordinate);
				if ($tableRow === 0 && $dxfsTableStyle->getHeaderRowStyle() !== null) {
					$styleMerger->mergeStyle(
						$dxfsTableStyle->getHeaderRowStyle()
					);
					$this->matched = true;
				} elseif ($tableRow % 2 === 1 && $dxfsTableStyle->getFirstRowStripeStyle() !== null) {
					$styleMerger->mergeStyle(
						$dxfsTableStyle->getFirstRowStripeStyle()
					);
					$this->matched = true;
				} elseif ($tableRow % 2 === 0 && $dxfsTableStyle->getSecondRowStripeStyle() !== null) {
					$styleMerger->mergeStyle(
						$dxfsTableStyle->getSecondRowStripeStyle()
					);
					$this->matched = true;
				}
			}
		}
	}

	private static ?Style $headerStyle = null;

	private static ?Style $firstRowStyle = null;

	private function assessBuiltinTables(Worksheet $worksheet, string $coordinate, StyleMerger $styleMerger): void
	{
		if (self::$headerStyle === null) {
			self::$headerStyle = new Style();
			self::$headerStyle->getFill()
				->setFillType(Fill::FILL_SOLID)
				->getEndColor()
				->setArgb('FF000000');
			self::$headerStyle->getFill()->getStartColor()
				->setArgb('FF000000');
			self::$headerStyle->getFont()
				->getColor()->setRgb('FFFFFF');
		}
		if (self::$firstRowStyle === null) {
			self::$firstRowStyle = new Style();
			self::$firstRowStyle->getFill()
				->setFillType(Fill::FILL_SOLID)
				->getEndColor()
				->setArgb('FFD9D9D9');
			self::$firstRowStyle->getFill()->getStartColor()
				->setArgb('FFD9D9D9');
		}
		$tables = $worksheet->getTablesWithoutStylesForCell($worksheet->getCell($coordinate));
		foreach ($tables as $table) {
			$tableRow = $table->getRowNumber($coordinate);
			if ($tableRow === 0 && $table->getShowHeaderRow()) {
				$styleMerger->mergeStyle(self::$headerStyle);
				$this->matched = true;
			} elseif ($tableRow % 2 === 1) {
				$styleMerger->mergeStyle(self::$firstRowStyle);
				$this->matched = true;
			}
		}
	}

	private function assessConditionals(Worksheet $worksheet, string $coordinate, StyleMerger $styleMerger): void
	{
		if ($worksheet->getConditionalRange($coordinate) !== null) {
			$assessor = new CellStyleAssessor($worksheet->getCell($coordinate), $worksheet->getConditionalRange($coordinate));
		} else {
			$assessor = new CellStyleAssessor($worksheet->getCell($coordinate), $coordinate);
		}
		$matchedStyle = $assessor
			->matchConditionsReturnNullIfNoneMatched(
				$worksheet->getConditionalStyles($coordinate),
				$worksheet->getCell($coordinate)
					->getCalculatedValueString(),
				true
			);
		if ($matchedStyle !== null) {
			$this->matched = true;
			$styleMerger->mergeStyle($matchedStyle);
		}
	}
}

```