@@ -41,7 +41,7 @@ |
||
41 | 41 | $this->sheetData->fwrite('<?xml version="1.0" encoding="UTF-8" standalone="yes"?><worksheet xml:space="preserve" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">'); |
42 | 42 | |
43 | 43 | if (1 == preg_match('~[A-Z]+([1-9]?[0-9]+)$~', $freezePaneCellId, $match)) { |
44 | - $this->sheetData->fwrite('<sheetViews><sheetView tabSelected="1" workbookViewId="0" showGridLines="true" showRowColHeaders="1"><pane ySplit="' . (array_pop($match) - 1) . '" topLeftCell="' . $freezePaneCellId . '" activePane="bottomLeft" state="frozen"/></sheetView></sheetViews>'); |
|
44 | + $this->sheetData->fwrite('<sheetViews><sheetView tabSelected="1" workbookViewId="0" showGridLines="true" showRowColHeaders="1"><pane ySplit="' . (array_pop($match)-1) . '" topLeftCell="' . $freezePaneCellId . '" activePane="bottomLeft" state="frozen"/></sheetView></sheetViews>'); |
|
45 | 45 | } |
46 | 46 | |
47 | 47 | $this->sheetData->fwrite('<sheetData>'); |
@@ -51,7 +51,7 @@ |
||
51 | 51 | public function __construct(Sheet $sheet, $fileName = 'dummy.xlsx') |
52 | 52 | { |
53 | 53 | $this->zip = new \ZipArchive(); |
54 | - $this->zip->open($fileName, \ZipArchive::CREATE|\ZipArchive::CM_STORE); |
|
54 | + $this->zip->open($fileName, \ZipArchive::CREATE | \ZipArchive::CM_STORE); |
|
55 | 55 | $this->sheet = $sheet; |
56 | 56 | } |
57 | 57 |
@@ -46,7 +46,7 @@ discard block |
||
46 | 46 | { |
47 | 47 | $this->characters = range('A', 'Z'); |
48 | 48 | |
49 | - foreach(range(chr(0), chr(31)) as $key => $char) { |
|
49 | + foreach (range(chr(0), chr(31)) as $key => $char) { |
|
50 | 50 | if (!in_array($char, array("\n", "\r", "\t"))) { |
51 | 51 | $this->controlCharacters[] = $char; |
52 | 52 | $this->escapeCharacters[] = sprintf('_x%04s_', strtoupper(dechex($key))); |
@@ -92,7 +92,7 @@ discard block |
||
92 | 92 | return $this->characters[$cellNumber] . $rowNumber; |
93 | 93 | } |
94 | 94 | |
95 | - return $this->getCellId(floor($cellNumber / 26) - 1) . $this->characters[$cellNumber % 26] . $rowNumber; |
|
95 | + return $this->getCellId(floor($cellNumber / 26)-1) . $this->characters[$cellNumber % 26] . $rowNumber; |
|
96 | 96 | } |
97 | 97 | |
98 | 98 | /** |