Inspection of "A few more manual code style fixes for phpcs" - PHPOffice/PhpSpreadsheet - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — develop ( 8c66af...af82e2 )

by Adrien

created 2016-12-22 15:10 UTC

Status

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

@@ -31,7 +31,7 @@  discard block
 block discarded – undo
 
 // Add some data
 $testDates = ['3:15',    '13:15',    '15:15:15',    '3:15 AM',    '3:15 PM',    '5PM',    '9:15AM',    '13:15AM',
-                  ];
+                    ];
 $testDateCount = count($testDates);
 
 for ($row = 1; $row <= $testDateCount; ++$row) {
@@ -41,8 +41,8 @@  discard block
 block discarded – undo
 }
 
 $worksheet->getStyle('C1:C' . $testDateCount)
-          ->getNumberFormat()
-          ->setFormatCode('hh:mm:ss');
+            ->getNumberFormat()
+            ->setFormatCode('hh:mm:ss');
 
 echo '<hr />';
 

Please login to merge, or discard this patch.

Spacing +5 added lines, -5 removed lines patch added patch discarded remove patch

@@ -30,7 +30,7 @@  discard block
 block discarded – undo
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$testDates = ['3:15',    '13:15',    '15:15:15',    '3:15 AM',    '3:15 PM',    '5PM',    '9:15AM',    '13:15AM',
+$testDates = ['3:15', '13:15', '15:15:15', '3:15 AM', '3:15 PM', '5PM', '9:15AM', '13:15AM',
                   ];
 $testDateCount = count($testDates);
 
@@ -58,10 +58,10 @@  discard block
 block discarded – undo
 	<?php
     for ($row = 1; $row <= $testDateCount; ++$row) {
         echo '<tr>';
-        echo '<td>' , $worksheet->getCell('A' . $row)->getFormattedValue() , '</td>';
-        echo '<td>' , $worksheet->getCell('B' . $row)->getValue() , '</td>';
-        echo '<td>' , $worksheet->getCell('B' . $row)->getFormattedValue() , '</td>';
-        echo '<td>' , $worksheet->getCell('C' . $row)->getFormattedValue() , '</td>';
+        echo '<td>', $worksheet->getCell('A' . $row)->getFormattedValue(), '</td>';
+        echo '<td>', $worksheet->getCell('B' . $row)->getValue(), '</td>';
+        echo '<td>', $worksheet->getCell('B' . $row)->getFormattedValue(), '</td>';
+        echo '<td>', $worksheet->getCell('C' . $row)->getFormattedValue(), '</td>';
         echo '</tr>';
     }
     ?>

Please login to merge, or discard this patch.

docs/Examples/Calculations/DateTime/DATE.php 2 patches

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

@@ -35,7 +35,7 @@  discard block
 block discarded – undo
                     [2011, 2, 29],    [7, 5, 3],        [2012, 13, 1],    [2012, 11, 45],
                     [2012, 0, 0],    [2012, 1, 0],    [2012, 0, 1],
                     [2012, -2, 2],    [2012, 2, -2],    [2012, -2, -2],
-                  ];
+                    ];
 $testDateCount = count($testDates);
 
 $worksheet->fromArray($testDates, null, 'A1', true);
@@ -45,8 +45,8 @@  discard block
 block discarded – undo
     $worksheet->setCellValue('E' . $row, '=D' . $row);
 }
 $worksheet->getStyle('E1:E' . $testDateCount)
-          ->getNumberFormat()
-          ->setFormatCode('yyyy-mmm-dd');
+            ->getNumberFormat()
+            ->setFormatCode('yyyy-mmm-dd');
 
 echo '<hr />';
 

Please login to merge, or discard this patch.

Spacing +11 added lines, -11 removed lines patch added patch discarded remove patch

		@@ -30,11 +30,11 @@ discard block
		block discarded – undo
30	30	$worksheet = $objPHPExcel->getActiveSheet();
31	31
32	32	// Add some data
33		-$testDates = [[2012, 3, 26], [2012, 2, 29], [2012, 4, 1], [2012, 12, 25],
34		- [2012, 10, 31], [2012, 11, 5], [2012, 1, 1], [2012, 3, 17],
35		- [2011, 2, 29], [7, 5, 3], [2012, 13, 1], [2012, 11, 45],
36		- [2012, 0, 0], [2012, 1, 0], [2012, 0, 1],
37		- [2012, -2, 2], [2012, 2, -2], [2012, -2, -2],
	33	+$testDates = [[2012, 3, 26], [2012, 2, 29], [2012, 4, 1], [2012, 12, 25],
	34	+ [2012, 10, 31], [2012, 11, 5], [2012, 1, 1], [2012, 3, 17],
	35	+ [2011, 2, 29], [7, 5, 3], [2012, 13, 1], [2012, 11, 45],
	36	+ [2012, 0, 0], [2012, 1, 0], [2012, 0, 1],
	37	+ [2012, -2, 2], [2012, 2, -2], [2012, -2, -2],
38	38	];
39	39	$testDateCount = count($testDates);
40	40
		@@ -67,12 +67,12 @@ discard block
		block discarded – undo
67	67	<?php
68	68	for ($row = 1; $row <= $testDateCount; ++$row) {
69	69	echo '<tr>';
70		- echo '<td>' , $worksheet->getCell('A' . $row)->getFormattedValue() , '</td>';
71		- echo '<td>' , $worksheet->getCell('B' . $row)->getFormattedValue() , '</td>';
72		- echo '<td>' , $worksheet->getCell('C' . $row)->getFormattedValue() , '</td>';
73		- echo '<td>' , $worksheet->getCell('D' . $row)->getValue() , '</td>';
74		- echo '<td>' , $worksheet->getCell('D' . $row)->getFormattedValue() , '</td>';
75		- echo '<td>' , $worksheet->getCell('E' . $row)->getFormattedValue() , '</td>';
	70	+ echo '<td>', $worksheet->getCell('A' . $row)->getFormattedValue(), '</td>';
	71	+ echo '<td>', $worksheet->getCell('B' . $row)->getFormattedValue(), '</td>';
	72	+ echo '<td>', $worksheet->getCell('C' . $row)->getFormattedValue(), '</td>';
	73	+ echo '<td>', $worksheet->getCell('D' . $row)->getValue(), '</td>';
	74	+ echo '<td>', $worksheet->getCell('D' . $row)->getFormattedValue(), '</td>';
	75	+ echo '<td>', $worksheet->getCell('E' . $row)->getFormattedValue(), '</td>';
76	76	echo '</tr>';
77	77	}
78	78	?>

Please login to merge, or discard this patch.

docs/Examples/Calculations/Database/DSTDEVP.php 2 patches

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

		@@ -31,17 +31,17 @@
		block discarded – undo
31	31
32	32	// Add some data
33	33	$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
34		- ['Apple', 18, 20, 14, 105.00],
35		- ['Pear', 12, 12, 10, 96.00],
36		- ['Cherry', 13, 14, 9, 105.00],
37		- ['Apple', 14, 15, 10, 75.00],
38		- ['Pear', 9, 8, 8, 76.80],
39		- ['Apple', 8, 9, 6, 45.00],
40		- ];
	34	+ ['Apple', 18, 20, 14, 105.00],
	35	+ ['Pear', 12, 12, 10, 96.00],
	36	+ ['Cherry', 13, 14, 9, 105.00],
	37	+ ['Apple', 14, 15, 10, 75.00],
	38	+ ['Pear', 9, 8, 8, 76.80],
	39	+ ['Apple', 8, 9, 6, 45.00],
	40	+ ];
41	41	$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42		- ['="=Apple"', '>10', null, null, null, '<16'],
43		- ['="=Pear"', null, null, null, null, null],
44		- ];
	42	+ ['="=Apple"', '>10', null, null, null, '<16'],
	43	+ ['="=Pear"', null, null, null, null, null],
	44	+ ];
45	45
46	46	$worksheet->fromArray($criteria, null, 'A1');
47	47	$worksheet->fromArray($database, null, 'A4');

Please login to merge, or discard this patch.

Spacing +10 added lines, -10 removed lines patch added patch discarded remove patch

		@@ -30,17 +30,17 @@
		block discarded – undo
30	30	$worksheet = $objPHPExcel->getActiveSheet();
31	31
32	32	// Add some data
33		-$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
34		- ['Apple', 18, 20, 14, 105.00],
35		- ['Pear', 12, 12, 10, 96.00],
36		- ['Cherry', 13, 14, 9, 105.00],
37		- ['Apple', 14, 15, 10, 75.00],
38		- ['Pear', 9, 8, 8, 76.80],
39		- ['Apple', 8, 9, 6, 45.00],
	33	+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
	34	+ ['Apple', 18, 20, 14, 105.00],
	35	+ ['Pear', 12, 12, 10, 96.00],
	36	+ ['Cherry', 13, 14, 9, 105.00],
	37	+ ['Apple', 14, 15, 10, 75.00],
	38	+ ['Pear', 9, 8, 8, 76.80],
	39	+ ['Apple', 8, 9, 6, 45.00],
40	40	];
41		-$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42		- ['="=Apple"', '>10', null, null, null, '<16'],
43		- ['="=Pear"', null, null, null, null, null],
	41	+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
	42	+ ['="=Apple"', '>10', null, null, null, '<16'],
	43	+ ['="=Pear"', null, null, null, null, null],
44	44	];
45	45
46	46	$worksheet->fromArray($criteria, null, 'A1');

Please login to merge, or discard this patch.

docs/Examples/Calculations/Database/DGET.php 2 patches

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

		@@ -31,17 +31,17 @@
		block discarded – undo
31	31
32	32	// Add some data
33	33	$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
34		- ['Apple', 18, 20, 14, 105.00],
35		- ['Pear', 12, 12, 10, 96.00],
36		- ['Cherry', 13, 14, 9, 105.00],
37		- ['Apple', 14, 15, 10, 75.00],
38		- ['Pear', 9, 8, 8, 76.80],
39		- ['Apple', 8, 9, 6, 45.00],
40		- ];
	34	+ ['Apple', 18, 20, 14, 105.00],
	35	+ ['Pear', 12, 12, 10, 96.00],
	36	+ ['Cherry', 13, 14, 9, 105.00],
	37	+ ['Apple', 14, 15, 10, 75.00],
	38	+ ['Pear', 9, 8, 8, 76.80],
	39	+ ['Apple', 8, 9, 6, 45.00],
	40	+ ];
41	41	$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42		- ['="=Apple"', '>10', null, null, null, '<16'],
43		- ['="=Pear"', null, null, null, null, null],
44		- ];
	42	+ ['="=Apple"', '>10', null, null, null, '<16'],
	43	+ ['="=Pear"', null, null, null, null, null],
	44	+ ];
45	45
46	46	$worksheet->fromArray($criteria, null, 'A1');
47	47	$worksheet->fromArray($database, null, 'A4');

Please login to merge, or discard this patch.

Spacing +10 added lines, -10 removed lines patch added patch discarded remove patch

		@@ -30,17 +30,17 @@
		block discarded – undo
30	30	$worksheet = $objPHPExcel->getActiveSheet();
31	31
32	32	// Add some data
33		-$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
34		- ['Apple', 18, 20, 14, 105.00],
35		- ['Pear', 12, 12, 10, 96.00],
36		- ['Cherry', 13, 14, 9, 105.00],
37		- ['Apple', 14, 15, 10, 75.00],
38		- ['Pear', 9, 8, 8, 76.80],
39		- ['Apple', 8, 9, 6, 45.00],
	33	+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
	34	+ ['Apple', 18, 20, 14, 105.00],
	35	+ ['Pear', 12, 12, 10, 96.00],
	36	+ ['Cherry', 13, 14, 9, 105.00],
	37	+ ['Apple', 14, 15, 10, 75.00],
	38	+ ['Pear', 9, 8, 8, 76.80],
	39	+ ['Apple', 8, 9, 6, 45.00],
40	40	];
41		-$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42		- ['="=Apple"', '>10', null, null, null, '<16'],
43		- ['="=Pear"', null, null, null, null, null],
	41	+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
	42	+ ['="=Apple"', '>10', null, null, null, '<16'],
	43	+ ['="=Pear"', null, null, null, null, null],
44	44	];
45	45
46	46	$worksheet->fromArray($criteria, null, 'A1');

Please login to merge, or discard this patch.

docs/Examples/Calculations/Database/DMIN.php 2 patches

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

		@@ -31,17 +31,17 @@
		block discarded – undo
31	31
32	32	// Add some data
33	33	$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
34		- ['Apple', 18, 20, 14, 105.00],
35		- ['Pear', 12, 12, 10, 96.00],
36		- ['Cherry', 13, 14, 9, 105.00],
37		- ['Apple', 14, 15, 10, 75.00],
38		- ['Pear', 9, 8, 8, 76.80],
39		- ['Apple', 8, 9, 6, 45.00],
40		- ];
	34	+ ['Apple', 18, 20, 14, 105.00],
	35	+ ['Pear', 12, 12, 10, 96.00],
	36	+ ['Cherry', 13, 14, 9, 105.00],
	37	+ ['Apple', 14, 15, 10, 75.00],
	38	+ ['Pear', 9, 8, 8, 76.80],
	39	+ ['Apple', 8, 9, 6, 45.00],
	40	+ ];
41	41	$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42		- ['="=Apple"', '>10', null, null, null, '<16'],
43		- ['="=Pear"', null, null, null, null, null],
44		- ];
	42	+ ['="=Apple"', '>10', null, null, null, '<16'],
	43	+ ['="=Pear"', null, null, null, null, null],
	44	+ ];
45	45
46	46	$worksheet->fromArray($criteria, null, 'A1');
47	47	$worksheet->fromArray($database, null, 'A4');

Please login to merge, or discard this patch.

Spacing +10 added lines, -10 removed lines patch added patch discarded remove patch

		@@ -30,17 +30,17 @@
		block discarded – undo
30	30	$worksheet = $objPHPExcel->getActiveSheet();
31	31
32	32	// Add some data
33		-$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
34		- ['Apple', 18, 20, 14, 105.00],
35		- ['Pear', 12, 12, 10, 96.00],
36		- ['Cherry', 13, 14, 9, 105.00],
37		- ['Apple', 14, 15, 10, 75.00],
38		- ['Pear', 9, 8, 8, 76.80],
39		- ['Apple', 8, 9, 6, 45.00],
	33	+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
	34	+ ['Apple', 18, 20, 14, 105.00],
	35	+ ['Pear', 12, 12, 10, 96.00],
	36	+ ['Cherry', 13, 14, 9, 105.00],
	37	+ ['Apple', 14, 15, 10, 75.00],
	38	+ ['Pear', 9, 8, 8, 76.80],
	39	+ ['Apple', 8, 9, 6, 45.00],
40	40	];
41		-$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42		- ['="=Apple"', '>10', null, null, null, '<16'],
43		- ['="=Pear"', null, null, null, null, null],
	41	+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
	42	+ ['="=Apple"', '>10', null, null, null, '<16'],
	43	+ ['="=Pear"', null, null, null, null, null],
44	44	];
45	45
46	46	$worksheet->fromArray($criteria, null, 'A1');

Please login to merge, or discard this patch.

docs/Examples/Calculations/Database/DVARP.php 2 patches

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

		@@ -31,17 +31,17 @@
		block discarded – undo
31	31
32	32	// Add some data
33	33	$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
34		- ['Apple', 18, 20, 14, 105.00],
35		- ['Pear', 12, 12, 10, 96.00],
36		- ['Cherry', 13, 14, 9, 105.00],
37		- ['Apple', 14, 15, 10, 75.00],
38		- ['Pear', 9, 8, 8, 76.80],
39		- ['Apple', 8, 9, 6, 45.00],
40		- ];
	34	+ ['Apple', 18, 20, 14, 105.00],
	35	+ ['Pear', 12, 12, 10, 96.00],
	36	+ ['Cherry', 13, 14, 9, 105.00],
	37	+ ['Apple', 14, 15, 10, 75.00],
	38	+ ['Pear', 9, 8, 8, 76.80],
	39	+ ['Apple', 8, 9, 6, 45.00],
	40	+ ];
41	41	$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42		- ['="=Apple"', '>10', null, null, null, '<16'],
43		- ['="=Pear"', null, null, null, null, null],
44		- ];
	42	+ ['="=Apple"', '>10', null, null, null, '<16'],
	43	+ ['="=Pear"', null, null, null, null, null],
	44	+ ];
45	45
46	46	$worksheet->fromArray($criteria, null, 'A1');
47	47	$worksheet->fromArray($database, null, 'A4');

Please login to merge, or discard this patch.

Spacing +10 added lines, -10 removed lines patch added patch discarded remove patch

		@@ -30,17 +30,17 @@
		block discarded – undo
30	30	$worksheet = $objPHPExcel->getActiveSheet();
31	31
32	32	// Add some data
33		-$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
34		- ['Apple', 18, 20, 14, 105.00],
35		- ['Pear', 12, 12, 10, 96.00],
36		- ['Cherry', 13, 14, 9, 105.00],
37		- ['Apple', 14, 15, 10, 75.00],
38		- ['Pear', 9, 8, 8, 76.80],
39		- ['Apple', 8, 9, 6, 45.00],
	33	+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
	34	+ ['Apple', 18, 20, 14, 105.00],
	35	+ ['Pear', 12, 12, 10, 96.00],
	36	+ ['Cherry', 13, 14, 9, 105.00],
	37	+ ['Apple', 14, 15, 10, 75.00],
	38	+ ['Pear', 9, 8, 8, 76.80],
	39	+ ['Apple', 8, 9, 6, 45.00],
40	40	];
41		-$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42		- ['="=Apple"', '>10', null, null, null, '<16'],
43		- ['="=Pear"', null, null, null, null, null],
	41	+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
	42	+ ['="=Apple"', '>10', null, null, null, '<16'],
	43	+ ['="=Pear"', null, null, null, null, null],
44	44	];
45	45
46	46	$worksheet->fromArray($criteria, null, 'A1');

Please login to merge, or discard this patch.

docs/Examples/Calculations/Database/DPRODUCT.php 2 patches

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

		@@ -31,17 +31,17 @@
		block discarded – undo
31	31
32	32	// Add some data
33	33	$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
34		- ['Apple', 18, 20, 14, 105.00],
35		- ['Pear', 12, 12, 10, 96.00],
36		- ['Cherry', 13, 14, 9, 105.00],
37		- ['Apple', 14, 15, 10, 75.00],
38		- ['Pear', 9, 8, 8, 76.80],
39		- ['Apple', 8, 9, 6, 45.00],
40		- ];
	34	+ ['Apple', 18, 20, 14, 105.00],
	35	+ ['Pear', 12, 12, 10, 96.00],
	36	+ ['Cherry', 13, 14, 9, 105.00],
	37	+ ['Apple', 14, 15, 10, 75.00],
	38	+ ['Pear', 9, 8, 8, 76.80],
	39	+ ['Apple', 8, 9, 6, 45.00],
	40	+ ];
41	41	$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42		- ['="=Apple"', '>10', null, null, null, '<16'],
43		- ['="=Pear"', null, null, null, null, null],
44		- ];
	42	+ ['="=Apple"', '>10', null, null, null, '<16'],
	43	+ ['="=Pear"', null, null, null, null, null],
	44	+ ];
45	45
46	46	$worksheet->fromArray($criteria, null, 'A1');
47	47	$worksheet->fromArray($database, null, 'A4');

Please login to merge, or discard this patch.

Spacing +10 added lines, -10 removed lines patch added patch discarded remove patch

		@@ -30,17 +30,17 @@
		block discarded – undo
30	30	$worksheet = $objPHPExcel->getActiveSheet();
31	31
32	32	// Add some data
33		-$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
34		- ['Apple', 18, 20, 14, 105.00],
35		- ['Pear', 12, 12, 10, 96.00],
36		- ['Cherry', 13, 14, 9, 105.00],
37		- ['Apple', 14, 15, 10, 75.00],
38		- ['Pear', 9, 8, 8, 76.80],
39		- ['Apple', 8, 9, 6, 45.00],
	33	+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
	34	+ ['Apple', 18, 20, 14, 105.00],
	35	+ ['Pear', 12, 12, 10, 96.00],
	36	+ ['Cherry', 13, 14, 9, 105.00],
	37	+ ['Apple', 14, 15, 10, 75.00],
	38	+ ['Pear', 9, 8, 8, 76.80],
	39	+ ['Apple', 8, 9, 6, 45.00],
40	40	];
41		-$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42		- ['="=Apple"', '>10', null, null, null, '<16'],
43		- ['="=Pear"', null, null, null, null, null],
	41	+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
	42	+ ['="=Apple"', '>10', null, null, null, '<16'],
	43	+ ['="=Pear"', null, null, null, null, null],
44	44	];
45	45
46	46	$worksheet->fromArray($criteria, null, 'A1');

Please login to merge, or discard this patch.

docs/Examples/Calculations/Database/DAVERAGE.php 2 patches

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

		@@ -31,17 +31,17 @@
		block discarded – undo
31	31
32	32	// Add some data
33	33	$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
34		- ['Apple', 18, 20, 14, 105.00],
35		- ['Pear', 12, 12, 10, 96.00],
36		- ['Cherry', 13, 14, 9, 105.00],
37		- ['Apple', 14, 15, 10, 75.00],
38		- ['Pear', 9, 8, 8, 76.80],
39		- ['Apple', 8, 9, 6, 45.00],
40		- ];
	34	+ ['Apple', 18, 20, 14, 105.00],
	35	+ ['Pear', 12, 12, 10, 96.00],
	36	+ ['Cherry', 13, 14, 9, 105.00],
	37	+ ['Apple', 14, 15, 10, 75.00],
	38	+ ['Pear', 9, 8, 8, 76.80],
	39	+ ['Apple', 8, 9, 6, 45.00],
	40	+ ];
41	41	$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42		- ['="=Apple"', '>10', null, null, null, '<16'],
43		- ['="=Pear"', null, null, null, null, null],
44		- ];
	42	+ ['="=Apple"', '>10', null, null, null, '<16'],
	43	+ ['="=Pear"', null, null, null, null, null],
	44	+ ];
45	45
46	46	$worksheet->fromArray($criteria, null, 'A1');
47	47	$worksheet->fromArray($database, null, 'A4');

Please login to merge, or discard this patch.

Spacing +10 added lines, -10 removed lines patch added patch discarded remove patch

		@@ -30,17 +30,17 @@
		block discarded – undo
30	30	$worksheet = $objPHPExcel->getActiveSheet();
31	31
32	32	// Add some data
33		-$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
34		- ['Apple', 18, 20, 14, 105.00],
35		- ['Pear', 12, 12, 10, 96.00],
36		- ['Cherry', 13, 14, 9, 105.00],
37		- ['Apple', 14, 15, 10, 75.00],
38		- ['Pear', 9, 8, 8, 76.80],
39		- ['Apple', 8, 9, 6, 45.00],
	33	+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
	34	+ ['Apple', 18, 20, 14, 105.00],
	35	+ ['Pear', 12, 12, 10, 96.00],
	36	+ ['Cherry', 13, 14, 9, 105.00],
	37	+ ['Apple', 14, 15, 10, 75.00],
	38	+ ['Pear', 9, 8, 8, 76.80],
	39	+ ['Apple', 8, 9, 6, 45.00],
40	40	];
41		-$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42		- ['="=Apple"', '>10', null, null, null, '<16'],
43		- ['="=Pear"', null, null, null, null, null],
	41	+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
	42	+ ['="=Apple"', '>10', null, null, null, '<16'],
	43	+ ['="=Pear"', null, null, null, null, null],
44	44	];
45	45
46	46	$worksheet->fromArray($criteria, null, 'A1');

Please login to merge, or discard this patch.

docs/Examples/Calculations/Database/DSTDEV.php 2 patches

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

		@@ -31,17 +31,17 @@
		block discarded – undo
31	31
32	32	// Add some data
33	33	$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
34		- ['Apple', 18, 20, 14, 105.00],
35		- ['Pear', 12, 12, 10, 96.00],
36		- ['Cherry', 13, 14, 9, 105.00],
37		- ['Apple', 14, 15, 10, 75.00],
38		- ['Pear', 9, 8, 8, 76.80],
39		- ['Apple', 8, 9, 6, 45.00],
40		- ];
	34	+ ['Apple', 18, 20, 14, 105.00],
	35	+ ['Pear', 12, 12, 10, 96.00],
	36	+ ['Cherry', 13, 14, 9, 105.00],
	37	+ ['Apple', 14, 15, 10, 75.00],
	38	+ ['Pear', 9, 8, 8, 76.80],
	39	+ ['Apple', 8, 9, 6, 45.00],
	40	+ ];
41	41	$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42		- ['="=Apple"', '>10', null, null, null, '<16'],
43		- ['="=Pear"', null, null, null, null, null],
44		- ];
	42	+ ['="=Apple"', '>10', null, null, null, '<16'],
	43	+ ['="=Pear"', null, null, null, null, null],
	44	+ ];
45	45
46	46	$worksheet->fromArray($criteria, null, 'A1');
47	47	$worksheet->fromArray($database, null, 'A4');

Please login to merge, or discard this patch.

Spacing +10 added lines, -10 removed lines patch added patch discarded remove patch

		@@ -30,17 +30,17 @@
		block discarded – undo
30	30	$worksheet = $objPHPExcel->getActiveSheet();
31	31
32	32	// Add some data
33		-$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
34		- ['Apple', 18, 20, 14, 105.00],
35		- ['Pear', 12, 12, 10, 96.00],
36		- ['Cherry', 13, 14, 9, 105.00],
37		- ['Apple', 14, 15, 10, 75.00],
38		- ['Pear', 9, 8, 8, 76.80],
39		- ['Apple', 8, 9, 6, 45.00],
	33	+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
	34	+ ['Apple', 18, 20, 14, 105.00],
	35	+ ['Pear', 12, 12, 10, 96.00],
	36	+ ['Cherry', 13, 14, 9, 105.00],
	37	+ ['Apple', 14, 15, 10, 75.00],
	38	+ ['Pear', 9, 8, 8, 76.80],
	39	+ ['Apple', 8, 9, 6, 45.00],
40	40	];
41		-$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42		- ['="=Apple"', '>10', null, null, null, '<16'],
43		- ['="=Pear"', null, null, null, null, null],
	41	+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
	42	+ ['="=Apple"', '>10', null, null, null, '<16'],
	43	+ ['="=Pear"', null, null, null, null, null],
44	44	];
45	45
46	46	$worksheet->fromArray($criteria, null, 'A1');

Please login to merge, or discard this patch.

		@@ -31,7 +31,7 @@ discard block
		block discarded – undo
31	31
32	32	// Add some data
33	33	$testDates = ['3:15', '13:15', '15:15:15', '3:15 AM', '3:15 PM', '5PM', '9:15AM', '13:15AM',
34		- ];
	34	+ ];
35	35	$testDateCount = count($testDates);
36	36
37	37	for ($row = 1; $row <= $testDateCount; ++$row) {
		@@ -41,8 +41,8 @@ discard block
		block discarded – undo
41	41	}
42	42
43	43	$worksheet->getStyle('C1:C' . $testDateCount)
44		- ->getNumberFormat()
45		- ->setFormatCode('hh:mm:ss');
	44	+ ->getNumberFormat()
	45	+ ->setFormatCode('hh:mm:ss');
46	46
47	47	echo '<hr />';
48	48

		@@ -30,7 +30,7 @@ discard block
		block discarded – undo
30	30	$worksheet = $objPHPExcel->getActiveSheet();
31	31
32	32	// Add some data
33		-$testDates = ['3:15', '13:15', '15:15:15', '3:15 AM', '3:15 PM', '5PM', '9:15AM', '13:15AM',
	33	+$testDates = ['3:15', '13:15', '15:15:15', '3:15 AM', '3:15 PM', '5PM', '9:15AM', '13:15AM',
34	34	];
35	35	$testDateCount = count($testDates);
36	36
		@@ -58,10 +58,10 @@ discard block
		block discarded – undo
58	58	<?php
59	59	for ($row = 1; $row <= $testDateCount; ++$row) {
60	60	echo '<tr>';
61		- echo '<td>' , $worksheet->getCell('A' . $row)->getFormattedValue() , '</td>';
62		- echo '<td>' , $worksheet->getCell('B' . $row)->getValue() , '</td>';
63		- echo '<td>' , $worksheet->getCell('B' . $row)->getFormattedValue() , '</td>';
64		- echo '<td>' , $worksheet->getCell('C' . $row)->getFormattedValue() , '</td>';
	61	+ echo '<td>', $worksheet->getCell('A' . $row)->getFormattedValue(), '</td>';
	62	+ echo '<td>', $worksheet->getCell('B' . $row)->getValue(), '</td>';
	63	+ echo '<td>', $worksheet->getCell('B' . $row)->getFormattedValue(), '</td>';
	64	+ echo '<td>', $worksheet->getCell('C' . $row)->getFormattedValue(), '</td>';
65	65	echo '</tr>';
66	66	}
67	67	?>

		@@ -35,7 +35,7 @@ discard block
		block discarded – undo
35	35	[2011, 2, 29], [7, 5, 3], [2012, 13, 1], [2012, 11, 45],
36	36	[2012, 0, 0], [2012, 1, 0], [2012, 0, 1],
37	37	[2012, -2, 2], [2012, 2, -2], [2012, -2, -2],
38		- ];
	38	+ ];
39	39	$testDateCount = count($testDates);
40	40
41	41	$worksheet->fromArray($testDates, null, 'A1', true);
		@@ -45,8 +45,8 @@ discard block
		block discarded – undo
45	45	$worksheet->setCellValue('E' . $row, '=D' . $row);
46	46	}
47	47	$worksheet->getStyle('E1:E' . $testDateCount)
48		- ->getNumberFormat()
49		- ->setFormatCode('yyyy-mmm-dd');
	48	+ ->getNumberFormat()
	49	+ ->setFormatCode('yyyy-mmm-dd');
50	50
51	51	echo '<hr />';
52	52

PHPOffice / PhpSpreadsheet

Push — develop ( 8c66af...af82e2 )

Status

Category

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

Spacing +5 added lines, -5 removed lines patch added patch discarded remove patch

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

Spacing +11 added lines, -11 removed lines patch added patch discarded remove patch

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

Spacing +10 added lines, -10 removed lines patch added patch discarded remove patch

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

Spacing +10 added lines, -10 removed lines patch added patch discarded remove patch

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

Spacing +10 added lines, -10 removed lines patch added patch discarded remove patch

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

Spacing +10 added lines, -10 removed lines patch added patch discarded remove patch

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

Spacing +10 added lines, -10 removed lines patch added patch discarded remove patch

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

Spacing +10 added lines, -10 removed lines patch added patch discarded remove patch

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

Spacing +10 added lines, -10 removed lines patch added patch discarded remove patch