PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Calculation/LookupRef/ChooseRowsEtc.php

Spacing +7 added lines, -7 removed lines

@@ -34,7 +34,7 @@ 
      *
      * @return mixed[]|string
      */
-    public static function chooseCols(mixed $input, mixed ...$args): array|string
+    public static function chooseCols(mixed $input, mixed ...$args): array | string
     {
         if (!is_array($input)) {
             $input = [[$input]];
@@ -51,7 +51,7 @@ 
      *
      * @return mixed[]|string
      */
-    public static function chooseRows(mixed $input, mixed ...$args): array|string
+    public static function chooseRows(mixed $input, mixed ...$args): array | string
     {
         if (!is_array($input)) {
             $input = [[$input]];
@@ -85,7 +85,7 @@ 
      *
      * @return mixed[]|string
      */
-    private static function dropRows(array $array, mixed $offset): array|string
+    private static function dropRows(array $array, mixed $offset): array | string
     {
         if ($offset === null) {
             return $array;
@@ -117,7 +117,7 @@ 
      *
      * @return mixed[]|string
      */
-    public static function drop(mixed $input, mixed $rows = null, mixed $columns = null): array|string
+    public static function drop(mixed $input, mixed $rows = null, mixed $columns = null): array | string
     {
         if (!is_array($input)) {
             $input = [[$input]];
@@ -144,7 +144,7 @@ 
      *
      * @return mixed[]|string
      */
-    private static function takeRows(array $array, mixed $offset): array|string
+    private static function takeRows(array $array, mixed $offset): array | string
     {
         if ($offset === null) {
             return $array;
@@ -175,7 +175,7 @@ 
      *
      * @return mixed[]|string
      */
-    public static function take(mixed $input, mixed $rows, mixed $columns = null): array|string
+    public static function take(mixed $input, mixed $rows, mixed $columns = null): array | string
     {
         if (!is_array($input)) {
             $input = [[$input]];
@@ -207,7 +207,7 @@ 
      *
      * @return mixed[]|string
      */
-    public static function expand(mixed $input, mixed $rows, mixed $columns = null, mixed $pad = '#N/A'): array|string
+    public static function expand(mixed $input, mixed $rows, mixed $columns = null, mixed $pad = '#N/A'): array | string
     {
         if (!is_array($input)) {
             $input = [[$input]];

src/PhpSpreadsheet/Calculation/LookupRef/ExcelMatch.php

Spacing +3 added lines, -3 removed lines

@@ -32,7 +32,7 @@ 
      *
      * @return array<mixed>|float|int|string The relative position of the found item
      */
-    public static function MATCH(mixed $lookupValue, mixed $lookupArray, mixed $matchType = self::MATCHTYPE_LARGEST_VALUE): array|string|int|float
+    public static function MATCH(mixed $lookupValue, mixed $lookupArray, mixed $matchType = self::MATCHTYPE_LARGEST_VALUE): array | string | int | float
     {
         if (is_array($lookupValue)) {
             return self::evaluateArrayArgumentsIgnore([self::class, __FUNCTION__], 1, $lookupValue, $lookupArray, $matchType);
@@ -78,7 +78,7 @@ 
     }
 
     /** @param mixed[] $lookupArray */
-    private static function matchFirstValue(array $lookupArray, mixed $lookupValue): int|string|null
+    private static function matchFirstValue(array $lookupArray, mixed $lookupValue): int | string | null
     {
         if (is_string($lookupValue)) {
             $valueIsString = true;
@@ -153,7 +153,7 @@ 
     }
 
     /** @param mixed[] $lookupArray */
-    private static function matchSmallestValue(array $lookupArray, mixed $lookupValue): int|string|null
+    private static function matchSmallestValue(array $lookupArray, mixed $lookupValue): int | string | null
     {
         $valueKey = null;
         if (is_string($lookupValue)) {

src/PhpSpreadsheet/Calculation/LookupRef/Offset.php

Spacing +1 added lines, -1 removed lines

@@ -42,7 +42,7 @@
      *
      * @return array<mixed>|string An array containing a cell or range of cells, or a string on error
      */
-    public static function OFFSET(?string $cellAddress = null, $rows = 0, $columns = 0, $height = null, $width = null, ?Cell $cell = null): string|array
+    public static function OFFSET(?string $cellAddress = null, $rows = 0, $columns = 0, $height = null, $width = null, ?Cell $cell = null): string | array
     {
         /** @var int */
         $rows = Functions::flattenSingleValue($rows);

src/PhpSpreadsheet/Calculation/LookupRef/Indirect.php

Spacing +2 added lines, -2 removed lines

@@ -37,7 +37,7 @@ 
      *
      * @param null|mixed[]|string $cellAddress
      */
-    private static function validateAddress(array|string|null $cellAddress): string
+    private static function validateAddress(array | string | null $cellAddress): string
     {
         $cellAddress = Functions::flattenSingleValue($cellAddress);
         if (!is_string($cellAddress) || !$cellAddress) {
@@ -63,7 +63,7 @@ 
      *
      * @return mixed[]|string An array containing a cell or range of cells, or a string on error
      */
-    public static function INDIRECT($cellAddress, mixed $a1fmt, Cell $cell): string|array
+    public static function INDIRECT($cellAddress, mixed $a1fmt, Cell $cell): string | array
     {
         [$baseCol, $baseRow] = Coordinate::indexesFromString($cell->getCoordinate());
 

src/PhpSpreadsheet/Calculation/LookupRef/Address.php

Spacing +1 added lines, -1 removed lines

@@ -48,7 +48,7 @@
      * @return mixed[]|string If an array of values is passed as the $testValue argument, then the returned result will also be
      *            an array with the same dimensions
      */
-    public static function cell(mixed $row, mixed $column, mixed $relativity = 1, mixed $referenceStyle = true, mixed $sheetName = ''): array|string
+    public static function cell(mixed $row, mixed $column, mixed $relativity = 1, mixed $referenceStyle = true, mixed $sheetName = ''): array | string
     {
         if (
             is_array($row) || is_array($column)

src/PhpSpreadsheet/Calculation/Engine/FormattedNumber.php

Spacing +5 added lines, -5 removed lines

@@ -22,7 +22,7 @@ 
      *
      * @param float|string $operand string value to test
      */
-    public static function convertToNumberIfFormatted(float|string &$operand): bool
+    public static function convertToNumberIfFormatted(float | string &$operand): bool
     {
         return self::convertToNumberIfNumeric($operand)
             || self::convertToNumberIfFraction($operand)
@@ -36,7 +36,7 @@ 
      *
      * @param float|string $operand string value to test
      */
-    public static function convertToNumberIfNumeric(float|string &$operand): bool
+    public static function convertToNumberIfNumeric(float | string &$operand): bool
     {
         $thousandsSeparator = preg_quote(StringHelper::getThousandsSeparator(), '/');
         $value = preg_replace(['/(\d)' . $thousandsSeparator . '(\d)/u', '/([+-])\s+(\d)/u'], ['$1$2', '$1$2'], trim("$operand"));
@@ -58,7 +58,7 @@ 
      *
      * @param string $operand string value to test
      */
-    public static function convertToNumberIfFraction(float|string &$operand): bool
+    public static function convertToNumberIfFraction(float | string &$operand): bool
     {
         if (is_string($operand) && preg_match(self::STRING_REGEXP_FRACTION, $operand, $match)) {
             $sign = ($match[1] === '-') ? '-' : '+';
@@ -80,7 +80,7 @@ 
      *
      * @param float|string $operand string value to test
      */
-    public static function convertToNumberIfPercent(float|string &$operand): bool
+    public static function convertToNumberIfPercent(float | string &$operand): bool
     {
         $thousandsSeparator = preg_quote(StringHelper::getThousandsSeparator(), '/');
         $value = preg_replace('/(\d)' . $thousandsSeparator . '(\d)/u', '$1$2', trim("$operand"));
@@ -105,7 +105,7 @@ 
      *
      * @param float|string $operand string value to test
      */
-    public static function convertToNumberIfCurrency(float|string &$operand): bool
+    public static function convertToNumberIfCurrency(float | string &$operand): bool
     {
         $currencyRegexp = self::currencyMatcherRegexp();
         $thousandsSeparator = preg_quote(StringHelper::getThousandsSeparator(), '/');

src/PhpSpreadsheet/Calculation/Logical/Operations.php

Spacing +2 added lines, -2 removed lines

@@ -110,7 +110,7 @@ 
      *         If an array of values is passed as an argument, then the returned result will also be an array
      *            with the same dimensions
      */
-    public static function NOT(mixed $logical = false): array|bool|string
+    public static function NOT(mixed $logical = false): array | bool | string
     {
         if (is_array($logical)) {
             return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $logical);
@@ -134,7 +134,7 @@ 
      * @param mixed[] $args
      * @param callable(int, int): bool $func
      */
-    private static function countTrueValues(array $args, callable $func): bool|string
+    private static function countTrueValues(array $args, callable $func): bool | string
     {
         $trueValueCount = 0;
         $count = 0;

src/PhpSpreadsheet/Writer/Xlsx/Worksheet.php

Spacing +3 added lines, -3 removed lines

@@ -1431,7 +1431,7 @@ 
         $objWriter->endElement();
     }
 
-    private function writeCellInlineStr(XMLWriter $objWriter, string $mappedType, RichText|string $cellValue): void
+    private function writeCellInlineStr(XMLWriter $objWriter, string $mappedType, RichText | string $cellValue): void
     {
         $objWriter->writeAttribute('t', $mappedType);
         if (!$cellValue instanceof RichText) {
@@ -1451,7 +1451,7 @@ 
     /**
      * @param string[] $flippedStringTable
      */
-    private function writeCellString(XMLWriter $objWriter, string $mappedType, RichText|string $cellValue, array $flippedStringTable): void
+    private function writeCellString(XMLWriter $objWriter, string $mappedType, RichText | string $cellValue, array $flippedStringTable): void
     {
         $objWriter->writeAttribute('t', $mappedType);
         if (!$cellValue instanceof RichText) {
@@ -1461,7 +1461,7 @@ 
         }
     }
 
-    private function writeCellNumeric(XMLWriter $objWriter, float|int $cellValue): void
+    private function writeCellNumeric(XMLWriter $objWriter, float | int $cellValue): void
     {
         $result = StringHelper::convertToString($cellValue);
         if (is_float($cellValue) && !str_contains($result, '.')) {

tests/PhpSpreadsheetTests/Reader/Xlsx/HyperlinkTest.php

Indentation +7 added lines, -7 removed lines

@@ -55,13 +55,13 @@
         $rsheet2 = $reloadedSpreadsheet->getSheet(1);
         self::assertSame('link to other sheet', $rsheet2->getCell('A2')->getValue());
         self::assertSame("sheet://'Sheet One'!A1", $rsheet2->getCell('A2')->getHyperlink()->getUrl());
-         self::assertSame(
-             'FF0000FF',
-             $rsheet2
-                 ->getStyle('A2')
-                 ->getFont()->getColor()->getARGB(),
-             'argb is set in addition to theme'
-         );
+            self::assertSame(
+                'FF0000FF',
+                $rsheet2
+                    ->getStyle('A2')
+                    ->getFont()->getColor()->getARGB(),
+                'argb is set in addition to theme'
+            );
 
         self::assertSame('external link', $rsheet2->getCell('A3')->getValue());
         self::assertSame('https://www.example.com', $rsheet2->getCell('A3')->getHyperlink()->getUrl());