@@ -110,7 +110,7 @@ |
||
| 110 | 110 | * Fallback method for writeRaw, introduced in PHP 5.2 |
| 111 | 111 | * |
| 112 | 112 | * @param string $text |
| 113 | - * @return string |
|
| 113 | + * @return boolean |
|
| 114 | 114 | */ |
| 115 | 115 | public function writeRawData($text) |
| 116 | 116 | { |
@@ -25,11 +25,11 @@ discard block |
||
| 25 | 25 | * @version 1.7.7, 2012-05-19 |
| 26 | 26 | */ |
| 27 | 27 | |
| 28 | -if (!defined('DATE_W3C')) { |
|
| 28 | +if ( ! defined('DATE_W3C')) { |
|
| 29 | 29 | define('DATE_W3C', 'Y-m-d\TH:i:sP'); |
| 30 | 30 | } |
| 31 | 31 | |
| 32 | -if (!defined('DEBUGMODE_ENABLED')) { |
|
| 32 | +if ( ! defined('DEBUGMODE_ENABLED')) { |
|
| 33 | 33 | define('DEBUGMODE_ENABLED', false); |
| 34 | 34 | } |
| 35 | 35 | |
@@ -43,8 +43,8 @@ discard block |
||
| 43 | 43 | */ |
| 44 | 44 | class PHPExcel_Shared_XMLWriter extends XMLWriter { |
| 45 | 45 | /** Temporary storage method */ |
| 46 | - const STORAGE_MEMORY = 1; |
|
| 47 | - const STORAGE_DISK = 2; |
|
| 46 | + const STORAGE_MEMORY = 1; |
|
| 47 | + const STORAGE_DISK = 2; |
|
| 48 | 48 | |
| 49 | 49 | /** |
| 50 | 50 | * Temporary filename |
@@ -65,8 +65,9 @@ |
||
| 65 | 65 | $this->openMemory(); |
| 66 | 66 | } else { |
| 67 | 67 | // Create temporary filename |
| 68 | - if ($pTemporaryStorageFolder === NULL) |
|
| 69 | - $pTemporaryStorageFolder = PHPExcel_Shared_File::sys_get_temp_dir(); |
|
| 68 | + if ($pTemporaryStorageFolder === NULL) { |
|
| 69 | + $pTemporaryStorageFolder = PHPExcel_Shared_File::sys_get_temp_dir(); |
|
| 70 | + } |
|
| 70 | 71 | $this->_tempFileName = @tempnam($pTemporaryStorageFolder, 'xml'); |
| 71 | 72 | |
| 72 | 73 | // Open storage |
@@ -145,7 +145,7 @@ |
||
| 145 | 145 | * |
| 146 | 146 | * @param int $offset byte offset |
| 147 | 147 | * @param int $whence SEEK_SET, SEEK_CUR or SEEK_END |
| 148 | - * @return bool |
|
| 148 | + * @return boolean|null |
|
| 149 | 149 | */ |
| 150 | 150 | public function stream_seek($offset, $whence) { |
| 151 | 151 | switch ($whence) { |
@@ -39,38 +39,38 @@ discard block |
||
| 39 | 39 | * |
| 40 | 40 | * @var ZipAcrhive |
| 41 | 41 | */ |
| 42 | - private $_archive; |
|
| 43 | - |
|
| 44 | - /** |
|
| 45 | - * Filename in ZipAcrhive |
|
| 46 | - * |
|
| 47 | - * @var string |
|
| 48 | - */ |
|
| 49 | - private $_fileNameInArchive = ''; |
|
| 50 | - |
|
| 51 | - /** |
|
| 52 | - * Position in file |
|
| 53 | - * |
|
| 54 | - * @var int |
|
| 55 | - */ |
|
| 56 | - private $_position = 0; |
|
| 57 | - |
|
| 58 | - /** |
|
| 59 | - * Data |
|
| 60 | - * |
|
| 61 | - * @var mixed |
|
| 62 | - */ |
|
| 63 | - private $_data = ''; |
|
| 64 | - |
|
| 65 | - /** |
|
| 66 | - * Register wrapper |
|
| 67 | - */ |
|
| 68 | - public static function register() { |
|
| 42 | + private $_archive; |
|
| 43 | + |
|
| 44 | + /** |
|
| 45 | + * Filename in ZipAcrhive |
|
| 46 | + * |
|
| 47 | + * @var string |
|
| 48 | + */ |
|
| 49 | + private $_fileNameInArchive = ''; |
|
| 50 | + |
|
| 51 | + /** |
|
| 52 | + * Position in file |
|
| 53 | + * |
|
| 54 | + * @var int |
|
| 55 | + */ |
|
| 56 | + private $_position = 0; |
|
| 57 | + |
|
| 58 | + /** |
|
| 59 | + * Data |
|
| 60 | + * |
|
| 61 | + * @var mixed |
|
| 62 | + */ |
|
| 63 | + private $_data = ''; |
|
| 64 | + |
|
| 65 | + /** |
|
| 66 | + * Register wrapper |
|
| 67 | + */ |
|
| 68 | + public static function register() { |
|
| 69 | 69 | @stream_wrapper_unregister("zip"); |
| 70 | 70 | @stream_wrapper_register("zip", __CLASS__); |
| 71 | - } |
|
| 71 | + } |
|
| 72 | 72 | |
| 73 | - /** |
|
| 73 | + /** |
|
| 74 | 74 | * Implements support for fopen(). |
| 75 | 75 | * |
| 76 | 76 | * @param string $path resource name including scheme, e.g. |
@@ -78,106 +78,106 @@ discard block |
||
| 78 | 78 | * @param int $options mask of STREAM_REPORT_ERRORS and STREAM_USE_PATH |
| 79 | 79 | * @param string &$openedPath absolute path of the opened stream (out parameter) |
| 80 | 80 | * @return bool true on success |
| 81 | - */ |
|
| 82 | - public function stream_open($path, $mode, $options, &$opened_path) { |
|
| 83 | - // Check for mode |
|
| 84 | - if ($mode{0} != 'r') { |
|
| 85 | - throw new Exception('Mode ' . $mode . ' is not supported. Only read mode is supported.'); |
|
| 86 | - } |
|
| 81 | + */ |
|
| 82 | + public function stream_open($path, $mode, $options, &$opened_path) { |
|
| 83 | + // Check for mode |
|
| 84 | + if ($mode{0} != 'r') { |
|
| 85 | + throw new Exception('Mode ' . $mode . ' is not supported. Only read mode is supported.'); |
|
| 86 | + } |
|
| 87 | 87 | |
| 88 | 88 | $pos = strrpos($path, '#'); |
| 89 | 89 | $url['host'] = substr($path, 6, $pos - 6); // 6: strlen('zip://') |
| 90 | 90 | $url['fragment'] = substr($path, $pos + 1); |
| 91 | 91 | |
| 92 | - // Open archive |
|
| 93 | - $this->_archive = new ZipArchive(); |
|
| 94 | - $this->_archive->open($url['host']); |
|
| 92 | + // Open archive |
|
| 93 | + $this->_archive = new ZipArchive(); |
|
| 94 | + $this->_archive->open($url['host']); |
|
| 95 | 95 | |
| 96 | - $this->_fileNameInArchive = $url['fragment']; |
|
| 97 | - $this->_position = 0; |
|
| 98 | - $this->_data = $this->_archive->getFromName( $this->_fileNameInArchive ); |
|
| 96 | + $this->_fileNameInArchive = $url['fragment']; |
|
| 97 | + $this->_position = 0; |
|
| 98 | + $this->_data = $this->_archive->getFromName( $this->_fileNameInArchive ); |
|
| 99 | 99 | |
| 100 | - return true; |
|
| 101 | - } |
|
| 100 | + return true; |
|
| 101 | + } |
|
| 102 | 102 | |
| 103 | - /** |
|
| 103 | + /** |
|
| 104 | 104 | * Implements support for fstat(). |
| 105 | 105 | * |
| 106 | 106 | * @return boolean |
| 107 | - */ |
|
| 108 | - public function stream_stat() { |
|
| 109 | - return $this->_archive->statName( $this->_fileNameInArchive ); |
|
| 110 | - } |
|
| 107 | + */ |
|
| 108 | + public function stream_stat() { |
|
| 109 | + return $this->_archive->statName( $this->_fileNameInArchive ); |
|
| 110 | + } |
|
| 111 | 111 | |
| 112 | - /** |
|
| 112 | + /** |
|
| 113 | 113 | * Implements support for fread(), fgets() etc. |
| 114 | 114 | * |
| 115 | 115 | * @param int $count maximum number of bytes to read |
| 116 | 116 | * @return string |
| 117 | - */ |
|
| 118 | - function stream_read($count) { |
|
| 119 | - $ret = substr($this->_data, $this->_position, $count); |
|
| 120 | - $this->_position += strlen($ret); |
|
| 121 | - return $ret; |
|
| 122 | - } |
|
| 123 | - |
|
| 124 | - /** |
|
| 117 | + */ |
|
| 118 | + function stream_read($count) { |
|
| 119 | + $ret = substr($this->_data, $this->_position, $count); |
|
| 120 | + $this->_position += strlen($ret); |
|
| 121 | + return $ret; |
|
| 122 | + } |
|
| 123 | + |
|
| 124 | + /** |
|
| 125 | 125 | * Returns the position of the file pointer, i.e. its offset into the file |
| 126 | 126 | * stream. Implements support for ftell(). |
| 127 | 127 | * |
| 128 | 128 | * @return int |
| 129 | - */ |
|
| 130 | - public function stream_tell() { |
|
| 131 | - return $this->_position; |
|
| 132 | - } |
|
| 129 | + */ |
|
| 130 | + public function stream_tell() { |
|
| 131 | + return $this->_position; |
|
| 132 | + } |
|
| 133 | 133 | |
| 134 | - /** |
|
| 135 | - * EOF stream |
|
| 134 | + /** |
|
| 135 | + * EOF stream |
|
| 136 | 136 | * |
| 137 | 137 | * @return bool |
| 138 | - */ |
|
| 139 | - public function stream_eof() { |
|
| 140 | - return $this->_position >= strlen($this->_data); |
|
| 141 | - } |
|
| 138 | + */ |
|
| 139 | + public function stream_eof() { |
|
| 140 | + return $this->_position >= strlen($this->_data); |
|
| 141 | + } |
|
| 142 | 142 | |
| 143 | - /** |
|
| 144 | - * Seek stream |
|
| 143 | + /** |
|
| 144 | + * Seek stream |
|
| 145 | 145 | * |
| 146 | 146 | * @param int $offset byte offset |
| 147 | 147 | * @param int $whence SEEK_SET, SEEK_CUR or SEEK_END |
| 148 | 148 | * @return bool |
| 149 | - */ |
|
| 150 | - public function stream_seek($offset, $whence) { |
|
| 151 | - switch ($whence) { |
|
| 152 | - case SEEK_SET: |
|
| 153 | - if ($offset < strlen($this->_data) && $offset >= 0) { |
|
| 154 | - $this->_position = $offset; |
|
| 155 | - return true; |
|
| 156 | - } else { |
|
| 157 | - return false; |
|
| 158 | - } |
|
| 159 | - break; |
|
| 160 | - |
|
| 161 | - case SEEK_CUR: |
|
| 162 | - if ($offset >= 0) { |
|
| 163 | - $this->_position += $offset; |
|
| 164 | - return true; |
|
| 165 | - } else { |
|
| 166 | - return false; |
|
| 167 | - } |
|
| 168 | - break; |
|
| 169 | - |
|
| 170 | - case SEEK_END: |
|
| 171 | - if (strlen($this->_data) + $offset >= 0) { |
|
| 172 | - $this->_position = strlen($this->_data) + $offset; |
|
| 173 | - return true; |
|
| 174 | - } else { |
|
| 175 | - return false; |
|
| 176 | - } |
|
| 177 | - break; |
|
| 178 | - |
|
| 179 | - default: |
|
| 180 | - return false; |
|
| 181 | - } |
|
| 182 | - } |
|
| 149 | + */ |
|
| 150 | + public function stream_seek($offset, $whence) { |
|
| 151 | + switch ($whence) { |
|
| 152 | + case SEEK_SET: |
|
| 153 | + if ($offset < strlen($this->_data) && $offset >= 0) { |
|
| 154 | + $this->_position = $offset; |
|
| 155 | + return true; |
|
| 156 | + } else { |
|
| 157 | + return false; |
|
| 158 | + } |
|
| 159 | + break; |
|
| 160 | + |
|
| 161 | + case SEEK_CUR: |
|
| 162 | + if ($offset >= 0) { |
|
| 163 | + $this->_position += $offset; |
|
| 164 | + return true; |
|
| 165 | + } else { |
|
| 166 | + return false; |
|
| 167 | + } |
|
| 168 | + break; |
|
| 169 | + |
|
| 170 | + case SEEK_END: |
|
| 171 | + if (strlen($this->_data) + $offset >= 0) { |
|
| 172 | + $this->_position = strlen($this->_data) + $offset; |
|
| 173 | + return true; |
|
| 174 | + } else { |
|
| 175 | + return false; |
|
| 176 | + } |
|
| 177 | + break; |
|
| 178 | + |
|
| 179 | + default: |
|
| 180 | + return false; |
|
| 181 | + } |
|
| 182 | + } |
|
| 183 | 183 | } |
@@ -82,7 +82,7 @@ discard block |
||
| 82 | 82 | public function stream_open($path, $mode, $options, &$opened_path) { |
| 83 | 83 | // Check for mode |
| 84 | 84 | if ($mode{0} != 'r') { |
| 85 | - throw new Exception('Mode ' . $mode . ' is not supported. Only read mode is supported.'); |
|
| 85 | + throw new Exception('Mode '.$mode.' is not supported. Only read mode is supported.'); |
|
| 86 | 86 | } |
| 87 | 87 | |
| 88 | 88 | $pos = strrpos($path, '#'); |
@@ -95,7 +95,7 @@ discard block |
||
| 95 | 95 | |
| 96 | 96 | $this->_fileNameInArchive = $url['fragment']; |
| 97 | 97 | $this->_position = 0; |
| 98 | - $this->_data = $this->_archive->getFromName( $this->_fileNameInArchive ); |
|
| 98 | + $this->_data = $this->_archive->getFromName($this->_fileNameInArchive); |
|
| 99 | 99 | |
| 100 | 100 | return true; |
| 101 | 101 | } |
@@ -106,7 +106,7 @@ discard block |
||
| 106 | 106 | * @return boolean |
| 107 | 107 | */ |
| 108 | 108 | public function stream_stat() { |
| 109 | - return $this->_archive->statName( $this->_fileNameInArchive ); |
|
| 109 | + return $this->_archive->statName($this->_fileNameInArchive); |
|
| 110 | 110 | } |
| 111 | 111 | |
| 112 | 112 | /** |
@@ -106,7 +106,7 @@ discard block |
||
| 106 | 106 | /** |
| 107 | 107 | * Get Condition type |
| 108 | 108 | * |
| 109 | - * @return string |
|
| 109 | + * @return integer |
|
| 110 | 110 | */ |
| 111 | 111 | public function getConditionType() { |
| 112 | 112 | return $this->_conditionType; |
@@ -126,7 +126,7 @@ discard block |
||
| 126 | 126 | /** |
| 127 | 127 | * Get Operator type |
| 128 | 128 | * |
| 129 | - * @return string |
|
| 129 | + * @return integer |
|
| 130 | 130 | */ |
| 131 | 131 | public function getOperatorType() { |
| 132 | 132 | return $this->_operatorType; |
@@ -36,24 +36,24 @@ discard block |
||
| 36 | 36 | class PHPExcel_Style_Conditional implements PHPExcel_IComparable |
| 37 | 37 | { |
| 38 | 38 | /* Condition types */ |
| 39 | - const CONDITION_NONE = 'none'; |
|
| 40 | - const CONDITION_CELLIS = 'cellIs'; |
|
| 39 | + const CONDITION_NONE = 'none'; |
|
| 40 | + const CONDITION_CELLIS = 'cellIs'; |
|
| 41 | 41 | const CONDITION_CONTAINSTEXT = 'containsText'; |
| 42 | 42 | const CONDITION_EXPRESSION = 'expression'; |
| 43 | 43 | |
| 44 | 44 | /* Operator types */ |
| 45 | 45 | const OPERATOR_NONE = ''; |
| 46 | - const OPERATOR_BEGINSWITH = 'beginsWith'; |
|
| 47 | - const OPERATOR_ENDSWITH = 'endsWith'; |
|
| 46 | + const OPERATOR_BEGINSWITH = 'beginsWith'; |
|
| 47 | + const OPERATOR_ENDSWITH = 'endsWith'; |
|
| 48 | 48 | const OPERATOR_EQUAL = 'equal'; |
| 49 | - const OPERATOR_GREATERTHAN = 'greaterThan'; |
|
| 50 | - const OPERATOR_GREATERTHANOREQUAL = 'greaterThanOrEqual'; |
|
| 49 | + const OPERATOR_GREATERTHAN = 'greaterThan'; |
|
| 50 | + const OPERATOR_GREATERTHANOREQUAL = 'greaterThanOrEqual'; |
|
| 51 | 51 | const OPERATOR_LESSTHAN = 'lessThan'; |
| 52 | - const OPERATOR_LESSTHANOREQUAL = 'lessThanOrEqual'; |
|
| 52 | + const OPERATOR_LESSTHANOREQUAL = 'lessThanOrEqual'; |
|
| 53 | 53 | const OPERATOR_NOTEQUAL = 'notEqual'; |
| 54 | - const OPERATOR_CONTAINSTEXT = 'containsText'; |
|
| 55 | - const OPERATOR_NOTCONTAINS = 'notContains'; |
|
| 56 | - const OPERATOR_BETWEEN = 'between'; |
|
| 54 | + const OPERATOR_CONTAINSTEXT = 'containsText'; |
|
| 55 | + const OPERATOR_NOTCONTAINS = 'notContains'; |
|
| 56 | + const OPERATOR_BETWEEN = 'between'; |
|
| 57 | 57 | |
| 58 | 58 | /** |
| 59 | 59 | * Condition type |
@@ -96,11 +96,11 @@ discard block |
||
| 96 | 96 | public function __construct() |
| 97 | 97 | { |
| 98 | 98 | // Initialise values |
| 99 | - $this->_conditionType = PHPExcel_Style_Conditional::CONDITION_NONE; |
|
| 100 | - $this->_operatorType = PHPExcel_Style_Conditional::OPERATOR_NONE; |
|
| 101 | - $this->_text = null; |
|
| 102 | - $this->_condition = array(); |
|
| 103 | - $this->_style = new PHPExcel_Style(); |
|
| 99 | + $this->_conditionType = PHPExcel_Style_Conditional::CONDITION_NONE; |
|
| 100 | + $this->_operatorType = PHPExcel_Style_Conditional::OPERATOR_NONE; |
|
| 101 | + $this->_text = null; |
|
| 102 | + $this->_condition = array(); |
|
| 103 | + $this->_style = new PHPExcel_Style(); |
|
| 104 | 104 | } |
| 105 | 105 | |
| 106 | 106 | /** |
@@ -185,7 +185,7 @@ discard block |
||
| 185 | 185 | * @return PHPExcel_Style_Conditional |
| 186 | 186 | */ |
| 187 | 187 | public function setCondition($pValue = '') { |
| 188 | - if (!is_array($pValue)) |
|
| 188 | + if ( ! is_array($pValue)) |
|
| 189 | 189 | $pValue = array($pValue); |
| 190 | 190 | |
| 191 | 191 | return $this->setConditions($pValue); |
@@ -207,7 +207,7 @@ discard block |
||
| 207 | 207 | * @return PHPExcel_Style_Conditional |
| 208 | 208 | */ |
| 209 | 209 | public function setConditions($pValue) { |
| 210 | - if (!is_array($pValue)) |
|
| 210 | + if ( ! is_array($pValue)) |
|
| 211 | 211 | $pValue = array($pValue); |
| 212 | 212 | |
| 213 | 213 | $this->_condition = $pValue; |
@@ -185,8 +185,9 @@ discard block |
||
| 185 | 185 | * @return PHPExcel_Style_Conditional |
| 186 | 186 | */ |
| 187 | 187 | public function setCondition($pValue = '') { |
| 188 | - if (!is_array($pValue)) |
|
| 189 | - $pValue = array($pValue); |
|
| 188 | + if (!is_array($pValue)) { |
|
| 189 | + $pValue = array($pValue); |
|
| 190 | + } |
|
| 190 | 191 | |
| 191 | 192 | return $this->setConditions($pValue); |
| 192 | 193 | } |
@@ -207,8 +208,9 @@ discard block |
||
| 207 | 208 | * @return PHPExcel_Style_Conditional |
| 208 | 209 | */ |
| 209 | 210 | public function setConditions($pValue) { |
| 210 | - if (!is_array($pValue)) |
|
| 211 | - $pValue = array($pValue); |
|
| 211 | + if (!is_array($pValue)) { |
|
| 212 | + $pValue = array($pValue); |
|
| 213 | + } |
|
| 212 | 214 | |
| 213 | 215 | $this->_condition = $pValue; |
| 214 | 216 | return $this; |
@@ -90,161 +90,161 @@ discard block |
||
| 90 | 90 | */ |
| 91 | 91 | private $_style; |
| 92 | 92 | |
| 93 | - /** |
|
| 94 | - * Create a new PHPExcel_Style_Conditional |
|
| 95 | - */ |
|
| 96 | - public function __construct() |
|
| 97 | - { |
|
| 98 | - // Initialise values |
|
| 99 | - $this->_conditionType = PHPExcel_Style_Conditional::CONDITION_NONE; |
|
| 100 | - $this->_operatorType = PHPExcel_Style_Conditional::OPERATOR_NONE; |
|
| 101 | - $this->_text = null; |
|
| 102 | - $this->_condition = array(); |
|
| 103 | - $this->_style = new PHPExcel_Style(); |
|
| 104 | - } |
|
| 93 | + /** |
|
| 94 | + * Create a new PHPExcel_Style_Conditional |
|
| 95 | + */ |
|
| 96 | + public function __construct() |
|
| 97 | + { |
|
| 98 | + // Initialise values |
|
| 99 | + $this->_conditionType = PHPExcel_Style_Conditional::CONDITION_NONE; |
|
| 100 | + $this->_operatorType = PHPExcel_Style_Conditional::OPERATOR_NONE; |
|
| 101 | + $this->_text = null; |
|
| 102 | + $this->_condition = array(); |
|
| 103 | + $this->_style = new PHPExcel_Style(); |
|
| 104 | + } |
|
| 105 | 105 | |
| 106 | - /** |
|
| 107 | - * Get Condition type |
|
| 108 | - * |
|
| 109 | - * @return string |
|
| 110 | - */ |
|
| 111 | - public function getConditionType() { |
|
| 112 | - return $this->_conditionType; |
|
| 113 | - } |
|
| 106 | + /** |
|
| 107 | + * Get Condition type |
|
| 108 | + * |
|
| 109 | + * @return string |
|
| 110 | + */ |
|
| 111 | + public function getConditionType() { |
|
| 112 | + return $this->_conditionType; |
|
| 113 | + } |
|
| 114 | 114 | |
| 115 | - /** |
|
| 116 | - * Set Condition type |
|
| 117 | - * |
|
| 118 | - * @param string $pValue PHPExcel_Style_Conditional condition type |
|
| 119 | - * @return PHPExcel_Style_Conditional |
|
| 120 | - */ |
|
| 121 | - public function setConditionType($pValue = PHPExcel_Style_Conditional::CONDITION_NONE) { |
|
| 122 | - $this->_conditionType = $pValue; |
|
| 123 | - return $this; |
|
| 124 | - } |
|
| 115 | + /** |
|
| 116 | + * Set Condition type |
|
| 117 | + * |
|
| 118 | + * @param string $pValue PHPExcel_Style_Conditional condition type |
|
| 119 | + * @return PHPExcel_Style_Conditional |
|
| 120 | + */ |
|
| 121 | + public function setConditionType($pValue = PHPExcel_Style_Conditional::CONDITION_NONE) { |
|
| 122 | + $this->_conditionType = $pValue; |
|
| 123 | + return $this; |
|
| 124 | + } |
|
| 125 | 125 | |
| 126 | - /** |
|
| 127 | - * Get Operator type |
|
| 128 | - * |
|
| 129 | - * @return string |
|
| 130 | - */ |
|
| 131 | - public function getOperatorType() { |
|
| 132 | - return $this->_operatorType; |
|
| 133 | - } |
|
| 126 | + /** |
|
| 127 | + * Get Operator type |
|
| 128 | + * |
|
| 129 | + * @return string |
|
| 130 | + */ |
|
| 131 | + public function getOperatorType() { |
|
| 132 | + return $this->_operatorType; |
|
| 133 | + } |
|
| 134 | 134 | |
| 135 | - /** |
|
| 136 | - * Set Operator type |
|
| 137 | - * |
|
| 138 | - * @param string $pValue PHPExcel_Style_Conditional operator type |
|
| 139 | - * @return PHPExcel_Style_Conditional |
|
| 140 | - */ |
|
| 141 | - public function setOperatorType($pValue = PHPExcel_Style_Conditional::OPERATOR_NONE) { |
|
| 142 | - $this->_operatorType = $pValue; |
|
| 143 | - return $this; |
|
| 144 | - } |
|
| 135 | + /** |
|
| 136 | + * Set Operator type |
|
| 137 | + * |
|
| 138 | + * @param string $pValue PHPExcel_Style_Conditional operator type |
|
| 139 | + * @return PHPExcel_Style_Conditional |
|
| 140 | + */ |
|
| 141 | + public function setOperatorType($pValue = PHPExcel_Style_Conditional::OPERATOR_NONE) { |
|
| 142 | + $this->_operatorType = $pValue; |
|
| 143 | + return $this; |
|
| 144 | + } |
|
| 145 | 145 | |
| 146 | - /** |
|
| 147 | - * Get text |
|
| 148 | - * |
|
| 149 | - * @return string |
|
| 150 | - */ |
|
| 151 | - public function getText() { |
|
| 152 | - return $this->_text; |
|
| 153 | - } |
|
| 146 | + /** |
|
| 147 | + * Get text |
|
| 148 | + * |
|
| 149 | + * @return string |
|
| 150 | + */ |
|
| 151 | + public function getText() { |
|
| 152 | + return $this->_text; |
|
| 153 | + } |
|
| 154 | 154 | |
| 155 | - /** |
|
| 156 | - * Set text |
|
| 157 | - * |
|
| 158 | - * @param string $value |
|
| 159 | - * @return PHPExcel_Style_Conditional |
|
| 160 | - */ |
|
| 161 | - public function setText($value = null) { |
|
| 162 | - $this->_text = $value; |
|
| 163 | - return $this; |
|
| 164 | - } |
|
| 155 | + /** |
|
| 156 | + * Set text |
|
| 157 | + * |
|
| 158 | + * @param string $value |
|
| 159 | + * @return PHPExcel_Style_Conditional |
|
| 160 | + */ |
|
| 161 | + public function setText($value = null) { |
|
| 162 | + $this->_text = $value; |
|
| 163 | + return $this; |
|
| 164 | + } |
|
| 165 | 165 | |
| 166 | - /** |
|
| 167 | - * Get Condition |
|
| 168 | - * |
|
| 169 | - * @deprecated Deprecated, use getConditions instead |
|
| 170 | - * @return string |
|
| 171 | - */ |
|
| 172 | - public function getCondition() { |
|
| 173 | - if (isset($this->_condition[0])) { |
|
| 174 | - return $this->_condition[0]; |
|
| 175 | - } |
|
| 166 | + /** |
|
| 167 | + * Get Condition |
|
| 168 | + * |
|
| 169 | + * @deprecated Deprecated, use getConditions instead |
|
| 170 | + * @return string |
|
| 171 | + */ |
|
| 172 | + public function getCondition() { |
|
| 173 | + if (isset($this->_condition[0])) { |
|
| 174 | + return $this->_condition[0]; |
|
| 175 | + } |
|
| 176 | 176 | |
| 177 | - return ''; |
|
| 178 | - } |
|
| 177 | + return ''; |
|
| 178 | + } |
|
| 179 | 179 | |
| 180 | - /** |
|
| 181 | - * Set Condition |
|
| 182 | - * |
|
| 183 | - * @deprecated Deprecated, use setConditions instead |
|
| 184 | - * @param string $pValue Condition |
|
| 185 | - * @return PHPExcel_Style_Conditional |
|
| 186 | - */ |
|
| 187 | - public function setCondition($pValue = '') { |
|
| 188 | - if (!is_array($pValue)) |
|
| 189 | - $pValue = array($pValue); |
|
| 180 | + /** |
|
| 181 | + * Set Condition |
|
| 182 | + * |
|
| 183 | + * @deprecated Deprecated, use setConditions instead |
|
| 184 | + * @param string $pValue Condition |
|
| 185 | + * @return PHPExcel_Style_Conditional |
|
| 186 | + */ |
|
| 187 | + public function setCondition($pValue = '') { |
|
| 188 | + if (!is_array($pValue)) |
|
| 189 | + $pValue = array($pValue); |
|
| 190 | 190 | |
| 191 | - return $this->setConditions($pValue); |
|
| 192 | - } |
|
| 191 | + return $this->setConditions($pValue); |
|
| 192 | + } |
|
| 193 | 193 | |
| 194 | - /** |
|
| 195 | - * Get Conditions |
|
| 196 | - * |
|
| 197 | - * @return string[] |
|
| 198 | - */ |
|
| 199 | - public function getConditions() { |
|
| 200 | - return $this->_condition; |
|
| 201 | - } |
|
| 194 | + /** |
|
| 195 | + * Get Conditions |
|
| 196 | + * |
|
| 197 | + * @return string[] |
|
| 198 | + */ |
|
| 199 | + public function getConditions() { |
|
| 200 | + return $this->_condition; |
|
| 201 | + } |
|
| 202 | 202 | |
| 203 | - /** |
|
| 204 | - * Set Conditions |
|
| 205 | - * |
|
| 206 | - * @param string[] $pValue Condition |
|
| 207 | - * @return PHPExcel_Style_Conditional |
|
| 208 | - */ |
|
| 209 | - public function setConditions($pValue) { |
|
| 210 | - if (!is_array($pValue)) |
|
| 211 | - $pValue = array($pValue); |
|
| 203 | + /** |
|
| 204 | + * Set Conditions |
|
| 205 | + * |
|
| 206 | + * @param string[] $pValue Condition |
|
| 207 | + * @return PHPExcel_Style_Conditional |
|
| 208 | + */ |
|
| 209 | + public function setConditions($pValue) { |
|
| 210 | + if (!is_array($pValue)) |
|
| 211 | + $pValue = array($pValue); |
|
| 212 | 212 | |
| 213 | - $this->_condition = $pValue; |
|
| 214 | - return $this; |
|
| 215 | - } |
|
| 213 | + $this->_condition = $pValue; |
|
| 214 | + return $this; |
|
| 215 | + } |
|
| 216 | 216 | |
| 217 | - /** |
|
| 218 | - * Add Condition |
|
| 219 | - * |
|
| 220 | - * @param string $pValue Condition |
|
| 221 | - * @return PHPExcel_Style_Conditional |
|
| 222 | - */ |
|
| 223 | - public function addCondition($pValue = '') { |
|
| 224 | - $this->_condition[] = $pValue; |
|
| 225 | - return $this; |
|
| 226 | - } |
|
| 217 | + /** |
|
| 218 | + * Add Condition |
|
| 219 | + * |
|
| 220 | + * @param string $pValue Condition |
|
| 221 | + * @return PHPExcel_Style_Conditional |
|
| 222 | + */ |
|
| 223 | + public function addCondition($pValue = '') { |
|
| 224 | + $this->_condition[] = $pValue; |
|
| 225 | + return $this; |
|
| 226 | + } |
|
| 227 | 227 | |
| 228 | - /** |
|
| 229 | - * Get Style |
|
| 230 | - * |
|
| 231 | - * @return PHPExcel_Style |
|
| 232 | - */ |
|
| 233 | - public function getStyle() { |
|
| 234 | - return $this->_style; |
|
| 235 | - } |
|
| 228 | + /** |
|
| 229 | + * Get Style |
|
| 230 | + * |
|
| 231 | + * @return PHPExcel_Style |
|
| 232 | + */ |
|
| 233 | + public function getStyle() { |
|
| 234 | + return $this->_style; |
|
| 235 | + } |
|
| 236 | 236 | |
| 237 | - /** |
|
| 238 | - * Set Style |
|
| 239 | - * |
|
| 240 | - * @param PHPExcel_Style $pValue |
|
| 241 | - * @throws Exception |
|
| 242 | - * @return PHPExcel_Style_Conditional |
|
| 243 | - */ |
|
| 244 | - public function setStyle(PHPExcel_Style $pValue = null) { |
|
| 237 | + /** |
|
| 238 | + * Set Style |
|
| 239 | + * |
|
| 240 | + * @param PHPExcel_Style $pValue |
|
| 241 | + * @throws Exception |
|
| 242 | + * @return PHPExcel_Style_Conditional |
|
| 243 | + */ |
|
| 244 | + public function setStyle(PHPExcel_Style $pValue = null) { |
|
| 245 | 245 | $this->_style = $pValue; |
| 246 | 246 | return $this; |
| 247 | - } |
|
| 247 | + } |
|
| 248 | 248 | |
| 249 | 249 | /** |
| 250 | 250 | * Get hash code |
@@ -252,14 +252,14 @@ discard block |
||
| 252 | 252 | * @return string Hash code |
| 253 | 253 | */ |
| 254 | 254 | public function getHashCode() { |
| 255 | - return md5( |
|
| 256 | - $this->_conditionType |
|
| 257 | - . $this->_operatorType |
|
| 258 | - . implode(';', $this->_condition) |
|
| 259 | - . $this->_style->getHashCode() |
|
| 260 | - . __CLASS__ |
|
| 261 | - ); |
|
| 262 | - } |
|
| 255 | + return md5( |
|
| 256 | + $this->_conditionType |
|
| 257 | + . $this->_operatorType |
|
| 258 | + . implode(';', $this->_condition) |
|
| 259 | + . $this->_style->getHashCode() |
|
| 260 | + . __CLASS__ |
|
| 261 | + ); |
|
| 262 | + } |
|
| 263 | 263 | |
| 264 | 264 | /** |
| 265 | 265 | * Implement PHP __clone to create a deep clone, not just a shallow copy. |
@@ -296,7 +296,7 @@ |
||
| 296 | 296 | /** |
| 297 | 297 | * Set Rotation |
| 298 | 298 | * |
| 299 | - * @param double $pValue |
|
| 299 | + * @param integer $pValue |
|
| 300 | 300 | * @return PHPExcel_Style_Fill |
| 301 | 301 | */ |
| 302 | 302 | public function setRotation($pValue = 0) { |
@@ -38,39 +38,39 @@ discard block |
||
| 38 | 38 | /* Fill types */ |
| 39 | 39 | const FILL_NONE = 'none'; |
| 40 | 40 | const FILL_SOLID = 'solid'; |
| 41 | - const FILL_GRADIENT_LINEAR = 'linear'; |
|
| 42 | - const FILL_GRADIENT_PATH = 'path'; |
|
| 41 | + const FILL_GRADIENT_LINEAR = 'linear'; |
|
| 42 | + const FILL_GRADIENT_PATH = 'path'; |
|
| 43 | 43 | const FILL_PATTERN_DARKDOWN = 'darkDown'; |
| 44 | 44 | const FILL_PATTERN_DARKGRAY = 'darkGray'; |
| 45 | 45 | const FILL_PATTERN_DARKGRID = 'darkGrid'; |
| 46 | - const FILL_PATTERN_DARKHORIZONTAL = 'darkHorizontal'; |
|
| 47 | - const FILL_PATTERN_DARKTRELLIS = 'darkTrellis'; |
|
| 48 | - const FILL_PATTERN_DARKUP = 'darkUp'; |
|
| 49 | - const FILL_PATTERN_DARKVERTICAL = 'darkVertical'; |
|
| 46 | + const FILL_PATTERN_DARKHORIZONTAL = 'darkHorizontal'; |
|
| 47 | + const FILL_PATTERN_DARKTRELLIS = 'darkTrellis'; |
|
| 48 | + const FILL_PATTERN_DARKUP = 'darkUp'; |
|
| 49 | + const FILL_PATTERN_DARKVERTICAL = 'darkVertical'; |
|
| 50 | 50 | const FILL_PATTERN_GRAY0625 = 'gray0625'; |
| 51 | - const FILL_PATTERN_GRAY125 = 'gray125'; |
|
| 51 | + const FILL_PATTERN_GRAY125 = 'gray125'; |
|
| 52 | 52 | const FILL_PATTERN_LIGHTDOWN = 'lightDown'; |
| 53 | 53 | const FILL_PATTERN_LIGHTGRAY = 'lightGray'; |
| 54 | 54 | const FILL_PATTERN_LIGHTGRID = 'lightGrid'; |
| 55 | - const FILL_PATTERN_LIGHTHORIZONTAL = 'lightHorizontal'; |
|
| 55 | + const FILL_PATTERN_LIGHTHORIZONTAL = 'lightHorizontal'; |
|
| 56 | 56 | const FILL_PATTERN_LIGHTTRELLIS = 'lightTrellis'; |
| 57 | - const FILL_PATTERN_LIGHTUP = 'lightUp'; |
|
| 57 | + const FILL_PATTERN_LIGHTUP = 'lightUp'; |
|
| 58 | 58 | const FILL_PATTERN_LIGHTVERTICAL = 'lightVertical'; |
| 59 | - const FILL_PATTERN_MEDIUMGRAY = 'mediumGray'; |
|
| 59 | + const FILL_PATTERN_MEDIUMGRAY = 'mediumGray'; |
|
| 60 | 60 | |
| 61 | 61 | /** |
| 62 | 62 | * Fill type |
| 63 | 63 | * |
| 64 | 64 | * @var string |
| 65 | 65 | */ |
| 66 | - private $_fillType = PHPExcel_Style_Fill::FILL_NONE; |
|
| 66 | + private $_fillType = PHPExcel_Style_Fill::FILL_NONE; |
|
| 67 | 67 | |
| 68 | 68 | /** |
| 69 | 69 | * Rotation |
| 70 | 70 | * |
| 71 | 71 | * @var double |
| 72 | 72 | */ |
| 73 | - private $_rotation = 0; |
|
| 73 | + private $_rotation = 0; |
|
| 74 | 74 | |
| 75 | 75 | /** |
| 76 | 76 | * Start color |
@@ -119,7 +119,7 @@ discard block |
||
| 119 | 119 | |
| 120 | 120 | // Initialise values |
| 121 | 121 | $this->_startColor = new PHPExcel_Style_Color(PHPExcel_Style_Color::COLOR_WHITE, $isSupervisor); |
| 122 | - $this->_endColor = new PHPExcel_Style_Color(PHPExcel_Style_Color::COLOR_BLACK, $isSupervisor); |
|
| 122 | + $this->_endColor = new PHPExcel_Style_Color(PHPExcel_Style_Color::COLOR_BLACK, $isSupervisor); |
|
| 123 | 123 | |
| 124 | 124 | // bind parent if we are a supervisor |
| 125 | 125 | if ($isSupervisor) { |
@@ -327,7 +327,7 @@ |
||
| 327 | 327 | /** |
| 328 | 328 | * Set Size |
| 329 | 329 | * |
| 330 | - * @param double $pValue |
|
| 330 | + * @param integer $pValue |
|
| 331 | 331 | * @return PHPExcel_Style_Font |
| 332 | 332 | */ |
| 333 | 333 | public function setSize($pValue = 10) { |
@@ -36,7 +36,7 @@ discard block |
||
| 36 | 36 | class PHPExcel_Style_Font implements PHPExcel_IComparable |
| 37 | 37 | { |
| 38 | 38 | /* Underline types */ |
| 39 | - const UNDERLINE_NONE = 'none'; |
|
| 39 | + const UNDERLINE_NONE = 'none'; |
|
| 40 | 40 | const UNDERLINE_DOUBLE = 'double'; |
| 41 | 41 | const UNDERLINE_DOUBLEACCOUNTING = 'doubleAccounting'; |
| 42 | 42 | const UNDERLINE_SINGLE = 'single'; |
@@ -47,56 +47,56 @@ discard block |
||
| 47 | 47 | * |
| 48 | 48 | * @var string |
| 49 | 49 | */ |
| 50 | - private $_name = 'Calibri'; |
|
| 50 | + private $_name = 'Calibri'; |
|
| 51 | 51 | |
| 52 | 52 | /** |
| 53 | 53 | * Font Size |
| 54 | 54 | * |
| 55 | 55 | * @var float |
| 56 | 56 | */ |
| 57 | - private $_size = 11; |
|
| 57 | + private $_size = 11; |
|
| 58 | 58 | |
| 59 | 59 | /** |
| 60 | 60 | * Bold |
| 61 | 61 | * |
| 62 | 62 | * @var boolean |
| 63 | 63 | */ |
| 64 | - private $_bold = false; |
|
| 64 | + private $_bold = false; |
|
| 65 | 65 | |
| 66 | 66 | /** |
| 67 | 67 | * Italic |
| 68 | 68 | * |
| 69 | 69 | * @var boolean |
| 70 | 70 | */ |
| 71 | - private $_italic = false; |
|
| 71 | + private $_italic = false; |
|
| 72 | 72 | |
| 73 | 73 | /** |
| 74 | 74 | * Superscript |
| 75 | 75 | * |
| 76 | 76 | * @var boolean |
| 77 | 77 | */ |
| 78 | - private $_superScript = false; |
|
| 78 | + private $_superScript = false; |
|
| 79 | 79 | |
| 80 | 80 | /** |
| 81 | 81 | * Subscript |
| 82 | 82 | * |
| 83 | 83 | * @var boolean |
| 84 | 84 | */ |
| 85 | - private $_subScript = false; |
|
| 85 | + private $_subScript = false; |
|
| 86 | 86 | |
| 87 | 87 | /** |
| 88 | 88 | * Underline |
| 89 | 89 | * |
| 90 | 90 | * @var string |
| 91 | 91 | */ |
| 92 | - private $_underline = PHPExcel_Style_Font::UNDERLINE_NONE; |
|
| 92 | + private $_underline = PHPExcel_Style_Font::UNDERLINE_NONE; |
|
| 93 | 93 | |
| 94 | 94 | /** |
| 95 | 95 | * Strikethrough |
| 96 | 96 | * |
| 97 | 97 | * @var boolean |
| 98 | 98 | */ |
| 99 | - private $_strikethrough = false; |
|
| 99 | + private $_strikethrough = false; |
|
| 100 | 100 | |
| 101 | 101 | /** |
| 102 | 102 | * Foreground color |
@@ -137,7 +137,7 @@ discard block |
||
| 137 | 137 | $this->_isSupervisor = $isSupervisor; |
| 138 | 138 | |
| 139 | 139 | // Initialise values |
| 140 | - $this->_color = new PHPExcel_Style_Color(PHPExcel_Style_Color::COLOR_BLACK, $isSupervisor); |
|
| 140 | + $this->_color = new PHPExcel_Style_Color(PHPExcel_Style_Color::COLOR_BLACK, $isSupervisor); |
|
| 141 | 141 | |
| 142 | 142 | // bind parent if we are a supervisor |
| 143 | 143 | if ($isSupervisor) { |
@@ -432,7 +432,7 @@ discard block |
||
| 432 | 432 | $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); |
| 433 | 433 | } else { |
| 434 | 434 | $this->_superScript = $pValue; |
| 435 | - $this->_subScript = !$pValue; |
|
| 435 | + $this->_subScript = ! $pValue; |
|
| 436 | 436 | } |
| 437 | 437 | return $this; |
| 438 | 438 | } |
@@ -464,7 +464,7 @@ discard block |
||
| 464 | 464 | $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); |
| 465 | 465 | } else { |
| 466 | 466 | $this->_subScript = $pValue; |
| 467 | - $this->_superScript = !$pValue; |
|
| 467 | + $this->_superScript = ! $pValue; |
|
| 468 | 468 | } |
| 469 | 469 | return $this; |
| 470 | 470 | } |
@@ -438,10 +438,10 @@ |
||
| 438 | 438 | } |
| 439 | 439 | |
| 440 | 440 | /** |
| 441 | - * Get SubScript |
|
| 442 | - * |
|
| 443 | - * @return boolean |
|
| 444 | - */ |
|
| 441 | + * Get SubScript |
|
| 442 | + * |
|
| 443 | + * @return boolean |
|
| 444 | + */ |
|
| 445 | 445 | public function getSubScript() { |
| 446 | 446 | if ($this->_isSupervisor) { |
| 447 | 447 | return $this->getSharedComponent()->getSubScript(); |
@@ -550,7 +550,7 @@ discard block |
||
| 550 | 550 | * Get a chart by its index position |
| 551 | 551 | * |
| 552 | 552 | * @param string $index Chart index position |
| 553 | - * @return false|PHPExcel_Chart |
|
| 553 | + * @return null|PHPExcel_Chart |
|
| 554 | 554 | * @throws Exception |
| 555 | 555 | */ |
| 556 | 556 | public function getChartByIndex($index = null) |
@@ -916,7 +916,7 @@ discard block |
||
| 916 | 916 | /** |
| 917 | 917 | * Get sheet view |
| 918 | 918 | * |
| 919 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
| 919 | + * @return PHPExcel_Worksheet_SheetView |
|
| 920 | 920 | */ |
| 921 | 921 | public function getSheetView() |
| 922 | 922 | { |
@@ -1030,8 +1030,8 @@ discard block |
||
| 1030 | 1030 | /** |
| 1031 | 1031 | * Set a cell value by using numeric cell coordinates |
| 1032 | 1032 | * |
| 1033 | - * @param string $pColumn Numeric column coordinate of the cell |
|
| 1034 | - * @param string $pRow Numeric row coordinate of the cell |
|
| 1033 | + * @param integer $pColumn Numeric column coordinate of the cell |
|
| 1034 | + * @param integer $pRow Numeric row coordinate of the cell |
|
| 1035 | 1035 | * @param mixed $pValue Value of the cell |
| 1036 | 1036 | * @param bool $returnCell Return the worksheet (false, default) or the cell (true) |
| 1037 | 1037 | * @return PHPExcel_Worksheet|PHPExcel_Cell Depending on the last parameter being specified |
@@ -1064,11 +1064,11 @@ discard block |
||
| 1064 | 1064 | /** |
| 1065 | 1065 | * Set a cell value by using numeric cell coordinates |
| 1066 | 1066 | * |
| 1067 | - * @param string $pColumn Numeric column coordinate of the cell |
|
| 1068 | - * @param string $pRow Numeric row coordinate of the cell |
|
| 1067 | + * @param integer $pColumn Numeric column coordinate of the cell |
|
| 1068 | + * @param integer $pRow Numeric row coordinate of the cell |
|
| 1069 | 1069 | * @param mixed $pValue Value of the cell |
| 1070 | 1070 | * @param string $pDataType Explicit data type |
| 1071 | - * @return PHPExcel_Worksheet |
|
| 1071 | + * @return PHPExcel_Cell |
|
| 1072 | 1072 | */ |
| 1073 | 1073 | public function setCellValueExplicitByColumnAndRow($pColumn = 0, $pRow = 1, $pValue = null, $pDataType = PHPExcel_Cell_DataType::TYPE_STRING) |
| 1074 | 1074 | { |
@@ -1148,8 +1148,8 @@ discard block |
||
| 1148 | 1148 | /** |
| 1149 | 1149 | * Get cell at a specific coordinate by using numeric cell coordinates |
| 1150 | 1150 | * |
| 1151 | - * @param string $pColumn Numeric column coordinate of the cell |
|
| 1152 | - * @param string $pRow Numeric row coordinate of the cell |
|
| 1151 | + * @param integer $pColumn Numeric column coordinate of the cell |
|
| 1152 | + * @param integer $pRow Numeric row coordinate of the cell |
|
| 1153 | 1153 | * @return PHPExcel_Cell Cell that was found |
| 1154 | 1154 | */ |
| 1155 | 1155 | public function getCellByColumnAndRow($pColumn = 0, $pRow = 1) |
@@ -1222,8 +1222,8 @@ discard block |
||
| 1222 | 1222 | /** |
| 1223 | 1223 | * Cell at a specific coordinate by using numeric cell coordinates exists? |
| 1224 | 1224 | * |
| 1225 | - * @param string $pColumn Numeric column coordinate of the cell |
|
| 1226 | - * @param string $pRow Numeric row coordinate of the cell |
|
| 1225 | + * @param integer $pColumn Numeric column coordinate of the cell |
|
| 1226 | + * @param integer $pRow Numeric row coordinate of the cell |
|
| 1227 | 1227 | * @return boolean |
| 1228 | 1228 | */ |
| 1229 | 1229 | public function cellExistsByColumnAndRow($pColumn = 0, $pRow = 1) |
@@ -1275,7 +1275,7 @@ discard block |
||
| 1275 | 1275 | /** |
| 1276 | 1276 | * Get column dimension at a specific column by using numeric cell coordinates |
| 1277 | 1277 | * |
| 1278 | - * @param string $pColumn Numeric column coordinate of the cell |
|
| 1278 | + * @param integer $pColumn Numeric column coordinate of the cell |
|
| 1279 | 1279 | * @return PHPExcel_Worksheet_ColumnDimension |
| 1280 | 1280 | */ |
| 1281 | 1281 | public function getColumnDimensionByColumn($pColumn = 0) |
@@ -38,11 +38,11 @@ discard block |
||
| 38 | 38 | /* Break types */ |
| 39 | 39 | const BREAK_NONE = 0; |
| 40 | 40 | const BREAK_ROW = 1; |
| 41 | - const BREAK_COLUMN = 2; |
|
| 41 | + const BREAK_COLUMN = 2; |
|
| 42 | 42 | |
| 43 | 43 | /* Sheet state */ |
| 44 | - const SHEETSTATE_VISIBLE = 'visible'; |
|
| 45 | - const SHEETSTATE_HIDDEN = 'hidden'; |
|
| 44 | + const SHEETSTATE_VISIBLE = 'visible'; |
|
| 45 | + const SHEETSTATE_HIDDEN = 'hidden'; |
|
| 46 | 46 | const SHEETSTATE_VERYHIDDEN = 'veryHidden'; |
| 47 | 47 | |
| 48 | 48 | /** |
@@ -316,14 +316,14 @@ discard block |
||
| 316 | 316 | * |
| 317 | 317 | * @var boolean |
| 318 | 318 | */ |
| 319 | - private $_dirty = true; |
|
| 319 | + private $_dirty = true; |
|
| 320 | 320 | |
| 321 | 321 | /** |
| 322 | 322 | * Hash |
| 323 | 323 | * |
| 324 | 324 | * @var string |
| 325 | 325 | */ |
| 326 | - private $_hash = null; |
|
| 326 | + private $_hash = null; |
|
| 327 | 327 | |
| 328 | 328 | /** |
| 329 | 329 | * Create a new worksheet |
@@ -338,10 +338,10 @@ discard block |
||
| 338 | 338 | $this->setTitle($pTitle, FALSE); |
| 339 | 339 | $this->setSheetState(PHPExcel_Worksheet::SHEETSTATE_VISIBLE); |
| 340 | 340 | |
| 341 | - $this->_cellCollection = PHPExcel_CachedObjectStorageFactory::getInstance($this); |
|
| 341 | + $this->_cellCollection = PHPExcel_CachedObjectStorageFactory::getInstance($this); |
|
| 342 | 342 | |
| 343 | 343 | // Set page setup |
| 344 | - $this->_pageSetup = new PHPExcel_Worksheet_PageSetup(); |
|
| 344 | + $this->_pageSetup = new PHPExcel_Worksheet_PageSetup(); |
|
| 345 | 345 | |
| 346 | 346 | // Set page margins |
| 347 | 347 | $this->_pageMargins = new PHPExcel_Worksheet_PageMargins(); |
@@ -350,16 +350,16 @@ discard block |
||
| 350 | 350 | $this->_headerFooter = new PHPExcel_Worksheet_HeaderFooter(); |
| 351 | 351 | |
| 352 | 352 | // Set sheet view |
| 353 | - $this->_sheetView = new PHPExcel_Worksheet_SheetView(); |
|
| 353 | + $this->_sheetView = new PHPExcel_Worksheet_SheetView(); |
|
| 354 | 354 | |
| 355 | 355 | // Drawing collection |
| 356 | - $this->_drawingCollection = new ArrayObject(); |
|
| 356 | + $this->_drawingCollection = new ArrayObject(); |
|
| 357 | 357 | |
| 358 | 358 | // Chart collection |
| 359 | - $this->_chartCollection = new ArrayObject(); |
|
| 359 | + $this->_chartCollection = new ArrayObject(); |
|
| 360 | 360 | |
| 361 | 361 | // Protection |
| 362 | - $this->_protection = new PHPExcel_Worksheet_Protection(); |
|
| 362 | + $this->_protection = new PHPExcel_Worksheet_Protection(); |
|
| 363 | 363 | |
| 364 | 364 | // Default row dimension |
| 365 | 365 | $this->_defaultRowDimension = new PHPExcel_Worksheet_RowDimension(null); |
@@ -562,7 +562,7 @@ discard block |
||
| 562 | 562 | if (is_null($index)) { |
| 563 | 563 | $index = --$chartCount; |
| 564 | 564 | } |
| 565 | - if (!isset($this->_chartCollection[$index])) { |
|
| 565 | + if ( ! isset($this->_chartCollection[$index])) { |
|
| 566 | 566 | return false; |
| 567 | 567 | } |
| 568 | 568 | |
@@ -578,7 +578,7 @@ discard block |
||
| 578 | 578 | public function getChartNames() |
| 579 | 579 | { |
| 580 | 580 | $chartNames = array(); |
| 581 | - foreach($this->_chartCollection as $chart) { |
|
| 581 | + foreach ($this->_chartCollection as $chart) { |
|
| 582 | 582 | $chartNames[] = $chart->getName(); |
| 583 | 583 | } |
| 584 | 584 | return $chartNames; |
@@ -597,7 +597,7 @@ discard block |
||
| 597 | 597 | if ($chartCount == 0) { |
| 598 | 598 | return false; |
| 599 | 599 | } |
| 600 | - foreach($this->_chartCollection as $index => $chart) { |
|
| 600 | + foreach ($this->_chartCollection as $index => $chart) { |
|
| 601 | 601 | if ($chart->getName() == $chartName) { |
| 602 | 602 | return $this->_chartCollection[$index]; |
| 603 | 603 | } |
@@ -651,7 +651,7 @@ discard block |
||
| 651 | 651 | public function calculateWorksheetDimension() |
| 652 | 652 | { |
| 653 | 653 | // Return |
| 654 | - return 'A1' . ':' . $this->getHighestColumn() . $this->getHighestRow(); |
|
| 654 | + return 'A1'.':'.$this->getHighestColumn().$this->getHighestRow(); |
|
| 655 | 655 | } |
| 656 | 656 | |
| 657 | 657 | /** |
@@ -662,7 +662,7 @@ discard block |
||
| 662 | 662 | public function calculateWorksheetDataDimension() |
| 663 | 663 | { |
| 664 | 664 | // Return |
| 665 | - return 'A1' . ':' . $this->getHighestDataColumn() . $this->getHighestDataRow(); |
|
| 665 | + return 'A1'.':'.$this->getHighestDataColumn().$this->getHighestDataRow(); |
|
| 666 | 666 | } |
| 667 | 667 | |
| 668 | 668 | /** |
@@ -682,7 +682,7 @@ discard block |
||
| 682 | 682 | } |
| 683 | 683 | |
| 684 | 684 | // There is only something to do if there are some auto-size columns |
| 685 | - if (!empty($autoSizes)) { |
|
| 685 | + if ( ! empty($autoSizes)) { |
|
| 686 | 686 | |
| 687 | 687 | // build list of cells references that participate in a merge |
| 688 | 688 | $isMergeCell = array(); |
@@ -697,7 +697,7 @@ discard block |
||
| 697 | 697 | $cell = $this->getCell($cellID); |
| 698 | 698 | if (isset($autoSizes[$cell->getColumn()])) { |
| 699 | 699 | // Determine width if cell does not participate in a merge |
| 700 | - if (!isset($isMergeCell[$cell->getCoordinate()])) { |
|
| 700 | + if ( ! isset($isMergeCell[$cell->getCoordinate()])) { |
|
| 701 | 701 | // Calculated value |
| 702 | 702 | $cellValue = $cell->getCalculatedValue(); |
| 703 | 703 | |
@@ -705,8 +705,8 @@ discard block |
||
| 705 | 705 | $cellValue = PHPExcel_Style_NumberFormat::toFormattedString($cellValue, $this->getParent()->getCellXfByIndex($cell->getXfIndex())->getNumberFormat()->getFormatCode()); |
| 706 | 706 | |
| 707 | 707 | $autoSizes[$cell->getColumn()] = max( |
| 708 | - (float)$autoSizes[$cell->getColumn()], |
|
| 709 | - (float)PHPExcel_Shared_Font::calculateColumnWidth( |
|
| 708 | + (float) $autoSizes[$cell->getColumn()], |
|
| 709 | + (float) PHPExcel_Shared_Font::calculateColumnWidth( |
|
| 710 | 710 | $this->getParent()->getCellXfByIndex($cell->getXfIndex())->getFont(), |
| 711 | 711 | $cellValue, |
| 712 | 712 | $this->getParent()->getCellXfByIndex($cell->getXfIndex())->getAlignment()->getTextRotation(), |
@@ -795,24 +795,24 @@ discard block |
||
| 795 | 795 | // Use name, but append with lowest possible integer |
| 796 | 796 | |
| 797 | 797 | if (PHPExcel_Shared_String::CountCharacters($pValue) > 29) { |
| 798 | - $pValue = PHPExcel_Shared_String::Substring($pValue,0,29); |
|
| 798 | + $pValue = PHPExcel_Shared_String::Substring($pValue, 0, 29); |
|
| 799 | 799 | } |
| 800 | 800 | $i = 1; |
| 801 | - while ($this->getParent()->getSheetByName($pValue . ' ' . $i)) { |
|
| 801 | + while ($this->getParent()->getSheetByName($pValue.' '.$i)) { |
|
| 802 | 802 | ++$i; |
| 803 | 803 | if ($i == 10) { |
| 804 | 804 | if (PHPExcel_Shared_String::CountCharacters($pValue) > 28) { |
| 805 | - $pValue = PHPExcel_Shared_String::Substring($pValue,0,28); |
|
| 805 | + $pValue = PHPExcel_Shared_String::Substring($pValue, 0, 28); |
|
| 806 | 806 | } |
| 807 | 807 | } elseif ($i == 100) { |
| 808 | 808 | if (PHPExcel_Shared_String::CountCharacters($pValue) > 27) { |
| 809 | - $pValue = PHPExcel_Shared_String::Substring($pValue,0,27); |
|
| 809 | + $pValue = PHPExcel_Shared_String::Substring($pValue, 0, 27); |
|
| 810 | 810 | } |
| 811 | 811 | } |
| 812 | 812 | } |
| 813 | 813 | |
| 814 | - $altTitle = $pValue . ' ' . $i; |
|
| 815 | - return $this->setTitle($altTitle,$updateFormulaCellReferences); |
|
| 814 | + $altTitle = $pValue.' '.$i; |
|
| 815 | + return $this->setTitle($altTitle, $updateFormulaCellReferences); |
|
| 816 | 816 | } |
| 817 | 817 | |
| 818 | 818 | // Set title |
@@ -1038,7 +1038,7 @@ discard block |
||
| 1038 | 1038 | */ |
| 1039 | 1039 | public function setCellValueByColumnAndRow($pColumn = 0, $pRow = 1, $pValue = null, $returnCell = false) |
| 1040 | 1040 | { |
| 1041 | - $cell = $this->getCell(PHPExcel_Cell::stringFromColumnIndex($pColumn) . $pRow)->setValue($pValue); |
|
| 1041 | + $cell = $this->getCell(PHPExcel_Cell::stringFromColumnIndex($pColumn).$pRow)->setValue($pValue); |
|
| 1042 | 1042 | |
| 1043 | 1043 | if ($returnCell) { |
| 1044 | 1044 | return $cell; |
@@ -1072,7 +1072,7 @@ discard block |
||
| 1072 | 1072 | */ |
| 1073 | 1073 | public function setCellValueExplicitByColumnAndRow($pColumn = 0, $pRow = 1, $pValue = null, $pDataType = PHPExcel_Cell_DataType::TYPE_STRING) |
| 1074 | 1074 | { |
| 1075 | - return $this->getCell(PHPExcel_Cell::stringFromColumnIndex($pColumn) . $pRow)->setValueExplicit($pValue, $pDataType); |
|
| 1075 | + return $this->getCell(PHPExcel_Cell::stringFromColumnIndex($pColumn).$pRow)->setValueExplicit($pValue, $pDataType); |
|
| 1076 | 1076 | } |
| 1077 | 1077 | |
| 1078 | 1078 | /** |
@@ -1096,7 +1096,7 @@ discard block |
||
| 1096 | 1096 | } |
| 1097 | 1097 | |
| 1098 | 1098 | // Named range? |
| 1099 | - if ((!preg_match('/^'.PHPExcel_Calculation::CALCULATION_REGEXP_CELLREF.'$/i', $pCoordinate, $matches)) && |
|
| 1099 | + if (( ! preg_match('/^'.PHPExcel_Calculation::CALCULATION_REGEXP_CELLREF.'$/i', $pCoordinate, $matches)) && |
|
| 1100 | 1100 | (preg_match('/^'.PHPExcel_Calculation::CALCULATION_REGEXP_NAMEDRANGE.'$/i', $pCoordinate, $matches))) { |
| 1101 | 1101 | $namedRange = PHPExcel_NamedRange::resolveRange($pCoordinate, $this); |
| 1102 | 1102 | if ($namedRange !== NULL) { |
@@ -1108,9 +1108,9 @@ discard block |
||
| 1108 | 1108 | // Uppercase coordinate |
| 1109 | 1109 | $pCoordinate = strtoupper($pCoordinate); |
| 1110 | 1110 | |
| 1111 | - if (strpos($pCoordinate,':') !== false || strpos($pCoordinate,',') !== false) { |
|
| 1111 | + if (strpos($pCoordinate, ':') !== false || strpos($pCoordinate, ',') !== false) { |
|
| 1112 | 1112 | throw new Exception('Cell coordinate can not be a range of cells.'); |
| 1113 | - } elseif (strpos($pCoordinate,'$') !== false) { |
|
| 1113 | + } elseif (strpos($pCoordinate, '$') !== false) { |
|
| 1114 | 1114 | throw new Exception('Cell coordinate must not be absolute.'); |
| 1115 | 1115 | } else { |
| 1116 | 1116 | // Create new cell object |
@@ -1118,22 +1118,22 @@ discard block |
||
| 1118 | 1118 | // Coordinates |
| 1119 | 1119 | $aCoordinates = PHPExcel_Cell::coordinateFromString($pCoordinate); |
| 1120 | 1120 | |
| 1121 | - $cell = $this->_cellCollection->addCacheData($pCoordinate,new PHPExcel_Cell($aCoordinates[0], $aCoordinates[1], null, PHPExcel_Cell_DataType::TYPE_NULL, $this)); |
|
| 1121 | + $cell = $this->_cellCollection->addCacheData($pCoordinate, new PHPExcel_Cell($aCoordinates[0], $aCoordinates[1], null, PHPExcel_Cell_DataType::TYPE_NULL, $this)); |
|
| 1122 | 1122 | $this->_cellCollectionIsSorted = false; |
| 1123 | 1123 | |
| 1124 | 1124 | if (PHPExcel_Cell::columnIndexFromString($this->_cachedHighestColumn) < PHPExcel_Cell::columnIndexFromString($aCoordinates[0])) |
| 1125 | 1125 | $this->_cachedHighestColumn = $aCoordinates[0]; |
| 1126 | 1126 | |
| 1127 | - $this->_cachedHighestRow = max($this->_cachedHighestRow,$aCoordinates[1]); |
|
| 1127 | + $this->_cachedHighestRow = max($this->_cachedHighestRow, $aCoordinates[1]); |
|
| 1128 | 1128 | |
| 1129 | 1129 | // Cell needs appropriate xfIndex |
| 1130 | - $rowDimensions = $this->getRowDimensions(); |
|
| 1130 | + $rowDimensions = $this->getRowDimensions(); |
|
| 1131 | 1131 | $columnDimensions = $this->getColumnDimensions(); |
| 1132 | 1132 | |
| 1133 | - if ( isset($rowDimensions[$aCoordinates[1]]) && $rowDimensions[$aCoordinates[1]]->getXfIndex() !== null ) { |
|
| 1133 | + if (isset($rowDimensions[$aCoordinates[1]]) && $rowDimensions[$aCoordinates[1]]->getXfIndex() !== null) { |
|
| 1134 | 1134 | // then there is a row dimension with explicit style, assign it to the cell |
| 1135 | 1135 | $cell->setXfIndex($rowDimensions[$aCoordinates[1]]->getXfIndex()); |
| 1136 | - } else if ( isset($columnDimensions[$aCoordinates[0]]) ) { |
|
| 1136 | + } else if (isset($columnDimensions[$aCoordinates[0]])) { |
|
| 1137 | 1137 | // then there is a column dimension, assign it to the cell |
| 1138 | 1138 | $cell->setXfIndex($columnDimensions[$aCoordinates[0]]->getXfIndex()); |
| 1139 | 1139 | } else { |
@@ -1155,16 +1155,16 @@ discard block |
||
| 1155 | 1155 | public function getCellByColumnAndRow($pColumn = 0, $pRow = 1) |
| 1156 | 1156 | { |
| 1157 | 1157 | $columnLetter = PHPExcel_Cell::stringFromColumnIndex($pColumn); |
| 1158 | - $coordinate = $columnLetter . $pRow; |
|
| 1158 | + $coordinate = $columnLetter.$pRow; |
|
| 1159 | 1159 | |
| 1160 | - if (!$this->_cellCollection->isDataSet($coordinate)) { |
|
| 1160 | + if ( ! $this->_cellCollection->isDataSet($coordinate)) { |
|
| 1161 | 1161 | $cell = $this->_cellCollection->addCacheData($coordinate, new PHPExcel_Cell($columnLetter, $pRow, null, PHPExcel_Cell_DataType::TYPE_NULL, $this)); |
| 1162 | 1162 | $this->_cellCollectionIsSorted = false; |
| 1163 | 1163 | |
| 1164 | 1164 | if (PHPExcel_Cell::columnIndexFromString($this->_cachedHighestColumn) < $pColumn) |
| 1165 | 1165 | $this->_cachedHighestColumn = $columnLetter; |
| 1166 | 1166 | |
| 1167 | - $this->_cachedHighestRow = max($this->_cachedHighestRow,$pRow); |
|
| 1167 | + $this->_cachedHighestRow = max($this->_cachedHighestRow, $pRow); |
|
| 1168 | 1168 | |
| 1169 | 1169 | return $cell; |
| 1170 | 1170 | } |
@@ -1188,16 +1188,16 @@ discard block |
||
| 1188 | 1188 | } |
| 1189 | 1189 | |
| 1190 | 1190 | // Named range? |
| 1191 | - if ((!preg_match('/^'.PHPExcel_Calculation::CALCULATION_REGEXP_CELLREF.'$/i', $pCoordinate, $matches)) && |
|
| 1191 | + if (( ! preg_match('/^'.PHPExcel_Calculation::CALCULATION_REGEXP_CELLREF.'$/i', $pCoordinate, $matches)) && |
|
| 1192 | 1192 | (preg_match('/^'.PHPExcel_Calculation::CALCULATION_REGEXP_NAMEDRANGE.'$/i', $pCoordinate, $matches))) { |
| 1193 | 1193 | $namedRange = PHPExcel_NamedRange::resolveRange($pCoordinate, $this); |
| 1194 | 1194 | if ($namedRange !== NULL) { |
| 1195 | 1195 | $pCoordinate = $namedRange->getRange(); |
| 1196 | 1196 | if ($this->getHashCode() != $namedRange->getWorksheet()->getHashCode()) { |
| 1197 | - if (!$namedRange->getLocalOnly()) { |
|
| 1197 | + if ( ! $namedRange->getLocalOnly()) { |
|
| 1198 | 1198 | return $namedRange->getWorksheet()->cellExists($pCoordinate); |
| 1199 | 1199 | } else { |
| 1200 | - throw new Exception('Named range ' . $namedRange->getName() . ' is not accessible from within sheet ' . $this->getTitle()); |
|
| 1200 | + throw new Exception('Named range '.$namedRange->getName().' is not accessible from within sheet '.$this->getTitle()); |
|
| 1201 | 1201 | } |
| 1202 | 1202 | } |
| 1203 | 1203 | } |
@@ -1206,9 +1206,9 @@ discard block |
||
| 1206 | 1206 | // Uppercase coordinate |
| 1207 | 1207 | $pCoordinate = strtoupper($pCoordinate); |
| 1208 | 1208 | |
| 1209 | - if (strpos($pCoordinate,':') !== false || strpos($pCoordinate,',') !== false) { |
|
| 1209 | + if (strpos($pCoordinate, ':') !== false || strpos($pCoordinate, ',') !== false) { |
|
| 1210 | 1210 | throw new Exception('Cell coordinate can not be a range of cells.'); |
| 1211 | - } elseif (strpos($pCoordinate,'$') !== false) { |
|
| 1211 | + } elseif (strpos($pCoordinate, '$') !== false) { |
|
| 1212 | 1212 | throw new Exception('Cell coordinate must not be absolute.'); |
| 1213 | 1213 | } else { |
| 1214 | 1214 | // Coordinates |
@@ -1228,7 +1228,7 @@ discard block |
||
| 1228 | 1228 | */ |
| 1229 | 1229 | public function cellExistsByColumnAndRow($pColumn = 0, $pRow = 1) |
| 1230 | 1230 | { |
| 1231 | - return $this->cellExists(PHPExcel_Cell::stringFromColumnIndex($pColumn) . $pRow); |
|
| 1231 | + return $this->cellExists(PHPExcel_Cell::stringFromColumnIndex($pColumn).$pRow); |
|
| 1232 | 1232 | } |
| 1233 | 1233 | |
| 1234 | 1234 | /** |
@@ -1243,10 +1243,10 @@ discard block |
||
| 1243 | 1243 | $found = null; |
| 1244 | 1244 | |
| 1245 | 1245 | // Get row dimension |
| 1246 | - if (!isset($this->_rowDimensions[$pRow])) { |
|
| 1246 | + if ( ! isset($this->_rowDimensions[$pRow])) { |
|
| 1247 | 1247 | $this->_rowDimensions[$pRow] = new PHPExcel_Worksheet_RowDimension($pRow); |
| 1248 | 1248 | |
| 1249 | - $this->_cachedHighestRow = max($this->_cachedHighestRow,$pRow); |
|
| 1249 | + $this->_cachedHighestRow = max($this->_cachedHighestRow, $pRow); |
|
| 1250 | 1250 | } |
| 1251 | 1251 | return $this->_rowDimensions[$pRow]; |
| 1252 | 1252 | } |
@@ -1263,7 +1263,7 @@ discard block |
||
| 1263 | 1263 | $pColumn = strtoupper($pColumn); |
| 1264 | 1264 | |
| 1265 | 1265 | // Fetch dimensions |
| 1266 | - if (!isset($this->_columnDimensions[$pColumn])) { |
|
| 1266 | + if ( ! isset($this->_columnDimensions[$pColumn])) { |
|
| 1267 | 1267 | $this->_columnDimensions[$pColumn] = new PHPExcel_Worksheet_ColumnDimension($pColumn); |
| 1268 | 1268 | |
| 1269 | 1269 | if (PHPExcel_Cell::columnIndexFromString($this->_cachedHighestColumn) < PHPExcel_Cell::columnIndexFromString($pColumn)) |
@@ -1350,7 +1350,7 @@ discard block |
||
| 1350 | 1350 | */ |
| 1351 | 1351 | public function getConditionalStyles($pCoordinate = 'A1') |
| 1352 | 1352 | { |
| 1353 | - if (!isset($this->_conditionalStylesCollection[$pCoordinate])) { |
|
| 1353 | + if ( ! isset($this->_conditionalStylesCollection[$pCoordinate])) { |
|
| 1354 | 1354 | $this->_conditionalStylesCollection[$pCoordinate] = array(); |
| 1355 | 1355 | } |
| 1356 | 1356 | return $this->_conditionalStylesCollection[$pCoordinate]; |
@@ -1414,7 +1414,7 @@ discard block |
||
| 1414 | 1414 | */ |
| 1415 | 1415 | public function getStyleByColumnAndRow($pColumn = 0, $pRow = 1) |
| 1416 | 1416 | { |
| 1417 | - return $this->getStyle(PHPExcel_Cell::stringFromColumnIndex($pColumn) . $pRow); |
|
| 1417 | + return $this->getStyle(PHPExcel_Cell::stringFromColumnIndex($pColumn).$pRow); |
|
| 1418 | 1418 | } |
| 1419 | 1419 | |
| 1420 | 1420 | /** |
@@ -1475,11 +1475,11 @@ discard block |
||
| 1475 | 1475 | |
| 1476 | 1476 | // Calculate range outer borders |
| 1477 | 1477 | $rangeStart = PHPExcel_Cell::coordinateFromString($rangeA); |
| 1478 | - $rangeEnd = PHPExcel_Cell::coordinateFromString($rangeB); |
|
| 1478 | + $rangeEnd = PHPExcel_Cell::coordinateFromString($rangeB); |
|
| 1479 | 1479 | |
| 1480 | 1480 | // Translate column into index |
| 1481 | - $rangeStart[0] = PHPExcel_Cell::columnIndexFromString($rangeStart[0]) - 1; |
|
| 1482 | - $rangeEnd[0] = PHPExcel_Cell::columnIndexFromString($rangeEnd[0]) - 1; |
|
| 1481 | + $rangeStart[0] = PHPExcel_Cell::columnIndexFromString($rangeStart[0]) - 1; |
|
| 1482 | + $rangeEnd[0] = PHPExcel_Cell::columnIndexFromString($rangeEnd[0]) - 1; |
|
| 1483 | 1483 | |
| 1484 | 1484 | // Make sure we can loop upwards on rows and columns |
| 1485 | 1485 | if ($rangeStart[0] > $rangeEnd[0] && $rangeStart[1] > $rangeEnd[1]) { |
@@ -1491,7 +1491,7 @@ discard block |
||
| 1491 | 1491 | // Loop through cells and apply styles |
| 1492 | 1492 | for ($col = $rangeStart[0]; $col <= $rangeEnd[0]; ++$col) { |
| 1493 | 1493 | for ($row = $rangeStart[1]; $row <= $rangeEnd[1]; ++$row) { |
| 1494 | - $this->getCell(PHPExcel_Cell::stringFromColumnIndex($col) . $row)->setXfIndex($xfIndex); |
|
| 1494 | + $this->getCell(PHPExcel_Cell::stringFromColumnIndex($col).$row)->setXfIndex($xfIndex); |
|
| 1495 | 1495 | } |
| 1496 | 1496 | } |
| 1497 | 1497 | |
@@ -1510,8 +1510,8 @@ discard block |
||
| 1510 | 1510 | */ |
| 1511 | 1511 | public function duplicateConditionalStyle(array $pCellStyle = null, $pRange = '') |
| 1512 | 1512 | { |
| 1513 | - foreach($pCellStyle as $cellStyle) { |
|
| 1514 | - if (!is_a($cellStyle,'PHPExcel_Style_Conditional')) { |
|
| 1513 | + foreach ($pCellStyle as $cellStyle) { |
|
| 1514 | + if ( ! is_a($cellStyle, 'PHPExcel_Style_Conditional')) { |
|
| 1515 | 1515 | throw new Exception('Style is not a conditional style'); |
| 1516 | 1516 | } |
| 1517 | 1517 | } |
@@ -1531,11 +1531,11 @@ discard block |
||
| 1531 | 1531 | |
| 1532 | 1532 | // Calculate range outer borders |
| 1533 | 1533 | $rangeStart = PHPExcel_Cell::coordinateFromString($rangeA); |
| 1534 | - $rangeEnd = PHPExcel_Cell::coordinateFromString($rangeB); |
|
| 1534 | + $rangeEnd = PHPExcel_Cell::coordinateFromString($rangeB); |
|
| 1535 | 1535 | |
| 1536 | 1536 | // Translate column into index |
| 1537 | - $rangeStart[0] = PHPExcel_Cell::columnIndexFromString($rangeStart[0]) - 1; |
|
| 1538 | - $rangeEnd[0] = PHPExcel_Cell::columnIndexFromString($rangeEnd[0]) - 1; |
|
| 1537 | + $rangeStart[0] = PHPExcel_Cell::columnIndexFromString($rangeStart[0]) - 1; |
|
| 1538 | + $rangeEnd[0] = PHPExcel_Cell::columnIndexFromString($rangeEnd[0]) - 1; |
|
| 1539 | 1539 | |
| 1540 | 1540 | // Make sure we can loop upwards on rows and columns |
| 1541 | 1541 | if ($rangeStart[0] > $rangeEnd[0] && $rangeStart[1] > $rangeEnd[1]) { |
@@ -1547,7 +1547,7 @@ discard block |
||
| 1547 | 1547 | // Loop through cells and apply styles |
| 1548 | 1548 | for ($col = $rangeStart[0]; $col <= $rangeEnd[0]; ++$col) { |
| 1549 | 1549 | for ($row = $rangeStart[1]; $row <= $rangeEnd[1]; ++$row) { |
| 1550 | - $this->setConditionalStyles(PHPExcel_Cell::stringFromColumnIndex($col) . $row, $pCellStyle); |
|
| 1550 | + $this->setConditionalStyles(PHPExcel_Cell::stringFromColumnIndex($col).$row, $pCellStyle); |
|
| 1551 | 1551 | } |
| 1552 | 1552 | } |
| 1553 | 1553 | |
@@ -1607,7 +1607,7 @@ discard block |
||
| 1607 | 1607 | */ |
| 1608 | 1608 | public function setBreakByColumnAndRow($pColumn = 0, $pRow = 1, $pBreak = PHPExcel_Worksheet::BREAK_NONE) |
| 1609 | 1609 | { |
| 1610 | - return $this->setBreak(PHPExcel_Cell::stringFromColumnIndex($pColumn) . $pRow, $pBreak); |
|
| 1610 | + return $this->setBreak(PHPExcel_Cell::stringFromColumnIndex($pColumn).$pRow, $pBreak); |
|
| 1611 | 1611 | } |
| 1612 | 1612 | |
| 1613 | 1613 | /** |
@@ -1632,7 +1632,7 @@ discard block |
||
| 1632 | 1632 | // Uppercase coordinate |
| 1633 | 1633 | $pRange = strtoupper($pRange); |
| 1634 | 1634 | |
| 1635 | - if (strpos($pRange,':') !== false) { |
|
| 1635 | + if (strpos($pRange, ':') !== false) { |
|
| 1636 | 1636 | $this->_mergeCells[$pRange] = $pRange; |
| 1637 | 1637 | |
| 1638 | 1638 | // make sure cells are created |
@@ -1642,7 +1642,7 @@ discard block |
||
| 1642 | 1642 | |
| 1643 | 1643 | // create upper left cell if it does not already exist |
| 1644 | 1644 | $upperLeft = $aReferences[0]; |
| 1645 | - if (!$this->cellExists($upperLeft)) { |
|
| 1645 | + if ( ! $this->cellExists($upperLeft)) { |
|
| 1646 | 1646 | $this->getCell($upperLeft)->setValueExplicit(null, PHPExcel_Cell_DataType::TYPE_NULL); |
| 1647 | 1647 | } |
| 1648 | 1648 | |
@@ -1671,7 +1671,7 @@ discard block |
||
| 1671 | 1671 | */ |
| 1672 | 1672 | public function mergeCellsByColumnAndRow($pColumn1 = 0, $pRow1 = 1, $pColumn2 = 0, $pRow2 = 1) |
| 1673 | 1673 | { |
| 1674 | - $cellRange = PHPExcel_Cell::stringFromColumnIndex($pColumn1) . $pRow1 . ':' . PHPExcel_Cell::stringFromColumnIndex($pColumn2) . $pRow2; |
|
| 1674 | + $cellRange = PHPExcel_Cell::stringFromColumnIndex($pColumn1).$pRow1.':'.PHPExcel_Cell::stringFromColumnIndex($pColumn2).$pRow2; |
|
| 1675 | 1675 | return $this->mergeCells($cellRange); |
| 1676 | 1676 | } |
| 1677 | 1677 | |
@@ -1687,11 +1687,11 @@ discard block |
||
| 1687 | 1687 | // Uppercase coordinate |
| 1688 | 1688 | $pRange = strtoupper($pRange); |
| 1689 | 1689 | |
| 1690 | - if (strpos($pRange,':') !== false) { |
|
| 1690 | + if (strpos($pRange, ':') !== false) { |
|
| 1691 | 1691 | if (isset($this->_mergeCells[$pRange])) { |
| 1692 | 1692 | unset($this->_mergeCells[$pRange]); |
| 1693 | 1693 | } else { |
| 1694 | - throw new Exception('Cell range ' . $pRange . ' not known as merged.'); |
|
| 1694 | + throw new Exception('Cell range '.$pRange.' not known as merged.'); |
|
| 1695 | 1695 | } |
| 1696 | 1696 | } else { |
| 1697 | 1697 | throw new Exception('Merge can only be removed from a range of cells.'); |
@@ -1712,7 +1712,7 @@ discard block |
||
| 1712 | 1712 | */ |
| 1713 | 1713 | public function unmergeCellsByColumnAndRow($pColumn1 = 0, $pRow1 = 1, $pColumn2 = 0, $pRow2 = 1) |
| 1714 | 1714 | { |
| 1715 | - $cellRange = PHPExcel_Cell::stringFromColumnIndex($pColumn1) . $pRow1 . ':' . PHPExcel_Cell::stringFromColumnIndex($pColumn2) . $pRow2; |
|
| 1715 | + $cellRange = PHPExcel_Cell::stringFromColumnIndex($pColumn1).$pRow1.':'.PHPExcel_Cell::stringFromColumnIndex($pColumn2).$pRow2; |
|
| 1716 | 1716 | return $this->unmergeCells($cellRange); |
| 1717 | 1717 | } |
| 1718 | 1718 | |
@@ -1753,7 +1753,7 @@ discard block |
||
| 1753 | 1753 | // Uppercase coordinate |
| 1754 | 1754 | $pRange = strtoupper($pRange); |
| 1755 | 1755 | |
| 1756 | - if (!$pAlreadyHashed) { |
|
| 1756 | + if ( ! $pAlreadyHashed) { |
|
| 1757 | 1757 | $pPassword = PHPExcel_Shared_PasswordHasher::hashPassword($pPassword); |
| 1758 | 1758 | } |
| 1759 | 1759 | $this->_protectedCells[$pRange] = $pPassword; |
@@ -1775,7 +1775,7 @@ discard block |
||
| 1775 | 1775 | */ |
| 1776 | 1776 | public function protectCellsByColumnAndRow($pColumn1 = 0, $pRow1 = 1, $pColumn2 = 0, $pRow2 = 1, $pPassword = '', $pAlreadyHashed = false) |
| 1777 | 1777 | { |
| 1778 | - $cellRange = PHPExcel_Cell::stringFromColumnIndex($pColumn1) . $pRow1 . ':' . PHPExcel_Cell::stringFromColumnIndex($pColumn2) . $pRow2; |
|
| 1778 | + $cellRange = PHPExcel_Cell::stringFromColumnIndex($pColumn1).$pRow1.':'.PHPExcel_Cell::stringFromColumnIndex($pColumn2).$pRow2; |
|
| 1779 | 1779 | return $this->protectCells($cellRange, $pPassword, $pAlreadyHashed); |
| 1780 | 1780 | } |
| 1781 | 1781 | |
@@ -1794,7 +1794,7 @@ discard block |
||
| 1794 | 1794 | if (isset($this->_protectedCells[$pRange])) { |
| 1795 | 1795 | unset($this->_protectedCells[$pRange]); |
| 1796 | 1796 | } else { |
| 1797 | - throw new Exception('Cell range ' . $pRange . ' not known as protected.'); |
|
| 1797 | + throw new Exception('Cell range '.$pRange.' not known as protected.'); |
|
| 1798 | 1798 | } |
| 1799 | 1799 | return $this; |
| 1800 | 1800 | } |
@@ -1813,7 +1813,7 @@ discard block |
||
| 1813 | 1813 | */ |
| 1814 | 1814 | public function unprotectCellsByColumnAndRow($pColumn1 = 0, $pRow1 = 1, $pColumn2 = 0, $pRow2 = 1, $pPassword = '', $pAlreadyHashed = false) |
| 1815 | 1815 | { |
| 1816 | - $cellRange = PHPExcel_Cell::stringFromColumnIndex($pColumn1) . $pRow1 . ':' . PHPExcel_Cell::stringFromColumnIndex($pColumn2) . $pRow2; |
|
| 1816 | + $cellRange = PHPExcel_Cell::stringFromColumnIndex($pColumn1).$pRow1.':'.PHPExcel_Cell::stringFromColumnIndex($pColumn2).$pRow2; |
|
| 1817 | 1817 | return $this->unprotectCells($cellRange, $pPassword, $pAlreadyHashed); |
| 1818 | 1818 | } |
| 1819 | 1819 | |
@@ -1849,7 +1849,7 @@ discard block |
||
| 1849 | 1849 | // Uppercase coordinate |
| 1850 | 1850 | $pRange = strtoupper($pRange); |
| 1851 | 1851 | |
| 1852 | - if (strpos($pRange,':') !== false) { |
|
| 1852 | + if (strpos($pRange, ':') !== false) { |
|
| 1853 | 1853 | $this->_autoFilter = $pRange; |
| 1854 | 1854 | $this->_dirty = true; |
| 1855 | 1855 | } else { |
@@ -1871,9 +1871,9 @@ discard block |
||
| 1871 | 1871 | public function setAutoFilterByColumnAndRow($pColumn1 = 0, $pRow1 = 1, $pColumn2 = 0, $pRow2 = 1) |
| 1872 | 1872 | { |
| 1873 | 1873 | return $this->setAutoFilter( |
| 1874 | - PHPExcel_Cell::stringFromColumnIndex($pColumn1) . $pRow1 |
|
| 1875 | - . ':' . |
|
| 1876 | - PHPExcel_Cell::stringFromColumnIndex($pColumn2) . $pRow2 |
|
| 1874 | + PHPExcel_Cell::stringFromColumnIndex($pColumn1).$pRow1 |
|
| 1875 | + . ':'. |
|
| 1876 | + PHPExcel_Cell::stringFromColumnIndex($pColumn2).$pRow2 |
|
| 1877 | 1877 | ); |
| 1878 | 1878 | } |
| 1879 | 1879 | |
@@ -1910,7 +1910,7 @@ discard block |
||
| 1910 | 1910 | // Uppercase coordinate |
| 1911 | 1911 | $pCell = strtoupper($pCell); |
| 1912 | 1912 | |
| 1913 | - if (strpos($pCell,':') === false && strpos($pCell,',') === false) { |
|
| 1913 | + if (strpos($pCell, ':') === false && strpos($pCell, ',') === false) { |
|
| 1914 | 1914 | $this->_freezePane = $pCell; |
| 1915 | 1915 | } else { |
| 1916 | 1916 | throw new Exception('Freeze pane can not be set on a range of cells.'); |
@@ -1928,7 +1928,7 @@ discard block |
||
| 1928 | 1928 | */ |
| 1929 | 1929 | public function freezePaneByColumnAndRow($pColumn = 0, $pRow = 1) |
| 1930 | 1930 | { |
| 1931 | - return $this->freezePane(PHPExcel_Cell::stringFromColumnIndex($pColumn) . $pRow); |
|
| 1931 | + return $this->freezePane(PHPExcel_Cell::stringFromColumnIndex($pColumn).$pRow); |
|
| 1932 | 1932 | } |
| 1933 | 1933 | |
| 1934 | 1934 | /** |
@@ -1952,7 +1952,7 @@ discard block |
||
| 1952 | 1952 | public function insertNewRowBefore($pBefore = 1, $pNumRows = 1) { |
| 1953 | 1953 | if ($pBefore >= 1) { |
| 1954 | 1954 | $objReferenceHelper = PHPExcel_ReferenceHelper::getInstance(); |
| 1955 | - $objReferenceHelper->insertNewBefore('A' . $pBefore, 0, $pNumRows, $this); |
|
| 1955 | + $objReferenceHelper->insertNewBefore('A'.$pBefore, 0, $pNumRows, $this); |
|
| 1956 | 1956 | } else { |
| 1957 | 1957 | throw new Exception("Rows can only be inserted before at least row 1."); |
| 1958 | 1958 | } |
@@ -1968,9 +1968,9 @@ discard block |
||
| 1968 | 1968 | * @return PHPExcel_Worksheet |
| 1969 | 1969 | */ |
| 1970 | 1970 | public function insertNewColumnBefore($pBefore = 'A', $pNumCols = 1) { |
| 1971 | - if (!is_numeric($pBefore)) { |
|
| 1971 | + if ( ! is_numeric($pBefore)) { |
|
| 1972 | 1972 | $objReferenceHelper = PHPExcel_ReferenceHelper::getInstance(); |
| 1973 | - $objReferenceHelper->insertNewBefore($pBefore . '1', $pNumCols, 0, $this); |
|
| 1973 | + $objReferenceHelper->insertNewBefore($pBefore.'1', $pNumCols, 0, $this); |
|
| 1974 | 1974 | } else { |
| 1975 | 1975 | throw new Exception("Column references should not be numeric."); |
| 1976 | 1976 | } |
@@ -2004,7 +2004,7 @@ discard block |
||
| 2004 | 2004 | public function removeRow($pRow = 1, $pNumRows = 1) { |
| 2005 | 2005 | if ($pRow >= 1) { |
| 2006 | 2006 | $objReferenceHelper = PHPExcel_ReferenceHelper::getInstance(); |
| 2007 | - $objReferenceHelper->insertNewBefore('A' . ($pRow + $pNumRows), 0, -$pNumRows, $this); |
|
| 2007 | + $objReferenceHelper->insertNewBefore('A'.($pRow + $pNumRows), 0, -$pNumRows, $this); |
|
| 2008 | 2008 | } else { |
| 2009 | 2009 | throw new Exception("Rows to be deleted should at least start from row 1."); |
| 2010 | 2010 | } |
@@ -2020,10 +2020,10 @@ discard block |
||
| 2020 | 2020 | * @return PHPExcel_Worksheet |
| 2021 | 2021 | */ |
| 2022 | 2022 | public function removeColumn($pColumn = 'A', $pNumCols = 1) { |
| 2023 | - if (!is_numeric($pColumn)) { |
|
| 2023 | + if ( ! is_numeric($pColumn)) { |
|
| 2024 | 2024 | $pColumn = PHPExcel_Cell::stringFromColumnIndex(PHPExcel_Cell::columnIndexFromString($pColumn) - 1 + $pNumCols); |
| 2025 | 2025 | $objReferenceHelper = PHPExcel_ReferenceHelper::getInstance(); |
| 2026 | - $objReferenceHelper->insertNewBefore($pColumn . '1', -$pNumCols, 0, $this); |
|
| 2026 | + $objReferenceHelper->insertNewBefore($pColumn.'1', -$pNumCols, 0, $this); |
|
| 2027 | 2027 | } else { |
| 2028 | 2028 | throw new Exception("Column references should not be numeric."); |
| 2029 | 2029 | } |
@@ -2181,9 +2181,9 @@ discard block |
||
| 2181 | 2181 | // Uppercase coordinate |
| 2182 | 2182 | $pCellCoordinate = strtoupper($pCellCoordinate); |
| 2183 | 2183 | |
| 2184 | - if (strpos($pCellCoordinate,':') !== false || strpos($pCellCoordinate,',') !== false) { |
|
| 2184 | + if (strpos($pCellCoordinate, ':') !== false || strpos($pCellCoordinate, ',') !== false) { |
|
| 2185 | 2185 | throw new Exception('Cell coordinate string can not be a range of cells.'); |
| 2186 | - } else if (strpos($pCellCoordinate,'$') !== false) { |
|
| 2186 | + } else if (strpos($pCellCoordinate, '$') !== false) { |
|
| 2187 | 2187 | throw new Exception('Cell coordinate string must not be absolute.'); |
| 2188 | 2188 | } else if ($pCellCoordinate == '') { |
| 2189 | 2189 | throw new Exception('Cell coordinate can not be zero-length string.'); |
@@ -2209,7 +2209,7 @@ discard block |
||
| 2209 | 2209 | */ |
| 2210 | 2210 | public function getCommentByColumnAndRow($pColumn = 0, $pRow = 1) |
| 2211 | 2211 | { |
| 2212 | - return $this->getComment(PHPExcel_Cell::stringFromColumnIndex($pColumn) . $pRow); |
|
| 2212 | + return $this->getComment(PHPExcel_Cell::stringFromColumnIndex($pColumn).$pRow); |
|
| 2213 | 2213 | } |
| 2214 | 2214 | |
| 2215 | 2215 | /** |
@@ -2278,8 +2278,8 @@ discard block |
||
| 2278 | 2278 | // Convert '1:3' to 'A1:XFD3' |
| 2279 | 2279 | $pCoordinate = preg_replace('/^([0-9]+):([0-9]+)$/', 'A${1}:XFD${2}', $pCoordinate); |
| 2280 | 2280 | |
| 2281 | - if (strpos($pCoordinate,':') !== false || strpos($pCoordinate,',') !== false) { |
|
| 2282 | - list($first, ) = PHPExcel_Cell::splitRange($pCoordinate); |
|
| 2281 | + if (strpos($pCoordinate, ':') !== false || strpos($pCoordinate, ',') !== false) { |
|
| 2282 | + list($first,) = PHPExcel_Cell::splitRange($pCoordinate); |
|
| 2283 | 2283 | $this->_activeCell = $first[0]; |
| 2284 | 2284 | } else { |
| 2285 | 2285 | $this->_activeCell = $pCoordinate; |
@@ -2298,7 +2298,7 @@ discard block |
||
| 2298 | 2298 | */ |
| 2299 | 2299 | public function setSelectedCellByColumnAndRow($pColumn = 0, $pRow = 1) |
| 2300 | 2300 | { |
| 2301 | - return $this->setSelectedCells(PHPExcel_Cell::stringFromColumnIndex($pColumn) . $pRow); |
|
| 2301 | + return $this->setSelectedCells(PHPExcel_Cell::stringFromColumnIndex($pColumn).$pRow); |
|
| 2302 | 2302 | } |
| 2303 | 2303 | |
| 2304 | 2304 | /** |
@@ -2334,7 +2334,7 @@ discard block |
||
| 2334 | 2334 | public function fromArray($source = null, $nullValue = null, $startCell = 'A1', $strictNullComparison = false) { |
| 2335 | 2335 | if (is_array($source)) { |
| 2336 | 2336 | // Convert a 1-D array to 2-D (for ease of looping) |
| 2337 | - if (!is_array(end($source))) { |
|
| 2337 | + if ( ! is_array(end($source))) { |
|
| 2338 | 2338 | $source = array($source); |
| 2339 | 2339 | } |
| 2340 | 2340 | |
@@ -2344,16 +2344,16 @@ discard block |
||
| 2344 | 2344 | // Loop through $source |
| 2345 | 2345 | foreach ($source as $rowData) { |
| 2346 | 2346 | $currentColumn = $startColumn; |
| 2347 | - foreach($rowData as $cellValue) { |
|
| 2347 | + foreach ($rowData as $cellValue) { |
|
| 2348 | 2348 | if ($strictNullComparison) { |
| 2349 | 2349 | if ($cellValue !== $nullValue) { |
| 2350 | 2350 | // Set cell value |
| 2351 | - $this->getCell($currentColumn . $startRow)->setValue($cellValue); |
|
| 2351 | + $this->getCell($currentColumn.$startRow)->setValue($cellValue); |
|
| 2352 | 2352 | } |
| 2353 | 2353 | } else { |
| 2354 | 2354 | if ($cellValue != $nullValue) { |
| 2355 | 2355 | // Set cell value |
| 2356 | - $this->getCell($currentColumn . $startRow)->setValue($cellValue); |
|
| 2356 | + $this->getCell($currentColumn.$startRow)->setValue($cellValue); |
|
| 2357 | 2357 | } |
| 2358 | 2358 | } |
| 2359 | 2359 | ++$currentColumn; |
@@ -2383,9 +2383,9 @@ discard block |
||
| 2383 | 2383 | |
| 2384 | 2384 | // Identify the range that we need to extract from the worksheet |
| 2385 | 2385 | list($rangeStart, $rangeEnd) = PHPExcel_Cell::rangeBoundaries($pRange); |
| 2386 | - $minCol = PHPExcel_Cell::stringFromColumnIndex($rangeStart[0] -1); |
|
| 2386 | + $minCol = PHPExcel_Cell::stringFromColumnIndex($rangeStart[0] - 1); |
|
| 2387 | 2387 | $minRow = $rangeStart[1]; |
| 2388 | - $maxCol = PHPExcel_Cell::stringFromColumnIndex($rangeEnd[0] -1); |
|
| 2388 | + $maxCol = PHPExcel_Cell::stringFromColumnIndex($rangeEnd[0] - 1); |
|
| 2389 | 2389 | $maxRow = $rangeEnd[1]; |
| 2390 | 2390 | |
| 2391 | 2391 | $maxCol++; |
@@ -2452,7 +2452,7 @@ discard block |
||
| 2452 | 2452 | $pWorkSheet = $namedRange->getWorksheet(); |
| 2453 | 2453 | $pCellRange = $namedRange->getRange(); |
| 2454 | 2454 | |
| 2455 | - return $pWorkSheet->rangeToArray( $pCellRange, |
|
| 2455 | + return $pWorkSheet->rangeToArray($pCellRange, |
|
| 2456 | 2456 | $nullValue, $calculateFormulas, $formatData, $returnCellRef); |
| 2457 | 2457 | } |
| 2458 | 2458 | |
@@ -2478,7 +2478,7 @@ discard block |
||
| 2478 | 2478 | $maxCol = $this->getHighestColumn(); |
| 2479 | 2479 | $maxRow = $this->getHighestRow(); |
| 2480 | 2480 | // Return |
| 2481 | - return $this->rangeToArray( 'A1:'.$maxCol.$maxRow, |
|
| 2481 | + return $this->rangeToArray('A1:'.$maxCol.$maxRow, |
|
| 2482 | 2482 | $nullValue, $calculateFormulas, $formatData, $returnCellRef); |
| 2483 | 2483 | } |
| 2484 | 2484 | |
@@ -2489,7 +2489,7 @@ discard block |
||
| 2489 | 2489 | * @return PHPExcel_Worksheet_RowIterator |
| 2490 | 2490 | */ |
| 2491 | 2491 | public function getRowIterator($startRow = 1) { |
| 2492 | - return new PHPExcel_Worksheet_RowIterator($this,$startRow); |
|
| 2492 | + return new PHPExcel_Worksheet_RowIterator($this, $startRow); |
|
| 2493 | 2493 | } |
| 2494 | 2494 | |
| 2495 | 2495 | /** |
@@ -2514,12 +2514,12 @@ discard block |
||
| 2514 | 2514 | |
| 2515 | 2515 | // Loop through column dimensions |
| 2516 | 2516 | foreach ($this->_columnDimensions as $dimension) { |
| 2517 | - $highestColumn = max($highestColumn,PHPExcel_Cell::columnIndexFromString($dimension->getColumnIndex())); |
|
| 2517 | + $highestColumn = max($highestColumn, PHPExcel_Cell::columnIndexFromString($dimension->getColumnIndex())); |
|
| 2518 | 2518 | } |
| 2519 | 2519 | |
| 2520 | 2520 | // Loop through row dimensions |
| 2521 | 2521 | foreach ($this->_rowDimensions as $dimension) { |
| 2522 | - $highestRow = max($highestRow,$dimension->getRowIndex()); |
|
| 2522 | + $highestRow = max($highestRow, $dimension->getRowIndex()); |
|
| 2523 | 2523 | } |
| 2524 | 2524 | |
| 2525 | 2525 | // Cache values |
@@ -2541,9 +2541,9 @@ discard block |
||
| 2541 | 2541 | */ |
| 2542 | 2542 | public function getHashCode() { |
| 2543 | 2543 | if ($this->_dirty) { |
| 2544 | - $this->_hash = md5( $this->_title . |
|
| 2545 | - $this->_autoFilter . |
|
| 2546 | - ($this->_protection->isProtectionEnabled() ? 't' : 'f') . |
|
| 2544 | + $this->_hash = md5($this->_title. |
|
| 2545 | + $this->_autoFilter. |
|
| 2546 | + ($this->_protection->isProtectionEnabled() ? 't' : 'f'). |
|
| 2547 | 2547 | __CLASS__ |
| 2548 | 2548 | ); |
| 2549 | 2549 | $this->_dirty = false; |
@@ -2568,7 +2568,7 @@ discard block |
||
| 2568 | 2568 | } |
| 2569 | 2569 | |
| 2570 | 2570 | if ($returnRange) { |
| 2571 | - return array( trim(substr($pRange, 0, $sep),"'"), |
|
| 2571 | + return array(trim(substr($pRange, 0, $sep), "'"), |
|
| 2572 | 2572 | substr($pRange, $sep + 1) |
| 2573 | 2573 | ); |
| 2574 | 2574 | } |
@@ -2697,7 +2697,7 @@ discard block |
||
| 2697 | 2697 | $maxRow = $this->getHighestRow(); |
| 2698 | 2698 | $maxCol = PHPExcel_Cell::columnIndexFromString($maxCol); |
| 2699 | 2699 | |
| 2700 | - $rangeBlocks = explode(' ',$range); |
|
| 2700 | + $rangeBlocks = explode(' ', $range); |
|
| 2701 | 2701 | foreach ($rangeBlocks as &$rangeSet) { |
| 2702 | 2702 | $rangeBoundaries = PHPExcel_Cell::getRangeBoundaries($rangeSet); |
| 2703 | 2703 | |
@@ -2708,7 +2708,7 @@ discard block |
||
| 2708 | 2708 | $rangeSet = $rangeBoundaries[0][0].$rangeBoundaries[0][1].':'.$rangeBoundaries[1][0].$rangeBoundaries[1][1]; |
| 2709 | 2709 | } |
| 2710 | 2710 | unset($rangeSet); |
| 2711 | - $stRange = implode(' ',$rangeBlocks); |
|
| 2711 | + $stRange = implode(' ', $rangeBlocks); |
|
| 2712 | 2712 | |
| 2713 | 2713 | return $stRange; |
| 2714 | 2714 | } |
@@ -719,7 +719,9 @@ discard block |
||
| 719 | 719 | |
| 720 | 720 | // adjust column widths |
| 721 | 721 | foreach ($autoSizes as $columnIndex => $width) { |
| 722 | - if ($width == -1) $width = $this->getDefaultColumnDimension()->getWidth(); |
|
| 722 | + if ($width == -1) { |
|
| 723 | + $width = $this->getDefaultColumnDimension()->getWidth(); |
|
| 724 | + } |
|
| 723 | 725 | $this->getColumnDimension($columnIndex)->setWidth($width); |
| 724 | 726 | } |
| 725 | 727 | } |
@@ -821,8 +823,9 @@ discard block |
||
| 821 | 823 | |
| 822 | 824 | // New title |
| 823 | 825 | $newTitle = $this->getTitle(); |
| 824 | - if ($updateFormulaCellReferences) |
|
| 825 | - PHPExcel_ReferenceHelper::getInstance()->updateNamedFormulas($this->getParent(), $oldTitle, $newTitle); |
|
| 826 | + if ($updateFormulaCellReferences) { |
|
| 827 | + PHPExcel_ReferenceHelper::getInstance()->updateNamedFormulas($this->getParent(), $oldTitle, $newTitle); |
|
| 828 | + } |
|
| 826 | 829 | |
| 827 | 830 | return $this; |
| 828 | 831 | } |
@@ -1121,8 +1124,9 @@ discard block |
||
| 1121 | 1124 | $cell = $this->_cellCollection->addCacheData($pCoordinate,new PHPExcel_Cell($aCoordinates[0], $aCoordinates[1], null, PHPExcel_Cell_DataType::TYPE_NULL, $this)); |
| 1122 | 1125 | $this->_cellCollectionIsSorted = false; |
| 1123 | 1126 | |
| 1124 | - if (PHPExcel_Cell::columnIndexFromString($this->_cachedHighestColumn) < PHPExcel_Cell::columnIndexFromString($aCoordinates[0])) |
|
| 1125 | - $this->_cachedHighestColumn = $aCoordinates[0]; |
|
| 1127 | + if (PHPExcel_Cell::columnIndexFromString($this->_cachedHighestColumn) < PHPExcel_Cell::columnIndexFromString($aCoordinates[0])) { |
|
| 1128 | + $this->_cachedHighestColumn = $aCoordinates[0]; |
|
| 1129 | + } |
|
| 1126 | 1130 | |
| 1127 | 1131 | $this->_cachedHighestRow = max($this->_cachedHighestRow,$aCoordinates[1]); |
| 1128 | 1132 | |
@@ -1161,8 +1165,9 @@ discard block |
||
| 1161 | 1165 | $cell = $this->_cellCollection->addCacheData($coordinate, new PHPExcel_Cell($columnLetter, $pRow, null, PHPExcel_Cell_DataType::TYPE_NULL, $this)); |
| 1162 | 1166 | $this->_cellCollectionIsSorted = false; |
| 1163 | 1167 | |
| 1164 | - if (PHPExcel_Cell::columnIndexFromString($this->_cachedHighestColumn) < $pColumn) |
|
| 1165 | - $this->_cachedHighestColumn = $columnLetter; |
|
| 1168 | + if (PHPExcel_Cell::columnIndexFromString($this->_cachedHighestColumn) < $pColumn) { |
|
| 1169 | + $this->_cachedHighestColumn = $columnLetter; |
|
| 1170 | + } |
|
| 1166 | 1171 | |
| 1167 | 1172 | $this->_cachedHighestRow = max($this->_cachedHighestRow,$pRow); |
| 1168 | 1173 | |
@@ -1266,8 +1271,9 @@ discard block |
||
| 1266 | 1271 | if (!isset($this->_columnDimensions[$pColumn])) { |
| 1267 | 1272 | $this->_columnDimensions[$pColumn] = new PHPExcel_Worksheet_ColumnDimension($pColumn); |
| 1268 | 1273 | |
| 1269 | - if (PHPExcel_Cell::columnIndexFromString($this->_cachedHighestColumn) < PHPExcel_Cell::columnIndexFromString($pColumn)) |
|
| 1270 | - $this->_cachedHighestColumn = $pColumn; |
|
| 1274 | + if (PHPExcel_Cell::columnIndexFromString($this->_cachedHighestColumn) < PHPExcel_Cell::columnIndexFromString($pColumn)) { |
|
| 1275 | + $this->_cachedHighestColumn = $pColumn; |
|
| 1276 | + } |
|
| 1271 | 1277 | } |
| 1272 | 1278 | return $this->_columnDimensions[$pColumn]; |
| 1273 | 1279 | } |
@@ -2721,8 +2727,9 @@ discard block |
||
| 2721 | 2727 | */ |
| 2722 | 2728 | public function getTabColor() |
| 2723 | 2729 | { |
| 2724 | - if ($this->_tabColor === NULL) |
|
| 2725 | - $this->_tabColor = new PHPExcel_Style_Color(); |
|
| 2730 | + if ($this->_tabColor === NULL) { |
|
| 2731 | + $this->_tabColor = new PHPExcel_Style_Color(); |
|
| 2732 | + } |
|
| 2726 | 2733 | |
| 2727 | 2734 | return $this->_tabColor; |
| 2728 | 2735 | } |
@@ -221,17 +221,17 @@ discard block |
||
| 221 | 221 | private $_showGridlines = true; |
| 222 | 222 | |
| 223 | 223 | /** |
| 224 | - * Print gridlines? |
|
| 225 | - * |
|
| 226 | - * @var boolean |
|
| 227 | - */ |
|
| 224 | + * Print gridlines? |
|
| 225 | + * |
|
| 226 | + * @var boolean |
|
| 227 | + */ |
|
| 228 | 228 | private $_printGridlines = false; |
| 229 | 229 | |
| 230 | 230 | /** |
| 231 | - * Show row and column headers? |
|
| 232 | - * |
|
| 233 | - * @var boolean |
|
| 234 | - */ |
|
| 231 | + * Show row and column headers? |
|
| 232 | + * |
|
| 233 | + * @var boolean |
|
| 234 | + */ |
|
| 235 | 235 | private $_showRowColHeaders = true; |
| 236 | 236 | |
| 237 | 237 | /** |
@@ -355,8 +355,8 @@ discard block |
||
| 355 | 355 | // Drawing collection |
| 356 | 356 | $this->_drawingCollection = new ArrayObject(); |
| 357 | 357 | |
| 358 | - // Chart collection |
|
| 359 | - $this->_chartCollection = new ArrayObject(); |
|
| 358 | + // Chart collection |
|
| 359 | + $this->_chartCollection = new ArrayObject(); |
|
| 360 | 360 | |
| 361 | 361 | // Protection |
| 362 | 362 | $this->_protection = new PHPExcel_Worksheet_Protection(); |
@@ -1877,16 +1877,16 @@ discard block |
||
| 1877 | 1877 | ); |
| 1878 | 1878 | } |
| 1879 | 1879 | |
| 1880 | - /** |
|
| 1881 | - * Remove autofilter |
|
| 1882 | - * |
|
| 1883 | - * @return PHPExcel_Worksheet |
|
| 1884 | - */ |
|
| 1885 | - public function removeAutoFilter() |
|
| 1886 | - { |
|
| 1887 | - $this->_autoFilter = ''; |
|
| 1888 | - return $this; |
|
| 1889 | - } |
|
| 1880 | + /** |
|
| 1881 | + * Remove autofilter |
|
| 1882 | + * |
|
| 1883 | + * @return PHPExcel_Worksheet |
|
| 1884 | + */ |
|
| 1885 | + public function removeAutoFilter() |
|
| 1886 | + { |
|
| 1887 | + $this->_autoFilter = ''; |
|
| 1888 | + return $this; |
|
| 1889 | + } |
|
| 1890 | 1890 | |
| 1891 | 1891 | /** |
| 1892 | 1892 | * Get Freeze Pane |
@@ -2067,40 +2067,40 @@ discard block |
||
| 2067 | 2067 | } |
| 2068 | 2068 | |
| 2069 | 2069 | /** |
| 2070 | - * Print gridlines? |
|
| 2071 | - * |
|
| 2072 | - * @return boolean |
|
| 2073 | - */ |
|
| 2070 | + * Print gridlines? |
|
| 2071 | + * |
|
| 2072 | + * @return boolean |
|
| 2073 | + */ |
|
| 2074 | 2074 | public function getPrintGridlines() { |
| 2075 | 2075 | return $this->_printGridlines; |
| 2076 | 2076 | } |
| 2077 | 2077 | |
| 2078 | 2078 | /** |
| 2079 | - * Set print gridlines |
|
| 2080 | - * |
|
| 2081 | - * @param boolean $pValue Print gridlines (true/false) |
|
| 2082 | - * @return PHPExcel_Worksheet |
|
| 2083 | - */ |
|
| 2079 | + * Set print gridlines |
|
| 2080 | + * |
|
| 2081 | + * @param boolean $pValue Print gridlines (true/false) |
|
| 2082 | + * @return PHPExcel_Worksheet |
|
| 2083 | + */ |
|
| 2084 | 2084 | public function setPrintGridlines($pValue = false) { |
| 2085 | 2085 | $this->_printGridlines = $pValue; |
| 2086 | 2086 | return $this; |
| 2087 | 2087 | } |
| 2088 | 2088 | |
| 2089 | 2089 | /** |
| 2090 | - * Show row and column headers? |
|
| 2091 | - * |
|
| 2092 | - * @return boolean |
|
| 2093 | - */ |
|
| 2090 | + * Show row and column headers? |
|
| 2091 | + * |
|
| 2092 | + * @return boolean |
|
| 2093 | + */ |
|
| 2094 | 2094 | public function getShowRowColHeaders() { |
| 2095 | 2095 | return $this->_showRowColHeaders; |
| 2096 | 2096 | } |
| 2097 | 2097 | |
| 2098 | 2098 | /** |
| 2099 | - * Set show row and column headers |
|
| 2100 | - * |
|
| 2101 | - * @param boolean $pValue Show row and column headers (true/false) |
|
| 2102 | - * @return PHPExcel_Worksheet |
|
| 2103 | - */ |
|
| 2099 | + * Set show row and column headers |
|
| 2100 | + * |
|
| 2101 | + * @param boolean $pValue Show row and column headers (true/false) |
|
| 2102 | + * @return PHPExcel_Worksheet |
|
| 2103 | + */ |
|
| 2104 | 2104 | public function setShowRowColHeaders($pValue = false) { |
| 2105 | 2105 | $this->_showRowColHeaders = $pValue; |
| 2106 | 2106 | return $this; |
@@ -2485,7 +2485,7 @@ discard block |
||
| 2485 | 2485 | /** |
| 2486 | 2486 | * Get row iterator |
| 2487 | 2487 | * |
| 2488 | - * @param integer $startRow The row number at which to start iterating |
|
| 2488 | + * @param integer $startRow The row number at which to start iterating |
|
| 2489 | 2489 | * @return PHPExcel_Worksheet_RowIterator |
| 2490 | 2490 | */ |
| 2491 | 2491 | public function getRowIterator($startRow = 1) { |
@@ -103,7 +103,7 @@ discard block |
||
| 103 | 103 | /** |
| 104 | 104 | * Get ColumnIndex |
| 105 | 105 | * |
| 106 | - * @return string |
|
| 106 | + * @return integer |
|
| 107 | 107 | */ |
| 108 | 108 | public function getColumnIndex() { |
| 109 | 109 | return $this->_columnIndex; |
@@ -132,7 +132,7 @@ discard block |
||
| 132 | 132 | /** |
| 133 | 133 | * Set Width |
| 134 | 134 | * |
| 135 | - * @param double $pValue |
|
| 135 | + * @param integer $pValue |
|
| 136 | 136 | * @return PHPExcel_Worksheet_ColumnDimension |
| 137 | 137 | */ |
| 138 | 138 | public function setWidth($pValue = -1) { |
@@ -49,35 +49,35 @@ discard block |
||
| 49 | 49 | * |
| 50 | 50 | * @var double |
| 51 | 51 | */ |
| 52 | - private $_width = -1; |
|
| 52 | + private $_width = -1; |
|
| 53 | 53 | |
| 54 | 54 | /** |
| 55 | 55 | * Auto size? |
| 56 | 56 | * |
| 57 | 57 | * @var bool |
| 58 | 58 | */ |
| 59 | - private $_autoSize = false; |
|
| 59 | + private $_autoSize = false; |
|
| 60 | 60 | |
| 61 | 61 | /** |
| 62 | 62 | * Visible? |
| 63 | 63 | * |
| 64 | 64 | * @var bool |
| 65 | 65 | */ |
| 66 | - private $_visible = true; |
|
| 66 | + private $_visible = true; |
|
| 67 | 67 | |
| 68 | 68 | /** |
| 69 | 69 | * Outline level |
| 70 | 70 | * |
| 71 | 71 | * @var int |
| 72 | 72 | */ |
| 73 | - private $_outlineLevel = 0; |
|
| 73 | + private $_outlineLevel = 0; |
|
| 74 | 74 | |
| 75 | 75 | /** |
| 76 | 76 | * Collapsed |
| 77 | 77 | * |
| 78 | 78 | * @var bool |
| 79 | 79 | */ |
| 80 | - private $_collapsed = false; |
|
| 80 | + private $_collapsed = false; |
|
| 81 | 81 | |
| 82 | 82 | /** |
| 83 | 83 | * Index to cellXf |
@@ -94,7 +94,7 @@ discard block |
||
| 94 | 94 | public function __construct($pIndex = 'A') |
| 95 | 95 | { |
| 96 | 96 | // Initialise values |
| 97 | - $this->_columnIndex = $pIndex; |
|
| 97 | + $this->_columnIndex = $pIndex; |
|
| 98 | 98 | |
| 99 | 99 | // set default index to cellXf |
| 100 | 100 | $this->_xfIndex = 0; |
@@ -86,146 +86,146 @@ |
||
| 86 | 86 | */ |
| 87 | 87 | private $_xfIndex; |
| 88 | 88 | |
| 89 | - /** |
|
| 90 | - * Create a new PHPExcel_Worksheet_ColumnDimension |
|
| 91 | - * |
|
| 92 | - * @param string $pIndex Character column index |
|
| 93 | - */ |
|
| 94 | - public function __construct($pIndex = 'A') |
|
| 95 | - { |
|
| 96 | - // Initialise values |
|
| 97 | - $this->_columnIndex = $pIndex; |
|
| 89 | + /** |
|
| 90 | + * Create a new PHPExcel_Worksheet_ColumnDimension |
|
| 91 | + * |
|
| 92 | + * @param string $pIndex Character column index |
|
| 93 | + */ |
|
| 94 | + public function __construct($pIndex = 'A') |
|
| 95 | + { |
|
| 96 | + // Initialise values |
|
| 97 | + $this->_columnIndex = $pIndex; |
|
| 98 | 98 | |
| 99 | 99 | // set default index to cellXf |
| 100 | 100 | $this->_xfIndex = 0; |
| 101 | - } |
|
| 101 | + } |
|
| 102 | 102 | |
| 103 | - /** |
|
| 104 | - * Get ColumnIndex |
|
| 105 | - * |
|
| 106 | - * @return string |
|
| 107 | - */ |
|
| 108 | - public function getColumnIndex() { |
|
| 109 | - return $this->_columnIndex; |
|
| 110 | - } |
|
| 103 | + /** |
|
| 104 | + * Get ColumnIndex |
|
| 105 | + * |
|
| 106 | + * @return string |
|
| 107 | + */ |
|
| 108 | + public function getColumnIndex() { |
|
| 109 | + return $this->_columnIndex; |
|
| 110 | + } |
|
| 111 | 111 | |
| 112 | - /** |
|
| 113 | - * Set ColumnIndex |
|
| 114 | - * |
|
| 115 | - * @param string $pValue |
|
| 116 | - * @return PHPExcel_Worksheet_ColumnDimension |
|
| 117 | - */ |
|
| 118 | - public function setColumnIndex($pValue) { |
|
| 119 | - $this->_columnIndex = $pValue; |
|
| 120 | - return $this; |
|
| 121 | - } |
|
| 112 | + /** |
|
| 113 | + * Set ColumnIndex |
|
| 114 | + * |
|
| 115 | + * @param string $pValue |
|
| 116 | + * @return PHPExcel_Worksheet_ColumnDimension |
|
| 117 | + */ |
|
| 118 | + public function setColumnIndex($pValue) { |
|
| 119 | + $this->_columnIndex = $pValue; |
|
| 120 | + return $this; |
|
| 121 | + } |
|
| 122 | 122 | |
| 123 | - /** |
|
| 124 | - * Get Width |
|
| 125 | - * |
|
| 126 | - * @return double |
|
| 127 | - */ |
|
| 128 | - public function getWidth() { |
|
| 129 | - return $this->_width; |
|
| 130 | - } |
|
| 123 | + /** |
|
| 124 | + * Get Width |
|
| 125 | + * |
|
| 126 | + * @return double |
|
| 127 | + */ |
|
| 128 | + public function getWidth() { |
|
| 129 | + return $this->_width; |
|
| 130 | + } |
|
| 131 | 131 | |
| 132 | - /** |
|
| 133 | - * Set Width |
|
| 134 | - * |
|
| 135 | - * @param double $pValue |
|
| 136 | - * @return PHPExcel_Worksheet_ColumnDimension |
|
| 137 | - */ |
|
| 138 | - public function setWidth($pValue = -1) { |
|
| 139 | - $this->_width = $pValue; |
|
| 140 | - return $this; |
|
| 141 | - } |
|
| 132 | + /** |
|
| 133 | + * Set Width |
|
| 134 | + * |
|
| 135 | + * @param double $pValue |
|
| 136 | + * @return PHPExcel_Worksheet_ColumnDimension |
|
| 137 | + */ |
|
| 138 | + public function setWidth($pValue = -1) { |
|
| 139 | + $this->_width = $pValue; |
|
| 140 | + return $this; |
|
| 141 | + } |
|
| 142 | 142 | |
| 143 | - /** |
|
| 144 | - * Get Auto Size |
|
| 145 | - * |
|
| 146 | - * @return bool |
|
| 147 | - */ |
|
| 148 | - public function getAutoSize() { |
|
| 149 | - return $this->_autoSize; |
|
| 150 | - } |
|
| 143 | + /** |
|
| 144 | + * Get Auto Size |
|
| 145 | + * |
|
| 146 | + * @return bool |
|
| 147 | + */ |
|
| 148 | + public function getAutoSize() { |
|
| 149 | + return $this->_autoSize; |
|
| 150 | + } |
|
| 151 | 151 | |
| 152 | - /** |
|
| 153 | - * Set Auto Size |
|
| 154 | - * |
|
| 155 | - * @param bool $pValue |
|
| 156 | - * @return PHPExcel_Worksheet_ColumnDimension |
|
| 157 | - */ |
|
| 158 | - public function setAutoSize($pValue = false) { |
|
| 159 | - $this->_autoSize = $pValue; |
|
| 160 | - return $this; |
|
| 161 | - } |
|
| 152 | + /** |
|
| 153 | + * Set Auto Size |
|
| 154 | + * |
|
| 155 | + * @param bool $pValue |
|
| 156 | + * @return PHPExcel_Worksheet_ColumnDimension |
|
| 157 | + */ |
|
| 158 | + public function setAutoSize($pValue = false) { |
|
| 159 | + $this->_autoSize = $pValue; |
|
| 160 | + return $this; |
|
| 161 | + } |
|
| 162 | 162 | |
| 163 | - /** |
|
| 164 | - * Get Visible |
|
| 165 | - * |
|
| 166 | - * @return bool |
|
| 167 | - */ |
|
| 168 | - public function getVisible() { |
|
| 169 | - return $this->_visible; |
|
| 170 | - } |
|
| 163 | + /** |
|
| 164 | + * Get Visible |
|
| 165 | + * |
|
| 166 | + * @return bool |
|
| 167 | + */ |
|
| 168 | + public function getVisible() { |
|
| 169 | + return $this->_visible; |
|
| 170 | + } |
|
| 171 | 171 | |
| 172 | - /** |
|
| 173 | - * Set Visible |
|
| 174 | - * |
|
| 175 | - * @param bool $pValue |
|
| 176 | - * @return PHPExcel_Worksheet_ColumnDimension |
|
| 177 | - */ |
|
| 178 | - public function setVisible($pValue = true) { |
|
| 179 | - $this->_visible = $pValue; |
|
| 180 | - return $this; |
|
| 181 | - } |
|
| 172 | + /** |
|
| 173 | + * Set Visible |
|
| 174 | + * |
|
| 175 | + * @param bool $pValue |
|
| 176 | + * @return PHPExcel_Worksheet_ColumnDimension |
|
| 177 | + */ |
|
| 178 | + public function setVisible($pValue = true) { |
|
| 179 | + $this->_visible = $pValue; |
|
| 180 | + return $this; |
|
| 181 | + } |
|
| 182 | 182 | |
| 183 | - /** |
|
| 184 | - * Get Outline Level |
|
| 185 | - * |
|
| 186 | - * @return int |
|
| 187 | - */ |
|
| 188 | - public function getOutlineLevel() { |
|
| 189 | - return $this->_outlineLevel; |
|
| 190 | - } |
|
| 183 | + /** |
|
| 184 | + * Get Outline Level |
|
| 185 | + * |
|
| 186 | + * @return int |
|
| 187 | + */ |
|
| 188 | + public function getOutlineLevel() { |
|
| 189 | + return $this->_outlineLevel; |
|
| 190 | + } |
|
| 191 | 191 | |
| 192 | - /** |
|
| 193 | - * Set Outline Level |
|
| 194 | - * |
|
| 195 | - * Value must be between 0 and 7 |
|
| 196 | - * |
|
| 197 | - * @param int $pValue |
|
| 198 | - * @throws Exception |
|
| 199 | - * @return PHPExcel_Worksheet_ColumnDimension |
|
| 200 | - */ |
|
| 201 | - public function setOutlineLevel($pValue) { |
|
| 202 | - if ($pValue < 0 || $pValue > 7) { |
|
| 203 | - throw new Exception("Outline level must range between 0 and 7."); |
|
| 204 | - } |
|
| 192 | + /** |
|
| 193 | + * Set Outline Level |
|
| 194 | + * |
|
| 195 | + * Value must be between 0 and 7 |
|
| 196 | + * |
|
| 197 | + * @param int $pValue |
|
| 198 | + * @throws Exception |
|
| 199 | + * @return PHPExcel_Worksheet_ColumnDimension |
|
| 200 | + */ |
|
| 201 | + public function setOutlineLevel($pValue) { |
|
| 202 | + if ($pValue < 0 || $pValue > 7) { |
|
| 203 | + throw new Exception("Outline level must range between 0 and 7."); |
|
| 204 | + } |
|
| 205 | 205 | |
| 206 | - $this->_outlineLevel = $pValue; |
|
| 207 | - return $this; |
|
| 208 | - } |
|
| 206 | + $this->_outlineLevel = $pValue; |
|
| 207 | + return $this; |
|
| 208 | + } |
|
| 209 | 209 | |
| 210 | - /** |
|
| 211 | - * Get Collapsed |
|
| 212 | - * |
|
| 213 | - * @return bool |
|
| 214 | - */ |
|
| 215 | - public function getCollapsed() { |
|
| 216 | - return $this->_collapsed; |
|
| 217 | - } |
|
| 210 | + /** |
|
| 211 | + * Get Collapsed |
|
| 212 | + * |
|
| 213 | + * @return bool |
|
| 214 | + */ |
|
| 215 | + public function getCollapsed() { |
|
| 216 | + return $this->_collapsed; |
|
| 217 | + } |
|
| 218 | 218 | |
| 219 | - /** |
|
| 220 | - * Set Collapsed |
|
| 221 | - * |
|
| 222 | - * @param bool $pValue |
|
| 223 | - * @return PHPExcel_Worksheet_ColumnDimension |
|
| 224 | - */ |
|
| 225 | - public function setCollapsed($pValue = true) { |
|
| 226 | - $this->_collapsed = $pValue; |
|
| 227 | - return $this; |
|
| 228 | - } |
|
| 219 | + /** |
|
| 220 | + * Set Collapsed |
|
| 221 | + * |
|
| 222 | + * @param bool $pValue |
|
| 223 | + * @return PHPExcel_Worksheet_ColumnDimension |
|
| 224 | + */ |
|
| 225 | + public function setCollapsed($pValue = true) { |
|
| 226 | + $this->_collapsed = $pValue; |
|
| 227 | + return $this; |
|
| 228 | + } |
|
| 229 | 229 | |
| 230 | 230 | /** |
| 231 | 231 | * Get index to cellXf |
@@ -766,7 +766,7 @@ discard block |
||
| 766 | 766 | * Set first page number |
| 767 | 767 | * |
| 768 | 768 | * @param int $value |
| 769 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
| 769 | + * @return PHPExcel_Worksheet_PageSetup |
|
| 770 | 770 | */ |
| 771 | 771 | public function setFirstPageNumber($value = null) { |
| 772 | 772 | $this->_firstPageNumber = $value; |
@@ -776,7 +776,7 @@ discard block |
||
| 776 | 776 | /** |
| 777 | 777 | * Reset first page number |
| 778 | 778 | * |
| 779 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
| 779 | + * @return PHPExcel_Worksheet_PageSetup |
|
| 780 | 780 | */ |
| 781 | 781 | public function resetFirstPageNumber() { |
| 782 | 782 | return $this->setFirstPageNumber(null); |
@@ -108,24 +108,24 @@ discard block |
||
| 108 | 108 | { |
| 109 | 109 | /* Paper size */ |
| 110 | 110 | const PAPERSIZE_LETTER = 1; |
| 111 | - const PAPERSIZE_LETTER_SMALL = 2; |
|
| 112 | - const PAPERSIZE_TABLOID = 3; |
|
| 111 | + const PAPERSIZE_LETTER_SMALL = 2; |
|
| 112 | + const PAPERSIZE_TABLOID = 3; |
|
| 113 | 113 | const PAPERSIZE_LEDGER = 4; |
| 114 | - const PAPERSIZE_LEGAL = 5; |
|
| 114 | + const PAPERSIZE_LEGAL = 5; |
|
| 115 | 115 | const PAPERSIZE_STATEMENT = 6; |
| 116 | 116 | const PAPERSIZE_EXECUTIVE = 7; |
| 117 | 117 | const PAPERSIZE_A3 = 8; |
| 118 | 118 | const PAPERSIZE_A4 = 9; |
| 119 | - const PAPERSIZE_A4_SMALL = 10; |
|
| 119 | + const PAPERSIZE_A4_SMALL = 10; |
|
| 120 | 120 | const PAPERSIZE_A5 = 11; |
| 121 | 121 | const PAPERSIZE_B4 = 12; |
| 122 | 122 | const PAPERSIZE_B5 = 13; |
| 123 | - const PAPERSIZE_FOLIO = 14; |
|
| 124 | - const PAPERSIZE_QUARTO = 15; |
|
| 123 | + const PAPERSIZE_FOLIO = 14; |
|
| 124 | + const PAPERSIZE_QUARTO = 15; |
|
| 125 | 125 | const PAPERSIZE_STANDARD_1 = 16; |
| 126 | 126 | const PAPERSIZE_STANDARD_2 = 17; |
| 127 | - const PAPERSIZE_NOTE = 18; |
|
| 128 | - const PAPERSIZE_NO9_ENVELOPE = 19; |
|
| 127 | + const PAPERSIZE_NOTE = 18; |
|
| 128 | + const PAPERSIZE_NO9_ENVELOPE = 19; |
|
| 129 | 129 | const PAPERSIZE_NO10_ENVELOPE = 20; |
| 130 | 130 | const PAPERSIZE_NO11_ENVELOPE = 21; |
| 131 | 131 | const PAPERSIZE_NO12_ENVELOPE = 22; |
@@ -143,45 +143,45 @@ discard block |
||
| 143 | 143 | const PAPERSIZE_B5_ENVELOPE = 34; |
| 144 | 144 | const PAPERSIZE_B6_ENVELOPE = 35; |
| 145 | 145 | const PAPERSIZE_ITALY_ENVELOPE = 36; |
| 146 | - const PAPERSIZE_MONARCH_ENVELOPE = 37; |
|
| 146 | + const PAPERSIZE_MONARCH_ENVELOPE = 37; |
|
| 147 | 147 | const PAPERSIZE_6_3_4_ENVELOPE = 38; |
| 148 | 148 | const PAPERSIZE_US_STANDARD_FANFOLD = 39; |
| 149 | 149 | const PAPERSIZE_GERMAN_STANDARD_FANFOLD = 40; |
| 150 | 150 | const PAPERSIZE_GERMAN_LEGAL_FANFOLD = 41; |
| 151 | - const PAPERSIZE_ISO_B4 = 42; |
|
| 151 | + const PAPERSIZE_ISO_B4 = 42; |
|
| 152 | 152 | const PAPERSIZE_JAPANESE_DOUBLE_POSTCARD = 43; |
| 153 | 153 | const PAPERSIZE_STANDARD_PAPER_1 = 44; |
| 154 | 154 | const PAPERSIZE_STANDARD_PAPER_2 = 45; |
| 155 | 155 | const PAPERSIZE_STANDARD_PAPER_3 = 46; |
| 156 | 156 | const PAPERSIZE_INVITE_ENVELOPE = 47; |
| 157 | - const PAPERSIZE_LETTER_EXTRA_PAPER = 48; |
|
| 158 | - const PAPERSIZE_LEGAL_EXTRA_PAPER = 49; |
|
| 157 | + const PAPERSIZE_LETTER_EXTRA_PAPER = 48; |
|
| 158 | + const PAPERSIZE_LEGAL_EXTRA_PAPER = 49; |
|
| 159 | 159 | const PAPERSIZE_TABLOID_EXTRA_PAPER = 50; |
| 160 | - const PAPERSIZE_A4_EXTRA_PAPER = 51; |
|
| 161 | - const PAPERSIZE_LETTER_TRANSVERSE_PAPER = 52; |
|
| 160 | + const PAPERSIZE_A4_EXTRA_PAPER = 51; |
|
| 161 | + const PAPERSIZE_LETTER_TRANSVERSE_PAPER = 52; |
|
| 162 | 162 | const PAPERSIZE_A4_TRANSVERSE_PAPER = 53; |
| 163 | - const PAPERSIZE_LETTER_EXTRA_TRANSVERSE_PAPER = 54; |
|
| 163 | + const PAPERSIZE_LETTER_EXTRA_TRANSVERSE_PAPER = 54; |
|
| 164 | 164 | const PAPERSIZE_SUPERA_SUPERA_A4_PAPER = 55; |
| 165 | 165 | const PAPERSIZE_SUPERB_SUPERB_A3_PAPER = 56; |
| 166 | - const PAPERSIZE_LETTER_PLUS_PAPER = 57; |
|
| 167 | - const PAPERSIZE_A4_PLUS_PAPER = 58; |
|
| 168 | - const PAPERSIZE_A5_TRANSVERSE_PAPER = 59; |
|
| 169 | - const PAPERSIZE_JIS_B5_TRANSVERSE_PAPER = 60; |
|
| 166 | + const PAPERSIZE_LETTER_PLUS_PAPER = 57; |
|
| 167 | + const PAPERSIZE_A4_PLUS_PAPER = 58; |
|
| 168 | + const PAPERSIZE_A5_TRANSVERSE_PAPER = 59; |
|
| 169 | + const PAPERSIZE_JIS_B5_TRANSVERSE_PAPER = 60; |
|
| 170 | 170 | const PAPERSIZE_A3_EXTRA_PAPER = 61; |
| 171 | 171 | const PAPERSIZE_A5_EXTRA_PAPER = 62; |
| 172 | - const PAPERSIZE_ISO_B5_EXTRA_PAPER = 63; |
|
| 173 | - const PAPERSIZE_A2_PAPER = 64; |
|
| 174 | - const PAPERSIZE_A3_TRANSVERSE_PAPER = 65; |
|
| 175 | - const PAPERSIZE_A3_EXTRA_TRANSVERSE_PAPER = 66; |
|
| 172 | + const PAPERSIZE_ISO_B5_EXTRA_PAPER = 63; |
|
| 173 | + const PAPERSIZE_A2_PAPER = 64; |
|
| 174 | + const PAPERSIZE_A3_TRANSVERSE_PAPER = 65; |
|
| 175 | + const PAPERSIZE_A3_EXTRA_TRANSVERSE_PAPER = 66; |
|
| 176 | 176 | |
| 177 | 177 | /* Page orientation */ |
| 178 | - const ORIENTATION_DEFAULT = 'default'; |
|
| 179 | - const ORIENTATION_LANDSCAPE = 'landscape'; |
|
| 180 | - const ORIENTATION_PORTRAIT = 'portrait'; |
|
| 178 | + const ORIENTATION_DEFAULT = 'default'; |
|
| 179 | + const ORIENTATION_LANDSCAPE = 'landscape'; |
|
| 180 | + const ORIENTATION_PORTRAIT = 'portrait'; |
|
| 181 | 181 | |
| 182 | 182 | /* Print Range Set Method */ |
| 183 | - const SETPRINTRANGE_OVERWRITE = 'O'; |
|
| 184 | - const SETPRINTRANGE_INSERT = 'I'; |
|
| 183 | + const SETPRINTRANGE_OVERWRITE = 'O'; |
|
| 184 | + const SETPRINTRANGE_INSERT = 'I'; |
|
| 185 | 185 | |
| 186 | 186 | |
| 187 | 187 | /** |
@@ -189,14 +189,14 @@ discard block |
||
| 189 | 189 | * |
| 190 | 190 | * @var int |
| 191 | 191 | */ |
| 192 | - private $_paperSize = PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER; |
|
| 192 | + private $_paperSize = PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER; |
|
| 193 | 193 | |
| 194 | 194 | /** |
| 195 | 195 | * Orientation |
| 196 | 196 | * |
| 197 | 197 | * @var string |
| 198 | 198 | */ |
| 199 | - private $_orientation = PHPExcel_Worksheet_PageSetup::ORIENTATION_DEFAULT; |
|
| 199 | + private $_orientation = PHPExcel_Worksheet_PageSetup::ORIENTATION_DEFAULT; |
|
| 200 | 200 | |
| 201 | 201 | /** |
| 202 | 202 | * Scale (Print Scale) |
@@ -206,7 +206,7 @@ discard block |
||
| 206 | 206 | * |
| 207 | 207 | * @var int? |
| 208 | 208 | */ |
| 209 | - private $_scale = 100; |
|
| 209 | + private $_scale = 100; |
|
| 210 | 210 | |
| 211 | 211 | /** |
| 212 | 212 | * Fit To Page |
@@ -214,7 +214,7 @@ discard block |
||
| 214 | 214 | * |
| 215 | 215 | * @var boolean |
| 216 | 216 | */ |
| 217 | - private $_fitToPage = FALSE; |
|
| 217 | + private $_fitToPage = FALSE; |
|
| 218 | 218 | |
| 219 | 219 | /** |
| 220 | 220 | * Fit To Height |
@@ -222,7 +222,7 @@ discard block |
||
| 222 | 222 | * |
| 223 | 223 | * @var int? |
| 224 | 224 | */ |
| 225 | - private $_fitToHeight = 1; |
|
| 225 | + private $_fitToHeight = 1; |
|
| 226 | 226 | |
| 227 | 227 | /** |
| 228 | 228 | * Fit To Width |
@@ -230,7 +230,7 @@ discard block |
||
| 230 | 230 | * |
| 231 | 231 | * @var int? |
| 232 | 232 | */ |
| 233 | - private $_fitToWidth = 1; |
|
| 233 | + private $_fitToWidth = 1; |
|
| 234 | 234 | |
| 235 | 235 | /** |
| 236 | 236 | * Columns to repeat at left |
@@ -575,9 +575,9 @@ discard block |
||
| 575 | 575 | if ($index == 0) { |
| 576 | 576 | return $this->_printArea; |
| 577 | 577 | } |
| 578 | - $printAreas = explode(',',$this->_printArea); |
|
| 579 | - if (isset($printAreas[$index-1])) { |
|
| 580 | - return $printAreas[$index-1]; |
|
| 578 | + $printAreas = explode(',', $this->_printArea); |
|
| 579 | + if (isset($printAreas[$index - 1])) { |
|
| 580 | + return $printAreas[$index - 1]; |
|
| 581 | 581 | } |
| 582 | 582 | throw new Exception("Requested Print Area does not exist"); |
| 583 | 583 | } |
@@ -593,10 +593,10 @@ discard block |
||
| 593 | 593 | */ |
| 594 | 594 | public function isPrintAreaSet($index = 0) { |
| 595 | 595 | if ($index == 0) { |
| 596 | - return !is_null($this->_printArea); |
|
| 596 | + return ! is_null($this->_printArea); |
|
| 597 | 597 | } |
| 598 | - $printAreas = explode(',',$this->_printArea); |
|
| 599 | - return isset($printAreas[$index-1]); |
|
| 598 | + $printAreas = explode(',', $this->_printArea); |
|
| 599 | + return isset($printAreas[$index - 1]); |
|
| 600 | 600 | } |
| 601 | 601 | |
| 602 | 602 | /** |
@@ -612,10 +612,10 @@ discard block |
||
| 612 | 612 | if ($index == 0) { |
| 613 | 613 | $this->_printArea = NULL; |
| 614 | 614 | } else { |
| 615 | - $printAreas = explode(',',$this->_printArea); |
|
| 616 | - if (isset($printAreas[$index-1])) { |
|
| 617 | - unset($printAreas[$index-1]); |
|
| 618 | - $this->_printArea = implode(',',$printAreas); |
|
| 615 | + $printAreas = explode(',', $this->_printArea); |
|
| 616 | + if (isset($printAreas[$index - 1])) { |
|
| 617 | + unset($printAreas[$index - 1]); |
|
| 618 | + $this->_printArea = implode(',', $printAreas); |
|
| 619 | 619 | } |
| 620 | 620 | } |
| 621 | 621 | |
@@ -643,11 +643,11 @@ discard block |
||
| 643 | 643 | * @throws Exception |
| 644 | 644 | */ |
| 645 | 645 | public function setPrintArea($value, $index = 0, $method = self::SETPRINTRANGE_OVERWRITE) { |
| 646 | - if (strpos($value,'!') !== false) { |
|
| 646 | + if (strpos($value, '!') !== false) { |
|
| 647 | 647 | throw new Exception('Cell coordinate must not specify a worksheet.'); |
| 648 | - } elseif (strpos($value,':') === false) { |
|
| 648 | + } elseif (strpos($value, ':') === false) { |
|
| 649 | 649 | throw new Exception('Cell coordinate must be a range of cells.'); |
| 650 | - } elseif (strpos($value,'$') !== false) { |
|
| 650 | + } elseif (strpos($value, '$') !== false) { |
|
| 651 | 651 | throw new Exception('Cell coordinate must not be absolute.'); |
| 652 | 652 | } |
| 653 | 653 | $value = strtoupper($value); |
@@ -656,29 +656,29 @@ discard block |
||
| 656 | 656 | if ($index == 0) { |
| 657 | 657 | $this->_printArea = $value; |
| 658 | 658 | } else { |
| 659 | - $printAreas = explode(',',$this->_printArea); |
|
| 660 | - if($index < 0) { |
|
| 659 | + $printAreas = explode(',', $this->_printArea); |
|
| 660 | + if ($index < 0) { |
|
| 661 | 661 | $index = count($printAreas) - abs($index) + 1; |
| 662 | 662 | } |
| 663 | 663 | if (($index <= 0) || ($index > count($printAreas))) { |
| 664 | 664 | throw new Exception('Invalid index for setting print range.'); |
| 665 | 665 | } |
| 666 | - $printAreas[$index-1] = $value; |
|
| 667 | - $this->_printArea = implode(',',$printAreas); |
|
| 666 | + $printAreas[$index - 1] = $value; |
|
| 667 | + $this->_printArea = implode(',', $printAreas); |
|
| 668 | 668 | } |
| 669 | - } elseif($method == self::SETPRINTRANGE_INSERT) { |
|
| 669 | + } elseif ($method == self::SETPRINTRANGE_INSERT) { |
|
| 670 | 670 | if ($index == 0) { |
| 671 | 671 | $this->_printArea .= ($this->_printArea == '') ? $value : ','.$value; |
| 672 | 672 | } else { |
| 673 | - $printAreas = explode(',',$this->_printArea); |
|
| 674 | - if($index < 0) { |
|
| 673 | + $printAreas = explode(',', $this->_printArea); |
|
| 674 | + if ($index < 0) { |
|
| 675 | 675 | $index = abs($index) - 1; |
| 676 | 676 | } |
| 677 | 677 | if ($index > count($printAreas)) { |
| 678 | 678 | throw new Exception('Invalid index for setting print range.'); |
| 679 | 679 | } |
| 680 | - $printAreas = array_merge(array_slice($printAreas,0,$index),array($value),array_slice($printAreas,$index)); |
|
| 681 | - $this->_printArea = implode(',',$printAreas); |
|
| 680 | + $printAreas = array_merge(array_slice($printAreas, 0, $index), array($value), array_slice($printAreas, $index)); |
|
| 681 | + $this->_printArea = implode(',', $printAreas); |
|
| 682 | 682 | } |
| 683 | 683 | } else { |
| 684 | 684 | throw new Exception('Invalid method for setting print range.'); |
@@ -729,7 +729,7 @@ discard block |
||
| 729 | 729 | */ |
| 730 | 730 | public function setPrintAreaByColumnAndRow($column1, $row1, $column2, $row2, $index = 0, $method = self::SETPRINTRANGE_OVERWRITE) |
| 731 | 731 | { |
| 732 | - return $this->setPrintArea(PHPExcel_Cell::stringFromColumnIndex($column1) . $row1 . ':' . PHPExcel_Cell::stringFromColumnIndex($column2) . $row2, $index, $method); |
|
| 732 | + return $this->setPrintArea(PHPExcel_Cell::stringFromColumnIndex($column1).$row1.':'.PHPExcel_Cell::stringFromColumnIndex($column2).$row2, $index, $method); |
|
| 733 | 733 | } |
| 734 | 734 | |
| 735 | 735 | /** |
@@ -750,7 +750,7 @@ discard block |
||
| 750 | 750 | */ |
| 751 | 751 | public function addPrintAreaByColumnAndRow($column1, $row1, $column2, $row2, $index = -1) |
| 752 | 752 | { |
| 753 | - return $this->setPrintArea(PHPExcel_Cell::stringFromColumnIndex($column1) . $row1 . ':' . PHPExcel_Cell::stringFromColumnIndex($column2) . $row2, $index, self::SETPRINTRANGE_INSERT); |
|
| 753 | + return $this->setPrintArea(PHPExcel_Cell::stringFromColumnIndex($column1).$row1.':'.PHPExcel_Cell::stringFromColumnIndex($column2).$row2, $index, self::SETPRINTRANGE_INSERT); |
|
| 754 | 754 | } |
| 755 | 755 | |
| 756 | 756 | /** |
@@ -209,27 +209,27 @@ discard block |
||
| 209 | 209 | private $_scale = 100; |
| 210 | 210 | |
| 211 | 211 | /** |
| 212 | - * Fit To Page |
|
| 213 | - * Whether scale or fitToWith / fitToHeight applies |
|
| 214 | - * |
|
| 215 | - * @var boolean |
|
| 216 | - */ |
|
| 212 | + * Fit To Page |
|
| 213 | + * Whether scale or fitToWith / fitToHeight applies |
|
| 214 | + * |
|
| 215 | + * @var boolean |
|
| 216 | + */ |
|
| 217 | 217 | private $_fitToPage = FALSE; |
| 218 | 218 | |
| 219 | 219 | /** |
| 220 | - * Fit To Height |
|
| 221 | - * Number of vertical pages to fit on |
|
| 222 | - * |
|
| 223 | - * @var int? |
|
| 224 | - */ |
|
| 220 | + * Fit To Height |
|
| 221 | + * Number of vertical pages to fit on |
|
| 222 | + * |
|
| 223 | + * @var int? |
|
| 224 | + */ |
|
| 225 | 225 | private $_fitToHeight = 1; |
| 226 | 226 | |
| 227 | 227 | /** |
| 228 | - * Fit To Width |
|
| 229 | - * Number of horizontal pages to fit on |
|
| 230 | - * |
|
| 231 | - * @var int? |
|
| 232 | - */ |
|
| 228 | + * Fit To Width |
|
| 229 | + * Number of horizontal pages to fit on |
|
| 230 | + * |
|
| 231 | + * @var int? |
|
| 232 | + */ |
|
| 233 | 233 | private $_fitToWidth = 1; |
| 234 | 234 | |
| 235 | 235 | /** |
@@ -274,52 +274,52 @@ discard block |
||
| 274 | 274 | */ |
| 275 | 275 | private $_firstPageNumber = NULL; |
| 276 | 276 | |
| 277 | - /** |
|
| 278 | - * Create a new PHPExcel_Worksheet_PageSetup |
|
| 279 | - */ |
|
| 280 | - public function __construct() |
|
| 281 | - { |
|
| 282 | - } |
|
| 283 | - |
|
| 284 | - /** |
|
| 285 | - * Get Paper Size |
|
| 286 | - * |
|
| 287 | - * @return int |
|
| 288 | - */ |
|
| 289 | - public function getPaperSize() { |
|
| 290 | - return $this->_paperSize; |
|
| 291 | - } |
|
| 292 | - |
|
| 293 | - /** |
|
| 294 | - * Set Paper Size |
|
| 295 | - * |
|
| 296 | - * @param int $pValue |
|
| 297 | - * @return PHPExcel_Worksheet_PageSetup |
|
| 298 | - */ |
|
| 299 | - public function setPaperSize($pValue = PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER) { |
|
| 300 | - $this->_paperSize = $pValue; |
|
| 301 | - return $this; |
|
| 302 | - } |
|
| 303 | - |
|
| 304 | - /** |
|
| 305 | - * Get Orientation |
|
| 306 | - * |
|
| 307 | - * @return string |
|
| 308 | - */ |
|
| 309 | - public function getOrientation() { |
|
| 310 | - return $this->_orientation; |
|
| 311 | - } |
|
| 312 | - |
|
| 313 | - /** |
|
| 314 | - * Set Orientation |
|
| 315 | - * |
|
| 316 | - * @param string $pValue |
|
| 317 | - * @return PHPExcel_Worksheet_PageSetup |
|
| 318 | - */ |
|
| 319 | - public function setOrientation($pValue = PHPExcel_Worksheet_PageSetup::ORIENTATION_DEFAULT) { |
|
| 320 | - $this->_orientation = $pValue; |
|
| 321 | - return $this; |
|
| 322 | - } |
|
| 277 | + /** |
|
| 278 | + * Create a new PHPExcel_Worksheet_PageSetup |
|
| 279 | + */ |
|
| 280 | + public function __construct() |
|
| 281 | + { |
|
| 282 | + } |
|
| 283 | + |
|
| 284 | + /** |
|
| 285 | + * Get Paper Size |
|
| 286 | + * |
|
| 287 | + * @return int |
|
| 288 | + */ |
|
| 289 | + public function getPaperSize() { |
|
| 290 | + return $this->_paperSize; |
|
| 291 | + } |
|
| 292 | + |
|
| 293 | + /** |
|
| 294 | + * Set Paper Size |
|
| 295 | + * |
|
| 296 | + * @param int $pValue |
|
| 297 | + * @return PHPExcel_Worksheet_PageSetup |
|
| 298 | + */ |
|
| 299 | + public function setPaperSize($pValue = PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER) { |
|
| 300 | + $this->_paperSize = $pValue; |
|
| 301 | + return $this; |
|
| 302 | + } |
|
| 303 | + |
|
| 304 | + /** |
|
| 305 | + * Get Orientation |
|
| 306 | + * |
|
| 307 | + * @return string |
|
| 308 | + */ |
|
| 309 | + public function getOrientation() { |
|
| 310 | + return $this->_orientation; |
|
| 311 | + } |
|
| 312 | + |
|
| 313 | + /** |
|
| 314 | + * Set Orientation |
|
| 315 | + * |
|
| 316 | + * @param string $pValue |
|
| 317 | + * @return PHPExcel_Worksheet_PageSetup |
|
| 318 | + */ |
|
| 319 | + public function setOrientation($pValue = PHPExcel_Worksheet_PageSetup::ORIENTATION_DEFAULT) { |
|
| 320 | + $this->_orientation = $pValue; |
|
| 321 | + return $this; |
|
| 322 | + } |
|
| 323 | 323 | |
| 324 | 324 | /** |
| 325 | 325 | * Get Scale |
@@ -619,7 +619,7 @@ discard block |
||
| 619 | 619 | } |
| 620 | 620 | } |
| 621 | 621 | |
| 622 | - return $this; |
|
| 622 | + return $this; |
|
| 623 | 623 | } |
| 624 | 624 | |
| 625 | 625 | /** |
@@ -661,7 +661,7 @@ discard block |
||
| 661 | 661 | $index = count($printAreas) - abs($index) + 1; |
| 662 | 662 | } |
| 663 | 663 | if (($index <= 0) || ($index > count($printAreas))) { |
| 664 | - throw new Exception('Invalid index for setting print range.'); |
|
| 664 | + throw new Exception('Invalid index for setting print range.'); |
|
| 665 | 665 | } |
| 666 | 666 | $printAreas[$index-1] = $value; |
| 667 | 667 | $this->_printArea = implode(',',$printAreas); |
@@ -675,16 +675,16 @@ discard block |
||
| 675 | 675 | $index = abs($index) - 1; |
| 676 | 676 | } |
| 677 | 677 | if ($index > count($printAreas)) { |
| 678 | - throw new Exception('Invalid index for setting print range.'); |
|
| 678 | + throw new Exception('Invalid index for setting print range.'); |
|
| 679 | 679 | } |
| 680 | 680 | $printAreas = array_merge(array_slice($printAreas,0,$index),array($value),array_slice($printAreas,$index)); |
| 681 | 681 | $this->_printArea = implode(',',$printAreas); |
| 682 | 682 | } |
| 683 | 683 | } else { |
| 684 | - throw new Exception('Invalid method for setting print range.'); |
|
| 684 | + throw new Exception('Invalid method for setting print range.'); |
|
| 685 | 685 | } |
| 686 | 686 | |
| 687 | - return $this; |
|
| 687 | + return $this; |
|
| 688 | 688 | } |
| 689 | 689 | |
| 690 | 690 | /** |
@@ -727,10 +727,10 @@ discard block |
||
| 727 | 727 | * @return PHPExcel_Worksheet_PageSetup |
| 728 | 728 | * @throws Exception |
| 729 | 729 | */ |
| 730 | - public function setPrintAreaByColumnAndRow($column1, $row1, $column2, $row2, $index = 0, $method = self::SETPRINTRANGE_OVERWRITE) |
|
| 731 | - { |
|
| 732 | - return $this->setPrintArea(PHPExcel_Cell::stringFromColumnIndex($column1) . $row1 . ':' . PHPExcel_Cell::stringFromColumnIndex($column2) . $row2, $index, $method); |
|
| 733 | - } |
|
| 730 | + public function setPrintAreaByColumnAndRow($column1, $row1, $column2, $row2, $index = 0, $method = self::SETPRINTRANGE_OVERWRITE) |
|
| 731 | + { |
|
| 732 | + return $this->setPrintArea(PHPExcel_Cell::stringFromColumnIndex($column1) . $row1 . ':' . PHPExcel_Cell::stringFromColumnIndex($column2) . $row2, $index, $method); |
|
| 733 | + } |
|
| 734 | 734 | |
| 735 | 735 | /** |
| 736 | 736 | * Add a new print area to the list of print areas |
@@ -748,9 +748,9 @@ discard block |
||
| 748 | 748 | * @return PHPExcel_Worksheet_PageSetup |
| 749 | 749 | * @throws Exception |
| 750 | 750 | */ |
| 751 | - public function addPrintAreaByColumnAndRow($column1, $row1, $column2, $row2, $index = -1) |
|
| 752 | - { |
|
| 753 | - return $this->setPrintArea(PHPExcel_Cell::stringFromColumnIndex($column1) . $row1 . ':' . PHPExcel_Cell::stringFromColumnIndex($column2) . $row2, $index, self::SETPRINTRANGE_INSERT); |
|
| 751 | + public function addPrintAreaByColumnAndRow($column1, $row1, $column2, $row2, $index = -1) |
|
| 752 | + { |
|
| 753 | + return $this->setPrintArea(PHPExcel_Cell::stringFromColumnIndex($column1) . $row1 . ':' . PHPExcel_Cell::stringFromColumnIndex($column2) . $row2, $index, self::SETPRINTRANGE_INSERT); |
|
| 754 | 754 | } |
| 755 | 755 | |
| 756 | 756 | /** |
@@ -758,29 +758,29 @@ discard block |
||
| 758 | 758 | * |
| 759 | 759 | * @return int |
| 760 | 760 | */ |
| 761 | - public function getFirstPageNumber() { |
|
| 761 | + public function getFirstPageNumber() { |
|
| 762 | 762 | return $this->_firstPageNumber; |
| 763 | - } |
|
| 764 | - |
|
| 765 | - /** |
|
| 766 | - * Set first page number |
|
| 767 | - * |
|
| 768 | - * @param int $value |
|
| 769 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
| 770 | - */ |
|
| 771 | - public function setFirstPageNumber($value = null) { |
|
| 763 | + } |
|
| 764 | + |
|
| 765 | + /** |
|
| 766 | + * Set first page number |
|
| 767 | + * |
|
| 768 | + * @param int $value |
|
| 769 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
| 770 | + */ |
|
| 771 | + public function setFirstPageNumber($value = null) { |
|
| 772 | 772 | $this->_firstPageNumber = $value; |
| 773 | 773 | return $this; |
| 774 | - } |
|
| 775 | - |
|
| 776 | - /** |
|
| 777 | - * Reset first page number |
|
| 778 | - * |
|
| 779 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
| 780 | - */ |
|
| 781 | - public function resetFirstPageNumber() { |
|
| 774 | + } |
|
| 775 | + |
|
| 776 | + /** |
|
| 777 | + * Reset first page number |
|
| 778 | + * |
|
| 779 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
| 780 | + */ |
|
| 781 | + public function resetFirstPageNumber() { |
|
| 782 | 782 | return $this->setFirstPageNumber(null); |
| 783 | - } |
|
| 783 | + } |
|
| 784 | 784 | |
| 785 | 785 | /** |
| 786 | 786 | * Implement PHP __clone to create a deep clone, not just a shallow copy. |
@@ -125,7 +125,7 @@ |
||
| 125 | 125 | /** |
| 126 | 126 | * Set Row Height |
| 127 | 127 | * |
| 128 | - * @param double $pValue |
|
| 128 | + * @param integer $pValue |
|
| 129 | 129 | * @return PHPExcel_Worksheet_RowDimension |
| 130 | 130 | */ |
| 131 | 131 | public function setRowHeight($pValue = -1) { |
@@ -49,28 +49,28 @@ discard block |
||
| 49 | 49 | * |
| 50 | 50 | * @var double |
| 51 | 51 | */ |
| 52 | - private $_rowHeight = -1; |
|
| 52 | + private $_rowHeight = -1; |
|
| 53 | 53 | |
| 54 | 54 | /** |
| 55 | 55 | * Visible? |
| 56 | 56 | * |
| 57 | 57 | * @var bool |
| 58 | 58 | */ |
| 59 | - private $_visible = true; |
|
| 59 | + private $_visible = true; |
|
| 60 | 60 | |
| 61 | 61 | /** |
| 62 | 62 | * Outline level |
| 63 | 63 | * |
| 64 | 64 | * @var int |
| 65 | 65 | */ |
| 66 | - private $_outlineLevel = 0; |
|
| 66 | + private $_outlineLevel = 0; |
|
| 67 | 67 | |
| 68 | 68 | /** |
| 69 | 69 | * Collapsed |
| 70 | 70 | * |
| 71 | 71 | * @var bool |
| 72 | 72 | */ |
| 73 | - private $_collapsed = false; |
|
| 73 | + private $_collapsed = false; |
|
| 74 | 74 | |
| 75 | 75 | /** |
| 76 | 76 | * Index to cellXf. Null value means row has no explicit cellXf format. |
@@ -87,7 +87,7 @@ discard block |
||
| 87 | 87 | public function __construct($pIndex = 0) |
| 88 | 88 | { |
| 89 | 89 | // Initialise values |
| 90 | - $this->_rowIndex = $pIndex; |
|
| 90 | + $this->_rowIndex = $pIndex; |
|
| 91 | 91 | |
| 92 | 92 | // set row dimension as unformatted by default |
| 93 | 93 | $this->_xfIndex = null; |
@@ -79,126 +79,126 @@ |
||
| 79 | 79 | */ |
| 80 | 80 | private $_xfIndex; |
| 81 | 81 | |
| 82 | - /** |
|
| 83 | - * Create a new PHPExcel_Worksheet_RowDimension |
|
| 84 | - * |
|
| 85 | - * @param int $pIndex Numeric row index |
|
| 86 | - */ |
|
| 87 | - public function __construct($pIndex = 0) |
|
| 88 | - { |
|
| 89 | - // Initialise values |
|
| 90 | - $this->_rowIndex = $pIndex; |
|
| 82 | + /** |
|
| 83 | + * Create a new PHPExcel_Worksheet_RowDimension |
|
| 84 | + * |
|
| 85 | + * @param int $pIndex Numeric row index |
|
| 86 | + */ |
|
| 87 | + public function __construct($pIndex = 0) |
|
| 88 | + { |
|
| 89 | + // Initialise values |
|
| 90 | + $this->_rowIndex = $pIndex; |
|
| 91 | 91 | |
| 92 | 92 | // set row dimension as unformatted by default |
| 93 | 93 | $this->_xfIndex = null; |
| 94 | - } |
|
| 95 | - |
|
| 96 | - /** |
|
| 97 | - * Get Row Index |
|
| 98 | - * |
|
| 99 | - * @return int |
|
| 100 | - */ |
|
| 101 | - public function getRowIndex() { |
|
| 102 | - return $this->_rowIndex; |
|
| 103 | - } |
|
| 104 | - |
|
| 105 | - /** |
|
| 106 | - * Set Row Index |
|
| 107 | - * |
|
| 108 | - * @param int $pValue |
|
| 109 | - * @return PHPExcel_Worksheet_RowDimension |
|
| 110 | - */ |
|
| 111 | - public function setRowIndex($pValue) { |
|
| 112 | - $this->_rowIndex = $pValue; |
|
| 113 | - return $this; |
|
| 114 | - } |
|
| 115 | - |
|
| 116 | - /** |
|
| 117 | - * Get Row Height |
|
| 118 | - * |
|
| 119 | - * @return double |
|
| 120 | - */ |
|
| 121 | - public function getRowHeight() { |
|
| 122 | - return $this->_rowHeight; |
|
| 123 | - } |
|
| 124 | - |
|
| 125 | - /** |
|
| 126 | - * Set Row Height |
|
| 127 | - * |
|
| 128 | - * @param double $pValue |
|
| 129 | - * @return PHPExcel_Worksheet_RowDimension |
|
| 130 | - */ |
|
| 131 | - public function setRowHeight($pValue = -1) { |
|
| 132 | - $this->_rowHeight = $pValue; |
|
| 133 | - return $this; |
|
| 134 | - } |
|
| 135 | - |
|
| 136 | - /** |
|
| 137 | - * Get Visible |
|
| 138 | - * |
|
| 139 | - * @return bool |
|
| 140 | - */ |
|
| 141 | - public function getVisible() { |
|
| 142 | - return $this->_visible; |
|
| 143 | - } |
|
| 144 | - |
|
| 145 | - /** |
|
| 146 | - * Set Visible |
|
| 147 | - * |
|
| 148 | - * @param bool $pValue |
|
| 149 | - * @return PHPExcel_Worksheet_RowDimension |
|
| 150 | - */ |
|
| 151 | - public function setVisible($pValue = true) { |
|
| 152 | - $this->_visible = $pValue; |
|
| 153 | - return $this; |
|
| 154 | - } |
|
| 155 | - |
|
| 156 | - /** |
|
| 157 | - * Get Outline Level |
|
| 158 | - * |
|
| 159 | - * @return int |
|
| 160 | - */ |
|
| 161 | - public function getOutlineLevel() { |
|
| 162 | - return $this->_outlineLevel; |
|
| 163 | - } |
|
| 164 | - |
|
| 165 | - /** |
|
| 166 | - * Set Outline Level |
|
| 167 | - * |
|
| 168 | - * Value must be between 0 and 7 |
|
| 169 | - * |
|
| 170 | - * @param int $pValue |
|
| 171 | - * @throws Exception |
|
| 172 | - * @return PHPExcel_Worksheet_RowDimension |
|
| 173 | - */ |
|
| 174 | - public function setOutlineLevel($pValue) { |
|
| 175 | - if ($pValue < 0 || $pValue > 7) { |
|
| 176 | - throw new Exception("Outline level must range between 0 and 7."); |
|
| 177 | - } |
|
| 178 | - |
|
| 179 | - $this->_outlineLevel = $pValue; |
|
| 180 | - return $this; |
|
| 181 | - } |
|
| 182 | - |
|
| 183 | - /** |
|
| 184 | - * Get Collapsed |
|
| 185 | - * |
|
| 186 | - * @return bool |
|
| 187 | - */ |
|
| 188 | - public function getCollapsed() { |
|
| 189 | - return $this->_collapsed; |
|
| 190 | - } |
|
| 191 | - |
|
| 192 | - /** |
|
| 193 | - * Set Collapsed |
|
| 194 | - * |
|
| 195 | - * @param bool $pValue |
|
| 196 | - * @return PHPExcel_Worksheet_RowDimension |
|
| 197 | - */ |
|
| 198 | - public function setCollapsed($pValue = true) { |
|
| 199 | - $this->_collapsed = $pValue; |
|
| 200 | - return $this; |
|
| 201 | - } |
|
| 94 | + } |
|
| 95 | + |
|
| 96 | + /** |
|
| 97 | + * Get Row Index |
|
| 98 | + * |
|
| 99 | + * @return int |
|
| 100 | + */ |
|
| 101 | + public function getRowIndex() { |
|
| 102 | + return $this->_rowIndex; |
|
| 103 | + } |
|
| 104 | + |
|
| 105 | + /** |
|
| 106 | + * Set Row Index |
|
| 107 | + * |
|
| 108 | + * @param int $pValue |
|
| 109 | + * @return PHPExcel_Worksheet_RowDimension |
|
| 110 | + */ |
|
| 111 | + public function setRowIndex($pValue) { |
|
| 112 | + $this->_rowIndex = $pValue; |
|
| 113 | + return $this; |
|
| 114 | + } |
|
| 115 | + |
|
| 116 | + /** |
|
| 117 | + * Get Row Height |
|
| 118 | + * |
|
| 119 | + * @return double |
|
| 120 | + */ |
|
| 121 | + public function getRowHeight() { |
|
| 122 | + return $this->_rowHeight; |
|
| 123 | + } |
|
| 124 | + |
|
| 125 | + /** |
|
| 126 | + * Set Row Height |
|
| 127 | + * |
|
| 128 | + * @param double $pValue |
|
| 129 | + * @return PHPExcel_Worksheet_RowDimension |
|
| 130 | + */ |
|
| 131 | + public function setRowHeight($pValue = -1) { |
|
| 132 | + $this->_rowHeight = $pValue; |
|
| 133 | + return $this; |
|
| 134 | + } |
|
| 135 | + |
|
| 136 | + /** |
|
| 137 | + * Get Visible |
|
| 138 | + * |
|
| 139 | + * @return bool |
|
| 140 | + */ |
|
| 141 | + public function getVisible() { |
|
| 142 | + return $this->_visible; |
|
| 143 | + } |
|
| 144 | + |
|
| 145 | + /** |
|
| 146 | + * Set Visible |
|
| 147 | + * |
|
| 148 | + * @param bool $pValue |
|
| 149 | + * @return PHPExcel_Worksheet_RowDimension |
|
| 150 | + */ |
|
| 151 | + public function setVisible($pValue = true) { |
|
| 152 | + $this->_visible = $pValue; |
|
| 153 | + return $this; |
|
| 154 | + } |
|
| 155 | + |
|
| 156 | + /** |
|
| 157 | + * Get Outline Level |
|
| 158 | + * |
|
| 159 | + * @return int |
|
| 160 | + */ |
|
| 161 | + public function getOutlineLevel() { |
|
| 162 | + return $this->_outlineLevel; |
|
| 163 | + } |
|
| 164 | + |
|
| 165 | + /** |
|
| 166 | + * Set Outline Level |
|
| 167 | + * |
|
| 168 | + * Value must be between 0 and 7 |
|
| 169 | + * |
|
| 170 | + * @param int $pValue |
|
| 171 | + * @throws Exception |
|
| 172 | + * @return PHPExcel_Worksheet_RowDimension |
|
| 173 | + */ |
|
| 174 | + public function setOutlineLevel($pValue) { |
|
| 175 | + if ($pValue < 0 || $pValue > 7) { |
|
| 176 | + throw new Exception("Outline level must range between 0 and 7."); |
|
| 177 | + } |
|
| 178 | + |
|
| 179 | + $this->_outlineLevel = $pValue; |
|
| 180 | + return $this; |
|
| 181 | + } |
|
| 182 | + |
|
| 183 | + /** |
|
| 184 | + * Get Collapsed |
|
| 185 | + * |
|
| 186 | + * @return bool |
|
| 187 | + */ |
|
| 188 | + public function getCollapsed() { |
|
| 189 | + return $this->_collapsed; |
|
| 190 | + } |
|
| 191 | + |
|
| 192 | + /** |
|
| 193 | + * Set Collapsed |
|
| 194 | + * |
|
| 195 | + * @param bool $pValue |
|
| 196 | + * @return PHPExcel_Worksheet_RowDimension |
|
| 197 | + */ |
|
| 198 | + public function setCollapsed($pValue = true) { |
|
| 199 | + $this->_collapsed = $pValue; |
|
| 200 | + return $this; |
|
| 201 | + } |
|
| 202 | 202 | |
| 203 | 203 | /** |
| 204 | 204 | * Get index to cellXf |