Inspection of "Update Border.php" - PHPOffice/PhpSpreadsheet - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — develop (#189)

by Manuel

created 2017-07-28 09:06 UTC

Status

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 = $spreadsheet->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/DVAR.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 = $spreadsheet->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 = $spreadsheet->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 = $spreadsheet->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/DMAX.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 = $spreadsheet->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 = $spreadsheet->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/DCOUNT.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 = $spreadsheet->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 = $spreadsheet->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/index.php 1 patch

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

@@ -36,9 +36,9 @@
 block discarded – undo
             $h1Text = $out[1];
             $h2Text = (preg_match($h2Pattern, $fileData, $out)) ? $out[1] : '';
 
-            echo '<a href="',$exampleFile,'">',$h1Text,'</a><br />';
+            echo '<a href="', $exampleFile, '">', $h1Text, '</a><br />';
             if ($h2Text > '') {
-                echo $h2Text,'<br />';
+                echo $h2Text, '<br />';
             }
         }
     }

Please login to merge, or discard this patch.

		@@ -36,9 +36,9 @@
		block discarded – undo
36	36	$h1Text = $out[1];
37	37	$h2Text = (preg_match($h2Pattern, $fileData, $out)) ? $out[1] : '';
38	38
39		- echo '<a href="',$exampleFile,'">',$h1Text,'</a><br />';
	39	+ echo '<a href="', $exampleFile, '">', $h1Text, '</a><br />';
40	40	if ($h2Text > '') {
41		- echo $h2Text,'<br />';
	41	+ echo $h2Text, '<br />';
42	42	}
43	43	}
44	44	}

PHPOffice / PhpSpreadsheet

Pull Request — develop (#189)

Status

Category

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

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

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