Completed
Push — develop ( 942ad7...b0621f )
by Adrien
22:01 queued 09:22
created
Examples/15datavalidation-xls.php 1 patch
Indentation   +18 added lines, -18 removed lines patch added patch discarded remove patch
@@ -47,30 +47,30 @@
 block discarded – undo
47 47
 // Set document properties
48 48
 echo date('H:i:s') , " Set document properties" , EOL;
49 49
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
50
-							 ->setLastModifiedBy("Maarten Balliauw")
51
-							 ->setTitle("Office 2007 XLSX Test Document")
52
-							 ->setSubject("Office 2007 XLSX Test Document")
53
-							 ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
54
-							 ->setKeywords("office 2007 openxml php")
55
-							 ->setCategory("Test result file");
50
+                                ->setLastModifiedBy("Maarten Balliauw")
51
+                                ->setTitle("Office 2007 XLSX Test Document")
52
+                                ->setSubject("Office 2007 XLSX Test Document")
53
+                                ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
54
+                                ->setKeywords("office 2007 openxml php")
55
+                                ->setCategory("Test result file");
56 56
 
57 57
 
58 58
 // Create a first sheet
59 59
 echo date('H:i:s') , " Add data" , EOL;
60 60
 $objPHPExcel->setActiveSheetIndex(0);
61 61
 $objPHPExcel->getActiveSheet()->setCellValue('A1', "Cell B3 and B5 contain data validation...")
62
-                              ->setCellValue('A3', "Number:")
63
-                              ->setCellValue('B3', "10")
64
-                              ->setCellValue('A5', "List:")
65
-                              ->setCellValue('B5', "Item A")
66
-                              ->setCellValue('A7', "List #2:")
67
-                              ->setCellValue('B7', "Item #2")
68
-                              ->setCellValue('D2', "Item #1")
69
-                              ->setCellValue('D3', "Item #2")
70
-                              ->setCellValue('D4', "Item #3")
71
-                              ->setCellValue('D5', "Item #4")
72
-                              ->setCellValue('D6', "Item #5")
73
-                              ;
62
+                                ->setCellValue('A3', "Number:")
63
+                                ->setCellValue('B3', "10")
64
+                                ->setCellValue('A5', "List:")
65
+                                ->setCellValue('B5', "Item A")
66
+                                ->setCellValue('A7', "List #2:")
67
+                                ->setCellValue('B7', "Item #2")
68
+                                ->setCellValue('D2', "Item #1")
69
+                                ->setCellValue('D3', "Item #2")
70
+                                ->setCellValue('D4', "Item #3")
71
+                                ->setCellValue('D5', "Item #4")
72
+                                ->setCellValue('D6', "Item #5")
73
+                                ;
74 74
 
75 75
 
76 76
 // Set data validation
Please login to merge, or discard this patch.
Examples/06largescale-with-cellcaching-sqlite3.php 1 patch
Indentation   +13 added lines, -13 removed lines patch added patch discarded remove patch
@@ -52,12 +52,12 @@  discard block
 block discarded – undo
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.
Examples/01pharSimple.php 1 patch
Indentation   +6 added lines, -6 removed lines patch added patch discarded remove patch
@@ -44,12 +44,12 @@
 block discarded – undo
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.
Examples/06largescale.php 1 patch
Indentation   +13 added lines, -13 removed lines patch added patch discarded remove patch
@@ -52,12 +52,12 @@  discard block
 block discarded – undo
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.
Examples/38cloneWorksheet.php 1 patch
Indentation   +6 added lines, -6 removed lines patch added patch discarded remove patch
@@ -44,12 +44,12 @@
 block discarded – undo
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.
Examples/33chartcreate-radar.php 1 patch
Indentation   +37 added lines, -37 removed lines patch added patch discarded remove patch
@@ -43,21 +43,21 @@  discard block
 block discarded – undo
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.
tests/PhpSpreadsheet/Worksheet/WorksheetColumnTest.php 1 patch
Indentation   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -13,8 +13,8 @@
 block discarded – undo
13 13
             ->disableOriginalConstructor()
14 14
             ->getMock();
15 15
         $this->mockWorksheet->expects($this->any())
16
-                 ->method('getHighestRow')
17
-                 ->will($this->returnValue(5));
16
+                    ->method('getHighestRow')
17
+                    ->will($this->returnValue(5));
18 18
     }
19 19
 
20 20
 
Please login to merge, or discard this patch.
tests/PhpSpreadsheet/Worksheet/ColumnIteratorTest.php 1 patch
Indentation   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -18,11 +18,11 @@
 block discarded – undo
18 18
             ->getMock();
19 19
 
20 20
         $this->mockWorksheet->expects($this->any())
21
-                 ->method('getHighestColumn')
22
-                 ->will($this->returnValue('E'));
21
+                    ->method('getHighestColumn')
22
+                    ->will($this->returnValue('E'));
23 23
         $this->mockWorksheet->expects($this->any())
24
-                 ->method('current')
25
-                 ->will($this->returnValue($this->mockColumn));
24
+                    ->method('current')
25
+                    ->will($this->returnValue($this->mockColumn));
26 26
     }
27 27
 
28 28
 
Please login to merge, or discard this patch.
tests/PhpSpreadsheet/Worksheet/ColumnCellIteratorTest.php 1 patch
Indentation   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -18,11 +18,11 @@
 block discarded – undo
18 18
             ->getMock();
19 19
 
20 20
         $this->mockWorksheet->expects($this->any())
21
-                 ->method('getHighestRow')
22
-                 ->will($this->returnValue(5));
21
+                    ->method('getHighestRow')
22
+                    ->will($this->returnValue(5));
23 23
         $this->mockWorksheet->expects($this->any())
24
-                 ->method('getCellByColumnAndRow')
25
-                 ->will($this->returnValue($this->mockCell));
24
+                    ->method('getCellByColumnAndRow')
25
+                    ->will($this->returnValue($this->mockCell));
26 26
     }
27 27
 
28 28
 
Please login to merge, or discard this patch.