Inspection of "Writer ignores PreCalculateFormulas Flag" - PHPOffice/PhpSpreadsheet - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — develop (#142)

by Dominik

created 2017-04-21 08:14 UTC

Status

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

@@ -28,9 +28,9 @@
 block discarded – undo
 $inputFileName = './sampleData/example1.xls';
 
 $inputFileType = \PhpOffice\PhpSpreadsheet\IOFactory::identify($inputFileName);
-echo 'File ',pathinfo($inputFileName, PATHINFO_BASENAME),' has been identified as an ',$inputFileType,' file<br />';
+echo 'File ', pathinfo($inputFileName, PATHINFO_BASENAME), ' has been identified as an ', $inputFileType, ' file<br />';
 
-echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory with the identified reader type<br />';
+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with the identified reader type<br />';
 $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType);
 $spreadsheet = $reader->load($inputFileName);
 

Please login to merge, or discard this patch.

docs/Examples/Reading WorkBook Data/exampleWorkBookReader01.php 1 patch

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

@@ -37,53 +37,53 @@
 block discarded – undo
 
 /*  Read the document's creator property  **/
 $creator = $spreadsheet->getProperties()->getCreator();
-echo '<b>Document Creator: </b>',$creator,'<br />';
+echo '<b>Document Creator: </b>', $creator, '<br />';
 
 /*  Read the Date when the workbook was created (as a PHP timestamp value)  **/
 $creationDatestamp = $spreadsheet->getProperties()->getCreated();
 /*  Format the date and time using the standard PHP date() function  **/
 $creationDate = date('l, d<\s\up>S</\s\up> F Y', $creationDatestamp);
 $creationTime = date('g:i A', $creationDatestamp);
-echo '<b>Created On: </b>',$creationDate,' at ',$creationTime,'<br />';
+echo '<b>Created On: </b>', $creationDate, ' at ', $creationTime, '<br />';
 
 /*  Read the name of the last person to modify this workbook  **/
 $modifiedBy = $spreadsheet->getProperties()->getLastModifiedBy();
-echo '<b>Last Modified By: </b>',$modifiedBy,'<br />';
+echo '<b>Last Modified By: </b>', $modifiedBy, '<br />';
 
 /*  Read the Date when the workbook was last modified (as a PHP timestamp value)  **/
 $modifiedDatestamp = $spreadsheet->getProperties()->getModified();
 /*  Format the date and time using the standard PHP date() function  **/
 $modifiedDate = date('l, d<\s\up>S</\s\up> F Y', $modifiedDatestamp);
 $modifiedTime = date('g:i A', $modifiedDatestamp);
-echo '<b>Last Modified On: </b>',$modifiedDate,' at ',$modifiedTime,'<br />';
+echo '<b>Last Modified On: </b>', $modifiedDate, ' at ', $modifiedTime, '<br />';
 
 /*  Read the workbook title property  **/
 $workbookTitle = $spreadsheet->getProperties()->getTitle();
-echo '<b>Title: </b>',$workbookTitle,'<br />';
+echo '<b>Title: </b>', $workbookTitle, '<br />';
 
 /*  Read the workbook description property  **/
 $description = $spreadsheet->getProperties()->getDescription();
-echo '<b>Description: </b>',$description,'<br />';
+echo '<b>Description: </b>', $description, '<br />';
 
 /*  Read the workbook subject property  **/
 $subject = $spreadsheet->getProperties()->getSubject();
-echo '<b>Subject: </b>',$subject,'<br />';
+echo '<b>Subject: </b>', $subject, '<br />';
 
 /*  Read the workbook keywords property  **/
 $keywords = $spreadsheet->getProperties()->getKeywords();
-echo '<b>Keywords: </b>',$keywords,'<br />';
+echo '<b>Keywords: </b>', $keywords, '<br />';
 
 /*  Read the workbook category property  **/
 $category = $spreadsheet->getProperties()->getCategory();
-echo '<b>Category: </b>',$category,'<br />';
+echo '<b>Category: </b>', $category, '<br />';
 
 /*  Read the workbook company property  **/
 $company = $spreadsheet->getProperties()->getCompany();
-echo '<b>Company: </b>',$company,'<br />';
+echo '<b>Company: </b>', $company, '<br />';
 
 /*  Read the workbook manager property  **/
 $manager = $spreadsheet->getProperties()->getManager();
-echo '<b>Manager: </b>',$manager,'<br />';
+echo '<b>Manager: </b>', $manager, '<br />';
 
 ?>
 <body>

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 = $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/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 = $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/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 = $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.

		@@ -28,9 +28,9 @@
		block discarded – undo
28	28	$inputFileName = './sampleData/example1.xls';
29	29
30	30	$inputFileType = \PhpOffice\PhpSpreadsheet\IOFactory::identify($inputFileName);
31		-echo 'File ',pathinfo($inputFileName, PATHINFO_BASENAME),' has been identified as an ',$inputFileType,' file<br />';
	31	+echo 'File ', pathinfo($inputFileName, PATHINFO_BASENAME), ' has been identified as an ', $inputFileType, ' file<br />';
32	32
33		-echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory with the identified reader type<br />';
	33	+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with the identified reader type<br />';
34	34	$reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType);
35	35	$spreadsheet = $reader->load($inputFileName);
36	36

		@@ -37,53 +37,53 @@
		block discarded – undo
37	37
38	38	/* Read the document's creator property **/
39	39	$creator = $spreadsheet->getProperties()->getCreator();
40		-echo '<b>Document Creator: </b>',$creator,'<br />';
	40	+echo '<b>Document Creator: </b>', $creator, '<br />';
41	41
42	42	/* Read the Date when the workbook was created (as a PHP timestamp value) **/
43	43	$creationDatestamp = $spreadsheet->getProperties()->getCreated();
44	44	/* Format the date and time using the standard PHP date() function **/
45	45	$creationDate = date('l, d<\s\up>S</\s\up> F Y', $creationDatestamp);
46	46	$creationTime = date('g:i A', $creationDatestamp);
47		-echo '<b>Created On: </b>',$creationDate,' at ',$creationTime,'<br />';
	47	+echo '<b>Created On: </b>', $creationDate, ' at ', $creationTime, '<br />';
48	48
49	49	/* Read the name of the last person to modify this workbook **/
50	50	$modifiedBy = $spreadsheet->getProperties()->getLastModifiedBy();
51		-echo '<b>Last Modified By: </b>',$modifiedBy,'<br />';
	51	+echo '<b>Last Modified By: </b>', $modifiedBy, '<br />';
52	52
53	53	/* Read the Date when the workbook was last modified (as a PHP timestamp value) **/
54	54	$modifiedDatestamp = $spreadsheet->getProperties()->getModified();
55	55	/* Format the date and time using the standard PHP date() function **/
56	56	$modifiedDate = date('l, d<\s\up>S</\s\up> F Y', $modifiedDatestamp);
57	57	$modifiedTime = date('g:i A', $modifiedDatestamp);
58		-echo '<b>Last Modified On: </b>',$modifiedDate,' at ',$modifiedTime,'<br />';
	58	+echo '<b>Last Modified On: </b>', $modifiedDate, ' at ', $modifiedTime, '<br />';
59	59
60	60	/* Read the workbook title property **/
61	61	$workbookTitle = $spreadsheet->getProperties()->getTitle();
62		-echo '<b>Title: </b>',$workbookTitle,'<br />';
	62	+echo '<b>Title: </b>', $workbookTitle, '<br />';
63	63
64	64	/* Read the workbook description property **/
65	65	$description = $spreadsheet->getProperties()->getDescription();
66		-echo '<b>Description: </b>',$description,'<br />';
	66	+echo '<b>Description: </b>', $description, '<br />';
67	67
68	68	/* Read the workbook subject property **/
69	69	$subject = $spreadsheet->getProperties()->getSubject();
70		-echo '<b>Subject: </b>',$subject,'<br />';
	70	+echo '<b>Subject: </b>', $subject, '<br />';
71	71
72	72	/* Read the workbook keywords property **/
73	73	$keywords = $spreadsheet->getProperties()->getKeywords();
74		-echo '<b>Keywords: </b>',$keywords,'<br />';
	74	+echo '<b>Keywords: </b>', $keywords, '<br />';
75	75
76	76	/* Read the workbook category property **/
77	77	$category = $spreadsheet->getProperties()->getCategory();
78		-echo '<b>Category: </b>',$category,'<br />';
	78	+echo '<b>Category: </b>', $category, '<br />';
79	79
80	80	/* Read the workbook company property **/
81	81	$company = $spreadsheet->getProperties()->getCompany();
82		-echo '<b>Company: </b>',$company,'<br />';
	82	+echo '<b>Company: </b>', $company, '<br />';
83	83
84	84	/* Read the workbook manager property **/
85	85	$manager = $spreadsheet->getProperties()->getManager();
86		-echo '<b>Manager: </b>',$manager,'<br />';
	86	+echo '<b>Manager: </b>', $manager, '<br />';
87	87
88	88	?>
89	89	<body>

PHPOffice / PhpSpreadsheet

Pull Request — develop (#142)

Status

Category

Spacing +2 added lines, -2 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