@@ -1,10 +1,10 @@ |
||
1 | 1 | <?php |
2 | -spl_autoload_register(function ($class_name) { |
|
2 | +spl_autoload_register(function($class_name) { |
|
3 | 3 | $preg_match = preg_match('/^Psr\\\SimpleCache/', $class_name); |
4 | 4 | |
5 | 5 | if (1 === $preg_match) { |
6 | 6 | $class_name = preg_replace('/\\\/', '/', $class_name); |
7 | 7 | $class_name = preg_replace('/^Psr\\/SimpleCache\\//', '', $class_name); |
8 | - require_once(__DIR__ . '/simple-cache/src/' . $class_name . '.php'); |
|
8 | + require_once(__DIR__.'/simple-cache/src/'.$class_name.'.php'); |
|
9 | 9 | } |
10 | 10 | }); |
11 | 11 | \ No newline at end of file |
@@ -179,6 +179,6 @@ |
||
179 | 179 | { |
180 | 180 | $binary = str_pad(decbin($decimal), 32, '0', STR_PAD_LEFT); |
181 | 181 | |
182 | - return bindec(substr($binary, $bits) . substr($binary, 0, $bits)); |
|
182 | + return bindec(substr($binary, $bits).substr($binary, 0, $bits)); |
|
183 | 183 | } |
184 | 184 | } |
@@ -600,7 +600,7 @@ discard block |
||
600 | 600 | $endOffsetY = Xls::getUInt2d($recordData, 16); |
601 | 601 | |
602 | 602 | // set the start coordinates |
603 | - $this->object->setStartCoordinates(Coordinate::stringFromColumnIndex($c1 + 1) . ($r1 + 1)); |
|
603 | + $this->object->setStartCoordinates(Coordinate::stringFromColumnIndex($c1 + 1).($r1 + 1)); |
|
604 | 604 | |
605 | 605 | // set the start offsetX |
606 | 606 | $this->object->setStartOffsetX($startOffsetX); |
@@ -609,7 +609,7 @@ discard block |
||
609 | 609 | $this->object->setStartOffsetY($startOffsetY); |
610 | 610 | |
611 | 611 | // set the end coordinates |
612 | - $this->object->setEndCoordinates(Coordinate::stringFromColumnIndex($c2 + 1) . ($r2 + 1)); |
|
612 | + $this->object->setEndCoordinates(Coordinate::stringFromColumnIndex($c2 + 1).($r2 + 1)); |
|
613 | 613 | |
614 | 614 | // set the end offsetX |
615 | 615 | $this->object->setEndOffsetX($endOffsetX); |
@@ -116,7 +116,7 @@ discard block |
||
116 | 116 | Settings::getLibXmlLoaderOptions() |
117 | 117 | ); |
118 | 118 | } catch (\Exception $e) { |
119 | - throw new Exception('Cannot load invalid XML file: ' . $pFilename, 0, $e); |
|
119 | + throw new Exception('Cannot load invalid XML file: '.$pFilename, 0, $e); |
|
120 | 120 | } |
121 | 121 | |
122 | 122 | return $xml; |
@@ -135,7 +135,7 @@ discard block |
||
135 | 135 | { |
136 | 136 | File::assertFile($pFilename); |
137 | 137 | if (!$this->canRead($pFilename)) { |
138 | - throw new Exception($pFilename . ' is an Invalid Spreadsheet file.'); |
|
138 | + throw new Exception($pFilename.' is an Invalid Spreadsheet file.'); |
|
139 | 139 | } |
140 | 140 | |
141 | 141 | $worksheetNames = []; |
@@ -308,7 +308,7 @@ discard block |
||
308 | 308 | { |
309 | 309 | File::assertFile($pFilename); |
310 | 310 | if (!$this->canRead($pFilename)) { |
311 | - throw new Exception($pFilename . ' is an Invalid Spreadsheet file.'); |
|
311 | + throw new Exception($pFilename.' is an Invalid Spreadsheet file.'); |
|
312 | 312 | } |
313 | 313 | |
314 | 314 | $xml = $this->trySimpleXMLLoadString($pFilename); |
@@ -459,7 +459,7 @@ discard block |
||
459 | 459 | if (isset($cell_ss['Index'])) { |
460 | 460 | $columnID = Coordinate::stringFromColumnIndex((int) $cell_ss['Index']); |
461 | 461 | } |
462 | - $cellRange = $columnID . $rowID; |
|
462 | + $cellRange = $columnID.$rowID; |
|
463 | 463 | |
464 | 464 | if ($this->getReadFilter() !== null) { |
465 | 465 | if (!$this->getReadFilter()->readCell($columnID, $rowID, $worksheetName)) { |
@@ -483,7 +483,7 @@ discard block |
||
483 | 483 | if (isset($cell_ss['MergeDown'])) { |
484 | 484 | $rowTo = $rowTo + $cell_ss['MergeDown']; |
485 | 485 | } |
486 | - $cellRange .= ':' . $columnTo . $rowTo; |
|
486 | + $cellRange .= ':'.$columnTo.$rowTo; |
|
487 | 487 | $spreadsheet->getActiveSheet()->mergeCells($cellRange); |
488 | 488 | } |
489 | 489 | |
@@ -585,7 +585,7 @@ discard block |
||
585 | 585 | if ($columnReference[0] == '[') { |
586 | 586 | $columnReference = $columnNumber + trim($columnReference, '[]'); |
587 | 587 | } |
588 | - $A1CellReference = Coordinate::stringFromColumnIndex($columnReference) . $rowReference; |
|
588 | + $A1CellReference = Coordinate::stringFromColumnIndex($columnReference).$rowReference; |
|
589 | 589 | $value = substr_replace($value, $A1CellReference, $cellReference[0][1], strlen($cellReference[0][0])); |
590 | 590 | } |
591 | 591 | } |
@@ -596,9 +596,9 @@ discard block |
||
596 | 596 | $cellDataFormula = implode('"', $temp); |
597 | 597 | } |
598 | 598 | |
599 | - $spreadsheet->getActiveSheet()->getCell($columnID . $rowID)->setValueExplicit((($hasCalculatedValue) ? $cellDataFormula : $cellValue), $type); |
|
599 | + $spreadsheet->getActiveSheet()->getCell($columnID.$rowID)->setValueExplicit((($hasCalculatedValue) ? $cellDataFormula : $cellValue), $type); |
|
600 | 600 | if ($hasCalculatedValue) { |
601 | - $spreadsheet->getActiveSheet()->getCell($columnID . $rowID)->setCalculatedValue($cellValue); |
|
601 | + $spreadsheet->getActiveSheet()->getCell($columnID.$rowID)->setCalculatedValue($cellValue); |
|
602 | 602 | } |
603 | 603 | $cellIsSet = $rowHasData = true; |
604 | 604 | } |
@@ -611,14 +611,14 @@ discard block |
||
611 | 611 | } |
612 | 612 | $node = $cell->Comment->Data->asXML(); |
613 | 613 | $annotation = strip_tags($node); |
614 | - $spreadsheet->getActiveSheet()->getComment($columnID . $rowID)->setAuthor(self::convertStringEncoding($author, $this->charSet))->setText($this->parseRichText($annotation)); |
|
614 | + $spreadsheet->getActiveSheet()->getComment($columnID.$rowID)->setAuthor(self::convertStringEncoding($author, $this->charSet))->setText($this->parseRichText($annotation)); |
|
615 | 615 | } |
616 | 616 | |
617 | 617 | if (($cellIsSet) && (isset($cell_ss['StyleID']))) { |
618 | 618 | $style = (string) $cell_ss['StyleID']; |
619 | 619 | if ((isset($this->styles[$style])) && (!empty($this->styles[$style]))) { |
620 | - if (!$spreadsheet->getActiveSheet()->cellExists($columnID . $rowID)) { |
|
621 | - $spreadsheet->getActiveSheet()->getCell($columnID . $rowID)->setValue(null); |
|
620 | + if (!$spreadsheet->getActiveSheet()->cellExists($columnID.$rowID)) { |
|
621 | + $spreadsheet->getActiveSheet()->getCell($columnID.$rowID)->setValue(null); |
|
622 | 622 | } |
623 | 623 | $spreadsheet->getActiveSheet()->getStyle($cellRange)->applyFromArray($this->styles[$style]); |
624 | 624 | } |
@@ -121,7 +121,7 @@ |
||
121 | 121 | } |
122 | 122 | |
123 | 123 | $this->worksheet->freezePane( |
124 | - Coordinate::stringFromColumnIndex($xSplit + 1) . ($ySplit + 1), |
|
124 | + Coordinate::stringFromColumnIndex($xSplit + 1).($ySplit + 1), |
|
125 | 125 | $topLeftCell |
126 | 126 | ); |
127 | 127 | } |
@@ -141,7 +141,7 @@ |
||
141 | 141 | foreach ($xmlSheet->colBreaks->brk as $brk) { |
142 | 142 | if ($brk['man']) { |
143 | 143 | $worksheet->setBreak( |
144 | - Coordinate::stringFromColumnIndex(((int) $brk['id']) + 1) . '1', |
|
144 | + Coordinate::stringFromColumnIndex(((int) $brk['id']) + 1).'1', |
|
145 | 145 | Worksheet::BREAK_COLUMN |
146 | 146 | ); |
147 | 147 | } |
@@ -42,11 +42,11 @@ |
||
42 | 42 | if (isset($linkRel['id'])) { |
43 | 43 | $hyperlinkUrl = $this->hyperlinks[(string) $linkRel['id']]; |
44 | 44 | if (isset($hyperlink['location'])) { |
45 | - $hyperlinkUrl .= '#' . (string) $hyperlink['location']; |
|
45 | + $hyperlinkUrl .= '#'.(string) $hyperlink['location']; |
|
46 | 46 | } |
47 | 47 | $cell->getHyperlink()->setUrl($hyperlinkUrl); |
48 | 48 | } elseif (isset($hyperlink['location'])) { |
49 | - $cell->getHyperlink()->setUrl('sheet://' . (string) $hyperlink['location']); |
|
49 | + $cell->getHyperlink()->setUrl('sheet://'.(string) $hyperlink['location']); |
|
50 | 50 | } |
51 | 51 | |
52 | 52 | // Tooltip |
@@ -231,7 +231,7 @@ |
||
231 | 231 | $returnColour = Color::changeBrightness($returnColour, $tintAdjust); |
232 | 232 | } |
233 | 233 | |
234 | - return 'FF' . $returnColour; |
|
234 | + return 'FF'.$returnColour; |
|
235 | 235 | } |
236 | 236 | } |
237 | 237 |
@@ -154,7 +154,7 @@ |
||
154 | 154 | // Open file |
155 | 155 | $this->fileHandle = fopen($pFilename, 'r'); |
156 | 156 | if ($this->fileHandle === false) { |
157 | - throw new Exception('Could not open file ' . $pFilename . ' for reading.'); |
|
157 | + throw new Exception('Could not open file '.$pFilename.' for reading.'); |
|
158 | 158 | } |
159 | 159 | } |
160 | 160 | } |