# tablepress/3.4/libraries/vendor/PhpSpreadsheet/Reader/Ods/PageSettings.php

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

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

```php
<?php

namespace TablePress\PhpOffice\PhpSpreadsheet\Reader\Ods;

use DOMDocument;
use TablePress\PhpOffice\PhpSpreadsheet\Worksheet\PageSetup;
use TablePress\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
use stdClass;

class PageSettings
{
	private string $officeNs = '';

	private string $stylesNs = '';

	private string $stylesFo = '';

	private string $tableNs = '';

	/**
	 * @var string[]
	 */
	private array $tableStylesCrossReference = [];

	/** @var mixed[] */
	private array $pageLayoutStyles = [];

	/**
	 * @var string[]
	 */
	private array $masterStylesCrossReference = [];

	/**
	 * @var string[]
	 */
	private array $masterPrintStylesCrossReference = [];

	public function __construct(DOMDocument $styleDom)
	{
		$this->setDomNameSpaces($styleDom);
		$this->readPageSettingStyles($styleDom);
		$this->readStyleMasterLookup($styleDom);
	}

	private function setDomNameSpaces(DOMDocument $styleDom): void
	{
		$this->officeNs = (string) $styleDom->lookupNamespaceUri('office');
		$this->stylesNs = (string) $styleDom->lookupNamespaceUri('style');
		$this->stylesFo = (string) $styleDom->lookupNamespaceUri('fo');
		$this->tableNs = (string) $styleDom->lookupNamespaceUri('table');
	}

	private function readPageSettingStyles(DOMDocument $styleDom): void
	{
		$item0 = $styleDom->getElementsByTagNameNS($this->officeNs, 'automatic-styles')->item(0);
		$styles = ($item0 === null) ? [] : $item0->getElementsByTagNameNS($this->stylesNs, 'page-layout');

		foreach ($styles as $styleSet) {
			$styleName = $styleSet->getAttributeNS($this->stylesNs, 'name');
			$pageLayoutProperties = $styleSet->getElementsByTagNameNS($this->stylesNs, 'page-layout-properties')->item(0);
			$styleOrientation = ($nullsafeVariable1 = $pageLayoutProperties) ? $nullsafeVariable1->getAttributeNS($this->stylesNs, 'print-orientation') : null;
			$styleScale = ($nullsafeVariable2 = $pageLayoutProperties) ? $nullsafeVariable2->getAttributeNS($this->stylesNs, 'scale-to') : null;
			$stylePrintOrder = ($nullsafeVariable3 = $pageLayoutProperties) ? $nullsafeVariable3->getAttributeNS($this->stylesNs, 'print-page-order') : null;
			$centered = ($nullsafeVariable4 = $pageLayoutProperties) ? $nullsafeVariable4->getAttributeNS($this->stylesNs, 'table-centering') : null;

			$marginLeft = ($nullsafeVariable5 = $pageLayoutProperties) ? $nullsafeVariable5->getAttributeNS($this->stylesFo, 'margin-left') : null;
			$marginRight = ($nullsafeVariable6 = $pageLayoutProperties) ? $nullsafeVariable6->getAttributeNS($this->stylesFo, 'margin-right') : null;
			$marginTop = ($nullsafeVariable7 = $pageLayoutProperties) ? $nullsafeVariable7->getAttributeNS($this->stylesFo, 'margin-top') : null;
			$marginBottom = ($nullsafeVariable8 = $pageLayoutProperties) ? $nullsafeVariable8->getAttributeNS($this->stylesFo, 'margin-bottom') : null;
			$header = $styleSet->getElementsByTagNameNS($this->stylesNs, 'header-style')->item(0);
			$headerProperties = ($nullsafeVariable9 = ($nullsafeVariable10 = $header) ? $nullsafeVariable10->getElementsByTagNameNS($this->stylesNs, 'header-footer-properties') : null) ? $nullsafeVariable9->item(0) : null;
			$marginHeader = ($nullsafeVariable11 = $headerProperties) ? $nullsafeVariable11->getAttributeNS($this->stylesFo, 'min-height') : null;
			$footer = $styleSet->getElementsByTagNameNS($this->stylesNs, 'footer-style')->item(0);
			$footerProperties = ($nullsafeVariable12 = ($nullsafeVariable13 = $footer) ? $nullsafeVariable13->getElementsByTagNameNS($this->stylesNs, 'header-footer-properties') : null) ? $nullsafeVariable12->item(0) : null;
			$marginFooter = ($nullsafeVariable14 = $footerProperties) ? $nullsafeVariable14->getAttributeNS($this->stylesFo, 'min-height') : null;

			$this->pageLayoutStyles[$styleName] = (object) [
				'orientation' => $styleOrientation ?: PageSetup::ORIENTATION_DEFAULT,
				'scale' => $styleScale ?: 100,
				'printOrder' => $stylePrintOrder,
				'horizontalCentered' => $centered === 'horizontal' || $centered === 'both',
				'verticalCentered' => $centered === 'vertical' || $centered === 'both',
				// margin size is already stored in inches, so no UOM conversion is required
				'marginLeft' => (float) ($marginLeft ?? 0.7),
				'marginRight' => (float) ($marginRight ?? 0.7),
				'marginTop' => (float) ($marginTop ?? 0.3),
				'marginBottom' => (float) ($marginBottom ?? 0.3),
				'marginHeader' => (float) ($marginHeader ?? 0.45),
				'marginFooter' => (float) ($marginFooter ?? 0.45),
			];
		}
	}

	private function readStyleMasterLookup(DOMDocument $styleDom): void
	{
		$item0 = $styleDom->getElementsByTagNameNS($this->officeNs, 'master-styles')->item(0);
		$styleMasterLookup = ($item0 === null) ? [] : $item0->getElementsByTagNameNS($this->stylesNs, 'master-page');

		foreach ($styleMasterLookup as $styleMasterSet) {
			$styleMasterName = $styleMasterSet->getAttributeNS($this->stylesNs, 'name');
			$pageLayoutName = $styleMasterSet->getAttributeNS($this->stylesNs, 'page-layout-name');
			$this->masterPrintStylesCrossReference[$styleMasterName] = $pageLayoutName;
		}
	}

	public function readStyleCrossReferences(DOMDocument $contentDom): void
	{
		$item0 = $contentDom->getElementsByTagNameNS($this->officeNs, 'automatic-styles')->item(0);
		$styleXReferences = ($item0 === null) ? [] : $item0->getElementsByTagNameNS($this->stylesNs, 'style');

		foreach ($styleXReferences as $styleXreferenceSet) {
			$styleXRefName = $styleXreferenceSet->getAttributeNS($this->stylesNs, 'name');
			$stylePageLayoutName = $styleXreferenceSet->getAttributeNS($this->stylesNs, 'master-page-name');
			$styleFamilyName = $styleXreferenceSet->getAttributeNS($this->stylesNs, 'family');
			if (!empty($styleFamilyName) && $styleFamilyName === 'table') {
				$styleVisibility = 'true';
				foreach ($styleXreferenceSet->getElementsByTagNameNS($this->stylesNs, 'table-properties') as $tableProperties) {
					$styleVisibility = $tableProperties->getAttributeNS($this->tableNs, 'display');
				}
				$this->tableStylesCrossReference[$styleXRefName] = $styleVisibility;
			}
			if (!empty($stylePageLayoutName)) {
				$this->masterStylesCrossReference[$styleXRefName] = $stylePageLayoutName;
			}
		}
	}

	public function setVisibilityForWorksheet(Worksheet $worksheet, string $styleName): void
	{
		if (!array_key_exists($styleName, $this->tableStylesCrossReference)) {
			return;
		}

		$worksheet->setSheetState(
			$this->tableStylesCrossReference[$styleName] === 'false'
				? Worksheet::SHEETSTATE_HIDDEN
				: Worksheet::SHEETSTATE_VISIBLE
		);
	}

	public function setPrintSettingsForWorksheet(Worksheet $worksheet, string $styleName): void
	{
		if (!array_key_exists($styleName, $this->masterStylesCrossReference)) {
			return;
		}
		$masterStyleName = $this->masterStylesCrossReference[$styleName];

		if (!array_key_exists($masterStyleName, $this->masterPrintStylesCrossReference)) {
			return;
		}
		$printSettingsIndex = $this->masterPrintStylesCrossReference[$masterStyleName];

		if (!array_key_exists($printSettingsIndex, $this->pageLayoutStyles)) {
			return;
		}
		/** @var (object{orientation: string, scale: int|string, printOrder: ?string,
		 * horizontalCentered: bool, verticalCentered: bool, marginLeft: float, marginRight: float, marginTop: float,
		 * marginBottom: float, marginHeader: float, marginFooter: float}&stdClass) */
		$printSettings = $this->pageLayoutStyles[$printSettingsIndex];

		$worksheet->getPageSetup()
			->setOrientation($printSettings->orientation ?? PageSetup::ORIENTATION_DEFAULT)
			->setPageOrder($printSettings->printOrder === 'ltr' ? PageSetup::PAGEORDER_OVER_THEN_DOWN : PageSetup::PAGEORDER_DOWN_THEN_OVER)
			->setScale((int) trim((string) $printSettings->scale, '%'))
			->setHorizontalCentered($printSettings->horizontalCentered)
			->setVerticalCentered($printSettings->verticalCentered);

		$worksheet->getPageMargins()
			->setLeft($printSettings->marginLeft)
			->setRight($printSettings->marginRight)
			->setTop($printSettings->marginTop)
			->setBottom($printSettings->marginBottom)
			->setHeader($printSettings->marginHeader)
			->setFooter($printSettings->marginFooter);
	}
}

```
