Styles::__construct() - Code Metrics - Inspection of "PHPCS Fix" - PHPOffice/PhpSpreadsheet - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( d2e6db...2ddb23 )

by Mark

created 2021-05-08 20:50 UTC

Styles::__construct() A

↳ Parent: Styles

Complexity

Conditions	1
Paths	1

Size

Total Lines	4
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	3
CRAP Score	1

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	1
eloc	2
c	1
b	0
f	0
nc	1
nop	2
dl	0
loc	4
ccs	3
cts	3
cp	1
crap	1
rs	10

<?php

namespace PhpOffice\PhpSpreadsheet\Reader\Gnumeric;

use PhpOffice\PhpSpreadsheet\Cell\Coordinate;
use PhpOffice\PhpSpreadsheet\Shared\Date;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Style\Alignment;
use PhpOffice\PhpSpreadsheet\Style\Border;
use PhpOffice\PhpSpreadsheet\Style\Borders;
use PhpOffice\PhpSpreadsheet\Style\Fill;
use PhpOffice\PhpSpreadsheet\Style\Font;
use SimpleXMLElement;

class Styles
{
    /**
     * @var Spreadsheet
     */
    private $spreadsheet;

    /**
     * @var bool
     */
    protected $readDataOnly = false;

    /** @var array */
    public static $mappings = [
        'borderStyle' => [
            '0' => Border::BORDER_NONE,
            '1' => Border::BORDER_THIN,
            '2' => Border::BORDER_MEDIUM,
            '3' => Border::BORDER_SLANTDASHDOT,
            '4' => Border::BORDER_DASHED,
            '5' => Border::BORDER_THICK,
            '6' => Border::BORDER_DOUBLE,
            '7' => Border::BORDER_DOTTED,
            '8' => Border::BORDER_MEDIUMDASHED,
            '9' => Border::BORDER_DASHDOT,
            '10' => Border::BORDER_MEDIUMDASHDOT,
            '11' => Border::BORDER_DASHDOTDOT,
            '12' => Border::BORDER_MEDIUMDASHDOTDOT,
            '13' => Border::BORDER_MEDIUMDASHDOTDOT,
        ],
        'fillType' => [
            '1' => Fill::FILL_SOLID,
            '2' => Fill::FILL_PATTERN_DARKGRAY,
            '3' => Fill::FILL_PATTERN_MEDIUMGRAY,
            '4' => Fill::FILL_PATTERN_LIGHTGRAY,
            '5' => Fill::FILL_PATTERN_GRAY125,
            '6' => Fill::FILL_PATTERN_GRAY0625,
            '7' => Fill::FILL_PATTERN_DARKHORIZONTAL, // horizontal stripe
            '8' => Fill::FILL_PATTERN_DARKVERTICAL, // vertical stripe
            '9' => Fill::FILL_PATTERN_DARKDOWN, // diagonal stripe
            '10' => Fill::FILL_PATTERN_DARKUP, // reverse diagonal stripe
            '11' => Fill::FILL_PATTERN_DARKGRID, // diagoanl crosshatch
            '12' => Fill::FILL_PATTERN_DARKTRELLIS, // thick diagonal crosshatch
            '13' => Fill::FILL_PATTERN_LIGHTHORIZONTAL,
            '14' => Fill::FILL_PATTERN_LIGHTVERTICAL,
            '15' => Fill::FILL_PATTERN_LIGHTUP,
            '16' => Fill::FILL_PATTERN_LIGHTDOWN,
            '17' => Fill::FILL_PATTERN_LIGHTGRID, // thin horizontal crosshatch
            '18' => Fill::FILL_PATTERN_LIGHTTRELLIS, // thin diagonal crosshatch
        ],
        'horizontal' => [
            '1' => Alignment::HORIZONTAL_GENERAL,
            '2' => Alignment::HORIZONTAL_LEFT,
            '4' => Alignment::HORIZONTAL_RIGHT,
            '8' => Alignment::HORIZONTAL_CENTER,
            '16' => Alignment::HORIZONTAL_CENTER_CONTINUOUS,
            '32' => Alignment::HORIZONTAL_JUSTIFY,
            '64' => Alignment::HORIZONTAL_CENTER_CONTINUOUS,
        ],
        'underline' => [
            '1' => Font::UNDERLINE_SINGLE,
            '2' => Font::UNDERLINE_DOUBLE,
            '3' => Font::UNDERLINE_SINGLEACCOUNTING,
            '4' => Font::UNDERLINE_DOUBLEACCOUNTING,
        ],
        'vertical' => [
            '1' => Alignment::VERTICAL_TOP,
            '2' => Alignment::VERTICAL_BOTTOM,
            '4' => Alignment::VERTICAL_CENTER,
            '8' => Alignment::VERTICAL_JUSTIFY,
        ],
    ];

    public function __construct(Spreadsheet $spreadsheet, bool $readDataOnly)
    {
        $this->spreadsheet = $spreadsheet;
        $this->readDataOnly = $readDataOnly;
    }

    public function read(SimpleXMLElement $sheet, int $maxRow, int $maxCol): void
    {
        if ($sheet->Styles->StyleRegion !== null) {
            $this->readStyles($sheet->Styles->StyleRegion, $maxRow, $maxCol);
        }
    }

    private function readStyles(SimpleXMLElement $styleRegion, int $maxRow, int $maxCol): void
    {
        foreach ($styleRegion as $style) {
            if ($style === null) {
                continue;
            }

            $styleAttributes = $style->attributes();
            if ($styleAttributes !== null && ($styleAttributes['startRow'] <= $maxRow) && ($styleAttributes['startCol'] <= $maxCol)) {
                $cellRange = $this->readStyleRange($styleAttributes, $maxCol, $maxRow);

                $styleAttributes = $style->Style->attributes();

                $styleArray = [];
                // We still set the number format mask for date/time values, even if readDataOnly is true
                //    so that we can identify whether a float is a float or a date value
                $formatCode = (string) $styleAttributes['Format'];
                if (Date::isDateTimeFormatCode($formatCode)) {
                    $styleArray['numberFormat']['formatCode'] = $formatCode;
                }
                if ($this->readDataOnly === false && $styleAttributes !== null) {
                    //    If readDataOnly is false, we set all formatting information
                    $styleArray['numberFormat']['formatCode'] = $formatCode;
                    $styleArray = $this->readStyle($styleArray, $styleAttributes, $style);
                }
                $this->spreadsheet->getActiveSheet()->getStyle($cellRange)->applyFromArray($styleArray);
            }
        }
    }

    private function addBorderDiagonal(SimpleXMLElement $srssb, array &$styleArray): void
    {
        if (isset($srssb->Diagonal, $srssb->{'Rev-Diagonal'})) {
            $styleArray['borders']['diagonal'] = self::parseBorderAttributes($srssb->Diagonal->attributes());
            $styleArray['borders']['diagonalDirection'] = Borders::DIAGONAL_BOTH;
        } elseif (isset($srssb->Diagonal)) {
            $styleArray['borders']['diagonal'] = self::parseBorderAttributes($srssb->Diagonal->attributes());
            $styleArray['borders']['diagonalDirection'] = Borders::DIAGONAL_UP;
        } elseif (isset($srssb->{'Rev-Diagonal'})) {
            $styleArray['borders']['diagonal'] = self::parseBorderAttributes($srssb->{'Rev-Diagonal'}->attributes());
            $styleArray['borders']['diagonalDirection'] = Borders::DIAGONAL_DOWN;
        }
    }

    private function addBorderStyle(SimpleXMLElement $srssb, array &$styleArray, string $direction): void
    {
        $ucDirection = ucfirst($direction);
        if (isset($srssb->$ucDirection)) {
            $styleArray['borders'][$direction] = self::parseBorderAttributes($srssb->$ucDirection->attributes());
        }
    }

    private function calcRotation(SimpleXMLElement $styleAttributes): int
    {
        $rotation = (int) $styleAttributes->Rotation;
        if ($rotation >= 270 && $rotation <= 360) {
            $rotation -= 360;
        }
        $rotation = (abs($rotation) > 90) ? 0 : $rotation;

        return $rotation;
    }

    private static function addStyle(array &$styleArray, string $key, string $value): void
    {
        if (array_key_exists($value, self::$mappings[$key])) {
            $styleArray[$key] = self::$mappings[$key][$value];
        }
    }

    private static function addStyle2(array &$styleArray, string $key1, string $key, string $value): void
    {
        if (array_key_exists($value, self::$mappings[$key])) {
            $styleArray[$key1][$key] = self::$mappings[$key][$value];
        }
    }

    private static function parseBorderAttributes(?SimpleXMLElement $borderAttributes): array
    {
        $styleArray = [];
        if ($borderAttributes !== null) {
            if (isset($borderAttributes['Color'])) {
                $styleArray['color']['rgb'] = self::parseGnumericColour($borderAttributes['Color']);
            }

            self::addStyle($styleArray, 'borderStyle', $borderAttributes['Style']);
        }

        return $styleArray;
    }

    private static function parseGnumericColour(string $gnmColour): string
    {
        [$gnmR, $gnmG, $gnmB] = explode(':', $gnmColour);
        $gnmR = substr(str_pad($gnmR, 4, '0', STR_PAD_RIGHT), 0, 2);
        $gnmG = substr(str_pad($gnmG, 4, '0', STR_PAD_RIGHT), 0, 2);
        $gnmB = substr(str_pad($gnmB, 4, '0', STR_PAD_RIGHT), 0, 2);

        return $gnmR . $gnmG . $gnmB;
    }

    private function addColors(array &$styleArray, SimpleXMLElement $styleAttributes): void
    {
        $RGB = self::parseGnumericColour($styleAttributes['Fore']);
        $styleArray['font']['color']['rgb'] = $RGB;
        $RGB = self::parseGnumericColour($styleAttributes['Back']);
        $shade = (string) $styleAttributes['Shade'];
        if (($RGB !== '000000') || ($shade !== '0')) {
            $RGB2 = self::parseGnumericColour($styleAttributes['PatternColor']);
            if ($shade === '1') {
                $styleArray['fill']['startColor']['rgb'] = $RGB;
                $styleArray['fill']['endColor']['rgb'] = $RGB2;
            } else {
                $styleArray['fill']['endColor']['rgb'] = $RGB;
                $styleArray['fill']['startColor']['rgb'] = $RGB2;
            }
            self::addStyle2($styleArray, 'fill', 'fillType', $shade);
        }
    }

    private function readStyleRange(SimpleXMLElement $styleAttributes, int $maxCol, int $maxRow): string
    {
        $startColumn = Coordinate::stringFromColumnIndex((int) $styleAttributes['startCol'] + 1);
        $startRow = $styleAttributes['startRow'] + 1;

        $endColumn = ($styleAttributes['endCol'] > $maxCol) ? $maxCol : (int) $styleAttributes['endCol'];
        $endColumn = Coordinate::stringFromColumnIndex($endColumn + 1);

        $endRow = 1 + (($styleAttributes['endRow'] > $maxRow) ? $maxRow : (int) $styleAttributes['endRow']);
        $cellRange = $startColumn . $startRow . ':' . $endColumn . $endRow;

        return $cellRange;
    }

    private function readStyle(array $styleArray, SimpleXMLElement $styleAttributes, SimpleXMLElement $style): array
    {
        self::addStyle2($styleArray, 'alignment', 'horizontal', $styleAttributes['HAlign']);
        self::addStyle2($styleArray, 'alignment', 'vertical', $styleAttributes['VAlign']);
        $styleArray['alignment']['wrapText'] = $styleAttributes['WrapText'] == '1';
        $styleArray['alignment']['textRotation'] = $this->calcRotation($styleAttributes);
        $styleArray['alignment']['shrinkToFit'] = $styleAttributes['ShrinkToFit'] == '1';
        $styleArray['alignment']['indent'] = ((int) ($styleAttributes['Indent']) > 0) ? $styleAttributes['indent'] : 0;

        $this->addColors($styleArray, $styleAttributes);

        $fontAttributes = $style->Style->Font->attributes();
        if ($fontAttributes !== null) {
            $styleArray['font']['name'] = (string) $style->Style->Font;
            $styleArray['font']['size'] = (int) ($fontAttributes['Unit']);
            $styleArray['font']['bold'] = $fontAttributes['Bold'] == '1';
            $styleArray['font']['italic'] = $fontAttributes['Italic'] == '1';
            $styleArray['font']['strikethrough'] = $fontAttributes['StrikeThrough'] == '1';
            self::addStyle2($styleArray, 'font', 'underline', $fontAttributes['Underline']);

            switch ($fontAttributes['Script']) {
                case '1':
                    $styleArray['font']['superscript'] = true;

                    break;
                case '-1':
                    $styleArray['font']['subscript'] = true;

                    break;
            }
        }

        if (isset($style->Style->StyleBorder)) {
            $srssb = $style->Style->StyleBorder;
            $this->addBorderStyle($srssb, $styleArray, 'top');
            $this->addBorderStyle($srssb, $styleArray, 'bottom');
            $this->addBorderStyle($srssb, $styleArray, 'left');
            $this->addBorderStyle($srssb, $styleArray, 'right');
            $this->addBorderDiagonal($srssb, $styleArray);
        }
        if (isset($style->Style->HyperLink)) {
            //    TO DO
            $hyperlink = $style->Style->HyperLink->attributes();

        }

        return $styleArray;
    }
}


1		<?php
2
3		namespace PhpOffice\PhpSpreadsheet\Reader\Gnumeric;
4
5		use PhpOffice\PhpSpreadsheet\Cell\Coordinate;
6		use PhpOffice\PhpSpreadsheet\Shared\Date;
7		use PhpOffice\PhpSpreadsheet\Spreadsheet;
8		use PhpOffice\PhpSpreadsheet\Style\Alignment;
9		use PhpOffice\PhpSpreadsheet\Style\Border;
10		use PhpOffice\PhpSpreadsheet\Style\Borders;
11		use PhpOffice\PhpSpreadsheet\Style\Fill;
12		use PhpOffice\PhpSpreadsheet\Style\Font;
13		use SimpleXMLElement;
14
15		class Styles
16		{
17		/**
18		* @var Spreadsheet
19		*/
20		private $spreadsheet;
21
22		/**
23		* @var bool
24		*/
25		protected $readDataOnly = false;
26
27		/** @var array */
28		public static $mappings = [
29		'borderStyle' => [
30		'0' => Border::BORDER_NONE,
31		'1' => Border::BORDER_THIN,
32		'2' => Border::BORDER_MEDIUM,
33		'3' => Border::BORDER_SLANTDASHDOT,
34		'4' => Border::BORDER_DASHED,
35		'5' => Border::BORDER_THICK,
36		'6' => Border::BORDER_DOUBLE,
37		'7' => Border::BORDER_DOTTED,
38		'8' => Border::BORDER_MEDIUMDASHED,
39		'9' => Border::BORDER_DASHDOT,
40		'10' => Border::BORDER_MEDIUMDASHDOT,
41		'11' => Border::BORDER_DASHDOTDOT,
42		'12' => Border::BORDER_MEDIUMDASHDOTDOT,
43		'13' => Border::BORDER_MEDIUMDASHDOTDOT,
44		],
45		'fillType' => [
46		'1' => Fill::FILL_SOLID,
47		'2' => Fill::FILL_PATTERN_DARKGRAY,
48		'3' => Fill::FILL_PATTERN_MEDIUMGRAY,
49		'4' => Fill::FILL_PATTERN_LIGHTGRAY,
50		'5' => Fill::FILL_PATTERN_GRAY125,
51		'6' => Fill::FILL_PATTERN_GRAY0625,
52		'7' => Fill::FILL_PATTERN_DARKHORIZONTAL, // horizontal stripe
53		'8' => Fill::FILL_PATTERN_DARKVERTICAL, // vertical stripe
54		'9' => Fill::FILL_PATTERN_DARKDOWN, // diagonal stripe
55		'10' => Fill::FILL_PATTERN_DARKUP, // reverse diagonal stripe
56		'11' => Fill::FILL_PATTERN_DARKGRID, // diagoanl crosshatch
57		'12' => Fill::FILL_PATTERN_DARKTRELLIS, // thick diagonal crosshatch
58		'13' => Fill::FILL_PATTERN_LIGHTHORIZONTAL,
59		'14' => Fill::FILL_PATTERN_LIGHTVERTICAL,
60		'15' => Fill::FILL_PATTERN_LIGHTUP,
61		'16' => Fill::FILL_PATTERN_LIGHTDOWN,
62		'17' => Fill::FILL_PATTERN_LIGHTGRID, // thin horizontal crosshatch
63		'18' => Fill::FILL_PATTERN_LIGHTTRELLIS, // thin diagonal crosshatch
64		],
65		'horizontal' => [
66		'1' => Alignment::HORIZONTAL_GENERAL,
67		'2' => Alignment::HORIZONTAL_LEFT,
68		'4' => Alignment::HORIZONTAL_RIGHT,
69		'8' => Alignment::HORIZONTAL_CENTER,
70		'16' => Alignment::HORIZONTAL_CENTER_CONTINUOUS,
71		'32' => Alignment::HORIZONTAL_JUSTIFY,
72		'64' => Alignment::HORIZONTAL_CENTER_CONTINUOUS,
73		],
74		'underline' => [
75		'1' => Font::UNDERLINE_SINGLE,
76		'2' => Font::UNDERLINE_DOUBLE,
77		'3' => Font::UNDERLINE_SINGLEACCOUNTING,
78		'4' => Font::UNDERLINE_DOUBLEACCOUNTING,
79		],
80		'vertical' => [
81		'1' => Alignment::VERTICAL_TOP,
82		'2' => Alignment::VERTICAL_BOTTOM,
83		'4' => Alignment::VERTICAL_CENTER,
84		'8' => Alignment::VERTICAL_JUSTIFY,
85		],
86		];
87
88	10	public function __construct(Spreadsheet $spreadsheet, bool $readDataOnly)
89		{
90	10	$this->spreadsheet = $spreadsheet;
91	10	$this->readDataOnly = $readDataOnly;
92	10	}
93
94	10	public function read(SimpleXMLElement $sheet, int $maxRow, int $maxCol): void
95		{
96	10	if ($sheet->Styles->StyleRegion !== null) {
97	10	$this->readStyles($sheet->Styles->StyleRegion, $maxRow, $maxCol);
98		}
99	10	}
100
101	10	private function readStyles(SimpleXMLElement $styleRegion, int $maxRow, int $maxCol): void
102		{
103	10	foreach ($styleRegion as $style) {
104	10	if ($style === null) {
105		continue;
106		}
107
108	10	$styleAttributes = $style->attributes();
109	10	if ($styleAttributes !== null && ($styleAttributes['startRow'] <= $maxRow) && ($styleAttributes['startCol'] <= $maxCol)) {
110	10	$cellRange = $this->readStyleRange($styleAttributes, $maxCol, $maxRow);
111
112	10	$styleAttributes = $style->Style->attributes();
113
114	10	$styleArray = [];
115		// We still set the number format mask for date/time values, even if readDataOnly is true
116		// so that we can identify whether a float is a float or a date value
117	10	$formatCode = (string) $styleAttributes['Format'];
118	10	if (Date::isDateTimeFormatCode($formatCode)) {
119	5	$styleArray['numberFormat']['formatCode'] = $formatCode;
120		}
121	10	if ($this->readDataOnly === false && $styleAttributes !== null) {
122		// If readDataOnly is false, we set all formatting information
123	10	$styleArray['numberFormat']['formatCode'] = $formatCode;
124	10	$styleArray = $this->readStyle($styleArray, $styleAttributes, $style);
125		}
126	10	$this->spreadsheet->getActiveSheet()->getStyle($cellRange)->applyFromArray($styleArray);
127		}
128		}
129	10	}
130
131	6	private function addBorderDiagonal(SimpleXMLElement $srssb, array &$styleArray): void
132		{
133	6	if (isset($srssb->Diagonal, $srssb->{'Rev-Diagonal'})) {
134	6	$styleArray['borders']['diagonal'] = self::parseBorderAttributes($srssb->Diagonal->attributes());
135	6	$styleArray['borders']['diagonalDirection'] = Borders::DIAGONAL_BOTH;
136	4	} elseif (isset($srssb->Diagonal)) {
137	4	$styleArray['borders']['diagonal'] = self::parseBorderAttributes($srssb->Diagonal->attributes());
138	4	$styleArray['borders']['diagonalDirection'] = Borders::DIAGONAL_UP;
139	4	} elseif (isset($srssb->{'Rev-Diagonal'})) {
140	4	$styleArray['borders']['diagonal'] = self::parseBorderAttributes($srssb->{'Rev-Diagonal'}->attributes());
141	4	$styleArray['borders']['diagonalDirection'] = Borders::DIAGONAL_DOWN;
142		}
143	6	}
144
145	6	private function addBorderStyle(SimpleXMLElement $srssb, array &$styleArray, string $direction): void
146		{
147	6	$ucDirection = ucfirst($direction);
148	6	if (isset($srssb->$ucDirection)) {
149	6	$styleArray['borders'][$direction] = self::parseBorderAttributes($srssb->$ucDirection->attributes());
150		}
151	6	}
152
153	10	private function calcRotation(SimpleXMLElement $styleAttributes): int
154		{
155	10	$rotation = (int) $styleAttributes->Rotation;
156	10	if ($rotation >= 270 && $rotation <= 360) {
157	4	$rotation -= 360;
158		}
159	10	$rotation = (abs($rotation) > 90) ? 0 : $rotation;
160
161	10	return $rotation;
162		}
163
164	6	private static function addStyle(array &$styleArray, string $key, string $value): void
165		{
166	6	if (array_key_exists($value, self::$mappings[$key])) {
167	6	$styleArray[$key] = self::$mappings[$key][$value];
168		}
169	6	}
170
171	10	private static function addStyle2(array &$styleArray, string $key1, string $key, string $value): void
172		{
173	10	if (array_key_exists($value, self::$mappings[$key])) {
174	6	$styleArray[$key1][$key] = self::$mappings[$key][$value];
175		}
176	10	}
177
178	6	private static function parseBorderAttributes(?SimpleXMLElement $borderAttributes): array
179		{
180	6	$styleArray = [];
181	6	if ($borderAttributes !== null) {
182	6	if (isset($borderAttributes['Color'])) {
183	4	$styleArray['color']['rgb'] = self::parseGnumericColour($borderAttributes['Color']);
184		}
185
186	6	self::addStyle($styleArray, 'borderStyle', $borderAttributes['Style']);
187		}
188
189	6	return $styleArray;
190		}
191
192	10	private static function parseGnumericColour(string $gnmColour): string
193		{
194	10	[$gnmR, $gnmG, $gnmB] = explode(':', $gnmColour);
195	10	$gnmR = substr(str_pad($gnmR, 4, '0', STR_PAD_RIGHT), 0, 2);
196	10	$gnmG = substr(str_pad($gnmG, 4, '0', STR_PAD_RIGHT), 0, 2);
197	10	$gnmB = substr(str_pad($gnmB, 4, '0', STR_PAD_RIGHT), 0, 2);
198
199	10	return $gnmR . $gnmG . $gnmB;
200		}
201
202	10	private function addColors(array &$styleArray, SimpleXMLElement $styleAttributes): void
203		{
204	10	$RGB = self::parseGnumericColour($styleAttributes['Fore']);
205	10	$styleArray['font']['color']['rgb'] = $RGB;
206	10	$RGB = self::parseGnumericColour($styleAttributes['Back']);
207	10	$shade = (string) $styleAttributes['Shade'];
208	10	if (($RGB !== '000000') \|\| ($shade !== '0')) {
209	10	$RGB2 = self::parseGnumericColour($styleAttributes['PatternColor']);
210	10	if ($shade === '1') {
211	4	$styleArray['fill']['startColor']['rgb'] = $RGB;
212	4	$styleArray['fill']['endColor']['rgb'] = $RGB2;
213		} else {
214	10	$styleArray['fill']['endColor']['rgb'] = $RGB;
215	10	$styleArray['fill']['startColor']['rgb'] = $RGB2;
216		}
217	10	self::addStyle2($styleArray, 'fill', 'fillType', $shade);
218		}
219	10	}
220
221	10	private function readStyleRange(SimpleXMLElement $styleAttributes, int $maxCol, int $maxRow): string
222		{
223	10	$startColumn = Coordinate::stringFromColumnIndex((int) $styleAttributes['startCol'] + 1);
224	10	$startRow = $styleAttributes['startRow'] + 1;
225
226	10	$endColumn = ($styleAttributes['endCol'] > $maxCol) ? $maxCol : (int) $styleAttributes['endCol'];
227	10	$endColumn = Coordinate::stringFromColumnIndex($endColumn + 1);
228
229	10	$endRow = 1 + (($styleAttributes['endRow'] > $maxRow) ? $maxRow : (int) $styleAttributes['endRow']);
230	10	$cellRange = $startColumn . $startRow . ':' . $endColumn . $endRow;
231
232	10	return $cellRange;
233		}
234
235	10	private function readStyle(array $styleArray, SimpleXMLElement $styleAttributes, SimpleXMLElement $style): array
236		{
237	10	self::addStyle2($styleArray, 'alignment', 'horizontal', $styleAttributes['HAlign']);
238	10	self::addStyle2($styleArray, 'alignment', 'vertical', $styleAttributes['VAlign']);
239	10	$styleArray['alignment']['wrapText'] = $styleAttributes['WrapText'] == '1';
240	10	$styleArray['alignment']['textRotation'] = $this->calcRotation($styleAttributes);
241	10	$styleArray['alignment']['shrinkToFit'] = $styleAttributes['ShrinkToFit'] == '1';
242	10	$styleArray['alignment']['indent'] = ((int) ($styleAttributes['Indent']) > 0) ? $styleAttributes['indent'] : 0;
243
244	10	$this->addColors($styleArray, $styleAttributes);
245
246	10	$fontAttributes = $style->Style->Font->attributes();
247	10	if ($fontAttributes !== null) {
248	10	$styleArray['font']['name'] = (string) $style->Style->Font;
249	10	$styleArray['font']['size'] = (int) ($fontAttributes['Unit']);
250	10	$styleArray['font']['bold'] = $fontAttributes['Bold'] == '1';
251	10	$styleArray['font']['italic'] = $fontAttributes['Italic'] == '1';
252	10	$styleArray['font']['strikethrough'] = $fontAttributes['StrikeThrough'] == '1';
253	10	self::addStyle2($styleArray, 'font', 'underline', $fontAttributes['Underline']);
254
255	10	switch ($fontAttributes['Script']) {
256	10	case '1':
257	4	$styleArray['font']['superscript'] = true;
258
259	4	break;
260	10	case '-1':
261	4	$styleArray['font']['subscript'] = true;
262
263	4	break;
264		}
265		}
266
267	10	if (isset($style->Style->StyleBorder)) {
268	6	$srssb = $style->Style->StyleBorder;
269	6	$this->addBorderStyle($srssb, $styleArray, 'top');
270	6	$this->addBorderStyle($srssb, $styleArray, 'bottom');
271	6	$this->addBorderStyle($srssb, $styleArray, 'left');
272	6	$this->addBorderStyle($srssb, $styleArray, 'right');
273	6	$this->addBorderDiagonal($srssb, $styleArray);
274		}
275	10	if (isset($style->Style->HyperLink)) {
276		// TO DO
277	4	$hyperlink = $style->Style->HyperLink->attributes();
		0 ignored issues – show Unused Code introduced 2017-12-03 09:09 UTC by Report Bug Copy Issue Report The assignment to `$hyperlink` is dead and can be removed. Loading history...
278		}
279
280	10	return $styleArray;
281		}
282		}
283

PHPOffice / PhpSpreadsheet

Push — master ( d2e6db...2ddb23 )

Styles::__construct() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like