@@ -222,7 +222,7 @@ discard block |
||
222 | 222 | } |
223 | 223 | |
224 | 224 | /** @param mixed[] $rowData */ |
225 | - private function processCRecord(array $rowData, Spreadsheet &$spreadsheet, string &$row, string &$column): void |
|
225 | + private function processCRecord(array $rowData, Spreadsheet & $spreadsheet, string &$row, string &$column): void |
|
226 | 226 | { |
227 | 227 | // Read cell value data |
228 | 228 | $hasCalculatedValue = false; |
@@ -297,7 +297,7 @@ discard block |
||
297 | 297 | $this->processCFinal($spreadsheet, $hasCalculatedValue, $cellDataFormula, $cellData, "$columnLetter$row", $tryNumeric); |
298 | 298 | } |
299 | 299 | |
300 | - private function processCFinal(Spreadsheet &$spreadsheet, bool $hasCalculatedValue, string $cellDataFormula, string $cellData, string $coordinate, bool $tryNumeric): void |
|
300 | + private function processCFinal(Spreadsheet & $spreadsheet, bool $hasCalculatedValue, string $cellDataFormula, string $cellData, string $coordinate, bool $tryNumeric): void |
|
301 | 301 | { |
302 | 302 | // Set cell value |
303 | 303 | $spreadsheet->getActiveSheet()->getCell($coordinate)->setValue(($hasCalculatedValue) ? $cellDataFormula : $cellData); |
@@ -308,7 +308,7 @@ discard block |
||
308 | 308 | } |
309 | 309 | |
310 | 310 | /** @param mixed[] $rowData */ |
311 | - private function processFRecord(array $rowData, Spreadsheet &$spreadsheet, string &$row, string &$column): void |
|
311 | + private function processFRecord(array $rowData, Spreadsheet & $spreadsheet, string &$row, string &$column): void |
|
312 | 312 | { |
313 | 313 | // Read cell formatting |
314 | 314 | $formatStyle = $columnWidth = ''; |
@@ -379,7 +379,7 @@ discard block |
||
379 | 379 | } |
380 | 380 | } |
381 | 381 | |
382 | - private function addFormats(Spreadsheet &$spreadsheet, string $formatStyle, string $row, string $column): void |
|
382 | + private function addFormats(Spreadsheet & $spreadsheet, string $formatStyle, string $row, string $column): void |
|
383 | 383 | { |
384 | 384 | if ($formatStyle && $column > '' && $row > '') { |
385 | 385 | $columnLetter = Coordinate::stringFromColumnIndex((int) $column); |
@@ -389,7 +389,7 @@ discard block |
||
389 | 389 | } |
390 | 390 | } |
391 | 391 | |
392 | - private function addFonts(Spreadsheet &$spreadsheet, string $fontStyle, string $row, string $column): void |
|
392 | + private function addFonts(Spreadsheet & $spreadsheet, string $fontStyle, string $row, string $column): void |
|
393 | 393 | { |
394 | 394 | if ($fontStyle && $column > '' && $row > '') { |
395 | 395 | $columnLetter = Coordinate::stringFromColumnIndex((int) $column); |
@@ -400,7 +400,7 @@ discard block |
||
400 | 400 | } |
401 | 401 | |
402 | 402 | /** @param mixed[] $styleData */ |
403 | - private function addStyle(Spreadsheet &$spreadsheet, array $styleData, string $row, string $column): void |
|
403 | + private function addStyle(Spreadsheet & $spreadsheet, array $styleData, string $row, string $column): void |
|
404 | 404 | { |
405 | 405 | if ((!empty($styleData)) && $column > '' && $row > '') { |
406 | 406 | $columnLetter = Coordinate::stringFromColumnIndex((int) $column); |
@@ -427,7 +427,7 @@ discard block |
||
427 | 427 | } |
428 | 428 | |
429 | 429 | /** @param string[] $rowData */ |
430 | - private function processPRecord(array $rowData, Spreadsheet &$spreadsheet): void |
|
430 | + private function processPRecord(array $rowData, Spreadsheet & $spreadsheet): void |
|
431 | 431 | { |
432 | 432 | // Read shared styles |
433 | 433 | $formatArray = []; |
@@ -484,7 +484,7 @@ discard block |
||
484 | 484 | } |
485 | 485 | |
486 | 486 | /** @param mixed[] $formatArray */ |
487 | - private function processPFinal(Spreadsheet &$spreadsheet, array $formatArray): void |
|
487 | + private function processPFinal(Spreadsheet & $spreadsheet, array $formatArray): void |
|
488 | 488 | { |
489 | 489 | if (array_key_exists('numberFormat', $formatArray)) { |
490 | 490 | $this->formats['P' . $this->format] = $formatArray; |
@@ -119,7 +119,7 @@ |
||
119 | 119 | } |
120 | 120 | |
121 | 121 | /** @param null|string|string[] $sheetList */ |
122 | - public function setLoadSheetsOnly(string|array|null $sheetList): self |
|
122 | + public function setLoadSheetsOnly(string | array | null $sheetList): self |
|
123 | 123 | { |
124 | 124 | if ($sheetList === null) { |
125 | 125 | return $this->setLoadAllSheets(); |
@@ -39,7 +39,7 @@ discard block |
||
39 | 39 | } |
40 | 40 | |
41 | 41 | #[DataProvider('providerTimeOnly')] |
42 | - public function testTimeOnly(int|float $expectedResult, int|float|string $value, ?string $format = null): void |
|
42 | + public function testTimeOnly(int | float $expectedResult, int | float | string $value, ?string $format = null): void |
|
43 | 43 | { |
44 | 44 | Cell::setCalculateDateTimeType(Cell::CALCULATE_TIME_FLOAT); |
45 | 45 | $spreadsheet = $this->spreadsheet = new Spreadsheet(); |
@@ -84,7 +84,7 @@ discard block |
||
84 | 84 | } |
85 | 85 | |
86 | 86 | #[DataProvider('providerDateAndTime')] |
87 | - public function testDateAndTime(int|float $expectedResult, int|float|string $value, ?string $format = null): void |
|
87 | + public function testDateAndTime(int | float $expectedResult, int | float | string $value, ?string $format = null): void |
|
88 | 88 | { |
89 | 89 | Cell::setCalculateDateTimeType( |
90 | 90 | Cell::CALCULATE_DATE_TIME_FLOAT |
@@ -131,7 +131,7 @@ discard block |
||
131 | 131 | } |
132 | 132 | |
133 | 133 | #[DataProvider('providerAsis')] |
134 | - public function testDefault(int|float $expectedResult, int|float|string $value, ?string $format = null): void |
|
134 | + public function testDefault(int | float $expectedResult, int | float | string $value, ?string $format = null): void |
|
135 | 135 | { |
136 | 136 | $spreadsheet = $this->spreadsheet = new Spreadsheet(); |
137 | 137 | self::assertSame(0, $spreadsheet->getActiveSheetIndex()); |
@@ -152,7 +152,7 @@ discard block |
||
152 | 152 | } |
153 | 153 | |
154 | 154 | #[DataProvider('providerAsis')] |
155 | - public function testAsis(int|float $expectedResult, int|float|string $value, ?string $format = null): void |
|
155 | + public function testAsis(int | float $expectedResult, int | float | string $value, ?string $format = null): void |
|
156 | 156 | { |
157 | 157 | Cell::setCalculateDateTimeType( |
158 | 158 | Cell::CALCULATE_DATE_TIME_ASIS |
@@ -2070,13 +2070,13 @@ discard block |
||
2070 | 2070 | } |
2071 | 2071 | |
2072 | 2072 | /** @param null|bool|mixed[]|SimpleXMLElement $array */ |
2073 | - private static function getArrayItem(null|array|bool|SimpleXMLElement $array, int|string $key = 0): mixed |
|
2073 | + private static function getArrayItem(null | array | bool | SimpleXMLElement $array, int | string $key = 0): mixed |
|
2074 | 2074 | { |
2075 | 2075 | return ($array === null || is_bool($array)) ? null : ($array[$key] ?? null); |
2076 | 2076 | } |
2077 | 2077 | |
2078 | 2078 | /** @param null|bool|mixed[]|SimpleXMLElement $array */ |
2079 | - private static function getArrayItemString(null|array|bool|SimpleXMLElement $array, int|string $key = 0): string |
|
2079 | + private static function getArrayItemString(null | array | bool | SimpleXMLElement $array, int | string $key = 0): string |
|
2080 | 2080 | { |
2081 | 2081 | $retVal = self::getArrayItem($array, $key); |
2082 | 2082 | |
@@ -2084,14 +2084,14 @@ discard block |
||
2084 | 2084 | } |
2085 | 2085 | |
2086 | 2086 | /** @param null|bool|mixed[]|SimpleXMLElement $array */ |
2087 | - private static function getArrayItemIntOrSxml(null|array|bool|SimpleXMLElement $array, int|string $key = 0): int|SimpleXMLElement |
|
2087 | + private static function getArrayItemIntOrSxml(null | array | bool | SimpleXMLElement $array, int | string $key = 0): int | SimpleXMLElement |
|
2088 | 2088 | { |
2089 | 2089 | $retVal = self::getArrayItem($array, $key); |
2090 | 2090 | |
2091 | 2091 | return (is_int($retVal) || $retVal instanceof SimpleXMLElement) ? $retVal : 0; |
2092 | 2092 | } |
2093 | 2093 | |
2094 | - private static function dirAdd(null|SimpleXMLElement|string $base, null|SimpleXMLElement|string $add): string |
|
2094 | + private static function dirAdd(null | SimpleXMLElement | string $base, null | SimpleXMLElement | string $add): string |
|
2095 | 2095 | { |
2096 | 2096 | $base = (string) $base; |
2097 | 2097 | $add = (string) $add; |
@@ -262,7 +262,7 @@ discard block |
||
262 | 262 | * |
263 | 263 | * @param-out string $cellContent In one case, it can be bool |
264 | 264 | */ |
265 | - protected function flushCell(Worksheet $sheet, string $column, int|string $row, mixed &$cellContent, array $attributeArray): void |
|
265 | + protected function flushCell(Worksheet $sheet, string $column, int | string $row, mixed &$cellContent, array $attributeArray): void |
|
266 | 266 | { |
267 | 267 | if (is_string($cellContent)) { |
268 | 268 | // Simple String content |
@@ -312,7 +312,7 @@ discard block |
||
312 | 312 | /** @var array<int, array<int, string>> */ |
313 | 313 | private static array $falseTrueArray = []; |
314 | 314 | |
315 | - private static function convertBoolean(?string $cellContent): bool|string |
|
315 | + private static function convertBoolean(?string $cellContent): bool | string |
|
316 | 316 | { |
317 | 317 | if ($cellContent === '1') { |
318 | 318 | return true; |
@@ -919,7 +919,7 @@ discard block |
||
919 | 919 | * |
920 | 920 | * @param string[] $attributeArray |
921 | 921 | */ |
922 | - private function applyInlineStyle(Worksheet &$sheet, int $row, string $column, array $attributeArray): void |
|
922 | + private function applyInlineStyle(Worksheet & $sheet, int $row, string $column, array $attributeArray): void |
|
923 | 923 | { |
924 | 924 | if (!isset($attributeArray['style'])) { |
925 | 925 | return; |
@@ -298,7 +298,7 @@ discard block |
||
298 | 298 | { |
299 | 299 | }*/ |
300 | 300 | |
301 | - private function readCFFormula(string $recordData, int $offset, int $size, Xls $xls): float|int|string|null |
|
301 | + private function readCFFormula(string $recordData, int $offset, int $size, Xls $xls): float | int | string | null |
|
302 | 302 | { |
303 | 303 | try { |
304 | 304 | $formula = substr($recordData, $offset, $size); |
@@ -316,7 +316,7 @@ discard block |
||
316 | 316 | } |
317 | 317 | |
318 | 318 | /** @param string[] $cellRanges */ |
319 | - private function setCFRules(array $cellRanges, string $type, string $operator, null|float|int|string $formula1, null|float|int|string $formula2, Style $style, bool $noFormatSet, Xls $xls): void |
|
319 | + private function setCFRules(array $cellRanges, string $type, string $operator, null | float | int | string $formula1, null | float | int | string $formula2, Style $style, bool $noFormatSet, Xls $xls): void |
|
320 | 320 | { |
321 | 321 | foreach ($cellRanges as $cellRange) { |
322 | 322 | $conditional = new Conditional(); |
@@ -309,7 +309,7 @@ |
||
309 | 309 | return $dataBar; |
310 | 310 | } |
311 | 311 | |
312 | - private function readColorScale(SimpleXMLElement|stdClass $cfRule): ConditionalColorScale |
|
312 | + private function readColorScale(SimpleXMLElement | stdClass $cfRule): ConditionalColorScale |
|
313 | 313 | { |
314 | 314 | $colorScale = new ConditionalColorScale(); |
315 | 315 | /** @var SimpleXMLElement $cfRule */ |
@@ -91,7 +91,7 @@ |
||
91 | 91 | } |
92 | 92 | |
93 | 93 | /** @param null|false|scalar[] $array */ |
94 | - private function getArrayItem(null|array|false $array): string |
|
94 | + private function getArrayItem(null | array | false $array): string |
|
95 | 95 | { |
96 | 96 | return is_array($array) ? (string) ($array[0] ?? '') : ''; |
97 | 97 | } |
@@ -69,7 +69,7 @@ |
||
69 | 69 | * |
70 | 70 | * @var null|array<string, mixed[]> |
71 | 71 | */ |
72 | - private static ?array $cachedStyles = null; |
|
72 | + private static ? array $cachedStyles = null; |
|
73 | 73 | |
74 | 74 | /** |
75 | 75 | * Create a new Style. |