@@ -60,61 +60,61 @@ |
||
60 | 60 | |
61 | 61 | protected function initializeMappings() |
62 | 62 | { |
63 | - $this->mappings['break'] = function ($value) { |
|
63 | + $this->mappings['break'] = function($value) { |
|
64 | 64 | $this->sheetWrapper->getObject()->setBreak($this->object->getCoordinate(), $value); |
65 | 65 | }; |
66 | - $this->mappings['dataType'] = function ($value) { |
|
66 | + $this->mappings['dataType'] = function($value) { |
|
67 | 67 | $this->object->setDataType($value); |
68 | 68 | }; |
69 | - $this->mappings['dataValidation']['allowBlank'] = function ($value) { |
|
69 | + $this->mappings['dataValidation']['allowBlank'] = function($value) { |
|
70 | 70 | $this->object->getDataValidation()->setAllowBlank($value); |
71 | 71 | }; |
72 | - $this->mappings['dataValidation']['error'] = function ($value) { |
|
72 | + $this->mappings['dataValidation']['error'] = function($value) { |
|
73 | 73 | $this->object->getDataValidation()->setError($value); |
74 | 74 | }; |
75 | - $this->mappings['dataValidation']['errorStyle'] = function ($value) { |
|
75 | + $this->mappings['dataValidation']['errorStyle'] = function($value) { |
|
76 | 76 | $this->object->getDataValidation()->setErrorStyle($value); |
77 | 77 | }; |
78 | - $this->mappings['dataValidation']['errorTitle'] = function ($value) { |
|
78 | + $this->mappings['dataValidation']['errorTitle'] = function($value) { |
|
79 | 79 | $this->object->getDataValidation()->setErrorTitle($value); |
80 | 80 | }; |
81 | - $this->mappings['dataValidation']['formula1'] = function ($value) { |
|
81 | + $this->mappings['dataValidation']['formula1'] = function($value) { |
|
82 | 82 | $this->object->getDataValidation()->setFormula1($value); |
83 | 83 | }; |
84 | - $this->mappings['dataValidation']['formula2'] = function ($value) { |
|
84 | + $this->mappings['dataValidation']['formula2'] = function($value) { |
|
85 | 85 | $this->object->getDataValidation()->setFormula2($value); |
86 | 86 | }; |
87 | - $this->mappings['dataValidation']['operator'] = function ($value) { |
|
87 | + $this->mappings['dataValidation']['operator'] = function($value) { |
|
88 | 88 | $this->object->getDataValidation()->setOperator($value); |
89 | 89 | }; |
90 | - $this->mappings['dataValidation']['prompt'] = function ($value) { |
|
90 | + $this->mappings['dataValidation']['prompt'] = function($value) { |
|
91 | 91 | $this->object->getDataValidation()->setPrompt($value); |
92 | 92 | }; |
93 | - $this->mappings['dataValidation']['promptTitle'] = function ($value) { |
|
93 | + $this->mappings['dataValidation']['promptTitle'] = function($value) { |
|
94 | 94 | $this->object->getDataValidation()->setPromptTitle($value); |
95 | 95 | }; |
96 | - $this->mappings['dataValidation']['showDropDown'] = function ($value) { |
|
96 | + $this->mappings['dataValidation']['showDropDown'] = function($value) { |
|
97 | 97 | $this->object->getDataValidation()->setShowDropDown($value); |
98 | 98 | }; |
99 | - $this->mappings['dataValidation']['showErrorMessage'] = function ($value) { |
|
99 | + $this->mappings['dataValidation']['showErrorMessage'] = function($value) { |
|
100 | 100 | $this->object->getDataValidation()->setShowErrorMessage($value); |
101 | 101 | }; |
102 | - $this->mappings['dataValidation']['showInputMessage'] = function ($value) { |
|
102 | + $this->mappings['dataValidation']['showInputMessage'] = function($value) { |
|
103 | 103 | $this->object->getDataValidation()->setShowInputMessage($value); |
104 | 104 | }; |
105 | - $this->mappings['dataValidation']['type'] = function ($value) { |
|
105 | + $this->mappings['dataValidation']['type'] = function($value) { |
|
106 | 106 | $this->object->getDataValidation()->setType($value); |
107 | 107 | }; |
108 | - $this->mappings['merge'] = function ($value) { |
|
108 | + $this->mappings['merge'] = function($value) { |
|
109 | 109 | if (is_int($value)) { |
110 | - $value = PHPExcel_Cell::stringFromColumnIndex($value) . $this->sheetWrapper->getRow(); |
|
110 | + $value = PHPExcel_Cell::stringFromColumnIndex($value).$this->sheetWrapper->getRow(); |
|
111 | 111 | } |
112 | 112 | $this->sheetWrapper->getObject()->mergeCells(sprintf('%s:%s', $this->object->getCoordinate(), $value)); |
113 | 113 | }; |
114 | - $this->mappings['style'] = function ($value) { |
|
114 | + $this->mappings['style'] = function($value) { |
|
115 | 115 | $this->sheetWrapper->getObject()->getStyle($this->object->getCoordinate())->applyFromArray($value); |
116 | 116 | }; |
117 | - $this->mappings['url'] = function ($value) { |
|
117 | + $this->mappings['url'] = function($value) { |
|
118 | 118 | $this->object->getHyperlink()->setUrl($value); |
119 | 119 | }; |
120 | 120 | } |
@@ -60,61 +60,79 @@ |
||
60 | 60 | |
61 | 61 | protected function initializeMappings() |
62 | 62 | { |
63 | - $this->mappings['break'] = function ($value) { |
|
63 | + $this->mappings['break'] = function ($value) |
|
64 | + { |
|
64 | 65 | $this->sheetWrapper->getObject()->setBreak($this->object->getCoordinate(), $value); |
65 | 66 | }; |
66 | - $this->mappings['dataType'] = function ($value) { |
|
67 | + $this->mappings['dataType'] = function ($value) |
|
68 | + { |
|
67 | 69 | $this->object->setDataType($value); |
68 | 70 | }; |
69 | - $this->mappings['dataValidation']['allowBlank'] = function ($value) { |
|
71 | + $this->mappings['dataValidation']['allowBlank'] = function ($value) |
|
72 | + { |
|
70 | 73 | $this->object->getDataValidation()->setAllowBlank($value); |
71 | 74 | }; |
72 | - $this->mappings['dataValidation']['error'] = function ($value) { |
|
75 | + $this->mappings['dataValidation']['error'] = function ($value) |
|
76 | + { |
|
73 | 77 | $this->object->getDataValidation()->setError($value); |
74 | 78 | }; |
75 | - $this->mappings['dataValidation']['errorStyle'] = function ($value) { |
|
79 | + $this->mappings['dataValidation']['errorStyle'] = function ($value) |
|
80 | + { |
|
76 | 81 | $this->object->getDataValidation()->setErrorStyle($value); |
77 | 82 | }; |
78 | - $this->mappings['dataValidation']['errorTitle'] = function ($value) { |
|
83 | + $this->mappings['dataValidation']['errorTitle'] = function ($value) |
|
84 | + { |
|
79 | 85 | $this->object->getDataValidation()->setErrorTitle($value); |
80 | 86 | }; |
81 | - $this->mappings['dataValidation']['formula1'] = function ($value) { |
|
87 | + $this->mappings['dataValidation']['formula1'] = function ($value) |
|
88 | + { |
|
82 | 89 | $this->object->getDataValidation()->setFormula1($value); |
83 | 90 | }; |
84 | - $this->mappings['dataValidation']['formula2'] = function ($value) { |
|
91 | + $this->mappings['dataValidation']['formula2'] = function ($value) |
|
92 | + { |
|
85 | 93 | $this->object->getDataValidation()->setFormula2($value); |
86 | 94 | }; |
87 | - $this->mappings['dataValidation']['operator'] = function ($value) { |
|
95 | + $this->mappings['dataValidation']['operator'] = function ($value) |
|
96 | + { |
|
88 | 97 | $this->object->getDataValidation()->setOperator($value); |
89 | 98 | }; |
90 | - $this->mappings['dataValidation']['prompt'] = function ($value) { |
|
99 | + $this->mappings['dataValidation']['prompt'] = function ($value) |
|
100 | + { |
|
91 | 101 | $this->object->getDataValidation()->setPrompt($value); |
92 | 102 | }; |
93 | - $this->mappings['dataValidation']['promptTitle'] = function ($value) { |
|
103 | + $this->mappings['dataValidation']['promptTitle'] = function ($value) |
|
104 | + { |
|
94 | 105 | $this->object->getDataValidation()->setPromptTitle($value); |
95 | 106 | }; |
96 | - $this->mappings['dataValidation']['showDropDown'] = function ($value) { |
|
107 | + $this->mappings['dataValidation']['showDropDown'] = function ($value) |
|
108 | + { |
|
97 | 109 | $this->object->getDataValidation()->setShowDropDown($value); |
98 | 110 | }; |
99 | - $this->mappings['dataValidation']['showErrorMessage'] = function ($value) { |
|
111 | + $this->mappings['dataValidation']['showErrorMessage'] = function ($value) |
|
112 | + { |
|
100 | 113 | $this->object->getDataValidation()->setShowErrorMessage($value); |
101 | 114 | }; |
102 | - $this->mappings['dataValidation']['showInputMessage'] = function ($value) { |
|
115 | + $this->mappings['dataValidation']['showInputMessage'] = function ($value) |
|
116 | + { |
|
103 | 117 | $this->object->getDataValidation()->setShowInputMessage($value); |
104 | 118 | }; |
105 | - $this->mappings['dataValidation']['type'] = function ($value) { |
|
119 | + $this->mappings['dataValidation']['type'] = function ($value) |
|
120 | + { |
|
106 | 121 | $this->object->getDataValidation()->setType($value); |
107 | 122 | }; |
108 | - $this->mappings['merge'] = function ($value) { |
|
123 | + $this->mappings['merge'] = function ($value) |
|
124 | + { |
|
109 | 125 | if (is_int($value)) { |
110 | 126 | $value = PHPExcel_Cell::stringFromColumnIndex($value) . $this->sheetWrapper->getRow(); |
111 | 127 | } |
112 | 128 | $this->sheetWrapper->getObject()->mergeCells(sprintf('%s:%s', $this->object->getCoordinate(), $value)); |
113 | 129 | }; |
114 | - $this->mappings['style'] = function ($value) { |
|
130 | + $this->mappings['style'] = function ($value) |
|
131 | + { |
|
115 | 132 | $this->sheetWrapper->getObject()->getStyle($this->object->getCoordinate())->applyFromArray($value); |
116 | 133 | }; |
117 | - $this->mappings['url'] = function ($value) { |
|
134 | + $this->mappings['url'] = function ($value) |
|
135 | + { |
|
118 | 136 | $this->object->getHyperlink()->setUrl($value); |
119 | 137 | }; |
120 | 138 | } |