PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Writer/Excel5/Workbook.php

Doc Comments +4 added lines, -2 removed lines

@@ -192,7 +192,9 @@ 
      * @param int        &$str_unique    Total number of unique strings
      * @param array        &$str_table        String Table
      * @param array        &$colors        Colour Table
-     * @param mixed        $parser            The formula parser created for the Workbook
+     * @param Parser        $parser            The formula parser created for the Workbook
+     * @param integer $str_total
+     * @param integer $str_unique
      */
     public function __construct(\PHPExcel\Spreadsheet $phpExcel, &$str_total, &$str_unique, &$str_table, &$colors, $parser)
     {
@@ -792,7 +794,7 @@ 
      *
      * @param    string        $name            The name in UTF-8
      * @param    string        $formulaData    The binary formula data
-     * @param    string        $sheetIndex        1-based sheet index the defined name applies to. 0 = global
+     * @param    integer        $sheetIndex        1-based sheet index the defined name applies to. 0 = global
      * @param    boolean        $isBuiltIn        Built-in name?
      * @return    string    Complete binary record data
      */

Spacing +81 added lines, -81 removed lines

@@ -199,7 +199,7 @@ 
         // It needs to call its parent's constructor explicitly
         parent::__construct();
 
-        $this->parser        = $parser;
+        $this->parser = $parser;
         $this->biffSize     = 0;
         $this->palette      = array();
         $this->countryCode = -1;
@@ -207,7 +207,7 @@ 
         $this->stringTotal      = &$str_total;
         $this->stringUnique     = &$str_unique;
         $this->stringTable      = &$str_table;
-        $this->colors        = &$colors;
+        $this->colors = &$colors;
         $this->setPaletteXl97();
 
         $this->phpExcel = $phpExcel;
@@ -221,11 +221,11 @@ 
         for ($i = 0; $i < $countSheets; ++$i) {
             $phpSheet = $phpExcel->getSheet($i);
 
-            $this->parser->setExtSheet($phpSheet->getTitle(), $i);  // Register worksheet name with parser
+            $this->parser->setExtSheet($phpSheet->getTitle(), $i); // Register worksheet name with parser
 
             $supbook_index = 0x00;
             $ref = pack('vvv', $supbook_index, $i, $i);
-            $this->parser->references[] = $ref;  // Register reference with parser
+            $this->parser->references[] = $ref; // Register reference with parser
 
             // Sheet tab colors?
             if ($phpSheet->isTabColorSet()) {
@@ -472,7 +472,7 @@ 
      */
     private function calcSheetOffsets()
     {
-        $boundsheet_length = 10;  // fixed length for a BOUNDSHEET record
+        $boundsheet_length = 10; // fixed length for a BOUNDSHEET record
 
         // size of Workbook globals part 1 + 3
         $offset            = $this->_datasize;
@@ -836,9 +836,9 @@ 
         $record = 0x0018;
 
         // option flags
-        $options = ($isHidden  ? 0x21 : 0x00);
+        $options = ($isHidden ? 0x21 : 0x00);
 
-        $extra  = pack(
+        $extra = pack(
             'Cvvvvv',
             0x3B,
             $sheetIndex - 1,
@@ -866,9 +866,9 @@ 
      */
     private function writeCodepage()
     {
-        $record = 0x0042;             // Record identifier
-        $length = 0x0002;             // Number of bytes to follow
-        $cv  = $this->codepage;   // The code page
+        $record = 0x0042; // Record identifier
+        $length = 0x0002; // Number of bytes to follow
+        $cv = $this->codepage; // The code page
 
         $header = pack('vv', $record, $length);
         $data   = pack('v', $cv);
@@ -881,24 +881,24 @@ 
      */
     private function writeWindow1()
     {
-        $record = 0x003D;   // Record identifier
-        $length = 0x0012;   // Number of bytes to follow
+        $record = 0x003D; // Record identifier
+        $length = 0x0012; // Number of bytes to follow
 
-        $xWn  = 0x0000;     // Horizontal position of window
-        $yWn  = 0x0000;     // Vertical position of window
-        $dxWn = 0x25BC;     // Width of window
-        $dyWn = 0x1572;     // Height of window
+        $xWn  = 0x0000; // Horizontal position of window
+        $yWn  = 0x0000; // Vertical position of window
+        $dxWn = 0x25BC; // Width of window
+        $dyWn = 0x1572; // Height of window
 
-        $grbit = 0x0038;    // Option flags
+        $grbit = 0x0038; // Option flags
 
         // not supported by PHPExcel, so there is only one selected sheet, the active
-        $ctabsel = 1;       // Number of workbook tabs selected
+        $ctabsel = 1; // Number of workbook tabs selected
 
-        $wTabRatio = 0x0258;    // Tab to scrollbar ratio
+        $wTabRatio = 0x0258; // Tab to scrollbar ratio
 
         // not supported by PHPExcel, set to 0
-        $itabFirst = 0;     // 1st displayed worksheet
-        $itabCur   = $this->phpExcel->getActiveSheetIndex();    // Active worksheet
+        $itabFirst = 0; // 1st displayed worksheet
+        $itabCur   = $this->phpExcel->getActiveSheetIndex(); // Active worksheet
 
         $header = pack("vv", $record, $length);
         $data   = pack("vvvvvvvvv", $xWn, $yWn, $dxWn, $dyWn, $grbit, $itabCur, $itabFirst, $ctabsel, $wTabRatio);
@@ -914,7 +914,7 @@ 
     private function writeBoundSheet($sheet, $offset)
     {
         $sheetname = $sheet->getTitle();
-        $record    = 0x0085;                    // Record identifier
+        $record    = 0x0085; // Record identifier
 
         // sheet state
         switch ($sheet->getSheetState()) {
@@ -935,7 +935,7 @@ 
         // sheet type
         $st = 0x00;
 
-        $grbit = 0x0000;                    // Visibility and sheet type
+        $grbit = 0x0000; // Visibility and sheet type
 
         $data = pack("VCC", $offset, $ss, $st);
         $data .= \PHPExcel\Shared\StringHelper::UTF8toBIFF8UnicodeShort($sheetname);
@@ -950,8 +950,8 @@ 
      */
     private function writeSupbookInternal()
     {
-        $record    = 0x01AE;   // Record identifier
-        $length    = 0x0004;   // Bytes to follow
+        $record    = 0x01AE; // Record identifier
+        $length    = 0x0004; // Bytes to follow
 
         $header    = pack("vv", $record, $length);
         $data      = pack("vv", $this->phpExcel->getSheetCount(), 0x0401);
@@ -966,10 +966,10 @@ 
     private function writeExternalsheetBiff8()
     {
         $totalReferences = count($this->parser->references);
-        $record = 0x0017;                     // Record identifier
-        $length = 2 + 6 * $totalReferences;  // Number of bytes to follow
+        $record = 0x0017; // Record identifier
+        $length = 2 + 6 * $totalReferences; // Number of bytes to follow
 
-        $supbook_index = 0;           // FIXME: only using internal SUPBOOK record
+        $supbook_index = 0; // FIXME: only using internal SUPBOOK record
         $header = pack("vv", $record, $length);
         $data   = pack('v', $totalReferences);
         for ($i = 0; $i < $totalReferences; ++$i) {
@@ -983,12 +983,12 @@ 
      */
     private function writeStyle()
     {
-        $record = 0x0293;   // Record identifier
-        $length = 0x0004;   // Bytes to follow
+        $record = 0x0293; // Record identifier
+        $length = 0x0004; // Bytes to follow
 
-        $ixfe    = 0x8000;  // Index to cell style XF
-        $BuiltIn = 0x00;     // Built-in style
-        $iLevel  = 0xff;     // Outline style level
+        $ixfe    = 0x8000; // Index to cell style XF
+        $BuiltIn = 0x00; // Built-in style
+        $iLevel  = 0xff; // Outline style level
 
         $header = pack("vv", $record, $length);
         $data   = pack("vCC", $ixfe, $BuiltIn, $iLevel);
@@ -1003,14 +1003,14 @@ 
      */
     private function writeNumberFormat($format, $ifmt)
     {
-        $record = 0x041E;    // Record identifier
+        $record = 0x041E; // Record identifier
 
         $numberFormatString = \PHPExcel\Shared\StringHelper::UTF8toBIFF8UnicodeLong($format);
-        $length = 2 + strlen($numberFormatString);    // Number of bytes to follow
+        $length = 2 + strlen($numberFormatString); // Number of bytes to follow
 
 
         $header = pack("vv", $record, $length);
-        $data   = pack("v", $ifmt) .  $numberFormatString;
+        $data   = pack("v", $ifmt) . $numberFormatString;
         $this->append($header . $data);
     }
 
@@ -1019,12 +1019,12 @@ 
      */
     private function writeDateMode()
     {
-        $record = 0x0022;   // Record identifier
-        $length = 0x0002;   // Bytes to follow
+        $record = 0x0022; // Record identifier
+        $length = 0x0002; // Bytes to follow
 
         $f1904  = (\PHPExcel\Shared\Date::getExcelCalendar() == \PHPExcel\Shared\Date::CALENDAR_MAC_1904)
             ? 1
-            : 0;   // Flag for 1904 date system
+            : 0; // Flag for 1904 date system
 
         $header = pack("vv", $record, $length);
         $data   = pack("v", $f1904);
@@ -1045,8 +1045,8 @@ 
      */
     private function writeExternalCount($cxals)
     {
-        $record = 0x0016;   // Record identifier
-        $length = 0x0002;   // Number of bytes to follow
+        $record = 0x0016; // Record identifier
+        $length = 0x0002; // Number of bytes to follow
 
         $header = pack("vv", $record, $length);
         $data   = pack("v", $cxals);
@@ -1064,11 +1064,11 @@ 
      */
     private function writeExternalSheet($sheetname)
     {
-        $record = 0x0017;                     // Record identifier
-        $length = 0x02 + strlen($sheetname);  // Number of bytes to follow
+        $record = 0x0017; // Record identifier
+        $length = 0x02 + strlen($sheetname); // Number of bytes to follow
 
-        $cch    = strlen($sheetname);         // Length of sheet name
-        $rgch   = 0x03;                       // Filename encoding
+        $cch    = strlen($sheetname); // Length of sheet name
+        $rgch   = 0x03; // Filename encoding
 
         $header = pack("vv", $record, $length);
         $data   = pack("CC", $cch, $rgch);
@@ -1088,20 +1088,20 @@ 
      */
     private function writeNameShort($index, $type, $rowmin, $rowmax, $colmin, $colmax)
     {
-        $record = 0x0018;       // Record identifier
-        $length = 0x0024;       // Number of bytes to follow
-
-        $grbit  = 0x0020;       // Option flags
-        $chKey  = 0x00;         // Keyboard shortcut
-        $cch    = 0x01;         // Length of text name
-        $cce    = 0x0015;       // Length of text definition
-        $ixals  = $index + 1;   // Sheet index
-        $itab   = $ixals;       // Equal to ixals
-        $cchCustMenu    = 0x00;         // Length of cust menu text
-        $cchDescription = 0x00;         // Length of description text
-        $cchHelptopic   = 0x00;         // Length of help topic text
-        $cchStatustext  = 0x00;         // Length of status bar text
-        $rgch           = $type;        // Built-in name type
+        $record = 0x0018; // Record identifier
+        $length = 0x0024; // Number of bytes to follow
+
+        $grbit  = 0x0020; // Option flags
+        $chKey  = 0x00; // Keyboard shortcut
+        $cch    = 0x01; // Length of text name
+        $cce    = 0x0015; // Length of text definition
+        $ixals  = $index + 1; // Sheet index
+        $itab   = $ixals; // Equal to ixals
+        $cchCustMenu    = 0x00; // Length of cust menu text
+        $cchDescription = 0x00; // Length of description text
+        $cchHelptopic   = 0x00; // Length of help topic text
+        $cchStatustext  = 0x00; // Length of status bar text
+        $rgch           = $type; // Built-in name type
 
         $unknown03 = 0x3b;
         $unknown04 = 0xffff - $index;
@@ -1152,24 +1152,24 @@ 
      */
     private function writeNameLong($index, $type, $rowmin, $rowmax, $colmin, $colmax)
     {
-        $record          = 0x0018;       // Record identifier
-        $length          = 0x003d;       // Number of bytes to follow
-        $grbit           = 0x0020;       // Option flags
-        $chKey           = 0x00;         // Keyboard shortcut
-        $cch             = 0x01;         // Length of text name
-        $cce             = 0x002e;       // Length of text definition
-        $ixals           = $index + 1;   // Sheet index
-        $itab            = $ixals;       // Equal to ixals
-        $cchCustMenu     = 0x00;         // Length of cust menu text
-        $cchDescription  = 0x00;         // Length of description text
-        $cchHelptopic    = 0x00;         // Length of help topic text
-        $cchStatustext   = 0x00;         // Length of status bar text
-        $rgch            = $type;        // Built-in name type
+        $record          = 0x0018; // Record identifier
+        $length          = 0x003d; // Number of bytes to follow
+        $grbit           = 0x0020; // Option flags
+        $chKey           = 0x00; // Keyboard shortcut
+        $cch             = 0x01; // Length of text name
+        $cce             = 0x002e; // Length of text definition
+        $ixals           = $index + 1; // Sheet index
+        $itab            = $ixals; // Equal to ixals
+        $cchCustMenu     = 0x00; // Length of cust menu text
+        $cchDescription  = 0x00; // Length of description text
+        $cchHelptopic    = 0x00; // Length of help topic text
+        $cchStatustext   = 0x00; // Length of status bar text
+        $rgch            = $type; // Built-in name type
 
         $unknown01       = 0x29;
         $unknown02       = 0x002b;
         $unknown03       = 0x3b;
-        $unknown04       = 0xffff-$index;
+        $unknown04       = 0xffff - $index;
         $unknown05       = 0x0000;
         $unknown06       = 0x0000;
         $unknown07       = 0x1087;
@@ -1227,8 +1227,8 @@ 
      */
     private function writeCountry()
     {
-        $record = 0x008C;    // Record identifier
-        $length = 4;         // Number of bytes to follow
+        $record = 0x008C; // Record identifier
+        $length = 4; // Number of bytes to follow
 
         $header = pack('vv', $record, $length);
         /* using the same country code always for simplicity */
@@ -1244,8 +1244,8 @@ 
      */
     private function writeRecalcId()
     {
-        $record = 0x01C1;    // Record identifier
-        $length = 8;         // Number of bytes to follow
+        $record = 0x01C1; // Record identifier
+        $length = 8; // Number of bytes to follow
 
         $header = pack('vv', $record, $length);
 
@@ -1262,10 +1262,10 @@ 
     {
         $aref = $this->palette;
 
-        $record = 0x0092;                // Record identifier
-        $length = 2 + 4 * count($aref);  // Number of bytes to follow
-        $ccv    = count($aref);          // Number of RGB values to follow
-        $data = '';                      // The RGB data
+        $record = 0x0092; // Record identifier
+        $length = 2 + 4 * count($aref); // Number of bytes to follow
+        $ccv    = count($aref); // Number of RGB values to follow
+        $data = ''; // The RGB data
 
         // Pack the RGB data
         foreach ($aref as $color) {

src/PhpSpreadsheet/Writer/Excel5/Worksheet.php

Doc Comments +10 added lines, -8 removed lines

@@ -200,10 +200,12 @@ 
      * @param int        &$str_unique    Total number of unique strings
      * @param array        &$str_table        String Table
      * @param array        &$colors        Colour Table
-     * @param mixed        $parser            The formula parser created for the Workbook
+     * @param Parser        $parser            The formula parser created for the Workbook
      * @param boolean    $preCalculateFormulas    Flag indicating whether formulas should be calculated or just written
      * @param string    $phpSheet        The worksheet to write
      * @param \PHPExcel\Worksheet $phpSheet
+     * @param integer $str_total
+     * @param integer $str_unique
      */
     public function __construct(&$str_total, &$str_unique, &$str_table, &$colors, $parser, $preCalculateFormulas, $phpSheet)
     {
@@ -614,7 +616,7 @@ 
      * @param integer $row    Zero indexed row
      * @param integer $col    Zero indexed column
      * @param float   $num    The number to write
-     * @param mixed   $xfIndex The optional XF format
+     * @param integer   $xfIndex The optional XF format
      * @return integer
      */
     private function writeNumber($row, $col, $num, $xfIndex)
@@ -652,7 +654,7 @@ 
      * @param int $row Row index (0-based)
      * @param int $col Column index (0-based)
      * @param string $str The string
-     * @param mixed   $xfIndex The XF format index for the cell
+     * @param integer   $xfIndex The XF format index for the cell
      * @param array $arrcRun Index to Font record and characters beginning
      */
     private function writeRichTextString($row, $col, $str, $xfIndex, $arrcRun)
@@ -720,7 +722,7 @@ 
      * @param integer $row    Zero indexed row
      * @param integer $col    Zero indexed column
      * @param string  $str    The string to write
-     * @param mixed   $xfIndex The XF format index for the cell
+     * @param integer   $xfIndex The XF format index for the cell
      * @return integer
      */
     private function writeLabelSst($row, $col, $str, $xfIndex)
@@ -785,7 +787,7 @@ 
      *
      * @param integer $row    Zero indexed row
      * @param integer $col    Zero indexed column
-     * @param mixed   $xfIndex The XF format index
+     * @param integer   $xfIndex The XF format index
      */
     public function writeBlank($row, $col, $xfIndex)
     {
@@ -830,7 +832,7 @@ 
      * @param integer $row     Zero indexed row
      * @param integer $col     Zero indexed column
      * @param string  $formula The formula text string
-     * @param mixed   $xfIndex  The XF format index
+     * @param integer   $xfIndex  The XF format index
      * @param mixed   $calculatedValue  Calculated value
      * @return integer
      */
@@ -2307,8 +2309,8 @@ 
      * @param mixed   $bitmap  The bitmap filename or GD-image resource
      * @param integer $x       The horizontal position (offset) of the image inside the cell.
      * @param integer $y       The vertical position (offset) of the image inside the cell.
-     * @param float   $scale_x The horizontal scale
-     * @param float   $scale_y The vertical scale
+     * @param integer   $scale_x The horizontal scale
+     * @param integer   $scale_y The vertical scale
      */
     public function insertBitmap($row, $col, $bitmap, $x = 0, $y = 0, $scale_x = 1, $scale_y = 1)
     {

Indentation +12 added lines, -12 removed lines

@@ -1019,8 +1019,8 @@ 
 
         // Write the packed data
         $this->append($header . $data .
-                       $unknown1 . $options .
-                       $unknown2 . $url_len . $url);
+                        $unknown1 . $options .
+                        $unknown2 . $url_len . $url);
         return 0;
     }
 
@@ -1068,8 +1068,8 @@ 
 
         // Write the packed data
         $this->append($header . $data .
-                       $unknown1 . $options .
-                       $url_len . $url);
+                        $unknown1 . $options .
+                        $url_len . $url);
         return 0;
     }
 
@@ -1151,14 +1151,14 @@ 
 
         // Pack the main data stream
         $data        = pack("vvvv", $row1, $row2, $col1, $col2) .
-                          $unknown1     .
-                          $link_type    .
-                          $unknown2     .
-                          $up_count     .
-                          $dir_short_len.
-                          $dir_short    .
-                          $unknown3     .
-                          $stream_len   ;/*.
+                            $unknown1     .
+                            $link_type    .
+                            $unknown2     .
+                            $up_count     .
+                            $dir_short_len.
+                            $dir_short    .
+                            $unknown3     .
+                            $stream_len   ;/*.
                           $dir_long_len .
                           $unknown4     .
                           $dir_long     .

Spacing +327 added lines, -327 removed lines

@@ -216,7 +216,7 @@ 
 
         $this->_preCalculateFormulas = $preCalculateFormulas;
         $this->stringTotal        = &$str_total;
-        $this->stringUnique        = &$str_unique;
+        $this->stringUnique = &$str_unique;
         $this->stringTable        = &$str_table;
         $this->colors            = &$colors;
         $this->parser            = $parser;
@@ -227,7 +227,7 @@ 
         //$this->offset            = 0;
         $this->xlsStringMaxLength = 255;
         $this->columnInfo  = array();
-        $this->selection   = array(0,0,0,0);
+        $this->selection   = array(0, 0, 0, 0);
         $this->activePane  = 3;
 
         $this->_print_headers = 0;
@@ -243,12 +243,12 @@ 
         $minR = 1;
         $minC = 'A';
 
-        $maxR  = $this->phpSheet->getHighestRow();
+        $maxR = $this->phpSheet->getHighestRow();
         $maxC = $this->phpSheet->getHighestColumn();
 
         // Determine lowest and highest column and row
 //        $this->firstRowIndex = ($minR > 65535) ? 65535 : $minR;
-        $this->lastRowIndex = ($maxR > 65535) ? 65535 : $maxR ;
+        $this->lastRowIndex = ($maxR > 65535) ? 65535 : $maxR;
 
         $this->firstColumnIndex = \PHPExcel\Cell::columnIndexFromString($minC);
         $this->lastColumnIndex  = \PHPExcel\Cell::columnIndexFromString($maxC);
@@ -295,7 +295,7 @@ 
         }
 
         $columnDimensions = $phpSheet->getColumnDimensions();
-        $maxCol = $this->lastColumnIndex -1;
+        $maxCol = $this->lastColumnIndex - 1;
         for ($i = 0; $i <= $maxCol; ++$i) {
             $hidden = 0;
             $level = 0;
@@ -545,7 +545,7 @@ 
         }
 
         $firstCellCoordinates = \PHPExcel\Cell::coordinateFromString($firstCell); // e.g. array(0, 1)
-        $lastCellCoordinates  = \PHPExcel\Cell::coordinateFromString($lastCell);  // e.g. array(1, 6)
+        $lastCellCoordinates  = \PHPExcel\Cell::coordinateFromString($lastCell); // e.g. array(1, 6)
 
         return pack('vvvv', $firstCellCoordinates[1] - 1, $lastCellCoordinates[1] - 1, \PHPExcel\Cell::columnIndexFromString($firstCellCoordinates[0]) - 1, \PHPExcel\Cell::columnIndexFromString($lastCellCoordinates[0]) - 1);
     }
@@ -562,7 +562,7 @@ 
 
         // Return data stored in memory
         if (isset($this->_data)) {
-            $tmp   = $this->_data;
+            $tmp = $this->_data;
             unset($this->_data);
             return $tmp;
         }
@@ -619,17 +619,17 @@ 
      */
     private function writeNumber($row, $col, $num, $xfIndex)
     {
-        $record    = 0x0203;                 // Record identifier
-        $length    = 0x000E;                 // Number of bytes to follow
+        $record    = 0x0203; // Record identifier
+        $length    = 0x000E; // Number of bytes to follow
 
-        $header        = pack("vv", $record, $length);
-        $data        = pack("vvv", $row, $col, $xfIndex);
-        $xl_double    = pack("d", $num);
+        $header = pack("vv", $record, $length);
+        $data = pack("vvv", $row, $col, $xfIndex);
+        $xl_double = pack("d", $num);
         if (self::getByteOrder()) { // if it's Big Endian
             $xl_double = strrev($xl_double);
         }
 
-        $this->append($header.$data.$xl_double);
+        $this->append($header . $data . $xl_double);
         return(0);
     }
 
@@ -657,8 +657,8 @@ 
      */
     private function writeRichTextString($row, $col, $str, $xfIndex, $arrcRun)
     {
-        $record    = 0x00FD;                   // Record identifier
-        $length    = 0x000A;                   // Bytes to follow
+        $record    = 0x00FD; // Record identifier
+        $length    = 0x000A; // Bytes to follow
         $str = \PHPExcel\Shared\StringHelper::UTF8toBIFF8UnicodeShort($str, $arrcRun);
 
         /* check if string is already present */
@@ -667,9 +667,9 @@ 
         }
         $this->stringTotal++;
 
-        $header    = pack('vv', $record, $length);
-        $data    = pack('vvvV', $row, $col, $xfIndex, $this->stringTable[$str]);
-        $this->append($header.$data);
+        $header = pack('vv', $record, $length);
+        $data = pack('vvvV', $row, $col, $xfIndex, $this->stringTable[$str]);
+        $this->append($header . $data);
     }
 
     /**
@@ -690,20 +690,20 @@ 
     private function writeLabel($row, $col, $str, $xfIndex)
     {
         $strlen    = strlen($str);
-        $record    = 0x0204;                   // Record identifier
-        $length    = 0x0008 + $strlen;         // Bytes to follow
+        $record    = 0x0204; // Record identifier
+        $length    = 0x0008 + $strlen; // Bytes to follow
 
         $str_error = 0;
 
         if ($strlen > $this->xlsStringMaxLength) { // LABEL must be < 255 chars
-            $str    = substr($str, 0, $this->xlsStringMaxLength);
+            $str = substr($str, 0, $this->xlsStringMaxLength);
             $length    = 0x0008 + $this->xlsStringMaxLength;
             $strlen    = $this->xlsStringMaxLength;
             $str_error = -3;
         }
 
-        $header    = pack("vv", $record, $length);
-        $data    = pack("vvvv", $row, $col, $xfIndex, $strlen);
+        $header = pack("vv", $record, $length);
+        $data = pack("vvvv", $row, $col, $xfIndex, $strlen);
         $this->append($header . $data . $str);
         return($str_error);
     }
@@ -725,8 +725,8 @@ 
      */
     private function writeLabelSst($row, $col, $str, $xfIndex)
     {
-        $record    = 0x00FD;                   // Record identifier
-        $length    = 0x000A;                   // Bytes to follow
+        $record    = 0x00FD; // Record identifier
+        $length    = 0x000A; // Bytes to follow
 
         $str = \PHPExcel\Shared\StringHelper::UTF8toBIFF8UnicodeLong($str);
 
@@ -736,9 +736,9 @@ 
         }
         $this->stringTotal++;
 
-        $header    = pack('vv', $record, $length);
-        $data    = pack('vvvV', $row, $col, $xfIndex, $this->stringTable[$str]);
-        $this->append($header.$data);
+        $header = pack('vv', $record, $length);
+        $data = pack('vvvV', $row, $col, $xfIndex, $this->stringTable[$str]);
+        $this->append($header . $data);
     }
 
     /**
@@ -751,14 +751,14 @@ 
      */
     private function writeNote($row, $col, $note)
     {
-        $note_length    = strlen($note);
-        $record            = 0x001C;            // Record identifier
-        $max_length        = 2048;                // Maximun length for a NOTE record
+        $note_length = strlen($note);
+        $record            = 0x001C; // Record identifier
+        $max_length        = 2048; // Maximun length for a NOTE record
 
         // Length for this record is no more than 2048 + 6
         $length    = 0x0006 + min($note_length, 2048);
         $header    = pack("vv", $record, $length);
-        $data    = pack("vvv", $row, $col, $note_length);
+        $data = pack("vvv", $row, $col, $note_length);
         $this->append($header . $data . substr($note, 0, 2048));
 
         for ($i = $max_length; $i < $note_length; $i += $max_length) {
@@ -766,7 +766,7 @@ 
             $length = 0x0006 + strlen($chunk);
             $header = pack("vv", $record, $length);
             $data   = pack("vvv", -1, 0, strlen($chunk));
-            $this->append($header.$data.$chunk);
+            $this->append($header . $data . $chunk);
         }
         return(0);
     }
@@ -789,8 +789,8 @@ 
      */
     public function writeBlank($row, $col, $xfIndex)
     {
-        $record    = 0x0201;                 // Record identifier
-        $length    = 0x0006;                 // Number of bytes to follow
+        $record    = 0x0201; // Record identifier
+        $length    = 0x0006; // Number of bytes to follow
 
         $header    = pack("vv", $record, $length);
         $data      = pack("vvv", $row, $col, $xfIndex);
@@ -836,7 +836,7 @@ 
      */
     private function writeFormula($row, $col, $formula, $xfIndex, $calculatedValue)
     {
-        $record    = 0x0006;     // Record identifier
+        $record = 0x0006; // Record identifier
 
         // Initialize possible additional value for STRING record that should be written after the FORMULA record?
         $stringValue = null;
@@ -847,7 +847,7 @@ 
             // we use best effort to determine data type
             if (is_bool($calculatedValue)) {
                 // Boolean value
-                $num = pack('CCCvCv', 0x01, 0x00, (int)$calculatedValue, 0x00, 0x00, 0xFFFF);
+                $num = pack('CCCvCv', 0x01, 0x00, (int) $calculatedValue, 0x00, 0x00, 0xFFFF);
             } elseif (is_int($calculatedValue) || is_float($calculatedValue)) {
                 // Numeric value
                 $num = pack('d', $calculatedValue);
@@ -871,8 +871,8 @@ 
             $num = pack('d', 0x00);
         }
 
-        $grbit        = 0x03;                // Option flags
-        $unknown    = 0x0000;            // Must be zero
+        $grbit = 0x03; // Option flags
+        $unknown = 0x0000; // Must be zero
 
         // Strip the '=' or '@' sign at the beginning of the formula string
         if ($formula{0} == '=') {
@@ -888,8 +888,8 @@ 
             $error = $this->parser->parse($formula);
             $formula = $this->parser->toReversePolish();
 
-            $formlen    = strlen($formula);    // Length of the binary string
-            $length     = 0x16 + $formlen;     // Length of the record data
+            $formlen    = strlen($formula); // Length of the binary string
+            $length     = 0x16 + $formlen; // Length of the record data
 
             $header    = pack("vv", $record, $length);
 
@@ -915,7 +915,7 @@ 
      */
     private function writeStringRecord($stringValue)
     {
-        $record = 0x0207;     // Record identifier
+        $record = 0x0207; // Record identifier
         $data = \PHPExcel\Shared\StringHelper::UTF8toBIFF8UnicodeLong($stringValue);
 
         $length = strlen($data);
@@ -993,8 +993,8 @@ 
      */
     public function writeUrlWeb($row1, $col1, $row2, $col2, $url)
     {
-        $record      = 0x01B8;                       // Record identifier
-        $length      = 0x00000;                      // Bytes to follow
+        $record      = 0x01B8; // Record identifier
+        $length      = 0x00000; // Bytes to follow
 
         // Pack the undocumented parts of the hyperlink stream
         $unknown1    = pack("H*", "D0C9EA79F9BACE118C8200AA004BA90B02000000");
@@ -1038,8 +1038,8 @@ 
      */
     public function writeUrlInternal($row1, $col1, $row2, $col2, $url)
     {
-        $record      = 0x01B8;                       // Record identifier
-        $length      = 0x00000;                      // Bytes to follow
+        $record      = 0x01B8; // Record identifier
+        $length      = 0x00000; // Bytes to follow
 
         // Strip URL type
         $url = preg_replace('/^internal:/', '', $url);
@@ -1097,8 +1097,8 @@ 
             return; //($this->writeUrlExternal_net($row1, $col1, $row2, $col2, $url, $str, $format));
         }
 
-        $record      = 0x01B8;                       // Record identifier
-        $length      = 0x00000;                      // Bytes to follow
+        $record      = 0x01B8; // Record identifier
+        $length      = 0x00000; // Bytes to follow
 
         // Strip URL type and change Unix dir separator to Dos style (if needed)
         //
@@ -1114,7 +1114,7 @@ 
         if (preg_match('/^[A-Z]:/', $url)) {
             $absolute = 0x02; // absolute path on Windows, e.g. C:\...
         }
-        $link_type               = 0x01 | $absolute;
+        $link_type = 0x01 | $absolute;
 
         // Determine if the link contains a sheet reference and change some of the
         // parameters accordingly.
@@ -1136,7 +1136,7 @@ 
         $dir_short   = preg_replace("/\.\.\\\/", '', $dir_long) . "\0";
 
         // Store the long dir name as a wchar string (non-null terminated)
-        $dir_long       = $dir_long . "\0";
+        $dir_long = $dir_long . "\0";
 
         // Pack the lengths of the dir strings
         $dir_short_len = pack("V", strlen($dir_short));
@@ -1150,15 +1150,15 @@ 
         $unknown4 = pack("v", 0x03);
 
         // Pack the main data stream
-        $data        = pack("vvvv", $row1, $row2, $col1, $col2) .
-                          $unknown1     .
-                          $link_type    .
-                          $unknown2     .
-                          $up_count     .
-                          $dir_short_len.
-                          $dir_short    .
-                          $unknown3     .
-                          $stream_len   ;/*.
+        $data = pack("vvvv", $row1, $row2, $col1, $col2) .
+                          $unknown1 .
+                          $link_type .
+                          $unknown2 .
+                          $up_count .
+                          $dir_short_len .
+                          $dir_short .
+                          $unknown3 .
+                          $stream_len; /*.
                           $dir_long_len .
                           $unknown4     .
                           $dir_long     .
@@ -1170,7 +1170,7 @@ 
         $header   = pack("vv", $record, $length);
 
         // Write the packed data
-        $this->append($header. $data);
+        $this->append($header . $data);
         return 0;
     }
 
@@ -1186,14 +1186,14 @@ 
      */
     private function writeRow($row, $height, $xfIndex, $hidden = false, $level = 0)
     {
-        $record      = 0x0208;               // Record identifier
-        $length      = 0x0010;               // Number of bytes to follow
-
-        $colMic      = 0x0000;               // First defined column
-        $colMac      = 0x0000;               // Last defined column
-        $irwMac      = 0x0000;               // Used by Excel to optimise loading
-        $reserved    = 0x0000;               // Reserved
-        $grbit       = 0x0000;               // Option flags
+        $record      = 0x0208; // Record identifier
+        $length      = 0x0010; // Number of bytes to follow
+
+        $colMic      = 0x0000; // First defined column
+        $colMac      = 0x0000; // Last defined column
+        $irwMac      = 0x0000; // Used by Excel to optimise loading
+        $reserved    = 0x0000; // Reserved
+        $grbit       = 0x0000; // Option flags
         $ixfe        = $xfIndex;
 
         if ($height < 0) {
@@ -1202,9 +1202,9 @@ 
 
         // Use writeRow($row, null, $XF) to set XF format without setting height
         if ($height != null) {
-            $miyRw = $height * 20;  // row height
+            $miyRw = $height * 20; // row height
         } else {
-            $miyRw = 0xff;          // default row height is 256
+            $miyRw = 0xff; // default row height is 256
         }
 
         // Set the options flags. fUnsynced is used to show that the font and row
@@ -1227,7 +1227,7 @@ 
 
         $header   = pack("vv", $record, $length);
         $data     = pack("vvvvvvvv", $row, $colMic, $colMac, $miyRw, $irwMac, $reserved, $grbit, $ixfe);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1241,7 +1241,7 @@ 
         $data = pack('VVvvv', $this->firstRowIndex, $this->lastRowIndex + 1, $this->firstColumnIndex, $this->lastColumnIndex + 1, 0x0000); // reserved
 
         $header = pack("vv", $record, $length);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1249,53 +1249,53 @@ 
      */
     private function writeWindow2()
     {
-        $record         = 0x023E;     // Record identifier
+        $record         = 0x023E; // Record identifier
         $length         = 0x0012;
 
-        $grbit          = 0x00B6;     // Option flags
-        $rwTop          = 0x0000;     // Top row visible in window
-        $colLeft        = 0x0000;     // Leftmost column visible in window
+        $grbit          = 0x00B6; // Option flags
+        $rwTop          = 0x0000; // Top row visible in window
+        $colLeft        = 0x0000; // Leftmost column visible in window
 
 
         // The options flags that comprise $grbit
-        $fDspFmla       = 0;                     // 0 - bit
+        $fDspFmla       = 0; // 0 - bit
         $fDspGrid       = $this->phpSheet->getShowGridlines() ? 1 : 0; // 1
         $fDspRwCol      = $this->phpSheet->getShowRowColHeaders() ? 1 : 0; // 2
-        $fFrozen        = $this->phpSheet->getFreezePane() ? 1 : 0;        // 3
-        $fDspZeros      = 1;                     // 4
-        $fDefaultHdr    = 1;                     // 5
+        $fFrozen        = $this->phpSheet->getFreezePane() ? 1 : 0; // 3
+        $fDspZeros      = 1; // 4
+        $fDefaultHdr    = 1; // 5
         $fArabic        = $this->phpSheet->getRightToLeft() ? 1 : 0; // 6
-        $fDspGuts       = $this->outlineOn;    // 7
-        $fFrozenNoSplit = 0;                     // 0 - bit
+        $fDspGuts       = $this->outlineOn; // 7
+        $fFrozenNoSplit = 0; // 0 - bit
         // no support in PHPExcel for selected sheet, therefore sheet is only selected if it is the active sheet
         $fSelected      = ($this->phpSheet === $this->phpSheet->getParent()->getActiveSheet()) ? 1 : 0;
-        $fPaged         = 1;                     // 2
+        $fPaged         = 1; // 2
         $fPageBreakPreview = $this->phpSheet->getSheetView()->getView() === \PHPExcel\Worksheet\SheetView::SHEETVIEW_PAGE_BREAK_PREVIEW;
 
         $grbit             = $fDspFmla;
-        $grbit            |= $fDspGrid       << 1;
-        $grbit            |= $fDspRwCol       << 2;
-        $grbit            |= $fFrozen           << 3;
-        $grbit            |= $fDspZeros       << 4;
-        $grbit            |= $fDefaultHdr       << 5;
-        $grbit            |= $fArabic           << 6;
-        $grbit            |= $fDspGuts       << 7;
+        $grbit            |= $fDspGrid << 1;
+        $grbit            |= $fDspRwCol << 2;
+        $grbit            |= $fFrozen << 3;
+        $grbit            |= $fDspZeros << 4;
+        $grbit            |= $fDefaultHdr << 5;
+        $grbit            |= $fArabic << 6;
+        $grbit            |= $fDspGuts << 7;
         $grbit            |= $fFrozenNoSplit << 8;
-        $grbit            |= $fSelected       << 9;
-        $grbit            |= $fPaged           << 10;
+        $grbit            |= $fSelected << 9;
+        $grbit            |= $fPaged << 10;
         $grbit            |= $fPageBreakPreview << 11;
 
         $header  = pack("vv", $record, $length);
         $data    = pack("vvv", $grbit, $rwTop, $colLeft);
 
         // FIXME !!!
-        $rgbHdr       = 0x0040; // Row/column heading and gridline color index
+        $rgbHdr = 0x0040; // Row/column heading and gridline color index
         $zoom_factor_page_break = ($fPageBreakPreview ? $this->phpSheet->getSheetView()->getZoomScale() : 0x0000);
-        $zoom_factor_normal =  $this->phpSheet->getSheetView()->getZoomScaleNormal();
+        $zoom_factor_normal = $this->phpSheet->getSheetView()->getZoomScaleNormal();
 
         $data .= pack("vvvvV", $rgbHdr, 0x0000, $zoom_factor_page_break, $zoom_factor_normal, 0x00000000);
 
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1312,8 +1312,8 @@ 
         // convert to twips
         $defaultRowHeight = (int) 20 * $defaultRowHeight;
 
-        $record   = 0x0225;      // Record identifier
-        $length   = 0x0004;      // Number of bytes to follow
+        $record   = 0x0225; // Record identifier
+        $length   = 0x0004; // Number of bytes to follow
 
         $header   = pack("vv", $record, $length);
         $data     = pack("vv", 1, $defaultRowHeight);
@@ -1327,8 +1327,8 @@ 
     {
         $defaultColWidth = 8;
 
-        $record   = 0x0055;      // Record identifier
-        $length   = 0x0002;      // Number of bytes to follow
+        $record   = 0x0055; // Record identifier
+        $length   = 0x0002; // Number of bytes to follow
 
         $header = pack("vv", $record, $length);
         $data = pack("v", $defaultColWidth);
@@ -1377,20 +1377,20 @@ 
         } else {
             $level = 0;
         }
-        $record   = 0x007D;          // Record identifier
-        $length   = 0x000C;          // Number of bytes to follow
+        $record   = 0x007D; // Record identifier
+        $length   = 0x000C; // Number of bytes to follow
 
-        $coldx   *= 256;             // Convert to units of 1/256 of a char
+        $coldx   *= 256; // Convert to units of 1/256 of a char
 
         $ixfe     = $xfIndex;
-        $reserved = 0x0000;            // Reserved
+        $reserved = 0x0000; // Reserved
 
         $level = max(0, min($level, 7));
         $grbit |= $level << 8;
 
         $header   = pack("vv", $record, $length);
         $data     = pack("vvvvvv", $colFirst, $colLast, $coldx, $ixfe, $grbit, $reserved);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1424,20 +1424,20 @@ 
         $rwFirst = min($rwFirst, 65535);
         $rwLast  = min($rwLast, 65535);
 
-        $record   = 0x001D;                  // Record identifier
-        $length   = 0x000F;                  // Number of bytes to follow
+        $record   = 0x001D; // Record identifier
+        $length   = 0x000F; // Number of bytes to follow
 
-        $pnn      = $this->activePane;     // Pane position
-        $rwAct    = $rwFirst;                // Active row
-        $colAct   = $colFirst;               // Active column
-        $irefAct  = 0;                       // Active cell ref
-        $cref     = 1;                       // Number of refs
+        $pnn      = $this->activePane; // Pane position
+        $rwAct    = $rwFirst; // Active row
+        $colAct   = $colFirst; // Active column
+        $irefAct  = 0; // Active cell ref
+        $cref     = 1; // Number of refs
 
         if (!isset($rwLast)) {
-            $rwLast   = $rwFirst;       // Last  row in reference
+            $rwLast   = $rwFirst; // Last  row in reference
         }
         if (!isset($colLast)) {
-            $colLast  = $colFirst;      // Last  col in reference
+            $colLast  = $colFirst; // Last  col in reference
         }
 
         // Swap last row/col for first row/col as necessary
@@ -1544,21 +1544,21 @@ 
         $record = 0x0867;
 
         // prepare options
-        $options  =   (int) !$this->phpSheet->getProtection()->getObjects()
-                    | (int) !$this->phpSheet->getProtection()->getScenarios()           << 1
-                    | (int) !$this->phpSheet->getProtection()->getFormatCells()         << 2
-                    | (int) !$this->phpSheet->getProtection()->getFormatColumns()       << 3
-                    | (int) !$this->phpSheet->getProtection()->getFormatRows()          << 4
-                    | (int) !$this->phpSheet->getProtection()->getInsertColumns()       << 5
-                    | (int) !$this->phpSheet->getProtection()->getInsertRows()          << 6
-                    | (int) !$this->phpSheet->getProtection()->getInsertHyperlinks()    << 7
-                    | (int) !$this->phpSheet->getProtection()->getDeleteColumns()       << 8
-                    | (int) !$this->phpSheet->getProtection()->getDeleteRows()          << 9
-                    | (int) !$this->phpSheet->getProtection()->getSelectLockedCells()   << 10
-                    | (int) !$this->phpSheet->getProtection()->getSort()                << 11
-                    | (int) !$this->phpSheet->getProtection()->getAutoFilter()          << 12
-                    | (int) !$this->phpSheet->getProtection()->getPivotTables()         << 13
-                    | (int) !$this->phpSheet->getProtection()->getSelectUnlockedCells() << 14 ;
+        $options = (int) !$this->phpSheet->getProtection()->getObjects()
+                    | (int) !$this->phpSheet->getProtection()->getScenarios() << 1
+                    | (int) !$this->phpSheet->getProtection()->getFormatCells() << 2
+                    | (int) !$this->phpSheet->getProtection()->getFormatColumns() << 3
+                    | (int) !$this->phpSheet->getProtection()->getFormatRows() << 4
+                    | (int) !$this->phpSheet->getProtection()->getInsertColumns() << 5
+                    | (int) !$this->phpSheet->getProtection()->getInsertRows() << 6
+                    | (int) !$this->phpSheet->getProtection()->getInsertHyperlinks() << 7
+                    | (int) !$this->phpSheet->getProtection()->getDeleteColumns() << 8
+                    | (int) !$this->phpSheet->getProtection()->getDeleteRows() << 9
+                    | (int) !$this->phpSheet->getProtection()->getSelectLockedCells() << 10
+                    | (int) !$this->phpSheet->getProtection()->getSort() << 11
+                    | (int) !$this->phpSheet->getProtection()->getAutoFilter() << 12
+                    | (int) !$this->phpSheet->getProtection()->getPivotTables() << 13
+                    | (int) !$this->phpSheet->getProtection()->getSelectUnlockedCells() << 14;
 
         // record data
         $recordData = pack(
@@ -1621,7 +1621,7 @@ 
 
             $length = strlen($recordData);
 
-            $record = 0x0868;        // Record identifier
+            $record = 0x0868; // Record identifier
             $header = pack("vv", $record, $length);
             $this->append($header . $recordData);
         }
@@ -1641,8 +1641,8 @@ 
      */
     private function writeExterncount($count)
     {
-        $record = 0x0016;          // Record identifier
-        $length = 0x0002;          // Number of bytes to follow
+        $record = 0x0016; // Record identifier
+        $length = 0x0002; // Number of bytes to follow
 
         $header = pack("vv", $record, $length);
         $data   = pack("v", $count);
@@ -1659,20 +1659,20 @@ 
      */
     private function writeExternsheet($sheetname)
     {
-        $record    = 0x0017;         // Record identifier
+        $record = 0x0017; // Record identifier
 
         // References to the current sheet are encoded differently to references to
         // external sheets.
         //
         if ($this->phpSheet->getTitle() == $sheetname) {
             $sheetname = '';
-            $length    = 0x02;  // The following 2 bytes
-            $cch       = 1;     // The following byte
-            $rgch      = 0x02;  // Self reference
+            $length    = 0x02; // The following 2 bytes
+            $cch       = 1; // The following byte
+            $rgch      = 0x02; // Self reference
         } else {
             $length    = 0x02 + strlen($sheetname);
             $cch       = strlen($sheetname);
-            $rgch      = 0x03;  // Reference to a sheet in the current workbook
+            $rgch      = 0x03; // Reference to a sheet in the current workbook
         }
 
         $header = pack("vv", $record, $length);
@@ -1707,8 +1707,8 @@ 
         } else {
             $pnnAct = null;
         }
-        $record  = 0x0041;       // Record identifier
-        $length  = 0x000A;       // Number of bytes to follow
+        $record  = 0x0041; // Record identifier
+        $length  = 0x000A; // Number of bytes to follow
 
         // Code specific to frozen or thawed panes.
         if ($this->phpSheet->getFreezePane()) {
@@ -1733,8 +1733,8 @@ 
             // The default column width is 8.43
             // The following slope and intersection values were interpolated.
             //
-            $y = 20*$y + 255;
-            $x = 113.879*$x + 390;
+            $y = 20 * $y + 255;
+            $x = 113.879 * $x + 390;
         }
 
 
@@ -1768,47 +1768,47 @@ 
      */
     private function writeSetup()
     {
-        $record       = 0x00A1;                  // Record identifier
-        $length       = 0x0022;                  // Number of bytes to follow
+        $record       = 0x00A1; // Record identifier
+        $length       = 0x0022; // Number of bytes to follow
 
-        $iPaperSize   = $this->phpSheet->getPageSetup()->getPaperSize();    // Paper size
+        $iPaperSize   = $this->phpSheet->getPageSetup()->getPaperSize(); // Paper size
 
         $iScale = $this->phpSheet->getPageSetup()->getScale() ?
-            $this->phpSheet->getPageSetup()->getScale() : 100;   // Print scaling factor
+            $this->phpSheet->getPageSetup()->getScale() : 100; // Print scaling factor
 
-        $iPageStart   = 0x01;                 // Starting page number
-        $iFitWidth    = (int) $this->phpSheet->getPageSetup()->getFitToWidth();    // Fit to number of pages wide
-        $iFitHeight    = (int) $this->phpSheet->getPageSetup()->getFitToHeight();    // Fit to number of pages high
-        $grbit        = 0x00;                 // Option flags
-        $iRes         = 0x0258;               // Print resolution
-        $iVRes        = 0x0258;               // Vertical print resolution
+        $iPageStart   = 0x01; // Starting page number
+        $iFitWidth    = (int) $this->phpSheet->getPageSetup()->getFitToWidth(); // Fit to number of pages wide
+        $iFitHeight = (int) $this->phpSheet->getPageSetup()->getFitToHeight(); // Fit to number of pages high
+        $grbit        = 0x00; // Option flags
+        $iRes         = 0x0258; // Print resolution
+        $iVRes        = 0x0258; // Vertical print resolution
 
-        $numHdr       = $this->phpSheet->getPageMargins()->getHeader();  // Header Margin
+        $numHdr       = $this->phpSheet->getPageMargins()->getHeader(); // Header Margin
 
-        $numFtr       = $this->phpSheet->getPageMargins()->getFooter();   // Footer Margin
-        $iCopies      = 0x01;                 // Number of copies
+        $numFtr       = $this->phpSheet->getPageMargins()->getFooter(); // Footer Margin
+        $iCopies      = 0x01; // Number of copies
 
-        $fLeftToRight = 0x0;                     // Print over then down
+        $fLeftToRight = 0x0; // Print over then down
 
         // Page orientation
         $fLandscape = ($this->phpSheet->getPageSetup()->getOrientation() == \PHPExcel\Worksheet\PageSetup::ORIENTATION_LANDSCAPE) ?
             0x0 : 0x1;
 
-        $fNoPls       = 0x0;                     // Setup not read from printer
-        $fNoColor     = 0x0;                     // Print black and white
-        $fDraft       = 0x0;                     // Print draft quality
-        $fNotes       = 0x0;                     // Print notes
-        $fNoOrient    = 0x0;                     // Orientation not set
-        $fUsePage     = 0x0;                     // Use custom starting page
+        $fNoPls       = 0x0; // Setup not read from printer
+        $fNoColor     = 0x0; // Print black and white
+        $fDraft       = 0x0; // Print draft quality
+        $fNotes       = 0x0; // Print notes
+        $fNoOrient    = 0x0; // Orientation not set
+        $fUsePage     = 0x0; // Use custom starting page
 
         $grbit           = $fLeftToRight;
-        $grbit          |= $fLandscape    << 1;
-        $grbit          |= $fNoPls        << 2;
-        $grbit          |= $fNoColor      << 3;
-        $grbit          |= $fDraft        << 4;
-        $grbit          |= $fNotes        << 5;
-        $grbit          |= $fNoOrient     << 6;
-        $grbit          |= $fUsePage      << 7;
+        $grbit          |= $fLandscape << 1;
+        $grbit          |= $fNoPls << 2;
+        $grbit          |= $fNoColor << 3;
+        $grbit          |= $fDraft << 4;
+        $grbit          |= $fNotes << 5;
+        $grbit          |= $fNoOrient << 6;
+        $grbit          |= $fUsePage << 7;
 
         $numHdr = pack("d", $numHdr);
         $numFtr = pack("d", $numFtr);
@@ -1819,7 +1819,7 @@ 
 
         $header = pack("vv", $record, $length);
         $data1  = pack("vvvvvvvv", $iPaperSize, $iScale, $iPageStart, $iFitWidth, $iFitHeight, $grbit, $iRes, $iVRes);
-        $data2  = $numHdr.$numFtr;
+        $data2  = $numHdr . $numFtr;
         $data3  = pack("v", $iCopies);
         $this->append($header . $data1 . $data2 . $data3);
     }
@@ -1829,7 +1829,7 @@ 
      */
     private function writeHeader()
     {
-        $record  = 0x0014;               // Record identifier
+        $record = 0x0014; // Record identifier
 
         /* removing for now
         // need to fix character count (multibyte!)
@@ -1843,7 +1843,7 @@ 
         $recordData = \PHPExcel\Shared\StringHelper::UTF8toBIFF8UnicodeLong($this->phpSheet->getHeaderFooter()->getOddHeader());
         $length = strlen($recordData);
 
-        $header   = pack("vv", $record, $length);
+        $header = pack("vv", $record, $length);
 
         $this->append($header . $recordData);
     }
@@ -1853,7 +1853,7 @@ 
      */
     private function writeFooter()
     {
-        $record  = 0x0015;               // Record identifier
+        $record = 0x0015; // Record identifier
 
         /* removing for now
         // need to fix character count (multibyte!)
@@ -1867,7 +1867,7 @@ 
         $recordData = \PHPExcel\Shared\StringHelper::UTF8toBIFF8UnicodeLong($this->phpSheet->getHeaderFooter()->getOddFooter());
         $length = strlen($recordData);
 
-        $header    = pack("vv", $record, $length);
+        $header = pack("vv", $record, $length);
 
         $this->append($header . $recordData);
     }
@@ -1879,15 +1879,15 @@ 
      */
     private function writeHcenter()
     {
-        $record   = 0x0083;              // Record identifier
-        $length   = 0x0002;              // Bytes to follow
+        $record   = 0x0083; // Record identifier
+        $length   = 0x0002; // Bytes to follow
 
-        $fHCenter = $this->phpSheet->getPageSetup()->getHorizontalCentered() ? 1 : 0;     // Horizontal centering
+        $fHCenter = $this->phpSheet->getPageSetup()->getHorizontalCentered() ? 1 : 0; // Horizontal centering
 
         $header    = pack("vv", $record, $length);
         $data      = pack("v", $fHCenter);
 
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -1895,10 +1895,10 @@ 
      */
     private function writeVcenter()
     {
-        $record   = 0x0084;              // Record identifier
-        $length   = 0x0002;              // Bytes to follow
+        $record   = 0x0084; // Record identifier
+        $length   = 0x0002; // Bytes to follow
 
-        $fVCenter = $this->phpSheet->getPageSetup()->getVerticalCentered() ? 1 : 0;     // Horizontal centering
+        $fVCenter = $this->phpSheet->getPageSetup()->getVerticalCentered() ? 1 : 0; // Horizontal centering
 
         $header    = pack("vv", $record, $length);
         $data      = pack("v", $fVCenter);
@@ -1910,10 +1910,10 @@ 
      */
     private function writeMarginLeft()
     {
-        $record  = 0x0026;                   // Record identifier
-        $length  = 0x0008;                   // Bytes to follow
+        $record  = 0x0026; // Record identifier
+        $length  = 0x0008; // Bytes to follow
 
-        $margin  = $this->phpSheet->getPageMargins()->getLeft();     // Margin in inches
+        $margin  = $this->phpSheet->getPageMargins()->getLeft(); // Margin in inches
 
         $header    = pack("vv", $record, $length);
         $data      = pack("d", $margin);
@@ -1929,10 +1929,10 @@ 
      */
     private function writeMarginRight()
     {
-        $record  = 0x0027;                   // Record identifier
-        $length  = 0x0008;                   // Bytes to follow
+        $record  = 0x0027; // Record identifier
+        $length  = 0x0008; // Bytes to follow
 
-        $margin  = $this->phpSheet->getPageMargins()->getRight();     // Margin in inches
+        $margin  = $this->phpSheet->getPageMargins()->getRight(); // Margin in inches
 
         $header    = pack("vv", $record, $length);
         $data      = pack("d", $margin);
@@ -1948,10 +1948,10 @@ 
      */
     private function writeMarginTop()
     {
-        $record  = 0x0028;                   // Record identifier
-        $length  = 0x0008;                   // Bytes to follow
+        $record  = 0x0028; // Record identifier
+        $length  = 0x0008; // Bytes to follow
 
-        $margin  = $this->phpSheet->getPageMargins()->getTop();     // Margin in inches
+        $margin  = $this->phpSheet->getPageMargins()->getTop(); // Margin in inches
 
         $header    = pack("vv", $record, $length);
         $data      = pack("d", $margin);
@@ -1967,10 +1967,10 @@ 
      */
     private function writeMarginBottom()
     {
-        $record  = 0x0029;                   // Record identifier
-        $length  = 0x0008;                   // Bytes to follow
+        $record  = 0x0029; // Record identifier
+        $length  = 0x0008; // Bytes to follow
 
-        $margin  = $this->phpSheet->getPageMargins()->getBottom();     // Margin in inches
+        $margin  = $this->phpSheet->getPageMargins()->getBottom(); // Margin in inches
 
         $header    = pack("vv", $record, $length);
         $data      = pack("d", $margin);
@@ -1986,10 +1986,10 @@ 
      */
     private function writePrintHeaders()
     {
-        $record      = 0x002a;                   // Record identifier
-        $length      = 0x0002;                   // Bytes to follow
+        $record      = 0x002a; // Record identifier
+        $length      = 0x0002; // Bytes to follow
 
-        $fPrintRwCol = $this->_print_headers;     // Boolean flag
+        $fPrintRwCol = $this->_print_headers; // Boolean flag
 
         $header      = pack("vv", $record, $length);
         $data        = pack("v", $fPrintRwCol);
@@ -2002,13 +2002,13 @@ 
      */
     private function writePrintGridlines()
     {
-        $record      = 0x002b;                    // Record identifier
-        $length      = 0x0002;                    // Bytes to follow
+        $record      = 0x002b; // Record identifier
+        $length      = 0x0002; // Bytes to follow
 
-        $fPrintGrid  = $this->phpSheet->getPrintGridlines() ? 1 : 0;    // Boolean flag
+        $fPrintGrid  = $this->phpSheet->getPrintGridlines() ? 1 : 0; // Boolean flag
 
         $header      = pack("vv", $record, $length);
-        $data      = pack("v", $fPrintGrid);
+        $data = pack("v", $fPrintGrid);
         $this->append($header . $data);
     }
 
@@ -2018,10 +2018,10 @@ 
      */
     private function writeGridset()
     {
-        $record      = 0x0082;                        // Record identifier
-        $length      = 0x0002;                        // Bytes to follow
+        $record      = 0x0082; // Record identifier
+        $length      = 0x0002; // Bytes to follow
 
-        $fGridSet    = !$this->phpSheet->getPrintGridlines();     // Boolean flag
+        $fGridSet    = !$this->phpSheet->getPrintGridlines(); // Boolean flag
 
         $header      = pack("vv", $record, $length);
         $data        = pack("v", $fGridSet);
@@ -2033,8 +2033,8 @@ 
      */
     private function writeAutoFilterInfo()
     {
-        $record      = 0x009D;                        // Record identifier
-        $length      = 0x0002;                        // Bytes to follow
+        $record      = 0x009D; // Record identifier
+        $length      = 0x0002; // Bytes to follow
 
         $rangeBounds = \PHPExcel\Cell::rangeBoundaries($this->phpSheet->getAutoFilter()->getRange());
         $iNumFilters = 1 + $rangeBounds[1][0] - $rangeBounds[0][0];
@@ -2053,11 +2053,11 @@ 
      */
     private function writeGuts()
     {
-        $record      = 0x0080;   // Record identifier
-        $length      = 0x0008;   // Bytes to follow
+        $record      = 0x0080; // Record identifier
+        $length      = 0x0008; // Bytes to follow
 
-        $dxRwGut     = 0x0000;   // Size of row gutter
-        $dxColGut    = 0x0000;   // Size of col gutter
+        $dxRwGut     = 0x0000; // Size of row gutter
+        $dxColGut    = 0x0000; // Size of col gutter
 
         // determine maximum row outline level
         $maxRowOutlineLevel = 0;
@@ -2065,7 +2065,7 @@ 
             $maxRowOutlineLevel = max($maxRowOutlineLevel, $rowDimension->getOutlineLevel());
         }
 
-        $col_level   = 0;
+        $col_level = 0;
 
         // Calculate the maximum column outline level. The equivalent calculation
         // for the row outline level is carried out in writeRow().
@@ -2088,7 +2088,7 @@ 
         $header      = pack("vv", $record, $length);
         $data        = pack("vvvv", $dxRwGut, $dxColGut, $maxRowOutlineLevel, $col_level);
 
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -2097,15 +2097,15 @@ 
      */
     private function writeWsbool()
     {
-        $record      = 0x0081;   // Record identifier
-        $length      = 0x0002;   // Bytes to follow
+        $record      = 0x0081; // Record identifier
+        $length      = 0x0002; // Bytes to follow
         $grbit       = 0x0000;
 
         // The only option that is of interest is the flag for fit to page. So we
         // set all the options in one go.
         //
         // Set the option flags
-        $grbit |= 0x0001;                           // Auto page breaks visible
+        $grbit |= 0x0001; // Auto page breaks visible
         if ($this->outlineStyle) {
             $grbit |= 0x0020; // Auto outline styles
         }
@@ -2165,9 +2165,9 @@ 
                 array_shift($hbreaks);
             }
 
-            $record  = 0x001b;               // Record identifier
-            $cbrk    = count($hbreaks);       // Number of page breaks
-            $length  = 2 + 6 * $cbrk;      // Bytes to follow
+            $record  = 0x001b; // Record identifier
+            $cbrk    = count($hbreaks); // Number of page breaks
+            $length  = 2 + 6 * $cbrk; // Bytes to follow
 
             $header  = pack("vv", $record, $length);
             $data    = pack("v", $cbrk);
@@ -2192,9 +2192,9 @@ 
                 array_shift($vbreaks);
             }
 
-            $record  = 0x001a;               // Record identifier
-            $cbrk    = count($vbreaks);       // Number of page breaks
-            $length  = 2 + 6 * $cbrk;      // Bytes to follow
+            $record  = 0x001a; // Record identifier
+            $cbrk    = count($vbreaks); // Number of page breaks
+            $length  = 2 + 6 * $cbrk; // Bytes to follow
 
             $header  = pack("vv", $record, $length);
             $data    = pack("v", $cbrk);
@@ -2218,15 +2218,15 @@ 
             return;
         }
 
-        $record      = 0x0012;             // Record identifier
-        $length      = 0x0002;             // Bytes to follow
+        $record      = 0x0012; // Record identifier
+        $length      = 0x0002; // Bytes to follow
 
-        $fLock      = 1;    // Worksheet is protected
+        $fLock = 1; // Worksheet is protected
 
-        $header      = pack("vv", $record, $length);
-        $data      = pack("v", $fLock);
+        $header = pack("vv", $record, $length);
+        $data = pack("v", $fLock);
 
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -2287,10 +2287,10 @@ 
             return;
         }
 
-        $record      = 0x0013;               // Record identifier
-        $length      = 0x0002;               // Bytes to follow
+        $record      = 0x0013; // Record identifier
+        $length      = 0x0002; // Bytes to follow
 
-        $wPassword   = hexdec($this->phpSheet->getProtection()->getPassword());     // Encoded password
+        $wPassword   = hexdec($this->phpSheet->getProtection()->getPassword()); // Encoded password
 
         $header      = pack("vv", $record, $length);
         $data        = pack("v", $wPassword);
@@ -2330,7 +2330,7 @@ 
         $lcb         = $size;
 
         $header      = pack("vvvvV", $record, $length, $cf, $env, $lcb);
-        $this->append($header.$data);
+        $this->append($header . $data);
     }
 
     /**
@@ -2387,8 +2387,8 @@ 
     public function positionImage($col_start, $row_start, $x1, $y1, $width, $height)
     {
         // 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 >= \PHPExcel\Shared\Excel5::sizeCol($this->phpSheet, \PHPExcel\Cell::stringFromColumnIndex($col_start))) {
@@ -2398,8 +2398,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 >= \PHPExcel\Shared\Excel5::sizeCol($this->phpSheet, \PHPExcel\Cell::stringFromColumnIndex($col_end))) {
@@ -2419,21 +2419,21 @@ 
         if (\PHPExcel\Shared\Excel5::sizeCol($this->phpSheet, \PHPExcel\Cell::stringFromColumnIndex($col_start)) == 0) {
             return;
         }
-        if (\PHPExcel\Shared\Excel5::sizeCol($this->phpSheet, \PHPExcel\Cell::stringFromColumnIndex($col_end))   == 0) {
+        if (\PHPExcel\Shared\Excel5::sizeCol($this->phpSheet, \PHPExcel\Cell::stringFromColumnIndex($col_end)) == 0) {
             return;
         }
         if (\PHPExcel\Shared\Excel5::sizeRow($this->phpSheet, $row_start + 1) == 0) {
             return;
         }
-        if (\PHPExcel\Shared\Excel5::sizeRow($this->phpSheet, $row_end + 1)   == 0) {
+        if (\PHPExcel\Shared\Excel5::sizeRow($this->phpSheet, $row_end + 1) == 0) {
             return;
         }
 
         // Convert the pixel values to the percentage value expected by Excel
-        $x1 = $x1     / \PHPExcel\Shared\Excel5::sizeCol($this->phpSheet, \PHPExcel\Cell::stringFromColumnIndex($col_start))   * 1024;
-        $y1 = $y1     / \PHPExcel\Shared\Excel5::sizeRow($this->phpSheet, $row_start + 1)   *  256;
-        $x2 = $width  / \PHPExcel\Shared\Excel5::sizeCol($this->phpSheet, \PHPExcel\Cell::stringFromColumnIndex($col_end))     * 1024; // Distance to right side of object
-        $y2 = $height / \PHPExcel\Shared\Excel5::sizeRow($this->phpSheet, $row_end + 1)     *  256; // Distance to bottom of object
+        $x1 = $x1 / \PHPExcel\Shared\Excel5::sizeCol($this->phpSheet, \PHPExcel\Cell::stringFromColumnIndex($col_start)) * 1024;
+        $y1 = $y1 / \PHPExcel\Shared\Excel5::sizeRow($this->phpSheet, $row_start + 1) * 256;
+        $x2 = $width / \PHPExcel\Shared\Excel5::sizeCol($this->phpSheet, \PHPExcel\Cell::stringFromColumnIndex($col_end)) * 1024; // Distance to right side of object
+        $y2 = $height / \PHPExcel\Shared\Excel5::sizeRow($this->phpSheet, $row_end + 1) * 256; // Distance to bottom of object
 
         $this->writeObjPicture($col_start, $x1, $row_start, $y1, $col_end, $x2, $row_end, $y2);
     }
@@ -2453,33 +2453,33 @@ 
      */
     private function writeObjPicture($colL, $dxL, $rwT, $dyT, $colR, $dxR, $rwB, $dyB)
     {
-        $record      = 0x005d;   // Record identifier
-        $length      = 0x003c;   // Bytes to follow
-
-        $cObj        = 0x0001;   // Count of objects in file (set to 1)
-        $OT          = 0x0008;   // Object type. 8 = Picture
-        $id          = 0x0001;   // Object ID
-        $grbit       = 0x0614;   // Option flags
-
-        $cbMacro     = 0x0000;   // Length of FMLA structure
-        $Reserved1   = 0x0000;   // Reserved
-        $Reserved2   = 0x0000;   // Reserved
-
-        $icvBack     = 0x09;     // Background colour
-        $icvFore     = 0x09;     // Foreground colour
-        $fls         = 0x00;     // Fill pattern
-        $fAuto       = 0x00;     // Automatic fill
-        $icv         = 0x08;     // Line colour
-        $lns         = 0xff;     // Line style
-        $lnw         = 0x01;     // Line weight
-        $fAutoB      = 0x00;     // Automatic border
-        $frs         = 0x0000;   // Frame style
-        $cf          = 0x0009;   // Image format, 9 = bitmap
-        $Reserved3   = 0x0000;   // Reserved
-        $cbPictFmla  = 0x0000;   // Length of FMLA structure
-        $Reserved4   = 0x0000;   // Reserved
-        $grbit2      = 0x0001;   // Option flags
-        $Reserved5   = 0x0000;   // Reserved
+        $record      = 0x005d; // Record identifier
+        $length      = 0x003c; // Bytes to follow
+
+        $cObj        = 0x0001; // Count of objects in file (set to 1)
+        $OT          = 0x0008; // Object type. 8 = Picture
+        $id          = 0x0001; // Object ID
+        $grbit       = 0x0614; // Option flags
+
+        $cbMacro     = 0x0000; // Length of FMLA structure
+        $Reserved1   = 0x0000; // Reserved
+        $Reserved2   = 0x0000; // Reserved
+
+        $icvBack     = 0x09; // Background colour
+        $icvFore     = 0x09; // Foreground colour
+        $fls         = 0x00; // Fill pattern
+        $fAuto       = 0x00; // Automatic fill
+        $icv         = 0x08; // Line colour
+        $lns         = 0xff; // Line style
+        $lnw         = 0x01; // Line weight
+        $fAutoB      = 0x00; // Automatic border
+        $frs         = 0x0000; // Frame style
+        $cf          = 0x0009; // Image format, 9 = bitmap
+        $Reserved3   = 0x0000; // Reserved
+        $cbPictFmla  = 0x0000; // Length of FMLA structure
+        $Reserved4   = 0x0000; // Reserved
+        $grbit2      = 0x0001; // Option flags
+        $Reserved5   = 0x0000; // Reserved
 
 
         $header      = pack("vv", $record, $length);
@@ -2530,16 +2530,16 @@ 
         $height = imagesy($image);
 
         $data = pack("Vvvvv", 0x000c, $width, $height, 0x01, 0x18);
-        for ($j=$height; $j--;) {
-            for ($i=0; $i < $width; ++$i) {
+        for ($j = $height; $j--;) {
+            for ($i = 0; $i < $width; ++$i) {
                 $color = imagecolorsforindex($image, imagecolorat($image, $i, $j));
                 foreach (array("red", "green", "blue") as $key) {
                     $color[$key] = $color[$key] + round((255 - $color[$key]) * $color["alpha"] / 127);
                 }
                 $data .= chr($color["blue"]) . chr($color["green"]) . chr($color["red"]);
             }
-            if (3*$width % 4) {
-                $data .= str_repeat("\x00", 4 - 3*$width % 4);
+            if (3 * $width % 4) {
+                $data .= str_repeat("\x00", 4 - 3 * $width % 4);
             }
         }
 
@@ -2583,7 +2583,7 @@ 
         // Read and remove the bitmap size. This is more reliable than reading
         // the data size at offset 0x22.
         //
-        $size_array   = unpack("Vsa", substr($data, 0, 4));
+        $size_array = unpack("Vsa", substr($data, 0, 4));
         $size   = $size_array['sa'];
         $data   = substr($data, 4);
         $size  -= 0x36; // Subtract size of bitmap header.
@@ -2644,8 +2644,8 @@ 
             return;
         }
 
-        $record      = 0x00A0;               // Record identifier
-        $length      = 0x0004;               // Bytes to follow
+        $record      = 0x00A0; // Record identifier
+        $length      = 0x0004; // Bytes to follow
 
         $header      = pack("vv", $record, $length);
         $data        = pack("vv", $this->phpSheet->getSheetView()->getZoomScale(), 100);
@@ -2690,10 +2690,10 @@ 
             $nm = count($spOffsets) - 1; // number of shapes excluding first shape
             for ($i = 1; $i <= $nm; ++$i) {
                 // MSODRAWING record
-                $record = 0x00EC;            // Record identifier
+                $record = 0x00EC; // Record identifier
 
                 // chunk of Escher stream for one shape
-                $dataChunk = substr($data, $spOffsets[$i -1], $spOffsets[$i] - $spOffsets[$i - 1]);
+                $dataChunk = substr($data, $spOffsets[$i - 1], $spOffsets[$i] - $spOffsets[$i - 1]);
 
                 $length = strlen($dataChunk);
                 $header = pack("vv", $record, $length);
@@ -2768,20 +2768,20 @@ 
         // Write data validations?
         if (!empty($dataValidationCollection)) {
             // DATAVALIDATIONS record
-            $record = 0x01B2;      // Record identifier
-            $length = 0x0012;      // Bytes to follow
+            $record = 0x01B2; // Record identifier
+            $length = 0x0012; // Bytes to follow
 
-            $grbit  = 0x0000;       // Prompt box at cell, no cached validity data at DV records
-            $horPos = 0x00000000;  // Horizontal position of prompt box, if fixed position
-            $verPos = 0x00000000;  // Vertical position of prompt box, if fixed position
-            $objId  = 0xFFFFFFFF;  // Object identifier of drop down arrow object, or -1 if not visible
+            $grbit  = 0x0000; // Prompt box at cell, no cached validity data at DV records
+            $horPos = 0x00000000; // Horizontal position of prompt box, if fixed position
+            $verPos = 0x00000000; // Vertical position of prompt box, if fixed position
+            $objId  = 0xFFFFFFFF; // Object identifier of drop down arrow object, or -1 if not visible
 
             $header = pack('vv', $record, $length);
             $data   = pack('vVVVV', $grbit, $horPos, $verPos, $objId, count($dataValidationCollection));
-            $this->append($header.$data);
+            $this->append($header . $data);
 
             // DATAVALIDATION records
-            $record = 0x01BE;              // Record identifier
+            $record = 0x01BE; // Record identifier
 
             foreach ($dataValidationCollection as $cellCoordinate => $dataValidation) {
                 // initialize record data
@@ -2981,8 +2981,8 @@ 
      */
     private function writePageLayoutView()
     {
-        $record      = 0x088B;               // Record identifier
-        $length      = 0x0010;               // Bytes to follow
+        $record      = 0x088B; // Record identifier
+        $length      = 0x0010; // Bytes to follow
 
         $rt         = 0x088B; // 2
         $grbitFrt   = 0x0000; // 2
@@ -2998,12 +2998,12 @@ 
         $fRulerVisible     = 0;
         $fWhitespaceHidden = 0;
 
-        $grbit      = $fPageLayoutView; // 2
-        $grbit        |= $fRulerVisible       << 1;
-        $grbit        |= $fWhitespaceHidden  << 3;
+        $grbit = $fPageLayoutView; // 2
+        $grbit        |= $fRulerVisible << 1;
+        $grbit        |= $fWhitespaceHidden << 3;
 
-        $header      = pack("vv", $record, $length);
-        $data      = pack("vvVVvv", $rt, $grbitFrt, 0x00000000, 0x00000000, $wScalvePLV, $grbit);
+        $header = pack("vv", $record, $length);
+        $data = pack("vvVVvv", $rt, $grbitFrt, 0x00000000, 0x00000000, $wScalvePLV, $grbit);
         $this->append($header . $data);
     }
 
@@ -3013,7 +3013,7 @@ 
      */
     private function writeCFRule(\PHPExcel\Style\Conditional $conditional)
     {
-        $record      = 0x01B1;               // Record identifier
+        $record = 0x01B1; // Record identifier
 
         // $type : Type of the CF
         // $operatorType : Comparison operator
@@ -3133,49 +3133,49 @@ 
         }
         // Alignment
         $flags = 0;
-        $flags |= (1 == $bAlignHz      ? 0x00000001 : 0);
-        $flags |= (1 == $bAlignVt      ? 0x00000002 : 0);
-        $flags |= (1 == $bAlignWrapTx  ? 0x00000004 : 0);
-        $flags |= (1 == $bTxRotation   ? 0x00000008 : 0);
+        $flags |= (1 == $bAlignHz ? 0x00000001 : 0);
+        $flags |= (1 == $bAlignVt ? 0x00000002 : 0);
+        $flags |= (1 == $bAlignWrapTx ? 0x00000004 : 0);
+        $flags |= (1 == $bTxRotation ? 0x00000008 : 0);
         // Justify last line flag
-        $flags |= (1 == 1              ? 0x00000010 : 0);
-        $flags |= (1 == $bIndent       ? 0x00000020 : 0);
-        $flags |= (1 == $bShrinkToFit  ? 0x00000040 : 0);
+        $flags |= (1 == 1 ? 0x00000010 : 0);
+        $flags |= (1 == $bIndent ? 0x00000020 : 0);
+        $flags |= (1 == $bShrinkToFit ? 0x00000040 : 0);
         // Default
-        $flags |= (1 == 1              ? 0x00000080 : 0);
+        $flags |= (1 == 1 ? 0x00000080 : 0);
         // Protection
-        $flags |= (1 == $bProtLocked   ? 0x00000100 : 0);
-        $flags |= (1 == $bProtHidden   ? 0x00000200 : 0);
+        $flags |= (1 == $bProtLocked ? 0x00000100 : 0);
+        $flags |= (1 == $bProtHidden ? 0x00000200 : 0);
         // Border
-        $flags |= (1 == $bBorderLeft   ? 0x00000400 : 0);
-        $flags |= (1 == $bBorderRight  ? 0x00000800 : 0);
-        $flags |= (1 == $bBorderTop    ? 0x00001000 : 0);
+        $flags |= (1 == $bBorderLeft ? 0x00000400 : 0);
+        $flags |= (1 == $bBorderRight ? 0x00000800 : 0);
+        $flags |= (1 == $bBorderTop ? 0x00001000 : 0);
         $flags |= (1 == $bBorderBottom ? 0x00002000 : 0);
-        $flags |= (1 == 1              ? 0x00004000 : 0); // Top left to Bottom right border
-        $flags |= (1 == 1              ? 0x00008000 : 0); // Bottom left to Top right border
+        $flags |= (1 == 1 ? 0x00004000 : 0); // Top left to Bottom right border
+        $flags |= (1 == 1 ? 0x00008000 : 0); // Bottom left to Top right border
         // Pattern
-        $flags |= (1 == $bFillStyle    ? 0x00010000 : 0);
-        $flags |= (1 == $bFillColor    ? 0x00020000 : 0);
-        $flags |= (1 == $bFillColorBg  ? 0x00040000 : 0);
-        $flags |= (1 == 1              ? 0x00380000 : 0);
+        $flags |= (1 == $bFillStyle ? 0x00010000 : 0);
+        $flags |= (1 == $bFillColor ? 0x00020000 : 0);
+        $flags |= (1 == $bFillColorBg ? 0x00040000 : 0);
+        $flags |= (1 == 1 ? 0x00380000 : 0);
         // Font
-        $flags |= (1 == $bFormatFont   ? 0x04000000 : 0);
+        $flags |= (1 == $bFormatFont ? 0x04000000 : 0);
         // Alignment:
-        $flags |= (1 == $bFormatAlign  ? 0x08000000 : 0);
+        $flags |= (1 == $bFormatAlign ? 0x08000000 : 0);
         // Border
         $flags |= (1 == $bFormatBorder ? 0x10000000 : 0);
         // Pattern
-        $flags |= (1 == $bFormatFill   ? 0x20000000 : 0);
+        $flags |= (1 == $bFormatFill ? 0x20000000 : 0);
         // Protection
-        $flags |= (1 == $bFormatProt   ? 0x40000000 : 0);
+        $flags |= (1 == $bFormatProt ? 0x40000000 : 0);
         // Text direction
-        $flags |= (1 == 0              ? 0x80000000 : 0);
+        $flags |= (1 == 0 ? 0x80000000 : 0);
 
         // Data Blocks
         if ($bFormatFont == 1) {
             // Font Name
             if ($conditional->getStyle()->getFont()->getName() == null) {
-                $dataBlockFont =  pack('VVVVVVVV', 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000);
+                $dataBlockFont = pack('VVVVVVVV', 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000);
                 $dataBlockFont .= pack('VVVVVVVV', 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000);
             } else {
                 $dataBlockFont = \PHPExcel\Shared\StringHelper::UTF8toBIFF8UnicodeLong($conditional->getStyle()->getFont()->getName());
@@ -3414,11 +3414,11 @@ 
             // Options flags for modified font attributes
             $optionsFlags = 0;
             $optionsFlagsBold = ($conditional->getStyle()->getFont()->getBold() == null ? 1 : 0);
-            $optionsFlags |= (1 == $optionsFlagsBold  ? 0x00000002 : 0);
-            $optionsFlags |= (1 == 1                  ? 0x00000008 : 0);
-            $optionsFlags |= (1 == 1                  ? 0x00000010 : 0);
-            $optionsFlags |= (1 == 0                  ? 0x00000020 : 0);
-            $optionsFlags |= (1 == 1                  ? 0x00000080 : 0);
+            $optionsFlags |= (1 == $optionsFlagsBold ? 0x00000002 : 0);
+            $optionsFlags |= (1 == 1 ? 0x00000008 : 0);
+            $optionsFlags |= (1 == 1 ? 0x00000010 : 0);
+            $optionsFlags |= (1 == 0 ? 0x00000020 : 0);
+            $optionsFlags |= (1 == 1 ? 0x00000080 : 0);
             $dataBlockFont .= pack('V', $optionsFlags);
             // Escapement type
             $dataBlockFont .= pack('V', $fontEscapement);
@@ -3789,10 +3789,10 @@ 
                     break;
                 case \PHPExcel\Style\Fill::FILL_GRADIENT_LINEAR:
                     $blockFillPatternStyle = 0x00;
-                    break;    // does not exist in BIFF8
+                    break; // does not exist in BIFF8
                 case \PHPExcel\Style\Fill::FILL_GRADIENT_PATH:
                     $blockFillPatternStyle = 0x00;
-                    break;    // does not exist in BIFF8
+                    break; // does not exist in BIFF8
                 default:
                     $blockFillPatternStyle = 0x00;
                     break;
@@ -4180,7 +4180,7 @@ 
         if (!is_null($operand2)) {
             $data .= $operand2;
         }
-        $header      = pack('vv', $record, strlen($data));
+        $header = pack('vv', $record, strlen($data));
         $this->append($header . $data);
     }
 
@@ -4189,8 +4189,8 @@ 
      */
     private function writeCFHeader()
     {
-        $record      = 0x01B0;               // Record identifier
-        $length      = 0x0016;               // Bytes to follow
+        $record      = 0x01B0; // Record identifier
+        $length      = 0x0016; // Bytes to follow
 
         $numColumnMin = null;
         $numColumnMax = null;
@@ -4225,9 +4225,9 @@ 
             }
         }
         $needRedraw = 1;
-        $cellRange = pack('vvvv', $numRowMin-1, $numRowMax-1, $numColumnMin-1, $numColumnMax-1);
+        $cellRange = pack('vvvv', $numRowMin - 1, $numRowMax - 1, $numColumnMin - 1, $numColumnMax - 1);
 
-        $header      = pack('vv', $record, $length);
+        $header = pack('vv', $record, $length);
         $data      = pack('vv', count($arrConditional), $needRedraw);
         $data     .= $cellRange;
         $data     .= pack('v', 0x0001);

src/PhpSpreadsheet/Writer/HTML.php

Doc Comments +5 added lines, -5 removed lines

@@ -135,7 +135,7 @@ 
     /**
      * Create a new PHPExcel_Writer_HTML
      *
-     * @param    PHPExcel    $phpExcel    PHPExcel object
+     * @param    Spreadsheet    $phpExcel    PHPExcel object
      */
     public function __construct(Spreadsheet $phpExcel)
     {
@@ -1419,7 +1419,7 @@ 
      * Set images root
      *
      * @param string $pValue
-     * @return PHPExcel_Writer_HTML
+     * @return HTML
      */
     public function setImagesRoot($pValue = '.')
     {
@@ -1440,8 +1440,8 @@ 
     /**
      * Set embed images
      *
-     * @param boolean $pValue
-     * @return PHPExcel_Writer_HTML
+     * @param string|boolean $pValue
+     * @return HTML
      */
     public function setEmbedImages($pValue = '.')
     {
@@ -1463,7 +1463,7 @@ 
      * Set use inline CSS?
      *
      * @param boolean $pValue
-     * @return PHPExcel_Writer_HTML
+     * @return HTML
      */
     public function setUseInlineCss($pValue = false)
     {

Spacing +19 added lines, -19 removed lines

@@ -439,7 +439,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();
 
@@ -452,7 +452,7 @@ 
             }
 
             // Loop through cells
-            $row = $rowMin-1;
+            $row = $rowMin - 1;
             while ($row++ < $rowMax) {
                 // <thead> ?
                 if ($row == $theadStart) {
@@ -590,9 +590,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>';
             }
@@ -649,7 +649,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;
                         }
@@ -666,10 +666,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);
 
@@ -677,7 +677,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;" />';
             }
         }
 
@@ -702,7 +702,7 @@ 
             if ($chart instanceof PHPExcel_Chart) {
                 $chartCoordinates = $chart->getTopLeftPosition();
                 if ($chartCoordinates['cell'] == $coordinates) {
-                    $chartFileName = \PHPExcel\Shared\File::sysGetTempDir().'/'.uniqid().'.png';
+                    $chartFileName = \PHPExcel\Shared\File::sysGetTempDir() . '/' . uniqid() . '.png';
                     if (!$chart->render($chartFileName)) {
                         return;
                     }
@@ -715,7 +715,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;
@@ -810,7 +810,7 @@ 
 
 
         // table { }
-        $css['table']['border-collapse']  = 'collapse';
+        $css['table']['border-collapse'] = 'collapse';
         if (!$this->isPdf) {
             $css['table']['page-break-after'] = 'always';
         }
@@ -968,7 +968,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';
             }
         }
 
@@ -1259,9 +1259,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>';
                         }
                     }
 
@@ -1371,7 +1371,7 @@ 
                     $html .= $cellData;
 
                     // Column end
-                    $html .= '</'.$cellType.'>' . PHP_EOL;
+                    $html .= '</' . $cellType . '>' . PHP_EOL;
                 }
 
                 // Next column
@@ -1516,7 +1516,7 @@ 
         foreach ($sheetIndexes as $sheetIndex) {
             $sheet = $this->phpExcel->getSheet($sheetIndex);
 
-            $candidateSpannedRow  = array();
+            $candidateSpannedRow = array();
 
             // loop through all Excel merged cells
             foreach ($sheet->getMergeCells() as $cells) {
@@ -1578,7 +1578,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/Writer/OpenDocument.php

Doc Comments +3 added lines, -3 removed lines

@@ -71,7 +71,7 @@ 
      * Get writer part
      *
      * @param  string  $pPartName  Writer part name
-     * @return \PHPExcel\Writer\Excel2007\WriterPart
+     * @return PHPExcel_Writer_OpenDocument_WriterPart|null
      */
     public function getWriterPart($pPartName = '')
     {
@@ -180,9 +180,9 @@ 
     /**
      * Set PHPExcel object
      *
-     * @param  PHPExcel  $pPHPExcel  PHPExcel object
+     * @param  \PHPExcel\Spreadsheet  $pPHPExcel  PHPExcel object
      * @throws \PHPExcel\Writer\Exception
-     * @return PHPExcel_Writer_Excel2007
+     * @return OpenDocument
      */
     public function setPHPExcel(\PHPExcel\SpreadSheet $pPHPExcel = null)
     {

src/PhpSpreadsheet/Writer/OpenDocument/Thumbnails.php

Doc Comments +1 added lines, -1 removed lines

@@ -32,7 +32,7 @@
     /**
      * Write Thumbnails/thumbnail.png to PNG format
      *
-     * @param   PHPExcel                   $pPHPExcel
+     * @param   \PHPExcel\Spreadsheet                   $pPHPExcel
      * @return  string                     XML Output
      * @throws  \PHPExcel\Writer\Exception
      */

src/PhpSpreadsheet/Writer/PDF/Core.php

Doc Comments +3 added lines, -3 removed lines

@@ -256,7 +256,7 @@ 
      *  Set Paper Size
      *
      *  @param  string  $pValue Paper size
-     *  @return PHPExcel_Writer_PDF
+     *  @return Core
      */
     public function setPaperSize($pValue = \PHPExcel\Worksheet\PageSetup::PAPERSIZE_LETTER)
     {
@@ -278,7 +278,7 @@ 
      *  Set Orientation
      *
      *  @param string $pValue  Page orientation
-     *  @return PHPExcel_Writer_PDF
+     *  @return Core
      */
     public function setOrientation($pValue = \PHPExcel\Worksheet\PageSetup::ORIENTATION_DEFAULT)
     {
@@ -301,7 +301,7 @@ 
      *
      *  @param     string        $pValue        Temporary storage directory
      *  @throws    \PHPExcel\Writer\Exception    when directory does not exist
-     *  @return    PHPExcel_Writer_PDF
+     *  @return    Core
      */
     public function setTempDir($pValue = '')
     {

Spacing +65 added lines, -65 removed lines

@@ -72,135 +72,135 @@
      */
     protected static $paperSizes = array(
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_LETTER
-            => 'LETTER',                 //    (8.5 in. by 11 in.)
+            => 'LETTER', //    (8.5 in. by 11 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_LETTER_SMALL
-            => 'LETTER',                 //    (8.5 in. by 11 in.)
+            => 'LETTER', //    (8.5 in. by 11 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_TABLOID
-            => array(792.00, 1224.00),   //    (11 in. by 17 in.)
+            => array(792.00, 1224.00), //    (11 in. by 17 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_LEDGER
-            => array(1224.00, 792.00),   //    (17 in. by 11 in.)
+            => array(1224.00, 792.00), //    (17 in. by 11 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_LEGAL
-            => 'LEGAL',                  //    (8.5 in. by 14 in.)
+            => 'LEGAL', //    (8.5 in. by 14 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_STATEMENT
-            => array(396.00, 612.00),    //    (5.5 in. by 8.5 in.)
+            => array(396.00, 612.00), //    (5.5 in. by 8.5 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_EXECUTIVE
-            => 'EXECUTIVE',              //    (7.25 in. by 10.5 in.)
+            => 'EXECUTIVE', //    (7.25 in. by 10.5 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A3
-            => 'A3',                     //    (297 mm by 420 mm)
+            => 'A3', //    (297 mm by 420 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A4
-            => 'A4',                     //    (210 mm by 297 mm)
+            => 'A4', //    (210 mm by 297 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A4_SMALL
-            => 'A4',                     //    (210 mm by 297 mm)
+            => 'A4', //    (210 mm by 297 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A5
-            => 'A5',                     //    (148 mm by 210 mm)
+            => 'A5', //    (148 mm by 210 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_B4
-            => 'B4',                     //    (250 mm by 353 mm)
+            => 'B4', //    (250 mm by 353 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_B5
-            => 'B5',                     //    (176 mm by 250 mm)
+            => 'B5', //    (176 mm by 250 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_FOLIO
-            => 'FOLIO',                  //    (8.5 in. by 13 in.)
+            => 'FOLIO', //    (8.5 in. by 13 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_QUARTO
-            => array(609.45, 779.53),    //    (215 mm by 275 mm)
+            => array(609.45, 779.53), //    (215 mm by 275 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_STANDARD_1
-            => array(720.00, 1008.00),   //    (10 in. by 14 in.)
+            => array(720.00, 1008.00), //    (10 in. by 14 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_STANDARD_2
-            => array(792.00, 1224.00),   //    (11 in. by 17 in.)
+            => array(792.00, 1224.00), //    (11 in. by 17 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_NOTE
-            => 'LETTER',                 //    (8.5 in. by 11 in.)
+            => 'LETTER', //    (8.5 in. by 11 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_NO9_ENVELOPE
-            => array(279.00, 639.00),    //    (3.875 in. by 8.875 in.)
+            => array(279.00, 639.00), //    (3.875 in. by 8.875 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_NO10_ENVELOPE
-            => array(297.00, 684.00),    //    (4.125 in. by 9.5 in.)
+            => array(297.00, 684.00), //    (4.125 in. by 9.5 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_NO11_ENVELOPE
-            => array(324.00, 747.00),    //    (4.5 in. by 10.375 in.)
+            => array(324.00, 747.00), //    (4.5 in. by 10.375 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_NO12_ENVELOPE
-            => array(342.00, 792.00),    //    (4.75 in. by 11 in.)
+            => array(342.00, 792.00), //    (4.75 in. by 11 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_NO14_ENVELOPE
-            => array(360.00, 828.00),    //    (5 in. by 11.5 in.)
+            => array(360.00, 828.00), //    (5 in. by 11.5 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_C
-            => array(1224.00, 1584.00),  //    (17 in. by 22 in.)
+            => array(1224.00, 1584.00), //    (17 in. by 22 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_D
-            => array(1584.00, 2448.00),  //    (22 in. by 34 in.)
+            => array(1584.00, 2448.00), //    (22 in. by 34 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_E
-            => array(2448.00, 3168.00),  //    (34 in. by 44 in.)
+            => array(2448.00, 3168.00), //    (34 in. by 44 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_DL_ENVELOPE
-            => array(311.81, 623.62),    //    (110 mm by 220 mm)
+            => array(311.81, 623.62), //    (110 mm by 220 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_C5_ENVELOPE
-            => 'C5',                     //    (162 mm by 229 mm)
+            => 'C5', //    (162 mm by 229 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_C3_ENVELOPE
-            => 'C3',                     //    (324 mm by 458 mm)
+            => 'C3', //    (324 mm by 458 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_C4_ENVELOPE
-            => 'C4',                     //    (229 mm by 324 mm)
+            => 'C4', //    (229 mm by 324 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_C6_ENVELOPE
-            => 'C6',                     //    (114 mm by 162 mm)
+            => 'C6', //    (114 mm by 162 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_C65_ENVELOPE
-            => array(323.15, 649.13),    //    (114 mm by 229 mm)
+            => array(323.15, 649.13), //    (114 mm by 229 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_B4_ENVELOPE
-            => 'B4',                     //    (250 mm by 353 mm)
+            => 'B4', //    (250 mm by 353 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_B5_ENVELOPE
-            => 'B5',                     //    (176 mm by 250 mm)
+            => 'B5', //    (176 mm by 250 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_B6_ENVELOPE
-            => array(498.90, 354.33),    //    (176 mm by 125 mm)
+            => array(498.90, 354.33), //    (176 mm by 125 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_ITALY_ENVELOPE
-            => array(311.81, 651.97),    //    (110 mm by 230 mm)
+            => array(311.81, 651.97), //    (110 mm by 230 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_MONARCH_ENVELOPE
-            => array(279.00, 540.00),    //    (3.875 in. by 7.5 in.)
+            => array(279.00, 540.00), //    (3.875 in. by 7.5 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_6_3_4_ENVELOPE
-            => array(261.00, 468.00),    //    (3.625 in. by 6.5 in.)
+            => array(261.00, 468.00), //    (3.625 in. by 6.5 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_US_STANDARD_FANFOLD
-            => array(1071.00, 792.00),   //    (14.875 in. by 11 in.)
+            => array(1071.00, 792.00), //    (14.875 in. by 11 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_GERMAN_STANDARD_FANFOLD
-            => array(612.00, 864.00),    //    (8.5 in. by 12 in.)
+            => array(612.00, 864.00), //    (8.5 in. by 12 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_GERMAN_LEGAL_FANFOLD
-            => 'FOLIO',                  //    (8.5 in. by 13 in.)
+            => 'FOLIO', //    (8.5 in. by 13 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_ISO_B4
-            => 'B4',                     //    (250 mm by 353 mm)
+            => 'B4', //    (250 mm by 353 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_JAPANESE_DOUBLE_POSTCARD
-            => array(566.93, 419.53),    //    (200 mm by 148 mm)
+            => array(566.93, 419.53), //    (200 mm by 148 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_STANDARD_PAPER_1
-            => array(648.00, 792.00),    //    (9 in. by 11 in.)
+            => array(648.00, 792.00), //    (9 in. by 11 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_STANDARD_PAPER_2
-            => array(720.00, 792.00),    //    (10 in. by 11 in.)
+            => array(720.00, 792.00), //    (10 in. by 11 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_STANDARD_PAPER_3
-            => array(1080.00, 792.00),   //    (15 in. by 11 in.)
+            => array(1080.00, 792.00), //    (15 in. by 11 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_INVITE_ENVELOPE
-            => array(623.62, 623.62),    //    (220 mm by 220 mm)
+            => array(623.62, 623.62), //    (220 mm by 220 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_LETTER_EXTRA_PAPER
-            => array(667.80, 864.00),    //    (9.275 in. by 12 in.)
+            => array(667.80, 864.00), //    (9.275 in. by 12 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_LEGAL_EXTRA_PAPER
-            => array(667.80, 1080.00),   //    (9.275 in. by 15 in.)
+            => array(667.80, 1080.00), //    (9.275 in. by 15 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_TABLOID_EXTRA_PAPER
-            => array(841.68, 1296.00),   //    (11.69 in. by 18 in.)
+            => array(841.68, 1296.00), //    (11.69 in. by 18 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A4_EXTRA_PAPER
-            => array(668.98, 912.76),    //    (236 mm by 322 mm)
+            => array(668.98, 912.76), //    (236 mm by 322 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_LETTER_TRANSVERSE_PAPER
-            => array(595.80, 792.00),    //    (8.275 in. by 11 in.)
+            => array(595.80, 792.00), //    (8.275 in. by 11 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A4_TRANSVERSE_PAPER
-            => 'A4',                     //    (210 mm by 297 mm)
+            => 'A4', //    (210 mm by 297 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_LETTER_EXTRA_TRANSVERSE_PAPER
-            => array(667.80, 864.00),    //    (9.275 in. by 12 in.)
+            => array(667.80, 864.00), //    (9.275 in. by 12 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_SUPERA_SUPERA_A4_PAPER
-            => array(643.46, 1009.13),   //    (227 mm by 356 mm)
+            => array(643.46, 1009.13), //    (227 mm by 356 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_SUPERB_SUPERB_A3_PAPER
-            => array(864.57, 1380.47),   //    (305 mm by 487 mm)
+            => array(864.57, 1380.47), //    (305 mm by 487 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_LETTER_PLUS_PAPER
-            => array(612.00, 913.68),    //    (8.5 in. by 12.69 in.)
+            => array(612.00, 913.68), //    (8.5 in. by 12.69 in.)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A4_PLUS_PAPER
-            => array(595.28, 935.43),    //    (210 mm by 330 mm)
+            => array(595.28, 935.43), //    (210 mm by 330 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A5_TRANSVERSE_PAPER
-            => 'A5',                     //    (148 mm by 210 mm)
+            => 'A5', //    (148 mm by 210 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_JIS_B5_TRANSVERSE_PAPER
-            => array(515.91, 728.50),    //    (182 mm by 257 mm)
+            => array(515.91, 728.50), //    (182 mm by 257 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A3_EXTRA_PAPER
-            => array(912.76, 1261.42),   //    (322 mm by 445 mm)
+            => array(912.76, 1261.42), //    (322 mm by 445 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A5_EXTRA_PAPER
-            => array(493.23, 666.14),    //    (174 mm by 235 mm)
+            => array(493.23, 666.14), //    (174 mm by 235 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_ISO_B5_EXTRA_PAPER
-            => array(569.76, 782.36),    //    (201 mm by 276 mm)
+            => array(569.76, 782.36), //    (201 mm by 276 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A2_PAPER
-            => 'A2',                     //    (420 mm by 594 mm)
+            => 'A2', //    (420 mm by 594 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A3_TRANSVERSE_PAPER
-            => 'A3',                     //    (297 mm by 420 mm)
+            => 'A3', //    (297 mm by 420 mm)
         \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A3_EXTRA_TRANSVERSE_PAPER
             => array(912.76, 1261.42)    //    (322 mm by 445 mm)
     );

Examples/29advancedvaluebinder.php

Indentation +34 added lines, -34 removed lines

@@ -51,12 +51,12 @@ 
 // Set document properties
 echo date('H:i:s') , " Set document properties" , EOL;
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
-							 ->setLastModifiedBy("Maarten Balliauw")
-							 ->setTitle("Office 2007 XLSX Test Document")
-							 ->setSubject("Office 2007 XLSX Test Document")
-							 ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
-							 ->setKeywords("office 2007 openxml php")
-							 ->setCategory("Test result file");
+                                ->setLastModifiedBy("Maarten Balliauw")
+                                ->setTitle("Office 2007 XLSX Test Document")
+                                ->setSubject("Office 2007 XLSX Test Document")
+                                ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
+                                ->setKeywords("office 2007 openxml php")
+                                ->setCategory("Test result file");
 
 // Set default font
 echo date('H:i:s') , " Set default font" , EOL;
@@ -71,88 +71,88 @@ 
 // Add some data, resembling some different data types
 echo date('H:i:s') , " Add some data" , EOL;
 $objPHPExcel->getActiveSheet()->setCellValue('A1', 'String value:')
-                              ->setCellValue('B1', 'Mark Baker');
+                                ->setCellValue('B1', 'Mark Baker');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A2', 'Numeric value #1:')
-                              ->setCellValue('B2', 12345);
+                                ->setCellValue('B2', 12345);
 
 $objPHPExcel->getActiveSheet()->setCellValue('A3', 'Numeric value #2:')
-                              ->setCellValue('B3', -12.345);
+                                ->setCellValue('B3', -12.345);
 
 $objPHPExcel->getActiveSheet()->setCellValue('A4', 'Numeric value #3:')
-                              ->setCellValue('B4', .12345);
+                                ->setCellValue('B4', .12345);
 
 $objPHPExcel->getActiveSheet()->setCellValue('A5', 'Numeric value #4:')
-                              ->setCellValue('B5', '12345');
+                                ->setCellValue('B5', '12345');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A6', 'Numeric value #5:')
-                              ->setCellValue('B6', '1.2345');
+                                ->setCellValue('B6', '1.2345');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A7', 'Numeric value #6:')
-                              ->setCellValue('B7', '.12345');
+                                ->setCellValue('B7', '.12345');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A8', 'Numeric value #7:')
-                              ->setCellValue('B8', '1.234e-5');
+                                ->setCellValue('B8', '1.234e-5');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A9', 'Numeric value #8:')
-                              ->setCellValue('B9', '-1.234e+5');
+                                ->setCellValue('B9', '-1.234e+5');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A10', 'Boolean value:')
-                              ->setCellValue('B10', 'TRUE');
+                                ->setCellValue('B10', 'TRUE');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A11', 'Percentage value #1:')
-                              ->setCellValue('B11', '10%');
+                                ->setCellValue('B11', '10%');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A12', 'Percentage value #2:')
-                              ->setCellValue('B12', '12.5%');
+                                ->setCellValue('B12', '12.5%');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A13', 'Fraction value #1:')
-                              ->setCellValue('B13', '-1/2');
+                                ->setCellValue('B13', '-1/2');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A14', 'Fraction value #2:')
-                              ->setCellValue('B14', '3 1/2');
+                                ->setCellValue('B14', '3 1/2');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A15', 'Fraction value #3:')
-                              ->setCellValue('B15', '-12 3/4');
+                                ->setCellValue('B15', '-12 3/4');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A16', 'Fraction value #4:')
-                              ->setCellValue('B16', '13/4');
+                                ->setCellValue('B16', '13/4');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A17', 'Currency value #1:')
-                              ->setCellValue('B17', '$12345');
+                                ->setCellValue('B17', '$12345');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A18', 'Currency value #2:')
-                              ->setCellValue('B18', '$12345.67');
+                                ->setCellValue('B18', '$12345.67');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A19', 'Currency value #3:')
-                              ->setCellValue('B19', '$12,345.67');
+                                ->setCellValue('B19', '$12,345.67');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A20', 'Date value #1:')
-                              ->setCellValue('B20', '21 December 1983');
+                                ->setCellValue('B20', '21 December 1983');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A21', 'Date value #2:')
-                              ->setCellValue('B21', '19-Dec-1960');
+                                ->setCellValue('B21', '19-Dec-1960');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A22', 'Date value #3:')
-                              ->setCellValue('B22', '07/12/1982');
+                                ->setCellValue('B22', '07/12/1982');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A23', 'Date value #4:')
-                              ->setCellValue('B23', '24-11-1950');
+                                ->setCellValue('B23', '24-11-1950');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A24', 'Date value #5:')
-                              ->setCellValue('B24', '17-Mar');
+                                ->setCellValue('B24', '17-Mar');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A25', 'Time value #1:')
-                              ->setCellValue('B25', '01:30');
+                                ->setCellValue('B25', '01:30');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A26', 'Time value #2:')
-                              ->setCellValue('B26', '01:30:15');
+                                ->setCellValue('B26', '01:30:15');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A27', 'Date/Time value:')
-                              ->setCellValue('B27', '19-Dec-1960 01:30');
+                                ->setCellValue('B27', '19-Dec-1960 01:30');
 
 $objPHPExcel->getActiveSheet()->setCellValue('A28', 'Formula:')
-                              ->setCellValue('B28', '=SUM(B2:B9)');
+                                ->setCellValue('B28', '=SUM(B2:B9)');
 
 // Rename worksheet
 echo date('H:i:s') , " Rename worksheet" , EOL;

Spacing +17 added lines, -17 removed lines

@@ -30,26 +30,26 @@ 
 ini_set('display_errors', TRUE);
 ini_set('display_startup_errors', TRUE);
 
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
 
 /** PHPExcel */
 require_once dirname(__FILE__) . '/../src/Bootstrap.php';
 
 
 // Set timezone
-echo date('H:i:s') , " Set timezone" , EOL;
+echo date('H:i:s'), " Set timezone", EOL;
 date_default_timezone_set('UTC');
 
 // Set value binder
-echo date('H:i:s') , " Set value binder" , EOL;
-\PHPExcel\Cell::setValueBinder( new \PHPExcel\Cell\AdvancedValueBinder() );
+echo date('H:i:s'), " Set value binder", EOL;
+\PHPExcel\Cell::setValueBinder(new \PHPExcel\Cell\AdvancedValueBinder());
 
 // Create new PHPExcel object
-echo date('H:i:s') , " Create new PHPExcel object" , EOL;
+echo date('H:i:s'), " Create new PHPExcel object", EOL;
 $objPHPExcel = new \PHPExcel\Spreadsheet();
 
 // Set document properties
-echo date('H:i:s') , " Set document properties" , EOL;
+echo date('H:i:s'), " Set document properties", EOL;
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
 							 ->setLastModifiedBy("Maarten Balliauw")
 							 ->setTitle("Office 2007 XLSX Test Document")
@@ -59,17 +59,17 @@ 
 							 ->setCategory("Test result file");
 
 // Set default font
-echo date('H:i:s') , " Set default font" , EOL;
+echo date('H:i:s'), " Set default font", EOL;
 $objPHPExcel->getActiveSheet()->getDefaultStyle()->getFont()->setName('Arial');
 $objPHPExcel->getActiveSheet()->getDefaultStyle()->getFont()->setSize(10);
 
 // Set column widths
-echo date('H:i:s') , " Set column widths" , EOL;
+echo date('H:i:s'), " Set column widths", EOL;
 $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
 $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(14);
 
 // Add some data, resembling some different data types
-echo date('H:i:s') , " Add some data" , EOL;
+echo date('H:i:s'), " Add some data", EOL;
 $objPHPExcel->getActiveSheet()->setCellValue('A1', 'String value:')
                               ->setCellValue('B1', 'Mark Baker');
 
@@ -155,7 +155,7 @@ 
                               ->setCellValue('B28', '=SUM(B2:B9)');
 
 // Rename worksheet
-echo date('H:i:s') , " Rename worksheet" , EOL;
+echo date('H:i:s'), " Rename worksheet", EOL;
 $objPHPExcel->getActiveSheet()->setTitle('Advanced value binder');
 
 
@@ -164,20 +164,20 @@ 
 
 
 // Save Excel 2007 file
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
 $objWriter->save(str_replace('.php', '.xlsx', __FILE__));
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
 // Save Excel5 file
-echo date('H:i:s') , " Write to Excel5 format" , EOL;
+echo date('H:i:s'), " Write to Excel5 format", EOL;
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel5');
 $objWriter->save(str_replace('.php', '.xls', __FILE__));
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
 
 
 // Echo memory peak usage
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
 
 // Echo done
-echo date('H:i:s') , " Done writing file" , EOL;
-echo 'File has been created in ' , getcwd() , EOL;
+echo date('H:i:s'), " Done writing file", EOL;
+echo 'File has been created in ', getcwd(), EOL;

Examples/XMLReader.php

Spacing +6 added lines, -6 removed lines

@@ -34,12 +34,12 @@ 
 require_once dirname(__FILE__) . '/../Classes/PHPExcel/IOFactory.php';

 

 

-echo date('H:i:s') , " Load from XML file" , PHP_EOL;

+echo date('H:i:s'), " Load from XML file", PHP_EOL;

 $inputFileName = "XMLTest.xml";

 

 /**  Identify the type of $inputFileName  **/

 $inputFileType = \PHPExcel\IOFactory::identify($inputFileName);

-echo 'Loading ' , $inputFileName , ' using ' , $inputFileType , " Reader" , PHP_EOL;

+echo 'Loading ', $inputFileName, ' using ', $inputFileType, " Reader", PHP_EOL;

 

 /**  Create a new Reader of the type that has been identified  **/

 $objReader = \PHPExcel\IOFactory::createReader($inputFileType);

@@ -47,14 +47,14 @@ 
 $objPHPExcel = $objReader->load($inputFileName);

 

 

-echo date('H:i:s') , " Write to Excel2007 format" , PHP_EOL;

+echo date('H:i:s'), " Write to Excel2007 format", PHP_EOL;

 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');

 $objWriter->save(str_replace('.php', '.xlsx', __FILE__));

-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', __FILE__) , PHP_EOL;

+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', __FILE__), PHP_EOL;

 

 

 // Echo memory peak usage

-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , PHP_EOL;

+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", PHP_EOL;

 

 // Echo done

-echo date('H:i:s') , " Done writing file" , PHP_EOL;

+echo date('H:i:s'), " Done writing file", PHP_EOL;

Examples/21pdf.php

Indentation +8 added lines, -8 removed lines

@@ -62,14 +62,14 @@
 echo date('H:i:s') , " Write to PDF format using {$rendererName}" , EOL;
 
 if (!\PHPExcel\Settings::setPdfRenderer(
-		$rendererName,
-		$rendererLibraryPath
-	)) {
-	die(
-		'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
-		EOL .
-		'at the top of this script as appropriate for your directory structure'
-	);
+        $rendererName,
+        $rendererLibraryPath
+    )) {
+    die(
+        'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
+        EOL .
+        'at the top of this script as appropriate for your directory structure'
+    );
 }
 
 

Spacing +11 added lines, -11 removed lines

@@ -31,7 +31,7 @@ 
 ini_set('display_startup_errors', TRUE);
 date_default_timezone_set('Europe/London');
 
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
 
 date_default_timezone_set('Europe/London');
 
@@ -52,14 +52,14 @@ 
 $rendererLibraryPath = '/php/libraries/PDF/' . $rendererLibrary;
 
 
-echo date('H:i:s') , " Hide grid lines" , EOL;
+echo date('H:i:s'), " Hide grid lines", EOL;
 $objPHPExcel->getActiveSheet()->setShowGridLines(false);
 
-echo date('H:i:s') , " Set orientation to landscape" , EOL;
+echo date('H:i:s'), " Set orientation to landscape", EOL;
 $objPHPExcel->getActiveSheet()->getPageSetup()->setOrientation(\PHPExcel\Worksheet\PageSetup::ORIENTATION_LANDSCAPE);
 
 
-echo date('H:i:s') , " Write to PDF format using {$rendererName}" , EOL;
+echo date('H:i:s'), " Write to PDF format using {$rendererName}", EOL;
 
 if (!\PHPExcel\Settings::setPdfRenderer(
 		$rendererName,
@@ -77,18 +77,18 @@ 
 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'PDF');
 $objWriter->setSheetIndex(0);
-$objWriter->save(str_replace('.php', '_'.$rendererName.'.pdf', __FILE__));
+$objWriter->save(str_replace('.php', '_' . $rendererName . '.pdf', __FILE__));
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
-echo date('H:i:s') , " File written to " , str_replace('.php', '_'.$rendererName.'.pdf', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '_' . $rendererName . '.pdf', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
 // Echo memory usage
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
 
 
 // Echo memory peak usage
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
 
 // Echo done
-echo date('H:i:s') , " Done writing files" , EOL;
-echo 'File has been created in ' , getcwd() , EOL;
+echo date('H:i:s'), " Done writing files", EOL;
+echo 'File has been created in ', getcwd(), EOL;