PHPOffice / PhpSpreadsheet

tests/data/Calculation/DateTime/DAY.php

Spacing +20 added lines, -20 removed lines

@@ -4,53 +4,53 @@
 
 return [
     [
-        19,         // Result for Excel
-        19,         // Result for OpenOffice
+        19, // Result for Excel
+        19, // Result for OpenOffice
         22269,
     ],
     [
-        1,          // Result for Excel
-        1,          // Result for OpenOffice
+        1, // Result for Excel
+        1, // Result for OpenOffice
         30348,
     ],
     [
-        10,         // Result for Excel
-        10,         // Result for OpenOffice
+        10, // Result for Excel
+        10, // Result for OpenOffice
         30843,
     ],
     [
-        11,         // Result for Excel
-        11,         // Result for OpenOffice
+        11, // Result for Excel
+        11, // Result for OpenOffice
         '11-Nov-1918',
     ],
     [
-        28,         // Result for Excel
-        28,         // Result for OpenOffice
+        28, // Result for Excel
+        28, // Result for OpenOffice
         '28-Feb-1904',
     ],
     [
-        '#VALUE!',  // Result for Excel
-        '#VALUE!',  // Result for OpenOffice
+        '#VALUE!', // Result for Excel
+        '#VALUE!', // Result for OpenOffice
         'Invalid',
     ],
     [
-        '#NUM!',  // Result for Excel
-        29,       // Result for OpenOffice
+        '#NUM!', // Result for Excel
+        29, // Result for OpenOffice
         -1,
     ],
     [
-        1,         // Result for Excel
-        31,        // Result for OpenOffice
+        1, // Result for Excel
+        31, // Result for OpenOffice
         1,
     ],
     [
-        0,         // Result for Excel
-        30,        // Result for OpenOffice
+        0, // Result for Excel
+        30, // Result for OpenOffice
         0.5,
     ],
     [
-        0,         // Result for Excel
-        30,        // Result for OpenOffice
+        0, // Result for Excel
+        30, // Result for OpenOffice
         0,
     ],
 ];

samples/Reader/20_Reader_worksheet_hyperlink_image.php

Spacing +3 added lines, -3 removed lines

@@ -15,9 +15,9 @@
 
 $helper->log('Set active sheet index 0');
 $aSheet = $spreadsheet->setActiveSheetIndex(0);
-$drawing  = $aSheet->getDrawingCollection();
+$drawing = $aSheet->getDrawingCollection();
 /** @var  $dr \PhpOffice\PhpSpreadsheet\Worksheet\Drawing */
-foreach ($drawing as $dr){
-    $helper->log("links "  . $dr->getHyperlink()->getUrl());
+foreach ($drawing as $dr) {
+    $helper->log("links " . $dr->getHyperlink()->getUrl());
 }
 $helper->log('End');

src/PhpSpreadsheet/Worksheet/BaseDrawing.php

Spacing +2 added lines, -3 removed lines

@@ -124,8 +124,7 @@ 
         $this->rotation = 0;
         $this->shadow = new Drawing\Shadow();
 
-        // Set image index
-        ++self::$imageCounter;
+        // Set image index++self::$imageCounter;
         $this->imageIndex = self::$imageCounter;
     }
 
@@ -530,7 +529,7 @@ 
      */
     public function getHyperlink()
     {
-        if ($this->hyperlink === null){
+        if ($this->hyperlink === null) {
             $this->hyperlink = new Hyperlink();
         }
 

src/PhpSpreadsheet/Reader/Xlsx.php

Spacing +2 added lines, -2 removed lines

@@ -1550,7 +1550,7 @@ 
                                         $hyperlinks = array();
                                         if ($relsDrawing && $relsDrawing->Relationship) {
                                             foreach ($relsDrawing->Relationship as $ele) {
-                                                if ($ele['Type'] == 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/hyperlink'){
+                                                if ($ele['Type'] == 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/hyperlink') {
                                                     $hyperlinks[(string) $ele['Id']] = (string) $ele['Target'];
                                                 }
                                                 if ($ele['Type'] == 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/image') {
@@ -1659,7 +1659,7 @@ 
                                                         $shadow->getColor()->setRGB(self::getArrayItem($outerShdw->srgbClr->attributes(), 'val'));
                                                         $shadow->setAlpha(self::getArrayItem($outerShdw->srgbClr->alpha->attributes(), 'val') / 1000);
                                                     }
-                                                    if($hlinkClick) {
+                                                    if ($hlinkClick) {
                                                         $hlinkId = (string) $hlinkClick->attributes('http://schemas.openxmlformats.org/officeDocument/2006/relationships')['id'];
                                                         $hyperlink = new Hyperlink(
                                                             $hyperlinks[$hlinkId],