Subversion Repositories eFlore/Applications.cel

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
2390 jpm 1
<?php
2
/**
3
 * PHPExcel
4
 *
5
 * Copyright (c) 2006 - 2013 PHPExcel
6
 *
7
 * This library is free software; you can redistribute it and/or
8
 * modify it under the terms of the GNU Lesser General Public
9
 * License as published by the Free Software Foundation; either
10
 * version 2.1 of the License, or (at your option) any later version.
11
 *
12
 * This library is distributed in the hope that it will be useful,
13
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
15
 * Lesser General Public License for more details.
16
 *
17
 * You should have received a copy of the GNU Lesser General Public
18
 * License along with this library; if not, write to the Free Software
19
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
20
 *
21
 * @category   PHPExcel
22
 * @package    PHPExcel_Worksheet
23
 * @copyright  Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel)
24
 * @license    http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt	LGPL
25
 * @version    ##VERSION##, ##DATE##
26
 */
27
 
28
 
29
/**
30
 * PHPExcel_Worksheet_SheetView
31
 *
32
 * @category   PHPExcel
33
 * @package    PHPExcel_Worksheet
34
 * @copyright  Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel)
35
 */
36
class PHPExcel_Worksheet_SheetView
37
{
38
 
39
	/* Sheet View types */
40
	const SHEETVIEW_NORMAL				= 'normal';
41
	const SHEETVIEW_PAGE_LAYOUT			= 'pageLayout';
42
	const SHEETVIEW_PAGE_BREAK_PREVIEW	= 'pageBreakPreview';
43
 
44
	private static $_sheetViewTypes = array(
45
		self::SHEETVIEW_NORMAL,
46
		self::SHEETVIEW_PAGE_LAYOUT,
47
		self::SHEETVIEW_PAGE_BREAK_PREVIEW,
48
	);
49
 
50
	/**
51
	 * ZoomScale
52
	 *
53
	 * Valid values range from 10 to 400.
54
	 *
55
	 * @var int
56
	 */
57
	private $_zoomScale			= 100;
58
 
59
	/**
60
	 * ZoomScaleNormal
61
	 *
62
	 * Valid values range from 10 to 400.
63
	 *
64
	 * @var int
65
	 */
66
	private $_zoomScaleNormal	= 100;
67
 
68
	/**
69
	 * View
70
	 *
71
	 * Valid values range from 10 to 400.
72
	 *
73
	 * @var string
74
	 */
75
	private $_sheetviewType		= self::SHEETVIEW_NORMAL;
76
 
77
    /**
78
     * Create a new PHPExcel_Worksheet_SheetView
79
     */
80
    public function __construct()
81
    {
82
    }
83
 
84
	/**
85
	 * Get ZoomScale
86
	 *
87
	 * @return int
88
	 */
89
	public function getZoomScale() {
90
		return $this->_zoomScale;
91
	}
92
 
93
	/**
94
	 * Set ZoomScale
95
	 *
96
	 * Valid values range from 10 to 400.
97
	 *
98
	 * @param 	int 	$pValue
99
	 * @throws 	PHPExcel_Exception
100
	 * @return PHPExcel_Worksheet_SheetView
101
	 */
102
	public function setZoomScale($pValue = 100) {
103
		// Microsoft Office Excel 2007 only allows setting a scale between 10 and 400 via the user interface,
104
		// but it is apparently still able to handle any scale >= 1
105
		if (($pValue >= 1) || is_null($pValue)) {
106
			$this->_zoomScale = $pValue;
107
		} else {
108
			throw new PHPExcel_Exception("Scale must be greater than or equal to 1.");
109
		}
110
		return $this;
111
	}
112
 
113
	/**
114
	 * Get ZoomScaleNormal
115
	 *
116
	 * @return int
117
	 */
118
	public function getZoomScaleNormal() {
119
		return $this->_zoomScaleNormal;
120
	}
121
 
122
	/**
123
	 * Set ZoomScale
124
	 *
125
	 * Valid values range from 10 to 400.
126
	 *
127
	 * @param 	int 	$pValue
128
	 * @throws 	PHPExcel_Exception
129
	 * @return PHPExcel_Worksheet_SheetView
130
	 */
131
	public function setZoomScaleNormal($pValue = 100) {
132
		if (($pValue >= 1) || is_null($pValue)) {
133
			$this->_zoomScaleNormal = $pValue;
134
		} else {
135
			throw new PHPExcel_Exception("Scale must be greater than or equal to 1.");
136
		}
137
		return $this;
138
	}
139
 
140
	/**
141
	 * Get View
142
	 *
143
	 * @return string
144
	 */
145
	public function getView() {
146
		return $this->_sheetviewType;
147
	}
148
 
149
	/**
150
	 * Set View
151
	 *
152
	 * Valid values are
153
	 *		'normal'			self::SHEETVIEW_NORMAL
154
	 *		'pageLayout'		self::SHEETVIEW_PAGE_LAYOUT
155
	 *		'pageBreakPreview'	self::SHEETVIEW_PAGE_BREAK_PREVIEW
156
	 *
157
	 * @param 	string 	$pValue
158
	 * @throws 	PHPExcel_Exception
159
	 * @return PHPExcel_Worksheet_SheetView
160
	 */
161
	public function setView($pValue = NULL) {
162
		//	MS Excel 2007 allows setting the view to 'normal', 'pageLayout' or 'pageBreakPreview'
163
		//		via the user interface
164
		if ($pValue === NULL)
165
			$pValue = self::SHEETVIEW_NORMAL;
166
		if (in_array($pValue, self::$_sheetViewTypes)) {
167
			$this->_sheetviewType = $pValue;
168
		} else {
169
			throw new PHPExcel_Exception("Invalid sheetview layout type.");
170
		}
171
 
172
		return $this;
173
	}
174
 
175
	/**
176
	 * Implement PHP __clone to create a deep clone, not just a shallow copy.
177
	 */
178
	public function __clone() {
179
		$vars = get_object_vars($this);
180
		foreach ($vars as $key => $value) {
181
			if (is_object($value)) {
182
				$this->$key = clone $value;
183
			} else {
184
				$this->$key = $value;
185
			}
186
		}
187
	}
188
}