PHPOffice / PhpSpreadsheet

tests/PhpSpreadsheet/Worksheet/RowCellIteratorTest.php

Indentation +4 added lines, -4 removed lines

@@ -18,11 +18,11 @@
             ->getMock();
 
         $this->mockWorksheet->expects($this->any())
-                 ->method('getHighestColumn')
-                 ->will($this->returnValue('E'));
+                    ->method('getHighestColumn')
+                    ->will($this->returnValue('E'));
         $this->mockWorksheet->expects($this->any())
-                 ->method('getCellByColumnAndRow')
-                 ->will($this->returnValue($this->mockCell));
+                    ->method('getCellByColumnAndRow')
+                    ->will($this->returnValue($this->mockCell));
     }
 
 

tests/PhpSpreadsheet/Worksheet/WorksheetRowTest.php

Indentation +2 added lines, -2 removed lines

@@ -13,8 +13,8 @@
             ->disableOriginalConstructor()
             ->getMock();
         $this->mockWorksheet->expects($this->any())
-                 ->method('getHighestColumn')
-                 ->will($this->returnValue('E'));
+                    ->method('getHighestColumn')
+                    ->will($this->returnValue('E'));
     }
 
 

tests/PhpSpreadsheet/Cell/DefaultValueBinderTest.php

Indentation +2 added lines, -2 removed lines

@@ -24,8 +24,8 @@
             ->getMock();
         // Configure the stub.
         $this->cellStub->expects($this->any())
-             ->method('setValueExplicit')
-             ->will($this->returnValue(true));
+                ->method('setValueExplicit')
+                ->will($this->returnValue(true));
 
     }
 

tests/PhpSpreadsheet/Cell/AdvancedValueBinderTest.php

Indentation +11 added lines, -11 removed lines

@@ -45,22 +45,22 @@
             ->disableOriginalConstructor()
             ->getMock();
         $cache->expects($this->any())
-                 ->method('getParent')
-                 ->will($this->returnValue($sheet));
+                    ->method('getParent')
+                    ->will($this->returnValue($sheet));
 
         $sheet->expects($this->once())
-                 ->method('getStyle')
-                 ->will($this->returnSelf());
+                    ->method('getStyle')
+                    ->will($this->returnSelf());
         $sheet->expects($this->once())
-                 ->method('getNumberFormat')
-                 ->will($this->returnSelf());
+                    ->method('getNumberFormat')
+                    ->will($this->returnSelf());
         $sheet->expects($this->once())
-                 ->method('setFormatCode')
-                 ->with($format)
-                 ->will($this->returnSelf());
+                    ->method('setFormatCode')
+                    ->with($format)
+                    ->will($this->returnSelf());
         $sheet->expects($this->any())
-                 ->method('getCellCacheController')
-                 ->will($this->returnValue($cache));
+                    ->method('getCellCacheController')
+                    ->will($this->returnValue($cache));
 
         \PHPExcel\Shared\StringHelper::setCurrencyCode($currencyCode);
         \PHPExcel\Shared\StringHelper::setDecimalSeparator($decimalSeparator);

Examples/runall.php

Indentation +85 added lines, -85 removed lines

@@ -29,105 +29,105 @@
 error_reporting(E_ALL);
 
 if (PHP_SAPI != 'cli') {
-	die ('This script executes all tests, and should only be run from the command line');
+    die ('This script executes all tests, and should only be run from the command line');
 }
 
 // List of tests
 $aTests = array(
-	  '01simple.php'
-	, '01simplePCLZip.php'
-	, '02types.php'
-	, '02types-xls.php'
-	, '03formulas.php'
-	, '04printing.php'
-	, '05featuredemo.php'
-	, '06largescale.php'
-	, '06largescale-with-cellcaching.php'
-	, '06largescale-with-cellcaching-sqlite.php'
-	, '06largescale-with-cellcaching-sqlite3.php'
-	, '06largescale-xls.php'
-	, '07reader.php'
-	, '07readerPCLZip.php'
-	, '08conditionalformatting.php'
-	, '08conditionalformatting2.php'
-	, '09pagebreaks.php'
-	, '10autofilter.php'
-	, '10autofilter-selection-1.php'
-	, '10autofilter-selection-2.php'
-	, '10autofilter-selection-display.php'
-	, '11documentsecurity.php'
-	, '11documentsecurity-xls.php'
-	, '12cellProtection.php'
-	, '13calculation.php'
+        '01simple.php'
+    , '01simplePCLZip.php'
+    , '02types.php'
+    , '02types-xls.php'
+    , '03formulas.php'
+    , '04printing.php'
+    , '05featuredemo.php'
+    , '06largescale.php'
+    , '06largescale-with-cellcaching.php'
+    , '06largescale-with-cellcaching-sqlite.php'
+    , '06largescale-with-cellcaching-sqlite3.php'
+    , '06largescale-xls.php'
+    , '07reader.php'
+    , '07readerPCLZip.php'
+    , '08conditionalformatting.php'
+    , '08conditionalformatting2.php'
+    , '09pagebreaks.php'
+    , '10autofilter.php'
+    , '10autofilter-selection-1.php'
+    , '10autofilter-selection-2.php'
+    , '10autofilter-selection-display.php'
+    , '11documentsecurity.php'
+    , '11documentsecurity-xls.php'
+    , '12cellProtection.php'
+    , '13calculation.php'
     , '13calculationCyclicFormulae.php'
-	, '14excel5.php'
-	, '15datavalidation.php'
-	, '15datavalidation-xls.php'
-	, '16csv.php'
-	, '17html.php'
-	, '18extendedcalculation.php'
-	, '19namedrange.php'
-	, '20readexcel5.php'
-	, '21pdf.php'
-	, '22heavilyformatted.php'
-	, '23sharedstyles.php'
-	, '24readfilter.php'
-	, '25inmemoryimage.php'
-	, '26utf8.php'
-	, '27imagesexcel5.php'
-	, '28iterator.php'
-	, '29advancedvaluebinder.php'
-	, '30template.php'
-	, '31docproperties_write.php'
-	, '31docproperties_write-xls.php'
-	, '32chartreadwrite.php'
-	, '33chartcreate-area.php'
-	, '33chartcreate-bar.php'
-	, '33chartcreate-bar-stacked.php'
-	, '33chartcreate-column.php'
-	, '33chartcreate-column-2.php'
-	, '33chartcreate-line.php'
-	, '33chartcreate-pie.php'
-	, '33chartcreate-radar.php'
-	, '33chartcreate-scatter.php'
-	, '33chartcreate-stock.php'
-	, '33chartcreate-multiple-charts.php'
-	, '33chartcreate-composite.php'
-	, '34chartupdate.php'
-	, '35chartrender.php'
-	, '36chartreadwriteHTML.php'
-	, '36chartreadwritePDF.php'
-	, '37page_layout_view.php'
-	, '38cloneWorksheet.php'
+    , '14excel5.php'
+    , '15datavalidation.php'
+    , '15datavalidation-xls.php'
+    , '16csv.php'
+    , '17html.php'
+    , '18extendedcalculation.php'
+    , '19namedrange.php'
+    , '20readexcel5.php'
+    , '21pdf.php'
+    , '22heavilyformatted.php'
+    , '23sharedstyles.php'
+    , '24readfilter.php'
+    , '25inmemoryimage.php'
+    , '26utf8.php'
+    , '27imagesexcel5.php'
+    , '28iterator.php'
+    , '29advancedvaluebinder.php'
+    , '30template.php'
+    , '31docproperties_write.php'
+    , '31docproperties_write-xls.php'
+    , '32chartreadwrite.php'
+    , '33chartcreate-area.php'
+    , '33chartcreate-bar.php'
+    , '33chartcreate-bar-stacked.php'
+    , '33chartcreate-column.php'
+    , '33chartcreate-column-2.php'
+    , '33chartcreate-line.php'
+    , '33chartcreate-pie.php'
+    , '33chartcreate-radar.php'
+    , '33chartcreate-scatter.php'
+    , '33chartcreate-stock.php'
+    , '33chartcreate-multiple-charts.php'
+    , '33chartcreate-composite.php'
+    , '34chartupdate.php'
+    , '35chartrender.php'
+    , '36chartreadwriteHTML.php'
+    , '36chartreadwritePDF.php'
+    , '37page_layout_view.php'
+    , '38cloneWorksheet.php'
     , '39dropdown.php'
-	, '40duplicateStyle.php'
-	, '41password.php'
-	, '42richText.php'
+    , '40duplicateStyle.php'
+    , '41password.php'
+    , '42richText.php'
     , '43mergeWorkbooks.php'
     , '44worksheetInfo.php'
-	, 'OOCalcReader.php'
-	, 'OOCalcReaderPCLZip.php'
-	, 'SylkReader.php'
-	, 'Excel2003XMLReader.php'
-	, 'XMLReader.php'
-	, 'GnumericReader.php'
+    , 'OOCalcReader.php'
+    , 'OOCalcReaderPCLZip.php'
+    , 'SylkReader.php'
+    , 'Excel2003XMLReader.php'
+    , 'XMLReader.php'
+    , 'GnumericReader.php'
 );
 
 // First, clear all previous run results
 foreach ($aTests as $sTest) {
-	@unlink( str_replace('.php', '.xls', 	$sTest) );
-	@unlink( str_replace('.php', '.xlsx', 	$sTest) );
-	@unlink( str_replace('.php', '.csv',	$sTest) );
-	@unlink( str_replace('.php', '.htm',	$sTest) );
-	@unlink( str_replace('.php', '.pdf',	$sTest) );
+    @unlink( str_replace('.php', '.xls', 	$sTest) );
+    @unlink( str_replace('.php', '.xlsx', 	$sTest) );
+    @unlink( str_replace('.php', '.csv',	$sTest) );
+    @unlink( str_replace('.php', '.htm',	$sTest) );
+    @unlink( str_replace('.php', '.pdf',	$sTest) );
 }
 
 // Run all tests
 foreach ($aTests as $sTest) {
-	echo '============== TEST ==============' . "\r\n";
-	echo 'Test name: ' . $sTest . "\r\n";
-	echo "\r\n";
-	echo shell_exec('php ' . $sTest);
-	echo "\r\n";
-	echo "\r\n";
+    echo '============== TEST ==============' . "\r\n";
+    echo 'Test name: ' . $sTest . "\r\n";
+    echo "\r\n";
+    echo shell_exec('php ' . $sTest);
+    echo "\r\n";
+    echo "\r\n";
 }
\ No newline at end of file

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))) {