Completed
Push — develop ( 539a89...685e29 )
by Adrien
11:28
created
Examples/01simple-download-ods.php 1 patch
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -79,10 +79,10 @@
 block discarded – undo
79 79
 header('Cache-Control: max-age=1');
80 80
 
81 81
 // If you're serving to IE over SSL, then the following may be needed
82
-header ('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
83
-header ('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT'); // always modified
84
-header ('Cache-Control: cache, must-revalidate'); // HTTP/1.1
85
-header ('Pragma: public'); // HTTP/1.0
82
+header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
83
+header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified
84
+header('Cache-Control: cache, must-revalidate'); // HTTP/1.1
85
+header('Pragma: public'); // HTTP/1.0
86 86
 
87 87
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel5');
88 88
 $objWriter->save('php://output');
Please login to merge, or discard this patch.
Examples/36chartreadwriteHTML.php 1 patch
Spacing   +23 added lines, -23 removed lines patch added patch discarded remove patch
@@ -6,7 +6,7 @@  discard block
 block discarded – undo
6 6
 ini_set('display_startup_errors', TRUE);
7 7
 date_default_timezone_set('Europe/London');
8 8
 
9
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
9
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
10 10
 
11 11
 date_default_timezone_set('Europe/London');
12 12
 
@@ -61,63 +61,63 @@  discard block
 block discarded – undo
61 61
 
62 62
 if ((isset($argc)) && ($argc > 1)) {
63 63
 	$inputFileNames = array();
64
-	for($i = 1; $i < $argc; ++$i) {
64
+	for ($i = 1; $i < $argc; ++$i) {
65 65
 		$inputFileNames[] = dirname(__FILE__) . '/templates/' . $argv[$i];
66 66
 	}
67 67
 } else {
68 68
 	$inputFileNames = glob($inputFileNames);
69 69
 }
70
-foreach($inputFileNames as $inputFileName) {
70
+foreach ($inputFileNames as $inputFileName) {
71 71
 	$inputFileNameShort = basename($inputFileName);
72 72
 
73 73
 	if (!file_exists($inputFileName)) {
74
-		echo date('H:i:s') , " File " , $inputFileNameShort , ' does not exist' , EOL;
74
+		echo date('H:i:s'), " File ", $inputFileNameShort, ' does not exist', EOL;
75 75
 		continue;
76 76
 	}
77 77
 
78
-	echo date('H:i:s') , " Load Test from $inputFileType file " , $inputFileNameShort , EOL;
78
+	echo date('H:i:s'), " Load Test from $inputFileType file ", $inputFileNameShort, EOL;
79 79
 
80 80
 	$objReader = \PHPExcel\IOFactory::createReader($inputFileType);
81 81
 	$objReader->setIncludeCharts(TRUE);
82 82
 	$objPHPExcel = $objReader->load($inputFileName);
83 83
 
84 84
 
85
-	echo date('H:i:s') , " Iterate worksheets looking at the charts" , EOL;
85
+	echo date('H:i:s'), " Iterate worksheets looking at the charts", EOL;
86 86
 	foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
87 87
 		$sheetName = $worksheet->getTitle();
88
-		echo 'Worksheet: ' , $sheetName , EOL;
88
+		echo 'Worksheet: ', $sheetName, EOL;
89 89
 
90 90
 		$chartNames = $worksheet->getChartNames();
91
-		if(empty($chartNames)) {
92
-			echo '    There are no charts in this worksheet' , EOL;
91
+		if (empty($chartNames)) {
92
+			echo '    There are no charts in this worksheet', EOL;
93 93
 		} else {
94 94
 			natsort($chartNames);
95
-			foreach($chartNames as $i => $chartName) {
95
+			foreach ($chartNames as $i => $chartName) {
96 96
 				$chart = $worksheet->getChartByName($chartName);
97 97
 				if (!is_null($chart->getTitle())) {
98
-					$caption = '"' . implode(' ',$chart->getTitle()->getCaption()) . '"';
98
+					$caption = '"' . implode(' ', $chart->getTitle()->getCaption()) . '"';
99 99
 				} else {
100 100
 					$caption = 'Untitled';
101 101
 				}
102
-				echo '    ' , $chartName , ' - ' , $caption , EOL;
103
-				echo str_repeat(' ',strlen($chartName)+3);
102
+				echo '    ', $chartName, ' - ', $caption, EOL;
103
+				echo str_repeat(' ', strlen($chartName) + 3);
104 104
 				$groupCount = $chart->getPlotArea()->getPlotGroupCount();
105 105
 				if ($groupCount == 1) {
106 106
 					$chartType = $chart->getPlotArea()->getPlotGroupByIndex(0)->getPlotType();
107
-					echo '    ' , $chartType , EOL;
107
+					echo '    ', $chartType, EOL;
108 108
 				} else {
109 109
 					$chartTypes = array();
110
-					for($i = 0; $i < $groupCount; ++$i) {
110
+					for ($i = 0; $i < $groupCount; ++$i) {
111 111
 						$chartTypes[] = $chart->getPlotArea()->getPlotGroupByIndex($i)->getPlotType();
112 112
 					}
113 113
 					$chartTypes = array_unique($chartTypes);
114 114
 					if (count($chartTypes) == 1) {
115 115
 						$chartType = 'Multiple Plot ' . array_pop($chartTypes);
116
-						echo '    ' , $chartType , EOL;
116
+						echo '    ', $chartType, EOL;
117 117
 					} elseif (count($chartTypes) == 0) {
118
-						echo '    *** Type not yet implemented' , EOL;
118
+						echo '    *** Type not yet implemented', EOL;
119 119
 					} else {
120
-						echo '    Combination Chart' , EOL;
120
+						echo '    Combination Chart', EOL;
121 121
 					}
122 122
 				}
123 123
 			}
@@ -127,19 +127,19 @@  discard block
 block discarded – undo
127 127
 
128 128
 	$outputFileName = str_replace('.xlsx', '.pdf', basename($inputFileName));
129 129
 
130
-	echo date('H:i:s') , " Write Tests to HTML file " , EOL;
130
+	echo date('H:i:s'), " Write Tests to HTML file ", EOL;
131 131
 	$objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'PDF');
132 132
 	$objWriter->setIncludeCharts(TRUE);
133 133
 	$objWriter->save($outputFileName);
134
-	echo date('H:i:s') , " File written to " , $outputFileName , EOL;
134
+	echo date('H:i:s'), " File written to ", $outputFileName, EOL;
135 135
 
136 136
 	$objPHPExcel->disconnectWorksheets();
137 137
 	unset($objPHPExcel);
138 138
 }
139 139
 
140 140
 // Echo memory peak usage
141
-echo date('H:i:s') , ' Peak memory usage: ' , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
141
+echo date('H:i:s'), ' Peak memory usage: ', (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
142 142
 
143 143
 // Echo done
144
-echo date('H:i:s') , " Done writing files" , EOL;
145
-echo 'Files have been created in ' , getcwd() , EOL;
144
+echo date('H:i:s'), " Done writing files", EOL;
145
+echo 'Files have been created in ', getcwd(), EOL;
Please login to merge, or discard this patch.
Examples/06largescale-with-cellcaching-sqlite3.php 1 patch
Spacing   +17 added lines, -17 removed lines patch added patch discarded remove patch
@@ -30,7 +30,7 @@  discard block
 block discarded – undo
30 30
 ini_set('display_errors', TRUE);
31 31
 ini_set('display_startup_errors', TRUE);
32 32
 
33
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
33
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
34 34
 
35 35
 date_default_timezone_set('Europe/London');
36 36
 
@@ -39,18 +39,18 @@  discard block
 block discarded – undo
39 39
 
40 40
 $cacheMethod = \PHPExcel\CachedObjectStorageFactory::CACHE_TO_SQLITE;
41 41
 if (\PHPExcel\Settings::setCacheStorageMethod($cacheMethod)) {
42
-    echo date('H:i:s') , " Enable Cell Caching using " , $cacheMethod , " method" , EOL;
42
+    echo date('H:i:s'), " Enable Cell Caching using ", $cacheMethod, " method", EOL;
43 43
 } else {
44
-    echo date('H:i:s') , " Unable to set Cell Caching using " , $cacheMethod , " method, reverting to memory" , EOL;
44
+    echo date('H:i:s'), " Unable to set Cell Caching using ", $cacheMethod, " method, reverting to memory", EOL;
45 45
 }
46 46
 
47 47
 
48 48
 // Create new PHPExcel object
49
-echo date('H:i:s') , " Create new PHPExcel object" , EOL;
49
+echo date('H:i:s'), " Create new PHPExcel object", EOL;
50 50
 $objPHPExcel = new \PHPExcel\Spreadsheet();
51 51
 
52 52
 // Set document properties
53
-echo date('H:i:s') , " Set properties" , EOL;
53
+echo date('H:i:s'), " Set properties", EOL;
54 54
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
55 55
 							 ->setLastModifiedBy("Maarten Balliauw")
56 56
 							 ->setTitle("Office 2007 XLSX Test Document")
@@ -61,7 +61,7 @@  discard block
 block discarded – undo
61 61
 
62 62
 
63 63
 // Create a first sheet
64
-echo date('H:i:s') , " Add data" , EOL;
64
+echo date('H:i:s'), " Add data", EOL;
65 65
 $objPHPExcel->setActiveSheetIndex(0);
66 66
 $objPHPExcel->getActiveSheet()->setCellValue('A1', "Firstname");
67 67
 $objPHPExcel->getActiveSheet()->setCellValue('B1', "Lastname");
@@ -71,24 +71,24 @@  discard block
 block discarded – undo
71 71
 
72 72
 
73 73
 // Hide "Phone" and "fax" column
74
-echo date('H:i:s') , " Hide 'Phone' and 'fax' columns" , EOL;
74
+echo date('H:i:s'), " Hide 'Phone' and 'fax' columns", EOL;
75 75
 $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setVisible(false);
76 76
 $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setVisible(false);
77 77
 
78 78
 
79 79
 // Set outline levels
80
-echo date('H:i:s') , " Set outline levels" , EOL;
80
+echo date('H:i:s'), " Set outline levels", EOL;
81 81
 $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setOutlineLevel(1)
82 82
                                                        ->setVisible(false)
83 83
                                                        ->setCollapsed(true);
84 84
 
85 85
 // Freeze panes
86
-echo date('H:i:s') , " Freeze panes" , EOL;
86
+echo date('H:i:s'), " Freeze panes", EOL;
87 87
 $objPHPExcel->getActiveSheet()->freezePane('A2');
88 88
 
89 89
 
90 90
 // Rows to repeat at top
91
-echo date('H:i:s') , " Rows to repeat at top" , EOL;
91
+echo date('H:i:s'), " Rows to repeat at top", EOL;
92 92
 $objPHPExcel->getActiveSheet()->getPageSetup()->setRowsToRepeatAtTopByStartAndEnd(1, 1);
93 93
 
94 94
 
@@ -107,7 +107,7 @@  discard block
 block discarded – undo
107 107
 
108 108
 
109 109
 // Save Excel 2007 file
110
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
110
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
111 111
 $callStartTime = microtime(true);
112 112
 
113 113
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
@@ -115,15 +115,15 @@  discard block
 block discarded – undo
115 115
 $callEndTime = microtime(true);
116 116
 $callTime = $callEndTime - $callStartTime;
117 117
 
118
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
119
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
118
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
119
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
120 120
 // Echo memory usage
121
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
121
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
122 122
 
123 123
 
124 124
 // Echo memory peak usage
125
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
125
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
126 126
 
127 127
 // Echo done
128
-echo date('H:i:s') , " Done writing file" , EOL;
129
-echo 'File has been created in ' , getcwd() , EOL;
128
+echo date('H:i:s'), " Done writing file", EOL;
129
+echo 'File has been created in ', getcwd(), EOL;
Please login to merge, or discard this patch.
Examples/01pharSimple.php 1 patch
Spacing   +16 added lines, -16 removed lines patch added patch discarded remove patch
@@ -31,18 +31,18 @@  discard block
 block discarded – undo
31 31
 ini_set('display_startup_errors', TRUE);
32 32
 date_default_timezone_set('Europe/London');
33 33
 
34
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
34
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
35 35
 
36 36
 /** Include PHPExcel */
37 37
 require_once dirname(__FILE__) . '/../src/Bootstrap.php';
38 38
 
39 39
 
40 40
 // Create new PHPExcel object
41
-echo date('H:i:s') , " Create new PHPExcel object" , EOL;
41
+echo date('H:i:s'), " Create new PHPExcel object", EOL;
42 42
 $objPHPExcel = new \PHPExcel\Spreadsheet();
43 43
 
44 44
 // Set document properties
45
-echo date('H:i:s') , " Set document properties" , EOL;
45
+echo date('H:i:s'), " Set document properties", EOL;
46 46
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
47 47
 	->setLastModifiedBy("Maarten Balliauw")
48 48
 	->setTitle("PHPExcel Test Document")
@@ -53,7 +53,7 @@  discard block
 block discarded – undo
53 53
 
54 54
 
55 55
 // Add some data
56
-echo date('H:i:s') , " Add some data" , EOL;
56
+echo date('H:i:s'), " Add some data", EOL;
57 57
 
58 58
 $html1 = '<font color="#0000ff">
59 59
 <h1 align="center">My very first example of rich text<br />generated from html markup</h1>
@@ -124,7 +124,7 @@  discard block
 block discarded – undo
124 124
 
125 125
 
126 126
 // Rename worksheet
127
-echo date('H:i:s') , " Rename worksheet" , EOL;
127
+echo date('H:i:s'), " Rename worksheet", EOL;
128 128
 $objPHPExcel->getActiveSheet()
129 129
     ->setTitle('Rich Text Examples');
130 130
 
@@ -134,7 +134,7 @@  discard block
 block discarded – undo
134 134
 
135 135
 
136 136
 // Save Excel 2007 file
137
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
137
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
138 138
 $callStartTime = microtime(true);
139 139
 
140 140
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
@@ -142,14 +142,14 @@  discard block
 block discarded – undo
142 142
 $callEndTime = microtime(true);
143 143
 $callTime = $callEndTime - $callStartTime;
144 144
 
145
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
146
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
145
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
146
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
147 147
 // Echo memory usage
148
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
148
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
149 149
 
150 150
 
151 151
 // Save Excel 95 file
152
-echo date('H:i:s') , " Write to Excel5 format" , EOL;
152
+echo date('H:i:s'), " Write to Excel5 format", EOL;
153 153
 $callStartTime = microtime(true);
154 154
 
155 155
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel5');
@@ -157,15 +157,15 @@  discard block
 block discarded – undo
157 157
 $callEndTime = microtime(true);
158 158
 $callTime = $callEndTime - $callStartTime;
159 159
 
160
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
161
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
160
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
161
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
162 162
 // Echo memory usage
163
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
163
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
164 164
 
165 165
 
166 166
 // Echo memory peak usage
167
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
167
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
168 168
 
169 169
 // Echo done
170
-echo date('H:i:s') , " Done writing files" , EOL;
171
-echo 'Files have been created in ' , getcwd() , EOL;
170
+echo date('H:i:s'), " Done writing files", EOL;
171
+echo 'Files have been created in ', getcwd(), EOL;
Please login to merge, or discard this patch.
Examples/01simple-download-xlsx.php 1 patch
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -79,10 +79,10 @@
 block discarded – undo
79 79
 header('Cache-Control: max-age=1');
80 80
 
81 81
 // If you're serving to IE over SSL, then the following may be needed
82
-header ('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
83
-header ('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT'); // always modified
84
-header ('Cache-Control: cache, must-revalidate'); // HTTP/1.1
85
-header ('Pragma: public'); // HTTP/1.0
82
+header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
83
+header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified
84
+header('Cache-Control: cache, must-revalidate'); // HTTP/1.1
85
+header('Pragma: public'); // HTTP/1.0
86 86
 
87 87
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel5');
88 88
 $objWriter->save('php://output');
Please login to merge, or discard this patch.
Examples/33chartcreate-radar.php 1 patch
Spacing   +38 added lines, -38 removed lines patch added patch discarded remove patch
@@ -6,7 +6,7 @@  discard block
 block discarded – undo
6 6
 ini_set('display_startup_errors', TRUE);
7 7
 date_default_timezone_set('Europe/London');
8 8
 
9
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
9
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
10 10
 
11 11
 date_default_timezone_set('Europe/London');
12 12
 
@@ -44,19 +44,19 @@  discard block
 block discarded – undo
44 44
 $objWorksheet = $objPHPExcel->getActiveSheet();
45 45
 $objWorksheet->fromArray(
46 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),
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 60
 	)
61 61
 );
62 62
 
@@ -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
@@ -97,14 +97,14 @@  discard block
 block discarded – undo
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
106
-    NULL,                                           // plotDirection
107
-	NULL,											// smooth line
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
+    NULL, // plotDirection
107
+	NULL, // smooth line
108 108
 	\PHPExcel\Chart\DataSeries::STYLE_MARKER		// plotStyle
109 109
 );
110 110
 
@@ -121,13 +121,13 @@  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
124
+	'chart1', // name
125
+	$title, // title
126
+	$legend, // legend
127
+	$plotArea, // plotArea
128
+	true, // plotVisibleOnly
129
+	0, // displayBlanksAs
130
+	NULL, // xAxisLabel
131 131
 	NULL			// yAxisLabel		- Radar charts don't have a Y-Axis
132 132
 );
133 133
 
@@ -140,16 +140,16 @@  discard block
 block discarded – undo
140 140
 
141 141
 
142 142
 // Save Excel 2007 file
143
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
143
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
144 144
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
145 145
 $objWriter->setIncludeCharts(TRUE);
146 146
 $objWriter->save(str_replace('.php', '.xlsx', __FILE__));
147
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
147
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
148 148
 
149 149
 
150 150
 // Echo memory peak usage
151
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
151
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
152 152
 
153 153
 // Echo done
154
-echo date('H:i:s') , " Done writing file" , EOL;
155
-echo 'File has been created in ' , getcwd() , EOL;
154
+echo date('H:i:s'), " Done writing file", EOL;
155
+echo 'File has been created in ', getcwd(), EOL;
Please login to merge, or discard this patch.
tests/PhpSpreadsheet/Custom/Complex.php 1 patch
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -102,7 +102,7 @@
 block discarded – undo
102 102
             if (abs($this->imaginaryPart) != 1.0) {
103 103
                 $str .= $this->imaginaryPart . $this->suffix;
104 104
             } else {
105
-                $str .= (($this->imaginaryPart < 0.0) ? '-' : ''). $this->suffix;
105
+                $str .= (($this->imaginaryPart < 0.0) ? '-' : '') . $this->suffix;
106 106
             }
107 107
         }
108 108
         if ($this->realPart != 0.0) {
Please login to merge, or discard this patch.
tests/PhpSpreadsheet/Custom/ComplexAssert.php 1 patch
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -4,7 +4,7 @@
 block discarded – undo
4 4
 
5 5
 class ComplexAssert
6 6
 {
7
-    private $_errorMessage    = '';
7
+    private $_errorMessage = '';
8 8
 
9 9
     public function assertComplexEquals($expected, $actual, $delta = 0)
10 10
     {
Please login to merge, or discard this patch.
tests/PhpSpreadsheet/Calculation/LogicalTest.php 1 patch
Spacing   +5 added lines, -5 removed lines patch added patch discarded remove patch
@@ -32,7 +32,7 @@  discard block
 block discarded – undo
32 32
     {
33 33
         $args = func_get_args();
34 34
         $expectedResult = array_pop($args);
35
-        $result = call_user_func_array(array(Logical::class,'logicalAnd'), $args);
35
+        $result = call_user_func_array(array(Logical::class, 'logicalAnd'), $args);
36 36
         $this->assertEquals($expectedResult, $result);
37 37
     }
38 38
 
@@ -48,7 +48,7 @@  discard block
 block discarded – undo
48 48
     {
49 49
         $args = func_get_args();
50 50
         $expectedResult = array_pop($args);
51
-        $result = call_user_func_array(array(Logical::class,'logicalOr'), $args);
51
+        $result = call_user_func_array(array(Logical::class, 'logicalOr'), $args);
52 52
         $this->assertEquals($expectedResult, $result);
53 53
     }
54 54
 
@@ -64,7 +64,7 @@  discard block
 block discarded – undo
64 64
     {
65 65
         $args = func_get_args();
66 66
         $expectedResult = array_pop($args);
67
-        $result = call_user_func_array(array(Logical::class,'NOT'), $args);
67
+        $result = call_user_func_array(array(Logical::class, 'NOT'), $args);
68 68
         $this->assertEquals($expectedResult, $result);
69 69
     }
70 70
 
@@ -80,7 +80,7 @@  discard block
 block discarded – undo
80 80
     {
81 81
         $args = func_get_args();
82 82
         $expectedResult = array_pop($args);
83
-        $result = call_user_func_array(array(Logical::class,'statementIf'), $args);
83
+        $result = call_user_func_array(array(Logical::class, 'statementIf'), $args);
84 84
         $this->assertEquals($expectedResult, $result);
85 85
     }
86 86
 
@@ -96,7 +96,7 @@  discard block
 block discarded – undo
96 96
     {
97 97
         $args = func_get_args();
98 98
         $expectedResult = array_pop($args);
99
-        $result = call_user_func_array(array(Logical::class,'IFERROR'), $args);
99
+        $result = call_user_func_array(array(Logical::class, 'IFERROR'), $args);
100 100
         $this->assertEquals($expectedResult, $result);
101 101
     }
102 102
 
Please login to merge, or discard this patch.