MewesK / TwigExcelBundle

Twig/Node/XlsDocumentNode.php

Spacing +8 added lines, -8 removed lines

@@ -45,16 +45,16 @@
         $compiler->addDebugInfo($this)
             ->write('$documentProperties = ')
             ->subcompile($this->getNode('properties'))
-            ->raw(';' . PHP_EOL)
-            ->write('$context[\'phpExcel\'] = new MewesK\TwigExcelBundle\Wrapper\PhpExcelWrapper($context, $this->getEnvironment());' . PHP_EOL)
-            ->write('$context[\'phpExcel\']->startDocument($documentProperties);' . PHP_EOL)
-            ->write('unset($documentProperties);' . PHP_EOL)
+            ->raw(';'.PHP_EOL)
+            ->write('$context[\'phpExcel\'] = new MewesK\TwigExcelBundle\Wrapper\PhpExcelWrapper($context, $this->getEnvironment());'.PHP_EOL)
+            ->write('$context[\'phpExcel\']->startDocument($documentProperties);'.PHP_EOL)
+            ->write('unset($documentProperties);'.PHP_EOL)
             ->subcompile($this->getNode('body'))
             ->addDebugInfo($this)
-            ->write('$context[\'phpExcel\']->endDocument(' .
-                ($this->preCalculateFormulas ? 'true' : 'false') . ', ' .
-                ($this->diskCachingDirectory ? '\'' . $this->diskCachingDirectory . '\'' : 'null') . ');' . PHP_EOL)
-            ->write('unset($context[\'phpExcel\']);' . PHP_EOL);
+            ->write('$context[\'phpExcel\']->endDocument('.
+                ($this->preCalculateFormulas ? 'true' : 'false').', '.
+                ($this->diskCachingDirectory ? '\''.$this->diskCachingDirectory.'\'' : 'null').');'.PHP_EOL)
+            ->write('unset($context[\'phpExcel\']);'.PHP_EOL);
     }
 
     /**

Wrapper/XlsSheetWrapper.php

Spacing +56 added lines, -56 removed lines

@@ -79,167 +79,167 @@ 
     protected function initializeMappings()
     {
         $this->mappings['columnDimension']['__multi'] = true;
-        $this->mappings['columnDimension']['__object'] = function ($key = 'default') {
+        $this->mappings['columnDimension']['__object'] = function($key = 'default') {
             return $key === 'default' ? $this->object->getDefaultColumnDimension() : $this->object->getColumnDimension($key);
         };
-        $this->mappings['columnDimension']['autoSize'] = function ($key, $value) {
+        $this->mappings['columnDimension']['autoSize'] = function($key, $value) {
             $this->mappings['columnDimension']['__object']($key)->setAutoSize($value);
         };
-        $this->mappings['columnDimension']['collapsed'] = function ($key, $value) {
+        $this->mappings['columnDimension']['collapsed'] = function($key, $value) {
             $this->mappings['columnDimension']['__object']($key)->setCollapsed($value);
         };
-        $this->mappings['columnDimension']['columnIndex'] = function ($key, $value) {
+        $this->mappings['columnDimension']['columnIndex'] = function($key, $value) {
             $this->mappings['columnDimension']['__object']($key)->setColumnIndex($value);
         };
-        $this->mappings['columnDimension']['outlineLevel'] = function ($key, $value) {
+        $this->mappings['columnDimension']['outlineLevel'] = function($key, $value) {
             $this->mappings['columnDimension']['__object']($key)->setOutlineLevel($value);
         };
-        $this->mappings['columnDimension']['visible'] = function ($key, $value) {
+        $this->mappings['columnDimension']['visible'] = function($key, $value) {
             $this->mappings['columnDimension']['__object']($key)->setVisible($value);
         };
-        $this->mappings['columnDimension']['width'] = function ($key, $value) {
+        $this->mappings['columnDimension']['width'] = function($key, $value) {
             $this->mappings['columnDimension']['__object']($key)->setWidth($value);
         };
-        $this->mappings['columnDimension']['xfIndex'] = function ($key, $value) {
+        $this->mappings['columnDimension']['xfIndex'] = function($key, $value) {
             $this->mappings['columnDimension']['__object']($key)->setXfIndex($value);
         };
-        $this->mappings['pageMargins']['top'] = function ($value) {
+        $this->mappings['pageMargins']['top'] = function($value) {
             $this->object->getPageMargins()->setTop($value);
         };
-        $this->mappings['pageMargins']['bottom'] = function ($value) {
+        $this->mappings['pageMargins']['bottom'] = function($value) {
             $this->object->getPageMargins()->setBottom($value);
         };
-        $this->mappings['pageMargins']['left'] = function ($value) {
+        $this->mappings['pageMargins']['left'] = function($value) {
             $this->object->getPageMargins()->setLeft($value);
         };
-        $this->mappings['pageMargins']['right'] = function ($value) {
+        $this->mappings['pageMargins']['right'] = function($value) {
             $this->object->getPageMargins()->setRight($value);
         };
-        $this->mappings['pageMargins']['header'] = function ($value) {
+        $this->mappings['pageMargins']['header'] = function($value) {
             $this->object->getPageMargins()->setHeader($value);
         };
-        $this->mappings['pageMargins']['footer'] = function ($value) {
+        $this->mappings['pageMargins']['footer'] = function($value) {
             $this->object->getPageMargins()->setFooter($value);
         };
-        $this->mappings['pageSetup']['fitToHeight'] = function ($value) {
+        $this->mappings['pageSetup']['fitToHeight'] = function($value) {
             $this->object->getPageSetup()->setFitToHeight($value);
         };
-        $this->mappings['pageSetup']['fitToPage'] = function ($value) {
+        $this->mappings['pageSetup']['fitToPage'] = function($value) {
             $this->object->getPageSetup()->setFitToPage($value);
         };
-        $this->mappings['pageSetup']['fitToWidth'] = function ($value) {
+        $this->mappings['pageSetup']['fitToWidth'] = function($value) {
             $this->object->getPageSetup()->setFitToWidth($value);
         };
-        $this->mappings['pageSetup']['horizontalCentered'] = function ($value) {
+        $this->mappings['pageSetup']['horizontalCentered'] = function($value) {
             $this->object->getPageSetup()->setHorizontalCentered($value);
         };
-        $this->mappings['pageSetup']['orientation'] = function ($value) {
+        $this->mappings['pageSetup']['orientation'] = function($value) {
             $this->object->getPageSetup()->setOrientation($value);
         };
-        $this->mappings['pageSetup']['paperSize'] = function ($value) {
+        $this->mappings['pageSetup']['paperSize'] = function($value) {
             $this->object->getPageSetup()->setPaperSize($value);
         };
-        $this->mappings['pageSetup']['printArea'] = function ($value) {
+        $this->mappings['pageSetup']['printArea'] = function($value) {
             $this->object->getPageSetup()->setPrintArea($value);
         };
-        $this->mappings['pageSetup']['scale'] = function ($value) {
+        $this->mappings['pageSetup']['scale'] = function($value) {
             $this->object->getPageSetup()->setScale($value);
         };
-        $this->mappings['pageSetup']['verticalCentered'] = function ($value) {
+        $this->mappings['pageSetup']['verticalCentered'] = function($value) {
             $this->object->getPageSetup()->setVerticalCentered($value);
         };
-        $this->mappings['printGridlines'] = function ($value) {
+        $this->mappings['printGridlines'] = function($value) {
             $this->object->setPrintGridlines($value);
         };
-        $this->mappings['protection']['autoFilter'] = function ($value) {
+        $this->mappings['protection']['autoFilter'] = function($value) {
             $this->object->getProtection()->setAutoFilter($value);
         };
-        $this->mappings['protection']['deleteColumns'] = function ($value) {
+        $this->mappings['protection']['deleteColumns'] = function($value) {
             $this->object->getProtection()->setDeleteColumns($value);
         };
-        $this->mappings['protection']['deleteRows'] = function ($value) {
+        $this->mappings['protection']['deleteRows'] = function($value) {
             $this->object->getProtection()->setDeleteRows($value);
         };
-        $this->mappings['protection']['formatCells'] = function ($value) {
+        $this->mappings['protection']['formatCells'] = function($value) {
             $this->object->getProtection()->setFormatCells($value);
         };
-        $this->mappings['protection']['formatColumns'] = function ($value) {
+        $this->mappings['protection']['formatColumns'] = function($value) {
             $this->object->getProtection()->setFormatColumns($value);
         };
-        $this->mappings['protection']['formatRows'] = function ($value) {
+        $this->mappings['protection']['formatRows'] = function($value) {
             $this->object->getProtection()->setFormatRows($value);
         };
-        $this->mappings['protection']['insertColumns'] = function ($value) {
+        $this->mappings['protection']['insertColumns'] = function($value) {
             $this->object->getProtection()->setInsertColumns($value);
         };
-        $this->mappings['protection']['insertHyperlinks'] = function ($value) {
+        $this->mappings['protection']['insertHyperlinks'] = function($value) {
             $this->object->getProtection()->setInsertHyperlinks($value);
         };
-        $this->mappings['protection']['insertRows'] = function ($value) {
+        $this->mappings['protection']['insertRows'] = function($value) {
             $this->object->getProtection()->setInsertRows($value);
         };
-        $this->mappings['protection']['objects'] = function ($value) {
+        $this->mappings['protection']['objects'] = function($value) {
             $this->object->getProtection()->setObjects($value);
         };
-        $this->mappings['protection']['password'] = function ($value) {
+        $this->mappings['protection']['password'] = function($value) {
             $this->object->getProtection()->setPassword($value);
         };
-        $this->mappings['protection']['pivotTables'] = function ($value) {
+        $this->mappings['protection']['pivotTables'] = function($value) {
             $this->object->getProtection()->setPivotTables($value);
         };
-        $this->mappings['protection']['scenarios'] = function ($value) {
+        $this->mappings['protection']['scenarios'] = function($value) {
             $this->object->getProtection()->setScenarios($value);
         };
-        $this->mappings['protection']['selectLockedCells'] = function ($value) {
+        $this->mappings['protection']['selectLockedCells'] = function($value) {
             $this->object->getProtection()->setSelectLockedCells($value);
         };
-        $this->mappings['protection']['selectUnlockedCells'] = function ($value) {
+        $this->mappings['protection']['selectUnlockedCells'] = function($value) {
             $this->object->getProtection()->setSelectUnlockedCells($value);
         };
-        $this->mappings['protection']['sheet'] = function ($value) {
+        $this->mappings['protection']['sheet'] = function($value) {
             $this->object->getProtection()->setSheet($value);
         };
-        $this->mappings['protection']['sort'] = function ($value) {
+        $this->mappings['protection']['sort'] = function($value) {
             $this->object->getProtection()->setSort($value);
         };
-        $this->mappings['rightToLeft'] = function ($value) {
+        $this->mappings['rightToLeft'] = function($value) {
             $this->object->setRightToLeft($value);
         };
         $this->mappings['rowDimension']['__multi'] = true;
-        $this->mappings['rowDimension']['__object'] = function ($key) {
+        $this->mappings['rowDimension']['__object'] = function($key) {
             return $key === 'default' ? $this->object->getDefaultRowDimension() : $this->object->getRowDimension($key);
         };
-        $this->mappings['rowDimension']['collapsed'] = function ($key, $value) {
+        $this->mappings['rowDimension']['collapsed'] = function($key, $value) {
             $this->mappings['rowDimension']['__object']($key)->setCollapsed($value);
         };
-        $this->mappings['rowDimension']['outlineLevel'] = function ($key, $value) {
+        $this->mappings['rowDimension']['outlineLevel'] = function($key, $value) {
             $this->mappings['rowDimension']['__object']($key)->setOutlineLevel($value);
         };
-        $this->mappings['rowDimension']['rowHeight'] = function ($key, $value) {
+        $this->mappings['rowDimension']['rowHeight'] = function($key, $value) {
             $this->mappings['rowDimension']['__object']($key)->setRowHeight($value);
         };
-        $this->mappings['rowDimension']['rowIndex'] = function ($key, $value) {
+        $this->mappings['rowDimension']['rowIndex'] = function($key, $value) {
             $this->mappings['rowDimension']['__object']($key)->setRowIndex($value);
         };
-        $this->mappings['rowDimension']['visible'] = function ($key, $value) {
+        $this->mappings['rowDimension']['visible'] = function($key, $value) {
             $this->mappings['rowDimension']['__object']($key)->setVisible($value);
         };
-        $this->mappings['rowDimension']['xfIndex'] = function ($key, $value) {
+        $this->mappings['rowDimension']['xfIndex'] = function($key, $value) {
             $this->mappings['rowDimension']['__object']($key)->setXfIndex($value);
         };
-        $this->mappings['rowDimension']['zeroHeight'] = function ($key, $value) {
+        $this->mappings['rowDimension']['zeroHeight'] = function($key, $value) {
             $this->mappings['rowDimension']['__object']($key)->setZeroHeight($value);
         };
-        $this->mappings['sheetState'] = function ($value) {
+        $this->mappings['sheetState'] = function($value) {
             $this->object->setSheetState($value);
         };
-        $this->mappings['showGridlines'] = function ($value) {
+        $this->mappings['showGridlines'] = function($value) {
             $this->object->setShowGridlines($value);
         };
-        $this->mappings['tabColor'] = function ($value) {
+        $this->mappings['tabColor'] = function($value) {
             $this->object->getTabColor()->setRGB($value);
         };
-        $this->mappings['zoomScale'] = function ($value) {
+        $this->mappings['zoomScale'] = function($value) {
             $this->object->getSheetView()->setZoomScale($value);
         };
     }
@@ -251,7 +251,7 @@ 
      */
     public function start($index, array $properties = null)
     {
-        if (is_int($index) && $index <$this->documentWrapper->getObject()->getSheetCount()) {
+        if (is_int($index) && $index < $this->documentWrapper->getObject()->getSheetCount()) {
             $this->object = $this->documentWrapper->getObject()->setActiveSheetIndex($index);
         } elseif (is_string($index)) {
             if (!$this->documentWrapper->getObject()->sheetNameExists($index)) {
@@ -259,7 +259,7 @@ 
                 $this->documentWrapper->getObject()->createSheet()->setTitle($index);
             }
             $this->object = $this->documentWrapper->getObject()->setActiveSheetIndexByName($index);
-        }  else {
+        } else {
             // create new sheet without a name
             $this->documentWrapper->getObject()->createSheet();
             $this->object = $this->documentWrapper->getObject()->setActiveSheetIndex(0);

Braces +109 added lines, -55 removed lines

@@ -79,167 +79,221 @@ 
     protected function initializeMappings()
     {
         $this->mappings['columnDimension']['__multi'] = true;
-        $this->mappings['columnDimension']['__object'] = function ($key = 'default') {
+        $this->mappings['columnDimension']['__object'] = function ($key = 'default')
+        {
             return $key === 'default' ? $this->object->getDefaultColumnDimension() : $this->object->getColumnDimension($key);
         };
-        $this->mappings['columnDimension']['autoSize'] = function ($key, $value) {
+        $this->mappings['columnDimension']['autoSize'] = function ($key, $value)
+        {
             $this->mappings['columnDimension']['__object']($key)->setAutoSize($value);
         };
-        $this->mappings['columnDimension']['collapsed'] = function ($key, $value) {
+        $this->mappings['columnDimension']['collapsed'] = function ($key, $value)
+        {
             $this->mappings['columnDimension']['__object']($key)->setCollapsed($value);
         };
-        $this->mappings['columnDimension']['columnIndex'] = function ($key, $value) {
+        $this->mappings['columnDimension']['columnIndex'] = function ($key, $value)
+        {
             $this->mappings['columnDimension']['__object']($key)->setColumnIndex($value);
         };
-        $this->mappings['columnDimension']['outlineLevel'] = function ($key, $value) {
+        $this->mappings['columnDimension']['outlineLevel'] = function ($key, $value)
+        {
             $this->mappings['columnDimension']['__object']($key)->setOutlineLevel($value);
         };
-        $this->mappings['columnDimension']['visible'] = function ($key, $value) {
+        $this->mappings['columnDimension']['visible'] = function ($key, $value)
+        {
             $this->mappings['columnDimension']['__object']($key)->setVisible($value);
         };
-        $this->mappings['columnDimension']['width'] = function ($key, $value) {
+        $this->mappings['columnDimension']['width'] = function ($key, $value)
+        {
             $this->mappings['columnDimension']['__object']($key)->setWidth($value);
         };
-        $this->mappings['columnDimension']['xfIndex'] = function ($key, $value) {
+        $this->mappings['columnDimension']['xfIndex'] = function ($key, $value)
+        {
             $this->mappings['columnDimension']['__object']($key)->setXfIndex($value);
         };
-        $this->mappings['pageMargins']['top'] = function ($value) {
+        $this->mappings['pageMargins']['top'] = function ($value)
+        {
             $this->object->getPageMargins()->setTop($value);
         };
-        $this->mappings['pageMargins']['bottom'] = function ($value) {
+        $this->mappings['pageMargins']['bottom'] = function ($value)
+        {
             $this->object->getPageMargins()->setBottom($value);
         };
-        $this->mappings['pageMargins']['left'] = function ($value) {
+        $this->mappings['pageMargins']['left'] = function ($value)
+        {
             $this->object->getPageMargins()->setLeft($value);
         };
-        $this->mappings['pageMargins']['right'] = function ($value) {
+        $this->mappings['pageMargins']['right'] = function ($value)
+        {
             $this->object->getPageMargins()->setRight($value);
         };
-        $this->mappings['pageMargins']['header'] = function ($value) {
+        $this->mappings['pageMargins']['header'] = function ($value)
+        {
             $this->object->getPageMargins()->setHeader($value);
         };
-        $this->mappings['pageMargins']['footer'] = function ($value) {
+        $this->mappings['pageMargins']['footer'] = function ($value)
+        {
             $this->object->getPageMargins()->setFooter($value);
         };
-        $this->mappings['pageSetup']['fitToHeight'] = function ($value) {
+        $this->mappings['pageSetup']['fitToHeight'] = function ($value)
+        {
             $this->object->getPageSetup()->setFitToHeight($value);
         };
-        $this->mappings['pageSetup']['fitToPage'] = function ($value) {
+        $this->mappings['pageSetup']['fitToPage'] = function ($value)
+        {
             $this->object->getPageSetup()->setFitToPage($value);
         };
-        $this->mappings['pageSetup']['fitToWidth'] = function ($value) {
+        $this->mappings['pageSetup']['fitToWidth'] = function ($value)
+        {
             $this->object->getPageSetup()->setFitToWidth($value);
         };
-        $this->mappings['pageSetup']['horizontalCentered'] = function ($value) {
+        $this->mappings['pageSetup']['horizontalCentered'] = function ($value)
+        {
             $this->object->getPageSetup()->setHorizontalCentered($value);
         };
-        $this->mappings['pageSetup']['orientation'] = function ($value) {
+        $this->mappings['pageSetup']['orientation'] = function ($value)
+        {
             $this->object->getPageSetup()->setOrientation($value);
         };
-        $this->mappings['pageSetup']['paperSize'] = function ($value) {
+        $this->mappings['pageSetup']['paperSize'] = function ($value)
+        {
             $this->object->getPageSetup()->setPaperSize($value);
         };
-        $this->mappings['pageSetup']['printArea'] = function ($value) {
+        $this->mappings['pageSetup']['printArea'] = function ($value)
+        {
             $this->object->getPageSetup()->setPrintArea($value);
         };
-        $this->mappings['pageSetup']['scale'] = function ($value) {
+        $this->mappings['pageSetup']['scale'] = function ($value)
+        {
             $this->object->getPageSetup()->setScale($value);
         };
-        $this->mappings['pageSetup']['verticalCentered'] = function ($value) {
+        $this->mappings['pageSetup']['verticalCentered'] = function ($value)
+        {
             $this->object->getPageSetup()->setVerticalCentered($value);
         };
-        $this->mappings['printGridlines'] = function ($value) {
+        $this->mappings['printGridlines'] = function ($value)
+        {
             $this->object->setPrintGridlines($value);
         };
-        $this->mappings['protection']['autoFilter'] = function ($value) {
+        $this->mappings['protection']['autoFilter'] = function ($value)
+        {
             $this->object->getProtection()->setAutoFilter($value);
         };
-        $this->mappings['protection']['deleteColumns'] = function ($value) {
+        $this->mappings['protection']['deleteColumns'] = function ($value)
+        {
             $this->object->getProtection()->setDeleteColumns($value);
         };
-        $this->mappings['protection']['deleteRows'] = function ($value) {
+        $this->mappings['protection']['deleteRows'] = function ($value)
+        {
             $this->object->getProtection()->setDeleteRows($value);
         };
-        $this->mappings['protection']['formatCells'] = function ($value) {
+        $this->mappings['protection']['formatCells'] = function ($value)
+        {
             $this->object->getProtection()->setFormatCells($value);
         };
-        $this->mappings['protection']['formatColumns'] = function ($value) {
+        $this->mappings['protection']['formatColumns'] = function ($value)
+        {
             $this->object->getProtection()->setFormatColumns($value);
         };
-        $this->mappings['protection']['formatRows'] = function ($value) {
+        $this->mappings['protection']['formatRows'] = function ($value)
+        {
             $this->object->getProtection()->setFormatRows($value);
         };
-        $this->mappings['protection']['insertColumns'] = function ($value) {
+        $this->mappings['protection']['insertColumns'] = function ($value)
+        {
             $this->object->getProtection()->setInsertColumns($value);
         };
-        $this->mappings['protection']['insertHyperlinks'] = function ($value) {
+        $this->mappings['protection']['insertHyperlinks'] = function ($value)
+        {
             $this->object->getProtection()->setInsertHyperlinks($value);
         };
-        $this->mappings['protection']['insertRows'] = function ($value) {
+        $this->mappings['protection']['insertRows'] = function ($value)
+        {
             $this->object->getProtection()->setInsertRows($value);
         };
-        $this->mappings['protection']['objects'] = function ($value) {
+        $this->mappings['protection']['objects'] = function ($value)
+        {
             $this->object->getProtection()->setObjects($value);
         };
-        $this->mappings['protection']['password'] = function ($value) {
+        $this->mappings['protection']['password'] = function ($value)
+        {
             $this->object->getProtection()->setPassword($value);
         };
-        $this->mappings['protection']['pivotTables'] = function ($value) {
+        $this->mappings['protection']['pivotTables'] = function ($value)
+        {
             $this->object->getProtection()->setPivotTables($value);
         };
-        $this->mappings['protection']['scenarios'] = function ($value) {
+        $this->mappings['protection']['scenarios'] = function ($value)
+        {
             $this->object->getProtection()->setScenarios($value);
         };
-        $this->mappings['protection']['selectLockedCells'] = function ($value) {
+        $this->mappings['protection']['selectLockedCells'] = function ($value)
+        {
             $this->object->getProtection()->setSelectLockedCells($value);
         };
-        $this->mappings['protection']['selectUnlockedCells'] = function ($value) {
+        $this->mappings['protection']['selectUnlockedCells'] = function ($value)
+        {
             $this->object->getProtection()->setSelectUnlockedCells($value);
         };
-        $this->mappings['protection']['sheet'] = function ($value) {
+        $this->mappings['protection']['sheet'] = function ($value)
+        {
             $this->object->getProtection()->setSheet($value);
         };
-        $this->mappings['protection']['sort'] = function ($value) {
+        $this->mappings['protection']['sort'] = function ($value)
+        {
             $this->object->getProtection()->setSort($value);
         };
-        $this->mappings['rightToLeft'] = function ($value) {
+        $this->mappings['rightToLeft'] = function ($value)
+        {
             $this->object->setRightToLeft($value);
         };
         $this->mappings['rowDimension']['__multi'] = true;
-        $this->mappings['rowDimension']['__object'] = function ($key) {
+        $this->mappings['rowDimension']['__object'] = function ($key)
+        {
             return $key === 'default' ? $this->object->getDefaultRowDimension() : $this->object->getRowDimension($key);
         };
-        $this->mappings['rowDimension']['collapsed'] = function ($key, $value) {
+        $this->mappings['rowDimension']['collapsed'] = function ($key, $value)
+        {
             $this->mappings['rowDimension']['__object']($key)->setCollapsed($value);
         };
-        $this->mappings['rowDimension']['outlineLevel'] = function ($key, $value) {
+        $this->mappings['rowDimension']['outlineLevel'] = function ($key, $value)
+        {
             $this->mappings['rowDimension']['__object']($key)->setOutlineLevel($value);
         };
-        $this->mappings['rowDimension']['rowHeight'] = function ($key, $value) {
+        $this->mappings['rowDimension']['rowHeight'] = function ($key, $value)
+        {
             $this->mappings['rowDimension']['__object']($key)->setRowHeight($value);
         };
-        $this->mappings['rowDimension']['rowIndex'] = function ($key, $value) {
+        $this->mappings['rowDimension']['rowIndex'] = function ($key, $value)
+        {
             $this->mappings['rowDimension']['__object']($key)->setRowIndex($value);
         };
-        $this->mappings['rowDimension']['visible'] = function ($key, $value) {
+        $this->mappings['rowDimension']['visible'] = function ($key, $value)
+        {
             $this->mappings['rowDimension']['__object']($key)->setVisible($value);
         };
-        $this->mappings['rowDimension']['xfIndex'] = function ($key, $value) {
+        $this->mappings['rowDimension']['xfIndex'] = function ($key, $value)
+        {
             $this->mappings['rowDimension']['__object']($key)->setXfIndex($value);
         };
-        $this->mappings['rowDimension']['zeroHeight'] = function ($key, $value) {
+        $this->mappings['rowDimension']['zeroHeight'] = function ($key, $value)
+        {
             $this->mappings['rowDimension']['__object']($key)->setZeroHeight($value);
         };
-        $this->mappings['sheetState'] = function ($value) {
+        $this->mappings['sheetState'] = function ($value)
+        {
             $this->object->setSheetState($value);
         };
-        $this->mappings['showGridlines'] = function ($value) {
+        $this->mappings['showGridlines'] = function ($value)
+        {
             $this->object->setShowGridlines($value);
         };
-        $this->mappings['tabColor'] = function ($value) {
+        $this->mappings['tabColor'] = function ($value)
+        {
             $this->object->getTabColor()->setRGB($value);
         };
-        $this->mappings['zoomScale'] = function ($value) {
+        $this->mappings['zoomScale'] = function ($value)
+        {
             $this->object->getSheetView()->setZoomScale($value);
         };
     }
@@ -259,7 +313,7 @@ 
                 $this->documentWrapper->getObject()->createSheet()->setTitle($index);
             }
             $this->object = $this->documentWrapper->getObject()->setActiveSheetIndexByName($index);
-        }  else {
+        } else {
             // create new sheet without a name
             $this->documentWrapper->getObject()->createSheet();
             $this->object = $this->documentWrapper->getObject()->setActiveSheetIndex(0);

Wrapper/XlsCellWrapper.php

Spacing +18 added lines, -18 removed lines

@@ -57,58 +57,58 @@
 
     protected function initializeMappings()
     {
-        $this->mappings['break'] = function ($value) {
+        $this->mappings['break'] = function($value) {
             $this->sheetWrapper->getObject()->setBreak($this->object->getCoordinate(), $value);
         };
-        $this->mappings['dataType'] = function ($value) {
+        $this->mappings['dataType'] = function($value) {
             $this->object->setDataType($value);
         };
-        $this->mappings['dataValidation']['allowBlank'] = function ($value) {
+        $this->mappings['dataValidation']['allowBlank'] = function($value) {
             $this->object->getDataValidation()->setAllowBlank($value);
         };
-        $this->mappings['dataValidation']['error'] = function ($value) {
+        $this->mappings['dataValidation']['error'] = function($value) {
             $this->object->getDataValidation()->setError($value);
         };
-        $this->mappings['dataValidation']['errorStyle'] = function ($value) {
+        $this->mappings['dataValidation']['errorStyle'] = function($value) {
             $this->object->getDataValidation()->setErrorStyle($value);
         };
-        $this->mappings['dataValidation']['errorTitle'] = function ($value) {
+        $this->mappings['dataValidation']['errorTitle'] = function($value) {
             $this->object->getDataValidation()->setErrorTitle($value);
         };
-        $this->mappings['dataValidation']['formula1'] = function ($value) {
+        $this->mappings['dataValidation']['formula1'] = function($value) {
             $this->object->getDataValidation()->setFormula1($value);
         };
-        $this->mappings['dataValidation']['formula2'] = function ($value) {
+        $this->mappings['dataValidation']['formula2'] = function($value) {
             $this->object->getDataValidation()->setFormula2($value);
         };
-        $this->mappings['dataValidation']['operator'] = function ($value) {
+        $this->mappings['dataValidation']['operator'] = function($value) {
             $this->object->getDataValidation()->setOperator($value);
         };
-        $this->mappings['dataValidation']['prompt'] = function ($value) {
+        $this->mappings['dataValidation']['prompt'] = function($value) {
             $this->object->getDataValidation()->setPrompt($value);
         };
-        $this->mappings['dataValidation']['promptTitle'] = function ($value) {
+        $this->mappings['dataValidation']['promptTitle'] = function($value) {
             $this->object->getDataValidation()->setPromptTitle($value);
         };
-        $this->mappings['dataValidation']['showDropDown'] = function ($value) {
+        $this->mappings['dataValidation']['showDropDown'] = function($value) {
             $this->object->getDataValidation()->setShowDropDown($value);
         };
-        $this->mappings['dataValidation']['showErrorMessage'] = function ($value) {
+        $this->mappings['dataValidation']['showErrorMessage'] = function($value) {
             $this->object->getDataValidation()->setShowErrorMessage($value);
         };
-        $this->mappings['dataValidation']['showInputMessage'] = function ($value) {
+        $this->mappings['dataValidation']['showInputMessage'] = function($value) {
             $this->object->getDataValidation()->setShowInputMessage($value);
         };
-        $this->mappings['dataValidation']['type'] = function ($value) {
+        $this->mappings['dataValidation']['type'] = function($value) {
             $this->object->getDataValidation()->setType($value);
         };
-        $this->mappings['style'] = function ($value) {
+        $this->mappings['style'] = function($value) {
             $this->sheetWrapper->getObject()->getStyle($this->object->getCoordinate())->applyFromArray($value);
         };
-        $this->mappings['url'] = function ($value) {
+        $this->mappings['url'] = function($value) {
             $this->object->getHyperlink()->setUrl($value);
         };
-        $this->mappings['merge'] = function ($value) {
+        $this->mappings['merge'] = function($value) {
             $this->sheetWrapper->getObject()->mergeCells($this->object->getCoordinate().':'.$value.$this->sheetWrapper->getRow());
         };
     }

Braces +36 added lines, -18 removed lines

@@ -57,58 +57,76 @@
 
     protected function initializeMappings()
     {
-        $this->mappings['break'] = function ($value) {
+        $this->mappings['break'] = function ($value)
+        {
             $this->sheetWrapper->getObject()->setBreak($this->object->getCoordinate(), $value);
         };
-        $this->mappings['dataType'] = function ($value) {
+        $this->mappings['dataType'] = function ($value)
+        {
             $this->object->setDataType($value);
         };
-        $this->mappings['dataValidation']['allowBlank'] = function ($value) {
+        $this->mappings['dataValidation']['allowBlank'] = function ($value)
+        {
             $this->object->getDataValidation()->setAllowBlank($value);
         };
-        $this->mappings['dataValidation']['error'] = function ($value) {
+        $this->mappings['dataValidation']['error'] = function ($value)
+        {
             $this->object->getDataValidation()->setError($value);
         };
-        $this->mappings['dataValidation']['errorStyle'] = function ($value) {
+        $this->mappings['dataValidation']['errorStyle'] = function ($value)
+        {
             $this->object->getDataValidation()->setErrorStyle($value);
         };
-        $this->mappings['dataValidation']['errorTitle'] = function ($value) {
+        $this->mappings['dataValidation']['errorTitle'] = function ($value)
+        {
             $this->object->getDataValidation()->setErrorTitle($value);
         };
-        $this->mappings['dataValidation']['formula1'] = function ($value) {
+        $this->mappings['dataValidation']['formula1'] = function ($value)
+        {
             $this->object->getDataValidation()->setFormula1($value);
         };
-        $this->mappings['dataValidation']['formula2'] = function ($value) {
+        $this->mappings['dataValidation']['formula2'] = function ($value)
+        {
             $this->object->getDataValidation()->setFormula2($value);
         };
-        $this->mappings['dataValidation']['operator'] = function ($value) {
+        $this->mappings['dataValidation']['operator'] = function ($value)
+        {
             $this->object->getDataValidation()->setOperator($value);
         };
-        $this->mappings['dataValidation']['prompt'] = function ($value) {
+        $this->mappings['dataValidation']['prompt'] = function ($value)
+        {
             $this->object->getDataValidation()->setPrompt($value);
         };
-        $this->mappings['dataValidation']['promptTitle'] = function ($value) {
+        $this->mappings['dataValidation']['promptTitle'] = function ($value)
+        {
             $this->object->getDataValidation()->setPromptTitle($value);
         };
-        $this->mappings['dataValidation']['showDropDown'] = function ($value) {
+        $this->mappings['dataValidation']['showDropDown'] = function ($value)
+        {
             $this->object->getDataValidation()->setShowDropDown($value);
         };
-        $this->mappings['dataValidation']['showErrorMessage'] = function ($value) {
+        $this->mappings['dataValidation']['showErrorMessage'] = function ($value)
+        {
             $this->object->getDataValidation()->setShowErrorMessage($value);
         };
-        $this->mappings['dataValidation']['showInputMessage'] = function ($value) {
+        $this->mappings['dataValidation']['showInputMessage'] = function ($value)
+        {
             $this->object->getDataValidation()->setShowInputMessage($value);
         };
-        $this->mappings['dataValidation']['type'] = function ($value) {
+        $this->mappings['dataValidation']['type'] = function ($value)
+        {
             $this->object->getDataValidation()->setType($value);
         };
-        $this->mappings['style'] = function ($value) {
+        $this->mappings['style'] = function ($value)
+        {
             $this->sheetWrapper->getObject()->getStyle($this->object->getCoordinate())->applyFromArray($value);
         };
-        $this->mappings['url'] = function ($value) {
+        $this->mappings['url'] = function ($value)
+        {
             $this->object->getHyperlink()->setUrl($value);
         };
-        $this->mappings['merge'] = function ($value) {
+        $this->mappings['merge'] = function ($value)
+        {
             $this->sheetWrapper->getObject()->mergeCells($this->object->getCoordinate().':'.$value.$this->sheetWrapper->getRow());
         };
     }