Inspection of "iconv illegal character fix" - PHPOffice/PhpSpreadsheet - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — develop ( 67d526...98e00e )

by Adrien

created 2016-08-26 13:53 UTC

Status

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

@@ -57,9 +57,9 @@  discard block
 block discarded – undo
 
 echo date('H:i:s') , " Adjust properties" , EOL;
 $objPHPExcel->getProperties()->setTitle("Office 95 XLS Test Document")
-							 ->setSubject("Office 95 XLS Test Document")
-							 ->setDescription("Test XLS document, generated using PHPExcel")
-							 ->setKeywords("office 95 biff php");
+                                ->setSubject("Office 95 XLS Test Document")
+                                ->setDescription("Test XLS document, generated using PHPExcel")
+                                ->setKeywords("office 95 biff php");
 
 
 // Save Excel 95 file
@@ -84,10 +84,10 @@  discard block
 block discarded – undo
 echo 'Core Properties:' , EOL;
 echo '    Created by - ' , $objPHPExcel->getProperties()->getCreator() , EOL;
 echo '    Created on - ' , date('d-M-Y',$objPHPExcel->getProperties()->getCreated()) , ' at ' ,
-                       date('H:i:s',$objPHPExcel->getProperties()->getCreated()) , EOL;
+                        date('H:i:s',$objPHPExcel->getProperties()->getCreated()) , EOL;
 echo '    Last Modified by - ' , $objPHPExcel->getProperties()->getLastModifiedBy() , EOL;
 echo '    Last Modified on - ' , date('d-M-Y',$objPHPExcel->getProperties()->getModified()) , ' at ' ,
-                             date('H:i:s',$objPHPExcel->getProperties()->getModified()) , EOL;
+                                date('H:i:s',$objPHPExcel->getProperties()->getModified()) , EOL;
 echo '    Title - ' , $objPHPExcel->getProperties()->getTitle() , EOL;
 echo '    Subject - ' , $objPHPExcel->getProperties()->getSubject() , EOL;
 echo '    Description - ' , $objPHPExcel->getProperties()->getDescription() , EOL;
@@ -103,16 +103,16 @@  discard block
 block discarded – undo
 echo 'Custom Properties:' , EOL;
 $customProperties = $objPHPExcel->getProperties()->getCustomProperties();
 foreach($customProperties as $customProperty) {
-	$propertyValue = $objPHPExcel->getProperties()->getCustomPropertyValue($customProperty);
-	$propertyType = $objPHPExcel->getProperties()->getCustomPropertyType($customProperty);
-	echo '    ' , $customProperty , ' - (' , $propertyType , ') - ';
-	if ($propertyType == \PHPExcel\Document\Properties::PROPERTY_TYPE_DATE) {
-		echo date('d-M-Y H:i:s',$propertyValue) , EOL;
-	} elseif ($propertyType == \PHPExcel\Document\Properties::PROPERTY_TYPE_BOOLEAN) {
-		echo (($propertyValue) ? 'TRUE' : 'FALSE') , EOL;
-	} else {
-		echo $propertyValue , EOL;
-	}
+    $propertyValue = $objPHPExcel->getProperties()->getCustomPropertyValue($customProperty);
+    $propertyType = $objPHPExcel->getProperties()->getCustomPropertyType($customProperty);
+    echo '    ' , $customProperty , ' - (' , $propertyType , ') - ';
+    if ($propertyType == \PHPExcel\Document\Properties::PROPERTY_TYPE_DATE) {
+        echo date('d-M-Y H:i:s',$propertyValue) , EOL;
+    } elseif ($propertyType == \PHPExcel\Document\Properties::PROPERTY_TYPE_BOOLEAN) {
+        echo (($propertyValue) ? 'TRUE' : 'FALSE') , EOL;
+    } else {
+        echo $propertyValue , EOL;
+    }
 }
 
 // Echo memory peak usage

Please login to merge, or discard this patch.

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

@@ -30,7 +30,7 @@  discard block
 block discarded – undo
 ini_set('display_errors', TRUE);
 ini_set('display_startup_errors', TRUE);
 
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
 
 date_default_timezone_set('Europe/London');
 
@@ -42,7 +42,7 @@  discard block
 block discarded – undo
 $inputFileName = 'templates/31docproperties.xls';
 
 
-echo date('H:i:s') , " Load Tests from $inputFileType file" , EOL;
+echo date('H:i:s'), " Load Tests from $inputFileType file", EOL;
 $callStartTime = microtime(true);
 
 $objPHPExcelReader = \PHPExcel\IOFactory::createReader($inputFileType);
@@ -50,12 +50,12 @@  discard block
 block discarded – undo
 
 $callEndTime = microtime(true);
 $callTime = $callEndTime - $callStartTime;
-echo 'Call time to read Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
+echo 'Call time to read Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
 // Echo memory usage
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
 
 
-echo date('H:i:s') , " Adjust properties" , EOL;
+echo date('H:i:s'), " Adjust properties", EOL;
 $objPHPExcel->getProperties()->setTitle("Office 95 XLS Test Document")
 							 ->setSubject("Office 95 XLS Test Document")
 							 ->setDescription("Test XLS document, generated using PHPExcel")
@@ -63,57 +63,57 @@  discard block
 block discarded – undo
 
 
 // Save Excel 95 file
-echo date('H:i:s') , " Write to Excel5 format" , EOL;
+echo date('H:i:s'), " Write to Excel5 format", EOL;
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel5');
 $objWriter->save(str_replace('.php', '.xls', __FILE__));
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
 
 
 // Echo memory peak usage
-echo date('H:i:s') , " Peak memory usage: " . (memory_get_peak_usage(true) / 1024 / 1024) . " MB" , EOL;
+echo date('H:i:s'), " Peak memory usage: " . (memory_get_peak_usage(true) / 1024 / 1024) . " MB", EOL;
 
 
 echo EOL;
 // Reread File
-echo date('H:i:s') , " Reread Excel5 file" , EOL;
+echo date('H:i:s'), " Reread Excel5 file", EOL;
 $objPHPExcelRead = \PHPExcel\IOFactory::load(str_replace('.php', '.xls', __FILE__));
 
 // Set properties
-echo date('H:i:s') , " Get properties" , EOL;
+echo date('H:i:s'), " Get properties", EOL;
 
-echo 'Core Properties:' , EOL;
-echo '    Created by - ' , $objPHPExcel->getProperties()->getCreator() , EOL;
-echo '    Created on - ' , date('d-M-Y',$objPHPExcel->getProperties()->getCreated()) , ' at ' ,
-                       date('H:i:s',$objPHPExcel->getProperties()->getCreated()) , EOL;
-echo '    Last Modified by - ' , $objPHPExcel->getProperties()->getLastModifiedBy() , EOL;
-echo '    Last Modified on - ' , date('d-M-Y',$objPHPExcel->getProperties()->getModified()) , ' at ' ,
-                             date('H:i:s',$objPHPExcel->getProperties()->getModified()) , EOL;
-echo '    Title - ' , $objPHPExcel->getProperties()->getTitle() , EOL;
-echo '    Subject - ' , $objPHPExcel->getProperties()->getSubject() , EOL;
-echo '    Description - ' , $objPHPExcel->getProperties()->getDescription() , EOL;
-echo '    Keywords: - ' , $objPHPExcel->getProperties()->getKeywords() , EOL;
+echo 'Core Properties:', EOL;
+echo '    Created by - ', $objPHPExcel->getProperties()->getCreator(), EOL;
+echo '    Created on - ', date('d-M-Y', $objPHPExcel->getProperties()->getCreated()), ' at ',
+                       date('H:i:s', $objPHPExcel->getProperties()->getCreated()), EOL;
+echo '    Last Modified by - ', $objPHPExcel->getProperties()->getLastModifiedBy(), EOL;
+echo '    Last Modified on - ', date('d-M-Y', $objPHPExcel->getProperties()->getModified()), ' at ',
+                             date('H:i:s', $objPHPExcel->getProperties()->getModified()), EOL;
+echo '    Title - ', $objPHPExcel->getProperties()->getTitle(), EOL;
+echo '    Subject - ', $objPHPExcel->getProperties()->getSubject(), EOL;
+echo '    Description - ', $objPHPExcel->getProperties()->getDescription(), EOL;
+echo '    Keywords: - ', $objPHPExcel->getProperties()->getKeywords(), EOL;
 
 
-echo 'Extended (Application) Properties:' , EOL;
-echo '    Category - ' , $objPHPExcel->getProperties()->getCategory() , EOL;
-echo '    Company - ' , $objPHPExcel->getProperties()->getCompany() , EOL;
-echo '    Manager - ' , $objPHPExcel->getProperties()->getManager() , EOL;
+echo 'Extended (Application) Properties:', EOL;
+echo '    Category - ', $objPHPExcel->getProperties()->getCategory(), EOL;
+echo '    Company - ', $objPHPExcel->getProperties()->getCompany(), EOL;
+echo '    Manager - ', $objPHPExcel->getProperties()->getManager(), EOL;
 
 
-echo 'Custom Properties:' , EOL;
+echo 'Custom Properties:', EOL;
 $customProperties = $objPHPExcel->getProperties()->getCustomProperties();
-foreach($customProperties as $customProperty) {
+foreach ($customProperties as $customProperty) {
 	$propertyValue = $objPHPExcel->getProperties()->getCustomPropertyValue($customProperty);
 	$propertyType = $objPHPExcel->getProperties()->getCustomPropertyType($customProperty);
-	echo '    ' , $customProperty , ' - (' , $propertyType , ') - ';
+	echo '    ', $customProperty, ' - (', $propertyType, ') - ';
 	if ($propertyType == \PHPExcel\Document\Properties::PROPERTY_TYPE_DATE) {
-		echo date('d-M-Y H:i:s',$propertyValue) , EOL;
+		echo date('d-M-Y H:i:s', $propertyValue), EOL;
 	} elseif ($propertyType == \PHPExcel\Document\Properties::PROPERTY_TYPE_BOOLEAN) {
-		echo (($propertyValue) ? 'TRUE' : 'FALSE') , EOL;
+		echo (($propertyValue) ? 'TRUE' : 'FALSE'), EOL;
 	} else {
-		echo $propertyValue , EOL;
+		echo $propertyValue, EOL;
 	}
 }
 
 // Echo memory peak usage
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) . " MB" , EOL;
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024) . " MB", EOL;

Please login to merge, or discard this patch.

Examples/24readfilter.php 2 patches

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

@@ -39,19 +39,19 @@
 block discarded – undo
 
 // Check prerequisites
 if (!file_exists("06largescale.xlsx")) {
-	exit("Please run 06largescale.php first.\n");
+    exit("Please run 06largescale.php first.\n");
 }
 
 class MyReadFilter implements \PHPExcel\Reader\IReadFilter
 {
-	public function readCell($column, $row, $worksheetName = '') {
-		// Read title row and rows 20 - 30
-		if ($row == 1 || ($row >= 20 && $row <= 30)) {
-			return true;
-		}
+    public function readCell($column, $row, $worksheetName = '') {
+        // Read title row and rows 20 - 30
+        if ($row == 1 || ($row >= 20 && $row <= 30)) {
+            return true;
+        }
 
-		return false;
-	}
+        return false;
+    }
 }
 
 

Please login to merge, or discard this patch.

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

@@ -29,7 +29,7 @@  discard block
 block discarded – undo
 ini_set('display_errors', TRUE);
 ini_set('display_startup_errors', TRUE);
 
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
 
 date_default_timezone_set('Europe/London');
 
@@ -55,23 +55,23 @@  discard block
 block discarded – undo
 }
 
 
-echo date('H:i:s') , " Load from Excel2007 file" , EOL;
+echo date('H:i:s'), " Load from Excel2007 file", EOL;
 $objReader = \PHPExcel\IOFactory::createReader('Excel2007');
-$objReader->setReadFilter( new MyReadFilter() );
+$objReader->setReadFilter(new MyReadFilter());
 $objPHPExcel = $objReader->load("06largescale.xlsx");
 
-echo date('H:i:s') , " Remove unnecessary rows" , EOL;
+echo date('H:i:s'), " Remove unnecessary rows", EOL;
 $objPHPExcel->getActiveSheet()->removeRow(2, 18);
 
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
 $objWriter->save(str_replace('.php', '.xlsx', __FILE__));
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
 
 
 // Echo memory peak usage
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
 
 // Echo done
-echo date('H:i:s') , " Done writing file" , EOL;
-echo 'File has been created in ' , getcwd() , EOL;
+echo date('H:i:s'), " Done writing file", EOL;
+echo 'File has been created in ', getcwd(), EOL;

Please login to merge, or discard this patch.

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

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

@@ -32,21 +32,21 @@  discard block
 block discarded – undo
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$database = array( array( 'Tree',  'Height', 'Age', 'Yield', 'Profit' ),
-                   array( 'Apple',  18,       20,    14,      105.00  ),
-                   array( 'Pear',   12,       12,    10,       96.00  ),
-                   array( 'Cherry', 13,       14,     9,      105.00  ),
-                   array( 'Apple',  14,       15,    10,       75.00  ),
-                   array( 'Pear',    9,        8,     8,       76.80  ),
-                   array( 'Apple',   8,        9,     6,       45.00  ),
+$database = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit'),
+                   array('Apple', 18, 20, 14, 105.00),
+                   array('Pear', 12, 12, 10, 96.00),
+                   array('Cherry', 13, 14, 9, 105.00),
+                   array('Apple', 14, 15, 10, 75.00),
+                   array('Pear', 9, 8, 8, 76.80),
+                   array('Apple', 8, 9, 6, 45.00),
                  );
-$criteria = array( array( 'Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height' ),
-                   array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),
-                   array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )
+$criteria = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'),
+                   array('="=Apple"', '>10', NULL, NULL, NULL, '<16'),
+                   array('="=Pear"', NULL, NULL, NULL, NULL, NULL)
                  );
 
-$worksheet->fromArray( $criteria, NULL, 'A1' );
-$worksheet->fromArray( $database, NULL, 'A4' );
+$worksheet->fromArray($criteria, NULL, 'A1');
+$worksheet->fromArray($database, NULL, 'A4');
 
 $worksheet->setCellValue('A12', 'The variance in the yield of Apple and Pear trees');
 $worksheet->setCellValue('B12', '=DVARP(A4:E10,"Yield",A1:A3)');
@@ -60,7 +60,7 @@  discard block
 block discarded – undo
 
 echo '<h4>Database</h4>';
 
-$databaseData = $worksheet->rangeToArray('A4:E10',null,true,true,true);
+$databaseData = $worksheet->rangeToArray('A4:E10', null, true, true, true);
 var_dump($databaseData);
 
 
@@ -70,18 +70,18 @@  discard block
 block discarded – undo
 // Test the formulae
 echo '<h4>Criteria</h4>';
 
-$criteriaData = $worksheet->rangeToArray('A1:A3',null,true,true,true);
+$criteriaData = $worksheet->rangeToArray('A1:A3', null, true, true, true);
 var_dump($criteriaData);
 
-echo $worksheet->getCell("A12")->getValue() .'<br />';
-echo 'DVARP() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() .'<br /><br />';
+echo $worksheet->getCell("A12")->getValue() . '<br />';
+echo 'DVARP() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() . '<br /><br />';
 
 echo '<h4>Criteria</h4>';
 
-$criteriaData = $worksheet->rangeToArray('A1:A3',null,true,true,true);
+$criteriaData = $worksheet->rangeToArray('A1:A3', null, true, true, true);
 var_dump($criteriaData);
 
-echo $worksheet->getCell("A13")->getValue() .'<br />';
+echo $worksheet->getCell("A13")->getValue() . '<br />';
 echo 'DVARP() Result is ' . $worksheet->getCell("B13")->getCalculatedValue();
 
 

Please login to merge, or discard this patch.

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

		@@ -33,17 +33,17 @@
		block discarded – undo
33	33
34	34	// Add some data
35	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		- );
	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	+ );
43	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		- );
	44	+ array( '="=Apple"', '>10', NULL, NULL, NULL, '<16' ),
	45	+ array( '="=Pear"', NULL, NULL, NULL, NULL, NULL )
	46	+ );
47	47
48	48	$worksheet->fromArray( $criteria, NULL, 'A1' );
49	49	$worksheet->fromArray( $database, NULL, 'A4' );

Please login to merge, or discard this patch.

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

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

@@ -32,21 +32,21 @@  discard block
 block discarded – undo
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$database = array( array( 'Tree',  'Height', 'Age', 'Yield', 'Profit' ),
-                   array( 'Apple',  18,       20,    14,      105.00  ),
-                   array( 'Pear',   12,       12,    10,       96.00  ),
-                   array( 'Cherry', 13,       14,     9,      105.00  ),
-                   array( 'Apple',  14,       15,    10,       75.00  ),
-                   array( 'Pear',    9,        8,     8,       76.80  ),
-                   array( 'Apple',   8,        9,     6,       45.00  ),
+$database = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit'),
+                   array('Apple', 18, 20, 14, 105.00),
+                   array('Pear', 12, 12, 10, 96.00),
+                   array('Cherry', 13, 14, 9, 105.00),
+                   array('Apple', 14, 15, 10, 75.00),
+                   array('Pear', 9, 8, 8, 76.80),
+                   array('Apple', 8, 9, 6, 45.00),
                  );
-$criteria = array( array( 'Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height' ),
-                   array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),
-                   array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )
+$criteria = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'),
+                   array('="=Apple"', '>10', NULL, NULL, NULL, '<16'),
+                   array('="=Pear"', NULL, NULL, NULL, NULL, NULL)
                  );
 
-$worksheet->fromArray( $criteria, NULL, 'A1' );
-$worksheet->fromArray( $database, NULL, 'A4' );
+$worksheet->fromArray($criteria, NULL, 'A1');
+$worksheet->fromArray($database, NULL, 'A4');
 
 $worksheet->setCellValue('A12', 'The shortest tree in the orchard');
 $worksheet->setCellValue('B12', '=DMIN(A4:E10,"Height",A4:E10)');
@@ -60,7 +60,7 @@  discard block
 block discarded – undo
 
 echo '<h4>Database</h4>';
 
-$databaseData = $worksheet->rangeToArray('A4:E10',null,true,true,true);
+$databaseData = $worksheet->rangeToArray('A4:E10', null, true, true, true);
 var_dump($databaseData);
 
 
@@ -72,15 +72,15 @@  discard block
 block discarded – undo
 
 echo 'ALL' . '<br /><br />';
 
-echo $worksheet->getCell("A12")->getValue() .'<br />';
-echo 'DMIN() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() .'<br /><br />';
+echo $worksheet->getCell("A12")->getValue() . '<br />';
+echo 'DMIN() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() . '<br /><br />';
 
 echo '<h4>Criteria</h4>';
 
-$criteriaData = $worksheet->rangeToArray('A1:A2',null,true,true,true);
+$criteriaData = $worksheet->rangeToArray('A1:A2', null, true, true, true);
 var_dump($criteriaData);
 
-echo $worksheet->getCell("A13")->getValue() .'<br />';
+echo $worksheet->getCell("A13")->getValue() . '<br />';
 echo 'DMIN() Result is ' . $worksheet->getCell("B13")->getCalculatedValue();
 
 

Please login to merge, or discard this patch.

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

		@@ -33,17 +33,17 @@
		block discarded – undo
33	33
34	34	// Add some data
35	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		- );
	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	+ );
43	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		- );
	44	+ array( '="=Apple"', '>10', NULL, NULL, NULL, '<16' ),
	45	+ array( '="=Pear"', NULL, NULL, NULL, NULL, NULL )
	46	+ );
47	47
48	48	$worksheet->fromArray( $criteria, NULL, 'A1' );
49	49	$worksheet->fromArray( $database, NULL, 'A4' );

Please login to merge, or discard this patch.

Documentation/Examples/Calculations/Database/DVAR.php 2 patches

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

@@ -32,21 +32,21 @@  discard block
 block discarded – undo
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$database = array( array( 'Tree',  'Height', 'Age', 'Yield', 'Profit' ),
-                   array( 'Apple',  18,       20,    14,      105.00  ),
-                   array( 'Pear',   12,       12,    10,       96.00  ),
-                   array( 'Cherry', 13,       14,     9,      105.00  ),
-                   array( 'Apple',  14,       15,    10,       75.00  ),
-                   array( 'Pear',    9,        8,     8,       76.80  ),
-                   array( 'Apple',   8,        9,     6,       45.00  ),
+$database = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit'),
+                   array('Apple', 18, 20, 14, 105.00),
+                   array('Pear', 12, 12, 10, 96.00),
+                   array('Cherry', 13, 14, 9, 105.00),
+                   array('Apple', 14, 15, 10, 75.00),
+                   array('Pear', 9, 8, 8, 76.80),
+                   array('Apple', 8, 9, 6, 45.00),
                  );
-$criteria = array( array( 'Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height' ),
-                   array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),
-                   array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )
+$criteria = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'),
+                   array('="=Apple"', '>10', NULL, NULL, NULL, '<16'),
+                   array('="=Pear"', NULL, NULL, NULL, NULL, NULL)
                  );
 
-$worksheet->fromArray( $criteria, NULL, 'A1' );
-$worksheet->fromArray( $database, NULL, 'A4' );
+$worksheet->fromArray($criteria, NULL, 'A1');
+$worksheet->fromArray($database, NULL, 'A4');
 
 $worksheet->setCellValue('A12', 'The estimated variance in the yield of Apple and Pear trees');
 $worksheet->setCellValue('B12', '=DVAR(A4:E10,"Yield",A1:A3)');
@@ -60,7 +60,7 @@  discard block
 block discarded – undo
 
 echo '<h4>Database</h4>';
 
-$databaseData = $worksheet->rangeToArray('A4:E10',null,true,true,true);
+$databaseData = $worksheet->rangeToArray('A4:E10', null, true, true, true);
 var_dump($databaseData);
 
 
@@ -70,18 +70,18 @@  discard block
 block discarded – undo
 // Test the formulae
 echo '<h4>Criteria</h4>';
 
-$criteriaData = $worksheet->rangeToArray('A1:A3',null,true,true,true);
+$criteriaData = $worksheet->rangeToArray('A1:A3', null, true, true, true);
 var_dump($criteriaData);
 
-echo $worksheet->getCell("A12")->getValue() .'<br />';
-echo 'DVAR() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() .'<br /><br />';
+echo $worksheet->getCell("A12")->getValue() . '<br />';
+echo 'DVAR() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() . '<br /><br />';
 
 echo '<h4>Criteria</h4>';
 
-$criteriaData = $worksheet->rangeToArray('A1:A3',null,true,true,true);
+$criteriaData = $worksheet->rangeToArray('A1:A3', null, true, true, true);
 var_dump($criteriaData);
 
-echo $worksheet->getCell("A13")->getValue() .'<br />';
+echo $worksheet->getCell("A13")->getValue() . '<br />';
 echo 'DVAR() Result is ' . $worksheet->getCell("B13")->getCalculatedValue();
 
 

Please login to merge, or discard this patch.

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

		@@ -33,17 +33,17 @@
		block discarded – undo
33	33
34	34	// Add some data
35	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		- );
	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	+ );
43	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		- );
	44	+ array( '="=Apple"', '>10', NULL, NULL, NULL, '<16' ),
	45	+ array( '="=Pear"', NULL, NULL, NULL, NULL, NULL )
	46	+ );
47	47
48	48	$worksheet->fromArray( $criteria, NULL, 'A1' );
49	49	$worksheet->fromArray( $database, NULL, 'A4' );

Please login to merge, or discard this patch.

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

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

@@ -32,21 +32,21 @@  discard block
 block discarded – undo
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$database = array( array( 'Tree',  'Height', 'Age', 'Yield', 'Profit' ),
-                   array( 'Apple',  18,       20,    14,      105.00  ),
-                   array( 'Pear',   12,       12,    10,       96.00  ),
-                   array( 'Cherry', 13,       14,     9,      105.00  ),
-                   array( 'Apple',  14,       15,    10,       75.00  ),
-                   array( 'Pear',    9,        8,     8,       76.80  ),
-                   array( 'Apple',   8,        9,     6,       45.00  ),
+$database = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit'),
+                   array('Apple', 18, 20, 14, 105.00),
+                   array('Pear', 12, 12, 10, 96.00),
+                   array('Cherry', 13, 14, 9, 105.00),
+                   array('Apple', 14, 15, 10, 75.00),
+                   array('Pear', 9, 8, 8, 76.80),
+                   array('Apple', 8, 9, 6, 45.00),
                  );
-$criteria = array( array( 'Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height' ),
-                   array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),
-                   array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )
+$criteria = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'),
+                   array('="=Apple"', '>10', NULL, NULL, NULL, '<16'),
+                   array('="=Pear"', NULL, NULL, NULL, NULL, NULL)
                  );
 
-$worksheet->fromArray( $criteria, NULL, 'A1' );
-$worksheet->fromArray( $database, NULL, 'A4' );
+$worksheet->fromArray($criteria, NULL, 'A1');
+$worksheet->fromArray($database, NULL, 'A4');
 
 $worksheet->setCellValue('A12', 'The Average yield of Apple trees over 10\' in height');
 $worksheet->setCellValue('B12', '=DAVERAGE(A4:E10,"Yield",A1:B2)');
@@ -60,7 +60,7 @@  discard block
 block discarded – undo
 
 echo '<h4>Database</h4>';
 
-$databaseData = $worksheet->rangeToArray('A4:E10',null,true,true,true);
+$databaseData = $worksheet->rangeToArray('A4:E10', null, true, true, true);
 var_dump($databaseData);
 
 
@@ -70,18 +70,18 @@  discard block
 block discarded – undo
 // Test the formulae
 echo '<h4>Criteria</h4>';
 
-$criteriaData = $worksheet->rangeToArray('A1:B2',null,true,true,true);
+$criteriaData = $worksheet->rangeToArray('A1:B2', null, true, true, true);
 var_dump($criteriaData);
 
-echo $worksheet->getCell("A12")->getValue() .'<br />';
-echo 'DAVERAGE() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() .'<br /><br />';
+echo $worksheet->getCell("A12")->getValue() . '<br />';
+echo 'DAVERAGE() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() . '<br /><br />';
 
 echo '<h4>Criteria</h4>';
 
-$criteriaData = $worksheet->rangeToArray('A1:A3',null,true,true,true);
+$criteriaData = $worksheet->rangeToArray('A1:A3', null, true, true, true);
 var_dump($criteriaData);
 
-echo $worksheet->getCell("A13")->getValue() .'<br />';
+echo $worksheet->getCell("A13")->getValue() . '<br />';
 echo 'DAVERAGE() Result is ' . $worksheet->getCell("B13")->getCalculatedValue();
 
 

Please login to merge, or discard this patch.

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

		@@ -33,17 +33,17 @@
		block discarded – undo
33	33
34	34	// Add some data
35	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		- );
	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	+ );
43	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		- );
	44	+ array( '="=Apple"', '>10', NULL, NULL, NULL, '<16' ),
	45	+ array( '="=Pear"', NULL, NULL, NULL, NULL, NULL )
	46	+ );
47	47
48	48	$worksheet->fromArray( $criteria, NULL, 'A1' );
49	49	$worksheet->fromArray( $database, NULL, 'A4' );

Please login to merge, or discard this patch.

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

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

@@ -32,21 +32,21 @@  discard block
 block discarded – undo
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$database = array( array( 'Tree',  'Height', 'Age', 'Yield', 'Profit' ),
-                   array( 'Apple',  18,       20,    14,      105.00  ),
-                   array( 'Pear',   12,       12,    10,       96.00  ),
-                   array( 'Cherry', 13,       14,     9,      105.00  ),
-                   array( 'Apple',  14,       15,    10,       75.00  ),
-                   array( 'Pear',    9,        8,     8,       76.80  ),
-                   array( 'Apple',   8,        9,     6,       45.00  ),
+$database = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit'),
+                   array('Apple', 18, 20, 14, 105.00),
+                   array('Pear', 12, 12, 10, 96.00),
+                   array('Cherry', 13, 14, 9, 105.00),
+                   array('Apple', 14, 15, 10, 75.00),
+                   array('Pear', 9, 8, 8, 76.80),
+                   array('Apple', 8, 9, 6, 45.00),
                  );
-$criteria = array( array( 'Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height' ),
-                   array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),
-                   array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )
+$criteria = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'),
+                   array('="=Apple"', '>10', NULL, NULL, NULL, '<16'),
+                   array('="=Pear"', NULL, NULL, NULL, NULL, NULL)
                  );
 
-$worksheet->fromArray( $criteria, NULL, 'A1' );
-$worksheet->fromArray( $database, NULL, 'A4' );
+$worksheet->fromArray($criteria, NULL, 'A1');
+$worksheet->fromArray($database, NULL, 'A4');
 
 $worksheet->setCellValue('A12', 'The estimated standard deviation in the yield of Apple and Pear trees');
 $worksheet->setCellValue('B12', '=DSTDEV(A4:E10,"Yield",A1:A3)');
@@ -60,7 +60,7 @@  discard block
 block discarded – undo
 
 echo '<h4>Database</h4>';
 
-$databaseData = $worksheet->rangeToArray('A4:E10',null,true,true,true);
+$databaseData = $worksheet->rangeToArray('A4:E10', null, true, true, true);
 var_dump($databaseData);
 
 
@@ -70,18 +70,18 @@  discard block
 block discarded – undo
 // Test the formulae
 echo '<h4>Criteria</h4>';
 
-$criteriaData = $worksheet->rangeToArray('A1:A3',null,true,true,true);
+$criteriaData = $worksheet->rangeToArray('A1:A3', null, true, true, true);
 var_dump($criteriaData);
 
-echo $worksheet->getCell("A12")->getValue() .'<br />';
-echo 'DSTDEV() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() .'<br /><br />';
+echo $worksheet->getCell("A12")->getValue() . '<br />';
+echo 'DSTDEV() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() . '<br /><br />';
 
 echo '<h4>Criteria</h4>';
 
-$criteriaData = $worksheet->rangeToArray('A1:A3',null,true,true,true);
+$criteriaData = $worksheet->rangeToArray('A1:A3', null, true, true, true);
 var_dump($criteriaData);
 
-echo $worksheet->getCell("A13")->getValue() .'<br />';
+echo $worksheet->getCell("A13")->getValue() . '<br />';
 echo 'DSTDEV() Result is ' . $worksheet->getCell("B13")->getCalculatedValue();
 
 

Please login to merge, or discard this patch.

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

		@@ -33,17 +33,17 @@
		block discarded – undo
33	33
34	34	// Add some data
35	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		- );
	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	+ );
43	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		- );
	44	+ array( '="=Apple"', '>10', NULL, NULL, NULL, '<16' ),
	45	+ array( '="=Pear"', NULL, NULL, NULL, NULL, NULL )
	46	+ );
47	47
48	48	$worksheet->fromArray( $criteria, NULL, 'A1' );
49	49	$worksheet->fromArray( $database, NULL, 'A4' );

Please login to merge, or discard this patch.

Documentation/Examples/Calculations/Database/DCOUNT.php 2 patches

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

@@ -32,21 +32,21 @@  discard block
 block discarded – undo
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$database = array( array( 'Tree',  'Height', 'Age', 'Yield', 'Profit' ),
-                   array( 'Apple',  18,       20,    14,      105.00  ),
-                   array( 'Pear',   12,       12,    10,       96.00  ),
-                   array( 'Cherry', 13,       14,     9,      105.00  ),
-                   array( 'Apple',  14,       15,    10,       75.00  ),
-                   array( 'Pear',    9,        8,     8,       76.80  ),
-                   array( 'Apple',   8,        9,     6,       45.00  ),
+$database = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit'),
+                   array('Apple', 18, 20, 14, 105.00),
+                   array('Pear', 12, 12, 10, 96.00),
+                   array('Cherry', 13, 14, 9, 105.00),
+                   array('Apple', 14, 15, 10, 75.00),
+                   array('Pear', 9, 8, 8, 76.80),
+                   array('Apple', 8, 9, 6, 45.00),
                  );
-$criteria = array( array( 'Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height' ),
-                   array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),
-                   array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )
+$criteria = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'),
+                   array('="=Apple"', '>10', NULL, NULL, NULL, '<16'),
+                   array('="=Pear"', NULL, NULL, NULL, NULL, NULL)
                  );
 
-$worksheet->fromArray( $criteria, NULL, 'A1' );
-$worksheet->fromArray( $database, NULL, 'A4' );
+$worksheet->fromArray($criteria, NULL, 'A1');
+$worksheet->fromArray($database, NULL, 'A4');
 
 $worksheet->setCellValue('A12', 'The Number of Apple trees over 10\' in height');
 $worksheet->setCellValue('B12', '=DCOUNT(A4:E10,"Yield",A1:B2)');
@@ -60,7 +60,7 @@  discard block
 block discarded – undo
 
 echo '<h4>Database</h4>';
 
-$databaseData = $worksheet->rangeToArray('A4:E10',null,true,true,true);
+$databaseData = $worksheet->rangeToArray('A4:E10', null, true, true, true);
 var_dump($databaseData);
 
 
@@ -70,18 +70,18 @@  discard block
 block discarded – undo
 // Test the formulae
 echo '<h4>Criteria</h4>';
 
-$criteriaData = $worksheet->rangeToArray('A1:B2',null,true,true,true);
+$criteriaData = $worksheet->rangeToArray('A1:B2', null, true, true, true);
 var_dump($criteriaData);
 
-echo $worksheet->getCell("A12")->getValue() .'<br />';
-echo 'DCOUNT() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() .'<br /><br />';
+echo $worksheet->getCell("A12")->getValue() . '<br />';
+echo 'DCOUNT() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() . '<br /><br />';
 
 echo '<h4>Criteria</h4>';
 
-$criteriaData = $worksheet->rangeToArray('A1:A3',null,true,true,true);
+$criteriaData = $worksheet->rangeToArray('A1:A3', null, true, true, true);
 var_dump($criteriaData);
 
-echo $worksheet->getCell("A13")->getValue() .'<br />';
+echo $worksheet->getCell("A13")->getValue() . '<br />';
 echo 'DCOUNT() Result is ' . $worksheet->getCell("B13")->getCalculatedValue();
 
 

Please login to merge, or discard this patch.

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

		@@ -33,17 +33,17 @@
		block discarded – undo
33	33
34	34	// Add some data
35	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		- );
	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	+ );
43	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		- );
	44	+ array( '="=Apple"', '>10', NULL, NULL, NULL, '<16' ),
	45	+ array( '="=Pear"', NULL, NULL, NULL, NULL, NULL )
	46	+ );
47	47
48	48	$worksheet->fromArray( $criteria, NULL, 'A1' );
49	49	$worksheet->fromArray( $database, NULL, 'A4' );

Please login to merge, or discard this patch.

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

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

@@ -32,21 +32,21 @@  discard block
 block discarded – undo
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$database = array( array( 'Tree',  'Height', 'Age', 'Yield', 'Profit' ),
-                   array( 'Apple',  18,       20,    14,      105.00  ),
-                   array( 'Pear',   12,       12,    10,       96.00  ),
-                   array( 'Cherry', 13,       14,     9,      105.00  ),
-                   array( 'Apple',  14,       15,    10,       75.00  ),
-                   array( 'Pear',    9,        8,     8,       76.80  ),
-                   array( 'Apple',   8,        9,     6,       45.00  ),
+$database = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit'),
+                   array('Apple', 18, 20, 14, 105.00),
+                   array('Pear', 12, 12, 10, 96.00),
+                   array('Cherry', 13, 14, 9, 105.00),
+                   array('Apple', 14, 15, 10, 75.00),
+                   array('Pear', 9, 8, 8, 76.80),
+                   array('Apple', 8, 9, 6, 45.00),
                  );
-$criteria = array( array( 'Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height' ),
-                   array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),
-                   array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )
+$criteria = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'),
+                   array('="=Apple"', '>10', NULL, NULL, NULL, '<16'),
+                   array('="=Pear"', NULL, NULL, NULL, NULL, NULL)
                  );
 
-$worksheet->fromArray( $criteria, NULL, 'A1' );
-$worksheet->fromArray( $database, NULL, 'A4' );
+$worksheet->fromArray($criteria, NULL, 'A1');
+$worksheet->fromArray($database, NULL, 'A4');
 
 $worksheet->setCellValue('A12', 'The height of the Apple tree between 10\' and 16\' tall');
 $worksheet->setCellValue('B12', '=DGET(A4:E10,"Height",A1:F2)');
@@ -57,7 +57,7 @@  discard block
 block discarded – undo
 
 echo '<h4>Database</h4>';
 
-$databaseData = $worksheet->rangeToArray('A4:E10',null,true,true,true);
+$databaseData = $worksheet->rangeToArray('A4:E10', null, true, true, true);
 var_dump($databaseData);
 
 
@@ -69,15 +69,15 @@  discard block
 block discarded – undo
 
 echo 'ALL' . '<br /><br />';
 
-echo $worksheet->getCell("A12")->getValue() .'<br />';
-echo 'DMAX() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() .'<br /><br />';
+echo $worksheet->getCell("A12")->getValue() . '<br />';
+echo 'DMAX() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() . '<br /><br />';
 
 echo '<h4>Criteria</h4>';
 
-$criteriaData = $worksheet->rangeToArray('A1:A2',null,true,true,true);
+$criteriaData = $worksheet->rangeToArray('A1:A2', null, true, true, true);
 var_dump($criteriaData);
 
-echo $worksheet->getCell("A13")->getValue() .'<br />';
+echo $worksheet->getCell("A13")->getValue() . '<br />';
 echo 'DMAX() Result is ' . $worksheet->getCell("B13")->getCalculatedValue();
 
 

Please login to merge, or discard this patch.

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

		@@ -33,17 +33,17 @@
		block discarded – undo
33	33
34	34	// Add some data
35	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		- );
	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	+ );
43	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		- );
	44	+ array( '="=Apple"', '>10', NULL, NULL, NULL, '<16' ),
	45	+ array( '="=Pear"', NULL, NULL, NULL, NULL, NULL )
	46	+ );
47	47
48	48	$worksheet->fromArray( $criteria, NULL, 'A1' );
49	49	$worksheet->fromArray( $database, NULL, 'A4' );

Please login to merge, or discard this patch.

		@@ -57,9 +57,9 @@ discard block
		block discarded – undo
57	57
58	58	echo date('H:i:s') , " Adjust properties" , EOL;
59	59	$objPHPExcel->getProperties()->setTitle("Office 95 XLS Test Document")
60		- ->setSubject("Office 95 XLS Test Document")
61		- ->setDescription("Test XLS document, generated using PHPExcel")
62		- ->setKeywords("office 95 biff php");
	60	+ ->setSubject("Office 95 XLS Test Document")
	61	+ ->setDescription("Test XLS document, generated using PHPExcel")
	62	+ ->setKeywords("office 95 biff php");
63	63
64	64
65	65	// Save Excel 95 file
		@@ -84,10 +84,10 @@ discard block
		block discarded – undo
84	84	echo 'Core Properties:' , EOL;
85	85	echo ' Created by - ' , $objPHPExcel->getProperties()->getCreator() , EOL;
86	86	echo ' Created on - ' , date('d-M-Y',$objPHPExcel->getProperties()->getCreated()) , ' at ' ,
87		- date('H:i:s',$objPHPExcel->getProperties()->getCreated()) , EOL;
	87	+ date('H:i:s',$objPHPExcel->getProperties()->getCreated()) , EOL;
88	88	echo ' Last Modified by - ' , $objPHPExcel->getProperties()->getLastModifiedBy() , EOL;
89	89	echo ' Last Modified on - ' , date('d-M-Y',$objPHPExcel->getProperties()->getModified()) , ' at ' ,
90		- date('H:i:s',$objPHPExcel->getProperties()->getModified()) , EOL;
	90	+ date('H:i:s',$objPHPExcel->getProperties()->getModified()) , EOL;
91	91	echo ' Title - ' , $objPHPExcel->getProperties()->getTitle() , EOL;
92	92	echo ' Subject - ' , $objPHPExcel->getProperties()->getSubject() , EOL;
93	93	echo ' Description - ' , $objPHPExcel->getProperties()->getDescription() , EOL;
		@@ -103,16 +103,16 @@ discard block
		block discarded – undo
103	103	echo 'Custom Properties:' , EOL;
104	104	$customProperties = $objPHPExcel->getProperties()->getCustomProperties();
105	105	foreach($customProperties as $customProperty) {
106		- $propertyValue = $objPHPExcel->getProperties()->getCustomPropertyValue($customProperty);
107		- $propertyType = $objPHPExcel->getProperties()->getCustomPropertyType($customProperty);
108		- echo ' ' , $customProperty , ' - (' , $propertyType , ') - ';
109		- if ($propertyType == \PHPExcel\Document\Properties::PROPERTY_TYPE_DATE) {
110		- echo date('d-M-Y H:i:s',$propertyValue) , EOL;
111		- } elseif ($propertyType == \PHPExcel\Document\Properties::PROPERTY_TYPE_BOOLEAN) {
112		- echo (($propertyValue) ? 'TRUE' : 'FALSE') , EOL;
113		- } else {
114		- echo $propertyValue , EOL;
115		- }
	106	+ $propertyValue = $objPHPExcel->getProperties()->getCustomPropertyValue($customProperty);
	107	+ $propertyType = $objPHPExcel->getProperties()->getCustomPropertyType($customProperty);
	108	+ echo ' ' , $customProperty , ' - (' , $propertyType , ') - ';
	109	+ if ($propertyType == \PHPExcel\Document\Properties::PROPERTY_TYPE_DATE) {
	110	+ echo date('d-M-Y H:i:s',$propertyValue) , EOL;
	111	+ } elseif ($propertyType == \PHPExcel\Document\Properties::PROPERTY_TYPE_BOOLEAN) {
	112	+ echo (($propertyValue) ? 'TRUE' : 'FALSE') , EOL;
	113	+ } else {
	114	+ echo $propertyValue , EOL;
	115	+ }
116	116	}
117	117
118	118	// Echo memory peak usage

		@@ -30,7 +30,7 @@ discard block
		block discarded – undo
30	30	ini_set('display_errors', TRUE);
31	31	ini_set('display_startup_errors', TRUE);
32	32
33		-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
	33	+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
34	34
35	35	date_default_timezone_set('Europe/London');
36	36
		@@ -42,7 +42,7 @@ discard block
		block discarded – undo
42	42	$inputFileName = 'templates/31docproperties.xls';
43	43
44	44
45		-echo date('H:i:s') , " Load Tests from $inputFileType file" , EOL;
	45	+echo date('H:i:s'), " Load Tests from $inputFileType file", EOL;
46	46	$callStartTime = microtime(true);
47	47
48	48	$objPHPExcelReader = \PHPExcel\IOFactory::createReader($inputFileType);
		@@ -50,12 +50,12 @@ discard block
		block discarded – undo
50	50
51	51	$callEndTime = microtime(true);
52	52	$callTime = $callEndTime - $callStartTime;
53		-echo 'Call time to read Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
	53	+echo 'Call time to read Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
54	54	// Echo memory usage
55		-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
	55	+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
56	56
57	57
58		-echo date('H:i:s') , " Adjust properties" , EOL;
	58	+echo date('H:i:s'), " Adjust properties", EOL;
59	59	$objPHPExcel->getProperties()->setTitle("Office 95 XLS Test Document")
60	60	->setSubject("Office 95 XLS Test Document")
61	61	->setDescription("Test XLS document, generated using PHPExcel")
		@@ -63,57 +63,57 @@ discard block
		block discarded – undo
63	63
64	64
65	65	// Save Excel 95 file
66		-echo date('H:i:s') , " Write to Excel5 format" , EOL;
	66	+echo date('H:i:s'), " Write to Excel5 format", EOL;
67	67	$objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel5');
68	68	$objWriter->save(str_replace('.php', '.xls', __FILE__));
69		-echo date('H:i:s') , " File written to " , str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
	69	+echo date('H:i:s'), " File written to ", str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
70	70
71	71
72	72	// Echo memory peak usage
73		-echo date('H:i:s') , " Peak memory usage: " . (memory_get_peak_usage(true) / 1024 / 1024) . " MB" , EOL;
	73	+echo date('H:i:s'), " Peak memory usage: " . (memory_get_peak_usage(true) / 1024 / 1024) . " MB", EOL;
74	74
75	75
76	76	echo EOL;
77	77	// Reread File
78		-echo date('H:i:s') , " Reread Excel5 file" , EOL;
	78	+echo date('H:i:s'), " Reread Excel5 file", EOL;
79	79	$objPHPExcelRead = \PHPExcel\IOFactory::load(str_replace('.php', '.xls', __FILE__));
80	80
81	81	// Set properties
82		-echo date('H:i:s') , " Get properties" , EOL;
	82	+echo date('H:i:s'), " Get properties", EOL;
83	83
84		-echo 'Core Properties:' , EOL;
85		-echo ' Created by - ' , $objPHPExcel->getProperties()->getCreator() , EOL;
86		-echo ' Created on - ' , date('d-M-Y',$objPHPExcel->getProperties()->getCreated()) , ' at ' ,
87		- date('H:i:s',$objPHPExcel->getProperties()->getCreated()) , EOL;
88		-echo ' Last Modified by - ' , $objPHPExcel->getProperties()->getLastModifiedBy() , EOL;
89		-echo ' Last Modified on - ' , date('d-M-Y',$objPHPExcel->getProperties()->getModified()) , ' at ' ,
90		- date('H:i:s',$objPHPExcel->getProperties()->getModified()) , EOL;
91		-echo ' Title - ' , $objPHPExcel->getProperties()->getTitle() , EOL;
92		-echo ' Subject - ' , $objPHPExcel->getProperties()->getSubject() , EOL;
93		-echo ' Description - ' , $objPHPExcel->getProperties()->getDescription() , EOL;
94		-echo ' Keywords: - ' , $objPHPExcel->getProperties()->getKeywords() , EOL;
	84	+echo 'Core Properties:', EOL;
	85	+echo ' Created by - ', $objPHPExcel->getProperties()->getCreator(), EOL;
	86	+echo ' Created on - ', date('d-M-Y', $objPHPExcel->getProperties()->getCreated()), ' at ',
	87	+ date('H:i:s', $objPHPExcel->getProperties()->getCreated()), EOL;
	88	+echo ' Last Modified by - ', $objPHPExcel->getProperties()->getLastModifiedBy(), EOL;
	89	+echo ' Last Modified on - ', date('d-M-Y', $objPHPExcel->getProperties()->getModified()), ' at ',
	90	+ date('H:i:s', $objPHPExcel->getProperties()->getModified()), EOL;
	91	+echo ' Title - ', $objPHPExcel->getProperties()->getTitle(), EOL;
	92	+echo ' Subject - ', $objPHPExcel->getProperties()->getSubject(), EOL;
	93	+echo ' Description - ', $objPHPExcel->getProperties()->getDescription(), EOL;
	94	+echo ' Keywords: - ', $objPHPExcel->getProperties()->getKeywords(), EOL;
95	95
96	96
97		-echo 'Extended (Application) Properties:' , EOL;
98		-echo ' Category - ' , $objPHPExcel->getProperties()->getCategory() , EOL;
99		-echo ' Company - ' , $objPHPExcel->getProperties()->getCompany() , EOL;
100		-echo ' Manager - ' , $objPHPExcel->getProperties()->getManager() , EOL;
	97	+echo 'Extended (Application) Properties:', EOL;
	98	+echo ' Category - ', $objPHPExcel->getProperties()->getCategory(), EOL;
	99	+echo ' Company - ', $objPHPExcel->getProperties()->getCompany(), EOL;
	100	+echo ' Manager - ', $objPHPExcel->getProperties()->getManager(), EOL;
101	101
102	102
103		-echo 'Custom Properties:' , EOL;
	103	+echo 'Custom Properties:', EOL;
104	104	$customProperties = $objPHPExcel->getProperties()->getCustomProperties();
105		-foreach($customProperties as $customProperty) {
	105	+foreach ($customProperties as $customProperty) {
106	106	$propertyValue = $objPHPExcel->getProperties()->getCustomPropertyValue($customProperty);
107	107	$propertyType = $objPHPExcel->getProperties()->getCustomPropertyType($customProperty);
108		- echo ' ' , $customProperty , ' - (' , $propertyType , ') - ';
	108	+ echo ' ', $customProperty, ' - (', $propertyType, ') - ';
109	109	if ($propertyType == \PHPExcel\Document\Properties::PROPERTY_TYPE_DATE) {
110		- echo date('d-M-Y H:i:s',$propertyValue) , EOL;
	110	+ echo date('d-M-Y H:i:s', $propertyValue), EOL;
111	111	} elseif ($propertyType == \PHPExcel\Document\Properties::PROPERTY_TYPE_BOOLEAN) {
112		- echo (($propertyValue) ? 'TRUE' : 'FALSE') , EOL;
	112	+ echo (($propertyValue) ? 'TRUE' : 'FALSE'), EOL;
113	113	} else {
114		- echo $propertyValue , EOL;
	114	+ echo $propertyValue, EOL;
115	115	}
116	116	}
117	117
118	118	// Echo memory peak usage
119		-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) . " MB" , EOL;
	119	+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024) . " MB", EOL;

		@@ -39,19 +39,19 @@
		block discarded – undo
39	39
40	40	// Check prerequisites
41	41	if (!file_exists("06largescale.xlsx")) {
42		- exit("Please run 06largescale.php first.\n");
	42	+ exit("Please run 06largescale.php first.\n");
43	43	}
44	44
45	45	class MyReadFilter implements \PHPExcel\Reader\IReadFilter
46	46	{
47		- public function readCell($column, $row, $worksheetName = '') {
48		- // Read title row and rows 20 - 30
49		- if ($row == 1 \|\| ($row >= 20 && $row <= 30)) {
50		- return true;
51		- }
	47	+ public function readCell($column, $row, $worksheetName = '') {
	48	+ // Read title row and rows 20 - 30
	49	+ if ($row == 1 \|\| ($row >= 20 && $row <= 30)) {
	50	+ return true;
	51	+ }
52	52
53		- return false;
54		- }
	53	+ return false;
	54	+ }
55	55	}
56	56
57	57

		@@ -29,7 +29,7 @@ discard block
		block discarded – undo
29	29	ini_set('display_errors', TRUE);
30	30	ini_set('display_startup_errors', TRUE);
31	31
32		-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
	32	+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
33	33
34	34	date_default_timezone_set('Europe/London');
35	35
		@@ -55,23 +55,23 @@ discard block
		block discarded – undo
55	55	}
56	56
57	57
58		-echo date('H:i:s') , " Load from Excel2007 file" , EOL;
	58	+echo date('H:i:s'), " Load from Excel2007 file", EOL;
59	59	$objReader = \PHPExcel\IOFactory::createReader('Excel2007');
60		-$objReader->setReadFilter( new MyReadFilter() );
	60	+$objReader->setReadFilter(new MyReadFilter());
61	61	$objPHPExcel = $objReader->load("06largescale.xlsx");
62	62
63		-echo date('H:i:s') , " Remove unnecessary rows" , EOL;
	63	+echo date('H:i:s'), " Remove unnecessary rows", EOL;
64	64	$objPHPExcel->getActiveSheet()->removeRow(2, 18);
65	65
66		-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
	66	+echo date('H:i:s'), " Write to Excel2007 format", EOL;
67	67	$objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
68	68	$objWriter->save(str_replace('.php', '.xlsx', __FILE__));
69		-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
	69	+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
70	70
71	71
72	72	// Echo memory peak usage
73		-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
	73	+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
74	74
75	75	// Echo done
76		-echo date('H:i:s') , " Done writing file" , EOL;
77		-echo 'File has been created in ' , getcwd() , EOL;
	76	+echo date('H:i:s'), " Done writing file", EOL;
	77	+echo 'File has been created in ', getcwd(), EOL;

		@@ -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

PHPOffice / PhpSpreadsheet

Push — develop ( 67d526...98e00e )

Status

Category

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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