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

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

- Page: https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Style/Alignment.php
- Raw: https://pluginprobe.com/plugins/tablepress/3.4/raw/libraries/vendor/PhpSpreadsheet/Style/Alignment.php
- Modified: 2026-03-03T04:48:30+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/Alignment.php#L10-L20`.

```php
<?php

namespace TablePress\PhpOffice\PhpSpreadsheet\Style;

use TablePress\PhpOffice\PhpSpreadsheet\Exception as PhpSpreadsheetException;

class Alignment extends Supervisor
{
	// Horizontal alignment styles
	const HORIZONTAL_GENERAL = 'general';
	const HORIZONTAL_LEFT = 'left';
	const HORIZONTAL_RIGHT = 'right';
	const HORIZONTAL_CENTER = 'center';
	const HORIZONTAL_CENTER_CONTINUOUS = 'centerContinuous';
	const HORIZONTAL_JUSTIFY = 'justify';
	const HORIZONTAL_FILL = 'fill';
	const HORIZONTAL_DISTRIBUTED = 'distributed'; // Excel2007 only
	private const HORIZONTAL_CENTER_CONTINUOUS_LC = 'centercontinuous';
	// Mapping for horizontal alignment
	const HORIZONTAL_ALIGNMENT_FOR_XLSX = [
		self::HORIZONTAL_LEFT => self::HORIZONTAL_LEFT,
		self::HORIZONTAL_RIGHT => self::HORIZONTAL_RIGHT,
		self::HORIZONTAL_CENTER => self::HORIZONTAL_CENTER,
		self::HORIZONTAL_CENTER_CONTINUOUS => self::HORIZONTAL_CENTER_CONTINUOUS,
		self::HORIZONTAL_JUSTIFY => self::HORIZONTAL_JUSTIFY,
		self::HORIZONTAL_FILL => self::HORIZONTAL_FILL,
		self::HORIZONTAL_DISTRIBUTED => self::HORIZONTAL_DISTRIBUTED,
	];
	// Mapping for horizontal alignment CSS
	const HORIZONTAL_ALIGNMENT_FOR_HTML = [
		self::HORIZONTAL_LEFT => self::HORIZONTAL_LEFT,
		self::HORIZONTAL_RIGHT => self::HORIZONTAL_RIGHT,
		self::HORIZONTAL_CENTER => self::HORIZONTAL_CENTER,
		self::HORIZONTAL_CENTER_CONTINUOUS => self::HORIZONTAL_CENTER,
		self::HORIZONTAL_JUSTIFY => self::HORIZONTAL_JUSTIFY,
		//self::HORIZONTAL_FILL => self::HORIZONTAL_FILL, // no reasonable equivalent for fill
		self::HORIZONTAL_DISTRIBUTED => self::HORIZONTAL_JUSTIFY,
	];

	// Vertical alignment styles
	const VERTICAL_BOTTOM = 'bottom';
	const VERTICAL_TOP = 'top';
	const VERTICAL_CENTER = 'center';
	const VERTICAL_JUSTIFY = 'justify';
	const VERTICAL_DISTRIBUTED = 'distributed'; // Excel2007 only
	// Vertical alignment CSS
	private const VERTICAL_BASELINE = 'baseline';
	private const VERTICAL_MIDDLE = 'middle';
	private const VERTICAL_SUB = 'sub';
	private const VERTICAL_SUPER = 'super';
	private const VERTICAL_TEXT_BOTTOM = 'text-bottom';
	private const VERTICAL_TEXT_TOP = 'text-top';

	// Mapping for vertical alignment
	const VERTICAL_ALIGNMENT_FOR_XLSX = [
		self::VERTICAL_BOTTOM => self::VERTICAL_BOTTOM,
		self::VERTICAL_TOP => self::VERTICAL_TOP,
		self::VERTICAL_CENTER => self::VERTICAL_CENTER,
		self::VERTICAL_JUSTIFY => self::VERTICAL_JUSTIFY,
		self::VERTICAL_DISTRIBUTED => self::VERTICAL_DISTRIBUTED,
		// css settings that aren't in sync with Excel
		self::VERTICAL_BASELINE => self::VERTICAL_BOTTOM,
		self::VERTICAL_MIDDLE => self::VERTICAL_CENTER,
		self::VERTICAL_SUB => self::VERTICAL_BOTTOM,
		self::VERTICAL_SUPER => self::VERTICAL_TOP,
		self::VERTICAL_TEXT_BOTTOM => self::VERTICAL_BOTTOM,
		self::VERTICAL_TEXT_TOP => self::VERTICAL_TOP,
	];

	// Mapping for vertical alignment for Html
	const VERTICAL_ALIGNMENT_FOR_HTML = [
		self::VERTICAL_BOTTOM => self::VERTICAL_BOTTOM,
		self::VERTICAL_TOP => self::VERTICAL_TOP,
		self::VERTICAL_CENTER => self::VERTICAL_MIDDLE,
		self::VERTICAL_JUSTIFY => self::VERTICAL_MIDDLE,
		self::VERTICAL_DISTRIBUTED => self::VERTICAL_MIDDLE,
		// css settings that aren't in sync with Excel
		self::VERTICAL_BASELINE => self::VERTICAL_BASELINE,
		self::VERTICAL_MIDDLE => self::VERTICAL_MIDDLE,
		self::VERTICAL_SUB => self::VERTICAL_SUB,
		self::VERTICAL_SUPER => self::VERTICAL_SUPER,
		self::VERTICAL_TEXT_BOTTOM => self::VERTICAL_TEXT_BOTTOM,
		self::VERTICAL_TEXT_TOP => self::VERTICAL_TEXT_TOP,
	];

	// Read order
	const READORDER_CONTEXT = 0;
	const READORDER_LTR = 1;
	const READORDER_RTL = 2;

	// Special value for Text Rotation
	const TEXTROTATION_STACK_EXCEL = 255;
	const TEXTROTATION_STACK_PHPSPREADSHEET = -165; // 90 - 255

	public const INDENT_UNITS_TO_PIXELS = 9;

	/**
	 * Horizontal alignment.
	 */
	protected ?string $horizontal = self::HORIZONTAL_GENERAL;

	/**
	 * Justify Last Line alignment.
	 */
	protected ?bool $justifyLastLine = null;

	/**
	 * Vertical alignment.
	 */
	protected ?string $vertical = self::VERTICAL_BOTTOM;

	/**
	 * Text rotation.
	 */
	protected ?int $textRotation = 0;

	/**
	 * Wrap text.
	 */
	protected bool $wrapText = false;

	/**
	 * Shrink to fit.
	 */
	protected bool $shrinkToFit = false;

	/**
	 * Indent - only possible with horizontal alignment left and right.
	 */
	protected int $indent = 0;

	/**
	 * Read order.
	 */
	protected int $readOrder = 0;

	/**
	 * Create a new Alignment.
	 *
	 * @param bool $isSupervisor Flag indicating if this is a supervisor or not
	 *                                       Leave this value at default unless you understand exactly what
	 *                                          its ramifications are
	 * @param bool $isConditional Flag indicating if this is a conditional style or not
	 *                                       Leave this value at default unless you understand exactly what
	 *                                          its ramifications are
	 */
	public function __construct(bool $isSupervisor = false, bool $isConditional = false)
	{
		// Supervisor?
		parent::__construct($isSupervisor);

		if ($isConditional) {
			$this->horizontal = null;
			$this->vertical = null;
			$this->textRotation = null;
		}
	}

	/**
	 * Get the shared style component for the currently active cell in currently active sheet.
	 * Only used for style supervisor.
	 */
	public function getSharedComponent(): self
	{
		/** @var Style $parent */
		$parent = $this->parent;

		return $parent->getSharedComponent()->getAlignment();
	}

	/**
	 * Build style array from subcomponents.
	 *
	 * @param mixed[] $array
	 *
	 * @return array{alignment: mixed[]}
	 */
	public function getStyleArray(array $array): array
	{
		return ['alignment' => $array];
	}

	/**
	 * Apply styles from array.
	 *
	 * <code>
	 * $spreadsheet->getActiveSheet()->getStyle('B2')->getAlignment()->applyFromArray(
	 *        [
	 *            'horizontal'   => \TablePress\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER,
	 *            'vertical'     => \TablePress\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER,
	 *            'textRotation' => 0,
	 *            'wrapText'     => TRUE
	 *        ]
	 * );
	 * </code>
	 *
	 * @param mixed[] $styleArray Array containing style information
	 *
	 * @return $this
	 */
	public function applyFromArray(array $styleArray)
	{
		if ($this->isSupervisor) {
			$this->getActiveSheet()->getStyle($this->getSelectedCells())
				->applyFromArray($this->getStyleArray($styleArray));
		} else {
			/** @var array{horizontal?: string, vertical?: string, justifyLastLine?: bool, textRotation?: int, wrapText?: bool, shrinkToFit?: bool, readOrder?: int, indent?: int} $styleArray */
			if (isset($styleArray['horizontal'])) {
				$this->setHorizontal($styleArray['horizontal']);
			}
			if (isset($styleArray['justifyLastLine'])) {
				$this->setJustifyLastLine($styleArray['justifyLastLine']);
			}
			if (isset($styleArray['vertical'])) {
				$this->setVertical($styleArray['vertical']);
			}
			if (isset($styleArray['textRotation'])) {
				$this->setTextRotation($styleArray['textRotation']);
			}
			if (isset($styleArray['wrapText'])) {
				$this->setWrapText($styleArray['wrapText']);
			}
			if (isset($styleArray['shrinkToFit'])) {
				$this->setShrinkToFit($styleArray['shrinkToFit']);
			}
			if (isset($styleArray['indent'])) {
				$this->setIndent($styleArray['indent']);
			}
			if (isset($styleArray['readOrder'])) {
				$this->setReadOrder($styleArray['readOrder']);
			}
		}

		return $this;
	}

	/**
	 * Get Horizontal.
	 */
	public function getHorizontal(): ?string
	{
		if ($this->isSupervisor) {
			return $this->getSharedComponent()->getHorizontal();
		}

		return $this->horizontal;
	}

	/**
	 * Set Horizontal.
	 *
	 * @param string $horizontalAlignment see self::HORIZONTAL_*
	 *
	 * @return $this
	 */
	public function setHorizontal(string $horizontalAlignment)
	{
		$horizontalAlignment = strtolower($horizontalAlignment);
		if ($horizontalAlignment === self::HORIZONTAL_CENTER_CONTINUOUS_LC) {
			$horizontalAlignment = self::HORIZONTAL_CENTER_CONTINUOUS;
		}

		if ($this->isSupervisor) {
			$styleArray = $this->getStyleArray(['horizontal' => $horizontalAlignment]);
			$this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);
		} else {
			$this->horizontal = $horizontalAlignment;
		}

		return $this;
	}

	/**
	 * Get Justify Last Line.
	 */
	public function getJustifyLastLine(): ?bool
	{
		if ($this->isSupervisor) {
			return $this->getSharedComponent()->getJustifyLastLine();
		}

		return $this->justifyLastLine;
	}

	/**
	 * Set Justify Last Line.
	 *
	 * @return $this
	 */
	public function setJustifyLastLine(bool $justifyLastLine)
	{
		if ($this->isSupervisor) {
			$styleArray = $this->getStyleArray(['justifyLastLine' => $justifyLastLine]);
			$this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);
		} else {
			$this->justifyLastLine = $justifyLastLine;
		}

		return $this;
	}

	/**
	 * Get Vertical.
	 */
	public function getVertical(): ?string
	{
		if ($this->isSupervisor) {
			return $this->getSharedComponent()->getVertical();
		}

		return $this->vertical;
	}

	/**
	 * Set Vertical.
	 *
	 * @param string $verticalAlignment see self::VERTICAL_*
	 *
	 * @return $this
	 */
	public function setVertical(string $verticalAlignment)
	{
		$verticalAlignment = strtolower($verticalAlignment);

		if ($this->isSupervisor) {
			$styleArray = $this->getStyleArray(['vertical' => $verticalAlignment]);
			$this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);
		} else {
			$this->vertical = $verticalAlignment;
		}

		return $this;
	}

	/**
	 * Get TextRotation.
	 */
	public function getTextRotation(): ?int
	{
		if ($this->isSupervisor) {
			return $this->getSharedComponent()->getTextRotation();
		}

		return $this->textRotation;
	}

	/**
	 * Set TextRotation.
	 *
	 * @return $this
	 */
	public function setTextRotation(int $angleInDegrees)
	{
		// Excel2007 value 255 => PhpSpreadsheet value -165
		if ($angleInDegrees == self::TEXTROTATION_STACK_EXCEL) {
			$angleInDegrees = self::TEXTROTATION_STACK_PHPSPREADSHEET;
		}

		// Set rotation
		if (($angleInDegrees >= -90 && $angleInDegrees <= 90) || $angleInDegrees == self::TEXTROTATION_STACK_PHPSPREADSHEET) {
			if ($this->isSupervisor) {
				$styleArray = $this->getStyleArray(['textRotation' => $angleInDegrees]);
				$this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);
			} else {
				$this->textRotation = $angleInDegrees;
			}
		} else {
			throw new PhpSpreadsheetException("Text rotation $angleInDegrees should be a value between -90 and 90.");
		}

		return $this;
	}

	/**
	 * Get Wrap Text.
	 */
	public function getWrapText(): bool
	{
		if ($this->isSupervisor) {
			return $this->getSharedComponent()->getWrapText();
		}

		return $this->wrapText;
	}

	/**
	 * Set Wrap Text.
	 *
	 * @return $this
	 */
	public function setWrapText(bool $wrapped)
	{
		if ($wrapped == '') {
			$wrapped = false;
		}
		if ($this->isSupervisor) {
			$styleArray = $this->getStyleArray(['wrapText' => $wrapped]);
			$this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);
		} else {
			$this->wrapText = $wrapped;
		}

		return $this;
	}

	/**
	 * Get Shrink to fit.
	 */
	public function getShrinkToFit(): bool
	{
		if ($this->isSupervisor) {
			return $this->getSharedComponent()->getShrinkToFit();
		}

		return $this->shrinkToFit;
	}

	/**
	 * Set Shrink to fit.
	 *
	 * @return $this
	 */
	public function setShrinkToFit(bool $shrink)
	{
		if ($shrink == '') {
			$shrink = false;
		}
		if ($this->isSupervisor) {
			$styleArray = $this->getStyleArray(['shrinkToFit' => $shrink]);
			$this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);
		} else {
			$this->shrinkToFit = $shrink;
		}

		return $this;
	}

	/**
	 * Get indent.
	 */
	public function getIndent(): int
	{
		if ($this->isSupervisor) {
			return $this->getSharedComponent()->getIndent();
		}

		return $this->indent;
	}

	/**
	 * Set indent.
	 *
	 * @return $this
	 */
	public function setIndent(int $indent)
	{
		if ($indent > 0) {
			if (
				$this->getHorizontal() != self::HORIZONTAL_GENERAL
				&& $this->getHorizontal() != self::HORIZONTAL_LEFT
				&& $this->getHorizontal() != self::HORIZONTAL_RIGHT
				&& $this->getHorizontal() != self::HORIZONTAL_DISTRIBUTED
			) {
				$indent = 0; // indent not supported
			}
		}
		if ($this->isSupervisor) {
			$styleArray = $this->getStyleArray(['indent' => $indent]);
			$this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);
		} else {
			$this->indent = $indent;
		}

		return $this;
	}

	/**
	 * Get read order.
	 */
	public function getReadOrder(): int
	{
		if ($this->isSupervisor) {
			return $this->getSharedComponent()->getReadOrder();
		}

		return $this->readOrder;
	}

	/**
	 * Set read order.
	 *
	 * @return $this
	 */
	public function setReadOrder(int $readOrder)
	{
		if ($readOrder < 0 || $readOrder > 2) {
			$readOrder = 0;
		}
		if ($this->isSupervisor) {
			$styleArray = $this->getStyleArray(['readOrder' => $readOrder]);
			$this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);
		} else {
			$this->readOrder = $readOrder;
		}

		return $this;
	}

	/**
	 * Get hash code.
	 *
	 * @return string Hash code
	 */
	public function getHashCode(): string
	{
		if ($this->isSupervisor) {
			return $this->getSharedComponent()->getHashCode();
		}

		return md5(
			$this->horizontal
			. (($this->justifyLastLine === null) ? 'null' : ($this->justifyLastLine ? 't' : 'f'))
			. $this->vertical
			. $this->textRotation
			. ($this->wrapText ? 't' : 'f')
			. ($this->shrinkToFit ? 't' : 'f')
			. $this->indent
			. $this->readOrder
			. __CLASS__
		);
	}

	/** @return mixed[] */
	protected function exportArray1(): array
	{
		$exportedArray = [];
		$this->exportArray2($exportedArray, 'horizontal', $this->getHorizontal());
		$this->exportArray2($exportedArray, 'justifyLastLine', $this->getJustifyLastLine());
		$this->exportArray2($exportedArray, 'indent', $this->getIndent());
		$this->exportArray2($exportedArray, 'readOrder', $this->getReadOrder());
		$this->exportArray2($exportedArray, 'shrinkToFit', $this->getShrinkToFit());
		$this->exportArray2($exportedArray, 'textRotation', $this->getTextRotation());
		$this->exportArray2($exportedArray, 'vertical', $this->getVertical());
		$this->exportArray2($exportedArray, 'wrapText', $this->getWrapText());

		return $exportedArray;
	}
}

```