@@ -1176,8 +1176,8 @@ |
||
1176 | 1176 | $objWriter->startElement('c:numFmt'); |
1177 | 1177 | $objWriter->writeAttribute('formatCode', 'General'); |
1178 | 1178 | $objWriter->writeAttribute('sourceLinked', '0'); |
1179 | - $objWriter->endElement(); // numFmt |
|
1180 | - $objWriter->endElement(); // trendlineLbl |
|
1179 | + $objWriter->endElement(); // numFmt |
|
1180 | + $objWriter->endElement(); // trendlineLbl |
|
1181 | 1181 | } |
1182 | 1182 | |
1183 | 1183 | $objWriter->endElement(); // trendline |
@@ -116,8 +116,8 @@ |
||
116 | 116 | true, // plotVisibleOnly |
117 | 117 | DataSeries::EMPTY_AS_GAP, // displayBlanksAs |
118 | 118 | null, // xAxisLabel |
119 | - $yAxisLabel, // yAxisLabel |
|
120 | - $xAxis, // xAxis |
|
119 | + $yAxisLabel, // yAxisLabel |
|
120 | + $xAxis, // xAxis |
|
121 | 121 | $yAxis // yAxis |
122 | 122 | ); |
123 | 123 |
@@ -67,12 +67,12 @@ discard block |
||
67 | 67 | ["[\$€-fy-NL]\u{a0}#,##0.00;[\$€-fy-NL]\u{a0}#,##0.00-", '€', 'fy-NL'], // Trailing negative |
68 | 68 | ["[\$€-nl-NL]\u{a0}#,##0.00;[\$€-nl-NL]\u{a0}-#,##0.00", '€', 'nl-NL'], // Sign between currency and value |
69 | 69 | ["[\$€-nl-BE]\u{a0}#,##0.00;[\$€-nl-BE]\u{a0}-#,##0.00", '€', 'NL-BE'], // Sign between currency and value |
70 | - ["#,##0.00\u{a0}[\$€-fr-BE]", '€', 'fr-be'], // Trailing currency code |
|
71 | - ["#,##0.00\u{a0}[\$€-el-GR]", '€', 'el-gr'], // Trailing currency code |
|
70 | + ["#,##0.00\u{a0}[\$€-fr-BE]", '€', 'fr-be'], // Trailing currency code |
|
71 | + ["#,##0.00\u{a0}[\$€-el-GR]", '€', 'el-gr'], // Trailing currency code |
|
72 | 72 | ['[$$-en-CA]#,##0.00', '$', 'en-ca'], |
73 | - ["#,##0.00\u{a0}[\$\$-fr-CA]", '$', 'fr-ca'], // Trailing currency code |
|
73 | + ["#,##0.00\u{a0}[\$\$-fr-CA]", '$', 'fr-ca'], // Trailing currency code |
|
74 | 74 | ['[$¥-ja-JP]#,##0', '¥', 'ja-JP'], // No decimals |
75 | - ["#,##0.000\u{a0}[\$د.ب\u{200e}-ar-BH]", "د.ب\u{200e}", 'ar-BH', true], // 3 decimals |
|
75 | + ["#,##0.000\u{a0}[\$د.ب\u{200e}-ar-BH]", "د.ب\u{200e}", 'ar-BH', true], // 3 decimals |
|
76 | 76 | ]; |
77 | 77 | } |
78 | 78 | |
@@ -130,12 +130,12 @@ discard block |
||
130 | 130 | ["[\$€-fy-NL]\u{a0}#,##0;[\$€-fy-NL]\u{a0}#,##0-", '€', 'fy-NL'], // Trailing negative |
131 | 131 | ["[\$€-nl-NL]\u{a0}#,##0;[\$€-nl-NL]\u{a0}-#,##0", '€', 'nl-NL'], // Sign between currency and value |
132 | 132 | ["[\$€-nl-BE]\u{a0}#,##0;[\$€-nl-BE]\u{a0}-#,##0", '€', 'NL-BE'], // Sign between currency and value |
133 | - ["#,##0\u{a0}[\$€-fr-BE]", '€', 'fr-be'], // Trailing currency code |
|
134 | - ["#,##0\u{a0}[\$€-el-GR]", '€', 'el-gr'], // Trailing currency code |
|
133 | + ["#,##0\u{a0}[\$€-fr-BE]", '€', 'fr-be'], // Trailing currency code |
|
134 | + ["#,##0\u{a0}[\$€-el-GR]", '€', 'el-gr'], // Trailing currency code |
|
135 | 135 | ['[$$-en-CA]#,##0', '$', 'en-ca'], |
136 | - ["#,##0\u{a0}[\$\$-fr-CA]", '$', 'fr-ca'], // Trailing currency code |
|
136 | + ["#,##0\u{a0}[\$\$-fr-CA]", '$', 'fr-ca'], // Trailing currency code |
|
137 | 137 | ['[$¥-ja-JP]#,##0', '¥', 'ja-JP'], // No decimals to truncate |
138 | - ["#,##0\u{a0}[\$د.ب\u{200e}-ar-BH]", "د.ب\u{200e}", 'ar-BH', true], // 3 decimals truncated to none |
|
138 | + ["#,##0\u{a0}[\$د.ب\u{200e}-ar-BH]", "د.ب\u{200e}", 'ar-BH', true], // 3 decimals truncated to none |
|
139 | 139 | ]; |
140 | 140 | } |
141 | 141 |
@@ -72,7 +72,7 @@ discard block |
||
72 | 72 | ['[$$-en-CA]#,##0.00;([$$-en-CA]#,##0.00)', '$', 'en-ca'], |
73 | 73 | ["#,##0.00\u{a0}[\$\$-fr-CA];(#,##0.00\u{a0}[\$\$-fr-CA])", '$', 'fr-ca'], |
74 | 74 | ['[$¥-ja-JP]#,##0;([$¥-ja-JP]#,##0)', '¥', 'ja-JP'], // No decimals |
75 | - ["#,##0.000\u{a0}[\$د.ب\u{200e}-ar-BH]", "د.ب\u{200e}", 'ar-BH', true], // 3 decimals |
|
75 | + ["#,##0.000\u{a0}[\$د.ب\u{200e}-ar-BH]", "د.ب\u{200e}", 'ar-BH', true], // 3 decimals |
|
76 | 76 | ]; |
77 | 77 | } |
78 | 78 | |
@@ -135,7 +135,7 @@ discard block |
||
135 | 135 | ['[$$-en-CA]#,##0;([$$-en-CA]#,##0)', '$', 'en-ca'], |
136 | 136 | ["#,##0\u{a0}[\$\$-fr-CA];(#,##0\u{a0}[\$\$-fr-CA])", '$', 'fr-ca'], |
137 | 137 | ['[$¥-ja-JP]#,##0;([$¥-ja-JP]#,##0)', '¥', 'ja-JP'], // No decimals to truncate |
138 | - ["#,##0\u{a0}[\$د.ب\u{200e}-ar-BH]", "د.ب\u{200e}", 'ar-BH', true], // 3 decimals truncated to none |
|
138 | + ["#,##0\u{a0}[\$د.ب\u{200e}-ar-BH]", "د.ب\u{200e}", 'ar-BH', true], // 3 decimals truncated to none |
|
139 | 139 | ]; |
140 | 140 | } |
141 | 141 |
@@ -266,7 +266,7 @@ discard block |
||
266 | 266 | $hasCalculatedValue = true; |
267 | 267 | } |
268 | 268 | |
269 | - private function processCRecord(array $rowData, Spreadsheet &$spreadsheet, string &$row, string &$column): void |
|
269 | + private function processCRecord(array $rowData, Spreadsheet & $spreadsheet, string &$row, string &$column): void |
|
270 | 270 | { |
271 | 271 | // Read cell value data |
272 | 272 | $hasCalculatedValue = false; |
@@ -311,7 +311,7 @@ discard block |
||
311 | 311 | $this->processCFinal($spreadsheet, $hasCalculatedValue, $cellDataFormula, $cellData, "$columnLetter$row", $tryNumeric); |
312 | 312 | } |
313 | 313 | |
314 | - private function processCFinal(Spreadsheet &$spreadsheet, bool $hasCalculatedValue, string $cellDataFormula, string $cellData, string $coordinate, bool $tryNumeric): void |
|
314 | + private function processCFinal(Spreadsheet & $spreadsheet, bool $hasCalculatedValue, string $cellDataFormula, string $cellData, string $coordinate, bool $tryNumeric): void |
|
315 | 315 | { |
316 | 316 | // Set cell value |
317 | 317 | $spreadsheet->getActiveSheet()->getCell($coordinate)->setValue(($hasCalculatedValue) ? $cellDataFormula : $cellData); |
@@ -321,7 +321,7 @@ discard block |
||
321 | 321 | } |
322 | 322 | } |
323 | 323 | |
324 | - private function processFRecord(array $rowData, Spreadsheet &$spreadsheet, string &$row, string &$column): void |
|
324 | + private function processFRecord(array $rowData, Spreadsheet & $spreadsheet, string &$row, string &$column): void |
|
325 | 325 | { |
326 | 326 | // Read cell formatting |
327 | 327 | $formatStyle = $columnWidth = ''; |
@@ -389,7 +389,7 @@ discard block |
||
389 | 389 | } |
390 | 390 | } |
391 | 391 | |
392 | - private function addFormats(Spreadsheet &$spreadsheet, string $formatStyle, string $row, string $column): void |
|
392 | + private function addFormats(Spreadsheet & $spreadsheet, string $formatStyle, string $row, string $column): void |
|
393 | 393 | { |
394 | 394 | if ($formatStyle && $column > '' && $row > '') { |
395 | 395 | $columnLetter = Coordinate::stringFromColumnIndex((int) $column); |
@@ -399,7 +399,7 @@ discard block |
||
399 | 399 | } |
400 | 400 | } |
401 | 401 | |
402 | - private function addFonts(Spreadsheet &$spreadsheet, string $fontStyle, string $row, string $column): void |
|
402 | + private function addFonts(Spreadsheet & $spreadsheet, string $fontStyle, string $row, string $column): void |
|
403 | 403 | { |
404 | 404 | if ($fontStyle && $column > '' && $row > '') { |
405 | 405 | $columnLetter = Coordinate::stringFromColumnIndex((int) $column); |
@@ -409,7 +409,7 @@ discard block |
||
409 | 409 | } |
410 | 410 | } |
411 | 411 | |
412 | - private function addStyle(Spreadsheet &$spreadsheet, array $styleData, string $row, string $column): void |
|
412 | + private function addStyle(Spreadsheet & $spreadsheet, array $styleData, string $row, string $column): void |
|
413 | 413 | { |
414 | 414 | if ((!empty($styleData)) && $column > '' && $row > '') { |
415 | 415 | $columnLetter = Coordinate::stringFromColumnIndex((int) $column); |
@@ -434,7 +434,7 @@ discard block |
||
434 | 434 | } |
435 | 435 | } |
436 | 436 | |
437 | - private function processPRecord(array $rowData, Spreadsheet &$spreadsheet): void |
|
437 | + private function processPRecord(array $rowData, Spreadsheet & $spreadsheet): void |
|
438 | 438 | { |
439 | 439 | // Read shared styles |
440 | 440 | $formatArray = []; |
@@ -487,7 +487,7 @@ discard block |
||
487 | 487 | } |
488 | 488 | } |
489 | 489 | |
490 | - private function processPFinal(Spreadsheet &$spreadsheet, array $formatArray): void |
|
490 | + private function processPFinal(Spreadsheet & $spreadsheet, array $formatArray): void |
|
491 | 491 | { |
492 | 492 | if (array_key_exists('numberFormat', $formatArray)) { |
493 | 493 | $this->formats['P' . $this->format] = $formatArray; |
@@ -21,7 +21,7 @@ |
||
21 | 21 | * |
22 | 22 | * @param string|string[] $color HEX color or array with HEX colors |
23 | 23 | */ |
24 | - private function buildChartSpreadsheet(string|array $color): Spreadsheet |
|
24 | + private function buildChartSpreadsheet(string | array $color): Spreadsheet |
|
25 | 25 | { |
26 | 26 | // Problem occurs when setting plot line color |
27 | 27 | // The output chart xml file is missing the a:ln tag |
@@ -132,7 +132,7 @@ |
||
132 | 132 | return $this->sheet; |
133 | 133 | } |
134 | 134 | |
135 | - public function prepareWorksheetWithFormula(string $functionName, array $database, null|int|string $field, array $criteria): void |
|
135 | + public function prepareWorksheetWithFormula(string $functionName, array $database, null | int | string $field, array $criteria): void |
|
136 | 136 | { |
137 | 137 | $sheet = $this->getSheet(); |
138 | 138 | $maxCol = ''; |
@@ -29,7 +29,7 @@ |
||
29 | 29 | /** |
30 | 30 | * Image resource. |
31 | 31 | */ |
32 | - private null|GdImage $imageResource = null; |
|
32 | + private null | GdImage $imageResource = null; |
|
33 | 33 | |
34 | 34 | /** |
35 | 35 | * Rendering function. |
@@ -3,7 +3,7 @@ discard block |
||
3 | 3 | declare(strict_types=1); |
4 | 4 | |
5 | 5 | return [ |
6 | - [ // Office reference example #1 |
|
6 | + [// Office reference example #1 |
|
7 | 7 | 'orange', |
8 | 8 | 4.19, |
9 | 9 | [ |
@@ -21,7 +21,7 @@ discard block |
||
21 | 21 | ['blue'], |
22 | 22 | ], |
23 | 23 | ], |
24 | - [ // Office reference example #2 |
|
24 | + [// Office reference example #2 |
|
25 | 25 | 'yellow', |
26 | 26 | 5.75, |
27 | 27 | [ |
@@ -39,7 +39,7 @@ discard block |
||
39 | 39 | ['blue'], |
40 | 40 | ], |
41 | 41 | ], |
42 | - [ // Office reference example #3 |
|
42 | + [// Office reference example #3 |
|
43 | 43 | 'blue', |
44 | 44 | 7.66, |
45 | 45 | [ |
@@ -57,7 +57,7 @@ discard block |
||
57 | 57 | ['blue'], |
58 | 58 | ], |
59 | 59 | ], |
60 | - [ // Office reference example #4 |
|
60 | + [// Office reference example #4 |
|
61 | 61 | '#N/A', |
62 | 62 | 0, |
63 | 63 | [ |
@@ -75,7 +75,7 @@ discard block |
||
75 | 75 | ['blue'], |
76 | 76 | ], |
77 | 77 | ], |
78 | - [ // Array form test |
|
78 | + [// Array form test |
|
79 | 79 | 'orange', |
80 | 80 | 4.2, |
81 | 81 | [ |