PHPOffice / PhpSpreadsheet

Examples/01simple-download-xlsx.php

Indentation +7 added lines, -7 removed lines

@@ -32,7 +32,7 @@ 
 date_default_timezone_set('Europe/London');
 
 if (PHP_SAPI == 'cli')
-	die('This example should only be run from a Web Browser');
+    die('This example should only be run from a Web Browser');
 
 /** Include PHPExcel */
 require_once dirname(__FILE__) . '/../src/Bootstrap.php';
@@ -43,12 +43,12 @@ 
 
 // Set document properties
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
-							 ->setLastModifiedBy("Maarten Balliauw")
-							 ->setTitle("Office 2007 XLSX Test Document")
-							 ->setSubject("Office 2007 XLSX Test Document")
-							 ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
-							 ->setKeywords("office 2007 openxml php")
-							 ->setCategory("Test result file");
+                                ->setLastModifiedBy("Maarten Balliauw")
+                                ->setTitle("Office 2007 XLSX Test Document")
+                                ->setSubject("Office 2007 XLSX Test Document")
+                                ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
+                                ->setKeywords("office 2007 openxml php")
+                                ->setCategory("Test result file");
 
 
 // Add some data

Examples/33chartcreate-radar.php

Indentation +37 added lines, -37 removed lines

@@ -43,21 +43,21 @@ 
 $objPHPExcel = new \PHPExcel\Spreadsheet();
 $objWorksheet = $objPHPExcel->getActiveSheet();
 $objWorksheet->fromArray(
-	array(
-		array('',	2010,	2011,	2012),
-		array('Jan',   47,   45,		71),
-		array('Feb',   56,   73,		86),
-		array('Mar',   52,   61,		69),
-		array('Apr',   40,   52,		60),
-		array('May',   42,   55,		71),
-		array('Jun',   58,   63,		76),
-		array('Jul',   53,   61,		89),
-		array('Aug',   46,   69,		85),
-		array('Sep',   62,   75,		81),
-		array('Oct',   51,   70,		96),
-		array('Nov',   55,   66,		89),
-		array('Dec',   68,   62,		0),
-	)
+    array(
+        array('',	2010,	2011,	2012),
+        array('Jan',   47,   45,		71),
+        array('Feb',   56,   73,		86),
+        array('Mar',   52,   61,		69),
+        array('Apr',   40,   52,		60),
+        array('May',   42,   55,		71),
+        array('Jun',   58,   63,		76),
+        array('Jul',   53,   61,		89),
+        array('Aug',   46,   69,		85),
+        array('Sep',   62,   75,		81),
+        array('Oct',   51,   70,		96),
+        array('Nov',   55,   66,		89),
+        array('Dec',   68,   62,		0),
+    )
 );
 
 
@@ -69,8 +69,8 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesLabels = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),	//	2011
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1),	//	2012
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),	//	2011
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1),	//	2012
 );
 //	Set the X-Axis Labels
 //		Datatype
@@ -80,8 +80,8 @@ 
 //		Data values
 //		Data Marker
 $xAxisTickValues = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$13', NULL, 12),	//	Jan to Dec
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$13', NULL, 12),	//	Jan to Dec
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$13', NULL, 12),	//	Jan to Dec
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$13', NULL, 12),	//	Jan to Dec
 );
 //	Set the Data values for each data series we want to plot
 //		Datatype
@@ -91,21 +91,21 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesValues = array(
-	new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$13', NULL, 12),
-	new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$13', NULL, 12),
+    new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$13', NULL, 12),
+    new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$13', NULL, 12),
 );
 
 //	Build the dataseries
 $series = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_RADARCHART,	// plotType
-	NULL,											// plotGrouping (Radar charts don't have any grouping)
-	range(0, count($dataSeriesValues)-1),			// plotOrder
-	$dataSeriesLabels,								// plotLabel
-	$xAxisTickValues,								// plotCategory
-	$dataSeriesValues,								// plotValues
+    \PHPExcel\Chart\DataSeries::TYPE_RADARCHART,	// plotType
+    NULL,											// plotGrouping (Radar charts don't have any grouping)
+    range(0, count($dataSeriesValues)-1),			// plotOrder
+    $dataSeriesLabels,								// plotLabel
+    $xAxisTickValues,								// plotCategory
+    $dataSeriesValues,								// plotValues
     NULL,                                           // plotDirection
-	NULL,											// smooth line
-	\PHPExcel\Chart\DataSeries::STYLE_MARKER		// plotStyle
+    NULL,											// smooth line
+    \PHPExcel\Chart\DataSeries::STYLE_MARKER		// plotStyle
 );
 
 //	Set up a layout object for the Pie chart
@@ -121,14 +121,14 @@ 
 
 //	Create the chart
 $chart = new \PHPExcel\Chart(
-	'chart1',		// name
-	$title,			// title
-	$legend,		// legend
-	$plotArea,		// plotArea
-	true,			// plotVisibleOnly
-	0,				// displayBlanksAs
-	NULL,			// xAxisLabel
-	NULL			// yAxisLabel		- Radar charts don't have a Y-Axis
+    'chart1',		// name
+    $title,			// title
+    $legend,		// legend
+    $plotArea,		// plotArea
+    true,			// plotVisibleOnly
+    0,				// displayBlanksAs
+    NULL,			// xAxisLabel
+    NULL			// yAxisLabel		- Radar charts don't have a Y-Axis
 );
 
 //	Set the position where the chart should appear in the worksheet

tests/PhpSpreadsheet/Worksheet/WorksheetColumnTest.php

Indentation +2 added lines, -2 removed lines

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

tests/PhpSpreadsheet/Worksheet/ColumnIteratorTest.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('current')
-                 ->will($this->returnValue($this->mockColumn));
+                    ->method('current')
+                    ->will($this->returnValue($this->mockColumn));
     }
 
 

tests/PhpSpreadsheet/Worksheet/ColumnCellIteratorTest.php

Indentation +4 added lines, -4 removed lines

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

tests/PhpSpreadsheet/Worksheet/AutoFilter/ColumnTest.php

Indentation +4 added lines, -4 removed lines

@@ -111,7 +111,7 @@ 
     {
         $attributeSet = array(    'val' => 100,
                                 'maxVal' => 200
-                             );
+                                );
 
         //    Setters return the instance to implement the fluent interface
         $result = $this->_testAutoFilterColumnObject->setAttributes($attributeSet);
@@ -122,7 +122,7 @@ 
     {
         $attributeSet = array(    'val' => 100,
                                 'maxVal' => 200
-                             );
+                                );
 
         $this->_testAutoFilterColumnObject->setAttributes($attributeSet);
 
@@ -135,7 +135,7 @@ 
     {
         $attributeSet = array(    'val' => 100,
                                 'maxVal' => 200
-                             );
+                                );
 
         foreach ($attributeSet as $attributeName => $attributeValue) {
             //    Setters return the instance to implement the fluent interface
@@ -148,7 +148,7 @@ 
     {
         $attributeSet = array(    'val' => 100,
                                 'maxVal' => 200
-                             );
+                                );
 
         $this->_testAutoFilterColumnObject->setAttributes($attributeSet);
 

tests/PhpSpreadsheet/Worksheet/RowIteratorTest.php

Indentation +4 added lines, -4 removed lines

@@ -18,11 +18,11 @@
             ->getMock();
 
         $this->mockWorksheet->expects($this->any())
-                 ->method('getHighestRow')
-                 ->will($this->returnValue(5));
+                    ->method('getHighestRow')
+                    ->will($this->returnValue(5));
         $this->mockWorksheet->expects($this->any())
-                 ->method('current')
-                 ->will($this->returnValue($this->mockRow));
+                    ->method('current')
+                    ->will($this->returnValue($this->mockRow));
     }
 
 

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'));
     }