View GitHub Repository PhpSpreadsheet

Schedule Inspection
Subscribe
Completed
Push — develop ( 699d11...3cc80b )
by Adrien
31:49 queued 19:10
created
Status
Category
Toggle Patches
Documentation/Examples/Calculations/Database/DVARP.php 1 patch
Spacing   +18 added lines, -18 removed lines patch added patch discarded remove patch 
@@ -32,21 +32,21 @@  discard block
 
 block discarded – undo
32 32 
 $worksheet = $objPHPExcel->getActiveSheet();
33 33
34 34 
 // Add some data
35 
-$database = array( array( 'Tree',  'Height', 'Age', 'Yield', 'Profit' ),
36 
-                   array( 'Apple',  18,       20,    14,      105.00  ),
37 
-                   array( 'Pear',   12,       12,    10,       96.00  ),
38 
-                   array( 'Cherry', 13,       14,     9,      105.00  ),
39 
-                   array( 'Apple',  14,       15,    10,       75.00  ),
40 
-                   array( 'Pear',    9,        8,     8,       76.80  ),
41 
-                   array( 'Apple',   8,        9,     6,       45.00  ),
35 
+$database = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit'),
36 
+                   array('Apple', 18, 20, 14, 105.00),
37 
+                   array('Pear', 12, 12, 10, 96.00),
38 
+                   array('Cherry', 13, 14, 9, 105.00),
39 
+                   array('Apple', 14, 15, 10, 75.00),
40 
+                   array('Pear', 9, 8, 8, 76.80),
41 
+                   array('Apple', 8, 9, 6, 45.00),
42 42 
                  );
43 
-$criteria = array( array( 'Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height' ),
44 
-                   array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),
45 
-                   array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )
43 
+$criteria = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'),
44 
+                   array('="=Apple"', '>10', NULL, NULL, NULL, '<16'),
45 
+                   array('="=Pear"', NULL, NULL, NULL, NULL, NULL)
46 46 
                  );
47 47
48 
-$worksheet->fromArray( $criteria, NULL, 'A1' );
49 
-$worksheet->fromArray( $database, NULL, 'A4' );
48 
+$worksheet->fromArray($criteria, NULL, 'A1');
49 
+$worksheet->fromArray($database, NULL, 'A4');
50 50
51 51 
 $worksheet->setCellValue('A12', 'The variance in the yield of Apple and Pear trees');
52 52 
 $worksheet->setCellValue('B12', '=DVARP(A4:E10,"Yield",A1:A3)');

@@ -60,7 +60,7 @@  discard block
 
 block discarded – undo
60 60
61 61 
 echo '<h4>Database</h4>';
62 62
63 
-$databaseData = $worksheet->rangeToArray('A4:E10',null,true,true,true);
63 
+$databaseData = $worksheet->rangeToArray('A4:E10', null, true, true, true);
64 64 
 var_dump($databaseData);
65 65
66 66 
 

@@ -70,18 +70,18 @@  discard block
 
 block discarded – undo
70 70 
 // Test the formulae
71 71 
 echo '<h4>Criteria</h4>';
72 72
73 
-$criteriaData = $worksheet->rangeToArray('A1:A3',null,true,true,true);
73 
+$criteriaData = $worksheet->rangeToArray('A1:A3', null, true, true, true);
74 74 
 var_dump($criteriaData);
75 75
76 
-echo $worksheet->getCell("A12")->getValue() .'<br />';
77 
-echo 'DVARP() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() .'<br /><br />';
76 
+echo $worksheet->getCell("A12")->getValue() . '<br />';
77 
+echo 'DVARP() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() . '<br /><br />';
78 78
79 79 
 echo '<h4>Criteria</h4>';
80 80
81 
-$criteriaData = $worksheet->rangeToArray('A1:A3',null,true,true,true);
81 
+$criteriaData = $worksheet->rangeToArray('A1:A3', null, true, true, true);
82 82 
 var_dump($criteriaData);
83 83
84 
-echo $worksheet->getCell("A13")->getValue() .'<br />';
84 
+echo $worksheet->getCell("A13")->getValue() . '<br />';
85 85 
 echo 'DVARP() Result is ' . $worksheet->getCell("B13")->getCalculatedValue();
86 86
87 87
Please login to merge, or discard this patch.
Documentation/Examples/Calculations/Database/DMIN.php 1 patch
Spacing   +17 added lines, -17 removed lines patch added patch discarded remove patch 
@@ -32,21 +32,21 @@  discard block
 
 block discarded – undo
32 32 
 $worksheet = $objPHPExcel->getActiveSheet();
33 33
34 34 
 // Add some data
35 
-$database = array( array( 'Tree',  'Height', 'Age', 'Yield', 'Profit' ),
36 
-                   array( 'Apple',  18,       20,    14,      105.00  ),
37 
-                   array( 'Pear',   12,       12,    10,       96.00  ),
38 
-                   array( 'Cherry', 13,       14,     9,      105.00  ),
39 
-                   array( 'Apple',  14,       15,    10,       75.00  ),
40 
-                   array( 'Pear',    9,        8,     8,       76.80  ),
41 
-                   array( 'Apple',   8,        9,     6,       45.00  ),
35 
+$database = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit'),
36 
+                   array('Apple', 18, 20, 14, 105.00),
37 
+                   array('Pear', 12, 12, 10, 96.00),
38 
+                   array('Cherry', 13, 14, 9, 105.00),
39 
+                   array('Apple', 14, 15, 10, 75.00),
40 
+                   array('Pear', 9, 8, 8, 76.80),
41 
+                   array('Apple', 8, 9, 6, 45.00),
42 42 
                  );
43 
-$criteria = array( array( 'Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height' ),
44 
-                   array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),
45 
-                   array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )
43 
+$criteria = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'),
44 
+                   array('="=Apple"', '>10', NULL, NULL, NULL, '<16'),
45 
+                   array('="=Pear"', NULL, NULL, NULL, NULL, NULL)
46 46 
                  );
47 47
48 
-$worksheet->fromArray( $criteria, NULL, 'A1' );
49 
-$worksheet->fromArray( $database, NULL, 'A4' );
48 
+$worksheet->fromArray($criteria, NULL, 'A1');
49 
+$worksheet->fromArray($database, NULL, 'A4');
50 50
51 51 
 $worksheet->setCellValue('A12', 'The shortest tree in the orchard');
52 52 
 $worksheet->setCellValue('B12', '=DMIN(A4:E10,"Height",A4:E10)');

@@ -60,7 +60,7 @@  discard block
 
 block discarded – undo
60 60
61 61 
 echo '<h4>Database</h4>';
62 62
63 
-$databaseData = $worksheet->rangeToArray('A4:E10',null,true,true,true);
63 
+$databaseData = $worksheet->rangeToArray('A4:E10', null, true, true, true);
64 64 
 var_dump($databaseData);
65 65
66 66 
 

@@ -72,15 +72,15 @@  discard block
 
 block discarded – undo
72 72
73 73 
 echo 'ALL' . '<br /><br />';
74 74
75 
-echo $worksheet->getCell("A12")->getValue() .'<br />';
76 
-echo 'DMIN() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() .'<br /><br />';
75 
+echo $worksheet->getCell("A12")->getValue() . '<br />';
76 
+echo 'DMIN() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() . '<br /><br />';
77 77
78 78 
 echo '<h4>Criteria</h4>';
79 79
80 
-$criteriaData = $worksheet->rangeToArray('A1:A2',null,true,true,true);
80 
+$criteriaData = $worksheet->rangeToArray('A1:A2', null, true, true, true);
81 81 
 var_dump($criteriaData);
82 82
83 
-echo $worksheet->getCell("A13")->getValue() .'<br />';
83 
+echo $worksheet->getCell("A13")->getValue() . '<br />';
84 84 
 echo 'DMIN() Result is ' . $worksheet->getCell("B13")->getCalculatedValue();
85 85
86 86
Please login to merge, or discard this patch.
Documentation/Examples/Calculations/Database/DVAR.php 1 patch
Spacing   +18 added lines, -18 removed lines patch added patch discarded remove patch 
@@ -32,21 +32,21 @@  discard block
 
 block discarded – undo
32 32 
 $worksheet = $objPHPExcel->getActiveSheet();
33 33
34 34 
 // Add some data
35 
-$database = array( array( 'Tree',  'Height', 'Age', 'Yield', 'Profit' ),
36 
-                   array( 'Apple',  18,       20,    14,      105.00  ),
37 
-                   array( 'Pear',   12,       12,    10,       96.00  ),
38 
-                   array( 'Cherry', 13,       14,     9,      105.00  ),
39 
-                   array( 'Apple',  14,       15,    10,       75.00  ),
40 
-                   array( 'Pear',    9,        8,     8,       76.80  ),
41 
-                   array( 'Apple',   8,        9,     6,       45.00  ),
35 
+$database = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit'),
36 
+                   array('Apple', 18, 20, 14, 105.00),
37 
+                   array('Pear', 12, 12, 10, 96.00),
38 
+                   array('Cherry', 13, 14, 9, 105.00),
39 
+                   array('Apple', 14, 15, 10, 75.00),
40 
+                   array('Pear', 9, 8, 8, 76.80),
41 
+                   array('Apple', 8, 9, 6, 45.00),
42 42 
                  );
43 
-$criteria = array( array( 'Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height' ),
44 
-                   array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),
45 
-                   array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )
43 
+$criteria = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'),
44 
+                   array('="=Apple"', '>10', NULL, NULL, NULL, '<16'),
45 
+                   array('="=Pear"', NULL, NULL, NULL, NULL, NULL)
46 46 
                  );
47 47
48 
-$worksheet->fromArray( $criteria, NULL, 'A1' );
49 
-$worksheet->fromArray( $database, NULL, 'A4' );
48 
+$worksheet->fromArray($criteria, NULL, 'A1');
49 
+$worksheet->fromArray($database, NULL, 'A4');
50 50
51 51 
 $worksheet->setCellValue('A12', 'The estimated variance in the yield of Apple and Pear trees');
52 52 
 $worksheet->setCellValue('B12', '=DVAR(A4:E10,"Yield",A1:A3)');

@@ -60,7 +60,7 @@  discard block
 
 block discarded – undo
60 60
61 61 
 echo '<h4>Database</h4>';
62 62
63 
-$databaseData = $worksheet->rangeToArray('A4:E10',null,true,true,true);
63 
+$databaseData = $worksheet->rangeToArray('A4:E10', null, true, true, true);
64 64 
 var_dump($databaseData);
65 65
66 66 
 

@@ -70,18 +70,18 @@  discard block
 
 block discarded – undo
70 70 
 // Test the formulae
71 71 
 echo '<h4>Criteria</h4>';
72 72
73 
-$criteriaData = $worksheet->rangeToArray('A1:A3',null,true,true,true);
73 
+$criteriaData = $worksheet->rangeToArray('A1:A3', null, true, true, true);
74 74 
 var_dump($criteriaData);
75 75
76 
-echo $worksheet->getCell("A12")->getValue() .'<br />';
77 
-echo 'DVAR() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() .'<br /><br />';
76 
+echo $worksheet->getCell("A12")->getValue() . '<br />';
77 
+echo 'DVAR() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() . '<br /><br />';
78 78
79 79 
 echo '<h4>Criteria</h4>';
80 80
81 
-$criteriaData = $worksheet->rangeToArray('A1:A3',null,true,true,true);
81 
+$criteriaData = $worksheet->rangeToArray('A1:A3', null, true, true, true);
82 82 
 var_dump($criteriaData);
83 83
84 
-echo $worksheet->getCell("A13")->getValue() .'<br />';
84 
+echo $worksheet->getCell("A13")->getValue() . '<br />';
85 85 
 echo 'DVAR() Result is ' . $worksheet->getCell("B13")->getCalculatedValue();
86 86
87 87
Please login to merge, or discard this patch.
Documentation/Examples/Calculations/Database/DAVERAGE.php 1 patch
Spacing   +18 added lines, -18 removed lines patch added patch discarded remove patch 
@@ -32,21 +32,21 @@  discard block
 
 block discarded – undo
32 32 
 $worksheet = $objPHPExcel->getActiveSheet();
33 33
34 34 
 // Add some data
35 
-$database = array( array( 'Tree',  'Height', 'Age', 'Yield', 'Profit' ),
36 
-                   array( 'Apple',  18,       20,    14,      105.00  ),
37 
-                   array( 'Pear',   12,       12,    10,       96.00  ),
38 
-                   array( 'Cherry', 13,       14,     9,      105.00  ),
39 
-                   array( 'Apple',  14,       15,    10,       75.00  ),
40 
-                   array( 'Pear',    9,        8,     8,       76.80  ),
41 
-                   array( 'Apple',   8,        9,     6,       45.00  ),
35 
+$database = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit'),
36 
+                   array('Apple', 18, 20, 14, 105.00),
37 
+                   array('Pear', 12, 12, 10, 96.00),
38 
+                   array('Cherry', 13, 14, 9, 105.00),
39 
+                   array('Apple', 14, 15, 10, 75.00),
40 
+                   array('Pear', 9, 8, 8, 76.80),
41 
+                   array('Apple', 8, 9, 6, 45.00),
42 42 
                  );
43 
-$criteria = array( array( 'Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height' ),
44 
-                   array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),
45 
-                   array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )
43 
+$criteria = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'),
44 
+                   array('="=Apple"', '>10', NULL, NULL, NULL, '<16'),
45 
+                   array('="=Pear"', NULL, NULL, NULL, NULL, NULL)
46 46 
                  );
47 47
48 
-$worksheet->fromArray( $criteria, NULL, 'A1' );
49 
-$worksheet->fromArray( $database, NULL, 'A4' );
48 
+$worksheet->fromArray($criteria, NULL, 'A1');
49 
+$worksheet->fromArray($database, NULL, 'A4');
50 50
51 51 
 $worksheet->setCellValue('A12', 'The Average yield of Apple trees over 10\' in height');
52 52 
 $worksheet->setCellValue('B12', '=DAVERAGE(A4:E10,"Yield",A1:B2)');

@@ -60,7 +60,7 @@  discard block
 
 block discarded – undo
60 60
61 61 
 echo '<h4>Database</h4>';
62 62
63 
-$databaseData = $worksheet->rangeToArray('A4:E10',null,true,true,true);
63 
+$databaseData = $worksheet->rangeToArray('A4:E10', null, true, true, true);
64 64 
 var_dump($databaseData);
65 65
66 66 
 

@@ -70,18 +70,18 @@  discard block
 
 block discarded – undo
70 70 
 // Test the formulae
71 71 
 echo '<h4>Criteria</h4>';
72 72
73 
-$criteriaData = $worksheet->rangeToArray('A1:B2',null,true,true,true);
73 
+$criteriaData = $worksheet->rangeToArray('A1:B2', null, true, true, true);
74 74 
 var_dump($criteriaData);
75 75
76 
-echo $worksheet->getCell("A12")->getValue() .'<br />';
77 
-echo 'DAVERAGE() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() .'<br /><br />';
76 
+echo $worksheet->getCell("A12")->getValue() . '<br />';
77 
+echo 'DAVERAGE() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() . '<br /><br />';
78 78
79 79 
 echo '<h4>Criteria</h4>';
80 80
81 
-$criteriaData = $worksheet->rangeToArray('A1:A3',null,true,true,true);
81 
+$criteriaData = $worksheet->rangeToArray('A1:A3', null, true, true, true);
82 82 
 var_dump($criteriaData);
83 83
84 
-echo $worksheet->getCell("A13")->getValue() .'<br />';
84 
+echo $worksheet->getCell("A13")->getValue() . '<br />';
85 85 
 echo 'DAVERAGE() Result is ' . $worksheet->getCell("B13")->getCalculatedValue();
86 86
87 87
Please login to merge, or discard this patch.
Documentation/Examples/Calculations/Database/DSTDEV.php 1 patch
Spacing   +18 added lines, -18 removed lines patch added patch discarded remove patch 
@@ -32,21 +32,21 @@  discard block
 
 block discarded – undo
32 32 
 $worksheet = $objPHPExcel->getActiveSheet();
33 33
34 34 
 // Add some data
35 
-$database = array( array( 'Tree',  'Height', 'Age', 'Yield', 'Profit' ),
36 
-                   array( 'Apple',  18,       20,    14,      105.00  ),
37 
-                   array( 'Pear',   12,       12,    10,       96.00  ),
38 
-                   array( 'Cherry', 13,       14,     9,      105.00  ),
39 
-                   array( 'Apple',  14,       15,    10,       75.00  ),
40 
-                   array( 'Pear',    9,        8,     8,       76.80  ),
41 
-                   array( 'Apple',   8,        9,     6,       45.00  ),
35 
+$database = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit'),
36 
+                   array('Apple', 18, 20, 14, 105.00),
37 
+                   array('Pear', 12, 12, 10, 96.00),
38 
+                   array('Cherry', 13, 14, 9, 105.00),
39 
+                   array('Apple', 14, 15, 10, 75.00),
40 
+                   array('Pear', 9, 8, 8, 76.80),
41 
+                   array('Apple', 8, 9, 6, 45.00),
42 42 
                  );
43 
-$criteria = array( array( 'Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height' ),
44 
-                   array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),
45 
-                   array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )
43 
+$criteria = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'),
44 
+                   array('="=Apple"', '>10', NULL, NULL, NULL, '<16'),
45 
+                   array('="=Pear"', NULL, NULL, NULL, NULL, NULL)
46 46 
                  );
47 47
48 
-$worksheet->fromArray( $criteria, NULL, 'A1' );
49 
-$worksheet->fromArray( $database, NULL, 'A4' );
48 
+$worksheet->fromArray($criteria, NULL, 'A1');
49 
+$worksheet->fromArray($database, NULL, 'A4');
50 50
51 51 
 $worksheet->setCellValue('A12', 'The estimated standard deviation in the yield of Apple and Pear trees');
52 52 
 $worksheet->setCellValue('B12', '=DSTDEV(A4:E10,"Yield",A1:A3)');

@@ -60,7 +60,7 @@  discard block
 
 block discarded – undo
60 60
61 61 
 echo '<h4>Database</h4>';
62 62
63 
-$databaseData = $worksheet->rangeToArray('A4:E10',null,true,true,true);
63 
+$databaseData = $worksheet->rangeToArray('A4:E10', null, true, true, true);
64 64 
 var_dump($databaseData);
65 65
66 66 
 

@@ -70,18 +70,18 @@  discard block
 
 block discarded – undo
70 70 
 // Test the formulae
71 71 
 echo '<h4>Criteria</h4>';
72 72
73 
-$criteriaData = $worksheet->rangeToArray('A1:A3',null,true,true,true);
73 
+$criteriaData = $worksheet->rangeToArray('A1:A3', null, true, true, true);
74 74 
 var_dump($criteriaData);
75 75
76 
-echo $worksheet->getCell("A12")->getValue() .'<br />';
77 
-echo 'DSTDEV() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() .'<br /><br />';
76 
+echo $worksheet->getCell("A12")->getValue() . '<br />';
77 
+echo 'DSTDEV() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() . '<br /><br />';
78 78
79 79 
 echo '<h4>Criteria</h4>';
80 80
81 
-$criteriaData = $worksheet->rangeToArray('A1:A3',null,true,true,true);
81 
+$criteriaData = $worksheet->rangeToArray('A1:A3', null, true, true, true);
82 82 
 var_dump($criteriaData);
83 83
84 
-echo $worksheet->getCell("A13")->getValue() .'<br />';
84 
+echo $worksheet->getCell("A13")->getValue() . '<br />';
85 85 
 echo 'DSTDEV() Result is ' . $worksheet->getCell("B13")->getCalculatedValue();
86 86
87 87
Please login to merge, or discard this patch.
Documentation/Examples/Calculations/Database/DCOUNT.php 1 patch
Spacing   +18 added lines, -18 removed lines patch added patch discarded remove patch 
@@ -32,21 +32,21 @@  discard block
 
 block discarded – undo
32 32 
 $worksheet = $objPHPExcel->getActiveSheet();
33 33
34 34 
 // Add some data
35 
-$database = array( array( 'Tree',  'Height', 'Age', 'Yield', 'Profit' ),
36 
-                   array( 'Apple',  18,       20,    14,      105.00  ),
37 
-                   array( 'Pear',   12,       12,    10,       96.00  ),
38 
-                   array( 'Cherry', 13,       14,     9,      105.00  ),
39 
-                   array( 'Apple',  14,       15,    10,       75.00  ),
40 
-                   array( 'Pear',    9,        8,     8,       76.80  ),
41 
-                   array( 'Apple',   8,        9,     6,       45.00  ),
35 
+$database = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit'),
36 
+                   array('Apple', 18, 20, 14, 105.00),
37 
+                   array('Pear', 12, 12, 10, 96.00),
38 
+                   array('Cherry', 13, 14, 9, 105.00),
39 
+                   array('Apple', 14, 15, 10, 75.00),
40 
+                   array('Pear', 9, 8, 8, 76.80),
41 
+                   array('Apple', 8, 9, 6, 45.00),
42 42 
                  );
43 
-$criteria = array( array( 'Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height' ),
44 
-                   array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),
45 
-                   array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )
43 
+$criteria = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'),
44 
+                   array('="=Apple"', '>10', NULL, NULL, NULL, '<16'),
45 
+                   array('="=Pear"', NULL, NULL, NULL, NULL, NULL)
46 46 
                  );
47 47
48 
-$worksheet->fromArray( $criteria, NULL, 'A1' );
49 
-$worksheet->fromArray( $database, NULL, 'A4' );
48 
+$worksheet->fromArray($criteria, NULL, 'A1');
49 
+$worksheet->fromArray($database, NULL, 'A4');
50 50
51 51 
 $worksheet->setCellValue('A12', 'The Number of Apple trees over 10\' in height');
52 52 
 $worksheet->setCellValue('B12', '=DCOUNT(A4:E10,"Yield",A1:B2)');

@@ -60,7 +60,7 @@  discard block
 
 block discarded – undo
60 60
61 61 
 echo '<h4>Database</h4>';
62 62
63 
-$databaseData = $worksheet->rangeToArray('A4:E10',null,true,true,true);
63 
+$databaseData = $worksheet->rangeToArray('A4:E10', null, true, true, true);
64 64 
 var_dump($databaseData);
65 65
66 66 
 

@@ -70,18 +70,18 @@  discard block
 
 block discarded – undo
70 70 
 // Test the formulae
71 71 
 echo '<h4>Criteria</h4>';
72 72
73 
-$criteriaData = $worksheet->rangeToArray('A1:B2',null,true,true,true);
73 
+$criteriaData = $worksheet->rangeToArray('A1:B2', null, true, true, true);
74 74 
 var_dump($criteriaData);
75 75
76 
-echo $worksheet->getCell("A12")->getValue() .'<br />';
77 
-echo 'DCOUNT() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() .'<br /><br />';
76 
+echo $worksheet->getCell("A12")->getValue() . '<br />';
77 
+echo 'DCOUNT() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() . '<br /><br />';
78 78
79 79 
 echo '<h4>Criteria</h4>';
80 80
81 
-$criteriaData = $worksheet->rangeToArray('A1:A3',null,true,true,true);
81 
+$criteriaData = $worksheet->rangeToArray('A1:A3', null, true, true, true);
82 82 
 var_dump($criteriaData);
83 83
84 
-echo $worksheet->getCell("A13")->getValue() .'<br />';
84 
+echo $worksheet->getCell("A13")->getValue() . '<br />';
85 85 
 echo 'DCOUNT() Result is ' . $worksheet->getCell("B13")->getCalculatedValue();
86 86
87 87
Please login to merge, or discard this patch.
Documentation/Examples/Calculations/Database/DGET.php 1 patch
Spacing   +17 added lines, -17 removed lines patch added patch discarded remove patch 
@@ -32,21 +32,21 @@  discard block
 
 block discarded – undo
32 32 
 $worksheet = $objPHPExcel->getActiveSheet();
33 33
34 34 
 // Add some data
35 
-$database = array( array( 'Tree',  'Height', 'Age', 'Yield', 'Profit' ),
36 
-                   array( 'Apple',  18,       20,    14,      105.00  ),
37 
-                   array( 'Pear',   12,       12,    10,       96.00  ),
38 
-                   array( 'Cherry', 13,       14,     9,      105.00  ),
39 
-                   array( 'Apple',  14,       15,    10,       75.00  ),
40 
-                   array( 'Pear',    9,        8,     8,       76.80  ),
41 
-                   array( 'Apple',   8,        9,     6,       45.00  ),
35 
+$database = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit'),
36 
+                   array('Apple', 18, 20, 14, 105.00),
37 
+                   array('Pear', 12, 12, 10, 96.00),
38 
+                   array('Cherry', 13, 14, 9, 105.00),
39 
+                   array('Apple', 14, 15, 10, 75.00),
40 
+                   array('Pear', 9, 8, 8, 76.80),
41 
+                   array('Apple', 8, 9, 6, 45.00),
42 42 
                  );
43 
-$criteria = array( array( 'Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height' ),
44 
-                   array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),
45 
-                   array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )
43 
+$criteria = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'),
44 
+                   array('="=Apple"', '>10', NULL, NULL, NULL, '<16'),
45 
+                   array('="=Pear"', NULL, NULL, NULL, NULL, NULL)
46 46 
                  );
47 47
48 
-$worksheet->fromArray( $criteria, NULL, 'A1' );
49 
-$worksheet->fromArray( $database, NULL, 'A4' );
48 
+$worksheet->fromArray($criteria, NULL, 'A1');
49 
+$worksheet->fromArray($database, NULL, 'A4');
50 50
51 51 
 $worksheet->setCellValue('A12', 'The height of the Apple tree between 10\' and 16\' tall');
52 52 
 $worksheet->setCellValue('B12', '=DGET(A4:E10,"Height",A1:F2)');

@@ -57,7 +57,7 @@  discard block
 
 block discarded – undo
57 57
58 58 
 echo '<h4>Database</h4>';
59 59
60 
-$databaseData = $worksheet->rangeToArray('A4:E10',null,true,true,true);
60 
+$databaseData = $worksheet->rangeToArray('A4:E10', null, true, true, true);
61 61 
 var_dump($databaseData);
62 62
63 63 
 

@@ -69,15 +69,15 @@  discard block
 
 block discarded – undo
69 69
70 70 
 echo 'ALL' . '<br /><br />';
71 71
72 
-echo $worksheet->getCell("A12")->getValue() .'<br />';
73 
-echo 'DMAX() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() .'<br /><br />';
72 
+echo $worksheet->getCell("A12")->getValue() . '<br />';
73 
+echo 'DMAX() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() . '<br /><br />';
74 74
75 75 
 echo '<h4>Criteria</h4>';
76 76
77 
-$criteriaData = $worksheet->rangeToArray('A1:A2',null,true,true,true);
77 
+$criteriaData = $worksheet->rangeToArray('A1:A2', null, true, true, true);
78 78 
 var_dump($criteriaData);
79 79
80 
-echo $worksheet->getCell("A13")->getValue() .'<br />';
80 
+echo $worksheet->getCell("A13")->getValue() . '<br />';
81 81 
 echo 'DMAX() Result is ' . $worksheet->getCell("B13")->getCalculatedValue();
82 82
83 83
Please login to merge, or discard this patch.
Documentation/Examples/Calculations/Database/DSTDEVP.php 1 patch
Spacing   +18 added lines, -18 removed lines patch added patch discarded remove patch 
@@ -32,21 +32,21 @@  discard block
 
 block discarded – undo
32 32 
 $worksheet = $objPHPExcel->getActiveSheet();
33 33
34 34 
 // Add some data
35 
-$database = array( array( 'Tree',  'Height', 'Age', 'Yield', 'Profit' ),
36 
-                   array( 'Apple',  18,       20,    14,      105.00  ),
37 
-                   array( 'Pear',   12,       12,    10,       96.00  ),
38 
-                   array( 'Cherry', 13,       14,     9,      105.00  ),
39 
-                   array( 'Apple',  14,       15,    10,       75.00  ),
40 
-                   array( 'Pear',    9,        8,     8,       76.80  ),
41 
-                   array( 'Apple',   8,        9,     6,       45.00  ),
35 
+$database = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit'),
36 
+                   array('Apple', 18, 20, 14, 105.00),
37 
+                   array('Pear', 12, 12, 10, 96.00),
38 
+                   array('Cherry', 13, 14, 9, 105.00),
39 
+                   array('Apple', 14, 15, 10, 75.00),
40 
+                   array('Pear', 9, 8, 8, 76.80),
41 
+                   array('Apple', 8, 9, 6, 45.00),
42 42 
                  );
43 
-$criteria = array( array( 'Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height' ),
44 
-                   array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),
45 
-                   array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )
43 
+$criteria = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'),
44 
+                   array('="=Apple"', '>10', NULL, NULL, NULL, '<16'),
45 
+                   array('="=Pear"', NULL, NULL, NULL, NULL, NULL)
46 46 
                  );
47 47
48 
-$worksheet->fromArray( $criteria, NULL, 'A1' );
49 
-$worksheet->fromArray( $database, NULL, 'A4' );
48 
+$worksheet->fromArray($criteria, NULL, 'A1');
49 
+$worksheet->fromArray($database, NULL, 'A4');
50 50
51 51 
 $worksheet->setCellValue('A12', 'The standard deviation in the yield of Apple and Pear trees');
52 52 
 $worksheet->setCellValue('B12', '=DSTDEVP(A4:E10,"Yield",A1:A3)');

@@ -60,7 +60,7 @@  discard block
 
 block discarded – undo
60 60
61 61 
 echo '<h4>Database</h4>';
62 62
63 
-$databaseData = $worksheet->rangeToArray('A4:E10',null,true,true,true);
63 
+$databaseData = $worksheet->rangeToArray('A4:E10', null, true, true, true);
64 64 
 var_dump($databaseData);
65 65
66 66 
 

@@ -70,18 +70,18 @@  discard block
 
 block discarded – undo
70 70 
 // Test the formulae
71 71 
 echo '<h4>Criteria</h4>';
72 72
73 
-$criteriaData = $worksheet->rangeToArray('A1:A3',null,true,true,true);
73 
+$criteriaData = $worksheet->rangeToArray('A1:A3', null, true, true, true);
74 74 
 var_dump($criteriaData);
75 75
76 
-echo $worksheet->getCell("A12")->getValue() .'<br />';
77 
-echo 'DSTDEVP() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() .'<br /><br />';
76 
+echo $worksheet->getCell("A12")->getValue() . '<br />';
77 
+echo 'DSTDEVP() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() . '<br /><br />';
78 78
79 79 
 echo '<h4>Criteria</h4>';
80 80
81 
-$criteriaData = $worksheet->rangeToArray('A1:A3',null,true,true,true);
81 
+$criteriaData = $worksheet->rangeToArray('A1:A3', null, true, true, true);
82 82 
 var_dump($criteriaData);
83 83
84 
-echo $worksheet->getCell("A13")->getValue() .'<br />';
84 
+echo $worksheet->getCell("A13")->getValue() . '<br />';
85 85 
 echo 'DSTDEVP() Result is ' . $worksheet->getCell("B13")->getCalculatedValue();
86 86
87 87
Please login to merge, or discard this patch.
Documentation/Examples/Calculations/DateTime/DATEVALUE.php 1 patch
Spacing   +13 added lines, -13 removed lines patch added patch discarded remove patch 
@@ -32,20 +32,20 @@  discard block
 
 block discarded – undo
32 32 
 $worksheet = $objPHPExcel->getActiveSheet();
33 33
34 34 
 // Add some data
35 
-$testDates = array(	'26 March 2012',	'29 Feb 2012',	'April 1, 2012',	'25/12/2012',
36 
-					'2012-Oct-31',		'5th November',	'January 1st',		'April 2012',
37 
-					'17-03',			'03-2012',		'29 Feb 2011',		'03-05-07',
38 
-					'03-MAY-07',		'03-13-07',
35 
+$testDates = array('26 March 2012', '29 Feb 2012', 'April 1, 2012', '25/12/2012',
36 
+					'2012-Oct-31', '5th November', 'January 1st', 'April 2012',
37 
+					'17-03', '03-2012', '29 Feb 2011', '03-05-07',
38 
+					'03-MAY-07', '03-13-07',
39 39 
 				  );
40 40 
 $testDateCount = count($testDates);
41 41
42 
-for($row = 1; $row <= $testDateCount; ++$row) {
43 
-	$worksheet->setCellValue('A'.$row, $testDates[$row-1]);
44 
-	$worksheet->setCellValue('B'.$row, '=DATEVALUE(A'.$row.')');
45 
-	$worksheet->setCellValue('C'.$row, '=B'.$row);
42 
+for ($row = 1; $row <= $testDateCount; ++$row) {
43 
+	$worksheet->setCellValue('A' . $row, $testDates[$row - 1]);
44 
+	$worksheet->setCellValue('B' . $row, '=DATEVALUE(A' . $row . ')');
45 
+	$worksheet->setCellValue('C' . $row, '=B' . $row);
46 46 
 }
47 47
48 
-$worksheet->getStyle('C1:C'.$testDateCount)
48 
+$worksheet->getStyle('C1:C' . $testDateCount)
49 49 
           ->getNumberFormat()
50 50 
           ->setFormatCode('yyyy-mmm-dd');
51 51 
 
@@ -66,10 +66,10 @@  discard block
 
 block discarded – undo
66 66 
 	<?php
67 67 
 	for ($row = 1; $row <= $testDateCount; ++$row) {
68 68 
 		echo '<tr>';
69 
-		    echo '<td>' , $worksheet->getCell('A'.$row)->getFormattedValue() , '</td>';
70 
-			echo '<td>' , $worksheet->getCell('B'.$row)->getValue() , '</td>';
71 
-			echo '<td>' , $worksheet->getCell('B'.$row)->getFormattedValue() , '</td>';
72 
-			echo '<td>' , $worksheet->getCell('C'.$row)->getFormattedValue() , '</td>';
69 
+		    echo '<td>', $worksheet->getCell('A' . $row)->getFormattedValue(), '</td>';
70 
+			echo '<td>', $worksheet->getCell('B' . $row)->getValue(), '</td>';
71 
+			echo '<td>', $worksheet->getCell('B' . $row)->getFormattedValue(), '</td>';
72 
+			echo '<td>', $worksheet->getCell('C' . $row)->getFormattedValue(), '</td>';
73 73 
 		echo '</tr>';
74 74 
 	}
75 75 
 	?>
Please login to merge, or discard this patch.