Inspection of "Report coverage to Scrutinizer" - PHPOffice/PhpSpreadsheet - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — develop ( 539a89...685e29 )

by Adrien

created 2016-08-16 14:42 UTC

Status

Indentation +13 added lines, -13 removed lines patch added patch discarded remove patch

@@ -52,12 +52,12 @@  discard block
 block discarded – undo
 // Set document properties
 echo date('H:i:s') , " Set properties" , EOL;
 $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");
 
 
 // Create a first sheet
@@ -79,8 +79,8 @@  discard block
 block discarded – undo
 // Set outline levels
 echo date('H:i:s') , " Set outline levels" , EOL;
 $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setOutlineLevel(1)
-                                                       ->setVisible(false)
-                                                       ->setCollapsed(true);
+                                                        ->setVisible(false)
+                                                        ->setCollapsed(true);
 
 // Freeze panes
 echo date('H:i:s') , " Freeze panes" , EOL;
@@ -94,11 +94,11 @@  discard block
 block discarded – undo
 
 // Add data
 for ($i = 2; $i <= 5000; $i++) {
-	$objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i")
-	                              ->setCellValue('B' . $i, "LName $i")
-	                              ->setCellValue('C' . $i, "PhoneNo $i")
-	                              ->setCellValue('D' . $i, "FaxNo $i")
-	                              ->setCellValue('E' . $i, true);
+    $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i")
+                                    ->setCellValue('B' . $i, "LName $i")
+                                    ->setCellValue('C' . $i, "PhoneNo $i")
+                                    ->setCellValue('D' . $i, "FaxNo $i")
+                                    ->setCellValue('E' . $i, true);
 }
 
 

Please login to merge, or discard this patch.

Examples/07readerPCLZip.php 1 patch

Indentation +1 added lines, -1 removed lines patch added patch discarded remove patch

@@ -38,7 +38,7 @@
 block discarded – undo
 
 
 if (!file_exists("05featuredemo.xlsx")) {
-	exit("Please run 05featuredemo.php first." . EOL);
+    exit("Please run 05featuredemo.php first." . EOL);
 }
 
 echo date('H:i:s') , " Load from Excel2007 file" , EOL;

Please login to merge, or discard this patch.

Examples/33chartcreate-scatter.php 1 patch

Indentation +30 added lines, -30 removed lines patch added patch discarded remove patch

@@ -43,13 +43,13 @@  discard block
 block discarded – undo
 $objPHPExcel = new \PHPExcel\Spreadsheet();
 $objWorksheet = $objPHPExcel->getActiveSheet();
 $objWorksheet->fromArray(
-	array(
-		array('',	2010,	2011,	2012),
-		array('Q1',   12,   15,		21),
-		array('Q2',   56,   73,		86),
-		array('Q3',   52,   61,		69),
-		array('Q4',   30,   32,		0),
-	)
+    array(
+        array('',	2010,	2011,	2012),
+        array('Q1',   12,   15,		21),
+        array('Q2',   56,   73,		86),
+        array('Q3',   52,   61,		69),
+        array('Q4',   30,   32,		0),
+    )
 );
 
 //	Set the Labels for each data series we want to plot
@@ -60,13 +60,13 @@  discard block
 block discarded – undo
 //		Data values
 //		Data Marker
 $dataSeriesLabels = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1),	//	2010
-	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!$B$1', NULL, 1),	//	2010
+    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
 $xAxisTickValues = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4),	//	Q1 to Q4
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4),	//	Q1 to Q4
 );
 //	Set the Data values for each data series we want to plot
 //		Datatype
@@ -76,22 +76,22 @@  discard block
 block discarded – undo
 //		Data values
 //		Data Marker
 $dataSeriesValues = array(
-	new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$B$2:$B$5', NULL, 4),
-	new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4),
-	new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$5', NULL, 4),
+    new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$B$2:$B$5', NULL, 4),
+    new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4),
+    new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$5', NULL, 4),
 );
 
 //	Build the dataseries
 $series = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_SCATTERCHART,	// plotType
-	NULL,											// plotGrouping (Scatter charts don't have any grouping)
-	range(0, count($dataSeriesValues)-1),			// plotOrder
-	$dataSeriesLabels,								// plotLabel
-	$xAxisTickValues,								// plotCategory
-	$dataSeriesValues,								// plotValues
+    \PHPExcel\Chart\DataSeries::TYPE_SCATTERCHART,	// plotType
+    NULL,											// plotGrouping (Scatter 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_LINEMARKER		// plotStyle
+    NULL,											// smooth line
+    \PHPExcel\Chart\DataSeries::STYLE_LINEMARKER		// plotStyle
 );
 
 //	Set the series in the plot area
@@ -105,14 +105,14 @@  discard block
 block discarded – undo
 
 //	Create the chart
 $chart = new \PHPExcel\Chart(
-	'chart1',		// name
-	$title,			// title
-	$legend,		// legend
-	$plotArea,		// plotArea
-	true,			// plotVisibleOnly
-	0,				// displayBlanksAs
-	NULL,			// xAxisLabel
-	$yAxisLabel		// yAxisLabel
+    'chart1',		// name
+    $title,			// title
+    $legend,		// legend
+    $plotArea,		// plotArea
+    true,			// plotVisibleOnly
+    0,				// displayBlanksAs
+    NULL,			// xAxisLabel
+    $yAxisLabel		// yAxisLabel
 );
 
 //	Set the position where the chart should appear in the worksheet

Please login to merge, or discard this patch.

Examples/25inmemoryimage.php 1 patch

Indentation +6 added lines, -6 removed lines patch added patch discarded remove patch

@@ -45,12 +45,12 @@
 block discarded – undo
 // Set document properties
 echo date('H:i:s') , " Set document properties" , EOL;
 $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

Please login to merge, or discard this patch.

Examples/11documentsecurity.php 1 patch

Indentation +6 added lines, -6 removed lines patch added patch discarded remove patch

@@ -45,12 +45,12 @@
 block discarded – undo
 // Set document properties
 echo date('H:i:s') , " Set document properties" , EOL;
 $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

Please login to merge, or discard this patch.

Examples/01simple-download-ods.php 1 patch

Indentation +7 added lines, -7 removed lines patch added patch discarded remove patch

@@ -32,7 +32,7 @@  discard block
 block discarded – undo
 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 @@  discard block
 block discarded – undo
 
 // 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

Please login to merge, or discard this patch.

Examples/44worksheetInfo.php 1 patch

Indentation +1 added lines, -1 removed lines patch added patch discarded remove patch

@@ -38,7 +38,7 @@
 block discarded – undo
 
 
 if (!file_exists("05featuredemo.xlsx")) {
-	exit("Please run 05featuredemo.php first." . EOL);
+    exit("Please run 05featuredemo.php first." . EOL);
 }
 
 echo date('H:i:s') , " Load from Excel2007 file" , EOL;

Please login to merge, or discard this patch.

Examples/01simple.php 1 patch

Indentation +6 added lines, -6 removed lines patch added patch discarded remove patch

@@ -44,12 +44,12 @@
 block discarded – undo
 // Set document properties
 echo date('H:i:s') , " Set document properties" , EOL;
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
-	->setLastModifiedBy("Maarten Balliauw")
-	->setTitle("PHPExcel Test Document")
-	->setSubject("PHPExcel Test Document")
-	->setDescription("Test document for PHPExcel, generated using PHP classes.")
-	->setKeywords("office PHPExcel php")
-	->setCategory("Test result file");
+    ->setLastModifiedBy("Maarten Balliauw")
+    ->setTitle("PHPExcel Test Document")
+    ->setSubject("PHPExcel Test Document")
+    ->setDescription("Test document for PHPExcel, generated using PHP classes.")
+    ->setKeywords("office PHPExcel php")
+    ->setCategory("Test result file");
 
 
 // Add some data

Please login to merge, or discard this patch.

Examples/15datavalidation-xls.php 1 patch

Indentation +18 added lines, -18 removed lines patch added patch discarded remove patch

@@ -47,30 +47,30 @@
 block discarded – undo
 // Set document properties
 echo date('H:i:s') , " Set document properties" , EOL;
 $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");
 
 
 // Create a first sheet
 echo date('H:i:s') , " Add data" , EOL;
 $objPHPExcel->setActiveSheetIndex(0);
 $objPHPExcel->getActiveSheet()->setCellValue('A1', "Cell B3 and B5 contain data validation...")
-                              ->setCellValue('A3', "Number:")
-                              ->setCellValue('B3', "10")
-                              ->setCellValue('A5', "List:")
-                              ->setCellValue('B5', "Item A")
-                              ->setCellValue('A7', "List #2:")
-                              ->setCellValue('B7', "Item #2")
-                              ->setCellValue('D2', "Item #1")
-                              ->setCellValue('D3', "Item #2")
-                              ->setCellValue('D4', "Item #3")
-                              ->setCellValue('D5', "Item #4")
-                              ->setCellValue('D6', "Item #5")
-                              ;
+                                ->setCellValue('A3', "Number:")
+                                ->setCellValue('B3', "10")
+                                ->setCellValue('A5', "List:")
+                                ->setCellValue('B5', "Item A")
+                                ->setCellValue('A7', "List #2:")
+                                ->setCellValue('B7', "Item #2")
+                                ->setCellValue('D2', "Item #1")
+                                ->setCellValue('D3', "Item #2")
+                                ->setCellValue('D4', "Item #3")
+                                ->setCellValue('D5', "Item #4")
+                                ->setCellValue('D6', "Item #5")
+                                ;
 
 
 // Set data validation

Please login to merge, or discard this patch.

		@@ -52,12 +52,12 @@ discard block
		block discarded – undo
52	52	// Set document properties
53	53	echo date('H:i:s') , " Set properties" , EOL;
54	54	$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
55		- ->setLastModifiedBy("Maarten Balliauw")
56		- ->setTitle("Office 2007 XLSX Test Document")
57		- ->setSubject("Office 2007 XLSX Test Document")
58		- ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
59		- ->setKeywords("office 2007 openxml php")
60		- ->setCategory("Test result file");
	55	+ ->setLastModifiedBy("Maarten Balliauw")
	56	+ ->setTitle("Office 2007 XLSX Test Document")
	57	+ ->setSubject("Office 2007 XLSX Test Document")
	58	+ ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
	59	+ ->setKeywords("office 2007 openxml php")
	60	+ ->setCategory("Test result file");
61	61
62	62
63	63	// Create a first sheet
		@@ -79,8 +79,8 @@ discard block
		block discarded – undo
79	79	// Set outline levels
80	80	echo date('H:i:s') , " Set outline levels" , EOL;
81	81	$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setOutlineLevel(1)
82		- ->setVisible(false)
83		- ->setCollapsed(true);
	82	+ ->setVisible(false)
	83	+ ->setCollapsed(true);
84	84
85	85	// Freeze panes
86	86	echo date('H:i:s') , " Freeze panes" , EOL;
		@@ -94,11 +94,11 @@ discard block
		block discarded – undo
94	94
95	95	// Add data
96	96	for ($i = 2; $i <= 5000; $i++) {
97		- $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i")
98		- ->setCellValue('B' . $i, "LName $i")
99		- ->setCellValue('C' . $i, "PhoneNo $i")
100		- ->setCellValue('D' . $i, "FaxNo $i")
101		- ->setCellValue('E' . $i, true);
	97	+ $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i")
	98	+ ->setCellValue('B' . $i, "LName $i")
	99	+ ->setCellValue('C' . $i, "PhoneNo $i")
	100	+ ->setCellValue('D' . $i, "FaxNo $i")
	101	+ ->setCellValue('E' . $i, true);
102	102	}
103	103
104	104

		@@ -38,7 +38,7 @@
		block discarded – undo
38	38
39	39
40	40	if (!file_exists("05featuredemo.xlsx")) {
41		- exit("Please run 05featuredemo.php first." . EOL);
	41	+ exit("Please run 05featuredemo.php first." . EOL);
42	42	}
43	43
44	44	echo date('H:i:s') , " Load from Excel2007 file" , EOL;

		@@ -43,13 +43,13 @@ discard block
		block discarded – undo
43	43	$objPHPExcel = new \PHPExcel\Spreadsheet();
44	44	$objWorksheet = $objPHPExcel->getActiveSheet();
45	45	$objWorksheet->fromArray(
46		- array(
47		- array('', 2010, 2011, 2012),
48		- array('Q1', 12, 15, 21),
49		- array('Q2', 56, 73, 86),
50		- array('Q3', 52, 61, 69),
51		- array('Q4', 30, 32, 0),
52		- )
	46	+ array(
	47	+ array('', 2010, 2011, 2012),
	48	+ array('Q1', 12, 15, 21),
	49	+ array('Q2', 56, 73, 86),
	50	+ array('Q3', 52, 61, 69),
	51	+ array('Q4', 30, 32, 0),
	52	+ )
53	53	);
54	54
55	55	// Set the Labels for each data series we want to plot
		@@ -60,13 +60,13 @@ discard block
		block discarded – undo
60	60	// Data values
61	61	// Data Marker
62	62	$dataSeriesLabels = array(
63		- new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1), // 2010
64		- new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), // 2011
65		- new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1), // 2012
	63	+ new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1), // 2010
	64	+ new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), // 2011
	65	+ new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1), // 2012
66	66	);
67	67	// Set the X-Axis Labels
68	68	$xAxisTickValues = array(
69		- new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4), // Q1 to Q4
	69	+ new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4), // Q1 to Q4
70	70	);
71	71	// Set the Data values for each data series we want to plot
72	72	// Datatype
		@@ -76,22 +76,22 @@ discard block
		block discarded – undo
76	76	// Data values
77	77	// Data Marker
78	78	$dataSeriesValues = array(
79		- new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$B$2:$B$5', NULL, 4),
80		- new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4),
81		- new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$5', NULL, 4),
	79	+ new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$B$2:$B$5', NULL, 4),
	80	+ new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4),
	81	+ new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$5', NULL, 4),
82	82	);
83	83
84	84	// Build the dataseries
85	85	$series = new \PHPExcel\Chart\DataSeries(
86		- \PHPExcel\Chart\DataSeries::TYPE_SCATTERCHART, // plotType
87		- NULL, // plotGrouping (Scatter charts don't have any grouping)
88		- range(0, count($dataSeriesValues)-1), // plotOrder
89		- $dataSeriesLabels, // plotLabel
90		- $xAxisTickValues, // plotCategory
91		- $dataSeriesValues, // plotValues
	86	+ \PHPExcel\Chart\DataSeries::TYPE_SCATTERCHART, // plotType
	87	+ NULL, // plotGrouping (Scatter charts don't have any grouping)
	88	+ range(0, count($dataSeriesValues)-1), // plotOrder
	89	+ $dataSeriesLabels, // plotLabel
	90	+ $xAxisTickValues, // plotCategory
	91	+ $dataSeriesValues, // plotValues
92	92	NULL, // plotDirection
93		- NULL, // smooth line
94		- \PHPExcel\Chart\DataSeries::STYLE_LINEMARKER // plotStyle
	93	+ NULL, // smooth line
	94	+ \PHPExcel\Chart\DataSeries::STYLE_LINEMARKER // plotStyle
95	95	);
96	96
97	97	// Set the series in the plot area
		@@ -105,14 +105,14 @@ discard block
		block discarded – undo
105	105
106	106	// Create the chart
107	107	$chart = new \PHPExcel\Chart(
108		- 'chart1', // name
109		- $title, // title
110		- $legend, // legend
111		- $plotArea, // plotArea
112		- true, // plotVisibleOnly
113		- 0, // displayBlanksAs
114		- NULL, // xAxisLabel
115		- $yAxisLabel // yAxisLabel
	108	+ 'chart1', // name
	109	+ $title, // title
	110	+ $legend, // legend
	111	+ $plotArea, // plotArea
	112	+ true, // plotVisibleOnly
	113	+ 0, // displayBlanksAs
	114	+ NULL, // xAxisLabel
	115	+ $yAxisLabel // yAxisLabel
116	116	);
117	117
118	118	// Set the position where the chart should appear in the worksheet

		@@ -45,12 +45,12 @@
		block discarded – undo
45	45	// Set document properties
46	46	echo date('H:i:s') , " Set document properties" , EOL;
47	47	$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
48		- ->setLastModifiedBy("Maarten Balliauw")
49		- ->setTitle("Office 2007 XLSX Test Document")
50		- ->setSubject("Office 2007 XLSX Test Document")
51		- ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
52		- ->setKeywords("office 2007 openxml php")
53		- ->setCategory("Test result file");
	48	+ ->setLastModifiedBy("Maarten Balliauw")
	49	+ ->setTitle("Office 2007 XLSX Test Document")
	50	+ ->setSubject("Office 2007 XLSX Test Document")
	51	+ ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
	52	+ ->setKeywords("office 2007 openxml php")
	53	+ ->setCategory("Test result file");
54	54
55	55
56	56	// Add some data

		@@ -32,7 +32,7 @@ discard block
		block discarded – undo
32	32	date_default_timezone_set('Europe/London');
33	33
34	34	if (PHP_SAPI == 'cli')
35		- die('This example should only be run from a Web Browser');
	35	+ die('This example should only be run from a Web Browser');
36	36
37	37	/** Include PHPExcel */
38	38	require_once dirname(__FILE__) . '/../src/Bootstrap.php';
		@@ -43,12 +43,12 @@ discard block
		block discarded – undo
43	43
44	44	// Set document properties
45	45	$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
46		- ->setLastModifiedBy("Maarten Balliauw")
47		- ->setTitle("Office 2007 XLSX Test Document")
48		- ->setSubject("Office 2007 XLSX Test Document")
49		- ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
50		- ->setKeywords("office 2007 openxml php")
51		- ->setCategory("Test result file");
	46	+ ->setLastModifiedBy("Maarten Balliauw")
	47	+ ->setTitle("Office 2007 XLSX Test Document")
	48	+ ->setSubject("Office 2007 XLSX Test Document")
	49	+ ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
	50	+ ->setKeywords("office 2007 openxml php")
	51	+ ->setCategory("Test result file");
52	52
53	53
54	54	// Add some data

		@@ -44,12 +44,12 @@
		block discarded – undo
44	44	// Set document properties
45	45	echo date('H:i:s') , " Set document properties" , EOL;
46	46	$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
47		- ->setLastModifiedBy("Maarten Balliauw")
48		- ->setTitle("PHPExcel Test Document")
49		- ->setSubject("PHPExcel Test Document")
50		- ->setDescription("Test document for PHPExcel, generated using PHP classes.")
51		- ->setKeywords("office PHPExcel php")
52		- ->setCategory("Test result file");
	47	+ ->setLastModifiedBy("Maarten Balliauw")
	48	+ ->setTitle("PHPExcel Test Document")
	49	+ ->setSubject("PHPExcel Test Document")
	50	+ ->setDescription("Test document for PHPExcel, generated using PHP classes.")
	51	+ ->setKeywords("office PHPExcel php")
	52	+ ->setCategory("Test result file");
53	53
54	54
55	55	// Add some data

		@@ -47,30 +47,30 @@
		block discarded – undo
47	47	// Set document properties
48	48	echo date('H:i:s') , " Set document properties" , EOL;
49	49	$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
50		- ->setLastModifiedBy("Maarten Balliauw")
51		- ->setTitle("Office 2007 XLSX Test Document")
52		- ->setSubject("Office 2007 XLSX Test Document")
53		- ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
54		- ->setKeywords("office 2007 openxml php")
55		- ->setCategory("Test result file");
	50	+ ->setLastModifiedBy("Maarten Balliauw")
	51	+ ->setTitle("Office 2007 XLSX Test Document")
	52	+ ->setSubject("Office 2007 XLSX Test Document")
	53	+ ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
	54	+ ->setKeywords("office 2007 openxml php")
	55	+ ->setCategory("Test result file");
56	56
57	57
58	58	// Create a first sheet
59	59	echo date('H:i:s') , " Add data" , EOL;
60	60	$objPHPExcel->setActiveSheetIndex(0);
61	61	$objPHPExcel->getActiveSheet()->setCellValue('A1', "Cell B3 and B5 contain data validation...")
62		- ->setCellValue('A3', "Number:")
63		- ->setCellValue('B3', "10")
64		- ->setCellValue('A5', "List:")
65		- ->setCellValue('B5', "Item A")
66		- ->setCellValue('A7', "List #2:")
67		- ->setCellValue('B7', "Item #2")
68		- ->setCellValue('D2', "Item #1")
69		- ->setCellValue('D3', "Item #2")
70		- ->setCellValue('D4', "Item #3")
71		- ->setCellValue('D5', "Item #4")
72		- ->setCellValue('D6', "Item #5")
73		- ;
	62	+ ->setCellValue('A3', "Number:")
	63	+ ->setCellValue('B3', "10")
	64	+ ->setCellValue('A5', "List:")
	65	+ ->setCellValue('B5', "Item A")
	66	+ ->setCellValue('A7', "List #2:")
	67	+ ->setCellValue('B7', "Item #2")
	68	+ ->setCellValue('D2', "Item #1")
	69	+ ->setCellValue('D3', "Item #2")
	70	+ ->setCellValue('D4', "Item #3")
	71	+ ->setCellValue('D5', "Item #4")
	72	+ ->setCellValue('D6', "Item #5")
	73	+ ;
74	74
75	75
76	76	// Set data validation

PHPOffice / PhpSpreadsheet

Push — develop ( 539a89...685e29 )

Status

Category

Indentation +13 added lines, -13 removed lines patch added patch discarded remove patch

Indentation +1 added lines, -1 removed lines patch added patch discarded remove patch

Indentation +30 added lines, -30 removed lines patch added patch discarded remove patch

Indentation +6 added lines, -6 removed lines patch added patch discarded remove patch

Indentation +6 added lines, -6 removed lines patch added patch discarded remove patch

Indentation +7 added lines, -7 removed lines patch added patch discarded remove patch

Indentation +1 added lines, -1 removed lines patch added patch discarded remove patch

Indentation +6 added lines, -6 removed lines patch added patch discarded remove patch

Indentation +18 added lines, -18 removed lines patch added patch discarded remove patch