PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Writer/Excel5.php

Indentation +80 added lines, -80 removed lines

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

src/PhpSpreadsheet/Writer/Excel2007/Comments.php

Indentation +12 added lines, -12 removed lines

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

src/PhpSpreadsheet/Shared/OLE/PPS/Root.php

Indentation +54 added lines, -54 removed lines

@@ -50,17 +50,17 @@ 
     }
 
     /**
-    * Method for saving the whole OLE container (including files).
-    * In fact, if called with an empty argument (or '-'), it saves to a
-    * temporary file and then outputs it's contents to stdout.
-    * If a resource pointer to a stream created by fopen() is passed
-    * it will be used, but you have to close such stream by yourself.
-    *
-    * @param string|resource $filename The name of the file or stream where to save the OLE container.
-    * @access public
-    * @return mixed true on success
-    * @throws \PhpSpreadsheet\Writer\Exception
-    */
+     * Method for saving the whole OLE container (including files).
+     * In fact, if called with an empty argument (or '-'), it saves to a
+     * temporary file and then outputs it's contents to stdout.
+     * If a resource pointer to a stream created by fopen() is passed
+     * it will be used, but you have to close such stream by yourself.
+     *
+     * @param string|resource $filename The name of the file or stream where to save the OLE container.
+     * @access public
+     * @return mixed true on success
+     * @throws \PhpSpreadsheet\Writer\Exception
+     */
     public function save($filename)
     {
         // Initial Setting for saving
@@ -116,12 +116,12 @@ 
     }
 
     /**
-    * Calculate some numbers
-    *
-    * @access public
-    * @param array $raList Reference to an array of PPS's
-    * @return array The array of numbers
-    */
+     * Calculate some numbers
+     *
+     * @access public
+     * @param array $raList Reference to an array of PPS's
+     * @return array The array of numbers
+     */
     public function _calcSize(&$raList)
     {
         // Calculate Basic Setting
@@ -154,13 +154,13 @@ 
     }
 
     /**
-    * Helper function for caculating a magic value for block sizes
-    *
-    * @access public
-    * @param integer $i2 The argument
-    * @see save()
-    * @return integer
-    */
+     * Helper function for caculating a magic value for block sizes
+     *
+     * @access public
+     * @param integer $i2 The argument
+     * @see save()
+     * @return integer
+     */
     private static function adjust2($i2)
     {
         $iWk = log($i2)/log(2);
@@ -168,13 +168,13 @@ 
     }
 
     /**
-    * Save OLE header
-    *
-    * @access public
-    * @param integer $iSBDcnt
-    * @param integer $iBBcnt
-    * @param integer $iPPScnt
-    */
+     * Save OLE header
+     *
+     * @access public
+     * @param integer $iSBDcnt
+     * @param integer $iBBcnt
+     * @param integer $iPPScnt
+     */
     public function _saveHeader($iSBDcnt, $iBBcnt, $iPPScnt)
     {
         $FILE = $this->_FILEH_;
@@ -249,12 +249,12 @@ 
     }
 
     /**
-    * Saving big data (PPS's with data bigger than \PhpSpreadsheet\Shared\OLE::OLE_DATA_SIZE_SMALL)
-    *
-    * @access public
-    * @param integer $iStBlk
-    * @param array &$raList Reference to array of PPS's
-    */
+     * Saving big data (PPS's with data bigger than \PhpSpreadsheet\Shared\OLE::OLE_DATA_SIZE_SMALL)
+     *
+     * @access public
+     * @param integer $iStBlk
+     * @param array &$raList Reference to array of PPS's
+     */
     public function _saveBigData($iStBlk, &$raList)
     {
         $FILE = $this->_FILEH_;
@@ -297,11 +297,11 @@ 
     }
 
     /**
-    * get small data (PPS's with data smaller than \PhpSpreadsheet\Shared\OLE::OLE_DATA_SIZE_SMALL)
-    *
-    * @access public
-    * @param array &$raList Reference to array of PPS's
-    */
+     * get small data (PPS's with data smaller than \PhpSpreadsheet\Shared\OLE::OLE_DATA_SIZE_SMALL)
+     *
+     * @access public
+     * @param array &$raList Reference to array of PPS's
+     */
     public function _makeSmallData(&$raList)
     {
         $sRes = '';
@@ -354,11 +354,11 @@ 
     }
 
     /**
-    * Saves all the PPS's WKs
-    *
-    * @access public
-    * @param array $raList Reference to an array with all PPS's
-    */
+     * Saves all the PPS's WKs
+     *
+     * @access public
+     * @param array $raList Reference to an array with all PPS's
+     */
     public function _savePps(&$raList)
     {
         // Save each PPS WK
@@ -375,13 +375,13 @@ 
     }
 
     /**
-    * Saving Big Block Depot
-    *
-    * @access public
-    * @param integer $iSbdSize
-    * @param integer $iBsize
-    * @param integer $iPpsCnt
-    */
+     * Saving Big Block Depot
+     *
+     * @access public
+     * @param integer $iSbdSize
+     * @param integer $iBsize
+     * @param integer $iPpsCnt
+     */
     public function _saveBbd($iSbdSize, $iBsize, $iPpsCnt)
     {
         $FILE = $this->_FILEH_;

src/PhpSpreadsheet/Shared/OLE/PPS.php

Indentation +86 added lines, -86 removed lines

@@ -32,98 +32,98 @@ 
 class PPS
 {
     /**
-    * The PPS index
-    * @var integer
-    */
+     * The PPS index
+     * @var integer
+     */
     public $No;
 
     /**
-    * The PPS name (in Unicode)
-    * @var string
-    */
+     * The PPS name (in Unicode)
+     * @var string
+     */
     public $Name;
 
     /**
-    * The PPS type. Dir, Root or File
-    * @var integer
-    */
+     * The PPS type. Dir, Root or File
+     * @var integer
+     */
     public $Type;
 
     /**
-    * The index of the previous PPS
-    * @var integer
-    */
+     * The index of the previous PPS
+     * @var integer
+     */
     public $PrevPps;
 
     /**
-    * The index of the next PPS
-    * @var integer
-    */
+     * The index of the next PPS
+     * @var integer
+     */
     public $NextPps;
 
     /**
-    * The index of it's first child if this is a Dir or Root PPS
-    * @var integer
-    */
+     * The index of it's first child if this is a Dir or Root PPS
+     * @var integer
+     */
     public $DirPps;
 
     /**
-    * A timestamp
-    * @var integer
-    */
+     * A timestamp
+     * @var integer
+     */
     public $Time1st;
 
     /**
-    * A timestamp
-    * @var integer
-    */
+     * A timestamp
+     * @var integer
+     */
     public $Time2nd;
 
     /**
-    * Starting block (small or big) for this PPS's data  inside the container
-    * @var integer
-    */
+     * Starting block (small or big) for this PPS's data  inside the container
+     * @var integer
+     */
     public $startBlock;
 
     /**
-    * The size of the PPS's data (in bytes)
-    * @var integer
-    */
+     * The size of the PPS's data (in bytes)
+     * @var integer
+     */
     public $Size;
 
     /**
-    * The PPS's data (only used if it's not using a temporary file)
-    * @var string
-    */
+     * The PPS's data (only used if it's not using a temporary file)
+     * @var string
+     */
     public $_data;
 
     /**
-    * Array of child PPS's (only used by Root and Dir PPS's)
-    * @var array
-    */
+     * Array of child PPS's (only used by Root and Dir PPS's)
+     * @var array
+     */
     public $children = array();
 
     /**
-    * Pointer to OLE container
-    * @var OLE
-    */
+     * Pointer to OLE container
+     * @var OLE
+     */
     public $ole;
 
     /**
-    * The constructor
-    *
-    * @access public
-    * @param integer $No   The PPS index
-    * @param string  $name The PPS name
-    * @param integer $type The PPS type. Dir, Root or File
-    * @param integer $prev The index of the previous PPS
-    * @param integer $next The index of the next PPS
-    * @param integer $dir  The index of it's first child if this is a Dir or Root PPS
-    * @param integer $time_1st A timestamp
-    * @param integer $time_2nd A timestamp
-    * @param string  $data  The (usually binary) source data of the PPS
-    * @param array   $children Array containing children PPS for this PPS
-    */
+     * The constructor
+     *
+     * @access public
+     * @param integer $No   The PPS index
+     * @param string  $name The PPS name
+     * @param integer $type The PPS type. Dir, Root or File
+     * @param integer $prev The index of the previous PPS
+     * @param integer $next The index of the next PPS
+     * @param integer $dir  The index of it's first child if this is a Dir or Root PPS
+     * @param integer $time_1st A timestamp
+     * @param integer $time_2nd A timestamp
+     * @param string  $data  The (usually binary) source data of the PPS
+     * @param array   $children Array containing children PPS for this PPS
+     */
     public function __construct($No, $name, $type, $prev, $next, $dir, $time_1st, $time_2nd, $data, $children)
     {
         $this->No      = $No;
@@ -144,11 +144,11 @@ 
     }
 
     /**
-    * Returns the amount of data saved for this PPS
-    *
-    * @access public
-    * @return integer The amount of data (in bytes)
-    */
+     * Returns the amount of data saved for this PPS
+     *
+     * @access public
+     * @return integer The amount of data (in bytes)
+     */
     public function getDataLen()
     {
         if (!isset($this->_data)) {
@@ -164,43 +164,43 @@ 
     }
 
     /**
-    * Returns a string with the PPS's WK (What is a WK?)
-    *
-    * @access public
-    * @return string The binary string
-    */
+     * Returns a string with the PPS's WK (What is a WK?)
+     *
+     * @access public
+     * @return string The binary string
+     */
     public function _getPpsWk()
     {
         $ret = str_pad($this->Name, 64, "\x00");
 
         $ret .= pack("v", strlen($this->Name) + 2)  // 66
-              . pack("c", $this->Type)              // 67
-              . pack("c", 0x00) //UK                // 68
-              . pack("V", $this->PrevPps) //Prev    // 72
-              . pack("V", $this->NextPps) //Next    // 76
-              . pack("V", $this->DirPps)  //Dir     // 80
-              . "\x00\x09\x02\x00"                  // 84
-              . "\x00\x00\x00\x00"                  // 88
-              . "\xc0\x00\x00\x00"                  // 92
-              . "\x00\x00\x00\x46"                  // 96 // Seems to be ok only for Root
-              . "\x00\x00\x00\x00"                  // 100
-              . \PhpSpreadsheet\Shared\OLE::localDateToOLE($this->Time1st)          // 108
-              . \PhpSpreadsheet\Shared\OLE::localDateToOLE($this->Time2nd)          // 116
-              . pack("V", isset($this->startBlock) ? $this->startBlock : 0)  // 120
-              . pack("V", $this->Size)               // 124
-              . pack("V", 0);                        // 128
+                . pack("c", $this->Type)              // 67
+                . pack("c", 0x00) //UK                // 68
+                . pack("V", $this->PrevPps) //Prev    // 72
+                . pack("V", $this->NextPps) //Next    // 76
+                . pack("V", $this->DirPps)  //Dir     // 80
+                . "\x00\x09\x02\x00"                  // 84
+                . "\x00\x00\x00\x00"                  // 88
+                . "\xc0\x00\x00\x00"                  // 92
+                . "\x00\x00\x00\x46"                  // 96 // Seems to be ok only for Root
+                . "\x00\x00\x00\x00"                  // 100
+                . \PhpSpreadsheet\Shared\OLE::localDateToOLE($this->Time1st)          // 108
+                . \PhpSpreadsheet\Shared\OLE::localDateToOLE($this->Time2nd)          // 116
+                . pack("V", isset($this->startBlock) ? $this->startBlock : 0)  // 120
+                . pack("V", $this->Size)               // 124
+                . pack("V", 0);                        // 128
         return $ret;
     }
 
     /**
-    * Updates index and pointers to previous, next and children PPS's for this
-    * PPS. I don't think it'll work with Dir PPS's.
-    *
-    * @access public
-    * @param array &$raList Reference to the array of PPS's for the whole OLE
-    *                          container
-    * @return integer          The index for this PPS
-    */
+     * Updates index and pointers to previous, next and children PPS's for this
+     * PPS. I don't think it'll work with Dir PPS's.
+     *
+     * @access public
+     * @param array &$raList Reference to the array of PPS's for the whole OLE
+     *                          container
+     * @return integer          The index for this PPS
+     */
     public static function _savePpsSetPnt(&$raList, $to_save, $depth = 0)
     {
         if (!is_array($to_save) || (empty($to_save))) {

src/PhpSpreadsheet/Shared/OLE.php

Indentation +88 added lines, -88 removed lines

@@ -49,43 +49,43 @@ 
     /**
      * The file handle for reading an OLE container
      * @var resource
-    */
+     */
     public $_file_handle;
 
     /**
-    * Array of PPS's found on the OLE container
-    * @var array
-    */
+     * Array of PPS's found on the OLE container
+     * @var array
+     */
     public $_list = array();
 
     /**
      * Root directory of OLE container
      * @var OLE_PPS_Root
-    */
+     */
     public $root;
 
     /**
      * Big Block Allocation Table
      * @var array  (blockId => nextBlockId)
-    */
+     */
     public $bbat;
 
     /**
      * Short Block Allocation Table
      * @var array  (blockId => nextBlockId)
-    */
+     */
     public $sbat;
 
     /**
      * Size of big blocks. This is usually 512.
      * @var  int  number of octets per block.
-    */
+     */
     public $bigBlockSize;
 
     /**
      * Size of small blocks. This is usually 64.
      * @var  int  number of octets per block
-    */
+     */
     public $smallBlockSize;
 
     /**
@@ -95,7 +95,7 @@ 
      * @param string $file
      * @return mixed true on success, PEAR_Error on failure
      * @throws \PhpSpreadsheet\Reader\Exception
-    */
+     */
     public function read($file)
     {
         $fh = fopen($file, "r");
@@ -192,11 +192,11 @@ 
     }
 
     /**
-    * Returns a stream for use with fread() etc. External callers should
-    * use \PhpSpreadsheet\Shared\OLE\PPS\File::getStream().
-    * @param   int|PPS   block id or PPS
-    * @return  resource  read-only stream
-    */
+     * Returns a stream for use with fread() etc. External callers should
+     * use \PhpSpreadsheet\Shared\OLE\PPS\File::getStream().
+     * @param   int|PPS   block id or PPS
+     * @return  resource  read-only stream
+     */
     public function getStream($blockIdOrPps)
     {
         static $isRegistered = false;
@@ -258,13 +258,13 @@ 
     }
 
     /**
-    * Gets information about all PPS's on the OLE container from the PPS WK's
-    * creates an OLE_PPS object for each one.
-    *
-    * @access public
-    * @param  integer  the block id of the first block
-    * @return mixed true on success, PEAR_Error on failure
-    */
+     * Gets information about all PPS's on the OLE container from the PPS WK's
+     * creates an OLE_PPS object for each one.
+     *
+     * @access public
+     * @param  integer  the block id of the first block
+     * @return mixed true on success, PEAR_Error on failure
+     */
     public function _readPpsWks($blockId)
     {
         $fh = $this->getStream($blockId);
@@ -332,13 +332,13 @@ 
     }
 
     /**
-    * It checks whether the PPS tree is complete (all PPS's read)
-    * starting with the given PPS (not necessarily root)
-    *
-    * @access public
-    * @param integer $index The index of the PPS from which we are checking
-    * @return boolean Whether the PPS tree for the given PPS is complete
-    */
+     * It checks whether the PPS tree is complete (all PPS's read)
+     * starting with the given PPS (not necessarily root)
+     *
+     * @access public
+     * @param integer $index The index of the PPS from which we are checking
+     * @return boolean Whether the PPS tree for the given PPS is complete
+     */
     public function _ppsTreeComplete($index)
     {
         return isset($this->_list[$index]) &&
@@ -352,13 +352,13 @@ 
     }
 
     /**
-    * Checks whether a PPS is a File PPS or not.
-    * If there is no PPS for the index given, it will return false.
-    *
-    * @access public
-    * @param integer $index The index for the PPS
-    * @return bool true if it's a File PPS, false otherwise
-    */
+     * Checks whether a PPS is a File PPS or not.
+     * If there is no PPS for the index given, it will return false.
+     *
+     * @access public
+     * @param integer $index The index for the PPS
+     * @return bool true if it's a File PPS, false otherwise
+     */
     public function isFile($index)
     {
         if (isset($this->_list[$index])) {
@@ -368,13 +368,13 @@ 
     }
 
     /**
-    * Checks whether a PPS is a Root PPS or not.
-    * If there is no PPS for the index given, it will return false.
-    *
-    * @access public
-    * @param integer $index The index for the PPS.
-    * @return bool true if it's a Root PPS, false otherwise
-    */
+     * Checks whether a PPS is a Root PPS or not.
+     * If there is no PPS for the index given, it will return false.
+     *
+     * @access public
+     * @param integer $index The index for the PPS.
+     * @return bool true if it's a Root PPS, false otherwise
+     */
     public function isRoot($index)
     {
         if (isset($this->_list[$index])) {
@@ -384,28 +384,28 @@ 
     }
 
     /**
-    * Gives the total number of PPS's found in the OLE container.
-    *
-    * @access public
-    * @return integer The total number of PPS's found in the OLE container
-    */
+     * Gives the total number of PPS's found in the OLE container.
+     *
+     * @access public
+     * @return integer The total number of PPS's found in the OLE container
+     */
     public function ppsTotal()
     {
         return count($this->_list);
     }
 
     /**
-    * Gets data from a PPS
-    * If there is no PPS for the index given, it will return an empty string.
-    *
-    * @access public
-    * @param integer $index    The index for the PPS
-    * @param integer $position The position from which to start reading
-    *                          (relative to the PPS)
-    * @param integer $length   The amount of bytes to read (at most)
-    * @return string The binary string containing the data requested
-    * @see OLE_PPS_File::getStream()
-    */
+     * Gets data from a PPS
+     * If there is no PPS for the index given, it will return an empty string.
+     *
+     * @access public
+     * @param integer $index    The index for the PPS
+     * @param integer $position The position from which to start reading
+     *                          (relative to the PPS)
+     * @param integer $length   The amount of bytes to read (at most)
+     * @return string The binary string containing the data requested
+     * @see OLE_PPS_File::getStream()
+     */
     public function getData($index, $position, $length)
     {
         // if position is not valid return empty string
@@ -419,13 +419,13 @@ 
     }
 
     /**
-    * Gets the data length from a PPS
-    * If there is no PPS for the index given, it will return 0.
-    *
-    * @access public
-    * @param integer $index    The index for the PPS
-    * @return integer The amount of bytes in data the PPS has
-    */
+     * Gets the data length from a PPS
+     * If there is no PPS for the index given, it will return 0.
+     *
+     * @access public
+     * @param integer $index    The index for the PPS
+     * @return integer The amount of bytes in data the PPS has
+     */
     public function getDataLength($index)
     {
         if (isset($this->_list[$index])) {
@@ -435,13 +435,13 @@ 
     }
 
     /**
-    * Utility function to transform ASCII text to Unicode
-    *
-    * @access public
-    * @static
-    * @param string $ascii The ASCII string to transform
-    * @return string The string in Unicode
-    */
+     * Utility function to transform ASCII text to Unicode
+     *
+     * @access public
+     * @static
+     * @param string $ascii The ASCII string to transform
+     * @return string The string in Unicode
+     */
     public static function ascToUcs($ascii)
     {
         $rawname = '';
@@ -452,14 +452,14 @@ 
     }
 
     /**
-    * Utility function
-    * Returns a string for the OLE container with the date given
-    *
-    * @access public
-    * @static
-    * @param integer $date A timestamp
-    * @return string The string for the OLE container
-    */
+     * Utility function
+     * Returns a string for the OLE container with the date given
+     *
+     * @access public
+     * @static
+     * @param integer $date A timestamp
+     * @return string The string for the OLE container
+     */
     public static function localDateToOLE($date = null)
     {
         if (!isset($date)) {
@@ -497,13 +497,13 @@ 
     }
 
     /**
-    * Returns a timestamp from an OLE container's date
-    *
-    * @access public
-    * @static
-    * @param integer $string A binary string with the encoded date
-    * @return string The timestamp corresponding to the string
-    */
+     * Returns a timestamp from an OLE container's date
+     *
+     * @access public
+     * @static
+     * @param integer $string A binary string with the encoded date
+     * @return string The timestamp corresponding to the string
+     */
     public static function OLE2LocalDate($string)
     {
         if (strlen($string) != 8) {

src/PhpSpreadsheet/Calculation.php

Indentation +8 added lines, -8 removed lines

@@ -261,7 +261,7 @@ 
         'NULL'  => null
     );
 
-     //    PhpSpreadsheet functions
+        //    PhpSpreadsheet functions
     private static $phpSpreadsheetFunctions = array(
         'ABS' => array(
             'category' => Calculation\Categories::CATEGORY_MATH_AND_TRIG,
@@ -3136,13 +3136,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/Spreadsheet.php

Indentation +79 added lines, -79 removed lines

@@ -99,65 +99,65 @@ 
     private $cellStyleXfCollection = array();
 
     /**
-    * hasMacros : this workbook have macros ?
-    *
-    * @var bool
-    */
+     * hasMacros : this workbook have macros ?
+     *
+     * @var bool
+     */
     private $hasMacros = false;
 
     /**
-    * macrosCode : all macros code (the vbaProject.bin file, this include form, code,  etc.), null if no macro
-    *
-    * @var binary
-    */
+     * macrosCode : all macros code (the vbaProject.bin file, this include form, code,  etc.), null if no macro
+     *
+     * @var binary
+     */
     private $macrosCode;
     /**
-    * macrosCertificate : if macros are signed, contains vbaProjectSignature.bin file, null if not signed
-    *
-    * @var binary
-    */
+     * macrosCertificate : if macros are signed, contains vbaProjectSignature.bin file, null if not signed
+     *
+     * @var binary
+     */
     private $macrosCertificate;
 
     /**
-    * ribbonXMLData : null if workbook is'nt Excel 2007 or not contain a customized UI
-    *
-    * @var null|string
-    */
+     * ribbonXMLData : null if workbook is'nt Excel 2007 or not contain a customized UI
+     *
+     * @var null|string
+     */
     private $ribbonXMLData;
 
     /**
-    * ribbonBinObjects : null if workbook is'nt Excel 2007 or not contain embedded objects (picture(s)) for Ribbon Elements
-    * ignored if $ribbonXMLData is null
-    *
-    * @var null|array
-    */
+     * ribbonBinObjects : null if workbook is'nt Excel 2007 or not contain embedded objects (picture(s)) for Ribbon Elements
+     * ignored if $ribbonXMLData is null
+     *
+     * @var null|array
+     */
     private $ribbonBinObjects;
 
     /**
-    * The workbook has macros ?
-    *
-    * @return true if workbook has macros, false if not
-    */
+     * The workbook has macros ?
+     *
+     * @return true if workbook has macros, false if not
+     */
     public function hasMacros()
     {
         return $this->hasMacros;
     }
 
     /**
-    * Define if a workbook has macros
-    *
-    * @param boolean $hasMacros true|false
-    */
+     * Define if a workbook has macros
+     *
+     * @param boolean $hasMacros true|false
+     */
     public function setHasMacros($hasMacros = false)
     {
         $this->hasMacros = (bool) $hasMacros;
     }
 
     /**
-    * Set the macros code
-    *
-    * @param string $macroCode string|null
-    */
+     * Set the macros code
+     *
+     * @param string $macroCode string|null
+     */
     public function setMacrosCode($macroCode = null)
     {
         $this->macrosCode = $macroCode;
@@ -165,49 +165,49 @@ 
     }
 
     /**
-    * Return the macros code
-    *
-    * @return string|null
-    */
+     * Return the macros code
+     *
+     * @return string|null
+     */
     public function getMacrosCode()
     {
         return $this->macrosCode;
     }
 
     /**
-    * Set the macros certificate
-    *
-    * @param string|null $Certificate
-    */
+     * Set the macros certificate
+     *
+     * @param string|null $Certificate
+     */
     public function setMacrosCertificate($certificate = null)
     {
         $this->macrosCertificate = $certificate;
     }
 
     /**
-    * Is the project signed ?
-    *
-    * @return boolean true|false
-    */
+     * Is the project signed ?
+     *
+     * @return boolean true|false
+     */
     public function hasMacrosCertificate()
     {
         return !is_null($this->macrosCertificate);
     }
 
     /**
-    * Return the macros certificate
-    *
-    * @return string|null
-    */
+     * Return the macros certificate
+     *
+     * @return string|null
+     */
     public function getMacrosCertificate()
     {
         return $this->macrosCertificate;
     }
 
     /**
-    * Remove all macros, certificate from spreadsheet
-    *
-    */
+     * Remove all macros, certificate from spreadsheet
+     *
+     */
     public function discardMacros()
     {
         $this->hasMacros = false;
@@ -216,9 +216,9 @@ 
     }
 
     /**
-    * set ribbon XML data
-    *
-    */
+     * set ribbon XML data
+     *
+     */
     public function setRibbonXMLData($target = null, $xmlData = null)
     {
         if (!is_null($target) && !is_null($xmlData)) {
@@ -229,10 +229,10 @@ 
     }
 
     /**
-    * retrieve ribbon XML Data
-    *
-    * return string|null|array
-    */
+     * retrieve ribbon XML Data
+     *
+     * return string|null|array
+     */
     public function getRibbonXMLData($what = 'all') //we need some constants here...
     {
         $returnData = null;
@@ -253,9 +253,9 @@ 
     }
 
     /**
-    * store binaries ribbon objects (pictures)
-    *
-    */
+     * store binaries ribbon objects (pictures)
+     *
+     */
     public function setRibbonBinObjects($BinObjectsNames = null, $BinObjectsData = null)
     {
         if (!is_null($BinObjectsNames) && !is_null($BinObjectsData)) {
@@ -265,18 +265,18 @@ 
         }
     }
     /**
-    * return the extension of a filename. Internal use for a array_map callback (php<5.3 don't like lambda function)
-    *
-    */
+     * return the extension of a filename. Internal use for a array_map callback (php<5.3 don't like lambda function)
+     *
+     */
     private function getExtensionOnly($ThePath)
     {
         return pathinfo($ThePath, PATHINFO_EXTENSION);
     }
 
     /**
-    * retrieve Binaries Ribbon Objects
-    *
-    */
+     * retrieve Binaries Ribbon Objects
+     *
+     */
     public function getRibbonBinObjects($What = 'all')
     {
         $ReturnData = null;
@@ -305,20 +305,20 @@ 
     }
 
     /**
-    * This workbook have a custom UI ?
-    *
-    * @return true|false
-    */
+     * This workbook have a custom UI ?
+     *
+     * @return true|false
+     */
     public function hasRibbon()
     {
         return !is_null($this->ribbonXMLData);
     }
 
     /**
-    * This workbook have additionnal object for the ribbon ?
-    *
-    * @return true|false
-    */
+     * This workbook have additionnal object for the ribbon ?
+     *
+     * @return true|false
+     */
     public function hasRibbonBinObjects()
     {
         return !is_null($this->ribbonBinObjects);
@@ -353,9 +353,9 @@ 
         return null;
     }
 
-     /**
-     * Create a new PhpSpreadsheet with one Worksheet
-     */
+        /**
+         * Create a new PhpSpreadsheet with one Worksheet
+         */
     public function __construct()
     {
         $this->uniqueID = uniqid();