Inspection of "Fix code style" - PHPOffice/PhpSpreadsheet - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — develop ( 6acd40...67d526 )

by Adrien

created 2016-08-26 13:49 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/01pharSimple.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/06largescale.php 1 patch

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/38cloneWorksheet.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/33chartcreate-radar.php 1 patch

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

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

Please login to merge, or discard this patch.

Examples/runall.php 1 patch

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

@@ -29,105 +29,105 @@
 block discarded – undo
 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

Please login to merge, or discard this patch.

Examples/03formulas.php 1 patch

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

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

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

@@ -31,7 +31,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 PhpSpreadsheet */
 require_once dirname(__FILE__) . '/../src/Bootstrap.php';
@@ -42,12 +42,12 @@  discard block
 block discarded – undo
 
 // Set document properties
 $objPhpSpreadsheet->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-pdf.php 1 patch

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

@@ -31,7 +31,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 PhpSpreadsheet */
 require_once dirname(__FILE__) . '/../src/Bootstrap.php';
@@ -53,12 +53,12 @@  discard block
 block discarded – undo
 
 // Set document properties
 $objPhpSpreadsheet->getProperties()->setCreator("Maarten Balliauw")
-	->setLastModifiedBy("Maarten Balliauw")
-	->setTitle("PDF Test Document")
-	->setSubject("PDF Test Document")
-	->setDescription("Test document for PDF, generated using PHP classes.")
-	->setKeywords("pdf php")
-	->setCategory("Test result file");
+    ->setLastModifiedBy("Maarten Balliauw")
+    ->setTitle("PDF Test Document")
+    ->setSubject("PDF Test Document")
+    ->setDescription("Test document for PDF, generated using PHP classes.")
+    ->setKeywords("pdf php")
+    ->setCategory("Test result file");
 
 
 // Add some data
@@ -83,13 +83,13 @@  discard block
 block discarded – undo
 
 if (!PhpSpreadsheet\Settings::setPdfRenderer(
         $rendererName,
-		$rendererLibraryPath
-	)) {
-	die(
-		'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
-		'<br />' .
-		'at the top of this script as appropriate for your directory structure'
-	);
+        $rendererLibraryPath
+    )) {
+    die(
+        'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
+        '<br />' .
+        'at the top of this script as appropriate for your directory structure'
+    );
 }
 
 

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

		@@ -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

		@@ -43,21 +43,21 @@ 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('Jan', 47, 45, 71),
49		- array('Feb', 56, 73, 86),
50		- array('Mar', 52, 61, 69),
51		- array('Apr', 40, 52, 60),
52		- array('May', 42, 55, 71),
53		- array('Jun', 58, 63, 76),
54		- array('Jul', 53, 61, 89),
55		- array('Aug', 46, 69, 85),
56		- array('Sep', 62, 75, 81),
57		- array('Oct', 51, 70, 96),
58		- array('Nov', 55, 66, 89),
59		- array('Dec', 68, 62, 0),
60		- )
	46	+ array(
	47	+ array('', 2010, 2011, 2012),
	48	+ array('Jan', 47, 45, 71),
	49	+ array('Feb', 56, 73, 86),
	50	+ array('Mar', 52, 61, 69),
	51	+ array('Apr', 40, 52, 60),
	52	+ array('May', 42, 55, 71),
	53	+ array('Jun', 58, 63, 76),
	54	+ array('Jul', 53, 61, 89),
	55	+ array('Aug', 46, 69, 85),
	56	+ array('Sep', 62, 75, 81),
	57	+ array('Oct', 51, 70, 96),
	58	+ array('Nov', 55, 66, 89),
	59	+ array('Dec', 68, 62, 0),
	60	+ )
61	61	);
62	62
63	63
		@@ -69,8 +69,8 @@ discard block
		block discarded – undo
69	69	// Data values
70	70	// Data Marker
71	71	$dataSeriesLabels = array(
72		- new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), // 2011
73		- new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1), // 2012
	72	+ new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), // 2011
	73	+ new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1), // 2012
74	74	);
75	75	// Set the X-Axis Labels
76	76	// Datatype
		@@ -80,8 +80,8 @@ discard block
		block discarded – undo
80	80	// Data values
81	81	// Data Marker
82	82	$xAxisTickValues = array(
83		- new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$13', NULL, 12), // Jan to Dec
84		- new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$13', NULL, 12), // Jan to Dec
	83	+ new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$13', NULL, 12), // Jan to Dec
	84	+ new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$13', NULL, 12), // Jan to Dec
85	85	);
86	86	// Set the Data values for each data series we want to plot
87	87	// Datatype
		@@ -91,21 +91,21 @@ discard block
		block discarded – undo
91	91	// Data values
92	92	// Data Marker
93	93	$dataSeriesValues = array(
94		- new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$13', NULL, 12),
95		- new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$13', NULL, 12),
	94	+ new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$13', NULL, 12),
	95	+ new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$13', NULL, 12),
96	96	);
97	97
98	98	// Build the dataseries
99	99	$series = new \PHPExcel\Chart\DataSeries(
100		- \PHPExcel\Chart\DataSeries::TYPE_RADARCHART, // plotType
101		- NULL, // plotGrouping (Radar charts don't have any grouping)
102		- range(0, count($dataSeriesValues)-1), // plotOrder
103		- $dataSeriesLabels, // plotLabel
104		- $xAxisTickValues, // plotCategory
105		- $dataSeriesValues, // plotValues
	100	+ \PHPExcel\Chart\DataSeries::TYPE_RADARCHART, // plotType
	101	+ NULL, // plotGrouping (Radar charts don't have any grouping)
	102	+ range(0, count($dataSeriesValues)-1), // plotOrder
	103	+ $dataSeriesLabels, // plotLabel
	104	+ $xAxisTickValues, // plotCategory
	105	+ $dataSeriesValues, // plotValues
106	106	NULL, // plotDirection
107		- NULL, // smooth line
108		- \PHPExcel\Chart\DataSeries::STYLE_MARKER // plotStyle
	107	+ NULL, // smooth line
	108	+ \PHPExcel\Chart\DataSeries::STYLE_MARKER // plotStyle
109	109	);
110	110
111	111	// Set up a layout object for the Pie chart
		@@ -121,14 +121,14 @@ discard block
		block discarded – undo
121	121
122	122	// Create the chart
123	123	$chart = new \PHPExcel\Chart(
124		- 'chart1', // name
125		- $title, // title
126		- $legend, // legend
127		- $plotArea, // plotArea
128		- true, // plotVisibleOnly
129		- 0, // displayBlanksAs
130		- NULL, // xAxisLabel
131		- NULL // yAxisLabel - Radar charts don't have a Y-Axis
	124	+ 'chart1', // name
	125	+ $title, // title
	126	+ $legend, // legend
	127	+ $plotArea, // plotArea
	128	+ true, // plotVisibleOnly
	129	+ 0, // displayBlanksAs
	130	+ NULL, // xAxisLabel
	131	+ NULL // yAxisLabel - Radar charts don't have a Y-Axis
132	132	);
133	133
134	134	// Set the position where the chart should appear in the worksheet

		@@ -29,105 +29,105 @@
		block discarded – undo
29	29	error_reporting(E_ALL);
30	30
31	31	if (PHP_SAPI != 'cli') {
32		- die ('This script executes all tests, and should only be run from the command line');
	32	+ die ('This script executes all tests, and should only be run from the command line');
33	33	}
34	34
35	35	// List of tests
36	36	$aTests = array(
37		- '01simple.php'
38		- , '01simplePCLZip.php'
39		- , '02types.php'
40		- , '02types-xls.php'
41		- , '03formulas.php'
42		- , '04printing.php'
43		- , '05featuredemo.php'
44		- , '06largescale.php'
45		- , '06largescale-with-cellcaching.php'
46		- , '06largescale-with-cellcaching-sqlite.php'
47		- , '06largescale-with-cellcaching-sqlite3.php'
48		- , '06largescale-xls.php'
49		- , '07reader.php'
50		- , '07readerPCLZip.php'
51		- , '08conditionalformatting.php'
52		- , '08conditionalformatting2.php'
53		- , '09pagebreaks.php'
54		- , '10autofilter.php'
55		- , '10autofilter-selection-1.php'
56		- , '10autofilter-selection-2.php'
57		- , '10autofilter-selection-display.php'
58		- , '11documentsecurity.php'
59		- , '11documentsecurity-xls.php'
60		- , '12cellProtection.php'
61		- , '13calculation.php'
	37	+ '01simple.php'
	38	+ , '01simplePCLZip.php'
	39	+ , '02types.php'
	40	+ , '02types-xls.php'
	41	+ , '03formulas.php'
	42	+ , '04printing.php'
	43	+ , '05featuredemo.php'
	44	+ , '06largescale.php'
	45	+ , '06largescale-with-cellcaching.php'
	46	+ , '06largescale-with-cellcaching-sqlite.php'
	47	+ , '06largescale-with-cellcaching-sqlite3.php'
	48	+ , '06largescale-xls.php'
	49	+ , '07reader.php'
	50	+ , '07readerPCLZip.php'
	51	+ , '08conditionalformatting.php'
	52	+ , '08conditionalformatting2.php'
	53	+ , '09pagebreaks.php'
	54	+ , '10autofilter.php'
	55	+ , '10autofilter-selection-1.php'
	56	+ , '10autofilter-selection-2.php'
	57	+ , '10autofilter-selection-display.php'
	58	+ , '11documentsecurity.php'
	59	+ , '11documentsecurity-xls.php'
	60	+ , '12cellProtection.php'
	61	+ , '13calculation.php'
62	62	, '13calculationCyclicFormulae.php'
63		- , '14excel5.php'
64		- , '15datavalidation.php'
65		- , '15datavalidation-xls.php'
66		- , '16csv.php'
67		- , '17html.php'
68		- , '18extendedcalculation.php'
69		- , '19namedrange.php'
70		- , '20readexcel5.php'
71		- , '21pdf.php'
72		- , '22heavilyformatted.php'
73		- , '23sharedstyles.php'
74		- , '24readfilter.php'
75		- , '25inmemoryimage.php'
76		- , '26utf8.php'
77		- , '27imagesexcel5.php'
78		- , '28iterator.php'
79		- , '29advancedvaluebinder.php'
80		- , '30template.php'
81		- , '31docproperties_write.php'
82		- , '31docproperties_write-xls.php'
83		- , '32chartreadwrite.php'
84		- , '33chartcreate-area.php'
85		- , '33chartcreate-bar.php'
86		- , '33chartcreate-bar-stacked.php'
87		- , '33chartcreate-column.php'
88		- , '33chartcreate-column-2.php'
89		- , '33chartcreate-line.php'
90		- , '33chartcreate-pie.php'
91		- , '33chartcreate-radar.php'
92		- , '33chartcreate-scatter.php'
93		- , '33chartcreate-stock.php'
94		- , '33chartcreate-multiple-charts.php'
95		- , '33chartcreate-composite.php'
96		- , '34chartupdate.php'
97		- , '35chartrender.php'
98		- , '36chartreadwriteHTML.php'
99		- , '36chartreadwritePDF.php'
100		- , '37page_layout_view.php'
101		- , '38cloneWorksheet.php'
	63	+ , '14excel5.php'
	64	+ , '15datavalidation.php'
	65	+ , '15datavalidation-xls.php'
	66	+ , '16csv.php'
	67	+ , '17html.php'
	68	+ , '18extendedcalculation.php'
	69	+ , '19namedrange.php'
	70	+ , '20readexcel5.php'
	71	+ , '21pdf.php'
	72	+ , '22heavilyformatted.php'
	73	+ , '23sharedstyles.php'
	74	+ , '24readfilter.php'
	75	+ , '25inmemoryimage.php'
	76	+ , '26utf8.php'
	77	+ , '27imagesexcel5.php'
	78	+ , '28iterator.php'
	79	+ , '29advancedvaluebinder.php'
	80	+ , '30template.php'
	81	+ , '31docproperties_write.php'
	82	+ , '31docproperties_write-xls.php'
	83	+ , '32chartreadwrite.php'
	84	+ , '33chartcreate-area.php'
	85	+ , '33chartcreate-bar.php'
	86	+ , '33chartcreate-bar-stacked.php'
	87	+ , '33chartcreate-column.php'
	88	+ , '33chartcreate-column-2.php'
	89	+ , '33chartcreate-line.php'
	90	+ , '33chartcreate-pie.php'
	91	+ , '33chartcreate-radar.php'
	92	+ , '33chartcreate-scatter.php'
	93	+ , '33chartcreate-stock.php'
	94	+ , '33chartcreate-multiple-charts.php'
	95	+ , '33chartcreate-composite.php'
	96	+ , '34chartupdate.php'
	97	+ , '35chartrender.php'
	98	+ , '36chartreadwriteHTML.php'
	99	+ , '36chartreadwritePDF.php'
	100	+ , '37page_layout_view.php'
	101	+ , '38cloneWorksheet.php'
102	102	, '39dropdown.php'
103		- , '40duplicateStyle.php'
104		- , '41password.php'
105		- , '42richText.php'
	103	+ , '40duplicateStyle.php'
	104	+ , '41password.php'
	105	+ , '42richText.php'
106	106	, '43mergeWorkbooks.php'
107	107	, '44worksheetInfo.php'
108		- , 'OOCalcReader.php'
109		- , 'OOCalcReaderPCLZip.php'
110		- , 'SylkReader.php'
111		- , 'Excel2003XMLReader.php'
112		- , 'XMLReader.php'
113		- , 'GnumericReader.php'
	108	+ , 'OOCalcReader.php'
	109	+ , 'OOCalcReaderPCLZip.php'
	110	+ , 'SylkReader.php'
	111	+ , 'Excel2003XMLReader.php'
	112	+ , 'XMLReader.php'
	113	+ , 'GnumericReader.php'
114	114	);
115	115
116	116	// First, clear all previous run results
117	117	foreach ($aTests as $sTest) {
118		- @unlink( str_replace('.php', '.xls', $sTest) );
119		- @unlink( str_replace('.php', '.xlsx', $sTest) );
120		- @unlink( str_replace('.php', '.csv', $sTest) );
121		- @unlink( str_replace('.php', '.htm', $sTest) );
122		- @unlink( str_replace('.php', '.pdf', $sTest) );
	118	+ @unlink( str_replace('.php', '.xls', $sTest) );
	119	+ @unlink( str_replace('.php', '.xlsx', $sTest) );
	120	+ @unlink( str_replace('.php', '.csv', $sTest) );
	121	+ @unlink( str_replace('.php', '.htm', $sTest) );
	122	+ @unlink( str_replace('.php', '.pdf', $sTest) );
123	123	}
124	124
125	125	// Run all tests
126	126	foreach ($aTests as $sTest) {
127		- echo '============== TEST ==============' . "\r\n";
128		- echo 'Test name: ' . $sTest . "\r\n";
129		- echo "\r\n";
130		- echo shell_exec('php ' . $sTest);
131		- echo "\r\n";
132		- echo "\r\n";
	127	+ echo '============== TEST ==============' . "\r\n";
	128	+ echo 'Test name: ' . $sTest . "\r\n";
	129	+ echo "\r\n";
	130	+ echo shell_exec('php ' . $sTest);
	131	+ echo "\r\n";
	132	+ echo "\r\n";
133	133	}
134	134	\ No newline at end of file

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

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

PHPOffice / PhpSpreadsheet

Push — develop ( 6acd40...67d526 )

Status

Category

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

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

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

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

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

Indentation +85 added lines, -85 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 +14 added lines, -14 removed lines patch added patch discarded remove patch