@@ -46,28 +46,28 @@ discard block |
||
| 46 | 46 | * |
| 47 | 47 | * @var string |
| 48 | 48 | */ |
| 49 | - private $_delimiter = ','; |
|
| 49 | + private $_delimiter = ','; |
|
| 50 | 50 | |
| 51 | 51 | /** |
| 52 | 52 | * Enclosure |
| 53 | 53 | * |
| 54 | 54 | * @var string |
| 55 | 55 | */ |
| 56 | - private $_enclosure = '"'; |
|
| 56 | + private $_enclosure = '"'; |
|
| 57 | 57 | |
| 58 | 58 | /** |
| 59 | 59 | * Line ending |
| 60 | 60 | * |
| 61 | 61 | * @var string |
| 62 | 62 | */ |
| 63 | - private $_lineEnding = PHP_EOL; |
|
| 63 | + private $_lineEnding = PHP_EOL; |
|
| 64 | 64 | |
| 65 | 65 | /** |
| 66 | 66 | * Sheet index to write |
| 67 | 67 | * |
| 68 | 68 | * @var int |
| 69 | 69 | */ |
| 70 | - private $_sheetIndex = 0; |
|
| 70 | + private $_sheetIndex = 0; |
|
| 71 | 71 | |
| 72 | 72 | /** |
| 73 | 73 | * Pre-calculate formulas |
@@ -89,7 +89,7 @@ discard block |
||
| 89 | 89 | * @param PHPExcel $phpExcel PHPExcel object |
| 90 | 90 | */ |
| 91 | 91 | public function __construct(PHPExcel $phpExcel) { |
| 92 | - $this->_phpExcel = $phpExcel; |
|
| 92 | + $this->_phpExcel = $phpExcel; |
|
| 93 | 93 | } |
| 94 | 94 | |
| 95 | 95 | /** |
@@ -123,9 +123,9 @@ discard block |
||
| 123 | 123 | $maxRow = $sheet->getHighestRow(); |
| 124 | 124 | |
| 125 | 125 | // Write rows to file |
| 126 | - for($row = 1; $row <= $maxRow; ++$row) { |
|
| 126 | + for ($row = 1; $row <= $maxRow; ++$row) { |
|
| 127 | 127 | // Convert the row to an array... |
| 128 | - $cellsArray = $sheet->rangeToArray('A'.$row.':'.$maxCol.$row,'', $this->_preCalculateFormulas); |
|
| 128 | + $cellsArray = $sheet->rangeToArray('A'.$row.':'.$maxCol.$row, '', $this->_preCalculateFormulas); |
|
| 129 | 129 | // ... and write to the file |
| 130 | 130 | $this->_writeLine($fileHandle, $cellsArray[0]); |
| 131 | 131 | } |
@@ -257,7 +257,7 @@ discard block |
||
| 257 | 257 | |
| 258 | 258 | foreach ($pValues as $element) { |
| 259 | 259 | // Escape enclosures |
| 260 | - $element = str_replace($this->_enclosure, $this->_enclosure . $this->_enclosure, $element); |
|
| 260 | + $element = str_replace($this->_enclosure, $this->_enclosure.$this->_enclosure, $element); |
|
| 261 | 261 | |
| 262 | 262 | // Add delimiter |
| 263 | 263 | if ($writeDelimiter) { |
@@ -267,7 +267,7 @@ discard block |
||
| 267 | 267 | } |
| 268 | 268 | |
| 269 | 269 | // Add enclosed string |
| 270 | - $line .= $this->_enclosure . $element . $this->_enclosure; |
|
| 270 | + $line .= $this->_enclosure.$element.$this->_enclosure; |
|
| 271 | 271 | } |
| 272 | 272 | |
| 273 | 273 | // Add line ending |
@@ -62,7 +62,7 @@ discard block |
||
| 62 | 62 | * |
| 63 | 63 | * @var PHPExcel_Writer_Excel2007_WriterPart[] |
| 64 | 64 | */ |
| 65 | - private $_writerParts = array(); |
|
| 65 | + private $_writerParts = array(); |
|
| 66 | 66 | |
| 67 | 67 | /** |
| 68 | 68 | * Private PHPExcel |
@@ -76,7 +76,7 @@ discard block |
||
| 76 | 76 | * |
| 77 | 77 | * @var string[] |
| 78 | 78 | */ |
| 79 | - private $_stringTable = array(); |
|
| 79 | + private $_stringTable = array(); |
|
| 80 | 80 | |
| 81 | 81 | /** |
| 82 | 82 | * Private unique PHPExcel_Style_Conditional HashTable |
@@ -104,7 +104,7 @@ discard block |
||
| 104 | 104 | * |
| 105 | 105 | * @var PHPExcel_HashTable |
| 106 | 106 | */ |
| 107 | - private $_bordersHashTable ; |
|
| 107 | + private $_bordersHashTable; |
|
| 108 | 108 | |
| 109 | 109 | /** |
| 110 | 110 | * Private unique PHPExcel_Style_NumberFormat HashTable |
@@ -132,7 +132,7 @@ discard block |
||
| 132 | 132 | * |
| 133 | 133 | * @var string |
| 134 | 134 | */ |
| 135 | - private $_diskCachingDirectory = './'; |
|
| 135 | + private $_diskCachingDirectory = './'; |
|
| 136 | 136 | |
| 137 | 137 | /** |
| 138 | 138 | * Create a new PHPExcel_Writer_Excel2007 |
@@ -144,7 +144,7 @@ discard block |
||
| 144 | 144 | // Assign PHPExcel |
| 145 | 145 | $this->setPHPExcel($pPHPExcel); |
| 146 | 146 | |
| 147 | - $writerPartsArray = array( 'stringtable' => 'PHPExcel_Writer_Excel2007_StringTable', |
|
| 147 | + $writerPartsArray = array('stringtable' => 'PHPExcel_Writer_Excel2007_StringTable', |
|
| 148 | 148 | 'contenttypes' => 'PHPExcel_Writer_Excel2007_ContentTypes', |
| 149 | 149 | 'docprops' => 'PHPExcel_Writer_Excel2007_DocProps', |
| 150 | 150 | 'rels' => 'PHPExcel_Writer_Excel2007_Rels', |
@@ -163,13 +163,13 @@ discard block |
||
| 163 | 163 | $this->_writerParts[$writer] = new $class($this); |
| 164 | 164 | } |
| 165 | 165 | |
| 166 | - $hashTablesArray = array( '_stylesConditionalHashTable', '_fillHashTable', '_fontHashTable', |
|
| 167 | - '_bordersHashTable', '_numFmtHashTable', '_drawingHashTable' |
|
| 166 | + $hashTablesArray = array('_stylesConditionalHashTable', '_fillHashTable', '_fontHashTable', |
|
| 167 | + '_bordersHashTable', '_numFmtHashTable', '_drawingHashTable' |
|
| 168 | 168 | ); |
| 169 | 169 | |
| 170 | 170 | // Set HashTable variables |
| 171 | 171 | foreach ($hashTablesArray as $tableName) { |
| 172 | - $this->$tableName = new PHPExcel_HashTable(); |
|
| 172 | + $this->$tableName = new PHPExcel_HashTable(); |
|
| 173 | 173 | } |
| 174 | 174 | } |
| 175 | 175 | |
@@ -220,14 +220,14 @@ discard block |
||
| 220 | 220 | } |
| 221 | 221 | |
| 222 | 222 | // Create styles dictionaries |
| 223 | - $this->_stylesConditionalHashTable->addFromSource( $this->getWriterPart('Style')->allConditionalStyles($this->_spreadSheet) ); |
|
| 224 | - $this->_fillHashTable->addFromSource( $this->getWriterPart('Style')->allFills($this->_spreadSheet) ); |
|
| 225 | - $this->_fontHashTable->addFromSource( $this->getWriterPart('Style')->allFonts($this->_spreadSheet) ); |
|
| 226 | - $this->_bordersHashTable->addFromSource( $this->getWriterPart('Style')->allBorders($this->_spreadSheet) ); |
|
| 227 | - $this->_numFmtHashTable->addFromSource( $this->getWriterPart('Style')->allNumberFormats($this->_spreadSheet) ); |
|
| 223 | + $this->_stylesConditionalHashTable->addFromSource($this->getWriterPart('Style')->allConditionalStyles($this->_spreadSheet)); |
|
| 224 | + $this->_fillHashTable->addFromSource($this->getWriterPart('Style')->allFills($this->_spreadSheet)); |
|
| 225 | + $this->_fontHashTable->addFromSource($this->getWriterPart('Style')->allFonts($this->_spreadSheet)); |
|
| 226 | + $this->_bordersHashTable->addFromSource($this->getWriterPart('Style')->allBorders($this->_spreadSheet)); |
|
| 227 | + $this->_numFmtHashTable->addFromSource($this->getWriterPart('Style')->allNumberFormats($this->_spreadSheet)); |
|
| 228 | 228 | |
| 229 | 229 | // Create drawing dictionary |
| 230 | - $this->_drawingHashTable->addFromSource( $this->getWriterPart('Drawing')->allDrawings($this->_spreadSheet) ); |
|
| 230 | + $this->_drawingHashTable->addFromSource($this->getWriterPart('Drawing')->allDrawings($this->_spreadSheet)); |
|
| 231 | 231 | |
| 232 | 232 | // Create new ZIP file and open it for writing |
| 233 | 233 | $zipClass = PHPExcel_Settings::getZipClass(); |
@@ -245,46 +245,46 @@ discard block |
||
| 245 | 245 | // Try opening the ZIP file |
| 246 | 246 | if ($objZip->open($pFilename, $zipOverWrite) !== true) { |
| 247 | 247 | if ($objZip->open($pFilename, $zipCreate) !== true) { |
| 248 | - throw new Exception("Could not open " . $pFilename . " for writing."); |
|
| 248 | + throw new Exception("Could not open ".$pFilename." for writing."); |
|
| 249 | 249 | } |
| 250 | 250 | } |
| 251 | 251 | |
| 252 | 252 | // Add [Content_Types].xml to ZIP file |
| 253 | - $objZip->addFromString('[Content_Types].xml', $this->getWriterPart('ContentTypes')->writeContentTypes($this->_spreadSheet, $this->_includeCharts)); |
|
| 253 | + $objZip->addFromString('[Content_Types].xml', $this->getWriterPart('ContentTypes')->writeContentTypes($this->_spreadSheet, $this->_includeCharts)); |
|
| 254 | 254 | |
| 255 | 255 | // Add relationships to ZIP file |
| 256 | - $objZip->addFromString('_rels/.rels', $this->getWriterPart('Rels')->writeRelationships($this->_spreadSheet)); |
|
| 257 | - $objZip->addFromString('xl/_rels/workbook.xml.rels', $this->getWriterPart('Rels')->writeWorkbookRelationships($this->_spreadSheet)); |
|
| 256 | + $objZip->addFromString('_rels/.rels', $this->getWriterPart('Rels')->writeRelationships($this->_spreadSheet)); |
|
| 257 | + $objZip->addFromString('xl/_rels/workbook.xml.rels', $this->getWriterPart('Rels')->writeWorkbookRelationships($this->_spreadSheet)); |
|
| 258 | 258 | |
| 259 | 259 | // Add document properties to ZIP file |
| 260 | - $objZip->addFromString('docProps/app.xml', $this->getWriterPart('DocProps')->writeDocPropsApp($this->_spreadSheet)); |
|
| 261 | - $objZip->addFromString('docProps/core.xml', $this->getWriterPart('DocProps')->writeDocPropsCore($this->_spreadSheet)); |
|
| 260 | + $objZip->addFromString('docProps/app.xml', $this->getWriterPart('DocProps')->writeDocPropsApp($this->_spreadSheet)); |
|
| 261 | + $objZip->addFromString('docProps/core.xml', $this->getWriterPart('DocProps')->writeDocPropsCore($this->_spreadSheet)); |
|
| 262 | 262 | $customPropertiesPart = $this->getWriterPart('DocProps')->writeDocPropsCustom($this->_spreadSheet); |
| 263 | 263 | if ($customPropertiesPart !== NULL) { |
| 264 | - $objZip->addFromString('docProps/custom.xml', $customPropertiesPart); |
|
| 264 | + $objZip->addFromString('docProps/custom.xml', $customPropertiesPart); |
|
| 265 | 265 | } |
| 266 | 266 | |
| 267 | 267 | // Add theme to ZIP file |
| 268 | - $objZip->addFromString('xl/theme/theme1.xml', $this->getWriterPart('Theme')->writeTheme($this->_spreadSheet)); |
|
| 268 | + $objZip->addFromString('xl/theme/theme1.xml', $this->getWriterPart('Theme')->writeTheme($this->_spreadSheet)); |
|
| 269 | 269 | |
| 270 | 270 | // Add string table to ZIP file |
| 271 | - $objZip->addFromString('xl/sharedStrings.xml', $this->getWriterPart('StringTable')->writeStringTable($this->_stringTable)); |
|
| 271 | + $objZip->addFromString('xl/sharedStrings.xml', $this->getWriterPart('StringTable')->writeStringTable($this->_stringTable)); |
|
| 272 | 272 | |
| 273 | 273 | // Add styles to ZIP file |
| 274 | - $objZip->addFromString('xl/styles.xml', $this->getWriterPart('Style')->writeStyles($this->_spreadSheet)); |
|
| 274 | + $objZip->addFromString('xl/styles.xml', $this->getWriterPart('Style')->writeStyles($this->_spreadSheet)); |
|
| 275 | 275 | |
| 276 | 276 | // Add workbook to ZIP file |
| 277 | - $objZip->addFromString('xl/workbook.xml', $this->getWriterPart('Workbook')->writeWorkbook($this->_spreadSheet, $this->_preCalculateFormulas)); |
|
| 277 | + $objZip->addFromString('xl/workbook.xml', $this->getWriterPart('Workbook')->writeWorkbook($this->_spreadSheet, $this->_preCalculateFormulas)); |
|
| 278 | 278 | |
| 279 | 279 | $chartCount = 0; |
| 280 | 280 | // Add worksheets |
| 281 | 281 | for ($i = 0; $i < $this->_spreadSheet->getSheetCount(); ++$i) { |
| 282 | - $objZip->addFromString('xl/worksheets/sheet' . ($i + 1) . '.xml', $this->getWriterPart('Worksheet')->writeWorksheet($this->_spreadSheet->getSheet($i), $this->_stringTable, $this->_includeCharts)); |
|
| 282 | + $objZip->addFromString('xl/worksheets/sheet'.($i + 1).'.xml', $this->getWriterPart('Worksheet')->writeWorksheet($this->_spreadSheet->getSheet($i), $this->_stringTable, $this->_includeCharts)); |
|
| 283 | 283 | if ($this->_includeCharts) { |
| 284 | 284 | $charts = $this->_spreadSheet->getSheet($i)->getChartCollection(); |
| 285 | 285 | if (count($charts) > 0) { |
| 286 | - foreach($charts as $chart) { |
|
| 287 | - $objZip->addFromString('xl/charts/chart' . ($chartCount + 1) . '.xml', $this->getWriterPart('Chart')->writeChart($chart)); |
|
| 286 | + foreach ($charts as $chart) { |
|
| 287 | + $objZip->addFromString('xl/charts/chart'.($chartCount + 1).'.xml', $this->getWriterPart('Chart')->writeChart($chart)); |
|
| 288 | 288 | $chartCount++; |
| 289 | 289 | } |
| 290 | 290 | } |
@@ -296,7 +296,7 @@ discard block |
||
| 296 | 296 | for ($i = 0; $i < $this->_spreadSheet->getSheetCount(); ++$i) { |
| 297 | 297 | |
| 298 | 298 | // Add relationships |
| 299 | - $objZip->addFromString('xl/worksheets/_rels/sheet' . ($i + 1) . '.xml.rels', $this->getWriterPart('Rels')->writeWorksheetRelationships($this->_spreadSheet->getSheet($i), ($i + 1), $this->_includeCharts)); |
|
| 299 | + $objZip->addFromString('xl/worksheets/_rels/sheet'.($i + 1).'.xml.rels', $this->getWriterPart('Rels')->writeWorksheetRelationships($this->_spreadSheet->getSheet($i), ($i + 1), $this->_includeCharts)); |
|
| 300 | 300 | |
| 301 | 301 | $drawings = $this->_spreadSheet->getSheet($i)->getDrawingCollection(); |
| 302 | 302 | $drawingCount = count($drawings); |
@@ -307,32 +307,32 @@ discard block |
||
| 307 | 307 | // Add drawing and image relationship parts |
| 308 | 308 | if (($drawingCount > 0) || ($chartCount > 0)) { |
| 309 | 309 | // Drawing relationships |
| 310 | - $objZip->addFromString('xl/drawings/_rels/drawing' . ($i + 1) . '.xml.rels', $this->getWriterPart('Rels')->writeDrawingRelationships($this->_spreadSheet->getSheet($i),$chartRef1, $this->_includeCharts)); |
|
| 310 | + $objZip->addFromString('xl/drawings/_rels/drawing'.($i + 1).'.xml.rels', $this->getWriterPart('Rels')->writeDrawingRelationships($this->_spreadSheet->getSheet($i), $chartRef1, $this->_includeCharts)); |
|
| 311 | 311 | |
| 312 | 312 | // Drawings |
| 313 | - $objZip->addFromString('xl/drawings/drawing' . ($i + 1) . '.xml', $this->getWriterPart('Drawing')->writeDrawings($this->_spreadSheet->getSheet($i),$chartRef2,$this->_includeCharts)); |
|
| 313 | + $objZip->addFromString('xl/drawings/drawing'.($i + 1).'.xml', $this->getWriterPart('Drawing')->writeDrawings($this->_spreadSheet->getSheet($i), $chartRef2, $this->_includeCharts)); |
|
| 314 | 314 | } |
| 315 | 315 | |
| 316 | 316 | // Add comment relationship parts |
| 317 | 317 | if (count($this->_spreadSheet->getSheet($i)->getComments()) > 0) { |
| 318 | 318 | // VML Comments |
| 319 | - $objZip->addFromString('xl/drawings/vmlDrawing' . ($i + 1) . '.vml', $this->getWriterPart('Comments')->writeVMLComments($this->_spreadSheet->getSheet($i))); |
|
| 319 | + $objZip->addFromString('xl/drawings/vmlDrawing'.($i + 1).'.vml', $this->getWriterPart('Comments')->writeVMLComments($this->_spreadSheet->getSheet($i))); |
|
| 320 | 320 | |
| 321 | 321 | // Comments |
| 322 | - $objZip->addFromString('xl/comments' . ($i + 1) . '.xml', $this->getWriterPart('Comments')->writeComments($this->_spreadSheet->getSheet($i))); |
|
| 322 | + $objZip->addFromString('xl/comments'.($i + 1).'.xml', $this->getWriterPart('Comments')->writeComments($this->_spreadSheet->getSheet($i))); |
|
| 323 | 323 | } |
| 324 | 324 | |
| 325 | 325 | // Add header/footer relationship parts |
| 326 | 326 | if (count($this->_spreadSheet->getSheet($i)->getHeaderFooter()->getImages()) > 0) { |
| 327 | 327 | // VML Drawings |
| 328 | - $objZip->addFromString('xl/drawings/vmlDrawingHF' . ($i + 1) . '.vml', $this->getWriterPart('Drawing')->writeVMLHeaderFooterImages($this->_spreadSheet->getSheet($i))); |
|
| 328 | + $objZip->addFromString('xl/drawings/vmlDrawingHF'.($i + 1).'.vml', $this->getWriterPart('Drawing')->writeVMLHeaderFooterImages($this->_spreadSheet->getSheet($i))); |
|
| 329 | 329 | |
| 330 | 330 | // VML Drawing relationships |
| 331 | - $objZip->addFromString('xl/drawings/_rels/vmlDrawingHF' . ($i + 1) . '.vml.rels', $this->getWriterPart('Rels')->writeHeaderFooterDrawingRelationships($this->_spreadSheet->getSheet($i))); |
|
| 331 | + $objZip->addFromString('xl/drawings/_rels/vmlDrawingHF'.($i + 1).'.vml.rels', $this->getWriterPart('Rels')->writeHeaderFooterDrawingRelationships($this->_spreadSheet->getSheet($i))); |
|
| 332 | 332 | |
| 333 | 333 | // Media |
| 334 | 334 | foreach ($this->_spreadSheet->getSheet($i)->getHeaderFooter()->getImages() as $image) { |
| 335 | - $objZip->addFromString('xl/media/' . $image->getIndexedFilename(), file_get_contents($image->getPath())); |
|
| 335 | + $objZip->addFromString('xl/media/'.$image->getIndexedFilename(), file_get_contents($image->getPath())); |
|
| 336 | 336 | } |
| 337 | 337 | } |
| 338 | 338 | } |
@@ -356,7 +356,7 @@ discard block |
||
| 356 | 356 | $imageContents = file_get_contents($imagePath); |
| 357 | 357 | } |
| 358 | 358 | |
| 359 | - $objZip->addFromString('xl/media/' . str_replace(' ', '_', $this->getDrawingHashTable()->getByIndex($i)->getIndexedFilename()), $imageContents); |
|
| 359 | + $objZip->addFromString('xl/media/'.str_replace(' ', '_', $this->getDrawingHashTable()->getByIndex($i)->getIndexedFilename()), $imageContents); |
|
| 360 | 360 | } else if ($this->getDrawingHashTable()->getByIndex($i) instanceof PHPExcel_Worksheet_MemoryDrawing) { |
| 361 | 361 | ob_start(); |
| 362 | 362 | call_user_func( |
@@ -366,7 +366,7 @@ discard block |
||
| 366 | 366 | $imageContents = ob_get_contents(); |
| 367 | 367 | ob_end_clean(); |
| 368 | 368 | |
| 369 | - $objZip->addFromString('xl/media/' . str_replace(' ', '_', $this->getDrawingHashTable()->getByIndex($i)->getIndexedFilename()), $imageContents); |
|
| 369 | + $objZip->addFromString('xl/media/'.str_replace(' ', '_', $this->getDrawingHashTable()->getByIndex($i)->getIndexedFilename()), $imageContents); |
|
| 370 | 370 | } |
| 371 | 371 | } |
| 372 | 372 | |
@@ -134,17 +134,17 @@ discard block |
||
| 134 | 134 | */ |
| 135 | 135 | private $_diskCachingDirectory = './'; |
| 136 | 136 | |
| 137 | - /** |
|
| 138 | - * Create a new PHPExcel_Writer_Excel2007 |
|
| 139 | - * |
|
| 137 | + /** |
|
| 138 | + * Create a new PHPExcel_Writer_Excel2007 |
|
| 139 | + * |
|
| 140 | 140 | * @param PHPExcel $pPHPExcel |
| 141 | - */ |
|
| 142 | - public function __construct(PHPExcel $pPHPExcel = null) |
|
| 143 | - { |
|
| 144 | - // Assign PHPExcel |
|
| 141 | + */ |
|
| 142 | + public function __construct(PHPExcel $pPHPExcel = null) |
|
| 143 | + { |
|
| 144 | + // Assign PHPExcel |
|
| 145 | 145 | $this->setPHPExcel($pPHPExcel); |
| 146 | 146 | |
| 147 | - $writerPartsArray = array( 'stringtable' => 'PHPExcel_Writer_Excel2007_StringTable', |
|
| 147 | + $writerPartsArray = array( 'stringtable' => 'PHPExcel_Writer_Excel2007_StringTable', |
|
| 148 | 148 | 'contenttypes' => 'PHPExcel_Writer_Excel2007_ContentTypes', |
| 149 | 149 | 'docprops' => 'PHPExcel_Writer_Excel2007_DocProps', |
| 150 | 150 | 'rels' => 'PHPExcel_Writer_Excel2007_Rels', |
@@ -157,21 +157,21 @@ discard block |
||
| 157 | 157 | 'chart' => 'PHPExcel_Writer_Excel2007_Chart', |
| 158 | 158 | ); |
| 159 | 159 | |
| 160 | - // Initialise writer parts |
|
| 160 | + // Initialise writer parts |
|
| 161 | 161 | // and Assign their parent IWriters |
| 162 | 162 | foreach ($writerPartsArray as $writer => $class) { |
| 163 | 163 | $this->_writerParts[$writer] = new $class($this); |
| 164 | 164 | } |
| 165 | 165 | |
| 166 | - $hashTablesArray = array( '_stylesConditionalHashTable', '_fillHashTable', '_fontHashTable', |
|
| 166 | + $hashTablesArray = array( '_stylesConditionalHashTable', '_fillHashTable', '_fontHashTable', |
|
| 167 | 167 | '_bordersHashTable', '_numFmtHashTable', '_drawingHashTable' |
| 168 | - ); |
|
| 168 | + ); |
|
| 169 | 169 | |
| 170 | 170 | // Set HashTable variables |
| 171 | 171 | foreach ($hashTablesArray as $tableName) { |
| 172 | 172 | $this->$tableName = new PHPExcel_HashTable(); |
| 173 | 173 | } |
| 174 | - } |
|
| 174 | + } |
|
| 175 | 175 | |
| 176 | 176 | /** |
| 177 | 177 | * Get writer part |
@@ -416,68 +416,68 @@ discard block |
||
| 416 | 416 | return $this; |
| 417 | 417 | } |
| 418 | 418 | |
| 419 | - /** |
|
| 420 | - * Get string table |
|
| 421 | - * |
|
| 422 | - * @return string[] |
|
| 423 | - */ |
|
| 424 | - public function getStringTable() { |
|
| 425 | - return $this->_stringTable; |
|
| 426 | - } |
|
| 427 | - |
|
| 428 | - /** |
|
| 429 | - * Get PHPExcel_Style_Conditional HashTable |
|
| 430 | - * |
|
| 431 | - * @return PHPExcel_HashTable |
|
| 432 | - */ |
|
| 433 | - public function getStylesConditionalHashTable() { |
|
| 434 | - return $this->_stylesConditionalHashTable; |
|
| 435 | - } |
|
| 436 | - |
|
| 437 | - /** |
|
| 438 | - * Get PHPExcel_Style_Fill HashTable |
|
| 439 | - * |
|
| 440 | - * @return PHPExcel_HashTable |
|
| 441 | - */ |
|
| 442 | - public function getFillHashTable() { |
|
| 443 | - return $this->_fillHashTable; |
|
| 444 | - } |
|
| 445 | - |
|
| 446 | - /** |
|
| 447 | - * Get PHPExcel_Style_Font HashTable |
|
| 448 | - * |
|
| 449 | - * @return PHPExcel_HashTable |
|
| 450 | - */ |
|
| 451 | - public function getFontHashTable() { |
|
| 452 | - return $this->_fontHashTable; |
|
| 453 | - } |
|
| 454 | - |
|
| 455 | - /** |
|
| 456 | - * Get PHPExcel_Style_Borders HashTable |
|
| 457 | - * |
|
| 458 | - * @return PHPExcel_HashTable |
|
| 459 | - */ |
|
| 460 | - public function getBordersHashTable() { |
|
| 461 | - return $this->_bordersHashTable; |
|
| 462 | - } |
|
| 463 | - |
|
| 464 | - /** |
|
| 465 | - * Get PHPExcel_Style_NumberFormat HashTable |
|
| 466 | - * |
|
| 467 | - * @return PHPExcel_HashTable |
|
| 468 | - */ |
|
| 469 | - public function getNumFmtHashTable() { |
|
| 470 | - return $this->_numFmtHashTable; |
|
| 471 | - } |
|
| 472 | - |
|
| 473 | - /** |
|
| 474 | - * Get PHPExcel_Worksheet_BaseDrawing HashTable |
|
| 475 | - * |
|
| 476 | - * @return PHPExcel_HashTable |
|
| 477 | - */ |
|
| 478 | - public function getDrawingHashTable() { |
|
| 479 | - return $this->_drawingHashTable; |
|
| 480 | - } |
|
| 419 | + /** |
|
| 420 | + * Get string table |
|
| 421 | + * |
|
| 422 | + * @return string[] |
|
| 423 | + */ |
|
| 424 | + public function getStringTable() { |
|
| 425 | + return $this->_stringTable; |
|
| 426 | + } |
|
| 427 | + |
|
| 428 | + /** |
|
| 429 | + * Get PHPExcel_Style_Conditional HashTable |
|
| 430 | + * |
|
| 431 | + * @return PHPExcel_HashTable |
|
| 432 | + */ |
|
| 433 | + public function getStylesConditionalHashTable() { |
|
| 434 | + return $this->_stylesConditionalHashTable; |
|
| 435 | + } |
|
| 436 | + |
|
| 437 | + /** |
|
| 438 | + * Get PHPExcel_Style_Fill HashTable |
|
| 439 | + * |
|
| 440 | + * @return PHPExcel_HashTable |
|
| 441 | + */ |
|
| 442 | + public function getFillHashTable() { |
|
| 443 | + return $this->_fillHashTable; |
|
| 444 | + } |
|
| 445 | + |
|
| 446 | + /** |
|
| 447 | + * Get PHPExcel_Style_Font HashTable |
|
| 448 | + * |
|
| 449 | + * @return PHPExcel_HashTable |
|
| 450 | + */ |
|
| 451 | + public function getFontHashTable() { |
|
| 452 | + return $this->_fontHashTable; |
|
| 453 | + } |
|
| 454 | + |
|
| 455 | + /** |
|
| 456 | + * Get PHPExcel_Style_Borders HashTable |
|
| 457 | + * |
|
| 458 | + * @return PHPExcel_HashTable |
|
| 459 | + */ |
|
| 460 | + public function getBordersHashTable() { |
|
| 461 | + return $this->_bordersHashTable; |
|
| 462 | + } |
|
| 463 | + |
|
| 464 | + /** |
|
| 465 | + * Get PHPExcel_Style_NumberFormat HashTable |
|
| 466 | + * |
|
| 467 | + * @return PHPExcel_HashTable |
|
| 468 | + */ |
|
| 469 | + public function getNumFmtHashTable() { |
|
| 470 | + return $this->_numFmtHashTable; |
|
| 471 | + } |
|
| 472 | + |
|
| 473 | + /** |
|
| 474 | + * Get PHPExcel_Worksheet_BaseDrawing HashTable |
|
| 475 | + * |
|
| 476 | + * @return PHPExcel_HashTable |
|
| 477 | + */ |
|
| 478 | + public function getDrawingHashTable() { |
|
| 479 | + return $this->_drawingHashTable; |
|
| 480 | + } |
|
| 481 | 481 | |
| 482 | 482 | /** |
| 483 | 483 | * Write charts in workbook? |
@@ -504,43 +504,43 @@ discard block |
||
| 504 | 504 | return $this; |
| 505 | 505 | } |
| 506 | 506 | |
| 507 | - /** |
|
| 508 | - * Get Pre-Calculate Formulas |
|
| 509 | - * |
|
| 510 | - * @return boolean |
|
| 511 | - */ |
|
| 512 | - public function getPreCalculateFormulas() { |
|
| 513 | - return $this->_preCalculateFormulas; |
|
| 514 | - } |
|
| 515 | - |
|
| 516 | - /** |
|
| 517 | - * Set Pre-Calculate Formulas |
|
| 518 | - * |
|
| 519 | - * @param boolean $pValue Pre-Calculate Formulas? |
|
| 520 | - */ |
|
| 521 | - public function setPreCalculateFormulas($pValue = true) { |
|
| 522 | - $this->_preCalculateFormulas = $pValue; |
|
| 523 | - } |
|
| 524 | - |
|
| 525 | - /** |
|
| 526 | - * Get Office2003 compatibility |
|
| 527 | - * |
|
| 528 | - * @return boolean |
|
| 529 | - */ |
|
| 530 | - public function getOffice2003Compatibility() { |
|
| 531 | - return $this->_office2003compatibility; |
|
| 532 | - } |
|
| 533 | - |
|
| 534 | - /** |
|
| 535 | - * Set Pre-Calculate Formulas |
|
| 536 | - * |
|
| 537 | - * @param boolean $pValue Office2003 compatibility? |
|
| 538 | - * @return PHPExcel_Writer_Excel2007 |
|
| 539 | - */ |
|
| 540 | - public function setOffice2003Compatibility($pValue = false) { |
|
| 541 | - $this->_office2003compatibility = $pValue; |
|
| 542 | - return $this; |
|
| 543 | - } |
|
| 507 | + /** |
|
| 508 | + * Get Pre-Calculate Formulas |
|
| 509 | + * |
|
| 510 | + * @return boolean |
|
| 511 | + */ |
|
| 512 | + public function getPreCalculateFormulas() { |
|
| 513 | + return $this->_preCalculateFormulas; |
|
| 514 | + } |
|
| 515 | + |
|
| 516 | + /** |
|
| 517 | + * Set Pre-Calculate Formulas |
|
| 518 | + * |
|
| 519 | + * @param boolean $pValue Pre-Calculate Formulas? |
|
| 520 | + */ |
|
| 521 | + public function setPreCalculateFormulas($pValue = true) { |
|
| 522 | + $this->_preCalculateFormulas = $pValue; |
|
| 523 | + } |
|
| 524 | + |
|
| 525 | + /** |
|
| 526 | + * Get Office2003 compatibility |
|
| 527 | + * |
|
| 528 | + * @return boolean |
|
| 529 | + */ |
|
| 530 | + public function getOffice2003Compatibility() { |
|
| 531 | + return $this->_office2003compatibility; |
|
| 532 | + } |
|
| 533 | + |
|
| 534 | + /** |
|
| 535 | + * Set Pre-Calculate Formulas |
|
| 536 | + * |
|
| 537 | + * @param boolean $pValue Office2003 compatibility? |
|
| 538 | + * @return PHPExcel_Writer_Excel2007 |
|
| 539 | + */ |
|
| 540 | + public function setOffice2003Compatibility($pValue = false) { |
|
| 541 | + $this->_office2003compatibility = $pValue; |
|
| 542 | + return $this; |
|
| 543 | + } |
|
| 544 | 544 | |
| 545 | 545 | /** |
| 546 | 546 | * Get use disk caching where possible? |
@@ -563,11 +563,11 @@ discard block |
||
| 563 | 563 | $this->_useDiskCaching = $pValue; |
| 564 | 564 | |
| 565 | 565 | if ($pDirectory !== NULL) { |
| 566 | - if (is_dir($pDirectory)) { |
|
| 567 | - $this->_diskCachingDirectory = $pDirectory; |
|
| 568 | - } else { |
|
| 569 | - throw new Exception("Directory does not exist: $pDirectory"); |
|
| 570 | - } |
|
| 566 | + if (is_dir($pDirectory)) { |
|
| 567 | + $this->_diskCachingDirectory = $pDirectory; |
|
| 568 | + } else { |
|
| 569 | + throw new Exception("Directory does not exist: $pDirectory"); |
|
| 570 | + } |
|
| 571 | 571 | } |
| 572 | 572 | return $this; |
| 573 | 573 | } |
@@ -55,7 +55,7 @@ discard block |
||
| 55 | 55 | $pChart->refresh(); |
| 56 | 56 | |
| 57 | 57 | // XML header |
| 58 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
| 58 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
| 59 | 59 | |
| 60 | 60 | // c:chartSpace |
| 61 | 61 | $objWriter->startElement('c:chartSpace'); |
@@ -232,11 +232,11 @@ discard block |
||
| 232 | 232 | $chartTypes = self::_getChartType($plotArea); |
| 233 | 233 | $catIsMultiLevelSeries = $valIsMultiLevelSeries = FALSE; |
| 234 | 234 | $plotGroupingType = ''; |
| 235 | - foreach($chartTypes as $chartType) { |
|
| 235 | + foreach ($chartTypes as $chartType) { |
|
| 236 | 236 | $objWriter->startElement('c:'.$chartType); |
| 237 | 237 | |
| 238 | 238 | $groupCount = $plotArea->getPlotGroupCount(); |
| 239 | - for($i = 0; $i < $groupCount; ++$i) { |
|
| 239 | + for ($i = 0; $i < $groupCount; ++$i) { |
|
| 240 | 240 | $plotGroup = $plotArea->getPlotGroupByIndex($i); |
| 241 | 241 | $groupType = $plotGroup->getPlotType(); |
| 242 | 242 | if ($groupType == $chartType) { |
@@ -244,11 +244,11 @@ discard block |
||
| 244 | 244 | $plotStyle = $plotGroup->getPlotStyle(); |
| 245 | 245 | if ($groupType === PHPExcel_Chart_DataSeries::TYPE_RADARCHART) { |
| 246 | 246 | $objWriter->startElement('c:radarStyle'); |
| 247 | - $objWriter->writeAttribute('val', $plotStyle ); |
|
| 247 | + $objWriter->writeAttribute('val', $plotStyle); |
|
| 248 | 248 | $objWriter->endElement(); |
| 249 | 249 | } elseif ($groupType === PHPExcel_Chart_DataSeries::TYPE_SCATTERCHART) { |
| 250 | 250 | $objWriter->startElement('c:scatterStyle'); |
| 251 | - $objWriter->writeAttribute('val', $plotStyle ); |
|
| 251 | + $objWriter->writeAttribute('val', $plotStyle); |
|
| 252 | 252 | $objWriter->endElement(); |
| 253 | 253 | } |
| 254 | 254 | |
@@ -262,30 +262,30 @@ discard block |
||
| 262 | 262 | // Line only, Line3D can't be smoothed |
| 263 | 263 | |
| 264 | 264 | $objWriter->startElement('c:smooth'); |
| 265 | - $objWriter->writeAttribute('val', (integer) $plotGroup->getSmoothLine() ); |
|
| 265 | + $objWriter->writeAttribute('val', (integer) $plotGroup->getSmoothLine()); |
|
| 266 | 266 | $objWriter->endElement(); |
| 267 | 267 | } elseif (($chartType === PHPExcel_Chart_DataSeries::TYPE_BARCHART) || |
| 268 | 268 | ($chartType === PHPExcel_Chart_DataSeries::TYPE_BARCHART_3D)) { |
| 269 | 269 | |
| 270 | 270 | $objWriter->startElement('c:gapWidth'); |
| 271 | - $objWriter->writeAttribute('val', 150 ); |
|
| 271 | + $objWriter->writeAttribute('val', 150); |
|
| 272 | 272 | $objWriter->endElement(); |
| 273 | 273 | |
| 274 | 274 | if ($plotGroupingType == 'percentStacked' || |
| 275 | 275 | $plotGroupingType == 'stacked') { |
| 276 | 276 | |
| 277 | 277 | $objWriter->startElement('c:overlap'); |
| 278 | - $objWriter->writeAttribute('val', 100 ); |
|
| 278 | + $objWriter->writeAttribute('val', 100); |
|
| 279 | 279 | $objWriter->endElement(); |
| 280 | 280 | } |
| 281 | 281 | } elseif ($chartType === PHPExcel_Chart_DataSeries::TYPE_BUBBLECHART) { |
| 282 | 282 | |
| 283 | 283 | $objWriter->startElement('c:bubbleScale'); |
| 284 | - $objWriter->writeAttribute('val', 25 ); |
|
| 284 | + $objWriter->writeAttribute('val', 25); |
|
| 285 | 285 | $objWriter->endElement(); |
| 286 | 286 | |
| 287 | 287 | $objWriter->startElement('c:showNegBubbles'); |
| 288 | - $objWriter->writeAttribute('val', 0 ); |
|
| 288 | + $objWriter->writeAttribute('val', 0); |
|
| 289 | 289 | $objWriter->endElement(); |
| 290 | 290 | } elseif ($chartType === PHPExcel_Chart_DataSeries::TYPE_STOCKCHART) { |
| 291 | 291 | |
@@ -306,10 +306,10 @@ discard block |
||
| 306 | 306 | ($chartType !== PHPExcel_Chart_DataSeries::TYPE_DONUTCHART)) { |
| 307 | 307 | |
| 308 | 308 | $objWriter->startElement('c:axId'); |
| 309 | - $objWriter->writeAttribute('val', $id1 ); |
|
| 309 | + $objWriter->writeAttribute('val', $id1); |
|
| 310 | 310 | $objWriter->endElement(); |
| 311 | 311 | $objWriter->startElement('c:axId'); |
| 312 | - $objWriter->writeAttribute('val', $id2 ); |
|
| 312 | + $objWriter->writeAttribute('val', $id2); |
|
| 313 | 313 | $objWriter->endElement(); |
| 314 | 314 | } else { |
| 315 | 315 | $objWriter->startElement('c:firstSliceAng'); |
@@ -332,12 +332,12 @@ discard block |
||
| 332 | 332 | ($chartType !== PHPExcel_Chart_DataSeries::TYPE_DONUTCHART)) { |
| 333 | 333 | |
| 334 | 334 | if ($chartType === PHPExcel_Chart_DataSeries::TYPE_BUBBLECHART) { |
| 335 | - $this->_writeValAx($objWriter,$plotArea,$xAxisLabel,$chartType,$id1,$id2,$catIsMultiLevelSeries); |
|
| 335 | + $this->_writeValAx($objWriter, $plotArea, $xAxisLabel, $chartType, $id1, $id2, $catIsMultiLevelSeries); |
|
| 336 | 336 | } else { |
| 337 | - $this->_writeCatAx($objWriter,$plotArea,$xAxisLabel,$chartType,$id1,$id2,$catIsMultiLevelSeries); |
|
| 337 | + $this->_writeCatAx($objWriter, $plotArea, $xAxisLabel, $chartType, $id1, $id2, $catIsMultiLevelSeries); |
|
| 338 | 338 | } |
| 339 | 339 | |
| 340 | - $this->_writeValAx($objWriter,$plotArea,$yAxisLabel,$chartType,$id1,$id2,$valIsMultiLevelSeries); |
|
| 340 | + $this->_writeValAx($objWriter, $plotArea, $yAxisLabel, $chartType, $id1, $id2, $valIsMultiLevelSeries); |
|
| 341 | 341 | } |
| 342 | 342 | |
| 343 | 343 | $objWriter->endElement(); |
@@ -420,7 +420,7 @@ discard block |
||
| 420 | 420 | $objWriter->writeAttribute('val', "b"); |
| 421 | 421 | $objWriter->endElement(); |
| 422 | 422 | |
| 423 | - if (!is_null($xAxisLabel)) { |
|
| 423 | + if ( ! is_null($xAxisLabel)) { |
|
| 424 | 424 | $objWriter->startElement('c:title'); |
| 425 | 425 | $objWriter->startElement('c:tx'); |
| 426 | 426 | $objWriter->startElement('c:rich'); |
@@ -439,7 +439,7 @@ discard block |
||
| 439 | 439 | $caption = $caption[0]; |
| 440 | 440 | $objWriter->startElement('a:t'); |
| 441 | 441 | $objWriter->writeAttribute('xml:space', 'preserve'); |
| 442 | - $objWriter->writeRawData(PHPExcel_Shared_String::ControlCharacterPHP2OOXML( $caption )); |
|
| 442 | + $objWriter->writeRawData(PHPExcel_Shared_String::ControlCharacterPHP2OOXML($caption)); |
|
| 443 | 443 | $objWriter->endElement(); |
| 444 | 444 | |
| 445 | 445 | $objWriter->endElement(); |
@@ -546,7 +546,7 @@ discard block |
||
| 546 | 546 | $objWriter->startElement('c:majorGridlines'); |
| 547 | 547 | $objWriter->endElement(); |
| 548 | 548 | |
| 549 | - if (!is_null($yAxisLabel)) { |
|
| 549 | + if ( ! is_null($yAxisLabel)) { |
|
| 550 | 550 | $objWriter->startElement('c:title'); |
| 551 | 551 | $objWriter->startElement('c:tx'); |
| 552 | 552 | $objWriter->startElement('c:rich'); |
@@ -565,7 +565,7 @@ discard block |
||
| 565 | 565 | $caption = $caption[0]; |
| 566 | 566 | $objWriter->startElement('a:t'); |
| 567 | 567 | $objWriter->writeAttribute('xml:space', 'preserve'); |
| 568 | - $objWriter->writeRawData(PHPExcel_Shared_String::ControlCharacterPHP2OOXML( $caption )); |
|
| 568 | + $objWriter->writeRawData(PHPExcel_Shared_String::ControlCharacterPHP2OOXML($caption)); |
|
| 569 | 569 | $objWriter->endElement(); |
| 570 | 570 | |
| 571 | 571 | $objWriter->endElement(); |
@@ -643,7 +643,7 @@ discard block |
||
| 643 | 643 | $chartType = array($plotArea->getPlotGroupByIndex(0)->getPlotType()); |
| 644 | 644 | } else { |
| 645 | 645 | $chartTypes = array(); |
| 646 | - for($i = 0; $i < $groupCount; ++$i) { |
|
| 646 | + for ($i = 0; $i < $groupCount; ++$i) { |
|
| 647 | 647 | $chartTypes[] = $plotArea->getPlotGroupByIndex($i)->getPlotType(); |
| 648 | 648 | } |
| 649 | 649 | $chartType = array_unique($chartTypes); |
@@ -679,7 +679,7 @@ discard block |
||
| 679 | 679 | $objWriter->endElement(); |
| 680 | 680 | } |
| 681 | 681 | |
| 682 | - if (!is_null($plotGroup->getPlotGrouping())) { |
|
| 682 | + if ( ! is_null($plotGroup->getPlotGrouping())) { |
|
| 683 | 683 | $plotGroupingType = $plotGroup->getPlotGrouping(); |
| 684 | 684 | $objWriter->startElement('c:grouping'); |
| 685 | 685 | $objWriter->writeAttribute('val', $plotGroupingType); |
@@ -709,7 +709,7 @@ discard block |
||
| 709 | 709 | } |
| 710 | 710 | } |
| 711 | 711 | |
| 712 | - foreach($plotSeriesOrder as $plotSeriesIdx => $plotSeriesRef) { |
|
| 712 | + foreach ($plotSeriesOrder as $plotSeriesIdx => $plotSeriesRef) { |
|
| 713 | 713 | $objWriter->startElement('c:ser'); |
| 714 | 714 | |
| 715 | 715 | $objWriter->startElement('c:idx'); |
@@ -798,7 +798,7 @@ discard block |
||
| 798 | 798 | ($groupType == PHPExcel_Chart_DataSeries::TYPE_PIECHART_3D) || |
| 799 | 799 | ($groupType == PHPExcel_Chart_DataSeries::TYPE_DONUTCHART)) { |
| 800 | 800 | |
| 801 | - if (!is_null($plotGroup->getPlotStyle())) { |
|
| 801 | + if ( ! is_null($plotGroup->getPlotStyle())) { |
|
| 802 | 802 | $plotStyle = $plotGroup->getPlotStyle(); |
| 803 | 803 | if ($plotStyle) { |
| 804 | 804 | $objWriter->startElement('c:explosion'); |
@@ -862,15 +862,15 @@ discard block |
||
| 862 | 862 | |
| 863 | 863 | $objWriter->startElement('c:strCache'); |
| 864 | 864 | $objWriter->startElement('c:ptCount'); |
| 865 | - $objWriter->writeAttribute('val', $plotSeriesLabel->getPointCount() ); |
|
| 865 | + $objWriter->writeAttribute('val', $plotSeriesLabel->getPointCount()); |
|
| 866 | 866 | $objWriter->endElement(); |
| 867 | 867 | |
| 868 | - foreach($plotSeriesLabel->getDataValues() as $plotLabelKey => $plotLabelValue) { |
|
| 868 | + foreach ($plotSeriesLabel->getDataValues() as $plotLabelKey => $plotLabelValue) { |
|
| 869 | 869 | $objWriter->startElement('c:pt'); |
| 870 | - $objWriter->writeAttribute('idx', $plotLabelKey ); |
|
| 870 | + $objWriter->writeAttribute('idx', $plotLabelKey); |
|
| 871 | 871 | |
| 872 | 872 | $objWriter->startElement('c:v'); |
| 873 | - $objWriter->writeRawData( $plotLabelValue ); |
|
| 873 | + $objWriter->writeRawData($plotLabelValue); |
|
| 874 | 874 | $objWriter->endElement(); |
| 875 | 875 | $objWriter->endElement(); |
| 876 | 876 | } |
@@ -887,7 +887,7 @@ discard block |
||
| 887 | 887 | * @param string $dataType Datatype of series values |
| 888 | 888 | * @throws Exception |
| 889 | 889 | */ |
| 890 | - private function _writePlotSeriesValues($plotSeriesValues, $objWriter, $groupType, $dataType='str') |
|
| 890 | + private function _writePlotSeriesValues($plotSeriesValues, $objWriter, $groupType, $dataType = 'str') |
|
| 891 | 891 | { |
| 892 | 892 | if (is_null($plotSeriesValues)) { |
| 893 | 893 | return; |
@@ -899,25 +899,25 @@ discard block |
||
| 899 | 899 | $objWriter->startElement('c:multiLvlStrRef'); |
| 900 | 900 | |
| 901 | 901 | $objWriter->startElement('c:f'); |
| 902 | - $objWriter->writeRawData( $plotSeriesValues->getDataSource() ); |
|
| 902 | + $objWriter->writeRawData($plotSeriesValues->getDataSource()); |
|
| 903 | 903 | $objWriter->endElement(); |
| 904 | 904 | |
| 905 | 905 | $objWriter->startElement('c:multiLvlStrCache'); |
| 906 | 906 | |
| 907 | 907 | $objWriter->startElement('c:ptCount'); |
| 908 | - $objWriter->writeAttribute('val', $plotSeriesValues->getPointCount() ); |
|
| 908 | + $objWriter->writeAttribute('val', $plotSeriesValues->getPointCount()); |
|
| 909 | 909 | $objWriter->endElement(); |
| 910 | 910 | |
| 911 | 911 | for ($level = 0; $level < $levelCount; ++$level) { |
| 912 | 912 | $objWriter->startElement('c:lvl'); |
| 913 | 913 | |
| 914 | - foreach($plotSeriesValues->getDataValues() as $plotSeriesKey => $plotSeriesValue) { |
|
| 914 | + foreach ($plotSeriesValues->getDataValues() as $plotSeriesKey => $plotSeriesValue) { |
|
| 915 | 915 | if (isset($plotSeriesValue[$level])) { |
| 916 | 916 | $objWriter->startElement('c:pt'); |
| 917 | - $objWriter->writeAttribute('idx', $plotSeriesKey ); |
|
| 917 | + $objWriter->writeAttribute('idx', $plotSeriesKey); |
|
| 918 | 918 | |
| 919 | 919 | $objWriter->startElement('c:v'); |
| 920 | - $objWriter->writeRawData( $plotSeriesValue[$level] ); |
|
| 920 | + $objWriter->writeRawData($plotSeriesValue[$level]); |
|
| 921 | 921 | $objWriter->endElement(); |
| 922 | 922 | $objWriter->endElement(); |
| 923 | 923 | } |
@@ -933,7 +933,7 @@ discard block |
||
| 933 | 933 | $objWriter->startElement('c:'.$dataType.'Ref'); |
| 934 | 934 | |
| 935 | 935 | $objWriter->startElement('c:f'); |
| 936 | - $objWriter->writeRawData( $plotSeriesValues->getDataSource() ); |
|
| 936 | + $objWriter->writeRawData($plotSeriesValues->getDataSource()); |
|
| 937 | 937 | $objWriter->endElement(); |
| 938 | 938 | |
| 939 | 939 | $objWriter->startElement('c:'.$dataType.'Cache'); |
@@ -944,21 +944,21 @@ discard block |
||
| 944 | 944 | |
| 945 | 945 | if ($plotSeriesValues->getFormatCode() !== NULL) { |
| 946 | 946 | $objWriter->startElement('c:formatCode'); |
| 947 | - $objWriter->writeRawData( $plotSeriesValues->getFormatCode() ); |
|
| 947 | + $objWriter->writeRawData($plotSeriesValues->getFormatCode()); |
|
| 948 | 948 | $objWriter->endElement(); |
| 949 | 949 | } |
| 950 | 950 | } |
| 951 | 951 | |
| 952 | 952 | $objWriter->startElement('c:ptCount'); |
| 953 | - $objWriter->writeAttribute('val', $plotSeriesValues->getPointCount() ); |
|
| 953 | + $objWriter->writeAttribute('val', $plotSeriesValues->getPointCount()); |
|
| 954 | 954 | $objWriter->endElement(); |
| 955 | 955 | |
| 956 | - foreach($plotSeriesValues->getDataValues() as $plotSeriesKey => $plotSeriesValue) { |
|
| 956 | + foreach ($plotSeriesValues->getDataValues() as $plotSeriesKey => $plotSeriesValue) { |
|
| 957 | 957 | $objWriter->startElement('c:pt'); |
| 958 | - $objWriter->writeAttribute('idx', $plotSeriesKey ); |
|
| 958 | + $objWriter->writeAttribute('idx', $plotSeriesKey); |
|
| 959 | 959 | |
| 960 | 960 | $objWriter->startElement('c:v'); |
| 961 | - $objWriter->writeRawData( $plotSeriesValue ); |
|
| 961 | + $objWriter->writeRawData($plotSeriesValue); |
|
| 962 | 962 | $objWriter->endElement(); |
| 963 | 963 | $objWriter->endElement(); |
| 964 | 964 | } |
@@ -986,18 +986,18 @@ discard block |
||
| 986 | 986 | $objWriter->startElement('c:numLit'); |
| 987 | 987 | |
| 988 | 988 | $objWriter->startElement('c:formatCode'); |
| 989 | - $objWriter->writeRawData( 'General' ); |
|
| 989 | + $objWriter->writeRawData('General'); |
|
| 990 | 990 | $objWriter->endElement(); |
| 991 | 991 | |
| 992 | 992 | $objWriter->startElement('c:ptCount'); |
| 993 | - $objWriter->writeAttribute('val', $plotSeriesValues->getPointCount() ); |
|
| 993 | + $objWriter->writeAttribute('val', $plotSeriesValues->getPointCount()); |
|
| 994 | 994 | $objWriter->endElement(); |
| 995 | 995 | |
| 996 | - foreach($plotSeriesValues->getDataValues() as $plotSeriesKey => $plotSeriesValue) { |
|
| 996 | + foreach ($plotSeriesValues->getDataValues() as $plotSeriesKey => $plotSeriesValue) { |
|
| 997 | 997 | $objWriter->startElement('c:pt'); |
| 998 | - $objWriter->writeAttribute('idx', $plotSeriesKey ); |
|
| 998 | + $objWriter->writeAttribute('idx', $plotSeriesKey); |
|
| 999 | 999 | $objWriter->startElement('c:v'); |
| 1000 | - $objWriter->writeRawData( 1 ); |
|
| 1000 | + $objWriter->writeRawData(1); |
|
| 1001 | 1001 | $objWriter->endElement(); |
| 1002 | 1002 | $objWriter->endElement(); |
| 1003 | 1003 | } |
@@ -1006,7 +1006,7 @@ discard block |
||
| 1006 | 1006 | $objWriter->endElement(); |
| 1007 | 1007 | |
| 1008 | 1008 | $objWriter->startElement('c:bubble3D'); |
| 1009 | - $objWriter->writeAttribute('val', 0 ); |
|
| 1009 | + $objWriter->writeAttribute('val', 0); |
|
| 1010 | 1010 | $objWriter->endElement(); |
| 1011 | 1011 | } |
| 1012 | 1012 | |
@@ -1021,53 +1021,53 @@ discard block |
||
| 1021 | 1021 | { |
| 1022 | 1022 | $objWriter->startElement('c:layout'); |
| 1023 | 1023 | |
| 1024 | - if (!is_null($layout)) { |
|
| 1024 | + if ( ! is_null($layout)) { |
|
| 1025 | 1025 | $objWriter->startElement('c:manualLayout'); |
| 1026 | 1026 | |
| 1027 | 1027 | $layoutTarget = $layout->getLayoutTarget(); |
| 1028 | - if (!is_null($layoutTarget)) { |
|
| 1028 | + if ( ! is_null($layoutTarget)) { |
|
| 1029 | 1029 | $objWriter->startElement('c:layoutTarget'); |
| 1030 | 1030 | $objWriter->writeAttribute('val', $layoutTarget); |
| 1031 | 1031 | $objWriter->endElement(); |
| 1032 | 1032 | } |
| 1033 | 1033 | |
| 1034 | 1034 | $xMode = $layout->getXMode(); |
| 1035 | - if (!is_null($xMode)) { |
|
| 1035 | + if ( ! is_null($xMode)) { |
|
| 1036 | 1036 | $objWriter->startElement('c:xMode'); |
| 1037 | 1037 | $objWriter->writeAttribute('val', $xMode); |
| 1038 | 1038 | $objWriter->endElement(); |
| 1039 | 1039 | } |
| 1040 | 1040 | |
| 1041 | 1041 | $yMode = $layout->getYMode(); |
| 1042 | - if (!is_null($yMode)) { |
|
| 1042 | + if ( ! is_null($yMode)) { |
|
| 1043 | 1043 | $objWriter->startElement('c:yMode'); |
| 1044 | 1044 | $objWriter->writeAttribute('val', $yMode); |
| 1045 | 1045 | $objWriter->endElement(); |
| 1046 | 1046 | } |
| 1047 | 1047 | |
| 1048 | 1048 | $x = $layout->getXPosition(); |
| 1049 | - if (!is_null($x)) { |
|
| 1049 | + if ( ! is_null($x)) { |
|
| 1050 | 1050 | $objWriter->startElement('c:x'); |
| 1051 | 1051 | $objWriter->writeAttribute('val', $x); |
| 1052 | 1052 | $objWriter->endElement(); |
| 1053 | 1053 | } |
| 1054 | 1054 | |
| 1055 | 1055 | $y = $layout->getYPosition(); |
| 1056 | - if (!is_null($y)) { |
|
| 1056 | + if ( ! is_null($y)) { |
|
| 1057 | 1057 | $objWriter->startElement('c:y'); |
| 1058 | 1058 | $objWriter->writeAttribute('val', $y); |
| 1059 | 1059 | $objWriter->endElement(); |
| 1060 | 1060 | } |
| 1061 | 1061 | |
| 1062 | 1062 | $w = $layout->getWidth(); |
| 1063 | - if (!is_null($w)) { |
|
| 1063 | + if ( ! is_null($w)) { |
|
| 1064 | 1064 | $objWriter->startElement('c:w'); |
| 1065 | 1065 | $objWriter->writeAttribute('val', $w); |
| 1066 | 1066 | $objWriter->endElement(); |
| 1067 | 1067 | } |
| 1068 | 1068 | |
| 1069 | 1069 | $h = $layout->getHeight(); |
| 1070 | - if (!is_null($h)) { |
|
| 1070 | + if ( ! is_null($h)) { |
|
| 1071 | 1071 | $objWriter->startElement('c:h'); |
| 1072 | 1072 | $objWriter->writeAttribute('val', $h); |
| 1073 | 1073 | $objWriter->endElement(); |
@@ -136,8 +136,9 @@ discard block |
||
| 136 | 136 | $objWriter->startElement('a:p'); |
| 137 | 137 | |
| 138 | 138 | $caption = $title->getCaption(); |
| 139 | - if ((is_array($caption)) && (count($caption) > 0)) |
|
| 140 | - $caption = $caption[0]; |
|
| 139 | + if ((is_array($caption)) && (count($caption) > 0)) { |
|
| 140 | + $caption = $caption[0]; |
|
| 141 | + } |
|
| 141 | 142 | $this->getParentWriter()->getWriterPart('stringtable')->writeRichTextForCharts($objWriter, $caption, 'a'); |
| 142 | 143 | |
| 143 | 144 | $objWriter->endElement(); |
@@ -435,8 +436,9 @@ discard block |
||
| 435 | 436 | $objWriter->startElement('a:r'); |
| 436 | 437 | |
| 437 | 438 | $caption = $xAxisLabel->getCaption(); |
| 438 | - if (is_array($caption)) |
|
| 439 | - $caption = $caption[0]; |
|
| 439 | + if (is_array($caption)) { |
|
| 440 | + $caption = $caption[0]; |
|
| 441 | + } |
|
| 440 | 442 | $objWriter->startElement('a:t'); |
| 441 | 443 | $objWriter->writeAttribute('xml:space', 'preserve'); |
| 442 | 444 | $objWriter->writeRawData(PHPExcel_Shared_String::ControlCharacterPHP2OOXML( $caption )); |
@@ -561,8 +563,9 @@ discard block |
||
| 561 | 563 | $objWriter->startElement('a:r'); |
| 562 | 564 | |
| 563 | 565 | $caption = $yAxisLabel->getCaption(); |
| 564 | - if (is_array($caption)) |
|
| 565 | - $caption = $caption[0]; |
|
| 566 | + if (is_array($caption)) { |
|
| 567 | + $caption = $caption[0]; |
|
| 568 | + } |
|
| 566 | 569 | $objWriter->startElement('a:t'); |
| 567 | 570 | $objWriter->writeAttribute('xml:space', 'preserve'); |
| 568 | 571 | $objWriter->writeRawData(PHPExcel_Shared_String::ControlCharacterPHP2OOXML( $caption )); |
@@ -53,16 +53,16 @@ discard block |
||
| 53 | 53 | } |
| 54 | 54 | |
| 55 | 55 | // XML header |
| 56 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
| 56 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
| 57 | 57 | |
| 58 | 58 | // Comments cache |
| 59 | - $comments = $pWorksheet->getComments(); |
|
| 59 | + $comments = $pWorksheet->getComments(); |
|
| 60 | 60 | |
| 61 | 61 | // Authors cache |
| 62 | - $authors = array(); |
|
| 63 | - $authorId = 0; |
|
| 62 | + $authors = array(); |
|
| 63 | + $authorId = 0; |
|
| 64 | 64 | foreach ($comments as $comment) { |
| 65 | - if (!isset($authors[$comment->getAuthor()])) { |
|
| 65 | + if ( ! isset($authors[$comment->getAuthor()])) { |
|
| 66 | 66 | $authors[$comment->getAuthor()] = $authorId++; |
| 67 | 67 | } |
| 68 | 68 | } |
@@ -104,8 +104,8 @@ discard block |
||
| 104 | 104 | { |
| 105 | 105 | // comment |
| 106 | 106 | $objWriter->startElement('comment'); |
| 107 | - $objWriter->writeAttribute('ref', $pCellReference); |
|
| 108 | - $objWriter->writeAttribute('authorId', $pAuthors[$pComment->getAuthor()]); |
|
| 107 | + $objWriter->writeAttribute('ref', $pCellReference); |
|
| 108 | + $objWriter->writeAttribute('authorId', $pAuthors[$pComment->getAuthor()]); |
|
| 109 | 109 | |
| 110 | 110 | // text |
| 111 | 111 | $objWriter->startElement('text'); |
@@ -133,10 +133,10 @@ discard block |
||
| 133 | 133 | } |
| 134 | 134 | |
| 135 | 135 | // XML header |
| 136 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
| 136 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
| 137 | 137 | |
| 138 | 138 | // Comments cache |
| 139 | - $comments = $pWorksheet->getComments(); |
|
| 139 | + $comments = $pWorksheet->getComments(); |
|
| 140 | 140 | |
| 141 | 141 | // xml |
| 142 | 142 | $objWriter->startElement('xml'); |
@@ -146,32 +146,32 @@ discard block |
||
| 146 | 146 | |
| 147 | 147 | // o:shapelayout |
| 148 | 148 | $objWriter->startElement('o:shapelayout'); |
| 149 | - $objWriter->writeAttribute('v:ext', 'edit'); |
|
| 149 | + $objWriter->writeAttribute('v:ext', 'edit'); |
|
| 150 | 150 | |
| 151 | 151 | // o:idmap |
| 152 | 152 | $objWriter->startElement('o:idmap'); |
| 153 | - $objWriter->writeAttribute('v:ext', 'edit'); |
|
| 154 | - $objWriter->writeAttribute('data', '1'); |
|
| 153 | + $objWriter->writeAttribute('v:ext', 'edit'); |
|
| 154 | + $objWriter->writeAttribute('data', '1'); |
|
| 155 | 155 | $objWriter->endElement(); |
| 156 | 156 | |
| 157 | 157 | $objWriter->endElement(); |
| 158 | 158 | |
| 159 | 159 | // v:shapetype |
| 160 | 160 | $objWriter->startElement('v:shapetype'); |
| 161 | - $objWriter->writeAttribute('id', '_x0000_t202'); |
|
| 161 | + $objWriter->writeAttribute('id', '_x0000_t202'); |
|
| 162 | 162 | $objWriter->writeAttribute('coordsize', '21600,21600'); |
| 163 | - $objWriter->writeAttribute('o:spt', '202'); |
|
| 164 | - $objWriter->writeAttribute('path', 'm,l,21600r21600,l21600,xe'); |
|
| 163 | + $objWriter->writeAttribute('o:spt', '202'); |
|
| 164 | + $objWriter->writeAttribute('path', 'm,l,21600r21600,l21600,xe'); |
|
| 165 | 165 | |
| 166 | 166 | // v:stroke |
| 167 | 167 | $objWriter->startElement('v:stroke'); |
| 168 | - $objWriter->writeAttribute('joinstyle', 'miter'); |
|
| 168 | + $objWriter->writeAttribute('joinstyle', 'miter'); |
|
| 169 | 169 | $objWriter->endElement(); |
| 170 | 170 | |
| 171 | 171 | // v:path |
| 172 | 172 | $objWriter->startElement('v:path'); |
| 173 | - $objWriter->writeAttribute('gradientshapeok', 't'); |
|
| 174 | - $objWriter->writeAttribute('o:connecttype', 'rect'); |
|
| 173 | + $objWriter->writeAttribute('gradientshapeok', 't'); |
|
| 174 | + $objWriter->writeAttribute('o:connecttype', 'rect'); |
|
| 175 | 175 | $objWriter->endElement(); |
| 176 | 176 | |
| 177 | 177 | $objWriter->endElement(); |
@@ -205,22 +205,22 @@ discard block |
||
| 205 | 205 | |
| 206 | 206 | // v:shape |
| 207 | 207 | $objWriter->startElement('v:shape'); |
| 208 | - $objWriter->writeAttribute('id', '_x0000_s' . $id); |
|
| 209 | - $objWriter->writeAttribute('type', '#_x0000_t202'); |
|
| 210 | - $objWriter->writeAttribute('style', 'position:absolute;margin-left:' . $pComment->getMarginLeft() . ';margin-top:' . $pComment->getMarginTop() . ';width:' . $pComment->getWidth() . ';height:' . $pComment->getHeight() . ';z-index:1;visibility:' . ($pComment->getVisible() ? 'visible' : 'hidden')); |
|
| 211 | - $objWriter->writeAttribute('fillcolor', '#' . $pComment->getFillColor()->getRGB()); |
|
| 212 | - $objWriter->writeAttribute('o:insetmode', 'auto'); |
|
| 208 | + $objWriter->writeAttribute('id', '_x0000_s'.$id); |
|
| 209 | + $objWriter->writeAttribute('type', '#_x0000_t202'); |
|
| 210 | + $objWriter->writeAttribute('style', 'position:absolute;margin-left:'.$pComment->getMarginLeft().';margin-top:'.$pComment->getMarginTop().';width:'.$pComment->getWidth().';height:'.$pComment->getHeight().';z-index:1;visibility:'.($pComment->getVisible() ? 'visible' : 'hidden')); |
|
| 211 | + $objWriter->writeAttribute('fillcolor', '#'.$pComment->getFillColor()->getRGB()); |
|
| 212 | + $objWriter->writeAttribute('o:insetmode', 'auto'); |
|
| 213 | 213 | |
| 214 | 214 | // v:fill |
| 215 | 215 | $objWriter->startElement('v:fill'); |
| 216 | - $objWriter->writeAttribute('color2', '#' . $pComment->getFillColor()->getRGB()); |
|
| 216 | + $objWriter->writeAttribute('color2', '#'.$pComment->getFillColor()->getRGB()); |
|
| 217 | 217 | $objWriter->endElement(); |
| 218 | 218 | |
| 219 | 219 | // v:shadow |
| 220 | 220 | $objWriter->startElement('v:shadow'); |
| 221 | - $objWriter->writeAttribute('on', 't'); |
|
| 222 | - $objWriter->writeAttribute('color', 'black'); |
|
| 223 | - $objWriter->writeAttribute('obscured', 't'); |
|
| 221 | + $objWriter->writeAttribute('on', 't'); |
|
| 222 | + $objWriter->writeAttribute('color', 'black'); |
|
| 223 | + $objWriter->writeAttribute('obscured', 't'); |
|
| 224 | 224 | $objWriter->endElement(); |
| 225 | 225 | |
| 226 | 226 | // v:path |
@@ -54,7 +54,7 @@ discard block |
||
| 54 | 54 | } |
| 55 | 55 | |
| 56 | 56 | // XML header |
| 57 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
| 57 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
| 58 | 58 | |
| 59 | 59 | // Types |
| 60 | 60 | $objWriter->startElement('Types'); |
@@ -100,7 +100,7 @@ discard block |
||
| 100 | 100 | ); |
| 101 | 101 | |
| 102 | 102 | $customPropertyList = $pPHPExcel->getProperties()->getCustomProperties(); |
| 103 | - if (!empty($customPropertyList)) { |
|
| 103 | + if ( ! empty($customPropertyList)) { |
|
| 104 | 104 | $this->_writeOverrideContentType( |
| 105 | 105 | $objWriter, '/docProps/custom.xml', 'application/vnd.openxmlformats-officedocument.custom-properties+xml' |
| 106 | 106 | ); |
@@ -110,7 +110,7 @@ discard block |
||
| 110 | 110 | $sheetCount = $pPHPExcel->getSheetCount(); |
| 111 | 111 | for ($i = 0; $i < $sheetCount; ++$i) { |
| 112 | 112 | $this->_writeOverrideContentType( |
| 113 | - $objWriter, '/xl/worksheets/sheet' . ($i + 1) . '.xml', 'application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml' |
|
| 113 | + $objWriter, '/xl/worksheets/sheet'.($i + 1).'.xml', 'application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml' |
|
| 114 | 114 | ); |
| 115 | 115 | } |
| 116 | 116 | |
@@ -129,7 +129,7 @@ discard block |
||
| 129 | 129 | // We need a drawing relationship for the worksheet if we have either drawings or charts |
| 130 | 130 | if (($drawingCount > 0) || ($chartCount > 0)) { |
| 131 | 131 | $this->_writeOverrideContentType( |
| 132 | - $objWriter, '/xl/drawings/drawing' . ($i + 1) . '.xml', 'application/vnd.openxmlformats-officedocument.drawing+xml' |
|
| 132 | + $objWriter, '/xl/drawings/drawing'.($i + 1).'.xml', 'application/vnd.openxmlformats-officedocument.drawing+xml' |
|
| 133 | 133 | ); |
| 134 | 134 | } |
| 135 | 135 | |
@@ -137,7 +137,7 @@ discard block |
||
| 137 | 137 | if ($chartCount > 0) { |
| 138 | 138 | for ($c = 0; $c < $chartCount; ++$c) { |
| 139 | 139 | $this->_writeOverrideContentType( |
| 140 | - $objWriter, '/xl/charts/chart' . $chart++ . '.xml', 'application/vnd.openxmlformats-officedocument.drawingml.chart+xml' |
|
| 140 | + $objWriter, '/xl/charts/chart'.$chart++.'.xml', 'application/vnd.openxmlformats-officedocument.drawingml.chart+xml' |
|
| 141 | 141 | ); |
| 142 | 142 | } |
| 143 | 143 | } |
@@ -147,7 +147,7 @@ discard block |
||
| 147 | 147 | for ($i = 0; $i < $sheetCount; ++$i) { |
| 148 | 148 | if (count($pPHPExcel->getSheet($i)->getComments()) > 0) { |
| 149 | 149 | $this->_writeOverrideContentType( |
| 150 | - $objWriter, '/xl/comments' . ($i + 1) . '.xml', 'application/vnd.openxmlformats-officedocument.spreadsheetml.comments+xml' |
|
| 150 | + $objWriter, '/xl/comments'.($i + 1).'.xml', 'application/vnd.openxmlformats-officedocument.spreadsheetml.comments+xml' |
|
| 151 | 151 | ); |
| 152 | 152 | } |
| 153 | 153 | } |
@@ -156,21 +156,21 @@ discard block |
||
| 156 | 156 | $aMediaContentTypes = array(); |
| 157 | 157 | $mediaCount = $this->getParentWriter()->getDrawingHashTable()->count(); |
| 158 | 158 | for ($i = 0; $i < $mediaCount; ++$i) { |
| 159 | - $extension = ''; |
|
| 159 | + $extension = ''; |
|
| 160 | 160 | $mimeType = ''; |
| 161 | 161 | |
| 162 | 162 | if ($this->getParentWriter()->getDrawingHashTable()->getByIndex($i) instanceof PHPExcel_Worksheet_Drawing) { |
| 163 | 163 | $extension = strtolower($this->getParentWriter()->getDrawingHashTable()->getByIndex($i)->getExtension()); |
| 164 | - $mimeType = $this->_getImageMimeType( $this->getParentWriter()->getDrawingHashTable()->getByIndex($i)->getPath() ); |
|
| 164 | + $mimeType = $this->_getImageMimeType($this->getParentWriter()->getDrawingHashTable()->getByIndex($i)->getPath()); |
|
| 165 | 165 | } else if ($this->getParentWriter()->getDrawingHashTable()->getByIndex($i) instanceof PHPExcel_Worksheet_MemoryDrawing) { |
| 166 | 166 | $extension = strtolower($this->getParentWriter()->getDrawingHashTable()->getByIndex($i)->getMimeType()); |
| 167 | 167 | $extension = explode('/', $extension); |
| 168 | 168 | $extension = $extension[1]; |
| 169 | 169 | |
| 170 | - $mimeType = $this->getParentWriter()->getDrawingHashTable()->getByIndex($i)->getMimeType(); |
|
| 170 | + $mimeType = $this->getParentWriter()->getDrawingHashTable()->getByIndex($i)->getMimeType(); |
|
| 171 | 171 | } |
| 172 | 172 | |
| 173 | - if (!isset( $aMediaContentTypes[$extension]) ) { |
|
| 173 | + if ( ! isset($aMediaContentTypes[$extension])) { |
|
| 174 | 174 | $aMediaContentTypes[$extension] = $mimeType; |
| 175 | 175 | |
| 176 | 176 | $this->_writeDefaultContentType( |
@@ -183,8 +183,8 @@ discard block |
||
| 183 | 183 | for ($i = 0; $i < $sheetCount; ++$i) { |
| 184 | 184 | if (count($pPHPExcel->getSheet()->getHeaderFooter()->getImages()) > 0) { |
| 185 | 185 | foreach ($pPHPExcel->getSheet()->getHeaderFooter()->getImages() as $image) { |
| 186 | - if (!isset( $aMediaContentTypes[strtolower($image->getExtension())]) ) { |
|
| 187 | - $aMediaContentTypes[strtolower($image->getExtension())] = $this->_getImageMimeType( $image->getPath() ); |
|
| 186 | + if ( ! isset($aMediaContentTypes[strtolower($image->getExtension())])) { |
|
| 187 | + $aMediaContentTypes[strtolower($image->getExtension())] = $this->_getImageMimeType($image->getPath()); |
|
| 188 | 188 | |
| 189 | 189 | $this->_writeDefaultContentType( |
| 190 | 190 | $objWriter, strtolower($image->getExtension()), $aMediaContentTypes[strtolower($image->getExtension())] |
@@ -230,8 +230,8 @@ discard block |
||
| 230 | 230 | if ($pPartname != '' && $pContentType != '') { |
| 231 | 231 | // Write content type |
| 232 | 232 | $objWriter->startElement('Default'); |
| 233 | - $objWriter->writeAttribute('Extension', $pPartname); |
|
| 234 | - $objWriter->writeAttribute('ContentType', $pContentType); |
|
| 233 | + $objWriter->writeAttribute('Extension', $pPartname); |
|
| 234 | + $objWriter->writeAttribute('ContentType', $pContentType); |
|
| 235 | 235 | $objWriter->endElement(); |
| 236 | 236 | } else { |
| 237 | 237 | throw new Exception("Invalid parameters passed."); |
@@ -251,8 +251,8 @@ discard block |
||
| 251 | 251 | if ($pPartname != '' && $pContentType != '') { |
| 252 | 252 | // Write content type |
| 253 | 253 | $objWriter->startElement('Override'); |
| 254 | - $objWriter->writeAttribute('PartName', $pPartname); |
|
| 255 | - $objWriter->writeAttribute('ContentType', $pContentType); |
|
| 254 | + $objWriter->writeAttribute('PartName', $pPartname); |
|
| 255 | + $objWriter->writeAttribute('ContentType', $pContentType); |
|
| 256 | 256 | $objWriter->endElement(); |
| 257 | 257 | } else { |
| 258 | 258 | throw new Exception("Invalid parameters passed."); |
@@ -53,7 +53,7 @@ discard block |
||
| 53 | 53 | } |
| 54 | 54 | |
| 55 | 55 | // XML header |
| 56 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
| 56 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
| 57 | 57 | |
| 58 | 58 | // Properties |
| 59 | 59 | $objWriter->startElement('Properties'); |
@@ -61,30 +61,30 @@ discard block |
||
| 61 | 61 | $objWriter->writeAttribute('xmlns:vt', 'http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes'); |
| 62 | 62 | |
| 63 | 63 | // Application |
| 64 | - $objWriter->writeElement('Application', 'Microsoft Excel'); |
|
| 64 | + $objWriter->writeElement('Application', 'Microsoft Excel'); |
|
| 65 | 65 | |
| 66 | 66 | // DocSecurity |
| 67 | - $objWriter->writeElement('DocSecurity', '0'); |
|
| 67 | + $objWriter->writeElement('DocSecurity', '0'); |
|
| 68 | 68 | |
| 69 | 69 | // ScaleCrop |
| 70 | - $objWriter->writeElement('ScaleCrop', 'false'); |
|
| 70 | + $objWriter->writeElement('ScaleCrop', 'false'); |
|
| 71 | 71 | |
| 72 | 72 | // HeadingPairs |
| 73 | 73 | $objWriter->startElement('HeadingPairs'); |
| 74 | 74 | |
| 75 | 75 | // Vector |
| 76 | 76 | $objWriter->startElement('vt:vector'); |
| 77 | - $objWriter->writeAttribute('size', '2'); |
|
| 78 | - $objWriter->writeAttribute('baseType', 'variant'); |
|
| 77 | + $objWriter->writeAttribute('size', '2'); |
|
| 78 | + $objWriter->writeAttribute('baseType', 'variant'); |
|
| 79 | 79 | |
| 80 | 80 | // Variant |
| 81 | 81 | $objWriter->startElement('vt:variant'); |
| 82 | - $objWriter->writeElement('vt:lpstr', 'Worksheets'); |
|
| 82 | + $objWriter->writeElement('vt:lpstr', 'Worksheets'); |
|
| 83 | 83 | $objWriter->endElement(); |
| 84 | 84 | |
| 85 | 85 | // Variant |
| 86 | 86 | $objWriter->startElement('vt:variant'); |
| 87 | - $objWriter->writeElement('vt:i4', $pPHPExcel->getSheetCount()); |
|
| 87 | + $objWriter->writeElement('vt:i4', $pPHPExcel->getSheetCount()); |
|
| 88 | 88 | $objWriter->endElement(); |
| 89 | 89 | |
| 90 | 90 | $objWriter->endElement(); |
@@ -96,8 +96,8 @@ discard block |
||
| 96 | 96 | |
| 97 | 97 | // Vector |
| 98 | 98 | $objWriter->startElement('vt:vector'); |
| 99 | - $objWriter->writeAttribute('size', $pPHPExcel->getSheetCount()); |
|
| 100 | - $objWriter->writeAttribute('baseType', 'lpstr'); |
|
| 99 | + $objWriter->writeAttribute('size', $pPHPExcel->getSheetCount()); |
|
| 100 | + $objWriter->writeAttribute('baseType', 'lpstr'); |
|
| 101 | 101 | |
| 102 | 102 | $sheetCount = $pPHPExcel->getSheetCount(); |
| 103 | 103 | for ($i = 0; $i < $sheetCount; ++$i) { |
@@ -109,22 +109,22 @@ discard block |
||
| 109 | 109 | $objWriter->endElement(); |
| 110 | 110 | |
| 111 | 111 | // Company |
| 112 | - $objWriter->writeElement('Company', $pPHPExcel->getProperties()->getCompany()); |
|
| 112 | + $objWriter->writeElement('Company', $pPHPExcel->getProperties()->getCompany()); |
|
| 113 | 113 | |
| 114 | 114 | // Company |
| 115 | - $objWriter->writeElement('Manager', $pPHPExcel->getProperties()->getManager()); |
|
| 115 | + $objWriter->writeElement('Manager', $pPHPExcel->getProperties()->getManager()); |
|
| 116 | 116 | |
| 117 | 117 | // LinksUpToDate |
| 118 | - $objWriter->writeElement('LinksUpToDate', 'false'); |
|
| 118 | + $objWriter->writeElement('LinksUpToDate', 'false'); |
|
| 119 | 119 | |
| 120 | 120 | // SharedDoc |
| 121 | - $objWriter->writeElement('SharedDoc', 'false'); |
|
| 121 | + $objWriter->writeElement('SharedDoc', 'false'); |
|
| 122 | 122 | |
| 123 | 123 | // HyperlinksChanged |
| 124 | - $objWriter->writeElement('HyperlinksChanged', 'false'); |
|
| 124 | + $objWriter->writeElement('HyperlinksChanged', 'false'); |
|
| 125 | 125 | |
| 126 | 126 | // AppVersion |
| 127 | - $objWriter->writeElement('AppVersion', '12.0000'); |
|
| 127 | + $objWriter->writeElement('AppVersion', '12.0000'); |
|
| 128 | 128 | |
| 129 | 129 | $objWriter->endElement(); |
| 130 | 130 | |
@@ -150,7 +150,7 @@ discard block |
||
| 150 | 150 | } |
| 151 | 151 | |
| 152 | 152 | // XML header |
| 153 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
| 153 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
| 154 | 154 | |
| 155 | 155 | // cp:coreProperties |
| 156 | 156 | $objWriter->startElement('cp:coreProperties'); |
@@ -161,37 +161,37 @@ discard block |
||
| 161 | 161 | $objWriter->writeAttribute('xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance'); |
| 162 | 162 | |
| 163 | 163 | // dc:creator |
| 164 | - $objWriter->writeElement('dc:creator', $pPHPExcel->getProperties()->getCreator()); |
|
| 164 | + $objWriter->writeElement('dc:creator', $pPHPExcel->getProperties()->getCreator()); |
|
| 165 | 165 | |
| 166 | 166 | // cp:lastModifiedBy |
| 167 | - $objWriter->writeElement('cp:lastModifiedBy', $pPHPExcel->getProperties()->getLastModifiedBy()); |
|
| 167 | + $objWriter->writeElement('cp:lastModifiedBy', $pPHPExcel->getProperties()->getLastModifiedBy()); |
|
| 168 | 168 | |
| 169 | 169 | // dcterms:created |
| 170 | 170 | $objWriter->startElement('dcterms:created'); |
| 171 | 171 | $objWriter->writeAttribute('xsi:type', 'dcterms:W3CDTF'); |
| 172 | - $objWriter->writeRawData(date(DATE_W3C, $pPHPExcel->getProperties()->getCreated())); |
|
| 172 | + $objWriter->writeRawData(date(DATE_W3C, $pPHPExcel->getProperties()->getCreated())); |
|
| 173 | 173 | $objWriter->endElement(); |
| 174 | 174 | |
| 175 | 175 | // dcterms:modified |
| 176 | 176 | $objWriter->startElement('dcterms:modified'); |
| 177 | 177 | $objWriter->writeAttribute('xsi:type', 'dcterms:W3CDTF'); |
| 178 | - $objWriter->writeRawData(date(DATE_W3C, $pPHPExcel->getProperties()->getModified())); |
|
| 178 | + $objWriter->writeRawData(date(DATE_W3C, $pPHPExcel->getProperties()->getModified())); |
|
| 179 | 179 | $objWriter->endElement(); |
| 180 | 180 | |
| 181 | 181 | // dc:title |
| 182 | - $objWriter->writeElement('dc:title', $pPHPExcel->getProperties()->getTitle()); |
|
| 182 | + $objWriter->writeElement('dc:title', $pPHPExcel->getProperties()->getTitle()); |
|
| 183 | 183 | |
| 184 | 184 | // dc:description |
| 185 | - $objWriter->writeElement('dc:description', $pPHPExcel->getProperties()->getDescription()); |
|
| 185 | + $objWriter->writeElement('dc:description', $pPHPExcel->getProperties()->getDescription()); |
|
| 186 | 186 | |
| 187 | 187 | // dc:subject |
| 188 | - $objWriter->writeElement('dc:subject', $pPHPExcel->getProperties()->getSubject()); |
|
| 188 | + $objWriter->writeElement('dc:subject', $pPHPExcel->getProperties()->getSubject()); |
|
| 189 | 189 | |
| 190 | 190 | // cp:keywords |
| 191 | - $objWriter->writeElement('cp:keywords', $pPHPExcel->getProperties()->getKeywords()); |
|
| 191 | + $objWriter->writeElement('cp:keywords', $pPHPExcel->getProperties()->getKeywords()); |
|
| 192 | 192 | |
| 193 | 193 | // cp:category |
| 194 | - $objWriter->writeElement('cp:category', $pPHPExcel->getProperties()->getCategory()); |
|
| 194 | + $objWriter->writeElement('cp:category', $pPHPExcel->getProperties()->getCategory()); |
|
| 195 | 195 | |
| 196 | 196 | $objWriter->endElement(); |
| 197 | 197 | |
@@ -222,7 +222,7 @@ discard block |
||
| 222 | 222 | } |
| 223 | 223 | |
| 224 | 224 | // XML header |
| 225 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
| 225 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
| 226 | 226 | |
| 227 | 227 | // cp:coreProperties |
| 228 | 228 | $objWriter->startElement('Properties'); |
@@ -230,24 +230,24 @@ discard block |
||
| 230 | 230 | $objWriter->writeAttribute('xmlns:vt', 'http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes'); |
| 231 | 231 | |
| 232 | 232 | |
| 233 | - foreach($customPropertyList as $key => $customProperty) { |
|
| 233 | + foreach ($customPropertyList as $key => $customProperty) { |
|
| 234 | 234 | $propertyValue = $pPHPExcel->getProperties()->getCustomPropertyValue($customProperty); |
| 235 | 235 | $propertyType = $pPHPExcel->getProperties()->getCustomPropertyType($customProperty); |
| 236 | 236 | |
| 237 | 237 | $objWriter->startElement('property'); |
| 238 | - $objWriter->writeAttribute('fmtid', '{D5CDD505-2E9C-101B-9397-08002B2CF9AE}'); |
|
| 239 | - $objWriter->writeAttribute('pid', $key+2); |
|
| 240 | - $objWriter->writeAttribute('name', $customProperty); |
|
| 238 | + $objWriter->writeAttribute('fmtid', '{D5CDD505-2E9C-101B-9397-08002B2CF9AE}'); |
|
| 239 | + $objWriter->writeAttribute('pid', $key + 2); |
|
| 240 | + $objWriter->writeAttribute('name', $customProperty); |
|
| 241 | 241 | |
| 242 | - switch($propertyType) { |
|
| 242 | + switch ($propertyType) { |
|
| 243 | 243 | case 'i' : |
| 244 | - $objWriter->writeElement('vt:i4', $propertyValue); |
|
| 244 | + $objWriter->writeElement('vt:i4', $propertyValue); |
|
| 245 | 245 | break; |
| 246 | 246 | case 'f' : |
| 247 | - $objWriter->writeElement('vt:r8', $propertyValue); |
|
| 247 | + $objWriter->writeElement('vt:r8', $propertyValue); |
|
| 248 | 248 | break; |
| 249 | 249 | case 'b' : |
| 250 | - $objWriter->writeElement('vt:bool', ($propertyValue) ? 'true' : 'false'); |
|
| 250 | + $objWriter->writeElement('vt:bool', ($propertyValue) ? 'true' : 'false'); |
|
| 251 | 251 | break; |
| 252 | 252 | case 'd' : |
| 253 | 253 | $objWriter->startElement('vt:filetime'); |
@@ -255,7 +255,7 @@ discard block |
||
| 255 | 255 | $objWriter->endElement(); |
| 256 | 256 | break; |
| 257 | 257 | default : |
| 258 | - $objWriter->writeElement('vt:lpwstr', $propertyValue); |
|
| 258 | + $objWriter->writeElement('vt:lpwstr', $propertyValue); |
|
| 259 | 259 | break; |
| 260 | 260 | } |
| 261 | 261 | |
@@ -36,12 +36,12 @@ |
||
| 36 | 36 | class PHPExcel_Writer_Excel2007_DocProps extends PHPExcel_Writer_Excel2007_WriterPart |
| 37 | 37 | { |
| 38 | 38 | /** |
| 39 | - * Write docProps/app.xml to XML format |
|
| 40 | - * |
|
| 41 | - * @param PHPExcel $pPHPExcel |
|
| 42 | - * @return string XML Output |
|
| 43 | - * @throws Exception |
|
| 44 | - */ |
|
| 39 | + * Write docProps/app.xml to XML format |
|
| 40 | + * |
|
| 41 | + * @param PHPExcel $pPHPExcel |
|
| 42 | + * @return string XML Output |
|
| 43 | + * @throws Exception |
|
| 44 | + */ |
|
| 45 | 45 | public function writeDocPropsApp(PHPExcel $pPHPExcel = null) |
| 46 | 46 | { |
| 47 | 47 | // Create XML writer |
@@ -55,7 +55,7 @@ discard block |
||
| 55 | 55 | } |
| 56 | 56 | |
| 57 | 57 | // XML header |
| 58 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
| 58 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
| 59 | 59 | |
| 60 | 60 | // xdr:wsDr |
| 61 | 61 | $objWriter->startElement('xdr:wsDr'); |
@@ -77,7 +77,7 @@ discard block |
||
| 77 | 77 | // Loop through charts and write the chart position |
| 78 | 78 | if ($chartCount > 0) { |
| 79 | 79 | for ($c = 0; $c < $chartCount; ++$c) { |
| 80 | - $this->_writeChart($objWriter, $pWorksheet->getChartByIndex($c), $c+$i); |
|
| 80 | + $this->_writeChart($objWriter, $pWorksheet->getChartByIndex($c), $c + $i); |
|
| 81 | 81 | } |
| 82 | 82 | } |
| 83 | 83 | } |
@@ -175,8 +175,8 @@ discard block |
||
| 175 | 175 | // xdr:oneCellAnchor |
| 176 | 176 | $objWriter->startElement('xdr:oneCellAnchor'); |
| 177 | 177 | // Image location |
| 178 | - $aCoordinates = PHPExcel_Cell::coordinateFromString($pDrawing->getCoordinates()); |
|
| 179 | - $aCoordinates[0] = PHPExcel_Cell::columnIndexFromString($aCoordinates[0]); |
|
| 178 | + $aCoordinates = PHPExcel_Cell::coordinateFromString($pDrawing->getCoordinates()); |
|
| 179 | + $aCoordinates[0] = PHPExcel_Cell::columnIndexFromString($aCoordinates[0]); |
|
| 180 | 180 | |
| 181 | 181 | // xdr:from |
| 182 | 182 | $objWriter->startElement('xdr:from'); |
@@ -223,7 +223,7 @@ discard block |
||
| 223 | 223 | // a:blip |
| 224 | 224 | $objWriter->startElement('a:blip'); |
| 225 | 225 | $objWriter->writeAttribute('xmlns:r', 'http://schemas.openxmlformats.org/officeDocument/2006/relationships'); |
| 226 | - $objWriter->writeAttribute('r:embed', 'rId' . $pRelationId); |
|
| 226 | + $objWriter->writeAttribute('r:embed', 'rId'.$pRelationId); |
|
| 227 | 227 | $objWriter->endElement(); |
| 228 | 228 | |
| 229 | 229 | // a:stretch |
@@ -297,19 +297,19 @@ discard block |
||
| 297 | 297 | |
| 298 | 298 | // a:outerShdw |
| 299 | 299 | $objWriter->startElement('a:outerShdw'); |
| 300 | - $objWriter->writeAttribute('blurRad', PHPExcel_Shared_Drawing::pixelsToEMU($pDrawing->getShadow()->getBlurRadius())); |
|
| 301 | - $objWriter->writeAttribute('dist', PHPExcel_Shared_Drawing::pixelsToEMU($pDrawing->getShadow()->getDistance())); |
|
| 302 | - $objWriter->writeAttribute('dir', PHPExcel_Shared_Drawing::degreesToAngle($pDrawing->getShadow()->getDirection())); |
|
| 303 | - $objWriter->writeAttribute('algn', $pDrawing->getShadow()->getAlignment()); |
|
| 304 | - $objWriter->writeAttribute('rotWithShape', '0'); |
|
| 300 | + $objWriter->writeAttribute('blurRad', PHPExcel_Shared_Drawing::pixelsToEMU($pDrawing->getShadow()->getBlurRadius())); |
|
| 301 | + $objWriter->writeAttribute('dist', PHPExcel_Shared_Drawing::pixelsToEMU($pDrawing->getShadow()->getDistance())); |
|
| 302 | + $objWriter->writeAttribute('dir', PHPExcel_Shared_Drawing::degreesToAngle($pDrawing->getShadow()->getDirection())); |
|
| 303 | + $objWriter->writeAttribute('algn', $pDrawing->getShadow()->getAlignment()); |
|
| 304 | + $objWriter->writeAttribute('rotWithShape', '0'); |
|
| 305 | 305 | |
| 306 | 306 | // a:srgbClr |
| 307 | 307 | $objWriter->startElement('a:srgbClr'); |
| 308 | - $objWriter->writeAttribute('val', $pDrawing->getShadow()->getColor()->getRGB()); |
|
| 308 | + $objWriter->writeAttribute('val', $pDrawing->getShadow()->getColor()->getRGB()); |
|
| 309 | 309 | |
| 310 | 310 | // a:alpha |
| 311 | 311 | $objWriter->startElement('a:alpha'); |
| 312 | - $objWriter->writeAttribute('val', $pDrawing->getShadow()->getAlpha() * 1000); |
|
| 312 | + $objWriter->writeAttribute('val', $pDrawing->getShadow()->getAlpha() * 1000); |
|
| 313 | 313 | $objWriter->endElement(); |
| 314 | 314 | |
| 315 | 315 | $objWriter->endElement(); |
@@ -397,7 +397,7 @@ discard block |
||
| 397 | 397 | } |
| 398 | 398 | |
| 399 | 399 | // XML header |
| 400 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
| 400 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
| 401 | 401 | |
| 402 | 402 | // Header/footer images |
| 403 | 403 | $images = $pWorksheet->getHeaderFooter()->getImages(); |
@@ -410,29 +410,29 @@ discard block |
||
| 410 | 410 | |
| 411 | 411 | // o:shapelayout |
| 412 | 412 | $objWriter->startElement('o:shapelayout'); |
| 413 | - $objWriter->writeAttribute('v:ext', 'edit'); |
|
| 413 | + $objWriter->writeAttribute('v:ext', 'edit'); |
|
| 414 | 414 | |
| 415 | 415 | // o:idmap |
| 416 | 416 | $objWriter->startElement('o:idmap'); |
| 417 | - $objWriter->writeAttribute('v:ext', 'edit'); |
|
| 418 | - $objWriter->writeAttribute('data', '1'); |
|
| 417 | + $objWriter->writeAttribute('v:ext', 'edit'); |
|
| 418 | + $objWriter->writeAttribute('data', '1'); |
|
| 419 | 419 | $objWriter->endElement(); |
| 420 | 420 | |
| 421 | 421 | $objWriter->endElement(); |
| 422 | 422 | |
| 423 | 423 | // v:shapetype |
| 424 | 424 | $objWriter->startElement('v:shapetype'); |
| 425 | - $objWriter->writeAttribute('id', '_x0000_t75'); |
|
| 426 | - $objWriter->writeAttribute('coordsize', '21600,21600'); |
|
| 427 | - $objWriter->writeAttribute('o:spt', '75'); |
|
| 428 | - $objWriter->writeAttribute('o:preferrelative', 't'); |
|
| 429 | - $objWriter->writeAttribute('path', 'm@4@5l@4@11@9@11@9@5xe'); |
|
| 430 | - $objWriter->writeAttribute('filled', 'f'); |
|
| 431 | - $objWriter->writeAttribute('stroked', 'f'); |
|
| 425 | + $objWriter->writeAttribute('id', '_x0000_t75'); |
|
| 426 | + $objWriter->writeAttribute('coordsize', '21600,21600'); |
|
| 427 | + $objWriter->writeAttribute('o:spt', '75'); |
|
| 428 | + $objWriter->writeAttribute('o:preferrelative', 't'); |
|
| 429 | + $objWriter->writeAttribute('path', 'm@4@5l@4@11@9@11@9@5xe'); |
|
| 430 | + $objWriter->writeAttribute('filled', 'f'); |
|
| 431 | + $objWriter->writeAttribute('stroked', 'f'); |
|
| 432 | 432 | |
| 433 | 433 | // v:stroke |
| 434 | 434 | $objWriter->startElement('v:stroke'); |
| 435 | - $objWriter->writeAttribute('joinstyle', 'miter'); |
|
| 435 | + $objWriter->writeAttribute('joinstyle', 'miter'); |
|
| 436 | 436 | $objWriter->endElement(); |
| 437 | 437 | |
| 438 | 438 | // v:formulas |
@@ -440,77 +440,77 @@ discard block |
||
| 440 | 440 | |
| 441 | 441 | // v:f |
| 442 | 442 | $objWriter->startElement('v:f'); |
| 443 | - $objWriter->writeAttribute('eqn', 'if lineDrawn pixelLineWidth 0'); |
|
| 443 | + $objWriter->writeAttribute('eqn', 'if lineDrawn pixelLineWidth 0'); |
|
| 444 | 444 | $objWriter->endElement(); |
| 445 | 445 | |
| 446 | 446 | // v:f |
| 447 | 447 | $objWriter->startElement('v:f'); |
| 448 | - $objWriter->writeAttribute('eqn', 'sum @0 1 0'); |
|
| 448 | + $objWriter->writeAttribute('eqn', 'sum @0 1 0'); |
|
| 449 | 449 | $objWriter->endElement(); |
| 450 | 450 | |
| 451 | 451 | // v:f |
| 452 | 452 | $objWriter->startElement('v:f'); |
| 453 | - $objWriter->writeAttribute('eqn', 'sum 0 0 @1'); |
|
| 453 | + $objWriter->writeAttribute('eqn', 'sum 0 0 @1'); |
|
| 454 | 454 | $objWriter->endElement(); |
| 455 | 455 | |
| 456 | 456 | // v:f |
| 457 | 457 | $objWriter->startElement('v:f'); |
| 458 | - $objWriter->writeAttribute('eqn', 'prod @2 1 2'); |
|
| 458 | + $objWriter->writeAttribute('eqn', 'prod @2 1 2'); |
|
| 459 | 459 | $objWriter->endElement(); |
| 460 | 460 | |
| 461 | 461 | // v:f |
| 462 | 462 | $objWriter->startElement('v:f'); |
| 463 | - $objWriter->writeAttribute('eqn', 'prod @3 21600 pixelWidth'); |
|
| 463 | + $objWriter->writeAttribute('eqn', 'prod @3 21600 pixelWidth'); |
|
| 464 | 464 | $objWriter->endElement(); |
| 465 | 465 | |
| 466 | 466 | // v:f |
| 467 | 467 | $objWriter->startElement('v:f'); |
| 468 | - $objWriter->writeAttribute('eqn', 'prod @3 21600 pixelHeight'); |
|
| 468 | + $objWriter->writeAttribute('eqn', 'prod @3 21600 pixelHeight'); |
|
| 469 | 469 | $objWriter->endElement(); |
| 470 | 470 | |
| 471 | 471 | // v:f |
| 472 | 472 | $objWriter->startElement('v:f'); |
| 473 | - $objWriter->writeAttribute('eqn', 'sum @0 0 1'); |
|
| 473 | + $objWriter->writeAttribute('eqn', 'sum @0 0 1'); |
|
| 474 | 474 | $objWriter->endElement(); |
| 475 | 475 | |
| 476 | 476 | // v:f |
| 477 | 477 | $objWriter->startElement('v:f'); |
| 478 | - $objWriter->writeAttribute('eqn', 'prod @6 1 2'); |
|
| 478 | + $objWriter->writeAttribute('eqn', 'prod @6 1 2'); |
|
| 479 | 479 | $objWriter->endElement(); |
| 480 | 480 | |
| 481 | 481 | // v:f |
| 482 | 482 | $objWriter->startElement('v:f'); |
| 483 | - $objWriter->writeAttribute('eqn', 'prod @7 21600 pixelWidth'); |
|
| 483 | + $objWriter->writeAttribute('eqn', 'prod @7 21600 pixelWidth'); |
|
| 484 | 484 | $objWriter->endElement(); |
| 485 | 485 | |
| 486 | 486 | // v:f |
| 487 | 487 | $objWriter->startElement('v:f'); |
| 488 | - $objWriter->writeAttribute('eqn', 'sum @8 21600 0'); |
|
| 488 | + $objWriter->writeAttribute('eqn', 'sum @8 21600 0'); |
|
| 489 | 489 | $objWriter->endElement(); |
| 490 | 490 | |
| 491 | 491 | // v:f |
| 492 | 492 | $objWriter->startElement('v:f'); |
| 493 | - $objWriter->writeAttribute('eqn', 'prod @7 21600 pixelHeight'); |
|
| 493 | + $objWriter->writeAttribute('eqn', 'prod @7 21600 pixelHeight'); |
|
| 494 | 494 | $objWriter->endElement(); |
| 495 | 495 | |
| 496 | 496 | // v:f |
| 497 | 497 | $objWriter->startElement('v:f'); |
| 498 | - $objWriter->writeAttribute('eqn', 'sum @10 21600 0'); |
|
| 498 | + $objWriter->writeAttribute('eqn', 'sum @10 21600 0'); |
|
| 499 | 499 | $objWriter->endElement(); |
| 500 | 500 | |
| 501 | 501 | $objWriter->endElement(); |
| 502 | 502 | |
| 503 | 503 | // v:path |
| 504 | 504 | $objWriter->startElement('v:path'); |
| 505 | - $objWriter->writeAttribute('o:extrusionok', 'f'); |
|
| 506 | - $objWriter->writeAttribute('gradientshapeok', 't'); |
|
| 507 | - $objWriter->writeAttribute('o:connecttype', 'rect'); |
|
| 505 | + $objWriter->writeAttribute('o:extrusionok', 'f'); |
|
| 506 | + $objWriter->writeAttribute('gradientshapeok', 't'); |
|
| 507 | + $objWriter->writeAttribute('o:connecttype', 'rect'); |
|
| 508 | 508 | $objWriter->endElement(); |
| 509 | 509 | |
| 510 | 510 | // o:lock |
| 511 | 511 | $objWriter->startElement('o:lock'); |
| 512 | - $objWriter->writeAttribute('v:ext', 'edit'); |
|
| 513 | - $objWriter->writeAttribute('aspectratio', 't'); |
|
| 512 | + $objWriter->writeAttribute('v:ext', 'edit'); |
|
| 513 | + $objWriter->writeAttribute('aspectratio', 't'); |
|
| 514 | 514 | $objWriter->endElement(); |
| 515 | 515 | |
| 516 | 516 | $objWriter->endElement(); |
@@ -548,21 +548,21 @@ discard block |
||
| 548 | 548 | |
| 549 | 549 | // v:shape |
| 550 | 550 | $objWriter->startElement('v:shape'); |
| 551 | - $objWriter->writeAttribute('id', $pReference); |
|
| 552 | - $objWriter->writeAttribute('o:spid', '_x0000_s' . $id); |
|
| 553 | - $objWriter->writeAttribute('type', '#_x0000_t75'); |
|
| 554 | - $objWriter->writeAttribute('style', "position:absolute;margin-left:{$marginLeft}px;margin-top:{$marginTop}px;width:{$width}px;height:{$height}px;z-index:1"); |
|
| 551 | + $objWriter->writeAttribute('id', $pReference); |
|
| 552 | + $objWriter->writeAttribute('o:spid', '_x0000_s'.$id); |
|
| 553 | + $objWriter->writeAttribute('type', '#_x0000_t75'); |
|
| 554 | + $objWriter->writeAttribute('style', "position:absolute;margin-left:{$marginLeft}px;margin-top:{$marginTop}px;width:{$width}px;height:{$height}px;z-index:1"); |
|
| 555 | 555 | |
| 556 | 556 | // v:imagedata |
| 557 | 557 | $objWriter->startElement('v:imagedata'); |
| 558 | - $objWriter->writeAttribute('o:relid', 'rId' . $pReference); |
|
| 559 | - $objWriter->writeAttribute('o:title', $pImage->getName()); |
|
| 558 | + $objWriter->writeAttribute('o:relid', 'rId'.$pReference); |
|
| 559 | + $objWriter->writeAttribute('o:title', $pImage->getName()); |
|
| 560 | 560 | $objWriter->endElement(); |
| 561 | 561 | |
| 562 | 562 | // o:lock |
| 563 | 563 | $objWriter->startElement('o:lock'); |
| 564 | - $objWriter->writeAttribute('v:ext', 'edit'); |
|
| 565 | - $objWriter->writeAttribute('rotation', 't'); |
|
| 564 | + $objWriter->writeAttribute('v:ext', 'edit'); |
|
| 565 | + $objWriter->writeAttribute('rotation', 't'); |
|
| 566 | 566 | $objWriter->endElement(); |
| 567 | 567 | |
| 568 | 568 | $objWriter->endElement(); |
@@ -579,7 +579,7 @@ discard block |
||
| 579 | 579 | public function allDrawings(PHPExcel $pPHPExcel = null) |
| 580 | 580 | { |
| 581 | 581 | // Get an array of all drawings |
| 582 | - $aDrawings = array(); |
|
| 582 | + $aDrawings = array(); |
|
| 583 | 583 | |
| 584 | 584 | // Loop through PHPExcel |
| 585 | 585 | $sheetCount = $pPHPExcel->getSheetCount(); |
@@ -53,14 +53,14 @@ discard block |
||
| 53 | 53 | } |
| 54 | 54 | |
| 55 | 55 | // XML header |
| 56 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
| 56 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
| 57 | 57 | |
| 58 | 58 | // Relationships |
| 59 | 59 | $objWriter->startElement('Relationships'); |
| 60 | 60 | $objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/package/2006/relationships'); |
| 61 | 61 | |
| 62 | 62 | $customPropertyList = $pPHPExcel->getProperties()->getCustomProperties(); |
| 63 | - if (!empty($customPropertyList)) { |
|
| 63 | + if ( ! empty($customPropertyList)) { |
|
| 64 | 64 | // Relationship docProps/app.xml |
| 65 | 65 | $this->_writeRelationship( |
| 66 | 66 | $objWriter, |
@@ -119,7 +119,7 @@ discard block |
||
| 119 | 119 | } |
| 120 | 120 | |
| 121 | 121 | // XML header |
| 122 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
| 122 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
| 123 | 123 | |
| 124 | 124 | // Relationships |
| 125 | 125 | $objWriter->startElement('Relationships'); |
@@ -156,7 +156,7 @@ discard block |
||
| 156 | 156 | $objWriter, |
| 157 | 157 | ($i + 1 + 3), |
| 158 | 158 | 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet', |
| 159 | - 'worksheets/sheet' . ($i + 1) . '.xml' |
|
| 159 | + 'worksheets/sheet'.($i + 1).'.xml' |
|
| 160 | 160 | ); |
| 161 | 161 | } |
| 162 | 162 | |
@@ -190,7 +190,7 @@ discard block |
||
| 190 | 190 | } |
| 191 | 191 | |
| 192 | 192 | // XML header |
| 193 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
| 193 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
| 194 | 194 | |
| 195 | 195 | // Relationships |
| 196 | 196 | $objWriter->startElement('Relationships'); |
@@ -209,7 +209,7 @@ discard block |
||
| 209 | 209 | $objWriter, |
| 210 | 210 | ++$d, |
| 211 | 211 | 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/drawing', |
| 212 | - '../drawings/drawing' . $pWorksheetId . '.xml' |
|
| 212 | + '../drawings/drawing'.$pWorksheetId.'.xml' |
|
| 213 | 213 | ); |
| 214 | 214 | } |
| 215 | 215 | |
@@ -231,10 +231,10 @@ discard block |
||
| 231 | 231 | // Write hyperlink relationships? |
| 232 | 232 | $i = 1; |
| 233 | 233 | foreach ($pWorksheet->getHyperlinkCollection() as $hyperlink) { |
| 234 | - if (!$hyperlink->isInternal()) { |
|
| 234 | + if ( ! $hyperlink->isInternal()) { |
|
| 235 | 235 | $this->_writeRelationship( |
| 236 | 236 | $objWriter, |
| 237 | - '_hyperlink_' . $i, |
|
| 237 | + '_hyperlink_'.$i, |
|
| 238 | 238 | 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/hyperlink', |
| 239 | 239 | $hyperlink->getUrl(), |
| 240 | 240 | 'External' |
@@ -249,16 +249,16 @@ discard block |
||
| 249 | 249 | if (count($pWorksheet->getComments()) > 0) { |
| 250 | 250 | $this->_writeRelationship( |
| 251 | 251 | $objWriter, |
| 252 | - '_comments_vml' . $i, |
|
| 252 | + '_comments_vml'.$i, |
|
| 253 | 253 | 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/vmlDrawing', |
| 254 | - '../drawings/vmlDrawing' . $pWorksheetId . '.vml' |
|
| 254 | + '../drawings/vmlDrawing'.$pWorksheetId.'.vml' |
|
| 255 | 255 | ); |
| 256 | 256 | |
| 257 | 257 | $this->_writeRelationship( |
| 258 | 258 | $objWriter, |
| 259 | - '_comments' . $i, |
|
| 259 | + '_comments'.$i, |
|
| 260 | 260 | 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/comments', |
| 261 | - '../comments' . $pWorksheetId . '.xml' |
|
| 261 | + '../comments'.$pWorksheetId.'.xml' |
|
| 262 | 262 | ); |
| 263 | 263 | } |
| 264 | 264 | |
@@ -267,9 +267,9 @@ discard block |
||
| 267 | 267 | if (count($pWorksheet->getHeaderFooter()->getImages()) > 0) { |
| 268 | 268 | $this->_writeRelationship( |
| 269 | 269 | $objWriter, |
| 270 | - '_headerfooter_vml' . $i, |
|
| 270 | + '_headerfooter_vml'.$i, |
|
| 271 | 271 | 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/vmlDrawing', |
| 272 | - '../drawings/vmlDrawingHF' . $pWorksheetId . '.vml' |
|
| 272 | + '../drawings/vmlDrawingHF'.$pWorksheetId.'.vml' |
|
| 273 | 273 | ); |
| 274 | 274 | } |
| 275 | 275 | |
@@ -299,7 +299,7 @@ discard block |
||
| 299 | 299 | } |
| 300 | 300 | |
| 301 | 301 | // XML header |
| 302 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
| 302 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
| 303 | 303 | |
| 304 | 304 | // Relationships |
| 305 | 305 | $objWriter->startElement('Relationships'); |
@@ -316,7 +316,7 @@ discard block |
||
| 316 | 316 | $objWriter, |
| 317 | 317 | $i, |
| 318 | 318 | 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/image', |
| 319 | - '../media/' . str_replace(' ', '', $iterator->current()->getIndexedFilename()) |
|
| 319 | + '../media/'.str_replace(' ', '', $iterator->current()->getIndexedFilename()) |
|
| 320 | 320 | ); |
| 321 | 321 | } |
| 322 | 322 | |
@@ -333,7 +333,7 @@ discard block |
||
| 333 | 333 | $objWriter, |
| 334 | 334 | $i++, |
| 335 | 335 | 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/chart', |
| 336 | - '../charts/chart' . ++$chartRef . '.xml' |
|
| 336 | + '../charts/chart'.++$chartRef.'.xml' |
|
| 337 | 337 | ); |
| 338 | 338 | } |
| 339 | 339 | } |
@@ -363,7 +363,7 @@ discard block |
||
| 363 | 363 | } |
| 364 | 364 | |
| 365 | 365 | // XML header |
| 366 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
| 366 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
| 367 | 367 | |
| 368 | 368 | // Relationships |
| 369 | 369 | $objWriter->startElement('Relationships'); |
@@ -376,7 +376,7 @@ discard block |
||
| 376 | 376 | $objWriter, |
| 377 | 377 | $key, |
| 378 | 378 | 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/image', |
| 379 | - '../media/' . $value->getIndexedFilename() |
|
| 379 | + '../media/'.$value->getIndexedFilename() |
|
| 380 | 380 | ); |
| 381 | 381 | } |
| 382 | 382 | |
@@ -401,12 +401,12 @@ discard block |
||
| 401 | 401 | if ($pType != '' && $pTarget != '') { |
| 402 | 402 | // Write relationship |
| 403 | 403 | $objWriter->startElement('Relationship'); |
| 404 | - $objWriter->writeAttribute('Id', 'rId' . $pId); |
|
| 405 | - $objWriter->writeAttribute('Type', $pType); |
|
| 406 | - $objWriter->writeAttribute('Target', $pTarget); |
|
| 404 | + $objWriter->writeAttribute('Id', 'rId'.$pId); |
|
| 405 | + $objWriter->writeAttribute('Type', $pType); |
|
| 406 | + $objWriter->writeAttribute('Target', $pTarget); |
|
| 407 | 407 | |
| 408 | 408 | if ($pTargetMode != '') { |
| 409 | - $objWriter->writeAttribute('TargetMode', $pTargetMode); |
|
| 409 | + $objWriter->writeAttribute('TargetMode', $pTargetMode); |
|
| 410 | 410 | } |
| 411 | 411 | |
| 412 | 412 | $objWriter->endElement(); |
@@ -49,10 +49,10 @@ discard block |
||
| 49 | 49 | // Create string lookup table |
| 50 | 50 | $aStringTable = array(); |
| 51 | 51 | $cellCollection = null; |
| 52 | - $aFlippedStringTable = null; // For faster lookup |
|
| 52 | + $aFlippedStringTable = null; // For faster lookup |
|
| 53 | 53 | |
| 54 | 54 | // Is an existing table given? |
| 55 | - if (!is_null($pExistingTable) && is_array($pExistingTable)) { |
|
| 55 | + if ( ! is_null($pExistingTable) && is_array($pExistingTable)) { |
|
| 56 | 56 | $aStringTable = $pExistingTable; |
| 57 | 57 | } |
| 58 | 58 | |
@@ -63,16 +63,16 @@ discard block |
||
| 63 | 63 | foreach ($pSheet->getCellCollection() as $cellID) { |
| 64 | 64 | $cell = $pSheet->getCell($cellID); |
| 65 | 65 | $cellValue = $cell->getValue(); |
| 66 | - if (!is_object($cellValue) && |
|
| 66 | + if ( ! is_object($cellValue) && |
|
| 67 | 67 | ($cellValue !== NULL) && |
| 68 | 68 | $cellValue !== '' && |
| 69 | - !isset($aFlippedStringTable[$cellValue]) && |
|
| 69 | + ! isset($aFlippedStringTable[$cellValue]) && |
|
| 70 | 70 | ($cell->getDataType() == PHPExcel_Cell_DataType::TYPE_STRING || $cell->getDataType() == PHPExcel_Cell_DataType::TYPE_STRING2 || $cell->getDataType() == PHPExcel_Cell_DataType::TYPE_NULL)) { |
| 71 | 71 | $aStringTable[] = $cellValue; |
| 72 | 72 | $aFlippedStringTable[$cellValue] = true; |
| 73 | 73 | } elseif ($cellValue instanceof PHPExcel_RichText && |
| 74 | 74 | ($cellValue !== NULL) && |
| 75 | - !isset($aFlippedStringTable[$cellValue->getHashCode()])) { |
|
| 75 | + ! isset($aFlippedStringTable[$cellValue->getHashCode()])) { |
|
| 76 | 76 | $aStringTable[] = $cellValue; |
| 77 | 77 | $aFlippedStringTable[$cellValue->getHashCode()] = true; |
| 78 | 78 | } |
@@ -94,7 +94,7 @@ discard block |
||
| 94 | 94 | */ |
| 95 | 95 | public function writeStringTable($pStringTable = null) |
| 96 | 96 | { |
| 97 | - if (!is_null($pStringTable)) { |
|
| 97 | + if ( ! is_null($pStringTable)) { |
|
| 98 | 98 | // Create XML writer |
| 99 | 99 | $objWriter = null; |
| 100 | 100 | if ($this->getParentWriter()->getUseDiskCaching()) { |
@@ -104,7 +104,7 @@ discard block |
||
| 104 | 104 | } |
| 105 | 105 | |
| 106 | 106 | // XML header |
| 107 | - $objWriter->startDocument('1.0','UTF-8','yes'); |
|
| 107 | + $objWriter->startDocument('1.0', 'UTF-8', 'yes'); |
|
| 108 | 108 | |
| 109 | 109 | // String table |
| 110 | 110 | $objWriter->startElement('sst'); |
@@ -115,8 +115,8 @@ discard block |
||
| 115 | 115 | foreach ($pStringTable as $textElement) { |
| 116 | 116 | $objWriter->startElement('si'); |
| 117 | 117 | |
| 118 | - if (! $textElement instanceof PHPExcel_RichText) { |
|
| 119 | - $textToWrite = PHPExcel_Shared_String::ControlCharacterPHP2OOXML( $textElement ); |
|
| 118 | + if ( ! $textElement instanceof PHPExcel_RichText) { |
|
| 119 | + $textToWrite = PHPExcel_Shared_String::ControlCharacterPHP2OOXML($textElement); |
|
| 120 | 120 | $objWriter->startElement('t'); |
| 121 | 121 | if ($textToWrite !== trim($textToWrite)) { |
| 122 | 122 | $objWriter->writeAttribute('xml:space', 'preserve'); |
@@ -147,7 +147,7 @@ discard block |
||
| 147 | 147 | * @param string $prefix Optional Namespace prefix |
| 148 | 148 | * @throws Exception |
| 149 | 149 | */ |
| 150 | - public function writeRichText(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_RichText $pRichText = null, $prefix=NULL) |
|
| 150 | + public function writeRichText(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_RichText $pRichText = null, $prefix = NULL) |
|
| 151 | 151 | { |
| 152 | 152 | if ($prefix !== NULL) |
| 153 | 153 | $prefix .= ':'; |
@@ -214,7 +214,7 @@ discard block |
||
| 214 | 214 | // t |
| 215 | 215 | $objWriter->startElement($prefix.'t'); |
| 216 | 216 | $objWriter->writeAttribute('xml:space', 'preserve'); |
| 217 | - $objWriter->writeRawData(PHPExcel_Shared_String::ControlCharacterPHP2OOXML( $element->getText() )); |
|
| 217 | + $objWriter->writeRawData(PHPExcel_Shared_String::ControlCharacterPHP2OOXML($element->getText())); |
|
| 218 | 218 | $objWriter->endElement(); |
| 219 | 219 | |
| 220 | 220 | $objWriter->endElement(); |
@@ -229,7 +229,7 @@ discard block |
||
| 229 | 229 | * @param string $prefix Optional Namespace prefix |
| 230 | 230 | * @throws Exception |
| 231 | 231 | */ |
| 232 | - public function writeRichTextForCharts(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_RichText $pRichText = null, $prefix=NULL) |
|
| 232 | + public function writeRichTextForCharts(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_RichText $pRichText = null, $prefix = NULL) |
|
| 233 | 233 | { |
| 234 | 234 | if ($prefix !== NULL) |
| 235 | 235 | $prefix .= ':'; |
@@ -248,7 +248,7 @@ discard block |
||
| 248 | 248 | $objWriter->writeAttribute('i', ($element->getFont()->getItalic() ? 1 : 0)); |
| 249 | 249 | // Underline |
| 250 | 250 | $underlineType = $element->getFont()->getUnderline(); |
| 251 | - switch($underlineType) { |
|
| 251 | + switch ($underlineType) { |
|
| 252 | 252 | case 'single' : |
| 253 | 253 | $underlineType = 'sng'; |
| 254 | 254 | break; |
@@ -281,7 +281,7 @@ discard block |
||
| 281 | 281 | // t |
| 282 | 282 | $objWriter->startElement($prefix.'t'); |
| 283 | 283 | $objWriter->writeAttribute('xml:space', 'preserve'); |
| 284 | - $objWriter->writeRawData(PHPExcel_Shared_String::ControlCharacterPHP2OOXML( $element->getText() )); |
|
| 284 | + $objWriter->writeRawData(PHPExcel_Shared_String::ControlCharacterPHP2OOXML($element->getText())); |
|
| 285 | 285 | $objWriter->endElement(); |
| 286 | 286 | |
| 287 | 287 | $objWriter->endElement(); |
@@ -300,7 +300,7 @@ discard block |
||
| 300 | 300 | |
| 301 | 301 | // Loop through stringtable and add flipped items to $returnValue |
| 302 | 302 | foreach ($stringTable as $key => $value) { |
| 303 | - if (! $value instanceof PHPExcel_RichText) { |
|
| 303 | + if ( ! $value instanceof PHPExcel_RichText) { |
|
| 304 | 304 | $returnValue[$value] = $key; |
| 305 | 305 | } else if ($value instanceof PHPExcel_RichText) { |
| 306 | 306 | $returnValue[$value->getHashCode()] = $key; |
@@ -149,8 +149,9 @@ discard block |
||
| 149 | 149 | */ |
| 150 | 150 | public function writeRichText(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_RichText $pRichText = null, $prefix=NULL) |
| 151 | 151 | { |
| 152 | - if ($prefix !== NULL) |
|
| 153 | - $prefix .= ':'; |
|
| 152 | + if ($prefix !== NULL) { |
|
| 153 | + $prefix .= ':'; |
|
| 154 | + } |
|
| 154 | 155 | // Loop through rich text elements |
| 155 | 156 | $elements = $pRichText->getRichTextElements(); |
| 156 | 157 | foreach ($elements as $element) { |
@@ -231,8 +232,9 @@ discard block |
||
| 231 | 232 | */ |
| 232 | 233 | public function writeRichTextForCharts(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_RichText $pRichText = null, $prefix=NULL) |
| 233 | 234 | { |
| 234 | - if ($prefix !== NULL) |
|
| 235 | - $prefix .= ':'; |
|
| 235 | + if ($prefix !== NULL) { |
|
| 236 | + $prefix .= ':'; |
|
| 237 | + } |
|
| 236 | 238 | // Loop through rich text elements |
| 237 | 239 | $elements = $pRichText->getRichTextElements(); |
| 238 | 240 | foreach ($elements as $element) { |
@@ -75,11 +75,11 @@ discard block |
||
| 75 | 75 | !isset($aFlippedStringTable[$cellValue->getHashCode()])) { |
| 76 | 76 | $aStringTable[] = $cellValue; |
| 77 | 77 | $aFlippedStringTable[$cellValue->getHashCode()] = true; |
| 78 | - } |
|
| 79 | - } |
|
| 78 | + } |
|
| 79 | + } |
|
| 80 | 80 | |
| 81 | - // Return |
|
| 82 | - return $aStringTable; |
|
| 81 | + // Return |
|
| 82 | + return $aStringTable; |
|
| 83 | 83 | } else { |
| 84 | 84 | throw new Exception("Invalid PHPExcel_Worksheet object passed."); |
| 85 | 85 | } |
@@ -127,7 +127,7 @@ discard block |
||
| 127 | 127 | $this->writeRichText($objWriter, $textElement); |
| 128 | 128 | } |
| 129 | 129 | |
| 130 | - $objWriter->endElement(); |
|
| 130 | + $objWriter->endElement(); |
|
| 131 | 131 | } |
| 132 | 132 | |
| 133 | 133 | $objWriter->endElement(); |