PHPOffice / PhpSpreadsheet

Examples/15datavalidation-xls.php

Spacing +20 added lines, -20 removed lines

@@ -31,7 +31,7 @@ 
 ini_set('display_startup_errors', TRUE);
 date_default_timezone_set('Europe/London');
 
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
 
 date_default_timezone_set('Europe/London');
 
@@ -40,12 +40,12 @@ 
 
 
 // Create new PHPExcel object
-echo date('H:i:s') , " Create new PHPExcel object" , EOL;
+echo date('H:i:s'), " Create new PHPExcel object", EOL;
 $objPHPExcel = new \PHPExcel\Spreadsheet();
 
 
 // Set document properties
-echo date('H:i:s') , " Set document properties" , EOL;
+echo date('H:i:s'), " Set document properties", EOL;
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
 							 ->setLastModifiedBy("Maarten Balliauw")
 							 ->setTitle("Office 2007 XLSX Test Document")
@@ -56,7 +56,7 @@ 
 
 
 // Create a first sheet
-echo date('H:i:s') , " Add data" , EOL;
+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:")
@@ -74,10 +74,10 @@ 
 
 
 // Set data validation
-echo date('H:i:s') , " Set data validation" , EOL;
+echo date('H:i:s'), " Set data validation", EOL;
 $objValidation = $objPHPExcel->getActiveSheet()->getCell('B3')->getDataValidation();
-$objValidation->setType( \PHPExcel\Cell\DataValidation::TYPE_WHOLE );
-$objValidation->setErrorStyle( \PHPExcel\Cell\DataValidation::STYLE_STOP );
+$objValidation->setType(\PHPExcel\Cell\DataValidation::TYPE_WHOLE);
+$objValidation->setErrorStyle(\PHPExcel\Cell\DataValidation::STYLE_STOP);
 $objValidation->setAllowBlank(true);
 $objValidation->setShowInputMessage(true);
 $objValidation->setShowErrorMessage(true);
@@ -89,8 +89,8 @@ 
 $objValidation->setFormula2(20);
 
 $objValidation = $objPHPExcel->getActiveSheet()->getCell('B5')->getDataValidation();
-$objValidation->setType( \PHPExcel\Cell\DataValidation::TYPE_LIST );
-$objValidation->setErrorStyle( \PHPExcel\Cell\DataValidation::STYLE_INFORMATION );
+$objValidation->setType(\PHPExcel\Cell\DataValidation::TYPE_LIST);
+$objValidation->setErrorStyle(\PHPExcel\Cell\DataValidation::STYLE_INFORMATION);
 $objValidation->setAllowBlank(false);
 $objValidation->setShowInputMessage(true);
 $objValidation->setShowErrorMessage(true);
@@ -99,11 +99,11 @@ 
 $objValidation->setError('Value is not in list.');
 $objValidation->setPromptTitle('Pick from list');
 $objValidation->setPrompt('Please pick a value from the drop-down list.');
-$objValidation->setFormula1('"Item A,Item B,Item C"');	// Make sure to put the list items between " and "  !!!
+$objValidation->setFormula1('"Item A,Item B,Item C"'); // Make sure to put the list items between " and "  !!!
 
 $objValidation = $objPHPExcel->getActiveSheet()->getCell('B7')->getDataValidation();
-$objValidation->setType( \PHPExcel\Cell\DataValidation::TYPE_LIST );
-$objValidation->setErrorStyle( \PHPExcel\Cell\DataValidation::STYLE_INFORMATION );
+$objValidation->setType(\PHPExcel\Cell\DataValidation::TYPE_LIST);
+$objValidation->setErrorStyle(\PHPExcel\Cell\DataValidation::STYLE_INFORMATION);
 $objValidation->setAllowBlank(false);
 $objValidation->setShowInputMessage(true);
 $objValidation->setShowErrorMessage(true);
@@ -112,7 +112,7 @@ 
 $objValidation->setError('Value is not in list.');
 $objValidation->setPromptTitle('Pick from list');
 $objValidation->setPrompt('Please pick a value from the drop-down list.');
-$objValidation->setFormula1('$D$2:$D$6');	// Make sure NOT to put a range of cells or a formula between " and "  !!!
+$objValidation->setFormula1('$D$2:$D$6'); // Make sure NOT to put a range of cells or a formula between " and "  !!!
 
 
 // Set active sheet index to the first sheet, so Excel opens this as the first sheet
@@ -120,7 +120,7 @@ 
 
 
 // Save Excel 95 file
-echo date('H:i:s') , " Write to Excel5 format" , EOL;
+echo date('H:i:s'), " Write to Excel5 format", EOL;
 $callStartTime = microtime(true);
 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel5');
@@ -128,15 +128,15 @@ 
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
 
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
 // Echo memory usage
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
 
 
 // Echo memory peak usage
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
 
 // Echo done
-echo date('H:i:s') , " Done writing file" , EOL;
-echo 'File has been created in ' , getcwd() , EOL;
+echo date('H:i:s'), " Done writing file", EOL;
+echo 'File has been created in ', getcwd(), EOL;

Indentation +18 added lines, -18 removed lines

@@ -47,30 +47,30 @@
 // 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

Examples/Excel2003XMLReader.php

Spacing +7 added lines, -7 removed lines

@@ -34,7 +34,7 @@ 
 require_once dirname(__FILE__) . '/../Classes/PHPExcel/IOFactory.php';

 

 

-echo date('H:i:s') , " Load from Excel2003XML file" , PHP_EOL;

+echo date('H:i:s'), " Load from Excel2003XML file", PHP_EOL;

 $callStartTime = microtime(true);

 

 $objReader = \PHPExcel\IOFactory::createReader('Excel2003XML');

@@ -43,19 +43,19 @@ 
 

 $callEndTime = microtime(true);

 $callTime = $callEndTime - $callStartTime;

-echo 'Call time to read Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , PHP_EOL;

+echo 'Call time to read Workbook was ', sprintf('%.4f', $callTime), " seconds", PHP_EOL;

 // Echo memory usage

-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , PHP_EOL;

+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", PHP_EOL;

 

 

-echo date('H:i:s') , " Write to Excel5 format" , PHP_EOL;

+echo date('H:i:s'), " Write to Excel5 format", PHP_EOL;

 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel5');

 $objWriter->save(str_replace('.php', '.xls', __FILE__));

-echo date('H:i:s') , " File written to " , str_replace('.php', '.xls', __FILE__) , PHP_EOL;

+echo date('H:i:s'), " File written to ", str_replace('.php', '.xls', __FILE__), PHP_EOL;

 

 

 // Echo memory peak usage

-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , PHP_EOL;

+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", PHP_EOL;

 

 // Echo done

-echo date('H:i:s') , " Done writing file" , PHP_EOL;

+echo date('H:i:s'), " Done writing file", PHP_EOL;

Examples/runall.php

Spacing +5 added lines, -5 removed lines

@@ -114,11 +114,11 @@
 
 // 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

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

Examples/33chartcreate-column-2.php

Indentation +36 added lines, -36 removed lines

@@ -43,21 +43,21 @@ 
 $objPHPExcel = new \PHPExcel\Spreadsheet();
 $objWorksheet = $objPHPExcel->getActiveSheet();
 $objWorksheet->fromArray(
-	array(
-		array('',		'',		'Budget',	'Forecast',	'Actual'),
-		array('2010',	'Q1',   47,   		44,			43		),
-		array('',		'Q2',   56,   		53,			50		),
-		array('',		'Q3',   52,   		46,			45		),
-		array('',		'Q4',   45,   		40,			40		),
-		array('2011',	'Q1',   51,   		42,			46		),
-		array('',		'Q2',   53,   		58,			56		),
-		array('',		'Q3',   64,   		66,			69		),
-		array('',		'Q4',   54,   		55,			56		),
-		array('2012',	'Q1',   49,   		52,			58		),
-		array('',		'Q2',   68,   		73,			86		),
-		array('',		'Q3',   72,   		78,			0		),
-		array('',		'Q4',   50,   		60,			0		),
-	)
+    array(
+        array('',		'',		'Budget',	'Forecast',	'Actual'),
+        array('2010',	'Q1',   47,   		44,			43		),
+        array('',		'Q2',   56,   		53,			50		),
+        array('',		'Q3',   52,   		46,			45		),
+        array('',		'Q4',   45,   		40,			40		),
+        array('2011',	'Q1',   51,   		42,			46		),
+        array('',		'Q2',   53,   		58,			56		),
+        array('',		'Q3',   64,   		66,			69		),
+        array('',		'Q4',   54,   		55,			56		),
+        array('2012',	'Q1',   49,   		52,			58		),
+        array('',		'Q2',   68,   		73,			86		),
+        array('',		'Q3',   72,   		78,			0		),
+        array('',		'Q4',   50,   		60,			0		),
+    )
 );
 
 //	Set the Labels for each data series we want to plot
@@ -68,9 +68,9 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesLabels = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),	//	'Budget'
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1),	//	'Forecast'
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$E$1', NULL, 1),	//	'Actual'
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),	//	'Budget'
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1),	//	'Forecast'
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$E$1', NULL, 1),	//	'Actual'
 );
 //	Set the X-Axis Labels
 //		Datatype
@@ -80,7 +80,7 @@ 
 //		Data values
 //		Data Marker
 $xAxisTickValues = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$B$13', NULL, 12),	//	Q1 to Q4 for 2010 to 2012
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$B$13', NULL, 12),	//	Q1 to Q4 for 2010 to 2012
 );
 //	Set the Data values for each data series we want to plot
 //		Datatype
@@ -90,19 +90,19 @@ 
 //		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!$E$2:$E$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),
+    new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$E$2:$E$13', NULL, 12),
 );
 
 //	Build the dataseries
 $series = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_BARCHART,		// plotType
-	\PHPExcel\Chart\DataSeries::GROUPING_CLUSTERED,	// plotGrouping
-	range(0, count($dataSeriesValues)-1),			// plotOrder
-	$dataSeriesLabels,								// plotLabel
-	$xAxisTickValues,								// plotCategory
-	$dataSeriesValues								// plotValues
+    \PHPExcel\Chart\DataSeries::TYPE_BARCHART,		// plotType
+    \PHPExcel\Chart\DataSeries::GROUPING_CLUSTERED,	// plotGrouping
+    range(0, count($dataSeriesValues)-1),			// plotOrder
+    $dataSeriesLabels,								// plotLabel
+    $xAxisTickValues,								// plotCategory
+    $dataSeriesValues								// plotValues
 );
 //	Set additional dataseries parameters
 //		Make it a vertical column rather than a horizontal bar graph
@@ -120,14 +120,14 @@ 
 
 //	Create the chart
 $chart = new \PHPExcel\Chart(
-	'chart1',		// name
-	$title,			// title
-	$legend,		// legend
-	$plotArea,		// plotArea
-	true,			// plotVisibleOnly
-	0,				// displayBlanksAs
-	$xAxisLabel,	// xAxisLabel
-	$yAxisLabel		// yAxisLabel
+    'chart1',		// name
+    $title,			// title
+    $legend,		// legend
+    $plotArea,		// plotArea
+    true,			// plotVisibleOnly
+    0,				// displayBlanksAs
+    $xAxisLabel,	// xAxisLabel
+    $yAxisLabel		// yAxisLabel
 );
 
 //	Set the position where the chart should appear in the worksheet

Spacing +35 added lines, -35 removed lines

@@ -6,7 +6,7 @@ 
 ini_set('display_startup_errors', TRUE);
 date_default_timezone_set('Europe/London');
 
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
 
 date_default_timezone_set('Europe/London');
 
@@ -44,19 +44,19 @@ 
 $objWorksheet = $objPHPExcel->getActiveSheet();
 $objWorksheet->fromArray(
 	array(
-		array('',		'',		'Budget',	'Forecast',	'Actual'),
-		array('2010',	'Q1',   47,   		44,			43		),
-		array('',		'Q2',   56,   		53,			50		),
-		array('',		'Q3',   52,   		46,			45		),
-		array('',		'Q4',   45,   		40,			40		),
-		array('2011',	'Q1',   51,   		42,			46		),
-		array('',		'Q2',   53,   		58,			56		),
-		array('',		'Q3',   64,   		66,			69		),
-		array('',		'Q4',   54,   		55,			56		),
-		array('2012',	'Q1',   49,   		52,			58		),
-		array('',		'Q2',   68,   		73,			86		),
-		array('',		'Q3',   72,   		78,			0		),
-		array('',		'Q4',   50,   		60,			0		),
+		array('', '', 'Budget', 'Forecast', 'Actual'),
+		array('2010', 'Q1', 47, 44, 43),
+		array('', 'Q2', 56, 53, 50),
+		array('', 'Q3', 52, 46, 45),
+		array('', 'Q4', 45, 40, 40),
+		array('2011', 'Q1', 51, 42, 46),
+		array('', 'Q2', 53, 58, 56),
+		array('', 'Q3', 64, 66, 69),
+		array('', 'Q4', 54, 55, 56),
+		array('2012', 'Q1', 49, 52, 58),
+		array('', 'Q2', 68, 73, 86),
+		array('', 'Q3', 72, 78, 0),
+		array('', 'Q4', 50, 60, 0),
 	)
 );
 
@@ -68,9 +68,9 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesLabels = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),	//	'Budget'
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1),	//	'Forecast'
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$E$1', NULL, 1),	//	'Actual'
+	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), //	'Budget'
+	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1), //	'Forecast'
+	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$E$1', NULL, 1), //	'Actual'
 );
 //	Set the X-Axis Labels
 //		Datatype
@@ -80,7 +80,7 @@ 
 //		Data values
 //		Data Marker
 $xAxisTickValues = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$B$13', NULL, 12),	//	Q1 to Q4 for 2010 to 2012
+	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$B$13', NULL, 12), //	Q1 to Q4 for 2010 to 2012
 );
 //	Set the Data values for each data series we want to plot
 //		Datatype
@@ -97,11 +97,11 @@ 
 
 //	Build the dataseries
 $series = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_BARCHART,		// plotType
-	\PHPExcel\Chart\DataSeries::GROUPING_CLUSTERED,	// plotGrouping
-	range(0, count($dataSeriesValues)-1),			// plotOrder
-	$dataSeriesLabels,								// plotLabel
-	$xAxisTickValues,								// plotCategory
+	\PHPExcel\Chart\DataSeries::TYPE_BARCHART, // plotType
+	\PHPExcel\Chart\DataSeries::GROUPING_CLUSTERED, // plotGrouping
+	range(0, count($dataSeriesValues) - 1), // plotOrder
+	$dataSeriesLabels, // plotLabel
+	$xAxisTickValues, // plotCategory
 	$dataSeriesValues								// plotValues
 );
 //	Set additional dataseries parameters
@@ -120,13 +120,13 @@ 
 
 //	Create the chart
 $chart = new \PHPExcel\Chart(
-	'chart1',		// name
-	$title,			// title
-	$legend,		// legend
-	$plotArea,		// plotArea
-	true,			// plotVisibleOnly
-	0,				// displayBlanksAs
-	$xAxisLabel,	// xAxisLabel
+	'chart1', // name
+	$title, // title
+	$legend, // legend
+	$plotArea, // plotArea
+	true, // plotVisibleOnly
+	0, // displayBlanksAs
+	$xAxisLabel, // xAxisLabel
 	$yAxisLabel		// yAxisLabel
 );
 
@@ -139,16 +139,16 @@ 
 
 
 // Save Excel 2007 file
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
 $objWriter->setIncludeCharts(TRUE);
 $objWriter->save(str_replace('.php', '.xlsx', __FILE__));
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
 
 
 // Echo memory peak usage
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
 
 // Echo done
-echo date('H:i:s') , " Done writing file" , EOL;
-echo 'File has been created in ' , getcwd() , EOL;
+echo date('H:i:s'), " Done writing file", EOL;
+echo 'File has been created in ', getcwd(), EOL;

Examples/OOCalcReaderPCLZip.php

Spacing +7 added lines, -7 removed lines

@@ -36,7 +36,7 @@ 
 // Use PCLZip rather than ZipArchive to read the Excel2007 OfficeOpenXML file
 PHPExcel\Settings::setZipClass(PHPExcel\Settings::PCLZIP);
 
-echo date('H:i:s') , " Load from OOCalc file" , PHP_EOL;
+echo date('H:i:s'), " Load from OOCalc file", PHP_EOL;
 $callStartTime = microtime(true);
 
 $objReader = \PHPExcel\IOFactory::createReader('OOCalc');
@@ -45,20 +45,20 @@ 
 
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
-echo 'Call time to read Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , PHP_EOL;
+echo 'Call time to read Workbook was ', sprintf('%.4f', $callTime), " seconds", PHP_EOL;
 // Echo memory usage
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , PHP_EOL;
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", PHP_EOL;
 
 
-echo date('H:i:s') , " Write to Excel2007 format" , PHP_EOL;
+echo date('H:i:s'), " Write to Excel2007 format", PHP_EOL;
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
 $objWriter->save(str_replace('.php', '.xlsx', __FILE__));
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', __FILE__) , PHP_EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', __FILE__), PHP_EOL;
 
 
 // Echo memory peak usage
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , PHP_EOL;
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", PHP_EOL;
 
 // Echo done
-echo date('H:i:s') , " Done writing file" , PHP_EOL;
+echo date('H:i:s'), " Done writing file", PHP_EOL;
 

Examples/36chartreadwriteHTML.php

Indentation +80 added lines, -80 removed lines

@@ -22,14 +22,14 @@ 
 
 
 if (!PHPExcel\Settings::setChartRenderer(
-		$rendererName,
-		$rendererLibraryPath
-	)) {
-	die(
-		'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
-		EOL .
-		'at the top of this script as appropriate for your directory structure'
-	);
+        $rendererName,
+        $rendererLibraryPath
+    )) {
+    die(
+        'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
+        EOL .
+        'at the top of this script as appropriate for your directory structure'
+    );
 }
 
 
@@ -37,81 +37,81 @@ 
 $inputFileNames = 'templates/36write*.xlsx';
 
 if ((isset($argc)) && ($argc > 1)) {
-	$inputFileNames = array();
-	for($i = 1; $i < $argc; ++$i) {
-		$inputFileNames[] = dirname(__FILE__) . '/templates/' . $argv[$i];
-	}
+    $inputFileNames = array();
+    for($i = 1; $i < $argc; ++$i) {
+        $inputFileNames[] = dirname(__FILE__) . '/templates/' . $argv[$i];
+    }
 } else {
-	$inputFileNames = glob($inputFileNames);
+    $inputFileNames = glob($inputFileNames);
 }
 foreach($inputFileNames as $inputFileName) {
-	$inputFileNameShort = basename($inputFileName);
-
-	if (!file_exists($inputFileName)) {
-		echo date('H:i:s') , " File " , $inputFileNameShort , ' does not exist' , EOL;
-		continue;
-	}
-
-	echo date('H:i:s') , " Load Test from $inputFileType file " , $inputFileNameShort , EOL;
-
-	$objReader = \PHPExcel\IOFactory::createReader($inputFileType);
-	$objReader->setIncludeCharts(TRUE);
-	$objPHPExcel = $objReader->load($inputFileName);
-
-
-	echo date('H:i:s') , " Iterate worksheets looking at the charts" , EOL;
-	foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
-		$sheetName = $worksheet->getTitle();
-		echo 'Worksheet: ' , $sheetName , EOL;
-
-		$chartNames = $worksheet->getChartNames();
-		if(empty($chartNames)) {
-			echo '    There are no charts in this worksheet' , EOL;
-		} else {
-			natsort($chartNames);
-			foreach($chartNames as $i => $chartName) {
-				$chart = $worksheet->getChartByName($chartName);
-				if (!is_null($chart->getTitle())) {
-					$caption = '"' . implode(' ',$chart->getTitle()->getCaption()) . '"';
-				} else {
-					$caption = 'Untitled';
-				}
-				echo '    ' , $chartName , ' - ' , $caption , EOL;
-				echo str_repeat(' ',strlen($chartName)+3);
-				$groupCount = $chart->getPlotArea()->getPlotGroupCount();
-				if ($groupCount == 1) {
-					$chartType = $chart->getPlotArea()->getPlotGroupByIndex(0)->getPlotType();
-					echo '    ' , $chartType , EOL;
-				} else {
-					$chartTypes = array();
-					for($i = 0; $i < $groupCount; ++$i) {
-						$chartTypes[] = $chart->getPlotArea()->getPlotGroupByIndex($i)->getPlotType();
-					}
-					$chartTypes = array_unique($chartTypes);
-					if (count($chartTypes) == 1) {
-						$chartType = 'Multiple Plot ' . array_pop($chartTypes);
-						echo '    ' , $chartType , EOL;
-					} elseif (count($chartTypes) == 0) {
-						echo '    *** Type not yet implemented' , EOL;
-					} else {
-						echo '    Combination Chart' , EOL;
-					}
-				}
-			}
-		}
-	}
-
-
-	$outputFileName = str_replace('.xlsx', '.html', basename($inputFileName));
-
-	echo date('H:i:s') , " Write Tests to HTML file " , EOL;
-	$objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'HTML');
-	$objWriter->setIncludeCharts(TRUE);
-	$objWriter->save($outputFileName);
-	echo date('H:i:s') , " File written to " , $outputFileName , EOL;
-
-	$objPHPExcel->disconnectWorksheets();
-	unset($objPHPExcel);
+    $inputFileNameShort = basename($inputFileName);
+
+    if (!file_exists($inputFileName)) {
+        echo date('H:i:s') , " File " , $inputFileNameShort , ' does not exist' , EOL;
+        continue;
+    }
+
+    echo date('H:i:s') , " Load Test from $inputFileType file " , $inputFileNameShort , EOL;
+
+    $objReader = \PHPExcel\IOFactory::createReader($inputFileType);
+    $objReader->setIncludeCharts(TRUE);
+    $objPHPExcel = $objReader->load($inputFileName);
+
+
+    echo date('H:i:s') , " Iterate worksheets looking at the charts" , EOL;
+    foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
+        $sheetName = $worksheet->getTitle();
+        echo 'Worksheet: ' , $sheetName , EOL;
+
+        $chartNames = $worksheet->getChartNames();
+        if(empty($chartNames)) {
+            echo '    There are no charts in this worksheet' , EOL;
+        } else {
+            natsort($chartNames);
+            foreach($chartNames as $i => $chartName) {
+                $chart = $worksheet->getChartByName($chartName);
+                if (!is_null($chart->getTitle())) {
+                    $caption = '"' . implode(' ',$chart->getTitle()->getCaption()) . '"';
+                } else {
+                    $caption = 'Untitled';
+                }
+                echo '    ' , $chartName , ' - ' , $caption , EOL;
+                echo str_repeat(' ',strlen($chartName)+3);
+                $groupCount = $chart->getPlotArea()->getPlotGroupCount();
+                if ($groupCount == 1) {
+                    $chartType = $chart->getPlotArea()->getPlotGroupByIndex(0)->getPlotType();
+                    echo '    ' , $chartType , EOL;
+                } else {
+                    $chartTypes = array();
+                    for($i = 0; $i < $groupCount; ++$i) {
+                        $chartTypes[] = $chart->getPlotArea()->getPlotGroupByIndex($i)->getPlotType();
+                    }
+                    $chartTypes = array_unique($chartTypes);
+                    if (count($chartTypes) == 1) {
+                        $chartType = 'Multiple Plot ' . array_pop($chartTypes);
+                        echo '    ' , $chartType , EOL;
+                    } elseif (count($chartTypes) == 0) {
+                        echo '    *** Type not yet implemented' , EOL;
+                    } else {
+                        echo '    Combination Chart' , EOL;
+                    }
+                }
+            }
+        }
+    }
+
+
+    $outputFileName = str_replace('.xlsx', '.html', basename($inputFileName));
+
+    echo date('H:i:s') , " Write Tests to HTML file " , EOL;
+    $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'HTML');
+    $objWriter->setIncludeCharts(TRUE);
+    $objWriter->save($outputFileName);
+    echo date('H:i:s') , " File written to " , $outputFileName , EOL;
+
+    $objPHPExcel->disconnectWorksheets();
+    unset($objPHPExcel);
 }
 
 // Echo memory peak usage

Spacing +23 added lines, -23 removed lines

@@ -6,7 +6,7 @@ 
 ini_set('display_startup_errors', TRUE);
 date_default_timezone_set('Europe/London');
 
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
 
 date_default_timezone_set('Europe/London');
 
@@ -61,63 +61,63 @@ 
 
 if ((isset($argc)) && ($argc > 1)) {
 	$inputFileNames = array();
-	for($i = 1; $i < $argc; ++$i) {
+	for ($i = 1; $i < $argc; ++$i) {
 		$inputFileNames[] = dirname(__FILE__) . '/templates/' . $argv[$i];
 	}
 } else {
 	$inputFileNames = glob($inputFileNames);
 }
-foreach($inputFileNames as $inputFileName) {
+foreach ($inputFileNames as $inputFileName) {
 	$inputFileNameShort = basename($inputFileName);
 
 	if (!file_exists($inputFileName)) {
-		echo date('H:i:s') , " File " , $inputFileNameShort , ' does not exist' , EOL;
+		echo date('H:i:s'), " File ", $inputFileNameShort, ' does not exist', EOL;
 		continue;
 	}
 
-	echo date('H:i:s') , " Load Test from $inputFileType file " , $inputFileNameShort , EOL;
+	echo date('H:i:s'), " Load Test from $inputFileType file ", $inputFileNameShort, EOL;
 
 	$objReader = \PHPExcel\IOFactory::createReader($inputFileType);
 	$objReader->setIncludeCharts(TRUE);
 	$objPHPExcel = $objReader->load($inputFileName);
 
 
-	echo date('H:i:s') , " Iterate worksheets looking at the charts" , EOL;
+	echo date('H:i:s'), " Iterate worksheets looking at the charts", EOL;
 	foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
 		$sheetName = $worksheet->getTitle();
-		echo 'Worksheet: ' , $sheetName , EOL;
+		echo 'Worksheet: ', $sheetName, EOL;
 
 		$chartNames = $worksheet->getChartNames();
-		if(empty($chartNames)) {
-			echo '    There are no charts in this worksheet' , EOL;
+		if (empty($chartNames)) {
+			echo '    There are no charts in this worksheet', EOL;
 		} else {
 			natsort($chartNames);
-			foreach($chartNames as $i => $chartName) {
+			foreach ($chartNames as $i => $chartName) {
 				$chart = $worksheet->getChartByName($chartName);
 				if (!is_null($chart->getTitle())) {
-					$caption = '"' . implode(' ',$chart->getTitle()->getCaption()) . '"';
+					$caption = '"' . implode(' ', $chart->getTitle()->getCaption()) . '"';
 				} else {
 					$caption = 'Untitled';
 				}
-				echo '    ' , $chartName , ' - ' , $caption , EOL;
-				echo str_repeat(' ',strlen($chartName)+3);
+				echo '    ', $chartName, ' - ', $caption, EOL;
+				echo str_repeat(' ', strlen($chartName) + 3);
 				$groupCount = $chart->getPlotArea()->getPlotGroupCount();
 				if ($groupCount == 1) {
 					$chartType = $chart->getPlotArea()->getPlotGroupByIndex(0)->getPlotType();
-					echo '    ' , $chartType , EOL;
+					echo '    ', $chartType, EOL;
 				} else {
 					$chartTypes = array();
-					for($i = 0; $i < $groupCount; ++$i) {
+					for ($i = 0; $i < $groupCount; ++$i) {
 						$chartTypes[] = $chart->getPlotArea()->getPlotGroupByIndex($i)->getPlotType();
 					}
 					$chartTypes = array_unique($chartTypes);
 					if (count($chartTypes) == 1) {
 						$chartType = 'Multiple Plot ' . array_pop($chartTypes);
-						echo '    ' , $chartType , EOL;
+						echo '    ', $chartType, EOL;
 					} elseif (count($chartTypes) == 0) {
-						echo '    *** Type not yet implemented' , EOL;
+						echo '    *** Type not yet implemented', EOL;
 					} else {
-						echo '    Combination Chart' , EOL;
+						echo '    Combination Chart', EOL;
 					}
 				}
 			}
@@ -127,19 +127,19 @@ 
 
 	$outputFileName = str_replace('.xlsx', '.pdf', basename($inputFileName));
 
-	echo date('H:i:s') , " Write Tests to HTML file " , EOL;
+	echo date('H:i:s'), " Write Tests to HTML file ", EOL;
 	$objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'PDF');
 	$objWriter->setIncludeCharts(TRUE);
 	$objWriter->save($outputFileName);
-	echo date('H:i:s') , " File written to " , $outputFileName , EOL;
+	echo date('H:i:s'), " File written to ", $outputFileName, EOL;
 
 	$objPHPExcel->disconnectWorksheets();
 	unset($objPHPExcel);
 }
 
 // Echo memory peak usage
-echo date('H:i:s') , ' Peak memory usage: ' , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), ' Peak memory usage: ', (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
 
 // Echo done
-echo date('H:i:s') , " Done writing files" , EOL;
-echo 'Files have been created in ' , getcwd() , EOL;
+echo date('H:i:s'), " Done writing files", EOL;
+echo 'Files have been created in ', getcwd(), EOL;

Examples/44worksheetInfo.php

Spacing +1 added lines, -1 removed lines

@@ -29,7 +29,7 @@
 ini_set('display_errors', TRUE);
 ini_set('display_startup_errors', TRUE);
 
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
 
 date_default_timezone_set('Europe/London');
 

Indentation +1 added lines, -1 removed lines

@@ -38,7 +38,7 @@
 
 
 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;

Examples/08conditionalformatting2.php

Indentation +9 added lines, -9 removed lines

@@ -45,12 +45,12 @@ 
 // 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, representing sales data
@@ -97,9 +97,9 @@ 
 //	duplicate the conditional styles across a range of cells
 echo date('H:i:s') , " Duplicate the conditional formatting across a range of cells" , EOL;
 $objPHPExcel->getActiveSheet()->duplicateConditionalStyle(
-				$objPHPExcel->getActiveSheet()->getStyle('A1')->getConditionalStyles(),
-				'A2:A8'
-			  );
+                $objPHPExcel->getActiveSheet()->getStyle('A1')->getConditionalStyles(),
+                'A2:A8'
+                );
 
 
 // Save Excel 2007 file

Spacing +16 added lines, -16 removed lines

@@ -30,7 +30,7 @@ 
 ini_set('display_errors', TRUE);
 ini_set('display_startup_errors', TRUE);
 
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
 
 date_default_timezone_set('Europe/London');
 
@@ -39,11 +39,11 @@ 
 
 
 // Create new PHPExcel object
-echo date('H:i:s') , " Create new PHPExcel object" , EOL;
+echo date('H:i:s'), " Create new PHPExcel object", EOL;
 $objPHPExcel = new \PHPExcel\Spreadsheet();
 
 // Set document properties
-echo date('H:i:s') , " Set document properties" , EOL;
+echo date('H:i:s'), " Set document properties", EOL;
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
 							 ->setLastModifiedBy("Maarten Balliauw")
 							 ->setTitle("Office 2007 XLSX Test Document")
@@ -54,7 +54,7 @@ 
 
 
 // Create a first sheet, representing sales data
-echo date('H:i:s') , " Add some data" , EOL;
+echo date('H:i:s'), " Add some data", EOL;
 $objPHPExcel->setActiveSheetIndex(0);
 $objPHPExcel->getActiveSheet()
     ->setCellValue('A1', '-0.5')
@@ -75,7 +75,7 @@ 
 
 
 // Add conditional formatting
-echo date('H:i:s') , " Add conditional formatting" , EOL;
+echo date('H:i:s'), " Add conditional formatting", EOL;
 $objConditional1 = new \PHPExcel\Style\Conditional();
 $objConditional1->setConditionType(\PHPExcel\Style\Conditional::CONDITION_CELLIS)
     ->setOperatorType(\PHPExcel\Style\Conditional::OPERATOR_LESSTHAN)
@@ -95,7 +95,7 @@ 
 
 
 //	duplicate the conditional styles across a range of cells
-echo date('H:i:s') , " Duplicate the conditional formatting across a range of cells" , EOL;
+echo date('H:i:s'), " Duplicate the conditional formatting across a range of cells", EOL;
 $objPHPExcel->getActiveSheet()->duplicateConditionalStyle(
 				$objPHPExcel->getActiveSheet()->getStyle('A1')->getConditionalStyles(),
 				'A2:A8'
@@ -103,7 +103,7 @@ 
 
 
 // Save Excel 2007 file
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
 $callStartTime = microtime(true);
 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
@@ -111,10 +111,10 @@ 
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
 
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
 // Save Excel5 file
-echo date('H:i:s') , " Write to Excel5 format" , EOL;
+echo date('H:i:s'), " Write to Excel5 format", EOL;
 $callStartTime = microtime(true);
 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel5');
@@ -122,15 +122,15 @@ 
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
 
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
 // Echo memory usage
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
 
 
 // Echo memory peak usage
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
 
 // Echo done
-echo date('H:i:s') , " Done writing file" , EOL;
-echo 'File has been created in ' , getcwd() , EOL;
+echo date('H:i:s'), " Done writing file", EOL;
+echo 'File has been created in ', getcwd(), EOL;

Examples/04printing.php

Indentation +8 added lines, -8 removed lines

@@ -45,19 +45,19 @@
 // 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, we will use printing features
 echo date('H:i:s') , " Add some data" , EOL;
 for ($i = 1; $i < 200; $i++) {
-	$objPHPExcel->getActiveSheet()->setCellValue('A' . $i, $i);
-	$objPHPExcel->getActiveSheet()->setCellValue('B' . $i, 'Test value');
+    $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, $i);
+    $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, 'Test value');
 }
 
 // Set header and footer. When no different headers for odd/even are used, odd header is assumed.

Spacing +19 added lines, -19 removed lines

@@ -30,7 +30,7 @@ 
 ini_set('display_errors', TRUE);
 ini_set('display_startup_errors', TRUE);
 
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
 
 date_default_timezone_set('Europe/London');
 
@@ -39,11 +39,11 @@ 
 
 
 // Create new PHPExcel object
-echo date('H:i:s') , " Create new PHPExcel object" , EOL;
+echo date('H:i:s'), " Create new PHPExcel object", EOL;
 $objPHPExcel = new \PHPExcel\Spreadsheet();
 
 // Set document properties
-echo date('H:i:s') , " Set document properties" , EOL;
+echo date('H:i:s'), " Set document properties", EOL;
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
 							 ->setLastModifiedBy("Maarten Balliauw")
 							 ->setTitle("Office 2007 XLSX Test Document")
@@ -54,19 +54,19 @@ 
 
 
 // Add some data, we will use printing features
-echo date('H:i:s') , " Add some data" , EOL;
+echo date('H:i:s'), " Add some data", EOL;
 for ($i = 1; $i < 200; $i++) {
 	$objPHPExcel->getActiveSheet()->setCellValue('A' . $i, $i);
 	$objPHPExcel->getActiveSheet()->setCellValue('B' . $i, 'Test value');
 }
 
 // Set header and footer. When no different headers for odd/even are used, odd header is assumed.
-echo date('H:i:s') , " Set header/footer" , EOL;
+echo date('H:i:s'), " Set header/footer", EOL;
 $objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader('&L&G&C&HPlease treat this document as confidential!');
 $objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddFooter('&L&B' . $objPHPExcel->getProperties()->getTitle() . '&RPage &P of &N');
 
 // Add a drawing to the header
-echo date('H:i:s') , " Add a drawing to the header" , EOL;
+echo date('H:i:s'), " Add a drawing to the header", EOL;
 $objDrawing = new \PHPExcel\Worksheet\HeaderFooterDrawing();
 $objDrawing->setName('PHPExcel logo');
 $objDrawing->setPath('./images/phpexcel_logo.gif');
@@ -74,12 +74,12 @@ 
 $objPHPExcel->getActiveSheet()->getHeaderFooter()->addImage($objDrawing, \PHPExcel\Worksheet\HeaderFooter::IMAGE_HEADER_LEFT);
 
 // Set page orientation and size
-echo date('H:i:s') , " Set page orientation and size" , EOL;
+echo date('H:i:s'), " Set page orientation and size", EOL;
 $objPHPExcel->getActiveSheet()->getPageSetup()->setOrientation(\PHPExcel\Worksheet\PageSetup::ORIENTATION_LANDSCAPE);
 $objPHPExcel->getActiveSheet()->getPageSetup()->setPaperSize(\PHPExcel\Worksheet\PageSetup::PAPERSIZE_A4);
 
 // Rename worksheet
-echo date('H:i:s') , " Rename worksheet" , EOL;
+echo date('H:i:s'), " Rename worksheet", EOL;
 $objPHPExcel->getActiveSheet()->setTitle('Printing');
 
 
@@ -88,7 +88,7 @@ 
 
 
 // Save Excel 2007 file
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
 $callStartTime = microtime(true);
 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
@@ -96,14 +96,14 @@ 
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
 
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
 // Echo memory usage
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
 
 
 // Save Excel 95 file
-echo date('H:i:s') , " Write to Excel5 format" , EOL;
+echo date('H:i:s'), " Write to Excel5 format", EOL;
 $callStartTime = microtime(true);
 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel5');
@@ -111,15 +111,15 @@ 
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
 
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
 // Echo memory usage
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
 
 
 // Echo memory peak usage
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
 
 // Echo done
-echo date('H:i:s') , " Done writing files" , EOL;
-echo 'Files have been created in ' , getcwd() , EOL;
+echo date('H:i:s'), " Done writing files", EOL;
+echo 'Files have been created in ', getcwd(), EOL;