PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Calculation/LookupRef.php

Spacing +9 added lines, -9 removed lines

@@ -536,33 +536,33 @@
                         $splitString = $lookupValue;
                         $chars = array_map(function ($i) use ($splitString) {
                             return mb_substr($splitString, $i, 1);
-                        }, range(0, mb_strlen($splitString) -1));
+                        }, range(0, mb_strlen($splitString) - 1));
 
                         $length = count($chars);
                         $pattern = '/^';
                         for ($j = 0; $j < $length; $j++) {
                             if ($chars[$j] === '~') {
-                                if (isset($chars[$j+1])) {
-                                    if ($chars[$j+1] === '*') {
-                                        $pattern .= preg_quote($chars[$j+1], '/');
+                                if (isset($chars[$j + 1])) {
+                                    if ($chars[$j + 1] === '*') {
+                                        $pattern .= preg_quote($chars[$j + 1], '/');
                                         $j++;
-                                    } elseif ($chars[$j+1] === '?') {
-                                        $pattern .= preg_quote($chars[$j+1], '/');
+                                    } elseif ($chars[$j + 1] === '?') {
+                                        $pattern .= preg_quote($chars[$j + 1], '/');
                                         $j++;
                                     }
                                 } else {
                                     $pattern .= preg_quote($chars[$j], '/');
                                 }
                             } elseif ($chars[$j] === '*') {
-                                $pattern .='.*';
+                                $pattern .= '.*';
                             } elseif ($chars[$j] === '?') {
-                                $pattern .='.{1}';
+                                $pattern .= '.{1}';
                             } else {
                                 $pattern .= preg_quote($chars[$j], '/');
                             }
                         }
 
-                        $pattern .='$/';
+                        $pattern .= '$/';
                         if ((bool) preg_match($pattern, $lookupArrayValue)) {
                             // exact match
                             return $i + 1;

tests/data/Calculation/LookupRef/MATCH.php

Spacing +11 added lines, -11 removed lines

@@ -107,7 +107,7 @@ 
     [
         2,
         'a',
-        [false, 'a',1],
+        [false, 'a', 1],
         -1
     ],
     [
@@ -125,37 +125,37 @@ 
     [
         '#N/A', // Expected
         true,
-        [0,1,2],
+        [0, 1, 2],
         -1
     ],
     [
         '#N/A', // Expected
         true,
-        [0,1,2],
+        [0, 1, 2],
         0
     ],
     [
         '#N/A', // Expected
         true,
-        [0,1,2],
+        [0, 1, 2],
         1
     ],
     [
         1, // Expected
         true,
-        [true,true,true],
+        [true, true, true],
         -1
     ],
     [
         1, // Expected
         true,
-        [true,true,true],
+        [true, true, true],
         0
     ],
     [
         3, // Expected
         true,
-        [true,true,true],
+        [true, true, true],
         1
     ],
     // lookup stops when value < searched one
@@ -169,7 +169,7 @@ 
     [
         '#N/A', // Expected
         6,
-        [true, false, 'a', 'z', 2, 888 ],
+        [true, false, 'a', 'z', 2, 888],
         -1
     ],
     [
@@ -230,19 +230,19 @@ 
     [
         '#N/A', // Expected
         '?',
-        [1, 22,333],
+        [1, 22, 333],
         0
     ],
     [
         3, // Expected
         '???',
-        [1, 22,'aaa'],
+        [1, 22, 'aaa'],
         0
     ],
     [
         3, // Expected
         '*',
-        [1, 22,'aaa'],
+        [1, 22, 'aaa'],
         0
     ],
 ];