Completed
Push — develop ( 30a5e4...a5c21a )
by Adrien
240:48 queued 175:47
created
docs/Examples/Calculations/Database/DPRODUCT.php 1 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 1 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 1 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/DVAR.php 1 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/DMAX.php 1 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/DCOUNT.php 1 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/Reader/exampleReader08.php 1 patch
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -33,18 +33,18 @@
 block discarded – undo
33 33
 $inputFileName = './sampleData/example1.xls';
34 34
 $sheetnames = ['Data Sheet #1', 'Data Sheet #3'];
35 35
 
36
-echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />';
36
+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />';
37 37
 $objReader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType);
38
-echo 'Loading Sheet',((count($sheetnames) == 1) ? '' : 's'),' "',implode('" and "', $sheetnames),'" only<br />';
38
+echo 'Loading Sheet', ((count($sheetnames) == 1) ? '' : 's'), ' "', implode('" and "', $sheetnames), '" only<br />';
39 39
 $objReader->setLoadSheetsOnly($sheetnames);
40 40
 $spreadsheet = $objReader->load($inputFileName);
41 41
 
42 42
 echo '<hr />';
43 43
 
44
-echo $spreadsheet->getSheetCount(),' worksheet',(($spreadsheet->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />';
44
+echo $spreadsheet->getSheetCount(), ' worksheet', (($spreadsheet->getSheetCount() == 1) ? '' : 's'), ' loaded<br /><br />';
45 45
 $loadedSheetNames = $spreadsheet->getSheetNames();
46 46
 foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {
47
-    echo $sheetIndex,' -> ',$loadedSheetName,'<br />';
47
+    echo $sheetIndex, ' -> ', $loadedSheetName, '<br />';
48 48
 }
49 49
 
50 50
 ?>
Please login to merge, or discard this patch.
docs/Examples/Reader/exampleReader07.php 1 patch
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -33,18 +33,18 @@
 block discarded – undo
33 33
 $inputFileName = './sampleData/example1.xls';
34 34
 $sheetname = 'Data Sheet #2';
35 35
 
36
-echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />';
36
+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />';
37 37
 $objReader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType);
38
-echo 'Loading Sheet "',$sheetname,'" only<br />';
38
+echo 'Loading Sheet "', $sheetname, '" only<br />';
39 39
 $objReader->setLoadSheetsOnly($sheetname);
40 40
 $spreadsheet = $objReader->load($inputFileName);
41 41
 
42 42
 echo '<hr />';
43 43
 
44
-echo $spreadsheet->getSheetCount(),' worksheet',(($spreadsheet->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />';
44
+echo $spreadsheet->getSheetCount(), ' worksheet', (($spreadsheet->getSheetCount() == 1) ? '' : 's'), ' loaded<br /><br />';
45 45
 $loadedSheetNames = $spreadsheet->getSheetNames();
46 46
 foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {
47
-    echo $sheetIndex,' -> ',$loadedSheetName,'<br />';
47
+    echo $sheetIndex, ' -> ', $loadedSheetName, '<br />';
48 48
 }
49 49
 
50 50
 ?>
Please login to merge, or discard this patch.
docs/Examples/Reader/exampleReader06.php 1 patch
Spacing   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -32,7 +32,7 @@  discard block
 block discarded – undo
32 32
 //	$inputFileType = 'Gnumeric';
33 33
 $inputFileName = './sampleData/example1.xls';
34 34
 
35
-echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />';
35
+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />';
36 36
 $objReader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType);
37 37
 echo 'Loading all WorkSheets<br />';
38 38
 $objReader->setLoadAllSheets();
@@ -40,10 +40,10 @@  discard block
 block discarded – undo
40 40
 
41 41
 echo '<hr />';
42 42
 
43
-echo $spreadsheet->getSheetCount(),' worksheet',(($spreadsheet->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />';
43
+echo $spreadsheet->getSheetCount(), ' worksheet', (($spreadsheet->getSheetCount() == 1) ? '' : 's'), ' loaded<br /><br />';
44 44
 $loadedSheetNames = $spreadsheet->getSheetNames();
45 45
 foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {
46
-    echo $sheetIndex,' -> ',$loadedSheetName,'<br />';
46
+    echo $sheetIndex, ' -> ', $loadedSheetName, '<br />';
47 47
 }
48 48
 
49 49
 ?>
Please login to merge, or discard this patch.