Completed
Branch develop (d19f73)
by Adrien
09:49
created
Examples/06largescale-with-cellcaching-sqlite3.php 2 patches
Indentation   +13 added lines, -13 removed lines patch added patch discarded remove 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
 
Please login to merge, or discard this 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 2 patches
Indentation   +6 added lines, -6 removed lines patch added patch discarded remove patch
@@ -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
Please login to merge, or discard this 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 3 patches
Indentation   +7 added lines, -7 removed lines patch added patch discarded remove patch
@@ -32,7 +32,7 @@  discard block
 block discarded – undo
32 32
 date_default_timezone_set('Europe/London');
33 33
 
34 34
 if (PHP_SAPI == 'cli')
35
-	die('This example should only be run from a Web Browser');
35
+    die('This example should only be run from a Web Browser');
36 36
 
37 37
 /** Include PHPExcel */
38 38
 require_once dirname(__FILE__) . '/../src/Bootstrap.php';
@@ -43,12 +43,12 @@  discard block
 block discarded – undo
43 43
 
44 44
 // Set document properties
45 45
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
46
-							 ->setLastModifiedBy("Maarten Balliauw")
47
-							 ->setTitle("Office 2007 XLSX Test Document")
48
-							 ->setSubject("Office 2007 XLSX Test Document")
49
-							 ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
50
-							 ->setKeywords("office 2007 openxml php")
51
-							 ->setCategory("Test result file");
46
+                                ->setLastModifiedBy("Maarten Balliauw")
47
+                                ->setTitle("Office 2007 XLSX Test Document")
48
+                                ->setSubject("Office 2007 XLSX Test Document")
49
+                                ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
50
+                                ->setKeywords("office 2007 openxml php")
51
+                                ->setCategory("Test result file");
52 52
 
53 53
 
54 54
 // Add some data
Please login to merge, or discard this 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.
Braces   +2 added lines, -1 removed lines patch added patch discarded remove patch
@@ -31,8 +31,9 @@
 block discarded – undo
31 31
 ini_set('display_startup_errors', TRUE);
32 32
 date_default_timezone_set('Europe/London');
33 33
 
34
-if (PHP_SAPI == 'cli')
34
+if (PHP_SAPI == 'cli') {
35 35
 	die('This example should only be run from a Web Browser');
36
+}
36 37
 
37 38
 /** Include PHPExcel */
38 39
 require_once dirname(__FILE__) . '/../src/Bootstrap.php';
Please login to merge, or discard this patch.
Examples/33chartcreate-radar.php 2 patches
Indentation   +37 added lines, -37 removed lines patch added patch discarded remove patch
@@ -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
Please login to merge, or discard this 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.
tests/PhpSpreadsheet/Calculation/EngineeringTest.php 1 patch
Spacing   +39 added lines, -39 removed lines patch added patch discarded remove patch
@@ -31,7 +31,7 @@  discard block
 block discarded – undo
31 31
     {
32 32
         $args = func_get_args();
33 33
         $expectedResult = array_pop($args);
34
-        $result = call_user_func_array(array(Engineering::class,'BESSELI'), $args);
34
+        $result = call_user_func_array(array(Engineering::class, 'BESSELI'), $args);
35 35
         $this->assertEquals($expectedResult, $result, null, 1E-8);
36 36
     }
37 37
 
@@ -47,7 +47,7 @@  discard block
 block discarded – undo
47 47
     {
48 48
         $args = func_get_args();
49 49
         $expectedResult = array_pop($args);
50
-        $result = call_user_func_array(array(Engineering::class,'BESSELJ'), $args);
50
+        $result = call_user_func_array(array(Engineering::class, 'BESSELJ'), $args);
51 51
         $this->assertEquals($expectedResult, $result, null, 1E-8);
52 52
     }
53 53
 
@@ -63,7 +63,7 @@  discard block
 block discarded – undo
63 63
     {
64 64
         $args = func_get_args();
65 65
         $expectedResult = array_pop($args);
66
-        $result = call_user_func_array(array(Engineering::class,'BESSELK'), $args);
66
+        $result = call_user_func_array(array(Engineering::class, 'BESSELK'), $args);
67 67
         $this->assertEquals($expectedResult, $result, null, 1E-8);
68 68
     }
69 69
 
@@ -79,7 +79,7 @@  discard block
 block discarded – undo
79 79
     {
80 80
         $args = func_get_args();
81 81
         $expectedResult = array_pop($args);
82
-        $result = call_user_func_array(array(Engineering::class,'BESSELY'), $args);
82
+        $result = call_user_func_array(array(Engineering::class, 'BESSELY'), $args);
83 83
         $this->assertEquals($expectedResult, $result, null, 1E-8);
84 84
     }
85 85
 
@@ -95,7 +95,7 @@  discard block
 block discarded – undo
95 95
     {
96 96
         $args = func_get_args();
97 97
         $expectedResult = array_pop($args);
98
-        $result = call_user_func_array(array(Engineering::class,'COMPLEX'), $args);
98
+        $result = call_user_func_array(array(Engineering::class, 'COMPLEX'), $args);
99 99
         $this->assertEquals($expectedResult, $result);
100 100
     }
101 101
 
@@ -111,7 +111,7 @@  discard block
 block discarded – undo
111 111
     {
112 112
         $args = func_get_args();
113 113
         $expectedResult = array_pop($args);
114
-        $result = call_user_func_array(array(Engineering::class,'IMAGINARY'), $args);
114
+        $result = call_user_func_array(array(Engineering::class, 'IMAGINARY'), $args);
115 115
         $this->assertEquals($expectedResult, $result, null, 1E-8);
116 116
     }
117 117
 
@@ -127,7 +127,7 @@  discard block
 block discarded – undo
127 127
     {
128 128
         $args = func_get_args();
129 129
         $expectedResult = array_pop($args);
130
-        $result = call_user_func_array(array(Engineering::class,'IMREAL'), $args);
130
+        $result = call_user_func_array(array(Engineering::class, 'IMREAL'), $args);
131 131
         $this->assertEquals($expectedResult, $result, null, 1E-8);
132 132
     }
133 133
 
@@ -143,7 +143,7 @@  discard block
 block discarded – undo
143 143
     {
144 144
         $args = func_get_args();
145 145
         $expectedResult = array_pop($args);
146
-        $result = call_user_func_array(array(Engineering::class,'IMABS'), $args);
146
+        $result = call_user_func_array(array(Engineering::class, 'IMABS'), $args);
147 147
         $this->assertEquals($expectedResult, $result, null, 1E-8);
148 148
     }
149 149
 
@@ -160,7 +160,7 @@  discard block
 block discarded – undo
160 160
     {
161 161
         $args = func_get_args();
162 162
         $expectedResult = array_pop($args);
163
-        $result = call_user_func_array(array(Engineering::class,'IMARGUMENT'), $args);
163
+        $result = call_user_func_array(array(Engineering::class, 'IMARGUMENT'), $args);
164 164
         $this->assertEquals($expectedResult, $result, null, 1E-8);
165 165
     }
166 166
 
@@ -176,7 +176,7 @@  discard block
 block discarded – undo
176 176
     {
177 177
         $args = func_get_args();
178 178
         $expectedResult = array_pop($args);
179
-        $result = call_user_func_array(array(Engineering::class,'IMCONJUGATE'), $args);
179
+        $result = call_user_func_array(array(Engineering::class, 'IMCONJUGATE'), $args);
180 180
         $this->assertTrue($this->complexAssert->assertComplexEquals($expectedResult, $result, 1E-8), $this->complexAssert->getErrorMessage());
181 181
     }
182 182
 
@@ -192,7 +192,7 @@  discard block
 block discarded – undo
192 192
     {
193 193
         $args = func_get_args();
194 194
         $expectedResult = array_pop($args);
195
-        $result = call_user_func_array(array(Engineering::class,'IMCOS'), $args);
195
+        $result = call_user_func_array(array(Engineering::class, 'IMCOS'), $args);
196 196
         $this->assertTrue($this->complexAssert->assertComplexEquals($expectedResult, $result, 1E-8), $this->complexAssert->getErrorMessage());
197 197
     }
198 198
 
@@ -211,7 +211,7 @@  discard block
 block discarded – undo
211 211
 
212 212
         $args = func_get_args();
213 213
         $expectedResult = array_pop($args);
214
-        $result = call_user_func_array(array(Engineering::class,'IMDIV'), $args);
214
+        $result = call_user_func_array(array(Engineering::class, 'IMDIV'), $args);
215 215
         $this->assertTrue($this->complexAssert->assertComplexEquals($expectedResult, $result, 1E-8), $this->complexAssert->getErrorMessage());
216 216
     }
217 217
 
@@ -227,7 +227,7 @@  discard block
 block discarded – undo
227 227
     {
228 228
         $args = func_get_args();
229 229
         $expectedResult = array_pop($args);
230
-        $result = call_user_func_array(array(Engineering::class,'IMEXP'), $args);
230
+        $result = call_user_func_array(array(Engineering::class, 'IMEXP'), $args);
231 231
         $this->assertTrue($this->complexAssert->assertComplexEquals($expectedResult, $result, 1E-8), $this->complexAssert->getErrorMessage());
232 232
     }
233 233
 
@@ -243,7 +243,7 @@  discard block
 block discarded – undo
243 243
     {
244 244
         $args = func_get_args();
245 245
         $expectedResult = array_pop($args);
246
-        $result = call_user_func_array(array(Engineering::class,'IMLN'), $args);
246
+        $result = call_user_func_array(array(Engineering::class, 'IMLN'), $args);
247 247
         $this->assertTrue($this->complexAssert->assertComplexEquals($expectedResult, $result, 1E-8), $this->complexAssert->getErrorMessage());
248 248
     }
249 249
 
@@ -259,7 +259,7 @@  discard block
 block discarded – undo
259 259
     {
260 260
         $args = func_get_args();
261 261
         $expectedResult = array_pop($args);
262
-        $result = call_user_func_array(array(Engineering::class,'IMLOG2'), $args);
262
+        $result = call_user_func_array(array(Engineering::class, 'IMLOG2'), $args);
263 263
         $this->assertTrue($this->complexAssert->assertComplexEquals($expectedResult, $result, 1E-8), $this->complexAssert->getErrorMessage());
264 264
     }
265 265
 
@@ -275,7 +275,7 @@  discard block
 block discarded – undo
275 275
     {
276 276
         $args = func_get_args();
277 277
         $expectedResult = array_pop($args);
278
-        $result = call_user_func_array(array(Engineering::class,'IMLOG10'), $args);
278
+        $result = call_user_func_array(array(Engineering::class, 'IMLOG10'), $args);
279 279
         $this->assertTrue($this->complexAssert->assertComplexEquals($expectedResult, $result, 1E-8), $this->complexAssert->getErrorMessage());
280 280
     }
281 281
 
@@ -294,7 +294,7 @@  discard block
 block discarded – undo
294 294
 
295 295
         $args = func_get_args();
296 296
         $expectedResult = array_pop($args);
297
-        $result = call_user_func_array(array(Engineering::class,'IMPOWER'), $args);
297
+        $result = call_user_func_array(array(Engineering::class, 'IMPOWER'), $args);
298 298
         $this->assertTrue($this->complexAssert->assertComplexEquals($expectedResult, $result, 1E-8), $this->complexAssert->getErrorMessage());
299 299
     }
300 300
 
@@ -310,7 +310,7 @@  discard block
 block discarded – undo
310 310
     {
311 311
         $args = func_get_args();
312 312
         $expectedResult = array_pop($args);
313
-        $result = call_user_func_array(array(Engineering::class,'IMPRODUCT'), $args);
313
+        $result = call_user_func_array(array(Engineering::class, 'IMPRODUCT'), $args);
314 314
         $this->assertTrue($this->complexAssert->assertComplexEquals($expectedResult, $result, 1E-8), $this->complexAssert->getErrorMessage());
315 315
     }
316 316
 
@@ -326,7 +326,7 @@  discard block
 block discarded – undo
326 326
     {
327 327
         $args = func_get_args();
328 328
         $expectedResult = array_pop($args);
329
-        $result = call_user_func_array(array(Engineering::class,'IMSIN'), $args);
329
+        $result = call_user_func_array(array(Engineering::class, 'IMSIN'), $args);
330 330
         $this->assertTrue($this->complexAssert->assertComplexEquals($expectedResult, $result, 1E-8), $this->complexAssert->getErrorMessage());
331 331
     }
332 332
 
@@ -342,7 +342,7 @@  discard block
 block discarded – undo
342 342
     {
343 343
         $args = func_get_args();
344 344
         $expectedResult = array_pop($args);
345
-        $result = call_user_func_array(array(Engineering::class,'IMSQRT'), $args);
345
+        $result = call_user_func_array(array(Engineering::class, 'IMSQRT'), $args);
346 346
         $this->assertTrue($this->complexAssert->assertComplexEquals($expectedResult, $result, 1E-8), $this->complexAssert->getErrorMessage());
347 347
     }
348 348
 
@@ -361,7 +361,7 @@  discard block
 block discarded – undo
361 361
 
362 362
         $args = func_get_args();
363 363
         $expectedResult = array_pop($args);
364
-        $result = call_user_func_array(array(Engineering::class,'IMSUB'), $args);
364
+        $result = call_user_func_array(array(Engineering::class, 'IMSUB'), $args);
365 365
         $this->assertTrue($this->complexAssert->assertComplexEquals($expectedResult, $result, 1E-8), $this->complexAssert->getErrorMessage());
366 366
     }
367 367
 
@@ -378,7 +378,7 @@  discard block
 block discarded – undo
378 378
     {
379 379
         $args = func_get_args();
380 380
         $expectedResult = array_pop($args);
381
-        $result = call_user_func_array(array(Engineering::class,'IMSUM'), $args);
381
+        $result = call_user_func_array(array(Engineering::class, 'IMSUM'), $args);
382 382
         $this->assertTrue($this->complexAssert->assertComplexEquals($expectedResult, $result, 1E-8), $this->complexAssert->getErrorMessage());
383 383
     }
384 384
 
@@ -394,7 +394,7 @@  discard block
 block discarded – undo
394 394
     {
395 395
         $args = func_get_args();
396 396
         $expectedResult = array_pop($args);
397
-        $result = call_user_func_array(array(Engineering::class,'ERF'), $args);
397
+        $result = call_user_func_array(array(Engineering::class, 'ERF'), $args);
398 398
         $this->assertEquals($expectedResult, $result, null, 1E-12);
399 399
     }
400 400
 
@@ -410,7 +410,7 @@  discard block
 block discarded – undo
410 410
     {
411 411
         $args = func_get_args();
412 412
         $expectedResult = array_pop($args);
413
-        $result = call_user_func_array(array(Engineering::class,'ERFC'), $args);
413
+        $result = call_user_func_array(array(Engineering::class, 'ERFC'), $args);
414 414
         $this->assertEquals($expectedResult, $result, null, 1E-12);
415 415
     }
416 416
 
@@ -426,7 +426,7 @@  discard block
 block discarded – undo
426 426
     {
427 427
         $args = func_get_args();
428 428
         $expectedResult = array_pop($args);
429
-        $result = call_user_func_array(array(Engineering::class,'BINTODEC'), $args);
429
+        $result = call_user_func_array(array(Engineering::class, 'BINTODEC'), $args);
430 430
         $this->assertEquals($expectedResult, $result);
431 431
     }
432 432
 
@@ -442,7 +442,7 @@  discard block
 block discarded – undo
442 442
     {
443 443
         $args = func_get_args();
444 444
         $expectedResult = array_pop($args);
445
-        $result = call_user_func_array(array(Engineering::class,'BINTOHEX'), $args);
445
+        $result = call_user_func_array(array(Engineering::class, 'BINTOHEX'), $args);
446 446
         $this->assertEquals($expectedResult, $result);
447 447
     }
448 448
 
@@ -458,7 +458,7 @@  discard block
 block discarded – undo
458 458
     {
459 459
         $args = func_get_args();
460 460
         $expectedResult = array_pop($args);
461
-        $result = call_user_func_array(array(Engineering::class,'BINTOOCT'), $args);
461
+        $result = call_user_func_array(array(Engineering::class, 'BINTOOCT'), $args);
462 462
         $this->assertEquals($expectedResult, $result);
463 463
     }
464 464
 
@@ -474,7 +474,7 @@  discard block
 block discarded – undo
474 474
     {
475 475
         $args = func_get_args();
476 476
         $expectedResult = array_pop($args);
477
-        $result = call_user_func_array(array(Engineering::class,'DECTOBIN'), $args);
477
+        $result = call_user_func_array(array(Engineering::class, 'DECTOBIN'), $args);
478 478
         $this->assertEquals($expectedResult, $result, null);
479 479
     }
480 480
 
@@ -490,7 +490,7 @@  discard block
 block discarded – undo
490 490
     {
491 491
         $args = func_get_args();
492 492
         $expectedResult = array_pop($args);
493
-        $result = call_user_func_array(array(Engineering::class,'DECTOHEX'), $args);
493
+        $result = call_user_func_array(array(Engineering::class, 'DECTOHEX'), $args);
494 494
         $this->assertEquals($expectedResult, $result, null);
495 495
     }
496 496
 
@@ -506,7 +506,7 @@  discard block
 block discarded – undo
506 506
     {
507 507
         $args = func_get_args();
508 508
         $expectedResult = array_pop($args);
509
-        $result = call_user_func_array(array(Engineering::class,'DECTOOCT'), $args);
509
+        $result = call_user_func_array(array(Engineering::class, 'DECTOOCT'), $args);
510 510
         $this->assertEquals($expectedResult, $result, null);
511 511
     }
512 512
 
@@ -522,7 +522,7 @@  discard block
 block discarded – undo
522 522
     {
523 523
         $args = func_get_args();
524 524
         $expectedResult = array_pop($args);
525
-        $result = call_user_func_array(array(Engineering::class,'HEXTOBIN'), $args);
525
+        $result = call_user_func_array(array(Engineering::class, 'HEXTOBIN'), $args);
526 526
         $this->assertEquals($expectedResult, $result, null);
527 527
     }
528 528
 
@@ -538,7 +538,7 @@  discard block
 block discarded – undo
538 538
     {
539 539
         $args = func_get_args();
540 540
         $expectedResult = array_pop($args);
541
-        $result = call_user_func_array(array(Engineering::class,'HEXTODEC'), $args);
541
+        $result = call_user_func_array(array(Engineering::class, 'HEXTODEC'), $args);
542 542
         $this->assertEquals($expectedResult, $result, null);
543 543
     }
544 544
 
@@ -554,7 +554,7 @@  discard block
 block discarded – undo
554 554
     {
555 555
         $args = func_get_args();
556 556
         $expectedResult = array_pop($args);
557
-        $result = call_user_func_array(array(Engineering::class,'HEXTOOCT'), $args);
557
+        $result = call_user_func_array(array(Engineering::class, 'HEXTOOCT'), $args);
558 558
         $this->assertEquals($expectedResult, $result, null);
559 559
     }
560 560
 
@@ -570,7 +570,7 @@  discard block
 block discarded – undo
570 570
     {
571 571
         $args = func_get_args();
572 572
         $expectedResult = array_pop($args);
573
-        $result = call_user_func_array(array(Engineering::class,'OCTTOBIN'), $args);
573
+        $result = call_user_func_array(array(Engineering::class, 'OCTTOBIN'), $args);
574 574
         $this->assertEquals($expectedResult, $result, null);
575 575
     }
576 576
 
@@ -586,7 +586,7 @@  discard block
 block discarded – undo
586 586
     {
587 587
         $args = func_get_args();
588 588
         $expectedResult = array_pop($args);
589
-        $result = call_user_func_array(array(Engineering::class,'OCTTODEC'), $args);
589
+        $result = call_user_func_array(array(Engineering::class, 'OCTTODEC'), $args);
590 590
         $this->assertEquals($expectedResult, $result, null);
591 591
     }
592 592
 
@@ -602,7 +602,7 @@  discard block
 block discarded – undo
602 602
     {
603 603
         $args = func_get_args();
604 604
         $expectedResult = array_pop($args);
605
-        $result = call_user_func_array(array(Engineering::class,'OCTTOHEX'), $args);
605
+        $result = call_user_func_array(array(Engineering::class, 'OCTTOHEX'), $args);
606 606
         $this->assertEquals($expectedResult, $result, null);
607 607
     }
608 608
 
@@ -618,7 +618,7 @@  discard block
 block discarded – undo
618 618
     {
619 619
         $args = func_get_args();
620 620
         $expectedResult = array_pop($args);
621
-        $result = call_user_func_array(array(Engineering::class,'DELTA'), $args);
621
+        $result = call_user_func_array(array(Engineering::class, 'DELTA'), $args);
622 622
         $this->assertEquals($expectedResult, $result, null);
623 623
     }
624 624
 
@@ -634,7 +634,7 @@  discard block
 block discarded – undo
634 634
     {
635 635
         $args = func_get_args();
636 636
         $expectedResult = array_pop($args);
637
-        $result = call_user_func_array(array(Engineering::class,'GESTEP'), $args);
637
+        $result = call_user_func_array(array(Engineering::class, 'GESTEP'), $args);
638 638
         $this->assertEquals($expectedResult, $result, null);
639 639
     }
640 640
 
@@ -674,7 +674,7 @@  discard block
 block discarded – undo
674 674
     {
675 675
         $args = func_get_args();
676 676
         $expectedResult = array_pop($args);
677
-        $result = call_user_func_array(array(Engineering::class,'CONVERTUOM'), $args);
677
+        $result = call_user_func_array(array(Engineering::class, 'CONVERTUOM'), $args);
678 678
         $this->assertEquals($expectedResult, $result, null);
679 679
     }
680 680
 
Please login to merge, or discard this patch.
tests/PhpSpreadsheet/Calculation/FinancialTest.php 1 patch
Spacing   +31 added lines, -31 removed lines patch added patch discarded remove patch
@@ -21,7 +21,7 @@  discard block
 block discarded – undo
21 21
     {
22 22
         $args = func_get_args();
23 23
         $expectedResult = array_pop($args);
24
-        $result = call_user_func_array(array(Financial::class,'ACCRINT'), $args);
24
+        $result = call_user_func_array(array(Financial::class, 'ACCRINT'), $args);
25 25
         $this->assertEquals($expectedResult, $result, null, 1E-8);
26 26
     }
27 27
 
@@ -37,7 +37,7 @@  discard block
 block discarded – undo
37 37
     {
38 38
         $args = func_get_args();
39 39
         $expectedResult = array_pop($args);
40
-        $result = call_user_func_array(array(Financial::class,'ACCRINTM'), $args);
40
+        $result = call_user_func_array(array(Financial::class, 'ACCRINTM'), $args);
41 41
         $this->assertEquals($expectedResult, $result, null, 1E-8);
42 42
     }
43 43
 
@@ -53,7 +53,7 @@  discard block
 block discarded – undo
53 53
     {
54 54
         $args = func_get_args();
55 55
         $expectedResult = array_pop($args);
56
-        $result = call_user_func_array(array(Financial::class,'AMORDEGRC'), $args);
56
+        $result = call_user_func_array(array(Financial::class, 'AMORDEGRC'), $args);
57 57
         $this->assertEquals($expectedResult, $result, null, 1E-8);
58 58
     }
59 59
 
@@ -69,7 +69,7 @@  discard block
 block discarded – undo
69 69
     {
70 70
         $args = func_get_args();
71 71
         $expectedResult = array_pop($args);
72
-        $result = call_user_func_array(array(Financial::class,'AMORLINC'), $args);
72
+        $result = call_user_func_array(array(Financial::class, 'AMORLINC'), $args);
73 73
         $this->assertEquals($expectedResult, $result, null, 1E-8);
74 74
     }
75 75
 
@@ -85,7 +85,7 @@  discard block
 block discarded – undo
85 85
     {
86 86
         $args = func_get_args();
87 87
         $expectedResult = array_pop($args);
88
-        $result = call_user_func_array(array(Financial::class,'COUPDAYBS'), $args);
88
+        $result = call_user_func_array(array(Financial::class, 'COUPDAYBS'), $args);
89 89
         $this->assertEquals($expectedResult, $result, null, 1E-8);
90 90
     }
91 91
 
@@ -101,7 +101,7 @@  discard block
 block discarded – undo
101 101
     {
102 102
         $args = func_get_args();
103 103
         $expectedResult = array_pop($args);
104
-        $result = call_user_func_array(array(Financial::class,'COUPDAYS'), $args);
104
+        $result = call_user_func_array(array(Financial::class, 'COUPDAYS'), $args);
105 105
         $this->assertEquals($expectedResult, $result, null, 1E-8);
106 106
     }
107 107
 
@@ -117,7 +117,7 @@  discard block
 block discarded – undo
117 117
     {
118 118
         $args = func_get_args();
119 119
         $expectedResult = array_pop($args);
120
-        $result = call_user_func_array(array(Financial::class,'COUPDAYSNC'), $args);
120
+        $result = call_user_func_array(array(Financial::class, 'COUPDAYSNC'), $args);
121 121
         $this->assertEquals($expectedResult, $result, null, 1E-8);
122 122
     }
123 123
 
@@ -133,7 +133,7 @@  discard block
 block discarded – undo
133 133
     {
134 134
         $args = func_get_args();
135 135
         $expectedResult = array_pop($args);
136
-        $result = call_user_func_array(array(Financial::class,'COUPNCD'), $args);
136
+        $result = call_user_func_array(array(Financial::class, 'COUPNCD'), $args);
137 137
         $this->assertEquals($expectedResult, $result, null, 1E-8);
138 138
     }
139 139
 
@@ -149,7 +149,7 @@  discard block
 block discarded – undo
149 149
     {
150 150
         $args = func_get_args();
151 151
         $expectedResult = array_pop($args);
152
-        $result = call_user_func_array(array(Financial::class,'COUPNUM'), $args);
152
+        $result = call_user_func_array(array(Financial::class, 'COUPNUM'), $args);
153 153
         $this->assertEquals($expectedResult, $result, null, 1E-8);
154 154
     }
155 155
 
@@ -165,7 +165,7 @@  discard block
 block discarded – undo
165 165
     {
166 166
         $args = func_get_args();
167 167
         $expectedResult = array_pop($args);
168
-        $result = call_user_func_array(array(Financial::class,'COUPPCD'), $args);
168
+        $result = call_user_func_array(array(Financial::class, 'COUPPCD'), $args);
169 169
         $this->assertEquals($expectedResult, $result, null, 1E-8);
170 170
     }
171 171
 
@@ -181,7 +181,7 @@  discard block
 block discarded – undo
181 181
     {
182 182
         $args = func_get_args();
183 183
         $expectedResult = array_pop($args);
184
-        $result = call_user_func_array(array(Financial::class,'CUMIPMT'), $args);
184
+        $result = call_user_func_array(array(Financial::class, 'CUMIPMT'), $args);
185 185
         $this->assertEquals($expectedResult, $result, null, 1E-8);
186 186
     }
187 187
 
@@ -197,7 +197,7 @@  discard block
 block discarded – undo
197 197
     {
198 198
         $args = func_get_args();
199 199
         $expectedResult = array_pop($args);
200
-        $result = call_user_func_array(array(Financial::class,'CUMPRINC'), $args);
200
+        $result = call_user_func_array(array(Financial::class, 'CUMPRINC'), $args);
201 201
         $this->assertEquals($expectedResult, $result, null, 1E-8);
202 202
     }
203 203
 
@@ -213,7 +213,7 @@  discard block
 block discarded – undo
213 213
     {
214 214
         $args = func_get_args();
215 215
         $expectedResult = array_pop($args);
216
-        $result = call_user_func_array(array(Financial::class,'DB'), $args);
216
+        $result = call_user_func_array(array(Financial::class, 'DB'), $args);
217 217
         $this->assertEquals($expectedResult, $result, null, 1E-8);
218 218
     }
219 219
 
@@ -229,7 +229,7 @@  discard block
 block discarded – undo
229 229
     {
230 230
         $args = func_get_args();
231 231
         $expectedResult = array_pop($args);
232
-        $result = call_user_func_array(array(Financial::class,'DDB'), $args);
232
+        $result = call_user_func_array(array(Financial::class, 'DDB'), $args);
233 233
         $this->assertEquals($expectedResult, $result, null, 1E-8);
234 234
     }
235 235
 
@@ -245,7 +245,7 @@  discard block
 block discarded – undo
245 245
     {
246 246
         $args = func_get_args();
247 247
         $expectedResult = array_pop($args);
248
-        $result = call_user_func_array(array(Financial::class,'DISC'), $args);
248
+        $result = call_user_func_array(array(Financial::class, 'DISC'), $args);
249 249
         $this->assertEquals($expectedResult, $result, null, 1E-8);
250 250
     }
251 251
 
@@ -261,7 +261,7 @@  discard block
 block discarded – undo
261 261
     {
262 262
         $args = func_get_args();
263 263
         $expectedResult = array_pop($args);
264
-        $result = call_user_func_array(array(Financial::class,'DOLLARDE'), $args);
264
+        $result = call_user_func_array(array(Financial::class, 'DOLLARDE'), $args);
265 265
         $this->assertEquals($expectedResult, $result, null, 1E-8);
266 266
     }
267 267
 
@@ -277,7 +277,7 @@  discard block
 block discarded – undo
277 277
     {
278 278
         $args = func_get_args();
279 279
         $expectedResult = array_pop($args);
280
-        $result = call_user_func_array(array(Financial::class,'DOLLARFR'), $args);
280
+        $result = call_user_func_array(array(Financial::class, 'DOLLARFR'), $args);
281 281
         $this->assertEquals($expectedResult, $result, null, 1E-8);
282 282
     }
283 283
 
@@ -293,7 +293,7 @@  discard block
 block discarded – undo
293 293
     {
294 294
         $args = func_get_args();
295 295
         $expectedResult = array_pop($args);
296
-        $result = call_user_func_array(array(Financial::class,'EFFECT'), $args);
296
+        $result = call_user_func_array(array(Financial::class, 'EFFECT'), $args);
297 297
         $this->assertEquals($expectedResult, $result, null, 1E-8);
298 298
     }
299 299
 
@@ -309,7 +309,7 @@  discard block
 block discarded – undo
309 309
     {
310 310
         $args = func_get_args();
311 311
         $expectedResult = array_pop($args);
312
-        $result = call_user_func_array(array(Financial::class,'FV'), $args);
312
+        $result = call_user_func_array(array(Financial::class, 'FV'), $args);
313 313
         $this->assertEquals($expectedResult, $result, null, 1E-8);
314 314
     }
315 315
 
@@ -325,7 +325,7 @@  discard block
 block discarded – undo
325 325
     {
326 326
         $args = func_get_args();
327 327
         $expectedResult = array_pop($args);
328
-        $result = call_user_func_array(array(Financial::class,'FVSCHEDULE'), $args);
328
+        $result = call_user_func_array(array(Financial::class, 'FVSCHEDULE'), $args);
329 329
         $this->assertEquals($expectedResult, $result, null, 1E-8);
330 330
     }
331 331
 
@@ -341,7 +341,7 @@  discard block
 block discarded – undo
341 341
     {
342 342
         $args = func_get_args();
343 343
         $expectedResult = array_pop($args);
344
-        $result = call_user_func_array(array(Financial::class,'INTRATE'), $args);
344
+        $result = call_user_func_array(array(Financial::class, 'INTRATE'), $args);
345 345
         $this->assertEquals($expectedResult, $result, null, 1E-8);
346 346
     }
347 347
 
@@ -357,7 +357,7 @@  discard block
 block discarded – undo
357 357
     {
358 358
         $args = func_get_args();
359 359
         $expectedResult = array_pop($args);
360
-        $result = call_user_func_array(array(Financial::class,'IPMT'), $args);
360
+        $result = call_user_func_array(array(Financial::class, 'IPMT'), $args);
361 361
         $this->assertEquals($expectedResult, $result, null, 1E-8);
362 362
     }
363 363
 
@@ -373,7 +373,7 @@  discard block
 block discarded – undo
373 373
     {
374 374
         $args = func_get_args();
375 375
         $expectedResult = array_pop($args);
376
-        $result = call_user_func_array(array(Financial::class,'IRR'), $args);
376
+        $result = call_user_func_array(array(Financial::class, 'IRR'), $args);
377 377
         $this->assertEquals($expectedResult, $result, null, 1E-8);
378 378
     }
379 379
 
@@ -389,7 +389,7 @@  discard block
 block discarded – undo
389 389
     {
390 390
         $args = func_get_args();
391 391
         $expectedResult = array_pop($args);
392
-        $result = call_user_func_array(array(Financial::class,'ISPMT'), $args);
392
+        $result = call_user_func_array(array(Financial::class, 'ISPMT'), $args);
393 393
         $this->assertEquals($expectedResult, $result, null, 1E-8);
394 394
     }
395 395
 
@@ -405,7 +405,7 @@  discard block
 block discarded – undo
405 405
     {
406 406
         $args = func_get_args();
407 407
         $expectedResult = array_pop($args);
408
-        $result = call_user_func_array(array(Financial::class,'MIRR'), $args);
408
+        $result = call_user_func_array(array(Financial::class, 'MIRR'), $args);
409 409
         $this->assertEquals($expectedResult, $result, null, 1E-8);
410 410
     }
411 411
 
@@ -421,7 +421,7 @@  discard block
 block discarded – undo
421 421
     {
422 422
         $args = func_get_args();
423 423
         $expectedResult = array_pop($args);
424
-        $result = call_user_func_array(array(Financial::class,'NOMINAL'), $args);
424
+        $result = call_user_func_array(array(Financial::class, 'NOMINAL'), $args);
425 425
         $this->assertEquals($expectedResult, $result, null, 1E-8);
426 426
     }
427 427
 
@@ -437,7 +437,7 @@  discard block
 block discarded – undo
437 437
     {
438 438
         $args = func_get_args();
439 439
         $expectedResult = array_pop($args);
440
-        $result = call_user_func_array(array(Financial::class,'NPER'), $args);
440
+        $result = call_user_func_array(array(Financial::class, 'NPER'), $args);
441 441
         $this->assertEquals($expectedResult, $result, null, 1E-8);
442 442
     }
443 443
 
@@ -453,7 +453,7 @@  discard block
 block discarded – undo
453 453
     {
454 454
         $args = func_get_args();
455 455
         $expectedResult = array_pop($args);
456
-        $result = call_user_func_array(array(Financial::class,'NPV'), $args);
456
+        $result = call_user_func_array(array(Financial::class, 'NPV'), $args);
457 457
         $this->assertEquals($expectedResult, $result, null, 1E-8);
458 458
     }
459 459
 
@@ -472,7 +472,7 @@  discard block
 block discarded – undo
472 472
 
473 473
         $args = func_get_args();
474 474
         $expectedResult = array_pop($args);
475
-        $result = call_user_func_array(array(Financial::class,'PRICE'), $args);
475
+        $result = call_user_func_array(array(Financial::class, 'PRICE'), $args);
476 476
         $this->assertEquals($expectedResult, $result, null, 1E-8);
477 477
     }
478 478
 
@@ -491,7 +491,7 @@  discard block
 block discarded – undo
491 491
 
492 492
         $args = func_get_args();
493 493
         $expectedResult = array_pop($args);
494
-        $result = call_user_func_array(array(Financial::class,'RATE'), $args);
494
+        $result = call_user_func_array(array(Financial::class, 'RATE'), $args);
495 495
         $this->assertEquals($expectedResult, $result, null, 1E-8);
496 496
     }
497 497
 
@@ -510,7 +510,7 @@  discard block
 block discarded – undo
510 510
 
511 511
         $args = func_get_args();
512 512
         $expectedResult = array_pop($args);
513
-        $result = call_user_func_array(array(Financial::class,'XIRR'), $args);
513
+        $result = call_user_func_array(array(Financial::class, 'XIRR'), $args);
514 514
         $this->assertEquals($expectedResult, $result, null, 1E-8);
515 515
     }
516 516
 
Please login to merge, or discard this patch.