PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Writer/Excel5/Worksheet.php

Indentation +12 added lines, -12 removed lines

@@ -1020,8 +1020,8 @@ 
 
         // Write the packed data
         $this->append($header . $data .
-                       $unknown1 . $options .
-                       $unknown2 . $url_len . $url);
+                        $unknown1 . $options .
+                        $unknown2 . $url_len . $url);
 
         return 0;
     }
@@ -1069,8 +1069,8 @@ 
 
         // Write the packed data
         $this->append($header . $data .
-                       $unknown1 . $options .
-                       $url_len . $url);
+                        $unknown1 . $options .
+                        $url_len . $url);
 
         return 0;
     }
@@ -1151,14 +1151,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     .

src/PhpSpreadsheet/Writer/Excel5/Parser.php

Indentation +1 added lines, -1 removed lines

@@ -666,7 +666,7 @@
             list($row1, $col1) = $this->cellToPackedRowcol($cell1);
             list($row2, $col2) = $this->cellToPackedRowcol($cell2);
         } else { // It's a rows range (like 26:27)
-             list($row1, $col1, $row2, $col2) = $this->rangeToPackedRange($cell1 . ':' . $cell2);
+                list($row1, $col1, $row2, $col2) = $this->rangeToPackedRange($cell1 . ':' . $cell2);
         }
 
         // The ptg value depends on the class of the ptg.

src/PhpSpreadsheet/Writer/Excel2007.php

Indentation +2 added lines, -2 removed lines

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

src/PhpSpreadsheet/Writer/Excel2007/Comments.php

Indentation +7 added lines, -7 removed lines

@@ -46,11 +46,11 @@ 
         // XML header
         $objWriter->startDocument('1.0', 'UTF-8', 'yes');
 
-          // Comments cache
-          $comments = $pWorksheet->getComments();
+            // Comments cache
+            $comments = $pWorksheet->getComments();
 
-          // Authors cache
-          $authors = [];
+            // Authors cache
+            $authors = [];
         $authorId = 0;
         foreach ($comments as $comment) {
             if (!isset($authors[$comment->getAuthor()])) {
@@ -126,8 +126,8 @@ 
         // XML header
         $objWriter->startDocument('1.0', 'UTF-8', 'yes');
 
-          // Comments cache
-          $comments = $pWorksheet->getComments();
+            // Comments cache
+            $comments = $pWorksheet->getComments();
 
         // xml
         $objWriter->startElement('xml');
@@ -189,7 +189,7 @@ 
     private function writeVMLComment(\PhpSpreadsheet\Shared\XMLWriter $objWriter = null, $pCellReference = 'A1', \PhpSpreadsheet\Comment $pComment = null)
     {
         // Metadata
-         list($column, $row) = \PhpSpreadsheet\Cell::coordinateFromString($pCellReference);
+            list($column, $row) = \PhpSpreadsheet\Cell::coordinateFromString($pCellReference);
         $column = \PhpSpreadsheet\Cell::columnIndexFromString($column);
         $id = 1024 + $column + $row;
         $id = substr($id, 0, 4);

src/PhpSpreadsheet/Writer/Excel5.php

Indentation +75 added lines, -75 removed lines

@@ -565,49 +565,49 @@ 
 
         // GKPIDDSI_CODEPAGE: CodePage
         $dataSection[] = ['summary' => ['pack' => 'V', 'data' => 0x01],
-                               'offset' => ['pack' => 'V'],
-                               'type' => ['pack' => 'V', 'data' => 0x02], // 2 byte signed integer
-                               'data' => ['data' => 1252], ];
+                                'offset' => ['pack' => 'V'],
+                                'type' => ['pack' => 'V', 'data' => 0x02], // 2 byte signed integer
+                                'data' => ['data' => 1252], ];
         ++$dataSection_NumProps;
 
         // GKPIDDSI_CATEGORY : Category
         if ($this->spreadsheet->getProperties()->getCategory()) {
             $dataProp = $this->spreadsheet->getProperties()->getCategory();
             $dataSection[] = ['summary' => ['pack' => 'V', 'data' => 0x02],
-                                   'offset' => ['pack' => 'V'],
-                                   'type' => ['pack' => 'V', 'data' => 0x1E],
-                                   'data' => ['data' => $dataProp, 'length' => strlen($dataProp)], ];
+                                    'offset' => ['pack' => 'V'],
+                                    'type' => ['pack' => 'V', 'data' => 0x1E],
+                                    'data' => ['data' => $dataProp, 'length' => strlen($dataProp)], ];
             ++$dataSection_NumProps;
         }
         // GKPIDDSI_VERSION :Version of the application that wrote the property storage
         $dataSection[] = ['summary' => ['pack' => 'V', 'data' => 0x17],
-                               'offset' => ['pack' => 'V'],
-                               'type' => ['pack' => 'V', 'data' => 0x03],
-                               'data' => ['pack' => 'V', 'data' => 0x000C0000], ];
+                                'offset' => ['pack' => 'V'],
+                                'type' => ['pack' => 'V', 'data' => 0x03],
+                                'data' => ['pack' => 'V', 'data' => 0x000C0000], ];
         ++$dataSection_NumProps;
         // GKPIDDSI_SCALE : FALSE
         $dataSection[] = ['summary' => ['pack' => 'V', 'data' => 0x0B],
-                               'offset' => ['pack' => 'V'],
-                               'type' => ['pack' => 'V', 'data' => 0x0B],
-                               'data' => ['data' => false], ];
+                                'offset' => ['pack' => 'V'],
+                                'type' => ['pack' => 'V', 'data' => 0x0B],
+                                'data' => ['data' => false], ];
         ++$dataSection_NumProps;
         // GKPIDDSI_LINKSDIRTY : True if any of the values for the linked properties have changed outside of the application
         $dataSection[] = ['summary' => ['pack' => 'V', 'data' => 0x10],
-                               'offset' => ['pack' => 'V'],
-                               'type' => ['pack' => 'V', 'data' => 0x0B],
-                               'data' => ['data' => false], ];
+                                'offset' => ['pack' => 'V'],
+                                'type' => ['pack' => 'V', 'data' => 0x0B],
+                                'data' => ['data' => false], ];
         ++$dataSection_NumProps;
         // GKPIDDSI_SHAREDOC : FALSE
         $dataSection[] = ['summary' => ['pack' => 'V', 'data' => 0x13],
-                               'offset' => ['pack' => 'V'],
-                               'type' => ['pack' => 'V', 'data' => 0x0B],
-                               'data' => ['data' => false], ];
+                                'offset' => ['pack' => 'V'],
+                                'type' => ['pack' => 'V', 'data' => 0x0B],
+                                'data' => ['data' => false], ];
         ++$dataSection_NumProps;
         // GKPIDDSI_HYPERLINKSCHANGED : True if any of the values for the _PID_LINKS (hyperlink text) have changed outside of the application
         $dataSection[] = ['summary' => ['pack' => 'V', 'data' => 0x16],
-                               'offset' => ['pack' => 'V'],
-                               'type' => ['pack' => 'V', 'data' => 0x0B],
-                               'data' => ['data' => false], ];
+                                'offset' => ['pack' => 'V'],
+                                'type' => ['pack' => 'V', 'data' => 0x0B],
+                                'data' => ['data' => false], ];
         ++$dataSection_NumProps;
 
         // GKPIDDSI_DOCSPARTS
@@ -617,50 +617,50 @@ 
         $dataProp = pack('v', 0x0001);
         $dataProp .= pack('v', 0x0000);
         // array of UnalignedLpstr
-          // cch
-          $dataProp .= pack('v', 0x000A);
+            // cch
+            $dataProp .= pack('v', 0x000A);
         $dataProp .= pack('v', 0x0000);
-          // value
-          $dataProp .= 'Worksheet' . chr(0);
+            // value
+            $dataProp .= 'Worksheet' . chr(0);
 
         $dataSection[] = ['summary' => ['pack' => 'V', 'data' => 0x0D],
-                               'offset' => ['pack' => 'V'],
-                               'type' => ['pack' => 'V', 'data' => 0x101E],
-                               'data' => ['data' => $dataProp, 'length' => strlen($dataProp)], ];
+                                'offset' => ['pack' => 'V'],
+                                'type' => ['pack' => 'V', 'data' => 0x101E],
+                                'data' => ['data' => $dataProp, 'length' => strlen($dataProp)], ];
         ++$dataSection_NumProps;
 
         // GKPIDDSI_HEADINGPAIR
         // VtVecHeadingPairValue
-          // cElements
-          $dataProp = pack('v', 0x0002);
+            // cElements
+            $dataProp = pack('v', 0x0002);
         $dataProp .= pack('v', 0x0000);
-          // Array of vtHeadingPair
+            // Array of vtHeadingPair
             // vtUnalignedString - headingString
-              // stringType
-              $dataProp .= pack('v', 0x001E);
-              // padding
-              $dataProp .= pack('v', 0x0000);
-              // UnalignedLpstr
+                // stringType
+                $dataProp .= pack('v', 0x001E);
+                // padding
+                $dataProp .= pack('v', 0x0000);
+                // UnalignedLpstr
                 // cch
                 $dataProp .= pack('v', 0x0013);
         $dataProp .= pack('v', 0x0000);
                 // value
                 $dataProp .= 'Feuilles de calcul';
             // vtUnalignedString - headingParts
-              // wType : 0x0003 = 32 bit signed integer
-              $dataProp .= pack('v', 0x0300);
-              // padding
-              $dataProp .= pack('v', 0x0000);
-              // value
-              $dataProp .= pack('v', 0x0100);
+                // wType : 0x0003 = 32 bit signed integer
+                $dataProp .= pack('v', 0x0300);
+                // padding
+                $dataProp .= pack('v', 0x0000);
+                // value
+                $dataProp .= pack('v', 0x0100);
         $dataProp .= pack('v', 0x0000);
         $dataProp .= pack('v', 0x0000);
         $dataProp .= pack('v', 0x0000);
 
         $dataSection[] = ['summary' => ['pack' => 'V', 'data' => 0x0C],
-                               'offset' => ['pack' => 'V'],
-                               'type' => ['pack' => 'V', 'data' => 0x100C],
-                               'data' => ['data' => $dataProp, 'length' => strlen($dataProp)], ];
+                                'offset' => ['pack' => 'V'],
+                                'type' => ['pack' => 'V', 'data' => 0x100C],
+                                'data' => ['data' => $dataProp, 'length' => strlen($dataProp)], ];
         ++$dataSection_NumProps;
 
         //         4     Section Length
@@ -761,88 +761,88 @@ 
 
         // CodePage : CP-1252
         $dataSection[] = ['summary' => ['pack' => 'V', 'data' => 0x01],
-                               'offset' => ['pack' => 'V'],
-                               'type' => ['pack' => 'V', 'data' => 0x02], // 2 byte signed integer
-                               'data' => ['data' => 1252], ];
+                                'offset' => ['pack' => 'V'],
+                                'type' => ['pack' => 'V', 'data' => 0x02], // 2 byte signed integer
+                                'data' => ['data' => 1252], ];
         ++$dataSection_NumProps;
 
         //    Title
         if ($this->spreadsheet->getProperties()->getTitle()) {
             $dataProp = $this->spreadsheet->getProperties()->getTitle();
             $dataSection[] = ['summary' => ['pack' => 'V', 'data' => 0x02],
-                                   'offset' => ['pack' => 'V'],
-                                   'type' => ['pack' => 'V', 'data' => 0x1E], // null-terminated string prepended by dword string length
-                                   'data' => ['data' => $dataProp, 'length' => strlen($dataProp)], ];
+                                    'offset' => ['pack' => 'V'],
+                                    'type' => ['pack' => 'V', 'data' => 0x1E], // null-terminated string prepended by dword string length
+                                    'data' => ['data' => $dataProp, 'length' => strlen($dataProp)], ];
             ++$dataSection_NumProps;
         }
         //    Subject
         if ($this->spreadsheet->getProperties()->getSubject()) {
             $dataProp = $this->spreadsheet->getProperties()->getSubject();
             $dataSection[] = ['summary' => ['pack' => 'V', 'data' => 0x03],
-                                   'offset' => ['pack' => 'V'],
-                                   'type' => ['pack' => 'V', 'data' => 0x1E], // null-terminated string prepended by dword string length
-                                   'data' => ['data' => $dataProp, 'length' => strlen($dataProp)], ];
+                                    'offset' => ['pack' => 'V'],
+                                    'type' => ['pack' => 'V', 'data' => 0x1E], // null-terminated string prepended by dword string length
+                                    'data' => ['data' => $dataProp, 'length' => strlen($dataProp)], ];
             ++$dataSection_NumProps;
         }
         //    Author (Creator)
         if ($this->spreadsheet->getProperties()->getCreator()) {
             $dataProp = $this->spreadsheet->getProperties()->getCreator();
             $dataSection[] = ['summary' => ['pack' => 'V', 'data' => 0x04],
-                                   'offset' => ['pack' => 'V'],
-                                   'type' => ['pack' => 'V', 'data' => 0x1E], // null-terminated string prepended by dword string length
-                                   'data' => ['data' => $dataProp, 'length' => strlen($dataProp)], ];
+                                    'offset' => ['pack' => 'V'],
+                                    'type' => ['pack' => 'V', 'data' => 0x1E], // null-terminated string prepended by dword string length
+                                    'data' => ['data' => $dataProp, 'length' => strlen($dataProp)], ];
             ++$dataSection_NumProps;
         }
         //    Keywords
         if ($this->spreadsheet->getProperties()->getKeywords()) {
             $dataProp = $this->spreadsheet->getProperties()->getKeywords();
             $dataSection[] = ['summary' => ['pack' => 'V', 'data' => 0x05],
-                                   'offset' => ['pack' => 'V'],
-                                   'type' => ['pack' => 'V', 'data' => 0x1E], // null-terminated string prepended by dword string length
-                                   'data' => ['data' => $dataProp, 'length' => strlen($dataProp)], ];
+                                    'offset' => ['pack' => 'V'],
+                                    'type' => ['pack' => 'V', 'data' => 0x1E], // null-terminated string prepended by dword string length
+                                    'data' => ['data' => $dataProp, 'length' => strlen($dataProp)], ];
             ++$dataSection_NumProps;
         }
         //    Comments (Description)
         if ($this->spreadsheet->getProperties()->getDescription()) {
             $dataProp = $this->spreadsheet->getProperties()->getDescription();
             $dataSection[] = ['summary' => ['pack' => 'V', 'data' => 0x06],
-                                   'offset' => ['pack' => 'V'],
-                                   'type' => ['pack' => 'V', 'data' => 0x1E], // null-terminated string prepended by dword string length
-                                   'data' => ['data' => $dataProp, 'length' => strlen($dataProp)], ];
+                                    'offset' => ['pack' => 'V'],
+                                    'type' => ['pack' => 'V', 'data' => 0x1E], // null-terminated string prepended by dword string length
+                                    'data' => ['data' => $dataProp, 'length' => strlen($dataProp)], ];
             ++$dataSection_NumProps;
         }
         //    Last Saved By (LastModifiedBy)
         if ($this->spreadsheet->getProperties()->getLastModifiedBy()) {
             $dataProp = $this->spreadsheet->getProperties()->getLastModifiedBy();
             $dataSection[] = ['summary' => ['pack' => 'V', 'data' => 0x08],
-                                   'offset' => ['pack' => 'V'],
-                                   'type' => ['pack' => 'V', 'data' => 0x1E], // null-terminated string prepended by dword string length
-                                   'data' => ['data' => $dataProp, 'length' => strlen($dataProp)], ];
+                                    'offset' => ['pack' => 'V'],
+                                    'type' => ['pack' => 'V', 'data' => 0x1E], // null-terminated string prepended by dword string length
+                                    'data' => ['data' => $dataProp, 'length' => strlen($dataProp)], ];
             ++$dataSection_NumProps;
         }
         //    Created Date/Time
         if ($this->spreadsheet->getProperties()->getCreated()) {
             $dataProp = $this->spreadsheet->getProperties()->getCreated();
             $dataSection[] = ['summary' => ['pack' => 'V', 'data' => 0x0C],
-                                   'offset' => ['pack' => 'V'],
-                                   'type' => ['pack' => 'V', 'data' => 0x40], // Filetime (64-bit value representing the number of 100-nanosecond intervals since January 1, 1601)
-                                   'data' => ['data' => \PhpSpreadsheet\Shared\OLE::localDateToOLE($dataProp)], ];
+                                    'offset' => ['pack' => 'V'],
+                                    'type' => ['pack' => 'V', 'data' => 0x40], // Filetime (64-bit value representing the number of 100-nanosecond intervals since January 1, 1601)
+                                    'data' => ['data' => \PhpSpreadsheet\Shared\OLE::localDateToOLE($dataProp)], ];
             ++$dataSection_NumProps;
         }
         //    Modified Date/Time
         if ($this->spreadsheet->getProperties()->getModified()) {
             $dataProp = $this->spreadsheet->getProperties()->getModified();
             $dataSection[] = ['summary' => ['pack' => 'V', 'data' => 0x0D],
-                                   'offset' => ['pack' => 'V'],
-                                   'type' => ['pack' => 'V', 'data' => 0x40], // Filetime (64-bit value representing the number of 100-nanosecond intervals since January 1, 1601)
-                                   'data' => ['data' => \PhpSpreadsheet\Shared\OLE::localDateToOLE($dataProp)], ];
+                                    'offset' => ['pack' => 'V'],
+                                    'type' => ['pack' => 'V', 'data' => 0x40], // Filetime (64-bit value representing the number of 100-nanosecond intervals since January 1, 1601)
+                                    'data' => ['data' => \PhpSpreadsheet\Shared\OLE::localDateToOLE($dataProp)], ];
             ++$dataSection_NumProps;
         }
         //    Security
         $dataSection[] = ['summary' => ['pack' => 'V', 'data' => 0x13],
-                               'offset' => ['pack' => 'V'],
-                               'type' => ['pack' => 'V', 'data' => 0x03], // 4 byte signed integer
-                               'data' => ['data' => 0x00], ];
+                                'offset' => ['pack' => 'V'],
+                                'type' => ['pack' => 'V', 'data' => 0x03], // 4 byte signed integer
+                                'data' => ['data' => 0x00], ];
         ++$dataSection_NumProps;
 
         //         4     Section Length

src/PhpSpreadsheet/Chart/GridLines.php

Indentation +1 added lines, -1 removed lines

@@ -76,7 +76,7 @@
 
     private $softEdges = [
         'size' => null,
-     ];
+        ];
 
     /**
      * Get Object State

src/PhpSpreadsheet/Calculation/FormulaParser.php

Indentation +2 added lines, -2 removed lines

@@ -497,7 +497,7 @@ 
                     (($previousToken->getTokenType() == FormulaToken::TOKEN_TYPE_FUNCTION) && ($previousToken->getTokenSubType() == FormulaToken::TOKEN_SUBTYPE_STOP)) ||
                     (($previousToken->getTokenType() == FormulaToken::TOKEN_TYPE_SUBEXPRESSION) && ($previousToken->getTokenSubType() == FormulaToken::TOKEN_SUBTYPE_STOP)) ||
                     ($previousToken->getTokenType() == FormulaToken::TOKEN_TYPE_OPERAND)
-                  )) {
+                    )) {
                 continue;
             }
 
@@ -509,7 +509,7 @@ 
                     (($nextToken->getTokenType() == FormulaToken::TOKEN_TYPE_FUNCTION) && ($nextToken->getTokenSubType() == FormulaToken::TOKEN_SUBTYPE_START)) ||
                     (($nextToken->getTokenType() == FormulaToken::TOKEN_TYPE_SUBEXPRESSION) && ($nextToken->getTokenSubType() == FormulaToken::TOKEN_SUBTYPE_START)) ||
                     ($nextToken->getTokenType() == FormulaToken::TOKEN_TYPE_OPERAND)
-                  )) {
+                    )) {
                 continue;
             }
 

src/PhpSpreadsheet/Calculation.php

Indentation +8 added lines, -8 removed lines

@@ -232,7 +232,7 @@ 
         'NULL' => null,
     ];
 
-     //    PhpSpreadsheet functions
+        //    PhpSpreadsheet functions
     private static $phpSpreadsheetFunctions = [
         'ABS' => [
             'category' => Calculation\Categories::CATEGORY_MATH_AND_TRIG,
@@ -3073,13 +3073,13 @@ 
         $pCellParent = ($pCell !== null) ? $pCell->getWorksheet() : null;
 
         $regexpMatchString = '/^(' . self::CALCULATION_REGEXP_FUNCTION .
-                               '|' . self::CALCULATION_REGEXP_CELLREF .
-                               '|' . self::CALCULATION_REGEXP_NUMBER .
-                               '|' . self::CALCULATION_REGEXP_STRING .
-                               '|' . self::CALCULATION_REGEXP_OPENBRACE .
-                               '|' . self::CALCULATION_REGEXP_NAMEDRANGE .
-                               '|' . self::CALCULATION_REGEXP_ERROR .
-                             ')/si';
+                                '|' . self::CALCULATION_REGEXP_CELLREF .
+                                '|' . self::CALCULATION_REGEXP_NUMBER .
+                                '|' . self::CALCULATION_REGEXP_STRING .
+                                '|' . self::CALCULATION_REGEXP_OPENBRACE .
+                                '|' . self::CALCULATION_REGEXP_NAMEDRANGE .
+                                '|' . self::CALCULATION_REGEXP_ERROR .
+                                ')/si';
 
         //    Start with initialisation
         $index = 0;

src/PhpSpreadsheet/Reader/CSV.php

Indentation +2 added lines, -2 removed lines

@@ -254,8 +254,8 @@
         $sheet = $spreadsheet->setActiveSheetIndex($this->sheetIndex);
 
         $escapeEnclosures = ['\\' . $this->enclosure,
-                                   $this->enclosure . $this->enclosure,
-                                 ];
+                                    $this->enclosure . $this->enclosure,
+                                    ];
 
         // Set our starting row based on whether we're in contiguous mode or not
         $currentRow = 1;