@@ -250,8 +250,8 @@ |
||
250 | 250 | */ |
251 | 251 | public function setStyle(\PHPExcel\Style $pValue = null) |
252 | 252 | { |
253 | - $this->style = $pValue; |
|
254 | - return $this; |
|
253 | + $this->style = $pValue; |
|
254 | + return $this; |
|
255 | 255 | } |
256 | 256 | |
257 | 257 | /** |
@@ -450,7 +450,7 @@ |
||
450 | 450 | if ($cell->getDataType() == Cell\DataType::TYPE_FORMULA) { |
451 | 451 | // Formula should be adjusted |
452 | 452 | $pSheet->getCell($newCoordinates) |
453 | - ->setValue($this->updateFormulaReferences($cell->getValue(), $pBefore, $pNumCols, $pNumRows, $pSheet->getTitle())); |
|
453 | + ->setValue($this->updateFormulaReferences($cell->getValue(), $pBefore, $pNumCols, $pNumRows, $pSheet->getTitle())); |
|
454 | 454 | } else { |
455 | 455 | // Formula should not be adjusted |
456 | 456 | $pSheet->getCell($newCoordinates)->setValue($cell->getValue()); |
@@ -215,17 +215,17 @@ discard block |
||
215 | 215 | private $showGridlines = true; |
216 | 216 | |
217 | 217 | /** |
218 | - * Print gridlines? |
|
219 | - * |
|
220 | - * @var boolean |
|
221 | - */ |
|
218 | + * Print gridlines? |
|
219 | + * |
|
220 | + * @var boolean |
|
221 | + */ |
|
222 | 222 | private $printGridlines = false; |
223 | 223 | |
224 | 224 | /** |
225 | - * Show row and column headers? |
|
226 | - * |
|
227 | - * @var boolean |
|
228 | - */ |
|
225 | + * Show row and column headers? |
|
226 | + * |
|
227 | + * @var boolean |
|
228 | + */ |
|
229 | 229 | private $showRowColHeaders = true; |
230 | 230 | |
231 | 231 | /** |
@@ -320,10 +320,10 @@ discard block |
||
320 | 320 | private $hash; |
321 | 321 | |
322 | 322 | /** |
323 | - * CodeName |
|
324 | - * |
|
325 | - * @var string |
|
326 | - */ |
|
323 | + * CodeName |
|
324 | + * |
|
325 | + * @var string |
|
326 | + */ |
|
327 | 327 | private $codeName = null; |
328 | 328 | |
329 | 329 | /** |
@@ -390,7 +390,7 @@ discard block |
||
390 | 390 | $this->disconnectCells(); |
391 | 391 | } |
392 | 392 | |
393 | - /** |
|
393 | + /** |
|
394 | 394 | * Return the cache controller for the cell collection |
395 | 395 | * |
396 | 396 | * @return CachedObjectStorage_xxx |
@@ -439,7 +439,7 @@ discard block |
||
439 | 439 | return $pValue; |
440 | 440 | } |
441 | 441 | |
442 | - /** |
|
442 | + /** |
|
443 | 443 | * Check sheet title for valid Excel syntax |
444 | 444 | * |
445 | 445 | * @param string $pValue The string to check |
@@ -1248,7 +1248,7 @@ discard block |
||
1248 | 1248 | */ |
1249 | 1249 | public function cellExists($pCoordinate = 'A1') |
1250 | 1250 | { |
1251 | - // Worksheet reference? |
|
1251 | + // Worksheet reference? |
|
1252 | 1252 | if (strpos($pCoordinate, '!') !== false) { |
1253 | 1253 | $worksheetReference = Worksheet::extractSheetTitle($pCoordinate, true); |
1254 | 1254 | return $this->parent->getSheetByName($worksheetReference[0])->cellExists(strtoupper($worksheetReference[1])); |
@@ -2140,21 +2140,21 @@ discard block |
||
2140 | 2140 | } |
2141 | 2141 | |
2142 | 2142 | /** |
2143 | - * Print gridlines? |
|
2144 | - * |
|
2145 | - * @return boolean |
|
2146 | - */ |
|
2143 | + * Print gridlines? |
|
2144 | + * |
|
2145 | + * @return boolean |
|
2146 | + */ |
|
2147 | 2147 | public function getPrintGridlines() |
2148 | 2148 | { |
2149 | 2149 | return $this->printGridlines; |
2150 | 2150 | } |
2151 | 2151 | |
2152 | 2152 | /** |
2153 | - * Set print gridlines |
|
2154 | - * |
|
2155 | - * @param boolean $pValue Print gridlines (true/false) |
|
2156 | - * @return Worksheet |
|
2157 | - */ |
|
2153 | + * Set print gridlines |
|
2154 | + * |
|
2155 | + * @param boolean $pValue Print gridlines (true/false) |
|
2156 | + * @return Worksheet |
|
2157 | + */ |
|
2158 | 2158 | public function setPrintGridlines($pValue = false) |
2159 | 2159 | { |
2160 | 2160 | $this->printGridlines = $pValue; |
@@ -2162,21 +2162,21 @@ discard block |
||
2162 | 2162 | } |
2163 | 2163 | |
2164 | 2164 | /** |
2165 | - * Show row and column headers? |
|
2166 | - * |
|
2167 | - * @return boolean |
|
2168 | - */ |
|
2165 | + * Show row and column headers? |
|
2166 | + * |
|
2167 | + * @return boolean |
|
2168 | + */ |
|
2169 | 2169 | public function getShowRowColHeaders() |
2170 | 2170 | { |
2171 | 2171 | return $this->showRowColHeaders; |
2172 | 2172 | } |
2173 | 2173 | |
2174 | 2174 | /** |
2175 | - * Set show row and column headers |
|
2176 | - * |
|
2177 | - * @param boolean $pValue Show row and column headers (true/false) |
|
2178 | - * @return Worksheet |
|
2179 | - */ |
|
2175 | + * Set show row and column headers |
|
2176 | + * |
|
2177 | + * @param boolean $pValue Show row and column headers (true/false) |
|
2178 | + * @return Worksheet |
|
2179 | + */ |
|
2180 | 2180 | public function setShowRowColHeaders($pValue = false) |
2181 | 2181 | { |
2182 | 2182 | $this->showRowColHeaders = $pValue; |
@@ -2905,7 +2905,7 @@ discard block |
||
2905 | 2905 | * @param null|string Same rule as Title minus space not allowed (but, like Excel, change silently space to underscore) |
2906 | 2906 | * @return objWorksheet |
2907 | 2907 | * @throws Exception |
2908 | - */ |
|
2908 | + */ |
|
2909 | 2909 | public function setCodeName($pValue = null) |
2910 | 2910 | { |
2911 | 2911 | // Is this a 'rename' or not? |
@@ -2954,7 +2954,7 @@ discard block |
||
2954 | 2954 | * Return the code name of the sheet |
2955 | 2955 | * |
2956 | 2956 | * @return null|string |
2957 | - */ |
|
2957 | + */ |
|
2958 | 2958 | public function getCodeName() |
2959 | 2959 | { |
2960 | 2960 | return $this->codeName; |
@@ -2962,7 +2962,7 @@ discard block |
||
2962 | 2962 | /** |
2963 | 2963 | * Sheet has a code name ? |
2964 | 2964 | * @return boolean |
2965 | - */ |
|
2965 | + */ |
|
2966 | 2966 | public function hasCodeName() |
2967 | 2967 | { |
2968 | 2968 | return !(is_null($this->codeName)); |
@@ -63,7 +63,7 @@ |
||
63 | 63 | 0x3F => '333333', |
64 | 64 | ); |
65 | 65 | |
66 | - /** |
|
66 | + /** |
|
67 | 67 | * Map color array from BIFF8 built-in color index |
68 | 68 | * |
69 | 69 | * @param int $color |
@@ -262,8 +262,8 @@ |
||
262 | 262 | $sheet = $objPHPExcel->setActiveSheetIndex($this->sheetIndex); |
263 | 263 | |
264 | 264 | $escapeEnclosures = array( "\\" . $this->enclosure, |
265 | - $this->enclosure . $this->enclosure |
|
266 | - ); |
|
265 | + $this->enclosure . $this->enclosure |
|
266 | + ); |
|
267 | 267 | |
268 | 268 | // Set our starting row based on whether we're in contiguous mode or not |
269 | 269 | $currentRow = 1; |
@@ -114,9 +114,9 @@ |
||
114 | 114 | private $topBorderColor; |
115 | 115 | |
116 | 116 | /** |
117 | - * Color of the left border of the cell. |
|
118 | - * @var integer |
|
119 | - */ |
|
117 | + * Color of the left border of the cell. |
|
118 | + * @var integer |
|
119 | + */ |
|
120 | 120 | private $leftBorderColor; |
121 | 121 | |
122 | 122 | /** |
@@ -674,7 +674,7 @@ |
||
674 | 674 | list($row1, $col1) = $this->cellToPackedRowcol($cell1); |
675 | 675 | list($row2, $col2) = $this->cellToPackedRowcol($cell2); |
676 | 676 | } else { // It's a rows range (like 26:27) |
677 | - list($row1, $col1, $row2, $col2) = $this->rangeToPackedRange($cell1.':'.$cell2); |
|
677 | + list($row1, $col1, $row2, $col2) = $this->rangeToPackedRange($cell1.':'.$cell2); |
|
678 | 678 | } |
679 | 679 | |
680 | 680 | // The ptg value depends on the class of the ptg. |
@@ -1019,8 +1019,8 @@ discard block |
||
1019 | 1019 | |
1020 | 1020 | // Write the packed data |
1021 | 1021 | $this->append($header . $data . |
1022 | - $unknown1 . $options . |
|
1023 | - $unknown2 . $url_len . $url); |
|
1022 | + $unknown1 . $options . |
|
1023 | + $unknown2 . $url_len . $url); |
|
1024 | 1024 | return 0; |
1025 | 1025 | } |
1026 | 1026 | |
@@ -1068,8 +1068,8 @@ discard block |
||
1068 | 1068 | |
1069 | 1069 | // Write the packed data |
1070 | 1070 | $this->append($header . $data . |
1071 | - $unknown1 . $options . |
|
1072 | - $url_len . $url); |
|
1071 | + $unknown1 . $options . |
|
1072 | + $url_len . $url); |
|
1073 | 1073 | return 0; |
1074 | 1074 | } |
1075 | 1075 | |
@@ -1151,14 +1151,14 @@ discard block |
||
1151 | 1151 | |
1152 | 1152 | // Pack the main data stream |
1153 | 1153 | $data = pack("vvvv", $row1, $row2, $col1, $col2) . |
1154 | - $unknown1 . |
|
1155 | - $link_type . |
|
1156 | - $unknown2 . |
|
1157 | - $up_count . |
|
1158 | - $dir_short_len. |
|
1159 | - $dir_short . |
|
1160 | - $unknown3 . |
|
1161 | - $stream_len ;/*. |
|
1154 | + $unknown1 . |
|
1155 | + $link_type . |
|
1156 | + $unknown2 . |
|
1157 | + $up_count . |
|
1158 | + $dir_short_len. |
|
1159 | + $dir_short . |
|
1160 | + $unknown3 . |
|
1161 | + $stream_len ;/*. |
|
1162 | 1162 | $dir_long_len . |
1163 | 1163 | $unknown4 . |
1164 | 1164 | $dir_long . |
@@ -139,8 +139,8 @@ |
||
139 | 139 | } |
140 | 140 | |
141 | 141 | $hashTablesArray = array( 'stylesConditionalHashTable', 'fillHashTable', 'fontHashTable', |
142 | - 'bordersHashTable', 'numFmtHashTable', 'drawingHashTable', |
|
143 | - 'styleHashTable' |
|
142 | + 'bordersHashTable', 'numFmtHashTable', 'drawingHashTable', |
|
143 | + 'styleHashTable' |
|
144 | 144 | ); |
145 | 145 | |
146 | 146 | // Set HashTable variables |