PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Writer/Excel2007/ContentTypes.php

Spacing +4 added lines, -4 removed lines

@@ -129,8 +129,8 @@ 
         $aMediaContentTypes = array();
         $mediaCount = $this->getParentWriter()->getDrawingHashTable()->count();
         for ($i = 0; $i < $mediaCount; ++$i) {
-            $extension     = '';
-            $mimeType     = '';
+            $extension = '';
+            $mimeType = '';
 
             if ($this->getParentWriter()->getDrawingHashTable()->getByIndex($i) instanceof \PhpSpreadsheet\Worksheet\Drawing) {
                 $extension = strtolower($this->getParentWriter()->getDrawingHashTable()->getByIndex($i)->getExtension());
@@ -152,9 +152,9 @@ 
         if ($spreadsheet->hasRibbonBinObjects()) {
             // Some additional objects in the ribbon ?
             // we need to write "Extension" but not already write for media content
-            $tabRibbonTypes=array_diff($spreadsheet->getRibbonBinObjects('types'), array_keys($aMediaContentTypes));
+            $tabRibbonTypes = array_diff($spreadsheet->getRibbonBinObjects('types'), array_keys($aMediaContentTypes));
             foreach ($tabRibbonTypes as $aRibbonType) {
-                $mimeType='image/.'.$aRibbonType;//we wrote $mimeType like customUI Editor
+                $mimeType = 'image/.' . $aRibbonType; //we wrote $mimeType like customUI Editor
                 $this->writeDefaultContentType($objWriter, $aRibbonType, $mimeType);
             }
         }

src/PhpSpreadsheet/Writer/Excel2007/Comments.php

Indentation +12 added lines, -12 removed lines

@@ -45,12 +45,12 @@ 
         // XML header
         $objWriter->startDocument('1.0', 'UTF-8', 'yes');
 
-          // Comments cache
-          $comments    = $pWorksheet->getComments();
+            // Comments cache
+            $comments    = $pWorksheet->getComments();
 
-          // Authors cache
-          $authors    = array();
-          $authorId    = 0;
+            // Authors cache
+            $authors    = array();
+            $authorId    = 0;
         foreach ($comments as $comment) {
             if (!isset($authors[$comment->getAuthor()])) {
                 $authors[$comment->getAuthor()] = $authorId++;
@@ -125,8 +125,8 @@ 
         // XML header
         $objWriter->startDocument('1.0', 'UTF-8', 'yes');
 
-          // Comments cache
-          $comments    = $pWorksheet->getComments();
+            // Comments cache
+            $comments    = $pWorksheet->getComments();
 
         // xml
         $objWriter->startElement('xml');
@@ -187,11 +187,11 @@ 
      */
     private function writeVMLComment(\PhpSpreadsheet\Shared\XMLWriter $objWriter = null, $pCellReference = 'A1', \PhpSpreadsheet\Comment $pComment = null)
     {
-         // Metadata
-         list($column, $row) = \PhpSpreadsheet\Cell::coordinateFromString($pCellReference);
-         $column = \PhpSpreadsheet\Cell::columnIndexFromString($column);
-         $id = 1024 + $column + $row;
-         $id = substr($id, 0, 4);
+            // Metadata
+            list($column, $row) = \PhpSpreadsheet\Cell::coordinateFromString($pCellReference);
+            $column = \PhpSpreadsheet\Cell::columnIndexFromString($column);
+            $id = 1024 + $column + $row;
+            $id = substr($id, 0, 4);
 
         // v:shape
         $objWriter->startElement('v:shape');

src/PhpSpreadsheet/Writer/Excel2007/StringTable.php

Spacing +18 added lines, -18 removed lines

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

src/PhpSpreadsheet/Writer/Excel2007/Drawing.php

Spacing +6 added lines, -6 removed lines

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

src/PhpSpreadsheet/Chart.php

Spacing +1 added lines, -1 removed lines

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

src/PhpSpreadsheet/Shared/Excel5.php

Spacing +10 added lines, -10 removed lines

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

src/PhpSpreadsheet/Shared/OLE/PPS/Root.php

Indentation +54 added lines, -54 removed lines

@@ -50,17 +50,17 @@ 
     }
 
     /**
-    * Method for saving the whole OLE container (including files).
-    * In fact, if called with an empty argument (or '-'), it saves to a
-    * temporary file and then outputs it's contents to stdout.
-    * If a resource pointer to a stream created by fopen() is passed
-    * it will be used, but you have to close such stream by yourself.
-    *
-    * @param string|resource $filename The name of the file or stream where to save the OLE container.
-    * @access public
-    * @return mixed true on success
-    * @throws \PhpSpreadsheet\Writer\Exception
-    */
+     * Method for saving the whole OLE container (including files).
+     * In fact, if called with an empty argument (or '-'), it saves to a
+     * temporary file and then outputs it's contents to stdout.
+     * If a resource pointer to a stream created by fopen() is passed
+     * it will be used, but you have to close such stream by yourself.
+     *
+     * @param string|resource $filename The name of the file or stream where to save the OLE container.
+     * @access public
+     * @return mixed true on success
+     * @throws \PhpSpreadsheet\Writer\Exception
+     */
     public function save($filename)
     {
         // Initial Setting for saving
@@ -116,12 +116,12 @@ 
     }
 
     /**
-    * Calculate some numbers
-    *
-    * @access public
-    * @param array $raList Reference to an array of PPS's
-    * @return array The array of numbers
-    */
+     * Calculate some numbers
+     *
+     * @access public
+     * @param array $raList Reference to an array of PPS's
+     * @return array The array of numbers
+     */
     public function _calcSize(&$raList)
     {
         // Calculate Basic Setting
@@ -154,13 +154,13 @@ 
     }
 
     /**
-    * Helper function for caculating a magic value for block sizes
-    *
-    * @access public
-    * @param integer $i2 The argument
-    * @see save()
-    * @return integer
-    */
+     * Helper function for caculating a magic value for block sizes
+     *
+     * @access public
+     * @param integer $i2 The argument
+     * @see save()
+     * @return integer
+     */
     private static function adjust2($i2)
     {
         $iWk = log($i2)/log(2);
@@ -168,13 +168,13 @@ 
     }
 
     /**
-    * Save OLE header
-    *
-    * @access public
-    * @param integer $iSBDcnt
-    * @param integer $iBBcnt
-    * @param integer $iPPScnt
-    */
+     * Save OLE header
+     *
+     * @access public
+     * @param integer $iSBDcnt
+     * @param integer $iBBcnt
+     * @param integer $iPPScnt
+     */
     public function _saveHeader($iSBDcnt, $iBBcnt, $iPPScnt)
     {
         $FILE = $this->_FILEH_;
@@ -249,12 +249,12 @@ 
     }
 
     /**
-    * Saving big data (PPS's with data bigger than \PhpSpreadsheet\Shared\OLE::OLE_DATA_SIZE_SMALL)
-    *
-    * @access public
-    * @param integer $iStBlk
-    * @param array &$raList Reference to array of PPS's
-    */
+     * Saving big data (PPS's with data bigger than \PhpSpreadsheet\Shared\OLE::OLE_DATA_SIZE_SMALL)
+     *
+     * @access public
+     * @param integer $iStBlk
+     * @param array &$raList Reference to array of PPS's
+     */
     public function _saveBigData($iStBlk, &$raList)
     {
         $FILE = $this->_FILEH_;
@@ -297,11 +297,11 @@ 
     }
 
     /**
-    * get small data (PPS's with data smaller than \PhpSpreadsheet\Shared\OLE::OLE_DATA_SIZE_SMALL)
-    *
-    * @access public
-    * @param array &$raList Reference to array of PPS's
-    */
+     * get small data (PPS's with data smaller than \PhpSpreadsheet\Shared\OLE::OLE_DATA_SIZE_SMALL)
+     *
+     * @access public
+     * @param array &$raList Reference to array of PPS's
+     */
     public function _makeSmallData(&$raList)
     {
         $sRes = '';
@@ -354,11 +354,11 @@ 
     }
 
     /**
-    * Saves all the PPS's WKs
-    *
-    * @access public
-    * @param array $raList Reference to an array with all PPS's
-    */
+     * Saves all the PPS's WKs
+     *
+     * @access public
+     * @param array $raList Reference to an array with all PPS's
+     */
     public function _savePps(&$raList)
     {
         // Save each PPS WK
@@ -375,13 +375,13 @@ 
     }
 
     /**
-    * Saving Big Block Depot
-    *
-    * @access public
-    * @param integer $iSbdSize
-    * @param integer $iBsize
-    * @param integer $iPpsCnt
-    */
+     * Saving Big Block Depot
+     *
+     * @access public
+     * @param integer $iSbdSize
+     * @param integer $iBsize
+     * @param integer $iPpsCnt
+     */
     public function _saveBbd($iSbdSize, $iBsize, $iPpsCnt)
     {
         $FILE = $this->_FILEH_;

src/PhpSpreadsheet/Shared/OLE/PPS.php

Indentation +86 added lines, -86 removed lines

@@ -32,98 +32,98 @@ 
 class PPS
 {
     /**
-    * The PPS index
-    * @var integer
-    */
+     * The PPS index
+     * @var integer
+     */
     public $No;
 
     /**
-    * The PPS name (in Unicode)
-    * @var string
-    */
+     * The PPS name (in Unicode)
+     * @var string
+     */
     public $Name;
 
     /**
-    * The PPS type. Dir, Root or File
-    * @var integer
-    */
+     * The PPS type. Dir, Root or File
+     * @var integer
+     */
     public $Type;
 
     /**
-    * The index of the previous PPS
-    * @var integer
-    */
+     * The index of the previous PPS
+     * @var integer
+     */
     public $PrevPps;
 
     /**
-    * The index of the next PPS
-    * @var integer
-    */
+     * The index of the next PPS
+     * @var integer
+     */
     public $NextPps;
 
     /**
-    * The index of it's first child if this is a Dir or Root PPS
-    * @var integer
-    */
+     * The index of it's first child if this is a Dir or Root PPS
+     * @var integer
+     */
     public $DirPps;
 
     /**
-    * A timestamp
-    * @var integer
-    */
+     * A timestamp
+     * @var integer
+     */
     public $Time1st;
 
     /**
-    * A timestamp
-    * @var integer
-    */
+     * A timestamp
+     * @var integer
+     */
     public $Time2nd;
 
     /**
-    * Starting block (small or big) for this PPS's data  inside the container
-    * @var integer
-    */
+     * Starting block (small or big) for this PPS's data  inside the container
+     * @var integer
+     */
     public $startBlock;
 
     /**
-    * The size of the PPS's data (in bytes)
-    * @var integer
-    */
+     * The size of the PPS's data (in bytes)
+     * @var integer
+     */
     public $Size;
 
     /**
-    * The PPS's data (only used if it's not using a temporary file)
-    * @var string
-    */
+     * The PPS's data (only used if it's not using a temporary file)
+     * @var string
+     */
     public $_data;
 
     /**
-    * Array of child PPS's (only used by Root and Dir PPS's)
-    * @var array
-    */
+     * Array of child PPS's (only used by Root and Dir PPS's)
+     * @var array
+     */
     public $children = array();
 
     /**
-    * Pointer to OLE container
-    * @var OLE
-    */
+     * Pointer to OLE container
+     * @var OLE
+     */
     public $ole;
 
     /**
-    * The constructor
-    *
-    * @access public
-    * @param integer $No   The PPS index
-    * @param string  $name The PPS name
-    * @param integer $type The PPS type. Dir, Root or File
-    * @param integer $prev The index of the previous PPS
-    * @param integer $next The index of the next PPS
-    * @param integer $dir  The index of it's first child if this is a Dir or Root PPS
-    * @param integer $time_1st A timestamp
-    * @param integer $time_2nd A timestamp
-    * @param string  $data  The (usually binary) source data of the PPS
-    * @param array   $children Array containing children PPS for this PPS
-    */
+     * The constructor
+     *
+     * @access public
+     * @param integer $No   The PPS index
+     * @param string  $name The PPS name
+     * @param integer $type The PPS type. Dir, Root or File
+     * @param integer $prev The index of the previous PPS
+     * @param integer $next The index of the next PPS
+     * @param integer $dir  The index of it's first child if this is a Dir or Root PPS
+     * @param integer $time_1st A timestamp
+     * @param integer $time_2nd A timestamp
+     * @param string  $data  The (usually binary) source data of the PPS
+     * @param array   $children Array containing children PPS for this PPS
+     */
     public function __construct($No, $name, $type, $prev, $next, $dir, $time_1st, $time_2nd, $data, $children)
     {
         $this->No      = $No;
@@ -144,11 +144,11 @@ 
     }
 
     /**
-    * Returns the amount of data saved for this PPS
-    *
-    * @access public
-    * @return integer The amount of data (in bytes)
-    */
+     * Returns the amount of data saved for this PPS
+     *
+     * @access public
+     * @return integer The amount of data (in bytes)
+     */
     public function getDataLen()
     {
         if (!isset($this->_data)) {
@@ -164,43 +164,43 @@ 
     }
 
     /**
-    * Returns a string with the PPS's WK (What is a WK?)
-    *
-    * @access public
-    * @return string The binary string
-    */
+     * Returns a string with the PPS's WK (What is a WK?)
+     *
+     * @access public
+     * @return string The binary string
+     */
     public function _getPpsWk()
     {
         $ret = str_pad($this->Name, 64, "\x00");
 
         $ret .= pack("v", strlen($this->Name) + 2)  // 66
-              . pack("c", $this->Type)              // 67
-              . pack("c", 0x00) //UK                // 68
-              . pack("V", $this->PrevPps) //Prev    // 72
-              . pack("V", $this->NextPps) //Next    // 76
-              . pack("V", $this->DirPps)  //Dir     // 80
-              . "\x00\x09\x02\x00"                  // 84
-              . "\x00\x00\x00\x00"                  // 88
-              . "\xc0\x00\x00\x00"                  // 92
-              . "\x00\x00\x00\x46"                  // 96 // Seems to be ok only for Root
-              . "\x00\x00\x00\x00"                  // 100
-              . \PhpSpreadsheet\Shared\OLE::localDateToOLE($this->Time1st)          // 108
-              . \PhpSpreadsheet\Shared\OLE::localDateToOLE($this->Time2nd)          // 116
-              . pack("V", isset($this->startBlock) ? $this->startBlock : 0)  // 120
-              . pack("V", $this->Size)               // 124
-              . pack("V", 0);                        // 128
+                . pack("c", $this->Type)              // 67
+                . pack("c", 0x00) //UK                // 68
+                . pack("V", $this->PrevPps) //Prev    // 72
+                . pack("V", $this->NextPps) //Next    // 76
+                . pack("V", $this->DirPps)  //Dir     // 80
+                . "\x00\x09\x02\x00"                  // 84
+                . "\x00\x00\x00\x00"                  // 88
+                . "\xc0\x00\x00\x00"                  // 92
+                . "\x00\x00\x00\x46"                  // 96 // Seems to be ok only for Root
+                . "\x00\x00\x00\x00"                  // 100
+                . \PhpSpreadsheet\Shared\OLE::localDateToOLE($this->Time1st)          // 108
+                . \PhpSpreadsheet\Shared\OLE::localDateToOLE($this->Time2nd)          // 116
+                . pack("V", isset($this->startBlock) ? $this->startBlock : 0)  // 120
+                . pack("V", $this->Size)               // 124
+                . pack("V", 0);                        // 128
         return $ret;
     }
 
     /**
-    * Updates index and pointers to previous, next and children PPS's for this
-    * PPS. I don't think it'll work with Dir PPS's.
-    *
-    * @access public
-    * @param array &$raList Reference to the array of PPS's for the whole OLE
-    *                          container
-    * @return integer          The index for this PPS
-    */
+     * Updates index and pointers to previous, next and children PPS's for this
+     * PPS. I don't think it'll work with Dir PPS's.
+     *
+     * @access public
+     * @param array &$raList Reference to the array of PPS's for the whole OLE
+     *                          container
+     * @return integer          The index for this PPS
+     */
     public static function _savePpsSetPnt(&$raList, $to_save, $depth = 0)
     {
         if (!is_array($to_save) || (empty($to_save))) {

src/PhpSpreadsheet/Shared/CodePage.php

Spacing +52 added lines, -52 removed lines

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