reginaldojunior / winners

app/Vendor/PHPExcel/PHPExcel/Calculation/Functions.php

Spacing +70 added lines, -71 removed lines

@@ -27,12 +27,12 @@ 
 
 
 /** PHPExcel root directory */
-if (!defined('PHPEXCEL_ROOT')) {
+if ( ! defined('PHPEXCEL_ROOT')) {
 	/**
 	 * @ignore
 	 */
-	define('PHPEXCEL_ROOT', dirname(__FILE__) . '/../../');
-	require(PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php');
+	define('PHPEXCEL_ROOT', dirname(__FILE__).'/../../');
+	require(PHPEXCEL_ROOT.'PHPExcel/Autoloader.php');
 }
 
 
@@ -59,13 +59,13 @@ 
 class PHPExcel_Calculation_Functions {
 
 	/** constants */
-	const COMPATIBILITY_EXCEL		= 'Excel';
+	const COMPATIBILITY_EXCEL = 'Excel';
 	const COMPATIBILITY_GNUMERIC	= 'Gnumeric';
-	const COMPATIBILITY_OPENOFFICE	= 'OpenOfficeCalc';
+	const COMPATIBILITY_OPENOFFICE = 'OpenOfficeCalc';
 
 	const RETURNDATE_PHP_NUMERIC	= 'P';
 	const RETURNDATE_PHP_OBJECT		= 'O';
-	const RETURNDATE_EXCEL			= 'E';
+	const RETURNDATE_EXCEL = 'E';
 
 
 	/**
@@ -74,7 +74,7 @@ 
 	 * @access	private
 	 * @var string
 	 */
-	protected static $compatibilityMode	= self::COMPATIBILITY_EXCEL;
+	protected static $compatibilityMode = self::COMPATIBILITY_EXCEL;
 
 	/**
 	 * Data Type to use when returning date values
@@ -82,7 +82,7 @@ 
 	 * @access	private
 	 * @var string
 	 */
-	protected static $ReturnDateType	= self::RETURNDATE_EXCEL;
+	protected static $ReturnDateType = self::RETURNDATE_EXCEL;
 
 	/**
 	 * List of error codes
@@ -90,7 +90,7 @@ 
 	 * @access	private
 	 * @var array
 	 */
-	protected static $_errorCodes	= array( 'null'				=> '#NULL!',
+	protected static $_errorCodes = array('null'				=> '#NULL!',
 											 'divisionbyzero'	=> '#DIV/0!',
 											 'value'			=> '#VALUE!',
 											 'reference'		=> '#REF!',
@@ -292,29 +292,29 @@ 
 
 
 	public static function isMatrixValue($idx) {
-		return ((substr_count($idx,'.') <= 1) || (preg_match('/\.[A-Z]/',$idx) > 0));
+		return ((substr_count($idx, '.') <= 1) || (preg_match('/\.[A-Z]/', $idx) > 0));
 	}
 
 
 	public static function isValue($idx) {
-		return (substr_count($idx,'.') == 0);
+		return (substr_count($idx, '.') == 0);
 	}
 
 
 	public static function isCellValue($idx) {
-		return (substr_count($idx,'.') > 1);
+		return (substr_count($idx, '.') > 1);
 	}
 
 
 	public static function _ifCondition($condition) {
-		$condition	= PHPExcel_Calculation_Functions::flattenSingleValue($condition);
-		if (!in_array($condition{0},array('>', '<', '='))) {
-			if (!is_numeric($condition)) { $condition = PHPExcel_Calculation::_wrapResult(strtoupper($condition)); }
+		$condition = PHPExcel_Calculation_Functions::flattenSingleValue($condition);
+		if ( ! in_array($condition{0},array('>', '<', '='))) {
+			if ( ! is_numeric($condition)) { $condition = PHPExcel_Calculation::_wrapResult(strtoupper($condition)); }
 			return '='.$condition;
 		} else {
-			preg_match('/([<>=]+)(.*)/',$condition,$matches);
-			list(,$operator,$operand) = $matches;
-			if (!is_numeric($operand)) { $operand = PHPExcel_Calculation::_wrapResult(strtoupper($operand)); }
+			preg_match('/([<>=]+)(.*)/', $condition, $matches);
+			list(,$operator, $operand) = $matches;
+			if ( ! is_numeric($operand)) { $operand = PHPExcel_Calculation::_wrapResult(strtoupper($operand)); }
 			return $operator.$operand;
 		}
 	}	//	function _ifCondition()
@@ -327,10 +327,10 @@ 
 	 * @return	boolean
 	 */
 	public static function ERROR_TYPE($value = '') {
-		$value	= self::flattenSingleValue($value);
+		$value = self::flattenSingleValue($value);
 
 		$i = 1;
-		foreach(self::$_errorCodes as $errorCode) {
+		foreach (self::$_errorCodes as $errorCode) {
 			if ($value === $errorCode) {
 				return $i;
 			}
@@ -347,8 +347,8 @@ 
 	 * @return	boolean
 	 */
 	public static function IS_BLANK($value = NULL) {
-		if (!is_null($value)) {
-			$value	= self::flattenSingleValue($value);
+		if ( ! is_null($value)) {
+			$value = self::flattenSingleValue($value);
 		}
 
 		return is_null($value);
@@ -362,9 +362,9 @@ 
 	 * @return	boolean
 	 */
 	public static function IS_ERR($value = '') {
-		$value		= self::flattenSingleValue($value);
+		$value = self::flattenSingleValue($value);
 
-		return self::IS_ERROR($value) && (!self::IS_NA($value));
+		return self::IS_ERROR($value) && ( ! self::IS_NA($value));
 	}	//	function IS_ERR()
 
 
@@ -375,9 +375,9 @@ 
 	 * @return	boolean
 	 */
 	public static function IS_ERROR($value = '') {
-		$value		= self::flattenSingleValue($value);
+		$value = self::flattenSingleValue($value);
 
-		if (!is_string($value))
+		if ( ! is_string($value))
 			return false;
 		return in_array($value, array_values(self::$_errorCodes));
 	}	//	function IS_ERROR()
@@ -390,7 +390,7 @@ 
 	 * @return	boolean
 	 */
 	public static function IS_NA($value = '') {
-		$value		= self::flattenSingleValue($value);
+		$value = self::flattenSingleValue($value);
 
 		return ($value === self::NA());
 	}	//	function IS_NA()
@@ -407,7 +407,7 @@ 
 
 		if ($value === NULL)
 			return self::NAME();
-		if ((is_bool($value)) || ((is_string($value)) && (!is_numeric($value))))
+		if ((is_bool($value)) || ((is_string($value)) && ( ! is_numeric($value))))
 			return self::VALUE();
 		return ($value % 2 == 0);
 	}	//	function IS_EVEN()
@@ -424,7 +424,7 @@ 
 
 		if ($value === NULL)
 			return self::NAME();
-		if ((is_bool($value)) || ((is_string($value)) && (!is_numeric($value))))
+		if ((is_bool($value)) || ((is_string($value)) && ( ! is_numeric($value))))
 			return self::VALUE();
 		return (abs($value) % 2 == 1);
 	}	//	function IS_ODD()
@@ -437,7 +437,7 @@ 
 	 * @return	boolean
 	 */
 	public static function IS_NUMBER($value = NULL) {
-		$value		= self::flattenSingleValue($value);
+		$value = self::flattenSingleValue($value);
 
 		if (is_string($value)) {
 			return False;
@@ -453,7 +453,7 @@ 
 	 * @return	boolean
 	 */
 	public static function IS_LOGICAL($value = NULL) {
-		$value		= self::flattenSingleValue($value);
+		$value = self::flattenSingleValue($value);
 
 		return is_bool($value);
 	}	//	function IS_LOGICAL()
@@ -466,9 +466,9 @@ 
 	 * @return	boolean
 	 */
 	public static function IS_TEXT($value = NULL) {
-		$value		= self::flattenSingleValue($value);
+		$value = self::flattenSingleValue($value);
 
-		return (is_string($value) && !self::IS_ERROR($value));
+		return (is_string($value) && ! self::IS_ERROR($value));
 	}	//	function IS_TEXT()
 
 
@@ -479,7 +479,7 @@ 
 	 * @return	boolean
 	 */
 	public static function IS_NONTEXT($value = NULL) {
-		return !self::IS_TEXT($value);
+		return ! self::IS_TEXT($value);
 	}	//	function IS_NONTEXT()
 
 
@@ -548,7 +548,7 @@ 
 	 *		Array or Matrix		64
 	 */
 	public static function TYPE($value = NULL) {
-		$value	= self::flattenArrayIndexed($value);
+		$value = self::flattenArrayIndexed($value);
 		if (is_array($value) && (count($value) > 1)) {
 			$a = array_keys($value);
 			$a = array_pop($a);
@@ -559,20 +559,20 @@ 
 			} elseif (self::isMatrixValue($a)) {
 				return 64;
 			}
-		} elseif(empty($value)) {
+		} elseif (empty($value)) {
 			//	Empty Cell
 			return 1;
 		}
-		$value	= self::flattenSingleValue($value);
+		$value = self::flattenSingleValue($value);
 
 		if (($value === NULL) || (is_float($value)) || (is_int($value))) {
 				return 1;
-		} elseif(is_bool($value)) {
+		} elseif (is_bool($value)) {
 				return 4;
-		} elseif(is_array($value)) {
+		} elseif (is_array($value)) {
 				return 64;
 				break;
-		} elseif(is_string($value)) {
+		} elseif (is_string($value)) {
 			//	Errors
 			if ((strlen($value) > 0) && ($value{0} == '#')) {
 				return 16;
@@ -590,7 +590,7 @@ 
 	 * @return	array	Flattened array
 	 */
 	public static function flattenArray($array) {
-		if (!is_array($array)) {
+		if ( ! is_array($array)) {
 			return (array) $array;
 		}
 
@@ -622,7 +622,7 @@ 
 	 * @return	array	Flattened array
 	 */
 	public static function flattenArrayIndexed($array) {
-		if (!is_array($array)) {
+		if ( ! is_array($array)) {
 			return (array) $array;
 		}
 
@@ -669,27 +669,27 @@ 
 //	These functions aren't available in Windows implementations of PHP prior to version 5.3.0
 //	So we test if they do exist for this version of PHP/operating platform; and if not we create them
 //
-if (!function_exists('acosh')) {
+if ( ! function_exists('acosh')) {
 	function acosh($x) {
 		return 2 * log(sqrt(($x + 1) / 2) + sqrt(($x - 1) / 2));
 	}	//	function acosh()
 }
 
-if (!function_exists('asinh')) {
+if ( ! function_exists('asinh')) {
 	function asinh($x) {
 		return log($x + sqrt(1 + $x * $x));
 	}	//	function asinh()
 }
 
-if (!function_exists('atanh')) {
+if ( ! function_exists('atanh')) {
 	function atanh($x) {
 		return (log(1 + $x) - log(1 - $x)) / 2;
 	}	//	function atanh()
 }
 
-if (!function_exists('money_format')) {
+if ( ! function_exists('money_format')) {
 	function money_format($format, $number) {
-		$regex = array( '/%((?:[\^!\-]|\+|\(|\=.)*)([0-9]+)?(?:#([0-9]+))?',
+		$regex = array('/%((?:[\^!\-]|\+|\(|\=.)*)([0-9]+)?(?:#([0-9]+))?',
 						 '(?:\.([0-9]+))?([in%])/'
 					  );
 		$regex = implode('', $regex);
@@ -698,19 +698,19 @@ 
 		}
 		$locale = localeconv();
 		$number = floatval($number);
-		if (!preg_match($regex, $format, $fmatch)) {
+		if ( ! preg_match($regex, $format, $fmatch)) {
 			trigger_error("No format specified or invalid format", E_USER_WARNING);
 			return $number;
 		}
-		$flags = array( 'fillchar'	=> preg_match('/\=(.)/', $fmatch[1], $match) ? $match[1] : ' ',
+		$flags = array('fillchar'	=> preg_match('/\=(.)/', $fmatch[1], $match) ? $match[1] : ' ',
 						'nogroup'	=> preg_match('/\^/', $fmatch[1]) > 0,
 						'usesignal'	=> preg_match('/\+|\(/', $fmatch[1], $match) ? $match[0] : '+',
 						'nosimbol'	=> preg_match('/\!/', $fmatch[1]) > 0,
 						'isleft'	=> preg_match('/\-/', $fmatch[1]) > 0
 					  );
-		$width	= trim($fmatch[2]) ? (int)$fmatch[2] : 0;
-		$left	= trim($fmatch[3]) ? (int)$fmatch[3] : 0;
-		$right	= trim($fmatch[4]) ? (int)$fmatch[4] : $locale['int_frac_digits'];
+		$width	= trim($fmatch[2]) ? (int) $fmatch[2] : 0;
+		$left = trim($fmatch[3]) ? (int) $fmatch[3] : 0;
+		$right	= trim($fmatch[4]) ? (int) $fmatch[4] : $locale['int_frac_digits'];
 		$conversion = $fmatch[5];
 		$positive = true;
 		if ($number < 0) {
@@ -719,7 +719,7 @@ 
 		}
 		$letter = $positive ? 'p' : 'n';
 		$prefix = $suffix = $cprefix = $csuffix = $signal = '';
-		if (!$positive) {
+		if ( ! $positive) {
 			$signal = $locale['negative_sign'];
 			switch (true) {
 				case $locale['n_sign_posn'] == 0 || $flags['usesignal'] == '(':
@@ -740,23 +740,22 @@ 
 					break;
 			}
 		}
-		if (!$flags['nosimbol']) {
+		if ( ! $flags['nosimbol']) {
 			$currency = $cprefix;
 			$currency .= ($conversion == 'i' ? $locale['int_curr_symbol'] : $locale['currency_symbol']);
 			$currency .= $csuffix;
-			$currency = iconv('ISO-8859-1','UTF-8',$currency);
+			$currency = iconv('ISO-8859-1', 'UTF-8', $currency);
 		} else {
 			$currency = '';
 		}
 		$space = $locale["{$letter}_sep_by_space"] ? ' ' : '';
 
-		if (!isset($locale['mon_decimal_point']) || empty($locale['mon_decimal_point'])) {
-			$locale['mon_decimal_point'] = (!isset($locale['decimal_point']) || empty($locale['decimal_point'])) ?
-											$locale['decimal_point'] :
-											'.';
+		if ( ! isset($locale['mon_decimal_point']) || empty($locale['mon_decimal_point'])) {
+			$locale['mon_decimal_point'] = ( ! isset($locale['decimal_point']) || empty($locale['decimal_point'])) ?
+											$locale['decimal_point'] : '.';
 		}
 
-		$number = number_format($number, $right, $locale['mon_decimal_point'], $flags['nogroup'] ? '' : $locale['mon_thousands_sep'] );
+		$number = number_format($number, $right, $locale['mon_decimal_point'], $flags['nogroup'] ? '' : $locale['mon_thousands_sep']);
 		$number = explode($locale['mon_decimal_point'], $number);
 
 		$n = strlen($prefix) + strlen($currency);
@@ -764,14 +763,14 @@ 
 			if ($flags['isleft']) {
 				$number[0] .= str_repeat($flags['fillchar'], $left - $n);
 			} else {
-				$number[0] = str_repeat($flags['fillchar'], $left - $n) . $number[0];
+				$number[0] = str_repeat($flags['fillchar'], $left - $n).$number[0];
 			}
 		}
 		$number = implode($locale['mon_decimal_point'], $number);
 		if ($locale["{$letter}_cs_precedes"]) {
-			$number = $prefix . $currency . $space . $number . $suffix;
+			$number = $prefix.$currency.$space.$number.$suffix;
 		} else {
-			$number = $prefix . $number . $space . $currency . $suffix;
+			$number = $prefix.$number.$space.$currency.$suffix;
 		}
 		if ($width > 0) {
 			$number = str_pad($number, $width, $flags['fillchar'], $flags['isleft'] ? STR_PAD_RIGHT : STR_PAD_LEFT);
@@ -786,25 +785,25 @@ 
 //	Strangely, PHP doesn't have a mb_str_replace multibyte function
 //	As we'll only ever use this function with UTF-8 characters, we can simply "hard-code" the character set
 //
-if ((!function_exists('mb_str_replace')) &&
+if (( ! function_exists('mb_str_replace')) &&
 	(function_exists('mb_substr')) && (function_exists('mb_strlen')) && (function_exists('mb_strpos'))) {
 	function mb_str_replace($search, $replace, $subject) {
-		if(is_array($subject)) {
+		if (is_array($subject)) {
 			$ret = array();
-			foreach($subject as $key => $val) {
+			foreach ($subject as $key => $val) {
 				$ret[$key] = mb_str_replace($search, $replace, $val);
 			}
 			return $ret;
 		}
 
-		foreach((array) $search as $key => $s) {
-			if($s == '') {
+		foreach ((array) $search as $key => $s) {
+			if ($s == '') {
 				continue;
 			}
-			$r = !is_array($replace) ? $replace : (array_key_exists($key, $replace) ? $replace[$key] : '');
+			$r = ! is_array($replace) ? $replace : (array_key_exists($key, $replace) ? $replace[$key] : '');
 			$pos = mb_strpos($subject, $s, 0, 'UTF-8');
-			while($pos !== false) {
-				$subject = mb_substr($subject, 0, $pos, 'UTF-8') . $r . mb_substr($subject, $pos + mb_strlen($s, 'UTF-8'), 65535, 'UTF-8');
+			while ($pos !== false) {
+				$subject = mb_substr($subject, 0, $pos, 'UTF-8').$r.mb_substr($subject, $pos + mb_strlen($s, 'UTF-8'), 65535, 'UTF-8');
 				$pos = mb_strpos($subject, $s, $pos + mb_strlen($r, 'UTF-8'), 'UTF-8');
 			}
 		}

Braces +15 added lines, -10 removed lines

@@ -377,8 +377,9 @@ 
 	public static function IS_ERROR($value = '') {
 		$value		= self::flattenSingleValue($value);
 
-		if (!is_string($value))
-			return false;
+		if (!is_string($value)) {
+					return false;
+		}
 		return in_array($value, array_values(self::$_errorCodes));
 	}	//	function IS_ERROR()
 
@@ -405,10 +406,12 @@ 
 	public static function IS_EVEN($value = NULL) {
 		$value = self::flattenSingleValue($value);
 
-		if ($value === NULL)
-			return self::NAME();
-		if ((is_bool($value)) || ((is_string($value)) && (!is_numeric($value))))
-			return self::VALUE();
+		if ($value === NULL) {
+					return self::NAME();
+		}
+		if ((is_bool($value)) || ((is_string($value)) && (!is_numeric($value)))) {
+					return self::VALUE();
+		}
 		return ($value % 2 == 0);
 	}	//	function IS_EVEN()
 
@@ -422,10 +425,12 @@ 
 	public static function IS_ODD($value = NULL) {
 		$value = self::flattenSingleValue($value);
 
-		if ($value === NULL)
-			return self::NAME();
-		if ((is_bool($value)) || ((is_string($value)) && (!is_numeric($value))))
-			return self::VALUE();
+		if ($value === NULL) {
+					return self::NAME();
+		}
+		if ((is_bool($value)) || ((is_string($value)) && (!is_numeric($value)))) {
+					return self::VALUE();
+		}
 		return (abs($value) % 2 == 1);
 	}	//	function IS_ODD()
 

Doc Comments +8 added lines, -2 removed lines

@@ -400,7 +400,7 @@ 
 	 * IS_EVEN
 	 *
 	 * @param	mixed	$value	Value to check
-	 * @return	boolean
+	 * @return	string|boolean
 	 */
 	public static function IS_EVEN($value = NULL) {
 		$value = self::flattenSingleValue($value);
@@ -417,7 +417,7 @@ 
 	 * IS_ODD
 	 *
 	 * @param	mixed	$value	Value to check
-	 * @return	boolean
+	 * @return	string|boolean
 	 */
 	public static function IS_ODD($value = NULL) {
 		$value = self::flattenSingleValue($value);
@@ -688,6 +688,12 @@ 
 }
 
 if (!function_exists('money_format')) {
+
+	/**
+	 * @param string $format
+	 *
+	 * @return string
+	 */
 	function money_format($format, $number) {
 		$regex = array( '/%((?:[\^!\-]|\+|\(|\=.)*)([0-9]+)?(?:#([0-9]+))?',
 						 '(?:\.([0-9]+))?([in%])/'

app/Vendor/PHPExcel/PHPExcel/Cell/AdvancedValueBinder.php

Spacing +14 added lines, -14 removed lines

@@ -27,12 +27,12 @@ 
 
 
 /** PHPExcel root directory */
-if (!defined('PHPEXCEL_ROOT')) {
+if ( ! defined('PHPEXCEL_ROOT')) {
 	/**
 	 * @ignore
 	 */
-	define('PHPEXCEL_ROOT', dirname(__FILE__) . '/../../');
-	require(PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php');
+	define('PHPEXCEL_ROOT', dirname(__FILE__).'/../../');
+	require(PHPEXCEL_ROOT.'PHPExcel/Autoloader.php');
 }
 
 
@@ -63,28 +63,28 @@ 
 		$dataType = parent::dataTypeForValue($value);
 
 		// Style logic - strings
-		if ($dataType === PHPExcel_Cell_DataType::TYPE_STRING && !$value instanceof PHPExcel_RichText) {
+		if ($dataType === PHPExcel_Cell_DataType::TYPE_STRING && ! $value instanceof PHPExcel_RichText) {
 			//	Test for booleans using locale-setting
 			if ($value == PHPExcel_Calculation::getTRUE()) {
-				$cell->setValueExplicit( True, PHPExcel_Cell_DataType::TYPE_BOOL);
+				$cell->setValueExplicit(True, PHPExcel_Cell_DataType::TYPE_BOOL);
 				return true;
-			} elseif($value == PHPExcel_Calculation::getFALSE()) {
-				$cell->setValueExplicit( False, PHPExcel_Cell_DataType::TYPE_BOOL);
+			} elseif ($value == PHPExcel_Calculation::getFALSE()) {
+				$cell->setValueExplicit(False, PHPExcel_Cell_DataType::TYPE_BOOL);
 				return true;
 			}
 
 			// Check for number in scientific format
 			if (preg_match('/^'.PHPExcel_Calculation::CALCULATION_REGEXP_NUMBER.'$/', $value)) {
-				$cell->setValueExplicit( (float) $value, PHPExcel_Cell_DataType::TYPE_NUMERIC);
+				$cell->setValueExplicit((float) $value, PHPExcel_Cell_DataType::TYPE_NUMERIC);
 				return true;
 			}
 
 			// Check for percentage
 			if (preg_match('/^\-?[0-9]*\.?[0-9]*\s?\%$/', $value)) {
 				// Convert value to number
-				$cell->setValueExplicit( (float)str_replace('%', '', $value) / 100, PHPExcel_Cell_DataType::TYPE_NUMERIC);
+				$cell->setValueExplicit((float) str_replace('%', '', $value) / 100, PHPExcel_Cell_DataType::TYPE_NUMERIC);
 				// Set style
-				$cell->getParent()->getStyle( $cell->getCoordinate() )->getNumberFormat()->setFormatCode( PHPExcel_Style_NumberFormat::FORMAT_PERCENTAGE );
+				$cell->getParent()->getStyle($cell->getCoordinate())->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_PERCENTAGE);
 				return true;
 			}
 
@@ -95,7 +95,7 @@ 
 				// Convert value to number
 				$cell->setValueExplicit($days, PHPExcel_Cell_DataType::TYPE_NUMERIC);
 				// Set style
-				$cell->getParent()->getStyle( $cell->getCoordinate() )->getNumberFormat()->setFormatCode( PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME3 );
+				$cell->getParent()->getStyle($cell->getCoordinate())->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME3);
 				return true;
 			}
 
@@ -106,7 +106,7 @@ 
 				// Convert value to number
 				$cell->setValueExplicit($days, PHPExcel_Cell_DataType::TYPE_NUMERIC);
 				// Set style
-				$cell->getParent()->getStyle( $cell->getCoordinate() )->getNumberFormat()->setFormatCode( PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME4 );
+				$cell->getParent()->getStyle($cell->getCoordinate())->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME4);
 				return true;
 			}
 
@@ -120,7 +120,7 @@ 
 				} else {
 					$formatCode = 'yyyy-mm-dd';
 				}
-				$cell->getParent()->getStyle( $cell->getCoordinate() )->getNumberFormat()->setFormatCode($formatCode);
+				$cell->getParent()->getStyle($cell->getCoordinate())->getNumberFormat()->setFormatCode($formatCode);
 				return true;
 			}
 
@@ -129,7 +129,7 @@ 
 				$value = PHPExcel_Shared_String::SanitizeUTF8($value);
 				$cell->setValueExplicit($value, PHPExcel_Cell_DataType::TYPE_STRING);
 				// Set style
-				$cell->getParent()->getStyle( $cell->getCoordinate() )->getAlignment()->setWrapText(true);
+				$cell->getParent()->getStyle($cell->getCoordinate())->getAlignment()->setWrapText(true);
 				return true;
 			}
 		}

app/Vendor/PHPExcel/PHPExcel/Cell/DataType.php

Spacing +6 added lines, -6 removed lines

@@ -37,12 +37,12 @@ 
 {
 	/* Data types */
 	const TYPE_STRING2		= 'str';
-	const TYPE_STRING		= 's';
+	const TYPE_STRING = 's';
 	const TYPE_FORMULA		= 'f';
 	const TYPE_NUMERIC		= 'n';
 	const TYPE_BOOL			= 'b';
-    const TYPE_NULL			= 'null';
-    const TYPE_INLINE		= 'inlineStr';
+    const TYPE_NULL = 'null';
+    const TYPE_INLINE = 'inlineStr';
 	const TYPE_ERROR		= 'e';
 
 	/**
@@ -50,7 +50,7 @@ 
 	 *
 	 * @var array
 	 */
-	private static $_errorCodes	= array('#NULL!' => 0, '#DIV/0!' => 1, '#VALUE!' => 2, '#REF!' => 3, '#NAME?' => 4, '#NUM!' => 5, '#N/A' => 6);
+	private static $_errorCodes = array('#NULL!' => 0, '#DIV/0!' => 1, '#VALUE!' => 2, '#REF!' => 3, '#NAME?' => 4, '#NUM!' => 5, '#N/A' => 6);
 
 	/**
 	 * Get list of error codes
@@ -102,9 +102,9 @@ 
 	 */
 	public static function checkErrorCode($pValue = null)
 	{
-		$pValue = (string)$pValue;
+		$pValue = (string) $pValue;
 
-		if ( !array_key_exists($pValue, self::$_errorCodes) ) {
+		if ( ! array_key_exists($pValue, self::$_errorCodes)) {
 			$pValue = '#NULL!';
 		}
 

Indentation +2 added lines, -2 removed lines

@@ -41,8 +41,8 @@
 	const TYPE_FORMULA		= 'f';
 	const TYPE_NUMERIC		= 'n';
 	const TYPE_BOOL			= 'b';
-    const TYPE_NULL			= 'null';
-    const TYPE_INLINE		= 'inlineStr';
+	const TYPE_NULL			= 'null';
+	const TYPE_INLINE		= 'inlineStr';
 	const TYPE_ERROR		= 'e';
 
 	/**

app/Vendor/PHPExcel/PHPExcel/Cell/DataValidation.php

Indentation +117 added lines, -117 removed lines

@@ -60,105 +60,105 @@ 
 	const OPERATOR_NOTBETWEEN			= 'notBetween';
 	const OPERATOR_NOTEQUAL				= 'notEqual';
 
-    /**
-     * Formula 1
-     *
-     * @var string
-     */
-    private $_formula1;
-
-    /**
-     * Formula 2
-     *
-     * @var string
-     */
-    private $_formula2;
-
-    /**
-     * Type
-     *
-     * @var string
-     */
-    private $_type = PHPExcel_Cell_DataValidation::TYPE_NONE;
-
-    /**
-     * Error style
-     *
-     * @var string
-     */
-    private $_errorStyle = PHPExcel_Cell_DataValidation::STYLE_STOP;
-
-    /**
-     * Operator
-     *
-     * @var string
-     */
-    private $_operator;
-
-    /**
-     * Allow Blank
-     *
-     * @var boolean
-     */
-    private $_allowBlank;
-
-    /**
-     * Show DropDown
-     *
-     * @var boolean
-     */
-    private $_showDropDown;
-
-    /**
-     * Show InputMessage
-     *
-     * @var boolean
-     */
-    private $_showInputMessage;
-
-    /**
-     * Show ErrorMessage
-     *
-     * @var boolean
-     */
-    private $_showErrorMessage;
-
-    /**
-     * Error title
-     *
-     * @var string
-     */
-    private $_errorTitle;
-
-    /**
-     * Error
-     *
-     * @var string
-     */
-    private $_error;
-
-    /**
-     * Prompt title
-     *
-     * @var string
-     */
-    private $_promptTitle;
-
-    /**
-     * Prompt
-     *
-     * @var string
-     */
-    private $_prompt;
-
-    /**
-     * Create a new PHPExcel_Cell_DataValidation
-     *
-     * @throws	Exception
-     */
-    public function __construct()
-    {
-    	// Initialise member variables
+	/**
+	 * Formula 1
+	 *
+	 * @var string
+	 */
+	private $_formula1;
+
+	/**
+	 * Formula 2
+	 *
+	 * @var string
+	 */
+	private $_formula2;
+
+	/**
+	 * Type
+	 *
+	 * @var string
+	 */
+	private $_type = PHPExcel_Cell_DataValidation::TYPE_NONE;
+
+	/**
+	 * Error style
+	 *
+	 * @var string
+	 */
+	private $_errorStyle = PHPExcel_Cell_DataValidation::STYLE_STOP;
+
+	/**
+	 * Operator
+	 *
+	 * @var string
+	 */
+	private $_operator;
+
+	/**
+	 * Allow Blank
+	 *
+	 * @var boolean
+	 */
+	private $_allowBlank;
+
+	/**
+	 * Show DropDown
+	 *
+	 * @var boolean
+	 */
+	private $_showDropDown;
+
+	/**
+	 * Show InputMessage
+	 *
+	 * @var boolean
+	 */
+	private $_showInputMessage;
+
+	/**
+	 * Show ErrorMessage
+	 *
+	 * @var boolean
+	 */
+	private $_showErrorMessage;
+
+	/**
+	 * Error title
+	 *
+	 * @var string
+	 */
+	private $_errorTitle;
+
+	/**
+	 * Error
+	 *
+	 * @var string
+	 */
+	private $_error;
+
+	/**
+	 * Prompt title
+	 *
+	 * @var string
+	 */
+	private $_promptTitle;
+
+	/**
+	 * Prompt
+	 *
+	 * @var string
+	 */
+	private $_prompt;
+
+	/**
+	 * Create a new PHPExcel_Cell_DataValidation
+	 *
+	 * @throws	Exception
+	 */
+	public function __construct()
+	{
+		// Initialise member variables
 		$this->_formula1 			= '';
 		$this->_formula2 			= '';
 		$this->_type 				= PHPExcel_Cell_DataValidation::TYPE_NONE;
@@ -172,7 +172,7 @@ 
 		$this->_error 				= '';
 		$this->_promptTitle 		= '';
 		$this->_prompt 				= '';
-    }
+	}
 
 	/**
 	 * Get Formula 1
@@ -440,23 +440,23 @@ 
 	 * @return string	Hash code
 	 */
 	public function getHashCode() {
-    	return md5(
-    		  $this->_formula1
-    		. $this->_formula2
-    		. $this->_type = PHPExcel_Cell_DataValidation::TYPE_NONE
-    		. $this->_errorStyle = PHPExcel_Cell_DataValidation::STYLE_STOP
-    		. $this->_operator
-    		. ($this->_allowBlank ? 't' : 'f')
-    		. ($this->_showDropDown ? 't' : 'f')
-    		. ($this->_showInputMessage ? 't' : 'f')
-    		. ($this->_showErrorMessage ? 't' : 'f')
-    		. $this->_errorTitle
-    		. $this->_error
-    		. $this->_promptTitle
-    		. $this->_prompt
-    		. __CLASS__
-    	);
-    }
+		return md5(
+			  $this->_formula1
+			. $this->_formula2
+			. $this->_type = PHPExcel_Cell_DataValidation::TYPE_NONE
+			. $this->_errorStyle = PHPExcel_Cell_DataValidation::STYLE_STOP
+			. $this->_operator
+			. ($this->_allowBlank ? 't' : 'f')
+			. ($this->_showDropDown ? 't' : 'f')
+			. ($this->_showInputMessage ? 't' : 'f')
+			. ($this->_showErrorMessage ? 't' : 'f')
+			. $this->_errorTitle
+			. $this->_error
+			. $this->_promptTitle
+			. $this->_prompt
+			. __CLASS__
+		);
+	}
 
 	/**
 	 * Implement PHP __clone to create a deep clone, not just a shallow copy.

Spacing +15 added lines, -15 removed lines

@@ -37,27 +37,27 @@ 
 {
 	/* Data validation types */
 	const TYPE_NONE			= 'none';
-	const TYPE_CUSTOM		= 'custom';
+	const TYPE_CUSTOM = 'custom';
 	const TYPE_DATE			= 'date';
-	const TYPE_DECIMAL		= 'decimal';
+	const TYPE_DECIMAL = 'decimal';
 	const TYPE_LIST			= 'list';
-	const TYPE_TEXTLENGTH	= 'textLength';
+	const TYPE_TEXTLENGTH = 'textLength';
 	const TYPE_TIME			= 'time';
 	const TYPE_WHOLE		= 'whole';
 
 	/* Data validation error styles */
 	const STYLE_STOP		= 'stop';
-	const STYLE_WARNING		= 'warning';
-	const STYLE_INFORMATION	= 'information';
+	const STYLE_WARNING = 'warning';
+	const STYLE_INFORMATION = 'information';
 
 	/* Data validation operators */
-	const OPERATOR_BETWEEN				= 'between';
-	const OPERATOR_EQUAL				= 'equal';
-	const OPERATOR_GREATERTHAN			= 'greaterThan';
-	const OPERATOR_GREATERTHANOREQUAL	= 'greaterThanOrEqual';
+	const OPERATOR_BETWEEN = 'between';
+	const OPERATOR_EQUAL = 'equal';
+	const OPERATOR_GREATERTHAN = 'greaterThan';
+	const OPERATOR_GREATERTHANOREQUAL = 'greaterThanOrEqual';
 	const OPERATOR_LESSTHAN				= 'lessThan';
-	const OPERATOR_LESSTHANOREQUAL		= 'lessThanOrEqual';
-	const OPERATOR_NOTBETWEEN			= 'notBetween';
+	const OPERATOR_LESSTHANOREQUAL = 'lessThanOrEqual';
+	const OPERATOR_NOTBETWEEN = 'notBetween';
 	const OPERATOR_NOTEQUAL				= 'notEqual';
 
     /**
@@ -161,17 +161,17 @@ 
     	// Initialise member variables
 		$this->_formula1 			= '';
 		$this->_formula2 			= '';
-		$this->_type 				= PHPExcel_Cell_DataValidation::TYPE_NONE;
+		$this->_type = PHPExcel_Cell_DataValidation::TYPE_NONE;
 		$this->_errorStyle 			= PHPExcel_Cell_DataValidation::STYLE_STOP;
 		$this->_operator 			= '';
 		$this->_allowBlank 			= false;
-		$this->_showDropDown 		= false;
+		$this->_showDropDown = false;
 		$this->_showInputMessage 	= false;
 		$this->_showErrorMessage 	= false;
 		$this->_errorTitle 			= '';
-		$this->_error 				= '';
+		$this->_error = '';
 		$this->_promptTitle 		= '';
-		$this->_prompt 				= '';
+		$this->_prompt = '';
     }
 
 	/**

app/Vendor/PHPExcel/PHPExcel/Cell/DefaultValueBinder.php

Spacing +4 added lines, -4 removed lines

@@ -27,12 +27,12 @@ 
 
 
 /** PHPExcel root directory */
-if (!defined('PHPEXCEL_ROOT')) {
+if ( ! defined('PHPEXCEL_ROOT')) {
 	/**
 	 * @ignore
 	 */
-	define('PHPEXCEL_ROOT', dirname(__FILE__) . '/../../');
-	require(PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php');
+	define('PHPEXCEL_ROOT', dirname(__FILE__).'/../../');
+	require(PHPEXCEL_ROOT.'PHPExcel/Autoloader.php');
 }
 
 
@@ -60,7 +60,7 @@ 
 		}
 
 		// Set value explicit
-		$cell->setValueExplicit( $value, self::dataTypeForValue($value) );
+		$cell->setValueExplicit($value, self::dataTypeForValue($value));
 
 		// Done!
 		return true;

app/Vendor/PHPExcel/PHPExcel/Cell/Hyperlink.php

Spacing +2 added lines, -2 removed lines

@@ -59,8 +59,8 @@
     public function __construct($pUrl = '', $pTooltip = '')
     {
     	// Initialise member variables
-		$this->_url 		= $pUrl;
-		$this->_tooltip 	= $pTooltip;
+		$this->_url = $pUrl;
+		$this->_tooltip = $pTooltip;
     }
 
 	/**

Indentation +17 added lines, -17 removed lines

@@ -49,19 +49,19 @@ 
 	 */
 	private $_tooltip;
 
-    /**
-     * Create a new PHPExcel_Cell_Hyperlink
-     *
-     * @param 	string				$pUrl		Url to link the cell to
-     * @param	string				$pTooltip	Tooltip to display on the hyperlink
-     * @throws	Exception
-     */
-    public function __construct($pUrl = '', $pTooltip = '')
-    {
-    	// Initialise member variables
+	/**
+	 * Create a new PHPExcel_Cell_Hyperlink
+	 *
+	 * @param 	string				$pUrl		Url to link the cell to
+	 * @param	string				$pTooltip	Tooltip to display on the hyperlink
+	 * @throws	Exception
+	 */
+	public function __construct($pUrl = '', $pTooltip = '')
+	{
+		// Initialise member variables
 		$this->_url 		= $pUrl;
 		$this->_tooltip 	= $pTooltip;
-    }
+	}
 
 	/**
 	 * Get URL
@@ -118,10 +118,10 @@ 
 	 * @return string	Hash code
 	 */
 	public function getHashCode() {
-    	return md5(
-    		  $this->_url
-    		. $this->_tooltip
-    		. __CLASS__
-    	);
-    }
+		return md5(
+			  $this->_url
+			. $this->_tooltip
+			. __CLASS__
+		);
+	}
 }

app/Vendor/PHPExcel/PHPExcel/Chart.php

Spacing +20 added lines, -20 removed lines

@@ -287,11 +287,11 @@ 
 	 * @param	integer	$yOffset
 	 * @return PHPExcel_Chart
 	 */
-	public function setTopLeftPosition($cell, $xOffset=null, $yOffset=null) {
+	public function setTopLeftPosition($cell, $xOffset = null, $yOffset = null) {
 		$this->_topLeftCellRef = $cell;
-		if (!is_null($xOffset))
+		if ( ! is_null($xOffset))
 			$this->setTopLeftXOffset($xOffset);
-		if (!is_null($yOffset))
+		if ( ! is_null($yOffset))
 			$this->setTopLeftYOffset($yOffset);
 
 		return $this;
@@ -303,7 +303,7 @@ 
 	 * @return array	an associative array containing the cell address, X-Offset and Y-Offset from the top left of that cell
 	 */
 	public function getTopLeftPosition() {
-		return array( 'cell'	=> $this->_topLeftCellRef,
+		return array('cell'	=> $this->_topLeftCellRef,
 					  'xOffset'	=> $this->_topLeftXOffset,
 					  'yOffset'	=> $this->_topLeftYOffset
 					);
@@ -330,17 +330,17 @@ 
 		return $this;
 	}
 
-	public function setTopLeftOffset($xOffset=null,$yOffset=null) {
-		if (!is_null($xOffset))
+	public function setTopLeftOffset($xOffset = null, $yOffset = null) {
+		if ( ! is_null($xOffset))
 			$this->setTopLeftXOffset($xOffset);
-		if (!is_null($yOffset))
+		if ( ! is_null($yOffset))
 			$this->setTopLeftYOffset($yOffset);
 
 		return $this;
 	}
 
 	public function getTopLeftOffset() {
-		return array( 'X' => $this->_topLeftXOffset,
+		return array('X' => $this->_topLeftXOffset,
 					  'Y' => $this->_topLeftYOffset
 					);
 	}
@@ -373,11 +373,11 @@ 
 	 * @param	integer	$yOffset
 	 * @return PHPExcel_Chart
 	 */
-	public function setBottomRightPosition($cell, $xOffset=null, $yOffset=null) {
+	public function setBottomRightPosition($cell, $xOffset = null, $yOffset = null) {
 		$this->_bottomRightCellRef = $cell;
-		if (!is_null($xOffset))
+		if ( ! is_null($xOffset))
 			$this->setBottomRightXOffset($xOffset);
-		if (!is_null($yOffset))
+		if ( ! is_null($yOffset))
 			$this->setBottomRightYOffset($yOffset);
 
 		return $this;
@@ -389,7 +389,7 @@ 
 	 * @return array	an associative array containing the cell address, X-Offset and Y-Offset from the top left of that cell
 	 */
 	public function getBottomRightPosition() {
-		return array( 'cell'	=> $this->_bottomRightCellRef,
+		return array('cell'	=> $this->_bottomRightCellRef,
 					  'xOffset'	=> $this->_bottomRightXOffset,
 					  'yOffset'	=> $this->_bottomRightYOffset
 					);
@@ -410,17 +410,17 @@ 
 		return $this->_bottomRightCellRef;
 	}
 
-	public function setBottomRightOffset($xOffset=null,$yOffset=null) {
-		if (!is_null($xOffset))
+	public function setBottomRightOffset($xOffset = null, $yOffset = null) {
+		if ( ! is_null($xOffset))
 			$this->setBottomRightXOffset($xOffset);
-		if (!is_null($yOffset))
+		if ( ! is_null($yOffset))
 			$this->setBottomRightYOffset($yOffset);
 
 		return $this;
 	}
 
 	public function getBottomRightOffset() {
-		return array( 'X' => $this->_bottomRightXOffset,
+		return array('X' => $this->_bottomRightXOffset,
 					  'Y' => $this->_bottomRightYOffset
 					);
 	}
@@ -461,10 +461,10 @@ 
 		$this->refresh();
 
 		$libraryPath = PHPExcel_Settings::getChartRendererPath();
-		$includePath = str_replace('\\','/',get_include_path());
-		$rendererPath = str_replace('\\','/',$libraryPath);
-		if (strpos($rendererPath,$includePath) === false) {
-			set_include_path(get_include_path() . PATH_SEPARATOR . $libraryPath);
+		$includePath = str_replace('\\', '/', get_include_path());
+		$rendererPath = str_replace('\\', '/', $libraryPath);
+		if (strpos($rendererPath, $includePath) === false) {
+			set_include_path(get_include_path().PATH_SEPARATOR.$libraryPath);
 		}
 
 		$rendererName = 'PHPExcel_Chart_Renderer_'.$libraryName;

Braces +24 added lines, -16 removed lines

@@ -289,10 +289,12 @@ 
 	 */
 	public function setTopLeftPosition($cell, $xOffset=null, $yOffset=null) {
 		$this->_topLeftCellRef = $cell;
-		if (!is_null($xOffset))
-			$this->setTopLeftXOffset($xOffset);
-		if (!is_null($yOffset))
-			$this->setTopLeftYOffset($yOffset);
+		if (!is_null($xOffset)) {
+					$this->setTopLeftXOffset($xOffset);
+		}
+		if (!is_null($yOffset)) {
+					$this->setTopLeftYOffset($yOffset);
+		}
 
 		return $this;
 	}
@@ -331,10 +333,12 @@ 
 	}
 
 	public function setTopLeftOffset($xOffset=null,$yOffset=null) {
-		if (!is_null($xOffset))
-			$this->setTopLeftXOffset($xOffset);
-		if (!is_null($yOffset))
-			$this->setTopLeftYOffset($yOffset);
+		if (!is_null($xOffset)) {
+					$this->setTopLeftXOffset($xOffset);
+		}
+		if (!is_null($yOffset)) {
+					$this->setTopLeftYOffset($yOffset);
+		}
 
 		return $this;
 	}
@@ -375,10 +379,12 @@ 
 	 */
 	public function setBottomRightPosition($cell, $xOffset=null, $yOffset=null) {
 		$this->_bottomRightCellRef = $cell;
-		if (!is_null($xOffset))
-			$this->setBottomRightXOffset($xOffset);
-		if (!is_null($yOffset))
-			$this->setBottomRightYOffset($yOffset);
+		if (!is_null($xOffset)) {
+					$this->setBottomRightXOffset($xOffset);
+		}
+		if (!is_null($yOffset)) {
+					$this->setBottomRightYOffset($yOffset);
+		}
 
 		return $this;
 	}
@@ -411,10 +417,12 @@ 
 	}
 
 	public function setBottomRightOffset($xOffset=null,$yOffset=null) {
-		if (!is_null($xOffset))
-			$this->setBottomRightXOffset($xOffset);
-		if (!is_null($yOffset))
-			$this->setBottomRightYOffset($yOffset);
+		if (!is_null($xOffset)) {
+					$this->setBottomRightXOffset($xOffset);
+		}
+		if (!is_null($yOffset)) {
+					$this->setBottomRightYOffset($yOffset);
+		}
 
 		return $this;
 	}

app/Vendor/PHPExcel/PHPExcel/Chart/Layout.php

Spacing +14 added lines, -14 removed lines

@@ -47,56 +47,56 @@
 	 *
 	 * @var string
 	 */
-	private $_xMode		= null;
+	private $_xMode = null;
 
 	/**
 	 * Y Mode
 	 *
 	 * @var string
 	 */
-	private $_yMode		= null;
+	private $_yMode = null;
 
 	/**
 	 * X-Position
 	 *
 	 * @var float
 	 */
-	private $_xPos		= null;
+	private $_xPos = null;
 
 	/**
 	 * Y-Position
 	 *
 	 * @var float
 	 */
-	private $_yPos		= null;
+	private $_yPos = null;
 
 	/**
 	 * width
 	 *
 	 * @var float
 	 */
-	private $_width		= null;
+	private $_width = null;
 
 	/**
 	 * height
 	 *
 	 * @var float
 	 */
-	private $_height	= null;
+	private $_height = null;
 
 
 	/**
 	 * Create a new PHPExcel_Chart_Layout
 	 */
-	public function __construct($layout=array())
+	public function __construct($layout = array())
 	{
-		if (isset($layout['layoutTarget']))	{ $this->_layoutTarget	= $layout['layoutTarget'];	}
-		if (isset($layout['xMode']))		{ $this->_xMode			= $layout['xMode'];			}
-		if (isset($layout['yMode']))		{ $this->_yMode			= $layout['yMode'];			}
-		if (isset($layout['x']))			{ $this->_xPos			= (float) $layout['x'];		}
-		if (isset($layout['y']))			{ $this->_yPos			= (float) $layout['y'];		}
-		if (isset($layout['w']))			{ $this->_width			= (float) $layout['w'];		}
-		if (isset($layout['h']))			{ $this->_height		= (float) $layout['h'];		}
+		if (isset($layout['layoutTarget'])) { $this->_layoutTarget = $layout['layoutTarget']; }
+		if (isset($layout['xMode'])) { $this->_xMode			= $layout['xMode']; }
+		if (isset($layout['yMode'])) { $this->_yMode			= $layout['yMode']; }
+		if (isset($layout['x'])) { $this->_xPos			= (float) $layout['x']; }
+		if (isset($layout['y'])) { $this->_yPos			= (float) $layout['y']; }
+		if (isset($layout['w'])) { $this->_width			= (float) $layout['w']; }
+		if (isset($layout['h'])) { $this->_height		= (float) $layout['h']; }
 	}
 
 	/**

app/Vendor/PHPExcel/PHPExcel/Chart/Legend.php

Indentation +1 added lines, -1 removed lines

@@ -55,7 +55,7 @@
 										   self::xlLegendPositionLeft	=> self::POSITION_LEFT,
 										   self::xlLegendPositionRight	=> self::POSITION_RIGHT,
 										   self::xlLegendPositionTop	=> self::POSITION_TOP
-									     );
+										 );
 
 	/**
 	 * Legend position

Spacing +15 added lines, -15 removed lines

@@ -36,20 +36,20 @@ 
 class PHPExcel_Chart_Legend
 {
 	/** Legend positions */
-	const xlLegendPositionBottom	= -4107;	//	Below the chart.
-	const xlLegendPositionCorner	= 2;		//	In the upper right-hand corner of the chart border.
-	const xlLegendPositionCustom	= -4161;	//	A custom position.
-	const xlLegendPositionLeft		= -4131;	//	Left of the chart.
-	const xlLegendPositionRight		= -4152;	//	Right of the chart.
-	const xlLegendPositionTop		= -4160;	//	Above the chart.
+	const xlLegendPositionBottom	= -4107; //	Below the chart.
+	const xlLegendPositionCorner	= 2; //	In the upper right-hand corner of the chart border.
+	const xlLegendPositionCustom	= -4161; //	A custom position.
+	const xlLegendPositionLeft = -4131; //	Left of the chart.
+	const xlLegendPositionRight		= -4152; //	Right of the chart.
+	const xlLegendPositionTop = -4160; //	Above the chart.
 
 	const POSITION_RIGHT	= 'r';
 	const POSITION_LEFT		= 'l';
-	const POSITION_BOTTOM	= 'b';
-	const POSITION_TOP		= 't';
-	const POSITION_TOPRIGHT	= 'tr';
+	const POSITION_BOTTOM = 'b';
+	const POSITION_TOP = 't';
+	const POSITION_TOPRIGHT = 'tr';
 
-	private static $_positionXref = array( self::xlLegendPositionBottom	=> self::POSITION_BOTTOM,
+	private static $_positionXref = array(self::xlLegendPositionBottom	=> self::POSITION_BOTTOM,
 										   self::xlLegendPositionCorner	=> self::POSITION_TOPRIGHT,
 										   self::xlLegendPositionCustom	=> '??',
 										   self::xlLegendPositionLeft	=> self::POSITION_LEFT,
@@ -82,7 +82,7 @@ 
 	/**
 	 *	Create a new PHPExcel_Chart_Legend
 	 */
-	public function __construct($position = null, PHPExcel_Chart_Layout $layout = null, $overlay= false)
+	public function __construct($position = null, PHPExcel_Chart_Layout $layout = null, $overlay = false)
 	{
 		$this->_position = $position;
 		$this->_layout = $layout;
@@ -104,7 +104,7 @@ 
 	 * @param	string	$position
 	 */
 	public function setPosition($position = self::POSITION_RIGHT) {
-		if (!in_array($position,self::$positionXref)) {
+		if ( ! in_array($position, self::$positionXref)) {
 			return false;
 		}
 
@@ -119,7 +119,7 @@ 
 	 * @return	number
 	 */
 	public function getPositionXL() {
-		return array_search($this->_position,self::$positionXref);
+		return array_search($this->_position, self::$positionXref);
 	}
 
 	/**
@@ -128,7 +128,7 @@ 
 	 * @param	number	$positionXL
 	 */
 	public function setPositionXL($positionXL = self::xlLegendPositionRight) {
-		if (!array_key_exists($positionXL,self::$positionXref)) {
+		if ( ! array_key_exists($positionXL, self::$positionXref)) {
 			return false;
 		}
 
@@ -150,7 +150,7 @@ 
 	 *
 	 * @param	boolean	$value
 	 */
-	public function setOverlay($value=false) {
+	public function setOverlay($value = false) {
 		$this->_overlay = $value;
 	}