PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Writer/Xlsx.php

Indentation +2 added lines, -2 removed lines

@@ -140,8 +140,8 @@
         }
 
         $hashTablesArray = ['stylesConditionalHashTable', 'fillHashTable', 'fontHashTable',
-                                  'bordersHashTable', 'numFmtHashTable', 'drawingHashTable',
-                                  'styleHashTable',
+                                    'bordersHashTable', 'numFmtHashTable', 'drawingHashTable',
+                                    'styleHashTable',
                                 ];
 
         // Set HashTable variables

src/PhpSpreadsheet/Reader/Xls.php

Doc Comments +5 added lines, -5 removed lines

@@ -5157,7 +5157,7 @@ 
      * is in one piece.
      * Moves to next current position in data stream to start of next record different from a CONtINUE record
      *
-     * @return array
+     * @return integer|null
      */
     private function getSplicedRecordData()
     {
@@ -5421,7 +5421,7 @@ 
      * @param string $formulaData Formula data
      * @param string $baseCell Base cell, only needed when formula contains tRefN tokens, e.g. with shared formulas
      * @throws Exception
-     * @return array
+     * @return string
      */
     private function getNextToken($formulaData, $baseCell = 'A1')
     {
@@ -6989,7 +6989,7 @@ 
      * section 2.5.15
      *
      * @param string $subData
-     * @return array
+     * @return string
      */
     private function readBIFF8CellRangeAddressList($subData)
     {
@@ -7100,7 +7100,7 @@ 
      * section 2.5.8
      *
      * @param string $arrayData
-     * @return array
+     * @return string
      */
     private static function readBIFF8ConstantArray($arrayData)
     {
@@ -7138,7 +7138,7 @@ 
      * returns e.g. array('value' => '5', 'size' => 9)
      *
      * @param string $valueData
-     * @return array
+     * @return string
      */
     private static function readBIFF8Constant($valueData)
     {

src/PhpSpreadsheet/Reader/Xls/MD5.php

Doc Comments +5 added lines

@@ -190,6 +190,11 @@
         return ($Y ^ ($X | (~ $Z))) ; // Y XOR (X OR NOT Z)
     }
 
+    /**
+     * @param string[] $func
+     * @param integer $s
+     * @param integer $t
+     */
     private static function step($func, &$A, $B, $C, $D, $M, $s, $t)
     {
         $A = ($A + call_user_func($func, $B, $C, $D) + $M + $t) & 0xffffffff;

src/PhpSpreadsheet/Writer/Xls/Worksheet.php

Indentation +8 added lines, -8 removed lines

@@ -1147,14 +1147,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     .

Doc Comments +9 added lines, -7 removed lines

@@ -223,10 +223,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 bool $preCalculateFormulas Flag indicating whether formulas should be calculated or just written
      * @param string $phpSheet The worksheet to write
      * @param \PhpOffice\PhpSpreadsheet\Worksheet $phpSheet
+     * @param integer $str_total
+     * @param integer $str_unique
      */
     public function __construct(&$str_total, &$str_unique, &$str_table, &$colors, $parser, $preCalculateFormulas, $phpSheet)
     {
@@ -624,7 +626,7 @@ 
      * @param int $row Zero indexed row
      * @param int $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 int
      */
@@ -733,7 +735,7 @@ 
      * @param int $row Zero indexed row
      * @param int $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 int
      */
@@ -800,7 +802,7 @@ 
      *
      * @param int $row Zero indexed row
      * @param int $col Zero indexed column
-     * @param mixed $xfIndex The XF format index
+     * @param integer $xfIndex The XF format index
      */
     public function writeBlank($row, $col, $xfIndex)
     {
@@ -847,7 +849,7 @@ 
      * @param int $row Zero indexed row
      * @param int $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 int
@@ -2327,8 +2329,8 @@ 
      * @param mixed $bitmap The bitmap filename or GD-image resource
      * @param int $x the horizontal position (offset) of the image inside the cell
      * @param int $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)
     {

src/PhpSpreadsheet/Writer/Xls/Font.php

Spacing +5 added lines, -5 removed lines

@@ -85,9 +85,9 @@ 
         $bFamily = 0; // Font family
         $bCharSet = \PHPExcel\Shared\Font::getCharsetFromFontName($this->font->getName()); // Character set
 
-        $record = 0x31;        // Record identifier
-        $reserved = 0x00;    // Reserved
-        $grbit = 0x00;        // Font attributes
+        $record = 0x31; // Record identifier
+        $reserved = 0x00; // Reserved
+        $grbit = 0x00; // Font attributes
         if ($this->font->getItalic()) {
             $grbit |= 0x02;
         }
@@ -134,9 +134,9 @@ 
     private static function mapBold($bold)
     {
         if ($bold) {
-            return 0x2BC;  //  700 = Bold font weight
+            return 0x2BC; //  700 = Bold font weight
         }
-        return 0x190;      //  400 = Normal font weight
+        return 0x190; //  400 = Normal font weight
     }
 
     /**

docs/Examples/Reading WorkBook Data/exampleWorkBookReader01.php

Spacing +11 added lines, -11 removed lines

@@ -37,53 +37,53 @@
 
 /*  Read the document's creator property  **/
 $creator = $objPHPExcel->getProperties()->getCreator();
-echo '<b>Document Creator: </b>',$creator,'<br />';
+echo '<b>Document Creator: </b>', $creator, '<br />';
 
 /*  Read the Date when the workbook was created (as a PHP timestamp value)  **/
 $creationDatestamp = $objPHPExcel->getProperties()->getCreated();
 /*  Format the date and time using the standard PHP date() function  **/
 $creationDate = date('l, d<\s\up>S</\s\up> F Y', $creationDatestamp);
 $creationTime = date('g:i A', $creationDatestamp);
-echo '<b>Created On: </b>',$creationDate,' at ',$creationTime,'<br />';
+echo '<b>Created On: </b>', $creationDate, ' at ', $creationTime, '<br />';
 
 /*  Read the name of the last person to modify this workbook  **/
 $modifiedBy = $objPHPExcel->getProperties()->getLastModifiedBy();
-echo '<b>Last Modified By: </b>',$modifiedBy,'<br />';
+echo '<b>Last Modified By: </b>', $modifiedBy, '<br />';
 
 /*  Read the Date when the workbook was last modified (as a PHP timestamp value)  **/
 $modifiedDatestamp = $objPHPExcel->getProperties()->getModified();
 /*  Format the date and time using the standard PHP date() function  **/
 $modifiedDate = date('l, d<\s\up>S</\s\up> F Y', $modifiedDatestamp);
 $modifiedTime = date('g:i A', $modifiedDatestamp);
-echo '<b>Last Modified On: </b>',$modifiedDate,' at ',$modifiedTime,'<br />';
+echo '<b>Last Modified On: </b>', $modifiedDate, ' at ', $modifiedTime, '<br />';
 
 /*  Read the workbook title property  **/
 $workbookTitle = $objPHPExcel->getProperties()->getTitle();
-echo '<b>Title: </b>',$workbookTitle,'<br />';
+echo '<b>Title: </b>', $workbookTitle, '<br />';
 
 /*  Read the workbook description property  **/
 $description = $objPHPExcel->getProperties()->getDescription();
-echo '<b>Description: </b>',$description,'<br />';
+echo '<b>Description: </b>', $description, '<br />';
 
 /*  Read the workbook subject property  **/
 $subject = $objPHPExcel->getProperties()->getSubject();
-echo '<b>Subject: </b>',$subject,'<br />';
+echo '<b>Subject: </b>', $subject, '<br />';
 
 /*  Read the workbook keywords property  **/
 $keywords = $objPHPExcel->getProperties()->getKeywords();
-echo '<b>Keywords: </b>',$keywords,'<br />';
+echo '<b>Keywords: </b>', $keywords, '<br />';
 
 /*  Read the workbook category property  **/
 $category = $objPHPExcel->getProperties()->getCategory();
-echo '<b>Category: </b>',$category,'<br />';
+echo '<b>Category: </b>', $category, '<br />';
 
 /*  Read the workbook company property  **/
 $company = $objPHPExcel->getProperties()->getCompany();
-echo '<b>Company: </b>',$company,'<br />';
+echo '<b>Company: </b>', $company, '<br />';
 
 /*  Read the workbook manager property  **/
 $manager = $objPHPExcel->getProperties()->getManager();
-echo '<b>Manager: </b>',$manager,'<br />';
+echo '<b>Manager: </b>', $manager, '<br />';
 
 ?>
 <body>

docs/Examples/Reading WorkBook Data/exampleWorkBookReader04.php

Spacing +2 added lines, -2 removed lines

@@ -38,13 +38,13 @@
 echo 'Reading the number of Worksheets in the WorkBook<br />';
 /*  Use the PHPExcel object's getSheetCount() method to get a count of the number of WorkSheets in the WorkBook  */
 $sheetCount = $objPHPExcel->getSheetCount();
-echo 'There ',(($sheetCount == 1) ? 'is' : 'are'),' ',$sheetCount,' WorkSheet',(($sheetCount == 1) ? '' : 's'),' in the WorkBook<br /><br />';
+echo 'There ', (($sheetCount == 1) ? 'is' : 'are'), ' ', $sheetCount, ' WorkSheet', (($sheetCount == 1) ? '' : 's'), ' in the WorkBook<br /><br />';
 
 echo 'Reading the names of Worksheets in the WorkBook<br />';
 /*  Use the PHPExcel object's getSheetNames() method to get an array listing the names/titles of the WorkSheets in the WorkBook  */
 $sheetNames = $objPHPExcel->getSheetNames();
 foreach ($sheetNames as $sheetIndex => $sheetName) {
-    echo 'WorkSheet #',$sheetIndex,' is named "',$sheetName,'"<br />';
+    echo 'WorkSheet #', $sheetIndex, ' is named "', $sheetName, '"<br />';
 }
 
 ?>

docs/Examples/Reader/exampleReader04.php

Spacing +2 added lines, -2 removed lines

@@ -28,9 +28,9 @@
 $inputFileName = './sampleData/example1.xls';
 
 $inputFileType = PHPExcel_IOFactory::identify($inputFileName);
-echo 'File ',pathinfo($inputFileName, PATHINFO_BASENAME),' has been identified as an ',$inputFileType,' file<br />';
+echo 'File ', pathinfo($inputFileName, PATHINFO_BASENAME), ' has been identified as an ', $inputFileType, ' file<br />';
 
-echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory with the identified reader type<br />';
+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with the identified reader type<br />';
 $objReader = PHPExcel_IOFactory::createReader($inputFileType);
 $objPHPExcel = $objReader->load($inputFileName);
 

docs/Examples/Reader/exampleReader01.php

Spacing +1 added lines, -1 removed lines

@@ -26,7 +26,7 @@
 include 'PHPExcel/IOFactory.php';
 
 $inputFileName = './sampleData/example_1.xls';
-echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory to identify the format<br />';
+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory to identify the format<br />';
 try {
     $objPHPExcel = PHPExcel_IOFactory::load($inputFileName);
 } catch (\PHPExcel\Reader\Exception $e) {