@@ -168,7 +168,7 @@ |
||
168 | 168 | 'http://schemas.microsoft.com/office/2006/relationships/vbaProject', |
169 | 169 | 'vbaProject.bin' |
170 | 170 | ); |
171 | - ++$i;//increment i if needed for an another relation |
|
171 | + ++$i; //increment i if needed for an another relation |
|
172 | 172 | } |
173 | 173 | |
174 | 174 | $objWriter->endElement(); |
@@ -49,11 +49,11 @@ discard block |
||
49 | 49 | $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
50 | 50 | |
51 | 51 | // Comments cache |
52 | - $comments = $pWorksheet->getComments(); |
|
52 | + $comments = $pWorksheet->getComments(); |
|
53 | 53 | |
54 | 54 | // Authors cache |
55 | - $authors = array(); |
|
56 | - $authorId = 0; |
|
55 | + $authors = array(); |
|
56 | + $authorId = 0; |
|
57 | 57 | foreach ($comments as $comment) { |
58 | 58 | if (!isset($authors[$comment->getAuthor()])) { |
59 | 59 | $authors[$comment->getAuthor()] = $authorId++; |
@@ -129,7 +129,7 @@ discard block |
||
129 | 129 | $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
130 | 130 | |
131 | 131 | // Comments cache |
132 | - $comments = $pWorksheet->getComments(); |
|
132 | + $comments = $pWorksheet->getComments(); |
|
133 | 133 | |
134 | 134 | // xml |
135 | 135 | $objWriter->startElement('xml'); |
@@ -229,7 +229,7 @@ |
||
229 | 229 | |
230 | 230 | $objWriter->startElement('property'); |
231 | 231 | $objWriter->writeAttribute('fmtid', '{D5CDD505-2E9C-101B-9397-08002B2CF9AE}'); |
232 | - $objWriter->writeAttribute('pid', $key+2); |
|
232 | + $objWriter->writeAttribute('pid', $key + 2); |
|
233 | 233 | $objWriter->writeAttribute('name', $customProperty); |
234 | 234 | |
235 | 235 | switch ($propertyType) { |
@@ -389,19 +389,19 @@ discard block |
||
389 | 389 | // xf |
390 | 390 | $objWriter->startElement('xf'); |
391 | 391 | $objWriter->writeAttribute('xfId', 0); |
392 | - $objWriter->writeAttribute('fontId', (int)$this->getParentWriter()->getFontHashTable()->getIndexForHashCode($pStyle->getFont()->getHashCode())); |
|
392 | + $objWriter->writeAttribute('fontId', (int) $this->getParentWriter()->getFontHashTable()->getIndexForHashCode($pStyle->getFont()->getHashCode())); |
|
393 | 393 | if ($pStyle->getQuotePrefix()) { |
394 | 394 | $objWriter->writeAttribute('quotePrefix', 1); |
395 | 395 | } |
396 | 396 | |
397 | 397 | if ($pStyle->getNumberFormat()->getBuiltInFormatCode() === false) { |
398 | - $objWriter->writeAttribute('numFmtId', (int)($this->getParentWriter()->getNumFmtHashTable()->getIndexForHashCode($pStyle->getNumberFormat()->getHashCode()) + 164)); |
|
398 | + $objWriter->writeAttribute('numFmtId', (int) ($this->getParentWriter()->getNumFmtHashTable()->getIndexForHashCode($pStyle->getNumberFormat()->getHashCode()) + 164)); |
|
399 | 399 | } else { |
400 | - $objWriter->writeAttribute('numFmtId', (int)$pStyle->getNumberFormat()->getBuiltInFormatCode()); |
|
400 | + $objWriter->writeAttribute('numFmtId', (int) $pStyle->getNumberFormat()->getBuiltInFormatCode()); |
|
401 | 401 | } |
402 | 402 | |
403 | - $objWriter->writeAttribute('fillId', (int)$this->getParentWriter()->getFillHashTable()->getIndexForHashCode($pStyle->getFill()->getHashCode())); |
|
404 | - $objWriter->writeAttribute('borderId', (int)$this->getParentWriter()->getBordersHashTable()->getIndexForHashCode($pStyle->getBorders()->getHashCode())); |
|
403 | + $objWriter->writeAttribute('fillId', (int) $this->getParentWriter()->getFillHashTable()->getIndexForHashCode($pStyle->getFill()->getHashCode())); |
|
404 | + $objWriter->writeAttribute('borderId', (int) $this->getParentWriter()->getBordersHashTable()->getIndexForHashCode($pStyle->getBorders()->getHashCode())); |
|
405 | 405 | |
406 | 406 | // Apply styles? |
407 | 407 | $objWriter->writeAttribute('applyFont', ($pPHPExcel->getDefaultStyle()->getFont()->getHashCode() != $pStyle->getFont()->getHashCode()) ? '1' : '0'); |
@@ -623,7 +623,7 @@ discard block |
||
623 | 623 | /** @var \PHPExcel\Style $style */ |
624 | 624 | foreach ($aStyles as $style) { |
625 | 625 | if (!array_key_exists($style->getFill()->getHashCode(), $aFills)) { |
626 | - $aFills[ $style->getFill()->getHashCode() ] = $style->getFill(); |
|
626 | + $aFills[$style->getFill()->getHashCode()] = $style->getFill(); |
|
627 | 627 | } |
628 | 628 | } |
629 | 629 | |
@@ -646,7 +646,7 @@ discard block |
||
646 | 646 | /** @var \PHPExcel\Style $style */ |
647 | 647 | foreach ($aStyles as $style) { |
648 | 648 | if (!array_key_exists($style->getFont()->getHashCode(), $aFonts)) { |
649 | - $aFonts[ $style->getFont()->getHashCode() ] = $style->getFont(); |
|
649 | + $aFonts[$style->getFont()->getHashCode()] = $style->getFont(); |
|
650 | 650 | } |
651 | 651 | } |
652 | 652 | |
@@ -669,7 +669,7 @@ discard block |
||
669 | 669 | /** @var \PHPExcel\Style $style */ |
670 | 670 | foreach ($aStyles as $style) { |
671 | 671 | if (!array_key_exists($style->getBorders()->getHashCode(), $aBorders)) { |
672 | - $aBorders[ $style->getBorders()->getHashCode() ] = $style->getBorders(); |
|
672 | + $aBorders[$style->getBorders()->getHashCode()] = $style->getBorders(); |
|
673 | 673 | } |
674 | 674 | } |
675 | 675 | |
@@ -692,7 +692,7 @@ discard block |
||
692 | 692 | /** @var \PHPExcel\Style $style */ |
693 | 693 | foreach ($aStyles as $style) { |
694 | 694 | if ($style->getNumberFormat()->getBuiltInFormatCode() === false && !array_key_exists($style->getNumberFormat()->getHashCode(), $aNumFmts)) { |
695 | - $aNumFmts[ $style->getNumberFormat()->getHashCode() ] = $style->getNumberFormat(); |
|
695 | + $aNumFmts[$style->getNumberFormat()->getHashCode()] = $style->getNumberFormat(); |
|
696 | 696 | } |
697 | 697 | } |
698 | 698 |
@@ -860,7 +860,7 @@ |
||
860 | 860 | private function writeColourScheme($objWriter) |
861 | 861 | { |
862 | 862 | foreach (self::$colourScheme as $colourName => $colourValue) { |
863 | - $objWriter->startElement('a:'.$colourName); |
|
863 | + $objWriter->startElement('a:' . $colourName); |
|
864 | 864 | |
865 | 865 | $objWriter->startElement('a:srgbClr'); |
866 | 866 | $objWriter->writeAttribute('val', $colourValue); |
@@ -72,135 +72,135 @@ |
||
72 | 72 | */ |
73 | 73 | protected static $paperSizes = array( |
74 | 74 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_LETTER |
75 | - => 'LETTER', // (8.5 in. by 11 in.) |
|
75 | + => 'LETTER', // (8.5 in. by 11 in.) |
|
76 | 76 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_LETTER_SMALL |
77 | - => 'LETTER', // (8.5 in. by 11 in.) |
|
77 | + => 'LETTER', // (8.5 in. by 11 in.) |
|
78 | 78 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_TABLOID |
79 | - => array(792.00, 1224.00), // (11 in. by 17 in.) |
|
79 | + => array(792.00, 1224.00), // (11 in. by 17 in.) |
|
80 | 80 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_LEDGER |
81 | - => array(1224.00, 792.00), // (17 in. by 11 in.) |
|
81 | + => array(1224.00, 792.00), // (17 in. by 11 in.) |
|
82 | 82 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_LEGAL |
83 | - => 'LEGAL', // (8.5 in. by 14 in.) |
|
83 | + => 'LEGAL', // (8.5 in. by 14 in.) |
|
84 | 84 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_STATEMENT |
85 | - => array(396.00, 612.00), // (5.5 in. by 8.5 in.) |
|
85 | + => array(396.00, 612.00), // (5.5 in. by 8.5 in.) |
|
86 | 86 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_EXECUTIVE |
87 | - => 'EXECUTIVE', // (7.25 in. by 10.5 in.) |
|
87 | + => 'EXECUTIVE', // (7.25 in. by 10.5 in.) |
|
88 | 88 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A3 |
89 | - => 'A3', // (297 mm by 420 mm) |
|
89 | + => 'A3', // (297 mm by 420 mm) |
|
90 | 90 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A4 |
91 | - => 'A4', // (210 mm by 297 mm) |
|
91 | + => 'A4', // (210 mm by 297 mm) |
|
92 | 92 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A4_SMALL |
93 | - => 'A4', // (210 mm by 297 mm) |
|
93 | + => 'A4', // (210 mm by 297 mm) |
|
94 | 94 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A5 |
95 | - => 'A5', // (148 mm by 210 mm) |
|
95 | + => 'A5', // (148 mm by 210 mm) |
|
96 | 96 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_B4 |
97 | - => 'B4', // (250 mm by 353 mm) |
|
97 | + => 'B4', // (250 mm by 353 mm) |
|
98 | 98 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_B5 |
99 | - => 'B5', // (176 mm by 250 mm) |
|
99 | + => 'B5', // (176 mm by 250 mm) |
|
100 | 100 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_FOLIO |
101 | - => 'FOLIO', // (8.5 in. by 13 in.) |
|
101 | + => 'FOLIO', // (8.5 in. by 13 in.) |
|
102 | 102 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_QUARTO |
103 | - => array(609.45, 779.53), // (215 mm by 275 mm) |
|
103 | + => array(609.45, 779.53), // (215 mm by 275 mm) |
|
104 | 104 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_STANDARD_1 |
105 | - => array(720.00, 1008.00), // (10 in. by 14 in.) |
|
105 | + => array(720.00, 1008.00), // (10 in. by 14 in.) |
|
106 | 106 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_STANDARD_2 |
107 | - => array(792.00, 1224.00), // (11 in. by 17 in.) |
|
107 | + => array(792.00, 1224.00), // (11 in. by 17 in.) |
|
108 | 108 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_NOTE |
109 | - => 'LETTER', // (8.5 in. by 11 in.) |
|
109 | + => 'LETTER', // (8.5 in. by 11 in.) |
|
110 | 110 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_NO9_ENVELOPE |
111 | - => array(279.00, 639.00), // (3.875 in. by 8.875 in.) |
|
111 | + => array(279.00, 639.00), // (3.875 in. by 8.875 in.) |
|
112 | 112 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_NO10_ENVELOPE |
113 | - => array(297.00, 684.00), // (4.125 in. by 9.5 in.) |
|
113 | + => array(297.00, 684.00), // (4.125 in. by 9.5 in.) |
|
114 | 114 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_NO11_ENVELOPE |
115 | - => array(324.00, 747.00), // (4.5 in. by 10.375 in.) |
|
115 | + => array(324.00, 747.00), // (4.5 in. by 10.375 in.) |
|
116 | 116 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_NO12_ENVELOPE |
117 | - => array(342.00, 792.00), // (4.75 in. by 11 in.) |
|
117 | + => array(342.00, 792.00), // (4.75 in. by 11 in.) |
|
118 | 118 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_NO14_ENVELOPE |
119 | - => array(360.00, 828.00), // (5 in. by 11.5 in.) |
|
119 | + => array(360.00, 828.00), // (5 in. by 11.5 in.) |
|
120 | 120 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_C |
121 | - => array(1224.00, 1584.00), // (17 in. by 22 in.) |
|
121 | + => array(1224.00, 1584.00), // (17 in. by 22 in.) |
|
122 | 122 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_D |
123 | - => array(1584.00, 2448.00), // (22 in. by 34 in.) |
|
123 | + => array(1584.00, 2448.00), // (22 in. by 34 in.) |
|
124 | 124 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_E |
125 | - => array(2448.00, 3168.00), // (34 in. by 44 in.) |
|
125 | + => array(2448.00, 3168.00), // (34 in. by 44 in.) |
|
126 | 126 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_DL_ENVELOPE |
127 | - => array(311.81, 623.62), // (110 mm by 220 mm) |
|
127 | + => array(311.81, 623.62), // (110 mm by 220 mm) |
|
128 | 128 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_C5_ENVELOPE |
129 | - => 'C5', // (162 mm by 229 mm) |
|
129 | + => 'C5', // (162 mm by 229 mm) |
|
130 | 130 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_C3_ENVELOPE |
131 | - => 'C3', // (324 mm by 458 mm) |
|
131 | + => 'C3', // (324 mm by 458 mm) |
|
132 | 132 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_C4_ENVELOPE |
133 | - => 'C4', // (229 mm by 324 mm) |
|
133 | + => 'C4', // (229 mm by 324 mm) |
|
134 | 134 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_C6_ENVELOPE |
135 | - => 'C6', // (114 mm by 162 mm) |
|
135 | + => 'C6', // (114 mm by 162 mm) |
|
136 | 136 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_C65_ENVELOPE |
137 | - => array(323.15, 649.13), // (114 mm by 229 mm) |
|
137 | + => array(323.15, 649.13), // (114 mm by 229 mm) |
|
138 | 138 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_B4_ENVELOPE |
139 | - => 'B4', // (250 mm by 353 mm) |
|
139 | + => 'B4', // (250 mm by 353 mm) |
|
140 | 140 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_B5_ENVELOPE |
141 | - => 'B5', // (176 mm by 250 mm) |
|
141 | + => 'B5', // (176 mm by 250 mm) |
|
142 | 142 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_B6_ENVELOPE |
143 | - => array(498.90, 354.33), // (176 mm by 125 mm) |
|
143 | + => array(498.90, 354.33), // (176 mm by 125 mm) |
|
144 | 144 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_ITALY_ENVELOPE |
145 | - => array(311.81, 651.97), // (110 mm by 230 mm) |
|
145 | + => array(311.81, 651.97), // (110 mm by 230 mm) |
|
146 | 146 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_MONARCH_ENVELOPE |
147 | - => array(279.00, 540.00), // (3.875 in. by 7.5 in.) |
|
147 | + => array(279.00, 540.00), // (3.875 in. by 7.5 in.) |
|
148 | 148 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_6_3_4_ENVELOPE |
149 | - => array(261.00, 468.00), // (3.625 in. by 6.5 in.) |
|
149 | + => array(261.00, 468.00), // (3.625 in. by 6.5 in.) |
|
150 | 150 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_US_STANDARD_FANFOLD |
151 | - => array(1071.00, 792.00), // (14.875 in. by 11 in.) |
|
151 | + => array(1071.00, 792.00), // (14.875 in. by 11 in.) |
|
152 | 152 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_GERMAN_STANDARD_FANFOLD |
153 | - => array(612.00, 864.00), // (8.5 in. by 12 in.) |
|
153 | + => array(612.00, 864.00), // (8.5 in. by 12 in.) |
|
154 | 154 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_GERMAN_LEGAL_FANFOLD |
155 | - => 'FOLIO', // (8.5 in. by 13 in.) |
|
155 | + => 'FOLIO', // (8.5 in. by 13 in.) |
|
156 | 156 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_ISO_B4 |
157 | - => 'B4', // (250 mm by 353 mm) |
|
157 | + => 'B4', // (250 mm by 353 mm) |
|
158 | 158 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_JAPANESE_DOUBLE_POSTCARD |
159 | - => array(566.93, 419.53), // (200 mm by 148 mm) |
|
159 | + => array(566.93, 419.53), // (200 mm by 148 mm) |
|
160 | 160 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_STANDARD_PAPER_1 |
161 | - => array(648.00, 792.00), // (9 in. by 11 in.) |
|
161 | + => array(648.00, 792.00), // (9 in. by 11 in.) |
|
162 | 162 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_STANDARD_PAPER_2 |
163 | - => array(720.00, 792.00), // (10 in. by 11 in.) |
|
163 | + => array(720.00, 792.00), // (10 in. by 11 in.) |
|
164 | 164 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_STANDARD_PAPER_3 |
165 | - => array(1080.00, 792.00), // (15 in. by 11 in.) |
|
165 | + => array(1080.00, 792.00), // (15 in. by 11 in.) |
|
166 | 166 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_INVITE_ENVELOPE |
167 | - => array(623.62, 623.62), // (220 mm by 220 mm) |
|
167 | + => array(623.62, 623.62), // (220 mm by 220 mm) |
|
168 | 168 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_LETTER_EXTRA_PAPER |
169 | - => array(667.80, 864.00), // (9.275 in. by 12 in.) |
|
169 | + => array(667.80, 864.00), // (9.275 in. by 12 in.) |
|
170 | 170 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_LEGAL_EXTRA_PAPER |
171 | - => array(667.80, 1080.00), // (9.275 in. by 15 in.) |
|
171 | + => array(667.80, 1080.00), // (9.275 in. by 15 in.) |
|
172 | 172 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_TABLOID_EXTRA_PAPER |
173 | - => array(841.68, 1296.00), // (11.69 in. by 18 in.) |
|
173 | + => array(841.68, 1296.00), // (11.69 in. by 18 in.) |
|
174 | 174 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A4_EXTRA_PAPER |
175 | - => array(668.98, 912.76), // (236 mm by 322 mm) |
|
175 | + => array(668.98, 912.76), // (236 mm by 322 mm) |
|
176 | 176 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_LETTER_TRANSVERSE_PAPER |
177 | - => array(595.80, 792.00), // (8.275 in. by 11 in.) |
|
177 | + => array(595.80, 792.00), // (8.275 in. by 11 in.) |
|
178 | 178 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A4_TRANSVERSE_PAPER |
179 | - => 'A4', // (210 mm by 297 mm) |
|
179 | + => 'A4', // (210 mm by 297 mm) |
|
180 | 180 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_LETTER_EXTRA_TRANSVERSE_PAPER |
181 | - => array(667.80, 864.00), // (9.275 in. by 12 in.) |
|
181 | + => array(667.80, 864.00), // (9.275 in. by 12 in.) |
|
182 | 182 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_SUPERA_SUPERA_A4_PAPER |
183 | - => array(643.46, 1009.13), // (227 mm by 356 mm) |
|
183 | + => array(643.46, 1009.13), // (227 mm by 356 mm) |
|
184 | 184 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_SUPERB_SUPERB_A3_PAPER |
185 | - => array(864.57, 1380.47), // (305 mm by 487 mm) |
|
185 | + => array(864.57, 1380.47), // (305 mm by 487 mm) |
|
186 | 186 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_LETTER_PLUS_PAPER |
187 | - => array(612.00, 913.68), // (8.5 in. by 12.69 in.) |
|
187 | + => array(612.00, 913.68), // (8.5 in. by 12.69 in.) |
|
188 | 188 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A4_PLUS_PAPER |
189 | - => array(595.28, 935.43), // (210 mm by 330 mm) |
|
189 | + => array(595.28, 935.43), // (210 mm by 330 mm) |
|
190 | 190 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A5_TRANSVERSE_PAPER |
191 | - => 'A5', // (148 mm by 210 mm) |
|
191 | + => 'A5', // (148 mm by 210 mm) |
|
192 | 192 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_JIS_B5_TRANSVERSE_PAPER |
193 | - => array(515.91, 728.50), // (182 mm by 257 mm) |
|
193 | + => array(515.91, 728.50), // (182 mm by 257 mm) |
|
194 | 194 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A3_EXTRA_PAPER |
195 | - => array(912.76, 1261.42), // (322 mm by 445 mm) |
|
195 | + => array(912.76, 1261.42), // (322 mm by 445 mm) |
|
196 | 196 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A5_EXTRA_PAPER |
197 | - => array(493.23, 666.14), // (174 mm by 235 mm) |
|
197 | + => array(493.23, 666.14), // (174 mm by 235 mm) |
|
198 | 198 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_ISO_B5_EXTRA_PAPER |
199 | - => array(569.76, 782.36), // (201 mm by 276 mm) |
|
199 | + => array(569.76, 782.36), // (201 mm by 276 mm) |
|
200 | 200 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A2_PAPER |
201 | - => 'A2', // (420 mm by 594 mm) |
|
201 | + => 'A2', // (420 mm by 594 mm) |
|
202 | 202 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A3_TRANSVERSE_PAPER |
203 | - => 'A3', // (297 mm by 420 mm) |
|
203 | + => 'A3', // (297 mm by 420 mm) |
|
204 | 204 | \PHPExcel\Worksheet\PageSetup::PAPERSIZE_A3_EXTRA_TRANSVERSE_PAPER |
205 | 205 | => array(912.76, 1261.42) // (322 mm by 445 mm) |
206 | 206 | ); |
@@ -58,7 +58,7 @@ |
||
58 | 58 | $fileHandle = parent::prepareForSave($pFilename); |
59 | 59 | |
60 | 60 | // Default PDF paper size |
61 | - $paperSize = 'LETTER'; // Letter (8.5 in. by 11 in.) |
|
61 | + $paperSize = 'LETTER'; // Letter (8.5 in. by 11 in.) |
|
62 | 62 | |
63 | 63 | // Check for paper size and page orientation |
64 | 64 | if (is_null($this->getSheetIndex())) { |
@@ -58,7 +58,7 @@ |
||
58 | 58 | * |
59 | 59 | * @var string |
60 | 60 | */ |
61 | - protected $_diskCachingDirectory = './'; |
|
61 | + protected $_diskCachingDirectory = './'; |
|
62 | 62 | |
63 | 63 | /** |
64 | 64 | * Write charts in workbook? |
@@ -41,28 +41,28 @@ discard block |
||
41 | 41 | * |
42 | 42 | * @var string |
43 | 43 | */ |
44 | - private $delimiter = ','; |
|
44 | + private $delimiter = ','; |
|
45 | 45 | |
46 | 46 | /** |
47 | 47 | * Enclosure |
48 | 48 | * |
49 | 49 | * @var string |
50 | 50 | */ |
51 | - private $enclosure = '"'; |
|
51 | + private $enclosure = '"'; |
|
52 | 52 | |
53 | 53 | /** |
54 | 54 | * Line ending |
55 | 55 | * |
56 | 56 | * @var string |
57 | 57 | */ |
58 | - private $lineEnding = PHP_EOL; |
|
58 | + private $lineEnding = PHP_EOL; |
|
59 | 59 | |
60 | 60 | /** |
61 | 61 | * Sheet index to write |
62 | 62 | * |
63 | 63 | * @var int |
64 | 64 | */ |
65 | - private $sheetIndex = 0; |
|
65 | + private $sheetIndex = 0; |
|
66 | 66 | |
67 | 67 | /** |
68 | 68 | * Whether to write a BOM (for UTF8). |
@@ -119,10 +119,10 @@ discard block |
||
119 | 119 | } |
120 | 120 | |
121 | 121 | if ($this->excelCompatibility) { |
122 | - $this->setUseBOM(true); // Enforce UTF-8 BOM Header |
|
123 | - $this->setIncludeSeparatorLine(true); // Set separator line |
|
124 | - $this->setEnclosure('"'); // Set enclosure to " |
|
125 | - $this->setDelimiter(";"); // Set delimiter to a semi-colon |
|
122 | + $this->setUseBOM(true); // Enforce UTF-8 BOM Header |
|
123 | + $this->setIncludeSeparatorLine(true); // Set separator line |
|
124 | + $this->setEnclosure('"'); // Set enclosure to " |
|
125 | + $this->setDelimiter(";"); // Set delimiter to a semi-colon |
|
126 | 126 | $this->setLineEnding("\r\n"); |
127 | 127 | } |
128 | 128 | if ($this->useBOM) { |
@@ -141,7 +141,7 @@ discard block |
||
141 | 141 | // Write rows to file |
142 | 142 | for ($row = 1; $row <= $maxRow; ++$row) { |
143 | 143 | // Convert the row to an array... |
144 | - $cellsArray = $sheet->rangeToArray('A'.$row.':'.$maxCol.$row, '', $this->preCalculateFormulas); |
|
144 | + $cellsArray = $sheet->rangeToArray('A' . $row . ':' . $maxCol . $row, '', $this->preCalculateFormulas); |
|
145 | 145 | // ... and write to the file |
146 | 146 | $this->writeLine($fileHandle, $cellsArray[0]); |
147 | 147 | } |