PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Writer/Xls/Parser.php

Doc Comments +9 added lines, -9 removed lines

@@ -505,7 +505,7 @@ 
      *
      * @param mixed $token the token to convert
      *
-     * @return mixed the converted token on success
+     * @return string the converted token on success
      */
     private function convert($token)
     {
@@ -576,7 +576,7 @@ 
      *
      * @param string $string a string for conversion to its ptg value
      *
-     * @return mixed the converted token on success
+     * @return string the converted token on success
      */
     private function convertString($string)
     {
@@ -654,7 +654,7 @@ 
      *
      * @param string $token an Excel range in the Sheet1!A1:A2 format
      *
-     * @return mixed the packed ptgArea3d token on success
+     * @return string the packed ptgArea3d token on success
      */
     private function convertRange3d($token)
     {
@@ -706,7 +706,7 @@ 
      *
      * @param string $cell An Excel cell reference
      *
-     * @return mixed the packed ptgRef3d token on success
+     * @return string the packed ptgRef3d token on success
      */
     private function convertRef3d($cell)
     {
@@ -805,7 +805,7 @@ 
      *
      * @param string $ext_ref The name of the external reference
      *
-     * @return mixed The reference index in packed() format on success
+     * @return string The reference index in packed() format on success
      */
     private function getRefIndex($ext_ref)
     {
@@ -896,7 +896,7 @@ 
      *
      * @param string $cell The Excel cell reference to be packed
      *
-     * @return array Array containing the row and column in packed() format
+     * @return string[] Array containing the row and column in packed() format
      */
     private function cellToPackedRowcol($cell)
     {
@@ -925,7 +925,7 @@ 
      *
      * @param string $range The Excel range to be packed
      *
-     * @return array Array containing (row1,col1,row2,col2) in packed() format
+     * @return string[] Array containing (row1,col1,row2,col2) in packed() format
      */
     private function rangeToPackedRange($range)
     {
@@ -1041,7 +1041,7 @@ 
     /**
      * Checks if it's a valid token.
      *
-     * @param mixed $token the token to check
+     * @param string $token the token to check
      *
      * @return mixed The checked token or false on failure
      */
@@ -1127,7 +1127,7 @@ 
      * @param string $formula the formula to parse, without the initial equal
      *                        sign (=)
      *
-     * @return mixed true on success
+     * @return boolean true on success
      */
     public function parse($formula)
     {

src/PhpSpreadsheet/Writer/Xlsx/Chart.php

Doc Comments +6 added lines, -6 removed lines

@@ -410,8 +410,8 @@ 
      * @param string $id1
      * @param string $id2
      * @param bool $isMultiLevelSeries
-     * @param mixed $xAxis
-     * @param mixed $yAxis
+     * @param null|Axis $xAxis
+     * @param null|Axis $yAxis
      *
      * @throws \PhpOffice\PhpSpreadsheet\Writer\Exception
      */
@@ -533,10 +533,10 @@ 
      * @param string $id1
      * @param string $id2
      * @param bool $isMultiLevelSeries
-     * @param mixed $xAxis
-     * @param mixed $yAxis
-     * @param mixed $majorGridlines
-     * @param mixed $minorGridlines
+     * @param null|Axis $xAxis
+     * @param null|Axis $yAxis
+     * @param null|GridLines $majorGridlines
+     * @param null|GridLines $minorGridlines
      *
      * @throws \PhpOffice\PhpSpreadsheet\Writer\Exception
      */

docs/Examples/Reader/exampleReader02.php

Spacing +1 added lines, -1 removed lines

@@ -27,7 +27,7 @@
 
 $inputFileName = './sampleData/example1.xls';
 
-echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using \PhpOffice\PhpSpreadsheet\Reader\Xls<br />';
+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using \PhpOffice\PhpSpreadsheet\Reader\Xls<br />';
 $reader = new \PhpOffice\PhpSpreadsheet\Reader\Xls();
 //	$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
 //	$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xml();

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 = $spreadsheet->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 = $spreadsheet->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 = $spreadsheet->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 = $spreadsheet->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 = $spreadsheet->getProperties()->getTitle();
-echo '<b>Title: </b>',$workbookTitle,'<br />';
+echo '<b>Title: </b>', $workbookTitle, '<br />';
 
 /*  Read the workbook description property  **/
 $description = $spreadsheet->getProperties()->getDescription();
-echo '<b>Description: </b>',$description,'<br />';
+echo '<b>Description: </b>', $description, '<br />';
 
 /*  Read the workbook subject property  **/
 $subject = $spreadsheet->getProperties()->getSubject();
-echo '<b>Subject: </b>',$subject,'<br />';
+echo '<b>Subject: </b>', $subject, '<br />';
 
 /*  Read the workbook keywords property  **/
 $keywords = $spreadsheet->getProperties()->getKeywords();
-echo '<b>Keywords: </b>',$keywords,'<br />';
+echo '<b>Keywords: </b>', $keywords, '<br />';
 
 /*  Read the workbook category property  **/
 $category = $spreadsheet->getProperties()->getCategory();
-echo '<b>Category: </b>',$category,'<br />';
+echo '<b>Category: </b>', $category, '<br />';
 
 /*  Read the workbook company property  **/
 $company = $spreadsheet->getProperties()->getCompany();
-echo '<b>Company: </b>',$company,'<br />';
+echo '<b>Company: </b>', $company, '<br />';
 
 /*  Read the workbook manager property  **/
 $manager = $spreadsheet->getProperties()->getManager();
-echo '<b>Manager: </b>',$manager,'<br />';
+echo '<b>Manager: </b>', $manager, '<br />';
 
 ?>
 <body>

docs/Examples/Calculations/Database/DAVERAGE.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/DVARP.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/DSTDEVP.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/DVAR.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/DSTDEV.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');