PHPOffice / PhpSpreadsheet

docs/Examples/Calculations/Database/DCOUNT.php

Indentation +10 added lines, -10 removed lines

@@ -31,17 +31,17 @@
 
 // Add some data
 $database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
-                   ['Apple',  18,       20,    14,      105.00],
-                   ['Pear',   12,       12,    10,       96.00],
-                   ['Cherry', 13,       14,     9,      105.00],
-                   ['Apple',  14,       15,    10,       75.00],
-                   ['Pear',    9,        8,     8,       76.80],
-                   ['Apple',   8,        9,     6,       45.00],
-                 ];
+                    ['Apple',  18,       20,    14,      105.00],
+                    ['Pear',   12,       12,    10,       96.00],
+                    ['Cherry', 13,       14,     9,      105.00],
+                    ['Apple',  14,       15,    10,       75.00],
+                    ['Pear',    9,        8,     8,       76.80],
+                    ['Apple',   8,        9,     6,       45.00],
+                    ];
 $criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
-                   ['="=Pear"',  null,     null,  null,    null,     null],
-                 ];
+                    ['="=Apple"', '>10',    null,  null,    null,     '<16'],
+                    ['="=Pear"',  null,     null,  null,    null,     null],
+                    ];
 
 $worksheet->fromArray($criteria, null, 'A1');
 $worksheet->fromArray($database, null, 'A4');

Spacing +10 added lines, -10 removed lines

@@ -30,17 +30,17 @@
 $worksheet = $spreadsheet->getActiveSheet();
 
 // Add some data
-$database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
-                   ['Apple',  18,       20,    14,      105.00],
-                   ['Pear',   12,       12,    10,       96.00],
-                   ['Cherry', 13,       14,     9,      105.00],
-                   ['Apple',  14,       15,    10,       75.00],
-                   ['Pear',    9,        8,     8,       76.80],
-                   ['Apple',   8,        9,     6,       45.00],
+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
+                   ['Apple', 18, 20, 14, 105.00],
+                   ['Pear', 12, 12, 10, 96.00],
+                   ['Cherry', 13, 14, 9, 105.00],
+                   ['Apple', 14, 15, 10, 75.00],
+                   ['Pear', 9, 8, 8, 76.80],
+                   ['Apple', 8, 9, 6, 45.00],
                  ];
-$criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
-                   ['="=Pear"',  null,     null,  null,    null,     null],
+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
+                   ['="=Apple"', '>10', null, null, null, '<16'],
+                   ['="=Pear"', null, null, null, null, null],
                  ];
 
 $worksheet->fromArray($criteria, null, 'A1');

docs/Examples/Calculations/Database/DPRODUCT.php

Indentation +10 added lines, -10 removed lines

@@ -31,17 +31,17 @@
 
 // Add some data
 $database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
-                   ['Apple',  18,       20,    14,      105.00],
-                   ['Pear',   12,       12,    10,       96.00],
-                   ['Cherry', 13,       14,     9,      105.00],
-                   ['Apple',  14,       15,    10,       75.00],
-                   ['Pear',    9,        8,     8,       76.80],
-                   ['Apple',   8,        9,     6,       45.00],
-                 ];
+                    ['Apple',  18,       20,    14,      105.00],
+                    ['Pear',   12,       12,    10,       96.00],
+                    ['Cherry', 13,       14,     9,      105.00],
+                    ['Apple',  14,       15,    10,       75.00],
+                    ['Pear',    9,        8,     8,       76.80],
+                    ['Apple',   8,        9,     6,       45.00],
+                    ];
 $criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
-                   ['="=Pear"',  null,     null,  null,    null,     null],
-                 ];
+                    ['="=Apple"', '>10',    null,  null,    null,     '<16'],
+                    ['="=Pear"',  null,     null,  null,    null,     null],
+                    ];
 
 $worksheet->fromArray($criteria, null, 'A1');
 $worksheet->fromArray($database, null, 'A4');

Spacing +10 added lines, -10 removed lines

@@ -30,17 +30,17 @@
 $worksheet = $spreadsheet->getActiveSheet();
 
 // Add some data
-$database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
-                   ['Apple',  18,       20,    14,      105.00],
-                   ['Pear',   12,       12,    10,       96.00],
-                   ['Cherry', 13,       14,     9,      105.00],
-                   ['Apple',  14,       15,    10,       75.00],
-                   ['Pear',    9,        8,     8,       76.80],
-                   ['Apple',   8,        9,     6,       45.00],
+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
+                   ['Apple', 18, 20, 14, 105.00],
+                   ['Pear', 12, 12, 10, 96.00],
+                   ['Cherry', 13, 14, 9, 105.00],
+                   ['Apple', 14, 15, 10, 75.00],
+                   ['Pear', 9, 8, 8, 76.80],
+                   ['Apple', 8, 9, 6, 45.00],
                  ];
-$criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
-                   ['="=Pear"',  null,     null,  null,    null,     null],
+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
+                   ['="=Apple"', '>10', null, null, null, '<16'],
+                   ['="=Pear"', null, null, null, null, null],
                  ];
 
 $worksheet->fromArray($criteria, null, 'A1');

docs/Examples/Calculations/index.php

Spacing +2 added lines, -2 removed lines

@@ -36,9 +36,9 @@
             $h1Text = $out[1];
             $h2Text = (preg_match($h2Pattern, $fileData, $out)) ? $out[1] : '';
 
-            echo '<a href="',$exampleFile,'">',$h1Text,'</a><br />';
+            echo '<a href="', $exampleFile, '">', $h1Text, '</a><br />';
             if ($h2Text > '') {
-                echo $h2Text,'<br />';
+                echo $h2Text, '<br />';
             }
         }
     }

src/PhpSpreadsheet/Writer/Xls/Font.php

Spacing +5 added lines, -5 removed lines

@@ -82,9 +82,9 @@ 
         $bFamily = 0; // Font family
         $bCharSet = \PhpOffice\PhpSpreadsheet\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;
         }
@@ -132,10 +132,10 @@ 
     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/Reader/exampleReader14.php

Spacing +1 added lines, -1 removed lines

@@ -62,7 +62,7 @@
     }
 }
 
-echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />';
+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />';
 /*  Create a new Reader of the type defined in $inputFileType  **/
 $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType);
 

Indentation +1 added lines, -1 removed lines

@@ -68,7 +68,7 @@
 /*  Tell the Reader that we want to use the Read Filter that we've Instantiated  **/
 /*    and that we want to store it in contiguous rows/columns  **/
 $reader->setReadFilter($chunkFilter)
-          ->setContiguous(true);
+            ->setContiguous(true);
 
 /*  Instantiate a new PhpSpreadsheet object manually  **/
 $spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet();

src/PhpSpreadsheet/Chart/DataSeriesValues.php

Doc Comments +2 added lines, -2 removed lines

@@ -79,10 +79,10 @@
     /**
      * Create a new DataSeriesValues object.
      *
-     * @param mixed $dataType
+     * @param string $dataType
      * @param string $dataSource
      * @param null|mixed $formatCode
-     * @param mixed $pointCount
+     * @param integer $pointCount
      * @param mixed $dataValues
      * @param null|mixed $marker
      */

src/PhpSpreadsheet/Calculation/LookupRef.php

Doc Comments +10 added lines, -10 removed lines

@@ -36,7 +36,7 @@ 
      *
      * @param row Row number to use in the cell reference
      * @param column Column number to use in the cell reference
-     * @param relativity Flag indicating the type of reference to return
+     * @param relativity integer indicating the type of reference to return
      *                                1 or omitted    Absolute
      *                                2                Absolute row; relative column
      *                                3                Relative row; absolute column
@@ -47,7 +47,7 @@ 
      * @param sheetText Optional Name of worksheet to use
      * @param mixed $row
      * @param mixed $column
-     * @param mixed $relativity
+     * @param integer $relativity
      * @param mixed $referenceStyle
      * @param mixed $sheetText
      *
@@ -358,7 +358,7 @@ 
      *
      * @param cellAddress The reference from which you want to base the offset. Reference must refer to a cell or
      *                                range of adjacent cells; otherwise, OFFSET returns the #VALUE! error value.
-     * @param rows The number of rows, up or down, that you want the upper-left cell to refer to.
+     * @param rows integer number of rows, up or down, that you want the upper-left cell to refer to.
      *                                Using 5 as the rows argument specifies that the upper-left cell in the reference is
      *                                five rows below reference. Rows can be positive (which means below the starting reference)
      *                                or negative (which means above the starting reference).
@@ -370,8 +370,8 @@ 
      * @param height The height, in number of rows, that you want the returned reference to be. Height must be a positive number.
      * @param width The width, in number of columns, that you want the returned reference to be. Width must be a positive number.
      * @param null|mixed $cellAddress
-     * @param mixed $rows
-     * @param mixed $columns
+     * @param integer $rows
+     * @param integer $columns
      * @param null|mixed $height
      * @param null|mixed $width
      * @param \PhpOffice\PhpSpreadsheet\Cell $pCell
@@ -499,7 +499,7 @@ 
      *
      * @param mixed $lookupValue The value that you want to match in lookup_array
      * @param mixed $lookupArray The range of cells being searched
-     * @param mixed $matchType The number -1, 0, or 1. -1 means above, 0 means exact match, 1 means below. If match_type is 1 or -1, the list has to be ordered.
+     * @param integer $matchType The number -1, 0, or 1. -1 means above, 0 means exact match, 1 means below. If match_type is 1 or -1, the list has to be ordered.
      *
      * @return int The relative position of the found item
      */
@@ -613,8 +613,8 @@ 
      * @param row_num The row in array from which to return a value. If row_num is omitted, column_num is required.
      * @param column_num The column in array from which to return a value. If column_num is omitted, row_num is required.
      * @param mixed $arrayValues
-     * @param mixed $rowNum
-     * @param mixed $columnNum
+     * @param integer $rowNum
+     * @param integer $columnNum
      *
      * @return mixed the value of a specified cell or array of cells
      */
@@ -710,11 +710,11 @@ 
      *
      * @param lookup_value The value that you want to match in lookup_array
      * @param lookup_array The range of cells being searched
-     * @param index_number The column number in table_array from which the matching value must be returned. The first column is 1.
+     * @param index_number integer column number in table_array from which the matching value must be returned. The first column is 1.
      * @param not_exact_match determines if you are looking for an exact match based on lookup_value
      * @param mixed $lookup_value
      * @param mixed $lookup_array
-     * @param mixed $index_number
+     * @param integer $index_number
      * @param mixed $not_exact_match
      *
      * @return mixed The value of the found cell

docs/Examples/Reading WorkBook Data/exampleWorkBookReader04.php

Spacing +2 added lines, -2 removed lines

@@ -34,13 +34,13 @@
 echo 'Reading the number of Worksheets in the WorkBook<br />';
 /*  Use the PhpSpreadsheet object's getSheetCount() method to get a count of the number of WorkSheets in the WorkBook  */
 $sheetCount = $spreadsheet->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 PhpSpreadsheet object's getSheetNames() method to get an array listing the names/titles of the WorkSheets in the WorkBook  */
 $sheetNames = $spreadsheet->getSheetNames();
 foreach ($sheetNames as $sheetIndex => $sheetName) {
-    echo 'WorkSheet #',$sheetIndex,' is named "',$sheetName,'"<br />';
+    echo 'WorkSheet #', $sheetIndex, ' is named "', $sheetName, '"<br />';
 }
 
 ?>

docs/Examples/Reader/exampleReader16.php

Spacing +1 added lines, -1 removed lines

@@ -22,7 +22,7 @@
 require_once __DIR__ . '/../../../src/Bootstrap.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 {
     $spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load($inputFileName);
 } catch (\InvalidArgumentException $e) {