1: <?php
2: /**
3: * LICENSE (BSD)
4: *
5: * Copyright (c) 2013, Gerd Christian Kunze
6: * All rights reserved.
7: *
8: * Redistribution and use in source and binary forms, with or without
9: * modification, are permitted provided that the following conditions are
10: * met:
11: *
12: * * Redistributions of source code must retain the above copyright
13: * notice, this list of conditions and the following disclaimer.
14: *
15: * * Redistributions in binary form must reproduce the above copyright
16: * notice, this list of conditions and the following disclaimer in the
17: * documentation and/or other materials provided with the distribution.
18: *
19: * * Neither the name of Gerd Christian Kunze nor the names of the
20: * contributors may be used to endorse or promote products derived from
21: * this software without specific prior written permission.
22: *
23: * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS
24: * IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,
25: * THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
26: * PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
27: * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
28: * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
29: * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
30: * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
31: * LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
32: * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
33: * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
34: *
35: * Style
36: * 25.02.2013 16:06
37: */
38: namespace MOC\Module\Office\Document\Excel\Cell;
39: use MOC\Api;
40: use MOC\Generic\Device\Module;
41:
42: /**
43: *
44: */
45: class Style implements Module {
46: /**
47: * Get Changelog
48: *
49: * @static
50: * @return \MOC\Core\Changelog
51: */
52: public static function InterfaceChangelog() {
53: return Api::Core()->Changelog()->Create( __CLASS__ );
54: }
55:
56: /**
57: * Get Dependencies
58: *
59: * @static
60: * @return \MOC\Core\Depending
61: */
62: public static function InterfaceDepending() {
63: return Api::Core()->Depending();
64: }
65:
66: /**
67: * Get Singleton/Instance
68: *
69: * @static
70: * @return Style
71: */
72: public static function InterfaceInstance() {
73: return new Style();
74: }
75:
76: /**
77: * @return Style\Border
78: */
79: public function Border() {
80: return Style\Border::InterfaceInstance();
81: }
82:
83: /**
84: * @return Style\Font
85: */
86: public function Font() {
87: return Style\Font::InterfaceInstance();
88: }
89:
90: /**
91: * @return Style\Align
92: */
93: public function Align() {
94: return Style\Align::InterfaceInstance();
95: }
96:
97: /**
98: * @return Style\Color
99: */
100: public function Color() {
101: return Style\Color::InterfaceInstance();
102: }
103:
104: /**
105: * @return Style\Width
106: */
107: public function Width() {
108: return Style\Width::InterfaceInstance();
109: }
110:
111: /**
112: * e.g Current-Cell = 'A1' and $CellRightBottom = 'B2' -> 'A1:B2' will merge 'A1,B1,A2,B2' into one cell
113: *
114: * EVERY FOLLOWING ACTION FOR THIS MERGED CELL MUST BE EXECUTED AT (in this case) 'A1' !!!
115: *
116: * BECAUSE ITS THE ORIGIN CELL FOR THIS RANGE
117: *
118: * @param string $CellRightBottom
119: *
120: * @return \MOC\Module\Office\Document\Excel
121: */
122: public function Merge( $CellRightBottom ) {
123: $this->getActiveSheet()->mergeCells(
124: $this->getCell()->getCoordinate().':'.$CellRightBottom
125: );
126: return Api::Module()->Office()->Document()->Excel();
127: }
128:
129: /**
130: * Wrap cell content
131: *
132: * @static
133: * @param bool $Toggle
134: *
135: * @return \MOC\Module\Office\Document\Excel
136: */
137: public function Wrap( $Toggle = true ) {
138: $this->getActiveSheet()->getStyle( $this->getCell()->getCoordinate() )->getAlignment()->setWrapText( $Toggle );
139: return Api::Module()->Office()->Document()->Excel();
140: }
141:
142: /**
143: * @return \PHPExcel_Worksheet
144: */
145: private function getActiveSheet() {
146: return Api::Extension()->Excel()->Current()->getActiveSheet();
147: }
148:
149: /**
150: * @return \PHPExcel_Cell
151: */
152: private function getCell() {
153: return Api::Extension()->Excel()->Current()
154: ->getActiveSheet()
155: ->getCell(
156: Api::Module()->Office()->Document()->Excel()
157: ->Cell()->Select()->Current()
158: );
159: }
160: }
161: