PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Calculation/Statistical.php

Spacing +4 added lines, -4 removed lines

@@ -874,7 +874,7 @@ 
             if (!is_numeric($arg)) {
                 $arg = \PhpOffice\PhpSpreadsheet\Calculation::wrapResult(strtoupper($arg));
             }
-            $testCondition = '='.$arg.$condition;
+            $testCondition = '=' . $arg . $condition;
             if (\PhpOffice\PhpSpreadsheet\Calculation::getInstance()->_calculateFormulaValue($testCondition)) {
                 if ((is_null($returnValue)) || ($arg > $returnValue)) {
                     $returnValue += $arg;
@@ -1304,7 +1304,7 @@ 
             if (!is_numeric($arg)) {
                 $arg = \PhpOffice\PhpSpreadsheet\Calculation::wrapResult(strtoupper($arg));
             }
-            $testCondition = '='.$arg.$condition;
+            $testCondition = '=' . $arg . $condition;
             if (\PhpOffice\PhpSpreadsheet\Calculation::getInstance()->_calculateFormulaValue($testCondition)) {
                 // Is it a value within our criteria
                 ++$returnValue;
@@ -2314,7 +2314,7 @@ 
             if (!is_numeric($arg)) {
                 $arg = \PhpOffice\PhpSpreadsheet\Calculation::wrapResult(strtoupper($arg));
             }
-            $testCondition = '='.$arg.$condition;
+            $testCondition = '=' . $arg . $condition;
             if (\PhpOffice\PhpSpreadsheet\Calculation::getInstance()->_calculateFormulaValue($testCondition)) {
                 if ((is_null($returnValue)) || ($arg > $returnValue)) {
                     $returnValue = $arg;
@@ -2476,7 +2476,7 @@ 
             if (!is_numeric($arg)) {
                 $arg = \PhpOffice\PhpSpreadsheet\Calculation::wrapResult(strtoupper($arg));
             }
-            $testCondition = '='.$arg.$condition;
+            $testCondition = '=' . $arg . $condition;
             if (\PhpOffice\PhpSpreadsheet\Calculation::getInstance()->_calculateFormulaValue($testCondition)) {
                 if ((is_null($returnValue)) || ($arg < $returnValue)) {
                     $returnValue = $arg;

src/PhpSpreadsheet/Calculation/DateTime.php

Spacing +12 added lines, -12 removed lines

@@ -130,10 +130,10 @@ 
 
         $adjustmentMonthsString = (string) $adjustmentMonths;
         if ($adjustmentMonths > 0) {
-            $adjustmentMonthsString = '+'.$adjustmentMonths;
+            $adjustmentMonthsString = '+' . $adjustmentMonths;
         }
         if ($adjustmentMonths != 0) {
-            $PHPDateObject->modify($adjustmentMonthsString.' months');
+            $PHPDateObject->modify($adjustmentMonthsString . ' months');
         }
         $nMonth = (int) $PHPDateObject->format('m');
         $nYear = (int) $PHPDateObject->format('Y');
@@ -141,7 +141,7 @@ 
         $monthDiff = ($nMonth - $oMonth) + (($nYear - $oYear) * 12);
         if ($monthDiff != $adjustmentMonths) {
             $adjustDays = (int) $PHPDateObject->format('d');
-            $adjustDaysString = '-'.$adjustDays.' days';
+            $adjustDaysString = '-' . $adjustDays . ' days';
             $PHPDateObject->modify($adjustDaysString);
         }
 
@@ -449,9 +449,9 @@ 
                     $dayAdjust = floor($hour / 24);
                     $hour = $hour % 24;
                 }
-                $phpDateObject = new \DateTime('1900-01-01 '.$hour.':'.$minute.':'.$second);
+                $phpDateObject = new \DateTime('1900-01-01 ' . $hour . ':' . $minute . ':' . $second);
                 if ($dayAdjust != 0) {
-                    $phpDateObject->modify($dayAdjust.' days');
+                    $phpDateObject->modify($dayAdjust . ' days');
                 }
 
                 return $phpDateObject;
@@ -546,9 +546,9 @@ 
             if ($testVal1 < 31 && $testVal2 < 12 && $testVal3 < 12 && strlen($testVal3) == 2) {
                 $testVal3 += 2000;
             }
-            $PHPDateArray = date_parse($testVal1.'-'.$testVal2.'-'.$testVal3);
+            $PHPDateArray = date_parse($testVal1 . '-' . $testVal2 . '-' . $testVal3);
             if (($PHPDateArray === false) || ($PHPDateArray['error_count'] > 0)) {
-                $PHPDateArray = date_parse($testVal2.'-'.$testVal1.'-'.$testVal3);
+                $PHPDateArray = date_parse($testVal2 . '-' . $testVal1 . '-' . $testVal3);
                 if (($PHPDateArray === false) || ($PHPDateArray['error_count'] > 0)) {
                     return Functions::VALUE();
                 }
@@ -588,7 +588,7 @@ 
                 case Functions::RETURNDATE_PHP_NUMERIC:
                     return (int) \PhpOffice\PhpSpreadsheet\Shared\Date::excelToTimestamp($excelDateValue);
                 case Functions::RETURNDATE_PHP_OBJECT:
-                    return new \DateTime($PHPDateArray['year'].'-'.$PHPDateArray['month'].'-'.$PHPDateArray['day'].' 00:00:00');
+                    return new \DateTime($PHPDateArray['year'] . '-' . $PHPDateArray['month'] . '-' . $PHPDateArray['day'] . ' 00:00:00');
             }
         }
 
@@ -650,7 +650,7 @@ 
                 case Functions::RETURNDATE_PHP_NUMERIC:
                     return (int) $phpDateValue = \PhpOffice\PhpSpreadsheet\Shared\Date::excelToTimestamp($excelDateValue + 25569) - 3600;
                 case Functions::RETURNDATE_PHP_OBJECT:
-                    return new \DateTime('1900-01-01 '.$PHPDateArray['hour'].':'.$PHPDateArray['minute'].':'.$PHPDateArray['second']);
+                    return new \DateTime('1900-01-01 ' . $PHPDateArray['hour'] . ':' . $PHPDateArray['minute'] . ':' . $PHPDateArray['second']);
             }
         }
 
@@ -726,7 +726,7 @@ 
             case 'MD':
                 if ($endDays < $startDays) {
                     $retVal = $endDays;
-                    $PHPEndDateObject->modify('-'.$endDays.' days');
+                    $PHPEndDateObject->modify('-' . $endDays . ' days');
                     $adjustDays = $PHPEndDateObject->format('j');
                     $retVal += ($adjustDays - $startDays);
                 } else {
@@ -1280,7 +1280,7 @@ 
         // Execute function
         $PHPDateObject = \PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($dateValue);
         $dayOfYear = $PHPDateObject->format('z');
-        $PHPDateObject->modify('-'.$dayOfYear.' days');
+        $PHPDateObject->modify('-' . $dayOfYear . ' days');
         $firstDayOfFirstWeek = $PHPDateObject->format('w');
         $daysInFirstWeek = (6 - $firstDayOfFirstWeek + $method) % 7;
         $interval = $dayOfYear - $daysInFirstWeek;
@@ -1564,7 +1564,7 @@ 
         // Execute function
         $PHPDateObject = self::adjustDateByMonths($dateValue, $adjustmentMonths + 1);
         $adjustDays = (int) $PHPDateObject->format('d');
-        $adjustDaysString = '-'.$adjustDays.' days';
+        $adjustDaysString = '-' . $adjustDays . ' days';
         $PHPDateObject->modify($adjustDaysString);
 
         switch (Functions::getReturnDateType()) {

src/PhpSpreadsheet/Calculation/MathTrig.php

Spacing +3 added lines, -3 removed lines

@@ -975,7 +975,7 @@ 
         $t = self::romanCut($aValue, 10);
         $aValue %= 10;
 
-        return $roman.$mill[$m].$cent[$c].$tens[$t].$ones[$aValue];
+        return $roman . $mill[$m] . $cent[$c] . $tens[$t] . $ones[$aValue];
     }
 
     /**
@@ -1234,7 +1234,7 @@ 
                 $arg = \PhpOffice\PhpSpreadsheet\Calculation::wrapResult(strtoupper($arg));
             }
 
-            $testCondition = '='.$arg.$condition;
+            $testCondition = '=' . $arg . $condition;
             if (\PhpOffice\PhpSpreadsheet\Calculation::getInstance()->_calculateFormulaValue($testCondition)) {
                 // Is it a value within our criteria
                 $returnValue += $sumArgs[$key];
@@ -1282,7 +1282,7 @@ 
                 if (!is_numeric($arg)) {
                     $arg = \PhpOffice\PhpSpreadsheet\Calculation::wrapResult(strtoupper($arg));
                 }
-                $testCondition = '='.$arg.$condition;
+                $testCondition = '=' . $arg . $condition;
                 if (\PhpOffice\PhpSpreadsheet\Calculation::getInstance()->_calculateFormulaValue($testCondition)) {
                     // Is it a value within our criteria
                     $returnValue += $sumArgs[$key];

src/PhpSpreadsheet/Style/Fill.php

Spacing +4 added lines, -4 removed lines

@@ -330,10 +330,10 @@
         }
 
         return md5(
-            $this->getFillType().
-            $this->getRotation().
-            $this->getStartColor()->getHashCode().
-            $this->getEndColor()->getHashCode().
+            $this->getFillType() .
+            $this->getRotation() .
+            $this->getStartColor()->getHashCode() .
+            $this->getEndColor()->getHashCode() .
             __CLASS__
         );
     }

src/PhpSpreadsheet/Style/NumberFormat.php

Spacing +14 added lines, -14 removed lines

@@ -390,8 +390,8 @@ 
         }
 
         return md5(
-            $this->formatCode.
-            $this->builtInFormatCode.
+            $this->formatCode .
+            $this->builtInFormatCode .
             __CLASS__
         );
     }
@@ -465,7 +465,7 @@ 
 
     private static function escapeQuotesCallback($matches)
     {
-        return '\\'.implode('\\', str_split($matches[1]));
+        return '\\' . implode('\\', str_split($matches[1]));
     }
 
     private static function formatAsDate(&$value, &$format)
@@ -506,16 +506,16 @@ 
     private static function formatAsPercentage(&$value, &$format)
     {
         if ($format === self::FORMAT_PERCENTAGE) {
-            $value = round((100 * $value), 0).'%';
+            $value = round((100 * $value), 0) . '%';
         } else {
             if (preg_match('/\.[#0]+/i', $format, $m)) {
-                $s = substr($m[0], 0, 1).(strlen($m[0]) - 1);
+                $s = substr($m[0], 0, 1) . (strlen($m[0]) - 1);
                 $format = str_replace($m[0], $s, $format);
             }
             if (preg_match('/^[#0]+/', $format, $m)) {
                 $format = str_replace($m[0], strlen($m[0]), $format);
             }
-            $format = '%'.str_replace('%', 'f%%', $format);
+            $format = '%' . str_replace('%', 'f%%', $format);
 
             $value = sprintf($format, 100 * $value);
         }
@@ -551,12 +551,12 @@ 
         $sign = ($number < 0.0);
         $number = abs($number);
         if (strpos($mask, '.') !== false) {
-            $numbers = explode('.', $number.'.0');
-            $masks = explode('.', $mask.'.0');
+            $numbers = explode('.', $number . '.0');
+            $masks = explode('.', $mask . '.0');
             $result1 = self::complexNumberFormatMask($numbers[0], $masks[0], 1);
             $result2 = strrev(self::complexNumberFormatMask(strrev($numbers[1]), strrev($masks[1]), 1));
 
-            return (($sign) ? '-' : '').$result1.'.'.$result2;
+            return (($sign) ? '-' : '') . $result1 . '.' . $result2;
         }
 
         $r = preg_match_all('/0+/', $mask, $result, PREG_OFFSET_CAPTURE);
@@ -564,12 +564,12 @@ 
             $result = array_reverse($result[0]);
 
             foreach ($result as $block) {
-                $divisor = 1 .$block[0];
+                $divisor = 1 . $block[0];
                 $size = strlen($block[0]);
                 $offset = $block[1];
 
                 $blockValue = sprintf(
-                    '%0'.$size.'d',
+                    '%0' . $size . 'd',
                     fmod($number, $divisor)
                 );
                 $number = floor($number / $divisor);
@@ -583,7 +583,7 @@ 
             $result = $number;
         }
 
-        return (($sign) ? '-' : '').$result;
+        return (($sign) ? '-' : '') . $result;
     }
 
     /**
@@ -669,7 +669,7 @@ 
             self::formatAsPercentage($value, $format);
         } else {
             if ($format === self::FORMAT_CURRENCY_EUR_SIMPLE) {
-                $value = 'EUR '.sprintf('%1.2f', $value);
+                $value = 'EUR ' . sprintf('%1.2f', $value);
             } else {
                 // Some non-number strings are quoted, so we'll get rid of the quotes, likewise any positional * symbols
                 $format = str_replace(['"', '*'], '', $format);
@@ -734,7 +734,7 @@ 
                             } elseif (preg_match('/0([^\d\.]+)0/', $format)) {
                                 $value = self::complexNumberFormatMask($value, $format);
                             } else {
-                                $sprintf_pattern = "%0$minWidth.".strlen($right).'f';
+                                $sprintf_pattern = "%0$minWidth." . strlen($right) . 'f';
                                 $value = sprintf($sprintf_pattern, $value);
                                 $value = preg_replace($number_regex, $value, $format);
                             }

src/PhpSpreadsheet/Style/Conditional.php

Spacing +4 added lines, -4 removed lines

@@ -277,10 +277,10 @@
     public function getHashCode()
     {
         return md5(
-            $this->conditionType.
-            $this->operatorType.
-            implode(';', $this->condition).
-            $this->style->getHashCode().
+            $this->conditionType .
+            $this->operatorType .
+            implode(';', $this->condition) .
+            $this->style->getHashCode() .
             __CLASS__
         );
     }

src/PhpSpreadsheet/Style/Protection.php

Spacing +2 added lines, -2 removed lines

@@ -208,8 +208,8 @@
         }
 
         return md5(
-            $this->locked.
-            $this->hidden.
+            $this->locked .
+            $this->hidden .
             __CLASS__
         );
     }

src/PhpSpreadsheet/Style/Color.php

Spacing +6 added lines, -6 removed lines

@@ -237,10 +237,10 @@ 
             $pValue = '000000';
         }
         if ($this->isSupervisor) {
-            $styleArray = $this->getStyleArray(['argb' => 'FF'.$pValue]);
+            $styleArray = $this->getStyleArray(['argb' => 'FF' . $pValue]);
             $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray);
         } else {
-            $this->argb = 'FF'.$pValue;
+            $this->argb = 'FF' . $pValue;
         }
 
         return $this;
@@ -352,12 +352,12 @@ 
         }
 
         $rgb = strtoupper(
-            str_pad(dechex($red), 2, '0', 0).
-            str_pad(dechex($green), 2, '0', 0).
+            str_pad(dechex($red), 2, '0', 0) .
+            str_pad(dechex($green), 2, '0', 0) .
             str_pad(dechex($blue), 2, '0', 0)
         );
 
-        return (($rgba) ? 'FF' : '').$rgb;
+        return (($rgba) ? 'FF' : '') . $rgb;
     }
 
     /**
@@ -459,7 +459,7 @@ 
         }
 
         return md5(
-            $this->argb.
+            $this->argb .
             __CLASS__
         );
     }

src/PhpSpreadsheet/Style/Borders.php

Spacing +6 added lines, -6 removed lines

@@ -436,12 +436,12 @@
         }
 
         return md5(
-            $this->getLeft()->getHashCode().
-            $this->getRight()->getHashCode().
-            $this->getTop()->getHashCode().
-            $this->getBottom()->getHashCode().
-            $this->getDiagonal()->getHashCode().
-            $this->getDiagonalDirection().
+            $this->getLeft()->getHashCode() .
+            $this->getRight()->getHashCode() .
+            $this->getTop()->getHashCode() .
+            $this->getBottom()->getHashCode() .
+            $this->getDiagonal()->getHashCode() .
+            $this->getDiagonalDirection() .
             __CLASS__
         );
     }