PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Cell.php

Spacing +10 added lines, -10 removed lines

@@ -291,7 +291,7 @@ 
 //echo 'Calculation Exception: '.$ex->getMessage().PHP_EOL;
                 $result = '#N/A';
                 throw new Calculation\Exception(
-                    $this->getWorksheet()->getTitle().'!'.$this->getCoordinate().' -> '.$ex->getMessage()
+                    $this->getWorksheet()->getTitle() . '!' . $this->getCoordinate() . ' -> ' . $ex->getMessage()
                 );
             }
 
@@ -586,14 +586,14 @@ 
     public static function coordinateFromString($pCoordinateString = 'A1')
     {
         if (preg_match("/^([$]?[A-Z]{1,3})([$]?\d{1,7})$/", $pCoordinateString, $matches)) {
-            return array($matches[1],$matches[2]);
+            return array($matches[1], $matches[2]);
         } elseif ((strpos($pCoordinateString, ':') !== false) || (strpos($pCoordinateString, ',') !== false)) {
             throw new Exception('Cell coordinate string can not be a range of cells');
         } elseif ($pCoordinateString == '') {
             throw new Exception('Cell coordinate can not be zero-length string');
         }
 
-        throw new Exception('Invalid cell coordinate '.$pCoordinateString);
+        throw new Exception('Invalid cell coordinate ' . $pCoordinateString);
     }
 
     /**
@@ -733,11 +733,11 @@ 
 
         // Calculate range outer borders
         $rangeStart = self::coordinateFromString($rangeA);
-        $rangeEnd    = self::coordinateFromString($rangeB);
+        $rangeEnd = self::coordinateFromString($rangeB);
 
         // Translate column into index
-        $rangeStart[0]    = self::columnIndexFromString($rangeStart[0]);
-        $rangeEnd[0]    = self::columnIndexFromString($rangeEnd[0]);
+        $rangeStart[0] = self::columnIndexFromString($rangeStart[0]);
+        $rangeEnd[0] = self::columnIndexFromString($rangeEnd[0]);
 
         return array($rangeStart, $rangeEnd);
     }
@@ -753,7 +753,7 @@ 
         // Calculate range outer borders
         list($rangeStart, $rangeEnd) = self::rangeBoundaries($pRange);
 
-        return array( ($rangeEnd[0] - $rangeStart[0] + 1), ($rangeEnd[1] - $rangeStart[1] + 1) );
+        return array(($rangeEnd[0] - $rangeStart[0] + 1), ($rangeEnd[1] - $rangeStart[1] + 1));
     }
 
     /**
@@ -780,7 +780,7 @@ 
             list($rangeA, $rangeB) = explode(':', $pRange);
         }
 
-        return array( self::coordinateFromString($rangeA), self::coordinateFromString($rangeB));
+        return array(self::coordinateFromString($rangeA), self::coordinateFromString($rangeB));
     }
 
     /**
@@ -885,7 +885,7 @@ 
                 }
 
                 // Range...
-                list($rangeStart, $rangeEnd)    = $range;
+                list($rangeStart, $rangeEnd) = $range;
                 sscanf($rangeStart, '%[A-Z]%d', $startCol, $startRow);
                 sscanf($rangeEnd, '%[A-Z]%d', $endCol, $endRow);
                 ++$endCol;
@@ -897,7 +897,7 @@ 
                 // Loop cells
                 while ($currentCol != $endCol) {
                     while ($currentRow <= $endRow) {
-                        $returnValue[] = $currentCol.$currentRow;
+                        $returnValue[] = $currentCol . $currentRow;
                         ++$currentRow;
                     }
                     ++$currentCol;

src/PhpSpreadsheet/Chart/DataSeries.php

Spacing +2 added lines, -2 removed lines

@@ -38,14 +38,14 @@
     const TYPE_PIECHART        = 'pieChart';
     const TYPE_PIECHART_3D     = 'pie3DChart';
     const TYPE_DOUGHTNUTCHART  = 'doughnutChart';
-    const TYPE_DONUTCHART      = self::TYPE_DOUGHTNUTCHART;    //    Synonym
+    const TYPE_DONUTCHART      = self::TYPE_DOUGHTNUTCHART; //    Synonym
     const TYPE_SCATTERCHART    = 'scatterChart';
     const TYPE_SURFACECHART    = 'surfaceChart';
     const TYPE_SURFACECHART_3D = 'surface3DChart';
     const TYPE_RADARCHART      = 'radarChart';
     const TYPE_BUBBLECHART     = 'bubbleChart';
     const TYPE_STOCKCHART      = 'stockChart';
-    const TYPE_CANDLECHART     = self::TYPE_STOCKCHART;       //    Synonym
+    const TYPE_CANDLECHART     = self::TYPE_STOCKCHART; //    Synonym
 
     const GROUPING_CLUSTERED       = 'clustered';
     const GROUPING_STACKED         = 'stacked';

src/PhpSpreadsheet/Chart/Legend.php

Spacing +6 added lines, -6 removed lines

@@ -30,12 +30,12 @@
 class Legend
 {
     /** Legend positions */
-    const XL_LEGEND_POSITION_BOTTOM = -4107;    //    Below the chart.
-    const XL_LEGEND_POSITION_CORNER = 2;        //    In the upper right-hand corner of the chart border.
-    const XL_LEGEND_POSITION_CUSTOM = -4161;    //    A custom position.
-    const XL_LEGEND_POSITION_LEFT   = -4131;    //    Left of the chart.
-    const XL_LEGEND_POSITION_RIGHT  = -4152;    //    Right of the chart.
-    const XL_LEGEND_POSITION_TOP    = -4160;    //    Above the chart.
+    const XL_LEGEND_POSITION_BOTTOM = -4107; //    Below the chart.
+    const XL_LEGEND_POSITION_CORNER = 2; //    In the upper right-hand corner of the chart border.
+    const XL_LEGEND_POSITION_CUSTOM = -4161; //    A custom position.
+    const XL_LEGEND_POSITION_LEFT   = -4131; //    Left of the chart.
+    const XL_LEGEND_POSITION_RIGHT  = -4152; //    Right of the chart.
+    const XL_LEGEND_POSITION_TOP    = -4160; //    Above the chart.
 
     const POSITION_RIGHT    = 'r';
     const POSITION_LEFT     = 'l';

src/PhpSpreadsheet/Chart/DataSeriesValues.php

Spacing +1 added lines, -1 removed lines

@@ -293,7 +293,7 @@
             $calcEngine = \PHPExcel\Calculation::getInstance($worksheet->getParent());
             $newDataValues = \PHPExcel\Calculation::unwrapResult(
                 $calcEngine->_calculateFormulaValue(
-                    '='.$this->dataSource,
+                    '=' . $this->dataSource,
                     null,
                     $worksheet->getCell('A1')
                 )

src/PhpSpreadsheet/Style.php

Spacing +1 added lines, -1 removed lines

@@ -618,7 +618,7 @@
             $this->numberFormat->getHashCode() .
             $hashConditionals .
             $this->protection->getHashCode() .
-            ($this->quotePrefix  ? 't' : 'f') .
+            ($this->quotePrefix ? 't' : 'f') .
             __CLASS__
         );
     }

src/PhpSpreadsheet/Spreadsheet.php

Spacing +4 added lines, -4 removed lines

@@ -289,16 +289,16 @@ 
             case 'names':
             case 'data':
                 if (is_array($this->ribbonBinObjects) && array_key_exists($What, $this->ribbonBinObjects)) {
-                    $ReturnData=$this->ribbonBinObjects[$What];
+                    $ReturnData = $this->ribbonBinObjects[$What];
                 }
                 break;
             case 'types':
                 if (is_array($this->ribbonBinObjects) &&
                     array_key_exists('data', $this->ribbonBinObjects) && is_array($this->ribbonBinObjects['data'])) {
-                    $tmpTypes=array_keys($this->ribbonBinObjects['data']);
+                    $tmpTypes = array_keys($this->ribbonBinObjects['data']);
                     $ReturnData = array_unique(array_map(array($this, 'getExtensionOnly'), $tmpTypes));
                 } else {
-                    $ReturnData=array(); // the caller want an array... not null if empty
+                    $ReturnData = array(); // the caller want an array... not null if empty
                 }
                 break;
         }
@@ -787,7 +787,7 @@ 
             $this->namedRanges[$namedRange->getName()] = $namedRange;
         } else {
             // local scope
-            $this->namedRanges[$namedRange->getScope()->getTitle().'!'.$namedRange->getName()] = $namedRange;
+            $this->namedRanges[$namedRange->getScope()->getTitle() . '!' . $namedRange->getName()] = $namedRange;
         }
         return true;
     }

src/PhpSpreadsheet/Style/NumberFormat.php

Spacing +13 added lines, -13 removed lines

@@ -95,7 +95,7 @@ 
      *
      * @var string
      */
-    protected $builtInFormatCode    = 0;
+    protected $builtInFormatCode = 0;
 
     /**
      * Create a new NumberFormat
@@ -283,7 +283,7 @@ 
             self::$builtInFormats[11] = '0.00E+00';
             self::$builtInFormats[12] = '# ?/?';
             self::$builtInFormats[13] = '# ??/??';
-            self::$builtInFormats[14] = 'm/d/yyyy';                     // Despite ECMA 'mm-dd-yy';
+            self::$builtInFormats[14] = 'm/d/yyyy'; // Despite ECMA 'mm-dd-yy';
             self::$builtInFormats[15] = 'd-mmm-yy';
             self::$builtInFormats[16] = 'd-mmm';
             self::$builtInFormats[17] = 'mmm-yy';
@@ -291,17 +291,17 @@ 
             self::$builtInFormats[19] = 'h:mm:ss AM/PM';
             self::$builtInFormats[20] = 'h:mm';
             self::$builtInFormats[21] = 'h:mm:ss';
-            self::$builtInFormats[22] = 'm/d/yyyy h:mm';                // Despite ECMA 'm/d/yy h:mm';
+            self::$builtInFormats[22] = 'm/d/yyyy h:mm'; // Despite ECMA 'm/d/yy h:mm';
 
-            self::$builtInFormats[37] = '#,##0_);(#,##0)';              //  Despite ECMA '#,##0 ;(#,##0)';
-            self::$builtInFormats[38] = '#,##0_);[Red](#,##0)';         //  Despite ECMA '#,##0 ;[Red](#,##0)';
-            self::$builtInFormats[39] = '#,##0.00_);(#,##0.00)';        //  Despite ECMA '#,##0.00;(#,##0.00)';
-            self::$builtInFormats[40] = '#,##0.00_);[Red](#,##0.00)';   //  Despite ECMA '#,##0.00;[Red](#,##0.00)';
+            self::$builtInFormats[37] = '#,##0_);(#,##0)'; //  Despite ECMA '#,##0 ;(#,##0)';
+            self::$builtInFormats[38] = '#,##0_);[Red](#,##0)'; //  Despite ECMA '#,##0 ;[Red](#,##0)';
+            self::$builtInFormats[39] = '#,##0.00_);(#,##0.00)'; //  Despite ECMA '#,##0.00;(#,##0.00)';
+            self::$builtInFormats[40] = '#,##0.00_);[Red](#,##0.00)'; //  Despite ECMA '#,##0.00;[Red](#,##0.00)';
 
             self::$builtInFormats[44] = '_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)';
             self::$builtInFormats[45] = 'mm:ss';
             self::$builtInFormats[46] = '[h]:mm:ss';
-            self::$builtInFormats[47] = 'mm:ss.0';                      //  Despite ECMA 'mmss.0';
+            self::$builtInFormats[47] = 'mm:ss.0'; //  Despite ECMA 'mmss.0';
             self::$builtInFormats[48] = '##0.0E+0';
             self::$builtInFormats[49] = '@';
 
@@ -520,8 +520,8 @@ 
 
         $GCD = \PHPExcel\Calculation\MathTrig::GCD($decimalPart, $decimalDivisor);
 
-        $adjustedDecimalPart = $decimalPart/$GCD;
-        $adjustedDecimalDivisor = $decimalDivisor/$GCD;
+        $adjustedDecimalPart = $decimalPart / $GCD;
+        $adjustedDecimalDivisor = $decimalDivisor / $GCD;
 
         if ((strpos($format, '0') !== false) || (strpos($format, '#') !== false) || (substr($format, 0, 3) == '? ?')) {
             if ($integerPart == 0) {
@@ -617,13 +617,13 @@ 
                 break;
             case 3:
                 $format = ($value > 0) ?
-                    $sections[0] : ( ($value < 0) ?
+                    $sections[0] : (($value < 0) ?
                         $sections[1] : $sections[2]);
                 $value = abs($value); // Use the absolute value
                 break;
             case 4:
                 $format = ($value > 0) ?
-                    $sections[0] : ( ($value < 0) ?
+                    $sections[0] : (($value < 0) ?
                         $sections[1] : $sections[2]);
                 $value = abs($value); // Use the absolute value
                 break;
@@ -684,7 +684,7 @@ 
 
                 if (preg_match('/#?.*\?\/\?/', $format, $m)) {
                     //echo 'Format mask is fractional '.$format.' <br />';
-                    if ($value != (int)$value) {
+                    if ($value != (int) $value) {
                         self::formatAsFraction($value, $format);
                     }
                 } else {

src/PhpSpreadsheet/Style/Alignment.php

Spacing +2 added lines, -2 removed lines

@@ -37,14 +37,14 @@
     const HORIZONTAL_CENTER_CONTINUOUS = 'centerContinuous';
     const HORIZONTAL_JUSTIFY           = 'justify';
     const HORIZONTAL_FILL              = 'fill';
-    const HORIZONTAL_DISTRIBUTED       = 'distributed';        // Excel2007 only
+    const HORIZONTAL_DISTRIBUTED       = 'distributed'; // Excel2007 only
 
     /* Vertical alignment styles */
     const VERTICAL_BOTTOM      = 'bottom';
     const VERTICAL_TOP         = 'top';
     const VERTICAL_CENTER      = 'center';
     const VERTICAL_JUSTIFY     = 'justify';
-    const VERTICAL_DISTRIBUTED = 'distributed';        // Excel2007 only
+    const VERTICAL_DISTRIBUTED = 'distributed'; // Excel2007 only
 
     /* Read order */
     const READORDER_CONTEXT = 0;

src/PhpSpreadsheet/Style/Color.php

Spacing +55 added lines, -55 removed lines

@@ -357,61 +357,61 @@
         // Indexed colors
         if (is_null(self::$indexedColors)) {
             self::$indexedColors = [
-                1  => 'FF000000',    //  System Colour #1 - Black
-                2  => 'FFFFFFFF',    //  System Colour #2 - White
-                3  => 'FFFF0000',    //  System Colour #3 - Red
-                4  => 'FF00FF00',    //  System Colour #4 - Green
-                5  => 'FF0000FF',    //  System Colour #5 - Blue
-                6  => 'FFFFFF00',    //  System Colour #6 - Yellow
-                7  => 'FFFF00FF',    //  System Colour #7- Magenta
-                8  => 'FF00FFFF',    //  System Colour #8- Cyan
-                9  => 'FF800000',    //  Standard Colour #9
-                10 => 'FF008000',    //  Standard Colour #10
-                11 => 'FF000080',    //  Standard Colour #11
-                12 => 'FF808000',    //  Standard Colour #12
-                13 => 'FF800080',    //  Standard Colour #13
-                14 => 'FF008080',    //  Standard Colour #14
-                15 => 'FFC0C0C0',    //  Standard Colour #15
-                16 => 'FF808080',    //  Standard Colour #16
-                17 => 'FF9999FF',    //  Chart Fill Colour #17
-                18 => 'FF993366',    //  Chart Fill Colour #18
-                19 => 'FFFFFFCC',    //  Chart Fill Colour #19
-                20 => 'FFCCFFFF',    //  Chart Fill Colour #20
-                21 => 'FF660066',    //  Chart Fill Colour #21
-                22 => 'FFFF8080',    //  Chart Fill Colour #22
-                23 => 'FF0066CC',    //  Chart Fill Colour #23
-                24 => 'FFCCCCFF',    //  Chart Fill Colour #24
-                25 => 'FF000080',    //  Chart Line Colour #25
-                26 => 'FFFF00FF',    //  Chart Line Colour #26
-                27 => 'FFFFFF00',    //  Chart Line Colour #27
-                28 => 'FF00FFFF',    //  Chart Line Colour #28
-                29 => 'FF800080',    //  Chart Line Colour #29
-                30 => 'FF800000',    //  Chart Line Colour #30
-                31 => 'FF008080',    //  Chart Line Colour #31
-                32 => 'FF0000FF',    //  Chart Line Colour #32
-                33 => 'FF00CCFF',    //  Standard Colour #33
-                34 => 'FFCCFFFF',    //  Standard Colour #34
-                35 => 'FFCCFFCC',    //  Standard Colour #35
-                36 => 'FFFFFF99',    //  Standard Colour #36
-                37 => 'FF99CCFF',    //  Standard Colour #37
-                38 => 'FFFF99CC',    //  Standard Colour #38
-                39 => 'FFCC99FF',    //  Standard Colour #39
-                40 => 'FFFFCC99',    //  Standard Colour #40
-                41 => 'FF3366FF',    //  Standard Colour #41
-                42 => 'FF33CCCC',    //  Standard Colour #42
-                43 => 'FF99CC00',    //  Standard Colour #43
-                44 => 'FFFFCC00',    //  Standard Colour #44
-                45 => 'FFFF9900',    //  Standard Colour #45
-                46 => 'FFFF6600',    //  Standard Colour #46
-                47 => 'FF666699',    //  Standard Colour #47
-                48 => 'FF969696',    //  Standard Colour #48
-                49 => 'FF003366',    //  Standard Colour #49
-                50 => 'FF339966',    //  Standard Colour #50
-                51 => 'FF003300',    //  Standard Colour #51
-                52 => 'FF333300',    //  Standard Colour #52
-                53 => 'FF993300',    //  Standard Colour #53
-                54 => 'FF993366',    //  Standard Colour #54
-                55 => 'FF333399',    //  Standard Colour #55
+                1  => 'FF000000', //  System Colour #1 - Black
+                2  => 'FFFFFFFF', //  System Colour #2 - White
+                3  => 'FFFF0000', //  System Colour #3 - Red
+                4  => 'FF00FF00', //  System Colour #4 - Green
+                5  => 'FF0000FF', //  System Colour #5 - Blue
+                6  => 'FFFFFF00', //  System Colour #6 - Yellow
+                7  => 'FFFF00FF', //  System Colour #7- Magenta
+                8  => 'FF00FFFF', //  System Colour #8- Cyan
+                9  => 'FF800000', //  Standard Colour #9
+                10 => 'FF008000', //  Standard Colour #10
+                11 => 'FF000080', //  Standard Colour #11
+                12 => 'FF808000', //  Standard Colour #12
+                13 => 'FF800080', //  Standard Colour #13
+                14 => 'FF008080', //  Standard Colour #14
+                15 => 'FFC0C0C0', //  Standard Colour #15
+                16 => 'FF808080', //  Standard Colour #16
+                17 => 'FF9999FF', //  Chart Fill Colour #17
+                18 => 'FF993366', //  Chart Fill Colour #18
+                19 => 'FFFFFFCC', //  Chart Fill Colour #19
+                20 => 'FFCCFFFF', //  Chart Fill Colour #20
+                21 => 'FF660066', //  Chart Fill Colour #21
+                22 => 'FFFF8080', //  Chart Fill Colour #22
+                23 => 'FF0066CC', //  Chart Fill Colour #23
+                24 => 'FFCCCCFF', //  Chart Fill Colour #24
+                25 => 'FF000080', //  Chart Line Colour #25
+                26 => 'FFFF00FF', //  Chart Line Colour #26
+                27 => 'FFFFFF00', //  Chart Line Colour #27
+                28 => 'FF00FFFF', //  Chart Line Colour #28
+                29 => 'FF800080', //  Chart Line Colour #29
+                30 => 'FF800000', //  Chart Line Colour #30
+                31 => 'FF008080', //  Chart Line Colour #31
+                32 => 'FF0000FF', //  Chart Line Colour #32
+                33 => 'FF00CCFF', //  Standard Colour #33
+                34 => 'FFCCFFFF', //  Standard Colour #34
+                35 => 'FFCCFFCC', //  Standard Colour #35
+                36 => 'FFFFFF99', //  Standard Colour #36
+                37 => 'FF99CCFF', //  Standard Colour #37
+                38 => 'FFFF99CC', //  Standard Colour #38
+                39 => 'FFCC99FF', //  Standard Colour #39
+                40 => 'FFFFCC99', //  Standard Colour #40
+                41 => 'FF3366FF', //  Standard Colour #41
+                42 => 'FF33CCCC', //  Standard Colour #42
+                43 => 'FF99CC00', //  Standard Colour #43
+                44 => 'FFFFCC00', //  Standard Colour #44
+                45 => 'FFFF9900', //  Standard Colour #45
+                46 => 'FFFF6600', //  Standard Colour #46
+                47 => 'FF666699', //  Standard Colour #47
+                48 => 'FF969696', //  Standard Colour #48
+                49 => 'FF003366', //  Standard Colour #49
+                50 => 'FF339966', //  Standard Colour #50
+                51 => 'FF003300', //  Standard Colour #51
+                52 => 'FF333300', //  Standard Colour #52
+                53 => 'FF993300', //  Standard Colour #53
+                54 => 'FF993366', //  Standard Colour #54
+                55 => 'FF333399', //  Standard Colour #55
                 56 => 'FF333333'     //  Standard Colour #56
             ];
         }