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

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

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

```php
<?php

namespace TablePress\PhpOffice\PhpSpreadsheet\Reader\Xlsx;

use TablePress\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
use SimpleXMLElement;

class SheetViewOptions extends BaseParserClass
{
	private Worksheet $worksheet;

	private ?SimpleXMLElement $worksheetXml;

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

	public function load(bool $readDataOnly, Styles $styleReader): void
	{
		if ($this->worksheetXml === null) {
			return;
		}

		if (isset($this->worksheetXml->sheetPr)) {
			$sheetPr = $this->worksheetXml->sheetPr;
			$this->tabColor($sheetPr, $styleReader);
			$this->codeName($sheetPr);
			$this->outlines($sheetPr);
			$this->pageSetup($sheetPr);
		}

		if (isset($this->worksheetXml->sheetFormatPr)) {
			$this->sheetFormat($this->worksheetXml->sheetFormatPr);
		}

		if (!$readDataOnly && isset($this->worksheetXml->printOptions)) {
			$this->printOptions($this->worksheetXml->printOptions);
		}
	}

	private function tabColor(SimpleXMLElement $sheetPr, Styles $styleReader): void
	{
		if (isset($sheetPr->tabColor)) {
			$this->worksheet->getTabColor()->setARGB($styleReader->readColor($sheetPr->tabColor));
		}
	}

	private function codeName(SimpleXMLElement $sheetPrx): void
	{
		$sheetPr = $sheetPrx->attributes() ?? [];
		if (isset($sheetPr['codeName'])) {
			$this->worksheet->setCodeName((string) $sheetPr['codeName'], false);
		}
	}

	private function outlines(SimpleXMLElement $sheetPr): void
	{
		if (isset($sheetPr->outlinePr)) {
			$attr = $sheetPr->outlinePr->attributes() ?? [];
			if (
				isset($attr['summaryRight'])
				&& !self::boolean((string) $attr['summaryRight'])
			) {
				$this->worksheet->setShowSummaryRight(false);
			} else {
				$this->worksheet->setShowSummaryRight(true);
			}

			if (
				isset($attr['summaryBelow'])
				&& !self::boolean((string) $attr['summaryBelow'])
			) {
				$this->worksheet->setShowSummaryBelow(false);
			} else {
				$this->worksheet->setShowSummaryBelow(true);
			}
		}
	}

	private function pageSetup(SimpleXMLElement $sheetPr): void
	{
		if (isset($sheetPr->pageSetUpPr)) {
			$attr = $sheetPr->pageSetUpPr->attributes() ?? [];
			if (
				isset($attr['fitToPage'])
				&& !self::boolean((string) $attr['fitToPage'])
			) {
				$this->worksheet->getPageSetup()->setFitToPage(false);
			} else {
				$this->worksheet->getPageSetup()->setFitToPage(true);
			}
		}
	}

	private function sheetFormat(SimpleXMLElement $sheetFormatPrx): void
	{
		$sheetFormatPr = $sheetFormatPrx->attributes() ?? [];
		if (
			isset($sheetFormatPr['customHeight'])
			&& self::boolean((string) $sheetFormatPr['customHeight'])
			&& isset($sheetFormatPr['defaultRowHeight'])
		) {
			$this->worksheet->getDefaultRowDimension()
				->setRowHeight((float) $sheetFormatPr['defaultRowHeight']);
		}

		if (isset($sheetFormatPr['defaultColWidth'])) {
			$this->worksheet->getDefaultColumnDimension()
				->setWidth((float) $sheetFormatPr['defaultColWidth']);
		}

		if (
			isset($sheetFormatPr['zeroHeight'])
			&& ((string) $sheetFormatPr['zeroHeight'] === '1')
		) {
			$this->worksheet->getDefaultRowDimension()->setZeroHeight(true);
		}
	}

	private function printOptions(SimpleXMLElement $printOptionsx): void
	{
		$printOptions = $printOptionsx->attributes() ?? [];
		// Spec is weird. gridLines (default false)
		// and gridLinesSet (default true) must both be true.
		if (isset($printOptions['gridLines']) && self::boolean((string) $printOptions['gridLines'])) {
			if (!isset($printOptions['gridLinesSet']) || self::boolean((string) $printOptions['gridLinesSet'])) {
				$this->worksheet->setPrintGridlines(true);
			}
		}
		if (isset($printOptions['horizontalCentered']) && self::boolean((string) $printOptions['horizontalCentered'])) {
			$this->worksheet->getPageSetup()->setHorizontalCentered(true);
		}
		if (isset($printOptions['verticalCentered']) && self::boolean((string) $printOptions['verticalCentered'])) {
			$this->worksheet->getPageSetup()->setVerticalCentered(true);
		}
	}
}

```