PHPOffice / PhpSpreadsheet

Documentation/Examples/Reader/exampleReader19.php

Indentation +4 added lines, -4 removed lines

@@ -41,10 +41,10 @@
 echo '<h3>Worksheet Information</h3>';
 echo '<ol>';
 foreach ($worksheetData as $worksheet) {
-	echo '<li>', $worksheet['worksheetName'], '<br />';
-	echo 'Rows: ', $worksheet['totalRows'], ' Columns: ', $worksheet['totalColumns'], '<br />';
-	echo 'Cell Range: A1:', $worksheet['lastColumnLetter'], $worksheet['totalRows'];
-	echo '</li>';
+    echo '<li>', $worksheet['worksheetName'], '<br />';
+    echo 'Rows: ', $worksheet['totalRows'], ' Columns: ', $worksheet['totalColumns'], '<br />';
+    echo 'Cell Range: A1:', $worksheet['lastColumnLetter'], $worksheet['totalRows'];
+    echo '</li>';
 }
 echo '</ol>';
 

Spacing +1 added lines, -1 removed lines

@@ -33,7 +33,7 @@
 //	$inputFileType = 'Gnumeric';
 $inputFileName = './sampleData/example1.xls';
 
-echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' information using IOFactory with a defined reader type of ',$inputFileType,'<br />';
+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' information using IOFactory with a defined reader type of ', $inputFileType, '<br />';
 
 $objReader = PHPExcel_IOFactory::createReader($inputFileType);
 $worksheetData = $objReader->listWorksheetInfo($inputFileName);

Documentation/Examples/index.php

Indentation +16 added lines, -16 removed lines

@@ -21,28 +21,28 @@
 

 foreach($exampleTypeList as $exampleType) {

 

-	echo '<h1>PHPExcel ' . pathinfo($exampleType,PATHINFO_BASENAME) . ' Examples</h1>';

+    echo '<h1>PHPExcel ' . pathinfo($exampleType,PATHINFO_BASENAME) . ' Examples</h1>';

 

-	$exampleList = glob('./'.$exampleType.'/*.php');

+    $exampleList = glob('./'.$exampleType.'/*.php');

 

-	foreach($exampleList as $exampleFile) {

-		$fileData = file_get_contents($exampleFile);

+    foreach($exampleList as $exampleFile) {

+        $fileData = file_get_contents($exampleFile);

 

-		$h1Pattern = '#<h1>(.*?)</h1>#';

-		$h2Pattern = '#<h2>(.*?)</h2>#';

+        $h1Pattern = '#<h1>(.*?)</h1>#';

+        $h2Pattern = '#<h2>(.*?)</h2>#';

 

-		if (preg_match($h1Pattern, $fileData, $out)) {

-			$h1Text = $out[1];

-			$h2Text = (preg_match($h2Pattern, $fileData, $out)) ? $out[1] : '';

+        if (preg_match($h1Pattern, $fileData, $out)) {

+            $h1Text = $out[1];

+            $h2Text = (preg_match($h2Pattern, $fileData, $out)) ? $out[1] : '';

 

-			echo '<a href="',$exampleFile,'">',$h1Text,'</a><br />';

-			if (($h2Text > '') &&

-				(pathinfo($exampleType,PATHINFO_BASENAME) != 'Calculations')) {

-				echo $h2Text,'<br />';

-			}

-		}

+            echo '<a href="',$exampleFile,'">',$h1Text,'</a><br />';

+            if (($h2Text > '') &&

+                (pathinfo($exampleType,PATHINFO_BASENAME) != 'Calculations')) {

+                echo $h2Text,'<br />';

+            }

+        }

 

-	}

+    }

 }

 

 ?>

Spacing +8 added lines, -8 removed lines

@@ -17,15 +17,15 @@ 
 

 <?php

 

-$exampleTypeList = glob('./*',GLOB_ONLYDIR);

+$exampleTypeList = glob('./*', GLOB_ONLYDIR);

 

-foreach($exampleTypeList as $exampleType) {

+foreach ($exampleTypeList as $exampleType) {

 

-	echo '<h1>PHPExcel ' . pathinfo($exampleType,PATHINFO_BASENAME) . ' Examples</h1>';

+	echo '<h1>PHPExcel ' . pathinfo($exampleType, PATHINFO_BASENAME) . ' Examples</h1>';

 

-	$exampleList = glob('./'.$exampleType.'/*.php');

+	$exampleList = glob('./' . $exampleType . '/*.php');

 

-	foreach($exampleList as $exampleFile) {

+	foreach ($exampleList as $exampleFile) {

 		$fileData = file_get_contents($exampleFile);

 

 		$h1Pattern = '#<h1>(.*?)</h1>#';

@@ -35,10 +35,10 @@ 
 			$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 > '') &&

-				(pathinfo($exampleType,PATHINFO_BASENAME) != 'Calculations')) {

-				echo $h2Text,'<br />';

+				(pathinfo($exampleType, PATHINFO_BASENAME) != 'Calculations')) {

+				echo $h2Text, '<br />';

 			}

 		}

 

src/PhpSpreadsheet/Style.php

Spacing +1 added lines, -1 removed lines

@@ -618,7 +618,7 @@
             $this->numberFormat->getHashCode() .
             $hashConditionals .
             $this->protection->getHashCode() .
-            ($this->quotePrefix  ? 't' : 'f') .
+            ($this->quotePrefix ? 't' : 'f') .
             __CLASS__
         );
     }

Doc Comments +1 added lines, -1 removed lines

@@ -147,7 +147,7 @@
     /**
      * Get parent. Only used for style supervisor
      *
-     * @return PhpSpreadsheet
+     * @return Style
      */
     public function getParent()
     {

src/PhpSpreadsheet/ReferenceHelper.php

Indentation +1 added lines, -1 removed lines

@@ -450,7 +450,7 @@
                 if ($cell->getDataType() == Cell\DataType::TYPE_FORMULA) {
                     // Formula should be adjusted
                     $pSheet->getCell($newCoordinates)
-                           ->setValue($this->updateFormulaReferences($cell->getValue(), $pBefore, $pNumCols, $pNumRows, $pSheet->getTitle()));
+                            ->setValue($this->updateFormulaReferences($cell->getValue(), $pBefore, $pNumCols, $pNumRows, $pSheet->getTitle()));
                 } else {
                     // Formula should not be adjusted
                     $pSheet->getCell($newCoordinates)->setValue($cell->getValue());

Spacing +4 added lines, -8 removed lines

@@ -169,8 +169,7 @@ 
     {
         $aBreaks = $pSheet->getBreaks();
         ($pNumCols > 0 || $pNumRows > 0) ?
-            uksort($aBreaks, ['self', 'cellReverseSort']) :
-            uksort($aBreaks, ['self', 'cellSort']);
+            uksort($aBreaks, ['self', 'cellReverseSort']) : uksort($aBreaks, ['self', 'cellSort']);
 
         foreach ($aBreaks as $key => $value) {
             if (self::cellAddressInDeleteRange($key, $beforeRow, $pNumRows, $beforeColumnIndex, $pNumCols)) {
@@ -230,8 +229,7 @@ 
     {
         $aHyperlinkCollection = $pSheet->getHyperlinkCollection();
         ($pNumCols > 0 || $pNumRows > 0) ?
-            uksort($aHyperlinkCollection, ['self', 'cellReverseSort']) :
-            uksort($aHyperlinkCollection, ['self', 'cellSort']);
+            uksort($aHyperlinkCollection, ['self', 'cellReverseSort']) : uksort($aHyperlinkCollection, ['self', 'cellSort']);
 
         foreach ($aHyperlinkCollection as $key => $value) {
             $newReference = $this->updateCellReference($key, $pBefore, $pNumCols, $pNumRows);
@@ -256,8 +254,7 @@ 
     {
         $aDataValidationCollection = $pSheet->getDataValidationCollection();
         ($pNumCols > 0 || $pNumRows > 0) ?
-            uksort($aDataValidationCollection, ['self', 'cellReverseSort']) :
-            uksort($aDataValidationCollection, ['self', 'cellSort']);
+            uksort($aDataValidationCollection, ['self', 'cellReverseSort']) : uksort($aDataValidationCollection, ['self', 'cellSort']);
 
         foreach ($aDataValidationCollection as $key => $value) {
             $newReference = $this->updateCellReference($key, $pBefore, $pNumCols, $pNumRows);
@@ -303,8 +300,7 @@ 
     {
         $aProtectedCells = $pSheet->getProtectedCells();
         ($pNumCols > 0 || $pNumRows > 0) ?
-            uksort($aProtectedCells, ['self', 'cellReverseSort']) :
-            uksort($aProtectedCells, ['self', 'cellSort']);
+            uksort($aProtectedCells, ['self', 'cellReverseSort']) : uksort($aProtectedCells, ['self', 'cellSort']);
         foreach ($aProtectedCells as $key => $value) {
             $newReference = $this->updateCellReference($key, $pBefore, $pNumCols, $pNumRows);
             if ($key != $newReference) {

src/PhpSpreadsheet/Writer/Excel5/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
     }
 
     /**

src/PhpSpreadsheet/Writer/Excel2007/Rels.php

Spacing +1 added lines, -1 removed lines

@@ -168,7 +168,7 @@
                 'http://schemas.microsoft.com/office/2006/relationships/vbaProject',
                 'vbaProject.bin'
             );
-            ++$i;//increment i if needed for an another relation
+            ++$i; //increment i if needed for an another relation
         }
 
         $objWriter->endElement();

src/PhpSpreadsheet/Writer/PDF/DomPDF.php

Spacing +1 added lines, -1 removed lines

@@ -58,7 +58,7 @@
         $fileHandle = parent::prepareForSave($pFilename);
 
         //  Default PDF paper size
-        $paperSize = 'LETTER';    //    Letter    (8.5 in. by 11 in.)
+        $paperSize = 'LETTER'; //    Letter    (8.5 in. by 11 in.)
 
         //  Check for paper size and page orientation
         if (is_null($this->getSheetIndex())) {

Documentation/Examples/Reader/exampleReader03.php

Spacing +2 added lines, -2 removed lines

@@ -33,7 +33,7 @@ 
 //	$inputFileType = 'Gnumeric';

 $inputFileName = './sampleData/example1.xls';

 

-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 />';

 $objReader = PHPExcel_IOFactory::createReader($inputFileType);

 echo 'Turning Formatting off for Load<br />';

 $objReader->setReadDataOnly(true);

@@ -42,7 +42,7 @@ 
 

 echo '<hr />';

 

-$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);

+$sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);

 var_dump($sheetData);

 

 

Documentation/Examples/Calculations/Database/DPRODUCT.php

Indentation +10 added lines, -10 removed lines

@@ -33,17 +33,17 @@
 

 // Add some data

 $database = array( array( 'Tree',  'Height', 'Age', 'Yield', 'Profit' ),

-                   array( 'Apple',  18,       20,    14,      105.00  ),

-                   array( 'Pear',   12,       12,    10,       96.00  ),

-                   array( 'Cherry', 13,       14,     9,      105.00  ),

-                   array( 'Apple',  14,       15,    10,       75.00  ),

-                   array( 'Pear',    9,        8,     8,       76.80  ),

-                   array( 'Apple',   8,        9,     6,       45.00  ),

-                 );

+                    array( 'Apple',  18,       20,    14,      105.00  ),

+                    array( 'Pear',   12,       12,    10,       96.00  ),

+                    array( 'Cherry', 13,       14,     9,      105.00  ),

+                    array( 'Apple',  14,       15,    10,       75.00  ),

+                    array( 'Pear',    9,        8,     8,       76.80  ),

+                    array( 'Apple',   8,        9,     6,       45.00  ),

+                    );

 $criteria = array( array( 'Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height' ),

-                   array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),

-                   array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )

-                 );

+                    array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),

+                    array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )

+                    );

 

 $worksheet->fromArray( $criteria, NULL, 'A1' );

 $worksheet->fromArray( $database, NULL, 'A4' );

Spacing +17 added lines, -17 removed lines

@@ -32,21 +32,21 @@ 
 $worksheet = $objPHPExcel->getActiveSheet();

 

 // Add some data

-$database = array( array( 'Tree',  'Height', 'Age', 'Yield', 'Profit' ),

-                   array( 'Apple',  18,       20,    14,      105.00  ),

-                   array( 'Pear',   12,       12,    10,       96.00  ),

-                   array( 'Cherry', 13,       14,     9,      105.00  ),

-                   array( 'Apple',  14,       15,    10,       75.00  ),

-                   array( 'Pear',    9,        8,     8,       76.80  ),

-                   array( 'Apple',   8,        9,     6,       45.00  ),

+$database = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit'),

+                   array('Apple', 18, 20, 14, 105.00),

+                   array('Pear', 12, 12, 10, 96.00),

+                   array('Cherry', 13, 14, 9, 105.00),

+                   array('Apple', 14, 15, 10, 75.00),

+                   array('Pear', 9, 8, 8, 76.80),

+                   array('Apple', 8, 9, 6, 45.00),

                  );

-$criteria = array( array( 'Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height' ),

-                   array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),

-                   array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )

+$criteria = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'),

+                   array('="=Apple"', '>10', NULL, NULL, NULL, '<16'),

+                   array('="=Pear"', NULL, NULL, NULL, NULL, NULL)

                  );

 

-$worksheet->fromArray( $criteria, NULL, 'A1' );

-$worksheet->fromArray( $database, NULL, 'A4' );

+$worksheet->fromArray($criteria, NULL, 'A1');

+$worksheet->fromArray($database, NULL, 'A4');

 

 $worksheet->setCellValue('A12', 'The height of the Apple tree between 10\' and 16\' tall');

 $worksheet->setCellValue('B12', '=DGET(A4:E10,"Height",A1:F2)');

@@ -57,7 +57,7 @@ 
 

 echo '<h4>Database</h4>';

 

-$databaseData = $worksheet->rangeToArray('A4:E10',null,true,true,true);

+$databaseData = $worksheet->rangeToArray('A4:E10', null, true, true, true);

 var_dump($databaseData);

 

 

@@ -69,15 +69,15 @@ 
 

 echo 'ALL' . '<br /><br />';

 

-echo $worksheet->getCell("A12")->getValue() .'<br />';

-echo 'DMAX() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() .'<br /><br />';

+echo $worksheet->getCell("A12")->getValue() . '<br />';

+echo 'DMAX() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() . '<br /><br />';

 

 echo '<h4>Criteria</h4>';

 

-$criteriaData = $worksheet->rangeToArray('A1:A2',null,true,true,true);

+$criteriaData = $worksheet->rangeToArray('A1:A2', null, true, true, true);

 var_dump($criteriaData);

 

-echo $worksheet->getCell("A13")->getValue() .'<br />';

+echo $worksheet->getCell("A13")->getValue() . '<br />';

 echo 'DMAX() Result is ' . $worksheet->getCell("B13")->getCalculatedValue();