diff options
author | Anton Luka Šijanec <anton@sijanec.eu> | 2024-05-27 13:08:29 +0200 |
---|---|---|
committer | Anton Luka Šijanec <anton@sijanec.eu> | 2024-05-27 13:08:29 +0200 |
commit | 75160b12821f7f4299cce7f0b69c83c1502ae071 (patch) | |
tree | 27e25e4ccaef45f0c58b22831164050d1af1d4db /vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Gnumeric/PageSetup.php | |
parent | prvi-commit (diff) | |
download | 1ka-75160b12821f7f4299cce7f0b69c83c1502ae071.tar 1ka-75160b12821f7f4299cce7f0b69c83c1502ae071.tar.gz 1ka-75160b12821f7f4299cce7f0b69c83c1502ae071.tar.bz2 1ka-75160b12821f7f4299cce7f0b69c83c1502ae071.tar.lz 1ka-75160b12821f7f4299cce7f0b69c83c1502ae071.tar.xz 1ka-75160b12821f7f4299cce7f0b69c83c1502ae071.tar.zst 1ka-75160b12821f7f4299cce7f0b69c83c1502ae071.zip |
Diffstat (limited to '')
-rw-r--r-- | vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Gnumeric/PageSetup.php | 143 |
1 files changed, 143 insertions, 0 deletions
diff --git a/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Gnumeric/PageSetup.php b/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Gnumeric/PageSetup.php new file mode 100644 index 0000000..445b021 --- /dev/null +++ b/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Gnumeric/PageSetup.php @@ -0,0 +1,143 @@ +<?php
+
+namespace PhpOffice\PhpSpreadsheet\Reader\Gnumeric;
+
+use PhpOffice\PhpSpreadsheet\Spreadsheet;
+use PhpOffice\PhpSpreadsheet\Worksheet\PageMargins;
+use PhpOffice\PhpSpreadsheet\Worksheet\PageSetup as WorksheetPageSetup;
+use SimpleXMLElement;
+
+class PageSetup
+{
+ /**
+ * @var Spreadsheet
+ */
+ private $spreadsheet;
+
+ /**
+ * @var string
+ */
+ private $gnm;
+
+ public function __construct(Spreadsheet $spreadsheet, string $gnm)
+ {
+ $this->spreadsheet = $spreadsheet;
+ $this->gnm = $gnm;
+ }
+
+ public function printInformation(SimpleXMLElement $sheet): self
+ {
+ if (isset($sheet->PrintInformation)) {
+ $printInformation = $sheet->PrintInformation[0];
+ $scale = (string) $printInformation->Scale->attributes()['percentage'];
+ $pageOrder = (string) $printInformation->order;
+ $orientation = (string) $printInformation->orientation;
+ $horizontalCentered = (string) $printInformation->hcenter->attributes()['value'];
+ $verticalCentered = (string) $printInformation->vcenter->attributes()['value'];
+
+ $this->spreadsheet->getActiveSheet()->getPageSetup()
+ ->setPageOrder($pageOrder === 'r_then_d' ? WorksheetPageSetup::PAGEORDER_OVER_THEN_DOWN : WorksheetPageSetup::PAGEORDER_DOWN_THEN_OVER)
+ ->setScale((int) $scale)
+ ->setOrientation($orientation ?? WorksheetPageSetup::ORIENTATION_DEFAULT)
+ ->setHorizontalCentered((bool) $horizontalCentered)
+ ->setVerticalCentered((bool) $verticalCentered);
+ }
+
+ return $this;
+ }
+
+ public function sheetMargins(SimpleXMLElement $sheet): self
+ {
+ if (isset($sheet->PrintInformation, $sheet->PrintInformation->Margins)) {
+ $marginSet = [
+ // Default Settings
+ 'top' => 0.75,
+ 'header' => 0.3,
+ 'left' => 0.7,
+ 'right' => 0.7,
+ 'bottom' => 0.75,
+ 'footer' => 0.3,
+ ];
+
+ $marginSet = $this->buildMarginSet($sheet, $marginSet);
+ $this->adjustMargins($marginSet);
+ }
+
+ return $this;
+ }
+
+ private function buildMarginSet(SimpleXMLElement $sheet, array $marginSet): array
+ {
+ foreach ($sheet->PrintInformation->Margins->children($this->gnm, true) as $key => $margin) {
+ $marginAttributes = $margin->attributes();
+ $marginSize = ($marginAttributes['Points']) ?? 72; // Default is 72pt
+ // Convert value in points to inches
+ $marginSize = PageMargins::fromPoints((float) $marginSize);
+ $marginSet[$key] = $marginSize;
+ }
+
+ return $marginSet;
+ }
+
+ private function adjustMargins(array $marginSet): void
+ {
+ foreach ($marginSet as $key => $marginSize) {
+ // Gnumeric is quirky in the way it displays the header/footer values:
+ // header is actually the sum of top and header; footer is actually the sum of bottom and footer
+ // then top is actually the header value, and bottom is actually the footer value
+ switch ($key) {
+ case 'left':
+ case 'right':
+ $this->sheetMargin($key, $marginSize);
+
+ break;
+ case 'top':
+ $this->sheetMargin($key, $marginSet['header'] ?? 0);
+
+ break;
+ case 'bottom':
+ $this->sheetMargin($key, $marginSet['footer'] ?? 0);
+
+ break;
+ case 'header':
+ $this->sheetMargin($key, ($marginSet['top'] ?? 0) - $marginSize);
+
+ break;
+ case 'footer':
+ $this->sheetMargin($key, ($marginSet['bottom'] ?? 0) - $marginSize);
+
+ break;
+ }
+ }
+ }
+
+ private function sheetMargin(string $key, float $marginSize): void
+ {
+ switch ($key) {
+ case 'top':
+ $this->spreadsheet->getActiveSheet()->getPageMargins()->setTop($marginSize);
+
+ break;
+ case 'bottom':
+ $this->spreadsheet->getActiveSheet()->getPageMargins()->setBottom($marginSize);
+
+ break;
+ case 'left':
+ $this->spreadsheet->getActiveSheet()->getPageMargins()->setLeft($marginSize);
+
+ break;
+ case 'right':
+ $this->spreadsheet->getActiveSheet()->getPageMargins()->setRight($marginSize);
+
+ break;
+ case 'header':
+ $this->spreadsheet->getActiveSheet()->getPageMargins()->setHeader($marginSize);
+
+ break;
+ case 'footer':
+ $this->spreadsheet->getActiveSheet()->getPageMargins()->setFooter($marginSize);
+
+ break;
+ }
+ }
+}
|