PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Writer/Excel2007/StringTable.php

Spacing +18 added lines, -18 removed lines

@@ -40,7 +40,7 @@ 
             // Create string lookup table
             $aStringTable = array();
             $cellCollection = null;
-            $aFlippedStringTable = null;    // For faster lookup
+            $aFlippedStringTable = null; // For faster lookup
 
             // Is an existing table given?
             if (($pExistingTable !== null) && is_array($pExistingTable)) {
@@ -105,7 +105,7 @@ 
             foreach ($pStringTable as $textElement) {
                 $objWriter->startElement('si');
 
-                if (! $textElement instanceof \PhpSpreadsheet\RichText) {
+                if (!$textElement instanceof \PhpSpreadsheet\RichText) {
                     $textToWrite = \PhpSpreadsheet\Shared\StringHelper::controlCharacterPHP2OOXML($textElement);
                     $objWriter->startElement('t');
                     if ($textToWrite !== trim($textToWrite)) {
@@ -146,31 +146,31 @@ 
         $elements = $pRichText->getRichTextElements();
         foreach ($elements as $element) {
             // r
-            $objWriter->startElement($prefix.'r');
+            $objWriter->startElement($prefix . 'r');
 
             // rPr
             if ($element instanceof \PhpSpreadsheet\RichText\Run) {
                 // rPr
-                $objWriter->startElement($prefix.'rPr');
+                $objWriter->startElement($prefix . 'rPr');
 
                 // rFont
-                $objWriter->startElement($prefix.'rFont');
+                $objWriter->startElement($prefix . 'rFont');
                 $objWriter->writeAttribute('val', $element->getFont()->getName());
                 $objWriter->endElement();
 
                 // Bold
-                $objWriter->startElement($prefix.'b');
+                $objWriter->startElement($prefix . 'b');
                 $objWriter->writeAttribute('val', ($element->getFont()->getBold() ? 'true' : 'false'));
                 $objWriter->endElement();
 
                 // Italic
-                $objWriter->startElement($prefix.'i');
+                $objWriter->startElement($prefix . 'i');
                 $objWriter->writeAttribute('val', ($element->getFont()->getItalic() ? 'true' : 'false'));
                 $objWriter->endElement();
 
                 // Superscript / subscript
                 if ($element->getFont()->getSuperScript() || $element->getFont()->getSubScript()) {
-                    $objWriter->startElement($prefix.'vertAlign');
+                    $objWriter->startElement($prefix . 'vertAlign');
                     if ($element->getFont()->getSuperScript()) {
                         $objWriter->writeAttribute('val', 'superscript');
                     } elseif ($element->getFont()->getSubScript()) {
@@ -180,22 +180,22 @@ 
                 }
 
                 // Strikethrough
-                $objWriter->startElement($prefix.'strike');
+                $objWriter->startElement($prefix . 'strike');
                 $objWriter->writeAttribute('val', ($element->getFont()->getStrikethrough() ? 'true' : 'false'));
                 $objWriter->endElement();
 
                 // Color
-                $objWriter->startElement($prefix.'color');
+                $objWriter->startElement($prefix . 'color');
                 $objWriter->writeAttribute('rgb', $element->getFont()->getColor()->getARGB());
                 $objWriter->endElement();
 
                 // Size
-                $objWriter->startElement($prefix.'sz');
+                $objWriter->startElement($prefix . 'sz');
                 $objWriter->writeAttribute('val', $element->getFont()->getSize());
                 $objWriter->endElement();
 
                 // Underline
-                $objWriter->startElement($prefix.'u');
+                $objWriter->startElement($prefix . 'u');
                 $objWriter->writeAttribute('val', $element->getFont()->getUnderline());
                 $objWriter->endElement();
 
@@ -203,7 +203,7 @@ 
             }
 
             // t
-            $objWriter->startElement($prefix.'t');
+            $objWriter->startElement($prefix . 't');
             $objWriter->writeAttribute('xml:space', 'preserve');
             $objWriter->writeRawData(\PhpSpreadsheet\Shared\StringHelper::controlCharacterPHP2OOXML($element->getText()));
             $objWriter->endElement();
@@ -236,10 +236,10 @@ 
         $elements = $pRichText->getRichTextElements();
         foreach ($elements as $element) {
             // r
-            $objWriter->startElement($prefix.'r');
+            $objWriter->startElement($prefix . 'r');
 
             // rPr
-            $objWriter->startElement($prefix.'rPr');
+            $objWriter->startElement($prefix . 'rPr');
 
             // Bold
             $objWriter->writeAttribute('b', ($element->getFont()->getBold() ? 1 : 0));
@@ -260,7 +260,7 @@ 
             $objWriter->writeAttribute('strike', ($element->getFont()->getStrikethrough() ? 'sngStrike' : 'noStrike'));
 
             // rFont
-            $objWriter->startElement($prefix.'latin');
+            $objWriter->startElement($prefix . 'latin');
                 $objWriter->writeAttribute('typeface', $element->getFont()->getName());
             $objWriter->endElement();
 
@@ -278,7 +278,7 @@ 
             $objWriter->endElement();
 
             // t
-            $objWriter->startElement($prefix.'t');
+            $objWriter->startElement($prefix . 't');
 //                    $objWriter->writeAttribute('xml:space', 'preserve');    //    Excel2010 accepts, Excel2007 complains
             $objWriter->writeRawData(\PhpSpreadsheet\Shared\StringHelper::controlCharacterPHP2OOXML($element->getText()));
             $objWriter->endElement();
@@ -300,7 +300,7 @@ 
 
         // Loop through stringtable and add flipped items to $returnValue
         foreach ($stringTable as $key => $value) {
-            if (! $value instanceof \PhpSpreadsheet\RichText) {
+            if (!$value instanceof \PhpSpreadsheet\RichText) {
                 $returnValue[$value] = $key;
             } elseif ($value instanceof \PhpSpreadsheet\RichText) {
                 $returnValue[$value->getHashCode()] = $key;

src/PhpSpreadsheet/Writer/Excel2007/Drawing.php

Spacing +6 added lines, -6 removed lines

@@ -69,7 +69,7 @@ 
             // Loop through charts and write the chart position
             if ($chartCount > 0) {
                 for ($c = 0; $c < $chartCount; ++$c) {
-                    $this->writeChart($objWriter, $pWorksheet->getChartByIndex($c), $c+$i);
+                    $this->writeChart($objWriter, $pWorksheet->getChartByIndex($c), $c + $i);
                 }
             }
         }
@@ -114,7 +114,7 @@ 
                 $objWriter->writeAttribute('macro', '');
                 $objWriter->startElement('xdr:nvGraphicFramePr');
                     $objWriter->startElement('xdr:cNvPr');
-                        $objWriter->writeAttribute('name', 'Chart '.$pRelationId);
+                        $objWriter->writeAttribute('name', 'Chart ' . $pRelationId);
                         $objWriter->writeAttribute('id', 1025 * $pRelationId);
                     $objWriter->endElement();
                     $objWriter->startElement('xdr:cNvGraphicFramePr');
@@ -140,7 +140,7 @@ 
                         $objWriter->startElement('c:chart');
                             $objWriter->writeAttribute('xmlns:c', 'http://schemas.openxmlformats.org/drawingml/2006/chart');
                             $objWriter->writeAttribute('xmlns:r', 'http://schemas.openxmlformats.org/officeDocument/2006/relationships');
-                            $objWriter->writeAttribute('r:id', 'rId'.$pRelationId);
+                            $objWriter->writeAttribute('r:id', 'rId' . $pRelationId);
                         $objWriter->endElement();
                     $objWriter->endElement();
                 $objWriter->endElement();
@@ -166,8 +166,8 @@ 
             // xdr:oneCellAnchor
             $objWriter->startElement('xdr:oneCellAnchor');
             // Image location
-            $aCoordinates         = \PhpSpreadsheet\Cell::coordinateFromString($pDrawing->getCoordinates());
-            $aCoordinates[0]     = \PhpSpreadsheet\Cell::columnIndexFromString($aCoordinates[0]);
+            $aCoordinates = \PhpSpreadsheet\Cell::coordinateFromString($pDrawing->getCoordinates());
+            $aCoordinates[0] = \PhpSpreadsheet\Cell::columnIndexFromString($aCoordinates[0]);
 
             // xdr:from
             $objWriter->startElement('xdr:from');
@@ -570,7 +570,7 @@ 
     public function allDrawings(\PhpSpreadsheet\SpreadSheet $spreadsheet = null)
     {
         // Get an array of all drawings
-        $aDrawings    = array();
+        $aDrawings = array();
 
         // Loop through PhpSpreadsheet
         $sheetCount = $spreadsheet->getSheetCount();

src/PhpSpreadsheet/Writer/HTML.php

Spacing +19 added lines, -19 removed lines

@@ -438,7 +438,7 @@ 
 
             // calculate start of <tbody>, <thead>
             $tbodyStart = $rowMin;
-            $theadStart = $theadEnd   = 0; // default: no <thead>    no </thead>
+            $theadStart = $theadEnd = 0; // default: no <thead>    no </thead>
             if ($sheet->getPageSetup()->isRowsToRepeatAtTopSet()) {
                 $rowsToRepeatAtTop = $sheet->getPageSetup()->getRowsToRepeatAtTop();
 
@@ -451,7 +451,7 @@ 
             }
 
             // Loop through cells
-            $row = $rowMin-1;
+            $row = $rowMin - 1;
             while ($row++ < $rowMax) {
                 // <thead> ?
                 if ($row == $theadStart) {
@@ -589,9 +589,9 @@ 
             $html .= '<tr>';
             for ($col = 'A'; $col != $colMax; ++$col) {
                 $html .= '<td>';
-                $html .= $this->writeImageInCell($pSheet, $col.$row);
+                $html .= $this->writeImageInCell($pSheet, $col . $row);
                 if ($this->includeCharts) {
-                    $html .= $this->writeChartInCell($pSheet, $col.$row);
+                    $html .= $this->writeChartInCell($pSheet, $col . $row);
                 }
                 $html .= '</td>';
             }
@@ -648,7 +648,7 @@ 
                             // base64 encode the binary data, then break it
                             // into chunks according to RFC 2045 semantics
                             $base64 = chunk_split(base64_encode($picture));
-                            $imageData = 'data:'.$imageDetails['mime'].';base64,' . $base64;
+                            $imageData = 'data:' . $imageDetails['mime'] . ';base64,' . $base64;
                         } else {
                             $imageData = $filename;
                         }
@@ -665,10 +665,10 @@ 
                 if ($drawing->getCoordinates() != $coordinates) {
                     continue;
                 }
-                ob_start();                                //  Let's start output buffering.
-                imagepng($drawing->getImageResource());    //  This will normally output the image, but because of ob_start(), it won't.
-                $contents = ob_get_contents();             //  Instead, output above is saved to $contents
-                ob_end_clean();                            //  End the output buffer.
+                ob_start(); //  Let's start output buffering.
+                imagepng($drawing->getImageResource()); //  This will normally output the image, but because of ob_start(), it won't.
+                $contents = ob_get_contents(); //  Instead, output above is saved to $contents
+                ob_end_clean(); //  End the output buffer.
 
                 $dataUri = "data:image/jpeg;base64," . base64_encode($contents);
 
@@ -676,7 +676,7 @@ 
                 //  max-width: 100% ensures that image doesnt overflow containing cell
                 //  width: X sets width of supplied image.
                 //  As a result, images bigger than cell will be contained and images smaller will not get stretched
-                $html .= '<img src="'.$dataUri.'" style="max-width:100%;width:'.$drawing->getWidth().'px;" />';
+                $html .= '<img src="' . $dataUri . '" style="max-width:100%;width:' . $drawing->getWidth() . 'px;" />';
             }
         }
 
@@ -701,7 +701,7 @@ 
             if ($chart instanceof Spreadsheet_Chart) {
                 $chartCoordinates = $chart->getTopLeftPosition();
                 if ($chartCoordinates['cell'] == $coordinates) {
-                    $chartFileName = \Spreadsheet\Shared\File::sysGetTempDir().'/'.uniqid().'.png';
+                    $chartFileName = \Spreadsheet\Shared\File::sysGetTempDir() . '/' . uniqid() . '.png';
                     if (!$chart->render($chartFileName)) {
                         return;
                     }
@@ -714,7 +714,7 @@ 
                         // base64 encode the binary data, then break it
                         // into chunks according to RFC 2045 semantics
                         $base64 = chunk_split(base64_encode($picture));
-                        $imageData = 'data:'.$imageDetails['mime'].';base64,' . $base64;
+                        $imageData = 'data:' . $imageDetails['mime'] . ';base64,' . $base64;
 
                         $html .= '<div style="position: relative;">';
                         $html .= '<img style="position: absolute; z-index: 1; left: ' . $chartCoordinates['xOffset'] . 'px; top: ' . $chartCoordinates['yOffset'] . 'px; width: ' . $imageDetails[0] . 'px; height: ' . $imageDetails[1] . 'px;" src="' . $imageData . '" border="0" />' . PHP_EOL;
@@ -809,7 +809,7 @@ 
 
 
         // table { }
-        $css['table']['border-collapse']  = 'collapse';
+        $css['table']['border-collapse'] = 'collapse';
         if (!$this->isPdf) {
             $css['table']['page-break-after'] = 'always';
         }
@@ -967,7 +967,7 @@ 
         if ($textAlign = $this->mapHAlign($pStyle->getHorizontal())) {
             $css['text-align'] = $textAlign;
             if (in_array($textAlign, array('left', 'right'))) {
-                $css['padding-'.$textAlign] = (string)((int)$pStyle->getIndent() * 9).'px';
+                $css['padding-' . $textAlign] = (string) ((int) $pStyle->getIndent() * 9) . 'px';
             }
         }
 
@@ -1258,9 +1258,9 @@ 
                         }
                         $cellData = htmlspecialchars($cellData);
                         if ($pSheet->getParent()->getCellXfByIndex($cell->getXfIndex())->getFont()->getSuperScript()) {
-                            $cellData = '<sup>'.$cellData.'</sup>';
+                            $cellData = '<sup>' . $cellData . '</sup>';
                         } elseif ($pSheet->getParent()->getCellXfByIndex($cell->getXfIndex())->getFont()->getSubScript()) {
-                            $cellData = '<sub>'.$cellData.'</sub>';
+                            $cellData = '<sub>' . $cellData . '</sub>';
                         }
                     }
 
@@ -1370,7 +1370,7 @@ 
                     $html .= $cellData;
 
                     // Column end
-                    $html .= '</'.$cellType.'>' . PHP_EOL;
+                    $html .= '</' . $cellType . '>' . PHP_EOL;
                 }
 
                 // Next column
@@ -1515,7 +1515,7 @@ 
         foreach ($sheetIndexes as $sheetIndex) {
             $sheet = $this->spreadsheet->getSheet($sheetIndex);
 
-            $candidateSpannedRow  = array();
+            $candidateSpannedRow = array();
 
             // loop through all Excel merged cells
             foreach ($sheet->getMergeCells() as $cells) {
@@ -1577,7 +1577,7 @@ 
 
                         if (!in_array($baseCell, $adjustedBaseCells)) {
                             // subtract rowspan by 1
-                            --$this->isBaseCell[$sheetIndex][ $baseCell[0] ][ $baseCell[1] ]['rowspan'];
+                            --$this->isBaseCell[$sheetIndex][$baseCell[0]][$baseCell[1]]['rowspan'];
                             $adjustedBaseCells[] = $baseCell;
                         }
                     }

src/PhpSpreadsheet/Chart.php

Spacing +1 added lines, -1 removed lines

@@ -668,7 +668,7 @@
             set_include_path(get_include_path() . PATH_SEPARATOR . $libraryPath);
         }
 
-        $rendererName = '\\PhpSpreadsheet\\Chart\\Renderer\\'.$libraryName;
+        $rendererName = '\\PhpSpreadsheet\\Chart\\Renderer\\' . $libraryName;
         $renderer = new $rendererName($this);
 
         if ($outputDestination == 'php://output') {

src/PhpSpreadsheet/Shared/Excel5.php

Spacing +10 added lines, -10 removed lines

@@ -233,8 +233,8 @@ 
         $y1 = $offsetY;
 
         // Initialise end cell to the same as the start cell
-        $col_end    = $col_start;  // Col containing lower right corner of object
-        $row_end    = $row_start;  // Row containing bottom right corner of object
+        $col_end    = $col_start; // Col containing lower right corner of object
+        $row_end    = $row_start; // Row containing bottom right corner of object
 
         // Zero the specified offset if greater than the cell dimensions
         if ($x1 >= self::sizeCol($sheet, \PhpSpreadsheet\Cell::stringFromColumnIndex($col_start))) {
@@ -244,8 +244,8 @@ 
             $y1 = 0;
         }
 
-        $width      = $width  + $x1 -1;
-        $height     = $height + $y1 -1;
+        $width      = $width + $x1 - 1;
+        $height     = $height + $y1 - 1;
 
         // Subtract the underlying cell widths to find the end cell of the image
         while ($width >= self::sizeCol($sheet, \PhpSpreadsheet\Cell::stringFromColumnIndex($col_end))) {
@@ -264,21 +264,21 @@ 
         if (self::sizeCol($sheet, \PhpSpreadsheet\Cell::stringFromColumnIndex($col_start)) == 0) {
             return;
         }
-        if (self::sizeCol($sheet, \PhpSpreadsheet\Cell::stringFromColumnIndex($col_end))   == 0) {
+        if (self::sizeCol($sheet, \PhpSpreadsheet\Cell::stringFromColumnIndex($col_end)) == 0) {
             return;
         }
         if (self::sizeRow($sheet, $row_start + 1) == 0) {
             return;
         }
-        if (self::sizeRow($sheet, $row_end + 1)   == 0) {
+        if (self::sizeRow($sheet, $row_end + 1) == 0) {
             return;
         }
 
         // Convert the pixel values to the percentage value expected by Excel
-        $x1 = $x1     / self::sizeCol($sheet, \PhpSpreadsheet\Cell::stringFromColumnIndex($col_start))   * 1024;
-        $y1 = $y1     / self::sizeRow($sheet, $row_start + 1)   *  256;
-        $x2 = ($width + 1)  / self::sizeCol($sheet, \PhpSpreadsheet\Cell::stringFromColumnIndex($col_end))     * 1024; // Distance to right side of object
-        $y2 = ($height + 1) / self::sizeRow($sheet, $row_end + 1)     *  256; // Distance to bottom of object
+        $x1 = $x1 / self::sizeCol($sheet, \PhpSpreadsheet\Cell::stringFromColumnIndex($col_start)) * 1024;
+        $y1 = $y1 / self::sizeRow($sheet, $row_start + 1) * 256;
+        $x2 = ($width + 1) / self::sizeCol($sheet, \PhpSpreadsheet\Cell::stringFromColumnIndex($col_end)) * 1024; // Distance to right side of object
+        $y2 = ($height + 1) / self::sizeRow($sheet, $row_end + 1) * 256; // Distance to bottom of object
 
         $startCoordinates = \PhpSpreadsheet\Cell::stringFromColumnIndex($col_start) . ($row_start + 1);
         $endCoordinates = \PhpSpreadsheet\Cell::stringFromColumnIndex($col_end) . ($row_end + 1);

src/PhpSpreadsheet/Shared/Font.php

Spacing +3 added lines, -3 removed lines

@@ -45,8 +45,8 @@ 
     const CHARSET_ANSI_JAPANESE_SHIFTJIS    = 0x80;
     const CHARSET_ANSI_KOREAN_HANGUL        = 0x81;
     const CHARSET_ANSI_KOREAN_JOHAB         = 0x82;
-    const CHARSET_ANSI_CHINESE_SIMIPLIFIED  = 0x86;        //    gb2312
-    const CHARSET_ANSI_CHINESE_TRADITIONAL  = 0x88;        //    big5
+    const CHARSET_ANSI_CHINESE_SIMIPLIFIED  = 0x86; //    gb2312
+    const CHARSET_ANSI_CHINESE_TRADITIONAL  = 0x88; //    big5
     const CHARSET_ANSI_GREEK                = 0xA1;
     const CHARSET_ANSI_TURKISH              = 0xA2;
     const CHARSET_ANSI_VIETNAMESE           = 0xA3;
@@ -511,7 +511,7 @@ 
                 );
                 break;
             default:
-                throw new \PhpSpreadsheet\Exception('Unknown font name "'. $name .'". Cannot map to TrueType font file');
+                throw new \PhpSpreadsheet\Exception('Unknown font name "' . $name . '". Cannot map to TrueType font file');
                 break;
         }
 

src/PhpSpreadsheet/Shared/CodePage.php

Spacing +52 added lines, -52 removed lines

@@ -40,117 +40,117 @@
     {
         switch ($codePage) {
             case 367:
-                return 'ASCII';    //    ASCII
+                return 'ASCII'; //    ASCII
             case 437:
-                return 'CP437';    //    OEM US
+                return 'CP437'; //    OEM US
             case 720:
-                throw new \PhpSpreadsheet\Exception('Code page 720 not supported.');    //    OEM Arabic
+                throw new \PhpSpreadsheet\Exception('Code page 720 not supported.'); //    OEM Arabic
             case 737:
-                return 'CP737';    //    OEM Greek
+                return 'CP737'; //    OEM Greek
             case 775:
-                return 'CP775';    //    OEM Baltic
+                return 'CP775'; //    OEM Baltic
             case 850:
-                return 'CP850';    //    OEM Latin I
+                return 'CP850'; //    OEM Latin I
             case 852:
-                return 'CP852';    //    OEM Latin II (Central European)
+                return 'CP852'; //    OEM Latin II (Central European)
             case 855:
-                return 'CP855';    //    OEM Cyrillic
+                return 'CP855'; //    OEM Cyrillic
             case 857:
-                return 'CP857';    //    OEM Turkish
+                return 'CP857'; //    OEM Turkish
             case 858:
-                return 'CP858';    //    OEM Multilingual Latin I with Euro
+                return 'CP858'; //    OEM Multilingual Latin I with Euro
             case 860:
-                return 'CP860';    //    OEM Portugese
+                return 'CP860'; //    OEM Portugese
             case 861:
-                return 'CP861';    //    OEM Icelandic
+                return 'CP861'; //    OEM Icelandic
             case 862:
-                return 'CP862';    //    OEM Hebrew
+                return 'CP862'; //    OEM Hebrew
             case 863:
-                return 'CP863';    //    OEM Canadian (French)
+                return 'CP863'; //    OEM Canadian (French)
             case 864:
-                return 'CP864';    //    OEM Arabic
+                return 'CP864'; //    OEM Arabic
             case 865:
-                return 'CP865';    //    OEM Nordic
+                return 'CP865'; //    OEM Nordic
             case 866:
-                return 'CP866';    //    OEM Cyrillic (Russian)
+                return 'CP866'; //    OEM Cyrillic (Russian)
             case 869:
-                return 'CP869';    //    OEM Greek (Modern)
+                return 'CP869'; //    OEM Greek (Modern)
             case 874:
-                return 'CP874';    //    ANSI Thai
+                return 'CP874'; //    ANSI Thai
             case 932:
-                return 'CP932';    //    ANSI Japanese Shift-JIS
+                return 'CP932'; //    ANSI Japanese Shift-JIS
             case 936:
-                return 'CP936';    //    ANSI Chinese Simplified GBK
+                return 'CP936'; //    ANSI Chinese Simplified GBK
             case 949:
-                return 'CP949';    //    ANSI Korean (Wansung)
+                return 'CP949'; //    ANSI Korean (Wansung)
             case 950:
-                return 'CP950';    //    ANSI Chinese Traditional BIG5
+                return 'CP950'; //    ANSI Chinese Traditional BIG5
             case 1200:
                 return 'UTF-16LE'; //    UTF-16 (BIFF8)
             case 1250:
-                return 'CP1250';   //    ANSI Latin II (Central European)
+                return 'CP1250'; //    ANSI Latin II (Central European)
             case 1251:
-                return 'CP1251';   //    ANSI Cyrillic
+                return 'CP1251'; //    ANSI Cyrillic
             case 0:
                 //    CodePage is not always correctly set when the xls file was saved by Apple's Numbers program
             case 1252:
-                return 'CP1252';   //    ANSI Latin I (BIFF4-BIFF7)
+                return 'CP1252'; //    ANSI Latin I (BIFF4-BIFF7)
             case 1253:
-                return 'CP1253';   //    ANSI Greek
+                return 'CP1253'; //    ANSI Greek
             case 1254:
-                return 'CP1254';   //    ANSI Turkish
+                return 'CP1254'; //    ANSI Turkish
             case 1255:
-                return 'CP1255';   //    ANSI Hebrew
+                return 'CP1255'; //    ANSI Hebrew
             case 1256:
-                return 'CP1256';   //    ANSI Arabic
+                return 'CP1256'; //    ANSI Arabic
             case 1257:
-                return 'CP1257';   //    ANSI Baltic
+                return 'CP1257'; //    ANSI Baltic
             case 1258:
-                return 'CP1258';   //    ANSI Vietnamese
+                return 'CP1258'; //    ANSI Vietnamese
             case 1361:
-                return 'CP1361';   //    ANSI Korean (Johab)
+                return 'CP1361'; //    ANSI Korean (Johab)
             case 10000:
-                return 'MAC';      //    Apple Roman
+                return 'MAC'; //    Apple Roman
             case 10001:
-                return 'CP932';    //    Macintosh Japanese
+                return 'CP932'; //    Macintosh Japanese
             case 10002:
-                return 'CP950';    //    Macintosh Chinese Traditional
+                return 'CP950'; //    Macintosh Chinese Traditional
             case 10003:
-                return 'CP1361';   //    Macintosh Korean
+                return 'CP1361'; //    Macintosh Korean
             case 10004:
                 return 'MACARABIC'; //    Apple Arabic
             case 10005:
                 return 'MACHEBREW'; //    Apple Hebrew
             case 10006:
-                return 'MACGREEK';  //    Macintosh Greek
+                return 'MACGREEK'; //    Macintosh Greek
             case 10007:
-                return 'MACCYRILLIC';  //    Macintosh Cyrillic
+                return 'MACCYRILLIC'; //    Macintosh Cyrillic
             case 10008:
-                return 'CP936';  //    Macintosh - Simplified Chinese (GB 2312)
+                return 'CP936'; //    Macintosh - Simplified Chinese (GB 2312)
             case 10010:
-                return 'MACROMANIA';    //    Macintosh Romania
+                return 'MACROMANIA'; //    Macintosh Romania
             case 10017:
-                return 'MACUKRAINE';    //    Macintosh Ukraine
+                return 'MACUKRAINE'; //    Macintosh Ukraine
             case 10021:
-                return 'MACTHAI';    //    Macintosh Thai
+                return 'MACTHAI'; //    Macintosh Thai
             case 10029:
-                return 'MACCENTRALEUROPE';  //    Macintosh Central Europe
+                return 'MACCENTRALEUROPE'; //    Macintosh Central Europe
             case 10079:
-                return 'MACICELAND';  //    Macintosh Icelandic
+                return 'MACICELAND'; //    Macintosh Icelandic
             case 10081:
-                return 'MACTURKISH';  //    Macintosh Turkish
+                return 'MACTURKISH'; //    Macintosh Turkish
             case 10082:
-                return 'MACCROATIAN';    //    Macintosh Croatian
+                return 'MACCROATIAN'; //    Macintosh Croatian
             case 21010:
-                return 'UTF-16LE';  //    UTF-16 (BIFF8) This isn't correct, but some Excel writer libraries erroneously use Codepage 21010 for UTF-16LE
+                return 'UTF-16LE'; //    UTF-16 (BIFF8) This isn't correct, but some Excel writer libraries erroneously use Codepage 21010 for UTF-16LE
             case 32768:
-                return 'MAC';      //    Apple Roman
+                return 'MAC'; //    Apple Roman
             case 32769:
-                throw new \PhpSpreadsheet\Exception('Code page 32769 not supported.');  //    ANSI Latin I (BIFF2-BIFF3)
+                throw new \PhpSpreadsheet\Exception('Code page 32769 not supported.'); //    ANSI Latin I (BIFF2-BIFF3)
             case 65000:
-                return 'UTF-7';    //    Unicode (UTF-7)
+                return 'UTF-7'; //    Unicode (UTF-7)
             case 65001:
-                return 'UTF-8';    //    Unicode (UTF-8)
+                return 'UTF-8'; //    Unicode (UTF-8)
         }
         throw new \PhpSpreadsheet\Exception('Unknown codepage: ' . $codePage);
     }

src/PhpSpreadsheet/Shared/Trend/Trend.php

Spacing +3 added lines, -3 removed lines

@@ -86,7 +86,7 @@ 
             trigger_error("Trend(): Number of elements in coordinate arrays do not match.", E_USER_ERROR);
         }
 
-        $key = md5($trendType.$const.serialize($yValues).serialize($xValues));
+        $key = md5($trendType . $const . serialize($yValues) . serialize($xValues));
         //    Determine which Trend method has been requested
         switch ($trendType) {
             //    Instantiate and return the class for the requested Trend method
@@ -95,7 +95,7 @@ 
             case self::TREND_EXPONENTIAL:
             case self::TREND_POWER:
                 if (!isset(self::$trendCache[$key])) {
-                    $className = '\PhpSpreadsheet\Shared\Trend\\'.$trendType.'BestFit';
+                    $className = '\PhpSpreadsheet\Shared\Trend\\' . $trendType . 'BestFit';
                     self::$trendCache[$key] = new $className($yValues, $xValues, $const);
                 }
                 return self::$trendCache[$key];
@@ -114,7 +114,7 @@ 
                 //    If the request is to determine the best fit regression, then we test each Trend line in turn
                 //    Start by generating an instance of each available Trend method
                 foreach (self::$trendTypes as $trendMethod) {
-                    $className = '\PhpSpreadsheet\Shared\Trend\\'.$trendType.'BestFit';
+                    $className = '\PhpSpreadsheet\Shared\Trend\\' . $trendType . 'BestFit';
                     $bestFit[$trendMethod] = new $className($yValues, $xValues, $const);
                     $bestFitValue[$trendMethod] = $bestFit[$trendMethod]->getGoodnessOfFit();
                 }

src/PhpSpreadsheet/Cell/AdvancedValueBinder.php

Spacing +3 added lines, -3 removed lines

@@ -55,7 +55,7 @@ 
             }
 
             // Check for number in scientific format
-            if (preg_match('/^'.\PhpSpreadsheet\Calculation::CALCULATION_REGEXP_NUMBER.'$/', $value)) {
+            if (preg_match('/^' . \PhpSpreadsheet\Calculation::CALCULATION_REGEXP_NUMBER . '$/', $value)) {
                 $cell->setValueExplicit((float) $value, DataType::TYPE_NUMERIC);
                 return true;
             }
@@ -100,7 +100,7 @@ 
             $currencyCode = \PhpSpreadsheet\Shared\StringHelper::getCurrencyCode();
             $decimalSeparator = \PhpSpreadsheet\Shared\StringHelper::getDecimalSeparator();
             $thousandsSeparator = \PhpSpreadsheet\Shared\StringHelper::getThousandsSeparator();
-            if (preg_match('/^'.preg_quote($currencyCode).' *(\d{1,3}('.preg_quote($thousandsSeparator).'\d{3})*|(\d+))('.preg_quote($decimalSeparator).'\d{2})?$/', $value)) {
+            if (preg_match('/^' . preg_quote($currencyCode) . ' *(\d{1,3}(' . preg_quote($thousandsSeparator) . '\d{3})*|(\d+))(' . preg_quote($decimalSeparator) . '\d{2})?$/', $value)) {
                 // Convert value to number
                 $value = (float) trim(str_replace(array($currencyCode, $thousandsSeparator, $decimalSeparator), array('', '', '.'), $value));
                 $cell->setValueExplicit($value, DataType::TYPE_NUMERIC);
@@ -112,7 +112,7 @@ 
                 return true;
             } elseif (preg_match('/^\$ *(\d{1,3}(\,\d{3})*|(\d+))(\.\d{2})?$/', $value)) {
                 // Convert value to number
-                $value = (float) trim(str_replace(array('$',','), '', $value));
+                $value = (float) trim(str_replace(array('$', ','), '', $value));
                 $cell->setValueExplicit($value, DataType::TYPE_NUMERIC);
                 // Set style
                 $cell->getWorksheet()->getStyle($cell->getCoordinate())