MewesK / TwigExcelBundle

Tests/Twig/BasicTwigTest.php

Spacing +1 added lines, -1 removed lines

@@ -352,7 +352,7 @@
     public function testDocumentTemplate($format)
     {
         try {
-            $document = $this->getDocument('documentTemplate.' . $format, $format);
+            $document = $this->getDocument('documentTemplate.'.$format, $format);
             static::assertNotNull($document, 'Document does not exist');
 
             $sheet = $document->getSheet(0);

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);