@@ -42,82 +42,82 @@ discard block |
||
| 42 | 42 | */ |
| 43 | 43 | private $_path; |
| 44 | 44 | |
| 45 | - /** |
|
| 46 | - * Create a new PHPExcel_Worksheet_Drawing |
|
| 47 | - */ |
|
| 48 | - public function __construct() |
|
| 49 | - { |
|
| 50 | - // Initialise values |
|
| 51 | - $this->_path = ''; |
|
| 45 | + /** |
|
| 46 | + * Create a new PHPExcel_Worksheet_Drawing |
|
| 47 | + */ |
|
| 48 | + public function __construct() |
|
| 49 | + { |
|
| 50 | + // Initialise values |
|
| 51 | + $this->_path = ''; |
|
| 52 | 52 | |
| 53 | - // Initialize parent |
|
| 54 | - parent::__construct(); |
|
| 55 | - } |
|
| 53 | + // Initialize parent |
|
| 54 | + parent::__construct(); |
|
| 55 | + } |
|
| 56 | 56 | |
| 57 | - /** |
|
| 58 | - * Get Filename |
|
| 59 | - * |
|
| 60 | - * @return string |
|
| 61 | - */ |
|
| 62 | - public function getFilename() { |
|
| 63 | - return basename($this->_path); |
|
| 64 | - } |
|
| 57 | + /** |
|
| 58 | + * Get Filename |
|
| 59 | + * |
|
| 60 | + * @return string |
|
| 61 | + */ |
|
| 62 | + public function getFilename() { |
|
| 63 | + return basename($this->_path); |
|
| 64 | + } |
|
| 65 | 65 | |
| 66 | - /** |
|
| 67 | - * Get indexed filename (using image index) |
|
| 68 | - * |
|
| 69 | - * @return string |
|
| 70 | - */ |
|
| 71 | - public function getIndexedFilename() { |
|
| 72 | - $fileName = $this->getFilename(); |
|
| 73 | - $fileName = str_replace(' ', '_', $fileName); |
|
| 74 | - return str_replace('.' . $this->getExtension(), '', $fileName) . $this->getImageIndex() . '.' . $this->getExtension(); |
|
| 75 | - } |
|
| 66 | + /** |
|
| 67 | + * Get indexed filename (using image index) |
|
| 68 | + * |
|
| 69 | + * @return string |
|
| 70 | + */ |
|
| 71 | + public function getIndexedFilename() { |
|
| 72 | + $fileName = $this->getFilename(); |
|
| 73 | + $fileName = str_replace(' ', '_', $fileName); |
|
| 74 | + return str_replace('.' . $this->getExtension(), '', $fileName) . $this->getImageIndex() . '.' . $this->getExtension(); |
|
| 75 | + } |
|
| 76 | 76 | |
| 77 | - /** |
|
| 78 | - * Get Extension |
|
| 79 | - * |
|
| 80 | - * @return string |
|
| 81 | - */ |
|
| 82 | - public function getExtension() { |
|
| 83 | - $exploded = explode(".", basename($this->_path)); |
|
| 84 | - return $exploded[count($exploded) - 1]; |
|
| 85 | - } |
|
| 77 | + /** |
|
| 78 | + * Get Extension |
|
| 79 | + * |
|
| 80 | + * @return string |
|
| 81 | + */ |
|
| 82 | + public function getExtension() { |
|
| 83 | + $exploded = explode(".", basename($this->_path)); |
|
| 84 | + return $exploded[count($exploded) - 1]; |
|
| 85 | + } |
|
| 86 | 86 | |
| 87 | - /** |
|
| 88 | - * Get Path |
|
| 89 | - * |
|
| 90 | - * @return string |
|
| 91 | - */ |
|
| 92 | - public function getPath() { |
|
| 93 | - return $this->_path; |
|
| 94 | - } |
|
| 87 | + /** |
|
| 88 | + * Get Path |
|
| 89 | + * |
|
| 90 | + * @return string |
|
| 91 | + */ |
|
| 92 | + public function getPath() { |
|
| 93 | + return $this->_path; |
|
| 94 | + } |
|
| 95 | 95 | |
| 96 | - /** |
|
| 97 | - * Set Path |
|
| 98 | - * |
|
| 99 | - * @param string $pValue File path |
|
| 100 | - * @param boolean $pVerifyFile Verify file |
|
| 101 | - * @throws Exception |
|
| 102 | - * @return PHPExcel_Worksheet_Drawing |
|
| 103 | - */ |
|
| 104 | - public function setPath($pValue = '', $pVerifyFile = true) { |
|
| 105 | - if ($pVerifyFile) { |
|
| 106 | - if (file_exists($pValue)) { |
|
| 107 | - $this->_path = $pValue; |
|
| 96 | + /** |
|
| 97 | + * Set Path |
|
| 98 | + * |
|
| 99 | + * @param string $pValue File path |
|
| 100 | + * @param boolean $pVerifyFile Verify file |
|
| 101 | + * @throws Exception |
|
| 102 | + * @return PHPExcel_Worksheet_Drawing |
|
| 103 | + */ |
|
| 104 | + public function setPath($pValue = '', $pVerifyFile = true) { |
|
| 105 | + if ($pVerifyFile) { |
|
| 106 | + if (file_exists($pValue)) { |
|
| 107 | + $this->_path = $pValue; |
|
| 108 | 108 | |
| 109 | - if ($this->_width == 0 && $this->_height == 0) { |
|
| 110 | - // Get width/height |
|
| 111 | - list($this->_width, $this->_height) = getimagesize($pValue); |
|
| 112 | - } |
|
| 113 | - } else { |
|
| 114 | - throw new Exception("File $pValue not found!"); |
|
| 115 | - } |
|
| 116 | - } else { |
|
| 117 | - $this->_path = $pValue; |
|
| 118 | - } |
|
| 119 | - return $this; |
|
| 120 | - } |
|
| 109 | + if ($this->_width == 0 && $this->_height == 0) { |
|
| 110 | + // Get width/height |
|
| 111 | + list($this->_width, $this->_height) = getimagesize($pValue); |
|
| 112 | + } |
|
| 113 | + } else { |
|
| 114 | + throw new Exception("File $pValue not found!"); |
|
| 115 | + } |
|
| 116 | + } else { |
|
| 117 | + $this->_path = $pValue; |
|
| 118 | + } |
|
| 119 | + return $this; |
|
| 120 | + } |
|
| 121 | 121 | |
| 122 | 122 | /** |
| 123 | 123 | * Get hash code |
@@ -125,12 +125,12 @@ discard block |
||
| 125 | 125 | * @return string Hash code |
| 126 | 126 | */ |
| 127 | 127 | public function getHashCode() { |
| 128 | - return md5( |
|
| 129 | - $this->_path |
|
| 130 | - . parent::getHashCode() |
|
| 131 | - . __CLASS__ |
|
| 132 | - ); |
|
| 133 | - } |
|
| 128 | + return md5( |
|
| 129 | + $this->_path |
|
| 130 | + . parent::getHashCode() |
|
| 131 | + . __CLASS__ |
|
| 132 | + ); |
|
| 133 | + } |
|
| 134 | 134 | |
| 135 | 135 | /** |
| 136 | 136 | * Implement PHP __clone to create a deep clone, not just a shallow copy. |
@@ -48,7 +48,7 @@ discard block |
||
| 48 | 48 | public function __construct() |
| 49 | 49 | { |
| 50 | 50 | // Initialise values |
| 51 | - $this->_path = ''; |
|
| 51 | + $this->_path = ''; |
|
| 52 | 52 | |
| 53 | 53 | // Initialize parent |
| 54 | 54 | parent::__construct(); |
@@ -71,7 +71,7 @@ discard block |
||
| 71 | 71 | public function getIndexedFilename() { |
| 72 | 72 | $fileName = $this->getFilename(); |
| 73 | 73 | $fileName = str_replace(' ', '_', $fileName); |
| 74 | - return str_replace('.' . $this->getExtension(), '', $fileName) . $this->getImageIndex() . '.' . $this->getExtension(); |
|
| 74 | + return str_replace('.'.$this->getExtension(), '', $fileName).$this->getImageIndex().'.'.$this->getExtension(); |
|
| 75 | 75 | } |
| 76 | 76 | |
| 77 | 77 | /** |
@@ -37,13 +37,13 @@ discard block |
||
| 37 | 37 | { |
| 38 | 38 | /* Shadow alignment */ |
| 39 | 39 | const SHADOW_BOTTOM = 'b'; |
| 40 | - const SHADOW_BOTTOM_LEFT = 'bl'; |
|
| 41 | - const SHADOW_BOTTOM_RIGHT = 'br'; |
|
| 40 | + const SHADOW_BOTTOM_LEFT = 'bl'; |
|
| 41 | + const SHADOW_BOTTOM_RIGHT = 'br'; |
|
| 42 | 42 | const SHADOW_CENTER = 'ctr'; |
| 43 | - const SHADOW_LEFT = 'l'; |
|
| 44 | - const SHADOW_TOP = 't'; |
|
| 45 | - const SHADOW_TOP_LEFT = 'tl'; |
|
| 46 | - const SHADOW_TOP_RIGHT = 'tr'; |
|
| 43 | + const SHADOW_LEFT = 'l'; |
|
| 44 | + const SHADOW_TOP = 't'; |
|
| 45 | + const SHADOW_TOP_LEFT = 'tl'; |
|
| 46 | + const SHADOW_TOP_RIGHT = 'tr'; |
|
| 47 | 47 | |
| 48 | 48 | /** |
| 49 | 49 | * Visible |
@@ -105,7 +105,7 @@ discard block |
||
| 105 | 105 | { |
| 106 | 106 | // Initialise values |
| 107 | 107 | $this->_visible = false; |
| 108 | - $this->_blurRadius = 6; |
|
| 108 | + $this->_blurRadius = 6; |
|
| 109 | 109 | $this->_distance = 2; |
| 110 | 110 | $this->_direction = 0; |
| 111 | 111 | $this->_alignment = PHPExcel_Worksheet_Drawing_Shadow::SHADOW_BOTTOM_RIGHT; |
@@ -98,161 +98,161 @@ discard block |
||
| 98 | 98 | */ |
| 99 | 99 | private $_alpha; |
| 100 | 100 | |
| 101 | - /** |
|
| 102 | - * Create a new PHPExcel_Worksheet_Drawing_Shadow |
|
| 103 | - */ |
|
| 104 | - public function __construct() |
|
| 105 | - { |
|
| 106 | - // Initialise values |
|
| 107 | - $this->_visible = false; |
|
| 108 | - $this->_blurRadius = 6; |
|
| 109 | - $this->_distance = 2; |
|
| 110 | - $this->_direction = 0; |
|
| 111 | - $this->_alignment = PHPExcel_Worksheet_Drawing_Shadow::SHADOW_BOTTOM_RIGHT; |
|
| 112 | - $this->_color = new PHPExcel_Style_Color(PHPExcel_Style_Color::COLOR_BLACK); |
|
| 113 | - $this->_alpha = 50; |
|
| 114 | - } |
|
| 101 | + /** |
|
| 102 | + * Create a new PHPExcel_Worksheet_Drawing_Shadow |
|
| 103 | + */ |
|
| 104 | + public function __construct() |
|
| 105 | + { |
|
| 106 | + // Initialise values |
|
| 107 | + $this->_visible = false; |
|
| 108 | + $this->_blurRadius = 6; |
|
| 109 | + $this->_distance = 2; |
|
| 110 | + $this->_direction = 0; |
|
| 111 | + $this->_alignment = PHPExcel_Worksheet_Drawing_Shadow::SHADOW_BOTTOM_RIGHT; |
|
| 112 | + $this->_color = new PHPExcel_Style_Color(PHPExcel_Style_Color::COLOR_BLACK); |
|
| 113 | + $this->_alpha = 50; |
|
| 114 | + } |
|
| 115 | 115 | |
| 116 | - /** |
|
| 117 | - * Get Visible |
|
| 118 | - * |
|
| 119 | - * @return boolean |
|
| 120 | - */ |
|
| 121 | - public function getVisible() { |
|
| 122 | - return $this->_visible; |
|
| 123 | - } |
|
| 116 | + /** |
|
| 117 | + * Get Visible |
|
| 118 | + * |
|
| 119 | + * @return boolean |
|
| 120 | + */ |
|
| 121 | + public function getVisible() { |
|
| 122 | + return $this->_visible; |
|
| 123 | + } |
|
| 124 | 124 | |
| 125 | - /** |
|
| 126 | - * Set Visible |
|
| 127 | - * |
|
| 128 | - * @param boolean $pValue |
|
| 129 | - * @return PHPExcel_Worksheet_Drawing_Shadow |
|
| 130 | - */ |
|
| 131 | - public function setVisible($pValue = false) { |
|
| 132 | - $this->_visible = $pValue; |
|
| 133 | - return $this; |
|
| 134 | - } |
|
| 125 | + /** |
|
| 126 | + * Set Visible |
|
| 127 | + * |
|
| 128 | + * @param boolean $pValue |
|
| 129 | + * @return PHPExcel_Worksheet_Drawing_Shadow |
|
| 130 | + */ |
|
| 131 | + public function setVisible($pValue = false) { |
|
| 132 | + $this->_visible = $pValue; |
|
| 133 | + return $this; |
|
| 134 | + } |
|
| 135 | 135 | |
| 136 | - /** |
|
| 137 | - * Get Blur radius |
|
| 138 | - * |
|
| 139 | - * @return int |
|
| 140 | - */ |
|
| 141 | - public function getBlurRadius() { |
|
| 142 | - return $this->_blurRadius; |
|
| 143 | - } |
|
| 136 | + /** |
|
| 137 | + * Get Blur radius |
|
| 138 | + * |
|
| 139 | + * @return int |
|
| 140 | + */ |
|
| 141 | + public function getBlurRadius() { |
|
| 142 | + return $this->_blurRadius; |
|
| 143 | + } |
|
| 144 | 144 | |
| 145 | - /** |
|
| 146 | - * Set Blur radius |
|
| 147 | - * |
|
| 148 | - * @param int $pValue |
|
| 149 | - * @return PHPExcel_Worksheet_Drawing_Shadow |
|
| 150 | - */ |
|
| 151 | - public function setBlurRadius($pValue = 6) { |
|
| 152 | - $this->_blurRadius = $pValue; |
|
| 153 | - return $this; |
|
| 154 | - } |
|
| 145 | + /** |
|
| 146 | + * Set Blur radius |
|
| 147 | + * |
|
| 148 | + * @param int $pValue |
|
| 149 | + * @return PHPExcel_Worksheet_Drawing_Shadow |
|
| 150 | + */ |
|
| 151 | + public function setBlurRadius($pValue = 6) { |
|
| 152 | + $this->_blurRadius = $pValue; |
|
| 153 | + return $this; |
|
| 154 | + } |
|
| 155 | 155 | |
| 156 | - /** |
|
| 157 | - * Get Shadow distance |
|
| 158 | - * |
|
| 159 | - * @return int |
|
| 160 | - */ |
|
| 161 | - public function getDistance() { |
|
| 162 | - return $this->_distance; |
|
| 163 | - } |
|
| 156 | + /** |
|
| 157 | + * Get Shadow distance |
|
| 158 | + * |
|
| 159 | + * @return int |
|
| 160 | + */ |
|
| 161 | + public function getDistance() { |
|
| 162 | + return $this->_distance; |
|
| 163 | + } |
|
| 164 | 164 | |
| 165 | - /** |
|
| 166 | - * Set Shadow distance |
|
| 167 | - * |
|
| 168 | - * @param int $pValue |
|
| 169 | - * @return PHPExcel_Worksheet_Drawing_Shadow |
|
| 170 | - */ |
|
| 171 | - public function setDistance($pValue = 2) { |
|
| 172 | - $this->_distance = $pValue; |
|
| 173 | - return $this; |
|
| 174 | - } |
|
| 165 | + /** |
|
| 166 | + * Set Shadow distance |
|
| 167 | + * |
|
| 168 | + * @param int $pValue |
|
| 169 | + * @return PHPExcel_Worksheet_Drawing_Shadow |
|
| 170 | + */ |
|
| 171 | + public function setDistance($pValue = 2) { |
|
| 172 | + $this->_distance = $pValue; |
|
| 173 | + return $this; |
|
| 174 | + } |
|
| 175 | 175 | |
| 176 | - /** |
|
| 177 | - * Get Shadow direction (in degrees) |
|
| 178 | - * |
|
| 179 | - * @return int |
|
| 180 | - */ |
|
| 181 | - public function getDirection() { |
|
| 182 | - return $this->_direction; |
|
| 183 | - } |
|
| 176 | + /** |
|
| 177 | + * Get Shadow direction (in degrees) |
|
| 178 | + * |
|
| 179 | + * @return int |
|
| 180 | + */ |
|
| 181 | + public function getDirection() { |
|
| 182 | + return $this->_direction; |
|
| 183 | + } |
|
| 184 | 184 | |
| 185 | - /** |
|
| 186 | - * Set Shadow direction (in degrees) |
|
| 187 | - * |
|
| 188 | - * @param int $pValue |
|
| 189 | - * @return PHPExcel_Worksheet_Drawing_Shadow |
|
| 190 | - */ |
|
| 191 | - public function setDirection($pValue = 0) { |
|
| 192 | - $this->_direction = $pValue; |
|
| 193 | - return $this; |
|
| 194 | - } |
|
| 185 | + /** |
|
| 186 | + * Set Shadow direction (in degrees) |
|
| 187 | + * |
|
| 188 | + * @param int $pValue |
|
| 189 | + * @return PHPExcel_Worksheet_Drawing_Shadow |
|
| 190 | + */ |
|
| 191 | + public function setDirection($pValue = 0) { |
|
| 192 | + $this->_direction = $pValue; |
|
| 193 | + return $this; |
|
| 194 | + } |
|
| 195 | 195 | |
| 196 | 196 | /** |
| 197 | - * Get Shadow alignment |
|
| 198 | - * |
|
| 199 | - * @return int |
|
| 200 | - */ |
|
| 201 | - public function getAlignment() { |
|
| 202 | - return $this->_alignment; |
|
| 203 | - } |
|
| 197 | + * Get Shadow alignment |
|
| 198 | + * |
|
| 199 | + * @return int |
|
| 200 | + */ |
|
| 201 | + public function getAlignment() { |
|
| 202 | + return $this->_alignment; |
|
| 203 | + } |
|
| 204 | 204 | |
| 205 | - /** |
|
| 206 | - * Set Shadow alignment |
|
| 207 | - * |
|
| 208 | - * @param int $pValue |
|
| 209 | - * @return PHPExcel_Worksheet_Drawing_Shadow |
|
| 210 | - */ |
|
| 211 | - public function setAlignment($pValue = 0) { |
|
| 212 | - $this->_alignment = $pValue; |
|
| 213 | - return $this; |
|
| 214 | - } |
|
| 205 | + /** |
|
| 206 | + * Set Shadow alignment |
|
| 207 | + * |
|
| 208 | + * @param int $pValue |
|
| 209 | + * @return PHPExcel_Worksheet_Drawing_Shadow |
|
| 210 | + */ |
|
| 211 | + public function setAlignment($pValue = 0) { |
|
| 212 | + $this->_alignment = $pValue; |
|
| 213 | + return $this; |
|
| 214 | + } |
|
| 215 | 215 | |
| 216 | 216 | /** |
| 217 | - * Get Color |
|
| 218 | - * |
|
| 219 | - * @return PHPExcel_Style_Color |
|
| 220 | - */ |
|
| 221 | - public function getColor() { |
|
| 222 | - return $this->_color; |
|
| 223 | - } |
|
| 217 | + * Get Color |
|
| 218 | + * |
|
| 219 | + * @return PHPExcel_Style_Color |
|
| 220 | + */ |
|
| 221 | + public function getColor() { |
|
| 222 | + return $this->_color; |
|
| 223 | + } |
|
| 224 | 224 | |
| 225 | - /** |
|
| 226 | - * Set Color |
|
| 227 | - * |
|
| 228 | - * @param PHPExcel_Style_Color $pValue |
|
| 229 | - * @throws Exception |
|
| 230 | - * @return PHPExcel_Worksheet_Drawing_Shadow |
|
| 231 | - */ |
|
| 232 | - public function setColor(PHPExcel_Style_Color $pValue = null) { |
|
| 225 | + /** |
|
| 226 | + * Set Color |
|
| 227 | + * |
|
| 228 | + * @param PHPExcel_Style_Color $pValue |
|
| 229 | + * @throws Exception |
|
| 230 | + * @return PHPExcel_Worksheet_Drawing_Shadow |
|
| 231 | + */ |
|
| 232 | + public function setColor(PHPExcel_Style_Color $pValue = null) { |
|
| 233 | 233 | $this->_color = $pValue; |
| 234 | 234 | return $this; |
| 235 | - } |
|
| 235 | + } |
|
| 236 | 236 | |
| 237 | 237 | /** |
| 238 | - * Get Alpha |
|
| 239 | - * |
|
| 240 | - * @return int |
|
| 241 | - */ |
|
| 242 | - public function getAlpha() { |
|
| 243 | - return $this->_alpha; |
|
| 244 | - } |
|
| 238 | + * Get Alpha |
|
| 239 | + * |
|
| 240 | + * @return int |
|
| 241 | + */ |
|
| 242 | + public function getAlpha() { |
|
| 243 | + return $this->_alpha; |
|
| 244 | + } |
|
| 245 | 245 | |
| 246 | - /** |
|
| 247 | - * Set Alpha |
|
| 248 | - * |
|
| 249 | - * @param int $pValue |
|
| 250 | - * @return PHPExcel_Worksheet_Drawing_Shadow |
|
| 251 | - */ |
|
| 252 | - public function setAlpha($pValue = 0) { |
|
| 253 | - $this->_alpha = $pValue; |
|
| 254 | - return $this; |
|
| 255 | - } |
|
| 246 | + /** |
|
| 247 | + * Set Alpha |
|
| 248 | + * |
|
| 249 | + * @param int $pValue |
|
| 250 | + * @return PHPExcel_Worksheet_Drawing_Shadow |
|
| 251 | + */ |
|
| 252 | + public function setAlpha($pValue = 0) { |
|
| 253 | + $this->_alpha = $pValue; |
|
| 254 | + return $this; |
|
| 255 | + } |
|
| 256 | 256 | |
| 257 | 257 | /** |
| 258 | 258 | * Get hash code |
@@ -260,17 +260,17 @@ discard block |
||
| 260 | 260 | * @return string Hash code |
| 261 | 261 | */ |
| 262 | 262 | public function getHashCode() { |
| 263 | - return md5( |
|
| 264 | - ($this->_visible ? 't' : 'f') |
|
| 265 | - . $this->_blurRadius |
|
| 266 | - . $this->_distance |
|
| 267 | - . $this->_direction |
|
| 268 | - . $this->_alignment |
|
| 269 | - . $this->_color->getHashCode() |
|
| 270 | - . $this->_alpha |
|
| 271 | - . __CLASS__ |
|
| 272 | - ); |
|
| 273 | - } |
|
| 263 | + return md5( |
|
| 264 | + ($this->_visible ? 't' : 'f') |
|
| 265 | + . $this->_blurRadius |
|
| 266 | + . $this->_distance |
|
| 267 | + . $this->_direction |
|
| 268 | + . $this->_alignment |
|
| 269 | + . $this->_color->getHashCode() |
|
| 270 | + . $this->_alpha |
|
| 271 | + . __CLASS__ |
|
| 272 | + ); |
|
| 273 | + } |
|
| 274 | 274 | |
| 275 | 275 | /** |
| 276 | 276 | * Implement PHP __clone to create a deep clone, not just a shallow copy. |
@@ -108,70 +108,70 @@ discard block |
||
| 108 | 108 | * |
| 109 | 109 | * @var string |
| 110 | 110 | */ |
| 111 | - private $_oddHeader = ''; |
|
| 111 | + private $_oddHeader = ''; |
|
| 112 | 112 | |
| 113 | 113 | /** |
| 114 | 114 | * OddFooter |
| 115 | 115 | * |
| 116 | 116 | * @var string |
| 117 | 117 | */ |
| 118 | - private $_oddFooter = ''; |
|
| 118 | + private $_oddFooter = ''; |
|
| 119 | 119 | |
| 120 | 120 | /** |
| 121 | 121 | * EvenHeader |
| 122 | 122 | * |
| 123 | 123 | * @var string |
| 124 | 124 | */ |
| 125 | - private $_evenHeader = ''; |
|
| 125 | + private $_evenHeader = ''; |
|
| 126 | 126 | |
| 127 | 127 | /** |
| 128 | 128 | * EvenFooter |
| 129 | 129 | * |
| 130 | 130 | * @var string |
| 131 | 131 | */ |
| 132 | - private $_evenFooter = ''; |
|
| 132 | + private $_evenFooter = ''; |
|
| 133 | 133 | |
| 134 | 134 | /** |
| 135 | 135 | * FirstHeader |
| 136 | 136 | * |
| 137 | 137 | * @var string |
| 138 | 138 | */ |
| 139 | - private $_firstHeader = ''; |
|
| 139 | + private $_firstHeader = ''; |
|
| 140 | 140 | |
| 141 | 141 | /** |
| 142 | 142 | * FirstFooter |
| 143 | 143 | * |
| 144 | 144 | * @var string |
| 145 | 145 | */ |
| 146 | - private $_firstFooter = ''; |
|
| 146 | + private $_firstFooter = ''; |
|
| 147 | 147 | |
| 148 | 148 | /** |
| 149 | 149 | * Different header for Odd/Even, defaults to false |
| 150 | 150 | * |
| 151 | 151 | * @var boolean |
| 152 | 152 | */ |
| 153 | - private $_differentOddEven = false; |
|
| 153 | + private $_differentOddEven = false; |
|
| 154 | 154 | |
| 155 | 155 | /** |
| 156 | 156 | * Different header for first page, defaults to false |
| 157 | 157 | * |
| 158 | 158 | * @var boolean |
| 159 | 159 | */ |
| 160 | - private $_differentFirst = false; |
|
| 160 | + private $_differentFirst = false; |
|
| 161 | 161 | |
| 162 | 162 | /** |
| 163 | 163 | * Scale with document, defaults to true |
| 164 | 164 | * |
| 165 | 165 | * @var boolean |
| 166 | 166 | */ |
| 167 | - private $_scaleWithDocument = true; |
|
| 167 | + private $_scaleWithDocument = true; |
|
| 168 | 168 | |
| 169 | 169 | /** |
| 170 | 170 | * Align with margins, defaults to true |
| 171 | 171 | * |
| 172 | 172 | * @var boolean |
| 173 | 173 | */ |
| 174 | - private $_alignWithMargins = true; |
|
| 174 | + private $_alignWithMargins = true; |
|
| 175 | 175 | |
| 176 | 176 | /** |
| 177 | 177 | * Header/footer images |
@@ -422,7 +422,7 @@ discard block |
||
| 422 | 422 | * @return PHPExcel_Worksheet_HeaderFooter |
| 423 | 423 | */ |
| 424 | 424 | public function setImages($images) { |
| 425 | - if (!is_array($images)) { |
|
| 425 | + if ( ! is_array($images)) { |
|
| 426 | 426 | throw new Exception('Invalid parameter!'); |
| 427 | 427 | } |
| 428 | 428 | |
@@ -438,12 +438,12 @@ discard block |
||
| 438 | 438 | public function getImages() { |
| 439 | 439 | // Sort array |
| 440 | 440 | $images = array(); |
| 441 | - if (isset($this->_headerFooterImages[self::IMAGE_HEADER_LEFT])) $images[self::IMAGE_HEADER_LEFT] = $this->_headerFooterImages[self::IMAGE_HEADER_LEFT]; |
|
| 442 | - if (isset($this->_headerFooterImages[self::IMAGE_HEADER_CENTER])) $images[self::IMAGE_HEADER_CENTER] = $this->_headerFooterImages[self::IMAGE_HEADER_CENTER]; |
|
| 443 | - if (isset($this->_headerFooterImages[self::IMAGE_HEADER_RIGHT])) $images[self::IMAGE_HEADER_RIGHT] = $this->_headerFooterImages[self::IMAGE_HEADER_RIGHT]; |
|
| 444 | - if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_LEFT])) $images[self::IMAGE_FOOTER_LEFT] = $this->_headerFooterImages[self::IMAGE_FOOTER_LEFT]; |
|
| 445 | - if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_CENTER])) $images[self::IMAGE_FOOTER_CENTER] = $this->_headerFooterImages[self::IMAGE_FOOTER_CENTER]; |
|
| 446 | - if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_RIGHT])) $images[self::IMAGE_FOOTER_RIGHT] = $this->_headerFooterImages[self::IMAGE_FOOTER_RIGHT]; |
|
| 441 | + if (isset($this->_headerFooterImages[self::IMAGE_HEADER_LEFT])) $images[self::IMAGE_HEADER_LEFT] = $this->_headerFooterImages[self::IMAGE_HEADER_LEFT]; |
|
| 442 | + if (isset($this->_headerFooterImages[self::IMAGE_HEADER_CENTER])) $images[self::IMAGE_HEADER_CENTER] = $this->_headerFooterImages[self::IMAGE_HEADER_CENTER]; |
|
| 443 | + if (isset($this->_headerFooterImages[self::IMAGE_HEADER_RIGHT])) $images[self::IMAGE_HEADER_RIGHT] = $this->_headerFooterImages[self::IMAGE_HEADER_RIGHT]; |
|
| 444 | + if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_LEFT])) $images[self::IMAGE_FOOTER_LEFT] = $this->_headerFooterImages[self::IMAGE_FOOTER_LEFT]; |
|
| 445 | + if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_CENTER])) $images[self::IMAGE_FOOTER_CENTER] = $this->_headerFooterImages[self::IMAGE_FOOTER_CENTER]; |
|
| 446 | + if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_RIGHT])) $images[self::IMAGE_FOOTER_RIGHT] = $this->_headerFooterImages[self::IMAGE_FOOTER_RIGHT]; |
|
| 447 | 447 | $this->_headerFooterImages = $images; |
| 448 | 448 | |
| 449 | 449 | return $this->_headerFooterImages; |
@@ -438,12 +438,24 @@ |
||
| 438 | 438 | public function getImages() { |
| 439 | 439 | // Sort array |
| 440 | 440 | $images = array(); |
| 441 | - if (isset($this->_headerFooterImages[self::IMAGE_HEADER_LEFT])) $images[self::IMAGE_HEADER_LEFT] = $this->_headerFooterImages[self::IMAGE_HEADER_LEFT]; |
|
| 442 | - if (isset($this->_headerFooterImages[self::IMAGE_HEADER_CENTER])) $images[self::IMAGE_HEADER_CENTER] = $this->_headerFooterImages[self::IMAGE_HEADER_CENTER]; |
|
| 443 | - if (isset($this->_headerFooterImages[self::IMAGE_HEADER_RIGHT])) $images[self::IMAGE_HEADER_RIGHT] = $this->_headerFooterImages[self::IMAGE_HEADER_RIGHT]; |
|
| 444 | - if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_LEFT])) $images[self::IMAGE_FOOTER_LEFT] = $this->_headerFooterImages[self::IMAGE_FOOTER_LEFT]; |
|
| 445 | - if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_CENTER])) $images[self::IMAGE_FOOTER_CENTER] = $this->_headerFooterImages[self::IMAGE_FOOTER_CENTER]; |
|
| 446 | - if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_RIGHT])) $images[self::IMAGE_FOOTER_RIGHT] = $this->_headerFooterImages[self::IMAGE_FOOTER_RIGHT]; |
|
| 441 | + if (isset($this->_headerFooterImages[self::IMAGE_HEADER_LEFT])) { |
|
| 442 | + $images[self::IMAGE_HEADER_LEFT] = $this->_headerFooterImages[self::IMAGE_HEADER_LEFT]; |
|
| 443 | + } |
|
| 444 | + if (isset($this->_headerFooterImages[self::IMAGE_HEADER_CENTER])) { |
|
| 445 | + $images[self::IMAGE_HEADER_CENTER] = $this->_headerFooterImages[self::IMAGE_HEADER_CENTER]; |
|
| 446 | + } |
|
| 447 | + if (isset($this->_headerFooterImages[self::IMAGE_HEADER_RIGHT])) { |
|
| 448 | + $images[self::IMAGE_HEADER_RIGHT] = $this->_headerFooterImages[self::IMAGE_HEADER_RIGHT]; |
|
| 449 | + } |
|
| 450 | + if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_LEFT])) { |
|
| 451 | + $images[self::IMAGE_FOOTER_LEFT] = $this->_headerFooterImages[self::IMAGE_FOOTER_LEFT]; |
|
| 452 | + } |
|
| 453 | + if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_CENTER])) { |
|
| 454 | + $images[self::IMAGE_FOOTER_CENTER] = $this->_headerFooterImages[self::IMAGE_FOOTER_CENTER]; |
|
| 455 | + } |
|
| 456 | + if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_RIGHT])) { |
|
| 457 | + $images[self::IMAGE_FOOTER_RIGHT] = $this->_headerFooterImages[self::IMAGE_FOOTER_RIGHT]; |
|
| 458 | + } |
|
| 447 | 459 | $this->_headerFooterImages = $images; |
| 448 | 460 | |
| 449 | 461 | return $this->_headerFooterImages; |
@@ -180,274 +180,274 @@ |
||
| 180 | 180 | */ |
| 181 | 181 | private $_headerFooterImages = array(); |
| 182 | 182 | |
| 183 | - /** |
|
| 184 | - * Create a new PHPExcel_Worksheet_HeaderFooter |
|
| 185 | - */ |
|
| 186 | - public function __construct() |
|
| 187 | - { |
|
| 188 | - } |
|
| 189 | - |
|
| 190 | - /** |
|
| 191 | - * Get OddHeader |
|
| 192 | - * |
|
| 193 | - * @return string |
|
| 194 | - */ |
|
| 195 | - public function getOddHeader() { |
|
| 196 | - return $this->_oddHeader; |
|
| 197 | - } |
|
| 198 | - |
|
| 199 | - /** |
|
| 200 | - * Set OddHeader |
|
| 201 | - * |
|
| 202 | - * @param string $pValue |
|
| 203 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
| 204 | - */ |
|
| 205 | - public function setOddHeader($pValue) { |
|
| 206 | - $this->_oddHeader = $pValue; |
|
| 207 | - return $this; |
|
| 208 | - } |
|
| 209 | - |
|
| 210 | - /** |
|
| 211 | - * Get OddFooter |
|
| 212 | - * |
|
| 213 | - * @return string |
|
| 214 | - */ |
|
| 215 | - public function getOddFooter() { |
|
| 216 | - return $this->_oddFooter; |
|
| 217 | - } |
|
| 218 | - |
|
| 219 | - /** |
|
| 220 | - * Set OddFooter |
|
| 221 | - * |
|
| 222 | - * @param string $pValue |
|
| 223 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
| 224 | - */ |
|
| 225 | - public function setOddFooter($pValue) { |
|
| 226 | - $this->_oddFooter = $pValue; |
|
| 227 | - return $this; |
|
| 228 | - } |
|
| 229 | - |
|
| 230 | - /** |
|
| 231 | - * Get EvenHeader |
|
| 232 | - * |
|
| 233 | - * @return string |
|
| 234 | - */ |
|
| 235 | - public function getEvenHeader() { |
|
| 236 | - return $this->_evenHeader; |
|
| 237 | - } |
|
| 238 | - |
|
| 239 | - /** |
|
| 240 | - * Set EvenHeader |
|
| 241 | - * |
|
| 242 | - * @param string $pValue |
|
| 243 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
| 244 | - */ |
|
| 245 | - public function setEvenHeader($pValue) { |
|
| 246 | - $this->_evenHeader = $pValue; |
|
| 247 | - return $this; |
|
| 248 | - } |
|
| 249 | - |
|
| 250 | - /** |
|
| 251 | - * Get EvenFooter |
|
| 252 | - * |
|
| 253 | - * @return string |
|
| 254 | - */ |
|
| 255 | - public function getEvenFooter() { |
|
| 256 | - return $this->_evenFooter; |
|
| 257 | - } |
|
| 258 | - |
|
| 259 | - /** |
|
| 260 | - * Set EvenFooter |
|
| 261 | - * |
|
| 262 | - * @param string $pValue |
|
| 263 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
| 264 | - */ |
|
| 265 | - public function setEvenFooter($pValue) { |
|
| 266 | - $this->_evenFooter = $pValue; |
|
| 267 | - return $this; |
|
| 268 | - } |
|
| 269 | - |
|
| 270 | - /** |
|
| 271 | - * Get FirstHeader |
|
| 272 | - * |
|
| 273 | - * @return string |
|
| 274 | - */ |
|
| 275 | - public function getFirstHeader() { |
|
| 276 | - return $this->_firstHeader; |
|
| 277 | - } |
|
| 278 | - |
|
| 279 | - /** |
|
| 280 | - * Set FirstHeader |
|
| 281 | - * |
|
| 282 | - * @param string $pValue |
|
| 283 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
| 284 | - */ |
|
| 285 | - public function setFirstHeader($pValue) { |
|
| 286 | - $this->_firstHeader = $pValue; |
|
| 287 | - return $this; |
|
| 288 | - } |
|
| 289 | - |
|
| 290 | - /** |
|
| 291 | - * Get FirstFooter |
|
| 292 | - * |
|
| 293 | - * @return string |
|
| 294 | - */ |
|
| 295 | - public function getFirstFooter() { |
|
| 296 | - return $this->_firstFooter; |
|
| 297 | - } |
|
| 298 | - |
|
| 299 | - /** |
|
| 300 | - * Set FirstFooter |
|
| 301 | - * |
|
| 302 | - * @param string $pValue |
|
| 303 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
| 304 | - */ |
|
| 305 | - public function setFirstFooter($pValue) { |
|
| 306 | - $this->_firstFooter = $pValue; |
|
| 307 | - return $this; |
|
| 308 | - } |
|
| 309 | - |
|
| 310 | - /** |
|
| 311 | - * Get DifferentOddEven |
|
| 312 | - * |
|
| 313 | - * @return boolean |
|
| 314 | - */ |
|
| 315 | - public function getDifferentOddEven() { |
|
| 316 | - return $this->_differentOddEven; |
|
| 317 | - } |
|
| 318 | - |
|
| 319 | - /** |
|
| 320 | - * Set DifferentOddEven |
|
| 321 | - * |
|
| 322 | - * @param boolean $pValue |
|
| 323 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
| 324 | - */ |
|
| 325 | - public function setDifferentOddEven($pValue = false) { |
|
| 326 | - $this->_differentOddEven = $pValue; |
|
| 327 | - return $this; |
|
| 328 | - } |
|
| 329 | - |
|
| 330 | - /** |
|
| 331 | - * Get DifferentFirst |
|
| 332 | - * |
|
| 333 | - * @return boolean |
|
| 334 | - */ |
|
| 335 | - public function getDifferentFirst() { |
|
| 336 | - return $this->_differentFirst; |
|
| 337 | - } |
|
| 338 | - |
|
| 339 | - /** |
|
| 340 | - * Set DifferentFirst |
|
| 341 | - * |
|
| 342 | - * @param boolean $pValue |
|
| 343 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
| 344 | - */ |
|
| 345 | - public function setDifferentFirst($pValue = false) { |
|
| 346 | - $this->_differentFirst = $pValue; |
|
| 347 | - return $this; |
|
| 348 | - } |
|
| 349 | - |
|
| 350 | - /** |
|
| 351 | - * Get ScaleWithDocument |
|
| 352 | - * |
|
| 353 | - * @return boolean |
|
| 354 | - */ |
|
| 355 | - public function getScaleWithDocument() { |
|
| 356 | - return $this->_scaleWithDocument; |
|
| 357 | - } |
|
| 358 | - |
|
| 359 | - /** |
|
| 360 | - * Set ScaleWithDocument |
|
| 361 | - * |
|
| 362 | - * @param boolean $pValue |
|
| 363 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
| 364 | - */ |
|
| 365 | - public function setScaleWithDocument($pValue = true) { |
|
| 366 | - $this->_scaleWithDocument = $pValue; |
|
| 367 | - return $this; |
|
| 368 | - } |
|
| 369 | - |
|
| 370 | - /** |
|
| 371 | - * Get AlignWithMargins |
|
| 372 | - * |
|
| 373 | - * @return boolean |
|
| 374 | - */ |
|
| 375 | - public function getAlignWithMargins() { |
|
| 376 | - return $this->_alignWithMargins; |
|
| 377 | - } |
|
| 378 | - |
|
| 379 | - /** |
|
| 380 | - * Set AlignWithMargins |
|
| 381 | - * |
|
| 382 | - * @param boolean $pValue |
|
| 383 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
| 384 | - */ |
|
| 385 | - public function setAlignWithMargins($pValue = true) { |
|
| 386 | - $this->_alignWithMargins = $pValue; |
|
| 387 | - return $this; |
|
| 388 | - } |
|
| 389 | - |
|
| 390 | - /** |
|
| 391 | - * Add header/footer image |
|
| 392 | - * |
|
| 393 | - * @param PHPExcel_Worksheet_HeaderFooterDrawing $image |
|
| 394 | - * @param string $location |
|
| 395 | - * @throws Exception |
|
| 396 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
| 397 | - */ |
|
| 398 | - public function addImage(PHPExcel_Worksheet_HeaderFooterDrawing $image = null, $location = self::IMAGE_HEADER_LEFT) { |
|
| 399 | - $this->_headerFooterImages[$location] = $image; |
|
| 400 | - return $this; |
|
| 401 | - } |
|
| 402 | - |
|
| 403 | - /** |
|
| 404 | - * Remove header/footer image |
|
| 405 | - * |
|
| 406 | - * @param string $location |
|
| 407 | - * @throws Exception |
|
| 408 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
| 409 | - */ |
|
| 410 | - public function removeImage($location = self::IMAGE_HEADER_LEFT) { |
|
| 411 | - if (isset($this->_headerFooterImages[$location])) { |
|
| 412 | - unset($this->_headerFooterImages[$location]); |
|
| 413 | - } |
|
| 414 | - return $this; |
|
| 415 | - } |
|
| 416 | - |
|
| 417 | - /** |
|
| 418 | - * Set header/footer images |
|
| 419 | - * |
|
| 420 | - * @param PHPExcel_Worksheet_HeaderFooterDrawing[] $images |
|
| 421 | - * @throws Exception |
|
| 422 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
| 423 | - */ |
|
| 424 | - public function setImages($images) { |
|
| 425 | - if (!is_array($images)) { |
|
| 426 | - throw new Exception('Invalid parameter!'); |
|
| 427 | - } |
|
| 428 | - |
|
| 429 | - $this->_headerFooterImages = $images; |
|
| 430 | - return $this; |
|
| 431 | - } |
|
| 432 | - |
|
| 433 | - /** |
|
| 434 | - * Get header/footer images |
|
| 435 | - * |
|
| 436 | - * @return PHPExcel_Worksheet_HeaderFooterDrawing[] |
|
| 437 | - */ |
|
| 438 | - public function getImages() { |
|
| 439 | - // Sort array |
|
| 440 | - $images = array(); |
|
| 441 | - if (isset($this->_headerFooterImages[self::IMAGE_HEADER_LEFT])) $images[self::IMAGE_HEADER_LEFT] = $this->_headerFooterImages[self::IMAGE_HEADER_LEFT]; |
|
| 442 | - if (isset($this->_headerFooterImages[self::IMAGE_HEADER_CENTER])) $images[self::IMAGE_HEADER_CENTER] = $this->_headerFooterImages[self::IMAGE_HEADER_CENTER]; |
|
| 443 | - if (isset($this->_headerFooterImages[self::IMAGE_HEADER_RIGHT])) $images[self::IMAGE_HEADER_RIGHT] = $this->_headerFooterImages[self::IMAGE_HEADER_RIGHT]; |
|
| 444 | - if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_LEFT])) $images[self::IMAGE_FOOTER_LEFT] = $this->_headerFooterImages[self::IMAGE_FOOTER_LEFT]; |
|
| 445 | - if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_CENTER])) $images[self::IMAGE_FOOTER_CENTER] = $this->_headerFooterImages[self::IMAGE_FOOTER_CENTER]; |
|
| 446 | - if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_RIGHT])) $images[self::IMAGE_FOOTER_RIGHT] = $this->_headerFooterImages[self::IMAGE_FOOTER_RIGHT]; |
|
| 447 | - $this->_headerFooterImages = $images; |
|
| 448 | - |
|
| 449 | - return $this->_headerFooterImages; |
|
| 450 | - } |
|
| 183 | + /** |
|
| 184 | + * Create a new PHPExcel_Worksheet_HeaderFooter |
|
| 185 | + */ |
|
| 186 | + public function __construct() |
|
| 187 | + { |
|
| 188 | + } |
|
| 189 | + |
|
| 190 | + /** |
|
| 191 | + * Get OddHeader |
|
| 192 | + * |
|
| 193 | + * @return string |
|
| 194 | + */ |
|
| 195 | + public function getOddHeader() { |
|
| 196 | + return $this->_oddHeader; |
|
| 197 | + } |
|
| 198 | + |
|
| 199 | + /** |
|
| 200 | + * Set OddHeader |
|
| 201 | + * |
|
| 202 | + * @param string $pValue |
|
| 203 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
| 204 | + */ |
|
| 205 | + public function setOddHeader($pValue) { |
|
| 206 | + $this->_oddHeader = $pValue; |
|
| 207 | + return $this; |
|
| 208 | + } |
|
| 209 | + |
|
| 210 | + /** |
|
| 211 | + * Get OddFooter |
|
| 212 | + * |
|
| 213 | + * @return string |
|
| 214 | + */ |
|
| 215 | + public function getOddFooter() { |
|
| 216 | + return $this->_oddFooter; |
|
| 217 | + } |
|
| 218 | + |
|
| 219 | + /** |
|
| 220 | + * Set OddFooter |
|
| 221 | + * |
|
| 222 | + * @param string $pValue |
|
| 223 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
| 224 | + */ |
|
| 225 | + public function setOddFooter($pValue) { |
|
| 226 | + $this->_oddFooter = $pValue; |
|
| 227 | + return $this; |
|
| 228 | + } |
|
| 229 | + |
|
| 230 | + /** |
|
| 231 | + * Get EvenHeader |
|
| 232 | + * |
|
| 233 | + * @return string |
|
| 234 | + */ |
|
| 235 | + public function getEvenHeader() { |
|
| 236 | + return $this->_evenHeader; |
|
| 237 | + } |
|
| 238 | + |
|
| 239 | + /** |
|
| 240 | + * Set EvenHeader |
|
| 241 | + * |
|
| 242 | + * @param string $pValue |
|
| 243 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
| 244 | + */ |
|
| 245 | + public function setEvenHeader($pValue) { |
|
| 246 | + $this->_evenHeader = $pValue; |
|
| 247 | + return $this; |
|
| 248 | + } |
|
| 249 | + |
|
| 250 | + /** |
|
| 251 | + * Get EvenFooter |
|
| 252 | + * |
|
| 253 | + * @return string |
|
| 254 | + */ |
|
| 255 | + public function getEvenFooter() { |
|
| 256 | + return $this->_evenFooter; |
|
| 257 | + } |
|
| 258 | + |
|
| 259 | + /** |
|
| 260 | + * Set EvenFooter |
|
| 261 | + * |
|
| 262 | + * @param string $pValue |
|
| 263 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
| 264 | + */ |
|
| 265 | + public function setEvenFooter($pValue) { |
|
| 266 | + $this->_evenFooter = $pValue; |
|
| 267 | + return $this; |
|
| 268 | + } |
|
| 269 | + |
|
| 270 | + /** |
|
| 271 | + * Get FirstHeader |
|
| 272 | + * |
|
| 273 | + * @return string |
|
| 274 | + */ |
|
| 275 | + public function getFirstHeader() { |
|
| 276 | + return $this->_firstHeader; |
|
| 277 | + } |
|
| 278 | + |
|
| 279 | + /** |
|
| 280 | + * Set FirstHeader |
|
| 281 | + * |
|
| 282 | + * @param string $pValue |
|
| 283 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
| 284 | + */ |
|
| 285 | + public function setFirstHeader($pValue) { |
|
| 286 | + $this->_firstHeader = $pValue; |
|
| 287 | + return $this; |
|
| 288 | + } |
|
| 289 | + |
|
| 290 | + /** |
|
| 291 | + * Get FirstFooter |
|
| 292 | + * |
|
| 293 | + * @return string |
|
| 294 | + */ |
|
| 295 | + public function getFirstFooter() { |
|
| 296 | + return $this->_firstFooter; |
|
| 297 | + } |
|
| 298 | + |
|
| 299 | + /** |
|
| 300 | + * Set FirstFooter |
|
| 301 | + * |
|
| 302 | + * @param string $pValue |
|
| 303 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
| 304 | + */ |
|
| 305 | + public function setFirstFooter($pValue) { |
|
| 306 | + $this->_firstFooter = $pValue; |
|
| 307 | + return $this; |
|
| 308 | + } |
|
| 309 | + |
|
| 310 | + /** |
|
| 311 | + * Get DifferentOddEven |
|
| 312 | + * |
|
| 313 | + * @return boolean |
|
| 314 | + */ |
|
| 315 | + public function getDifferentOddEven() { |
|
| 316 | + return $this->_differentOddEven; |
|
| 317 | + } |
|
| 318 | + |
|
| 319 | + /** |
|
| 320 | + * Set DifferentOddEven |
|
| 321 | + * |
|
| 322 | + * @param boolean $pValue |
|
| 323 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
| 324 | + */ |
|
| 325 | + public function setDifferentOddEven($pValue = false) { |
|
| 326 | + $this->_differentOddEven = $pValue; |
|
| 327 | + return $this; |
|
| 328 | + } |
|
| 329 | + |
|
| 330 | + /** |
|
| 331 | + * Get DifferentFirst |
|
| 332 | + * |
|
| 333 | + * @return boolean |
|
| 334 | + */ |
|
| 335 | + public function getDifferentFirst() { |
|
| 336 | + return $this->_differentFirst; |
|
| 337 | + } |
|
| 338 | + |
|
| 339 | + /** |
|
| 340 | + * Set DifferentFirst |
|
| 341 | + * |
|
| 342 | + * @param boolean $pValue |
|
| 343 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
| 344 | + */ |
|
| 345 | + public function setDifferentFirst($pValue = false) { |
|
| 346 | + $this->_differentFirst = $pValue; |
|
| 347 | + return $this; |
|
| 348 | + } |
|
| 349 | + |
|
| 350 | + /** |
|
| 351 | + * Get ScaleWithDocument |
|
| 352 | + * |
|
| 353 | + * @return boolean |
|
| 354 | + */ |
|
| 355 | + public function getScaleWithDocument() { |
|
| 356 | + return $this->_scaleWithDocument; |
|
| 357 | + } |
|
| 358 | + |
|
| 359 | + /** |
|
| 360 | + * Set ScaleWithDocument |
|
| 361 | + * |
|
| 362 | + * @param boolean $pValue |
|
| 363 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
| 364 | + */ |
|
| 365 | + public function setScaleWithDocument($pValue = true) { |
|
| 366 | + $this->_scaleWithDocument = $pValue; |
|
| 367 | + return $this; |
|
| 368 | + } |
|
| 369 | + |
|
| 370 | + /** |
|
| 371 | + * Get AlignWithMargins |
|
| 372 | + * |
|
| 373 | + * @return boolean |
|
| 374 | + */ |
|
| 375 | + public function getAlignWithMargins() { |
|
| 376 | + return $this->_alignWithMargins; |
|
| 377 | + } |
|
| 378 | + |
|
| 379 | + /** |
|
| 380 | + * Set AlignWithMargins |
|
| 381 | + * |
|
| 382 | + * @param boolean $pValue |
|
| 383 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
| 384 | + */ |
|
| 385 | + public function setAlignWithMargins($pValue = true) { |
|
| 386 | + $this->_alignWithMargins = $pValue; |
|
| 387 | + return $this; |
|
| 388 | + } |
|
| 389 | + |
|
| 390 | + /** |
|
| 391 | + * Add header/footer image |
|
| 392 | + * |
|
| 393 | + * @param PHPExcel_Worksheet_HeaderFooterDrawing $image |
|
| 394 | + * @param string $location |
|
| 395 | + * @throws Exception |
|
| 396 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
| 397 | + */ |
|
| 398 | + public function addImage(PHPExcel_Worksheet_HeaderFooterDrawing $image = null, $location = self::IMAGE_HEADER_LEFT) { |
|
| 399 | + $this->_headerFooterImages[$location] = $image; |
|
| 400 | + return $this; |
|
| 401 | + } |
|
| 402 | + |
|
| 403 | + /** |
|
| 404 | + * Remove header/footer image |
|
| 405 | + * |
|
| 406 | + * @param string $location |
|
| 407 | + * @throws Exception |
|
| 408 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
| 409 | + */ |
|
| 410 | + public function removeImage($location = self::IMAGE_HEADER_LEFT) { |
|
| 411 | + if (isset($this->_headerFooterImages[$location])) { |
|
| 412 | + unset($this->_headerFooterImages[$location]); |
|
| 413 | + } |
|
| 414 | + return $this; |
|
| 415 | + } |
|
| 416 | + |
|
| 417 | + /** |
|
| 418 | + * Set header/footer images |
|
| 419 | + * |
|
| 420 | + * @param PHPExcel_Worksheet_HeaderFooterDrawing[] $images |
|
| 421 | + * @throws Exception |
|
| 422 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
| 423 | + */ |
|
| 424 | + public function setImages($images) { |
|
| 425 | + if (!is_array($images)) { |
|
| 426 | + throw new Exception('Invalid parameter!'); |
|
| 427 | + } |
|
| 428 | + |
|
| 429 | + $this->_headerFooterImages = $images; |
|
| 430 | + return $this; |
|
| 431 | + } |
|
| 432 | + |
|
| 433 | + /** |
|
| 434 | + * Get header/footer images |
|
| 435 | + * |
|
| 436 | + * @return PHPExcel_Worksheet_HeaderFooterDrawing[] |
|
| 437 | + */ |
|
| 438 | + public function getImages() { |
|
| 439 | + // Sort array |
|
| 440 | + $images = array(); |
|
| 441 | + if (isset($this->_headerFooterImages[self::IMAGE_HEADER_LEFT])) $images[self::IMAGE_HEADER_LEFT] = $this->_headerFooterImages[self::IMAGE_HEADER_LEFT]; |
|
| 442 | + if (isset($this->_headerFooterImages[self::IMAGE_HEADER_CENTER])) $images[self::IMAGE_HEADER_CENTER] = $this->_headerFooterImages[self::IMAGE_HEADER_CENTER]; |
|
| 443 | + if (isset($this->_headerFooterImages[self::IMAGE_HEADER_RIGHT])) $images[self::IMAGE_HEADER_RIGHT] = $this->_headerFooterImages[self::IMAGE_HEADER_RIGHT]; |
|
| 444 | + if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_LEFT])) $images[self::IMAGE_FOOTER_LEFT] = $this->_headerFooterImages[self::IMAGE_FOOTER_LEFT]; |
|
| 445 | + if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_CENTER])) $images[self::IMAGE_FOOTER_CENTER] = $this->_headerFooterImages[self::IMAGE_FOOTER_CENTER]; |
|
| 446 | + if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_RIGHT])) $images[self::IMAGE_FOOTER_RIGHT] = $this->_headerFooterImages[self::IMAGE_FOOTER_RIGHT]; |
|
| 447 | + $this->_headerFooterImages = $images; |
|
| 448 | + |
|
| 449 | + return $this->_headerFooterImages; |
|
| 450 | + } |
|
| 451 | 451 | |
| 452 | 452 | /** |
| 453 | 453 | * Implement PHP __clone to create a deep clone, not just a shallow copy. |
@@ -94,9 +94,9 @@ discard block |
||
| 94 | 94 | $this->_name = ''; |
| 95 | 95 | $this->_offsetX = 0; |
| 96 | 96 | $this->_offsetY = 0; |
| 97 | - $this->_width = 0; |
|
| 98 | - $this->_height = 0; |
|
| 99 | - $this->_resizeProportional = true; |
|
| 97 | + $this->_width = 0; |
|
| 98 | + $this->_height = 0; |
|
| 99 | + $this->_resizeProportional = true; |
|
| 100 | 100 | } |
| 101 | 101 | |
| 102 | 102 | /** |
@@ -231,12 +231,12 @@ discard block |
||
| 231 | 231 | public function setWidthAndHeight($width = 0, $height = 0) { |
| 232 | 232 | $xratio = $width / $this->_width; |
| 233 | 233 | $yratio = $height / $this->_height; |
| 234 | - if ($this->_resizeProportional && !($width == 0 || $height == 0)) { |
|
| 234 | + if ($this->_resizeProportional && ! ($width == 0 || $height == 0)) { |
|
| 235 | 235 | if (($xratio * $this->_height) < $height) { |
| 236 | 236 | $this->_height = ceil($xratio * $this->_height); |
| 237 | 237 | $this->_width = $width; |
| 238 | 238 | } else { |
| 239 | - $this->_width = ceil($yratio * $this->_width); |
|
| 239 | + $this->_width = ceil($yratio * $this->_width); |
|
| 240 | 240 | $this->_height = $height; |
| 241 | 241 | } |
| 242 | 242 | } |
@@ -84,150 +84,150 @@ discard block |
||
| 84 | 84 | */ |
| 85 | 85 | protected $_resizeProportional; |
| 86 | 86 | |
| 87 | - /** |
|
| 88 | - * Create a new PHPExcel_Worksheet_HeaderFooterDrawing |
|
| 89 | - */ |
|
| 90 | - public function __construct() |
|
| 91 | - { |
|
| 92 | - // Initialise values |
|
| 93 | - $this->_path = ''; |
|
| 94 | - $this->_name = ''; |
|
| 95 | - $this->_offsetX = 0; |
|
| 96 | - $this->_offsetY = 0; |
|
| 97 | - $this->_width = 0; |
|
| 98 | - $this->_height = 0; |
|
| 99 | - $this->_resizeProportional = true; |
|
| 100 | - } |
|
| 101 | - |
|
| 102 | - /** |
|
| 103 | - * Get Name |
|
| 104 | - * |
|
| 105 | - * @return string |
|
| 106 | - */ |
|
| 107 | - public function getName() { |
|
| 108 | - return $this->_name; |
|
| 109 | - } |
|
| 110 | - |
|
| 111 | - /** |
|
| 112 | - * Set Name |
|
| 113 | - * |
|
| 114 | - * @param string $pValue |
|
| 115 | - * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
| 116 | - */ |
|
| 117 | - public function setName($pValue = '') { |
|
| 118 | - $this->_name = $pValue; |
|
| 119 | - return $this; |
|
| 120 | - } |
|
| 121 | - |
|
| 122 | - /** |
|
| 123 | - * Get OffsetX |
|
| 124 | - * |
|
| 125 | - * @return int |
|
| 126 | - */ |
|
| 127 | - public function getOffsetX() { |
|
| 128 | - return $this->_offsetX; |
|
| 129 | - } |
|
| 130 | - |
|
| 131 | - /** |
|
| 132 | - * Set OffsetX |
|
| 133 | - * |
|
| 134 | - * @param int $pValue |
|
| 135 | - * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
| 136 | - */ |
|
| 137 | - public function setOffsetX($pValue = 0) { |
|
| 138 | - $this->_offsetX = $pValue; |
|
| 139 | - return $this; |
|
| 140 | - } |
|
| 141 | - |
|
| 142 | - /** |
|
| 143 | - * Get OffsetY |
|
| 144 | - * |
|
| 145 | - * @return int |
|
| 146 | - */ |
|
| 147 | - public function getOffsetY() { |
|
| 148 | - return $this->_offsetY; |
|
| 149 | - } |
|
| 150 | - |
|
| 151 | - /** |
|
| 152 | - * Set OffsetY |
|
| 153 | - * |
|
| 154 | - * @param int $pValue |
|
| 155 | - * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
| 156 | - */ |
|
| 157 | - public function setOffsetY($pValue = 0) { |
|
| 158 | - $this->_offsetY = $pValue; |
|
| 159 | - return $this; |
|
| 160 | - } |
|
| 161 | - |
|
| 162 | - /** |
|
| 163 | - * Get Width |
|
| 164 | - * |
|
| 165 | - * @return int |
|
| 166 | - */ |
|
| 167 | - public function getWidth() { |
|
| 168 | - return $this->_width; |
|
| 169 | - } |
|
| 170 | - |
|
| 171 | - /** |
|
| 172 | - * Set Width |
|
| 173 | - * |
|
| 174 | - * @param int $pValue |
|
| 175 | - * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
| 176 | - */ |
|
| 177 | - public function setWidth($pValue = 0) { |
|
| 178 | - // Resize proportional? |
|
| 179 | - if ($this->_resizeProportional && $pValue != 0) { |
|
| 180 | - $ratio = $this->_width / $this->_height; |
|
| 181 | - $this->_height = round($ratio * $pValue); |
|
| 182 | - } |
|
| 183 | - |
|
| 184 | - // Set width |
|
| 185 | - $this->_width = $pValue; |
|
| 186 | - |
|
| 187 | - return $this; |
|
| 188 | - } |
|
| 189 | - |
|
| 190 | - /** |
|
| 191 | - * Get Height |
|
| 192 | - * |
|
| 193 | - * @return int |
|
| 194 | - */ |
|
| 195 | - public function getHeight() { |
|
| 196 | - return $this->_height; |
|
| 197 | - } |
|
| 198 | - |
|
| 199 | - /** |
|
| 200 | - * Set Height |
|
| 201 | - * |
|
| 202 | - * @param int $pValue |
|
| 203 | - * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
| 204 | - */ |
|
| 205 | - public function setHeight($pValue = 0) { |
|
| 206 | - // Resize proportional? |
|
| 207 | - if ($this->_resizeProportional && $pValue != 0) { |
|
| 208 | - $ratio = $this->_width / $this->_height; |
|
| 209 | - $this->_width = round($ratio * $pValue); |
|
| 210 | - } |
|
| 211 | - |
|
| 212 | - // Set height |
|
| 213 | - $this->_height = $pValue; |
|
| 214 | - |
|
| 215 | - return $this; |
|
| 216 | - } |
|
| 217 | - |
|
| 218 | - /** |
|
| 219 | - * Set width and height with proportional resize |
|
| 87 | + /** |
|
| 88 | + * Create a new PHPExcel_Worksheet_HeaderFooterDrawing |
|
| 89 | + */ |
|
| 90 | + public function __construct() |
|
| 91 | + { |
|
| 92 | + // Initialise values |
|
| 93 | + $this->_path = ''; |
|
| 94 | + $this->_name = ''; |
|
| 95 | + $this->_offsetX = 0; |
|
| 96 | + $this->_offsetY = 0; |
|
| 97 | + $this->_width = 0; |
|
| 98 | + $this->_height = 0; |
|
| 99 | + $this->_resizeProportional = true; |
|
| 100 | + } |
|
| 101 | + |
|
| 102 | + /** |
|
| 103 | + * Get Name |
|
| 104 | + * |
|
| 105 | + * @return string |
|
| 106 | + */ |
|
| 107 | + public function getName() { |
|
| 108 | + return $this->_name; |
|
| 109 | + } |
|
| 110 | + |
|
| 111 | + /** |
|
| 112 | + * Set Name |
|
| 113 | + * |
|
| 114 | + * @param string $pValue |
|
| 115 | + * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
| 116 | + */ |
|
| 117 | + public function setName($pValue = '') { |
|
| 118 | + $this->_name = $pValue; |
|
| 119 | + return $this; |
|
| 120 | + } |
|
| 121 | + |
|
| 122 | + /** |
|
| 123 | + * Get OffsetX |
|
| 124 | + * |
|
| 125 | + * @return int |
|
| 126 | + */ |
|
| 127 | + public function getOffsetX() { |
|
| 128 | + return $this->_offsetX; |
|
| 129 | + } |
|
| 130 | + |
|
| 131 | + /** |
|
| 132 | + * Set OffsetX |
|
| 133 | + * |
|
| 134 | + * @param int $pValue |
|
| 135 | + * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
| 136 | + */ |
|
| 137 | + public function setOffsetX($pValue = 0) { |
|
| 138 | + $this->_offsetX = $pValue; |
|
| 139 | + return $this; |
|
| 140 | + } |
|
| 141 | + |
|
| 142 | + /** |
|
| 143 | + * Get OffsetY |
|
| 144 | + * |
|
| 145 | + * @return int |
|
| 146 | + */ |
|
| 147 | + public function getOffsetY() { |
|
| 148 | + return $this->_offsetY; |
|
| 149 | + } |
|
| 150 | + |
|
| 151 | + /** |
|
| 152 | + * Set OffsetY |
|
| 153 | + * |
|
| 154 | + * @param int $pValue |
|
| 155 | + * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
| 156 | + */ |
|
| 157 | + public function setOffsetY($pValue = 0) { |
|
| 158 | + $this->_offsetY = $pValue; |
|
| 159 | + return $this; |
|
| 160 | + } |
|
| 161 | + |
|
| 162 | + /** |
|
| 163 | + * Get Width |
|
| 164 | + * |
|
| 165 | + * @return int |
|
| 166 | + */ |
|
| 167 | + public function getWidth() { |
|
| 168 | + return $this->_width; |
|
| 169 | + } |
|
| 170 | + |
|
| 171 | + /** |
|
| 172 | + * Set Width |
|
| 173 | + * |
|
| 174 | + * @param int $pValue |
|
| 175 | + * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
| 176 | + */ |
|
| 177 | + public function setWidth($pValue = 0) { |
|
| 178 | + // Resize proportional? |
|
| 179 | + if ($this->_resizeProportional && $pValue != 0) { |
|
| 180 | + $ratio = $this->_width / $this->_height; |
|
| 181 | + $this->_height = round($ratio * $pValue); |
|
| 182 | + } |
|
| 183 | + |
|
| 184 | + // Set width |
|
| 185 | + $this->_width = $pValue; |
|
| 186 | + |
|
| 187 | + return $this; |
|
| 188 | + } |
|
| 189 | + |
|
| 190 | + /** |
|
| 191 | + * Get Height |
|
| 192 | + * |
|
| 193 | + * @return int |
|
| 194 | + */ |
|
| 195 | + public function getHeight() { |
|
| 196 | + return $this->_height; |
|
| 197 | + } |
|
| 198 | + |
|
| 199 | + /** |
|
| 200 | + * Set Height |
|
| 201 | + * |
|
| 202 | + * @param int $pValue |
|
| 203 | + * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
| 204 | + */ |
|
| 205 | + public function setHeight($pValue = 0) { |
|
| 206 | + // Resize proportional? |
|
| 207 | + if ($this->_resizeProportional && $pValue != 0) { |
|
| 208 | + $ratio = $this->_width / $this->_height; |
|
| 209 | + $this->_width = round($ratio * $pValue); |
|
| 210 | + } |
|
| 211 | + |
|
| 212 | + // Set height |
|
| 213 | + $this->_height = $pValue; |
|
| 214 | + |
|
| 215 | + return $this; |
|
| 216 | + } |
|
| 217 | + |
|
| 218 | + /** |
|
| 219 | + * Set width and height with proportional resize |
|
| 220 | 220 | * Example: |
| 221 | 221 | * <code> |
| 222 | - * $objDrawing->setResizeProportional(true); |
|
| 223 | - * $objDrawing->setWidthAndHeight(160,120); |
|
| 222 | + * $objDrawing->setResizeProportional(true); |
|
| 223 | + * $objDrawing->setWidthAndHeight(160,120); |
|
| 224 | 224 | * </code> |
| 225 | 225 | * |
| 226 | - * @author Vincent@luo MSN:[email protected] |
|
| 227 | - * @param int $width |
|
| 228 | - * @param int $height |
|
| 229 | - * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
| 230 | - */ |
|
| 226 | + * @author Vincent@luo MSN:[email protected] |
|
| 227 | + * @param int $width |
|
| 228 | + * @param int $height |
|
| 229 | + * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
| 230 | + */ |
|
| 231 | 231 | public function setWidthAndHeight($width = 0, $height = 0) { |
| 232 | 232 | $xratio = $width / $this->_width; |
| 233 | 233 | $yratio = $height / $this->_height; |
@@ -243,79 +243,79 @@ discard block |
||
| 243 | 243 | return $this; |
| 244 | 244 | } |
| 245 | 245 | |
| 246 | - /** |
|
| 247 | - * Get ResizeProportional |
|
| 248 | - * |
|
| 249 | - * @return boolean |
|
| 250 | - */ |
|
| 251 | - public function getResizeProportional() { |
|
| 252 | - return $this->_resizeProportional; |
|
| 253 | - } |
|
| 254 | - |
|
| 255 | - /** |
|
| 256 | - * Set ResizeProportional |
|
| 257 | - * |
|
| 258 | - * @param boolean $pValue |
|
| 259 | - * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
| 260 | - */ |
|
| 261 | - public function setResizeProportional($pValue = true) { |
|
| 262 | - $this->_resizeProportional = $pValue; |
|
| 263 | - return $this; |
|
| 264 | - } |
|
| 265 | - |
|
| 266 | - /** |
|
| 267 | - * Get Filename |
|
| 268 | - * |
|
| 269 | - * @return string |
|
| 270 | - */ |
|
| 271 | - public function getFilename() { |
|
| 272 | - return basename($this->_path); |
|
| 273 | - } |
|
| 274 | - |
|
| 275 | - /** |
|
| 276 | - * Get Extension |
|
| 277 | - * |
|
| 278 | - * @return string |
|
| 279 | - */ |
|
| 280 | - public function getExtension() { |
|
| 281 | - $parts = explode(".", basename($this->_path)); |
|
| 282 | - return end($parts); |
|
| 283 | - } |
|
| 284 | - |
|
| 285 | - /** |
|
| 286 | - * Get Path |
|
| 287 | - * |
|
| 288 | - * @return string |
|
| 289 | - */ |
|
| 290 | - public function getPath() { |
|
| 291 | - return $this->_path; |
|
| 292 | - } |
|
| 293 | - |
|
| 294 | - /** |
|
| 295 | - * Set Path |
|
| 296 | - * |
|
| 297 | - * @param string $pValue File path |
|
| 298 | - * @param boolean $pVerifyFile Verify file |
|
| 299 | - * @throws Exception |
|
| 300 | - * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
| 301 | - */ |
|
| 302 | - public function setPath($pValue = '', $pVerifyFile = true) { |
|
| 303 | - if ($pVerifyFile) { |
|
| 304 | - if (file_exists($pValue)) { |
|
| 305 | - $this->_path = $pValue; |
|
| 306 | - |
|
| 307 | - if ($this->_width == 0 && $this->_height == 0) { |
|
| 308 | - // Get width/height |
|
| 309 | - list($this->_width, $this->_height) = getimagesize($pValue); |
|
| 310 | - } |
|
| 311 | - } else { |
|
| 312 | - throw new Exception("File $pValue not found!"); |
|
| 313 | - } |
|
| 314 | - } else { |
|
| 315 | - $this->_path = $pValue; |
|
| 316 | - } |
|
| 317 | - return $this; |
|
| 318 | - } |
|
| 246 | + /** |
|
| 247 | + * Get ResizeProportional |
|
| 248 | + * |
|
| 249 | + * @return boolean |
|
| 250 | + */ |
|
| 251 | + public function getResizeProportional() { |
|
| 252 | + return $this->_resizeProportional; |
|
| 253 | + } |
|
| 254 | + |
|
| 255 | + /** |
|
| 256 | + * Set ResizeProportional |
|
| 257 | + * |
|
| 258 | + * @param boolean $pValue |
|
| 259 | + * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
| 260 | + */ |
|
| 261 | + public function setResizeProportional($pValue = true) { |
|
| 262 | + $this->_resizeProportional = $pValue; |
|
| 263 | + return $this; |
|
| 264 | + } |
|
| 265 | + |
|
| 266 | + /** |
|
| 267 | + * Get Filename |
|
| 268 | + * |
|
| 269 | + * @return string |
|
| 270 | + */ |
|
| 271 | + public function getFilename() { |
|
| 272 | + return basename($this->_path); |
|
| 273 | + } |
|
| 274 | + |
|
| 275 | + /** |
|
| 276 | + * Get Extension |
|
| 277 | + * |
|
| 278 | + * @return string |
|
| 279 | + */ |
|
| 280 | + public function getExtension() { |
|
| 281 | + $parts = explode(".", basename($this->_path)); |
|
| 282 | + return end($parts); |
|
| 283 | + } |
|
| 284 | + |
|
| 285 | + /** |
|
| 286 | + * Get Path |
|
| 287 | + * |
|
| 288 | + * @return string |
|
| 289 | + */ |
|
| 290 | + public function getPath() { |
|
| 291 | + return $this->_path; |
|
| 292 | + } |
|
| 293 | + |
|
| 294 | + /** |
|
| 295 | + * Set Path |
|
| 296 | + * |
|
| 297 | + * @param string $pValue File path |
|
| 298 | + * @param boolean $pVerifyFile Verify file |
|
| 299 | + * @throws Exception |
|
| 300 | + * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
| 301 | + */ |
|
| 302 | + public function setPath($pValue = '', $pVerifyFile = true) { |
|
| 303 | + if ($pVerifyFile) { |
|
| 304 | + if (file_exists($pValue)) { |
|
| 305 | + $this->_path = $pValue; |
|
| 306 | + |
|
| 307 | + if ($this->_width == 0 && $this->_height == 0) { |
|
| 308 | + // Get width/height |
|
| 309 | + list($this->_width, $this->_height) = getimagesize($pValue); |
|
| 310 | + } |
|
| 311 | + } else { |
|
| 312 | + throw new Exception("File $pValue not found!"); |
|
| 313 | + } |
|
| 314 | + } else { |
|
| 315 | + $this->_path = $pValue; |
|
| 316 | + } |
|
| 317 | + return $this; |
|
| 318 | + } |
|
| 319 | 319 | |
| 320 | 320 | /** |
| 321 | 321 | * Get hash code |
@@ -323,16 +323,16 @@ discard block |
||
| 323 | 323 | * @return string Hash code |
| 324 | 324 | */ |
| 325 | 325 | public function getHashCode() { |
| 326 | - return md5( |
|
| 327 | - $this->_path |
|
| 328 | - . $this->_name |
|
| 329 | - . $this->_offsetX |
|
| 330 | - . $this->_offsetY |
|
| 331 | - . $this->_width |
|
| 332 | - . $this->_height |
|
| 333 | - . __CLASS__ |
|
| 334 | - ); |
|
| 335 | - } |
|
| 326 | + return md5( |
|
| 327 | + $this->_path |
|
| 328 | + . $this->_name |
|
| 329 | + . $this->_offsetX |
|
| 330 | + . $this->_offsetY |
|
| 331 | + . $this->_width |
|
| 332 | + . $this->_height |
|
| 333 | + . __CLASS__ |
|
| 334 | + ); |
|
| 335 | + } |
|
| 336 | 336 | |
| 337 | 337 | /** |
| 338 | 338 | * Implement PHP __clone to create a deep clone, not just a shallow copy. |
@@ -36,16 +36,16 @@ discard block |
||
| 36 | 36 | class PHPExcel_Worksheet_MemoryDrawing extends PHPExcel_Worksheet_BaseDrawing implements PHPExcel_IComparable |
| 37 | 37 | { |
| 38 | 38 | /* Rendering functions */ |
| 39 | - const RENDERING_DEFAULT = 'imagepng'; |
|
| 39 | + const RENDERING_DEFAULT = 'imagepng'; |
|
| 40 | 40 | const RENDERING_PNG = 'imagepng'; |
| 41 | 41 | const RENDERING_GIF = 'imagegif'; |
| 42 | 42 | const RENDERING_JPEG = 'imagejpeg'; |
| 43 | 43 | |
| 44 | 44 | /* MIME types */ |
| 45 | - const MIMETYPE_DEFAULT = 'image/png'; |
|
| 45 | + const MIMETYPE_DEFAULT = 'image/png'; |
|
| 46 | 46 | const MIMETYPE_PNG = 'image/png'; |
| 47 | 47 | const MIMETYPE_GIF = 'image/gif'; |
| 48 | - const MIMETYPE_JPEG = 'image/jpeg'; |
|
| 48 | + const MIMETYPE_JPEG = 'image/jpeg'; |
|
| 49 | 49 | |
| 50 | 50 | /** |
| 51 | 51 | * Image resource |
@@ -81,10 +81,10 @@ discard block |
||
| 81 | 81 | public function __construct() |
| 82 | 82 | { |
| 83 | 83 | // Initialise values |
| 84 | - $this->_imageResource = null; |
|
| 85 | - $this->_renderingFunction = self::RENDERING_DEFAULT; |
|
| 86 | - $this->_mimeType = self::MIMETYPE_DEFAULT; |
|
| 87 | - $this->_uniqueName = md5(rand(0, 9999). time() . rand(0, 9999)); |
|
| 84 | + $this->_imageResource = null; |
|
| 85 | + $this->_renderingFunction = self::RENDERING_DEFAULT; |
|
| 86 | + $this->_mimeType = self::MIMETYPE_DEFAULT; |
|
| 87 | + $this->_uniqueName = md5(rand(0, 9999).time().rand(0, 9999)); |
|
| 88 | 88 | |
| 89 | 89 | // Initialize parent |
| 90 | 90 | parent::__construct(); |
@@ -108,10 +108,10 @@ discard block |
||
| 108 | 108 | public function setImageResource($value = null) { |
| 109 | 109 | $this->_imageResource = $value; |
| 110 | 110 | |
| 111 | - if (!is_null($this->_imageResource)) { |
|
| 111 | + if ( ! is_null($this->_imageResource)) { |
|
| 112 | 112 | // Get width/height |
| 113 | - $this->_width = imagesx($this->_imageResource); |
|
| 114 | - $this->_height = imagesy($this->_imageResource); |
|
| 113 | + $this->_width = imagesx($this->_imageResource); |
|
| 114 | + $this->_height = imagesy($this->_imageResource); |
|
| 115 | 115 | } |
| 116 | 116 | return $this; |
| 117 | 117 | } |
@@ -166,7 +166,7 @@ discard block |
||
| 166 | 166 | $extension = explode('/', $extension); |
| 167 | 167 | $extension = $extension[1]; |
| 168 | 168 | |
| 169 | - return $this->_uniqueName . $this->getImageIndex() . '.' . $extension; |
|
| 169 | + return $this->_uniqueName.$this->getImageIndex().'.'.$extension; |
|
| 170 | 170 | } |
| 171 | 171 | |
| 172 | 172 | /** |
@@ -75,99 +75,99 @@ discard block |
||
| 75 | 75 | */ |
| 76 | 76 | private $_uniqueName; |
| 77 | 77 | |
| 78 | - /** |
|
| 79 | - * Create a new PHPExcel_Worksheet_MemoryDrawing |
|
| 80 | - */ |
|
| 81 | - public function __construct() |
|
| 82 | - { |
|
| 83 | - // Initialise values |
|
| 84 | - $this->_imageResource = null; |
|
| 85 | - $this->_renderingFunction = self::RENDERING_DEFAULT; |
|
| 86 | - $this->_mimeType = self::MIMETYPE_DEFAULT; |
|
| 87 | - $this->_uniqueName = md5(rand(0, 9999). time() . rand(0, 9999)); |
|
| 88 | - |
|
| 89 | - // Initialize parent |
|
| 90 | - parent::__construct(); |
|
| 91 | - } |
|
| 92 | - |
|
| 93 | - /** |
|
| 94 | - * Get image resource |
|
| 95 | - * |
|
| 96 | - * @return resource |
|
| 97 | - */ |
|
| 98 | - public function getImageResource() { |
|
| 99 | - return $this->_imageResource; |
|
| 100 | - } |
|
| 101 | - |
|
| 102 | - /** |
|
| 103 | - * Set image resource |
|
| 104 | - * |
|
| 105 | - * @param $value resource |
|
| 106 | - * @return PHPExcel_Worksheet_MemoryDrawing |
|
| 107 | - */ |
|
| 108 | - public function setImageResource($value = null) { |
|
| 109 | - $this->_imageResource = $value; |
|
| 110 | - |
|
| 111 | - if (!is_null($this->_imageResource)) { |
|
| 112 | - // Get width/height |
|
| 113 | - $this->_width = imagesx($this->_imageResource); |
|
| 114 | - $this->_height = imagesy($this->_imageResource); |
|
| 115 | - } |
|
| 116 | - return $this; |
|
| 117 | - } |
|
| 118 | - |
|
| 119 | - /** |
|
| 120 | - * Get rendering function |
|
| 121 | - * |
|
| 122 | - * @return string |
|
| 123 | - */ |
|
| 124 | - public function getRenderingFunction() { |
|
| 125 | - return $this->_renderingFunction; |
|
| 126 | - } |
|
| 127 | - |
|
| 128 | - /** |
|
| 129 | - * Set rendering function |
|
| 130 | - * |
|
| 131 | - * @param string $value |
|
| 132 | - * @return PHPExcel_Worksheet_MemoryDrawing |
|
| 133 | - */ |
|
| 134 | - public function setRenderingFunction($value = PHPExcel_Worksheet_MemoryDrawing::RENDERING_DEFAULT) { |
|
| 135 | - $this->_renderingFunction = $value; |
|
| 136 | - return $this; |
|
| 137 | - } |
|
| 138 | - |
|
| 139 | - /** |
|
| 140 | - * Get mime type |
|
| 141 | - * |
|
| 142 | - * @return string |
|
| 143 | - */ |
|
| 144 | - public function getMimeType() { |
|
| 145 | - return $this->_mimeType; |
|
| 146 | - } |
|
| 147 | - |
|
| 148 | - /** |
|
| 149 | - * Set mime type |
|
| 150 | - * |
|
| 151 | - * @param string $value |
|
| 152 | - * @return PHPExcel_Worksheet_MemoryDrawing |
|
| 153 | - */ |
|
| 154 | - public function setMimeType($value = PHPExcel_Worksheet_MemoryDrawing::MIMETYPE_DEFAULT) { |
|
| 155 | - $this->_mimeType = $value; |
|
| 156 | - return $this; |
|
| 157 | - } |
|
| 158 | - |
|
| 159 | - /** |
|
| 160 | - * Get indexed filename (using image index) |
|
| 161 | - * |
|
| 162 | - * @return string |
|
| 163 | - */ |
|
| 164 | - public function getIndexedFilename() { |
|
| 78 | + /** |
|
| 79 | + * Create a new PHPExcel_Worksheet_MemoryDrawing |
|
| 80 | + */ |
|
| 81 | + public function __construct() |
|
| 82 | + { |
|
| 83 | + // Initialise values |
|
| 84 | + $this->_imageResource = null; |
|
| 85 | + $this->_renderingFunction = self::RENDERING_DEFAULT; |
|
| 86 | + $this->_mimeType = self::MIMETYPE_DEFAULT; |
|
| 87 | + $this->_uniqueName = md5(rand(0, 9999). time() . rand(0, 9999)); |
|
| 88 | + |
|
| 89 | + // Initialize parent |
|
| 90 | + parent::__construct(); |
|
| 91 | + } |
|
| 92 | + |
|
| 93 | + /** |
|
| 94 | + * Get image resource |
|
| 95 | + * |
|
| 96 | + * @return resource |
|
| 97 | + */ |
|
| 98 | + public function getImageResource() { |
|
| 99 | + return $this->_imageResource; |
|
| 100 | + } |
|
| 101 | + |
|
| 102 | + /** |
|
| 103 | + * Set image resource |
|
| 104 | + * |
|
| 105 | + * @param $value resource |
|
| 106 | + * @return PHPExcel_Worksheet_MemoryDrawing |
|
| 107 | + */ |
|
| 108 | + public function setImageResource($value = null) { |
|
| 109 | + $this->_imageResource = $value; |
|
| 110 | + |
|
| 111 | + if (!is_null($this->_imageResource)) { |
|
| 112 | + // Get width/height |
|
| 113 | + $this->_width = imagesx($this->_imageResource); |
|
| 114 | + $this->_height = imagesy($this->_imageResource); |
|
| 115 | + } |
|
| 116 | + return $this; |
|
| 117 | + } |
|
| 118 | + |
|
| 119 | + /** |
|
| 120 | + * Get rendering function |
|
| 121 | + * |
|
| 122 | + * @return string |
|
| 123 | + */ |
|
| 124 | + public function getRenderingFunction() { |
|
| 125 | + return $this->_renderingFunction; |
|
| 126 | + } |
|
| 127 | + |
|
| 128 | + /** |
|
| 129 | + * Set rendering function |
|
| 130 | + * |
|
| 131 | + * @param string $value |
|
| 132 | + * @return PHPExcel_Worksheet_MemoryDrawing |
|
| 133 | + */ |
|
| 134 | + public function setRenderingFunction($value = PHPExcel_Worksheet_MemoryDrawing::RENDERING_DEFAULT) { |
|
| 135 | + $this->_renderingFunction = $value; |
|
| 136 | + return $this; |
|
| 137 | + } |
|
| 138 | + |
|
| 139 | + /** |
|
| 140 | + * Get mime type |
|
| 141 | + * |
|
| 142 | + * @return string |
|
| 143 | + */ |
|
| 144 | + public function getMimeType() { |
|
| 145 | + return $this->_mimeType; |
|
| 146 | + } |
|
| 147 | + |
|
| 148 | + /** |
|
| 149 | + * Set mime type |
|
| 150 | + * |
|
| 151 | + * @param string $value |
|
| 152 | + * @return PHPExcel_Worksheet_MemoryDrawing |
|
| 153 | + */ |
|
| 154 | + public function setMimeType($value = PHPExcel_Worksheet_MemoryDrawing::MIMETYPE_DEFAULT) { |
|
| 155 | + $this->_mimeType = $value; |
|
| 156 | + return $this; |
|
| 157 | + } |
|
| 158 | + |
|
| 159 | + /** |
|
| 160 | + * Get indexed filename (using image index) |
|
| 161 | + * |
|
| 162 | + * @return string |
|
| 163 | + */ |
|
| 164 | + public function getIndexedFilename() { |
|
| 165 | 165 | $extension = strtolower($this->getMimeType()); |
| 166 | 166 | $extension = explode('/', $extension); |
| 167 | 167 | $extension = $extension[1]; |
| 168 | 168 | |
| 169 | - return $this->_uniqueName . $this->getImageIndex() . '.' . $extension; |
|
| 170 | - } |
|
| 169 | + return $this->_uniqueName . $this->getImageIndex() . '.' . $extension; |
|
| 170 | + } |
|
| 171 | 171 | |
| 172 | 172 | /** |
| 173 | 173 | * Get hash code |
@@ -175,14 +175,14 @@ discard block |
||
| 175 | 175 | * @return string Hash code |
| 176 | 176 | */ |
| 177 | 177 | public function getHashCode() { |
| 178 | - return md5( |
|
| 179 | - $this->_renderingFunction |
|
| 180 | - . $this->_mimeType |
|
| 181 | - . $this->_uniqueName |
|
| 182 | - . parent::getHashCode() |
|
| 183 | - . __CLASS__ |
|
| 184 | - ); |
|
| 185 | - } |
|
| 178 | + return md5( |
|
| 179 | + $this->_renderingFunction |
|
| 180 | + . $this->_mimeType |
|
| 181 | + . $this->_uniqueName |
|
| 182 | + . parent::getHashCode() |
|
| 183 | + . __CLASS__ |
|
| 184 | + ); |
|
| 185 | + } |
|
| 186 | 186 | |
| 187 | 187 | /** |
| 188 | 188 | * Implement PHP __clone to create a deep clone, not just a shallow copy. |
@@ -40,42 +40,42 @@ |
||
| 40 | 40 | * |
| 41 | 41 | * @var double |
| 42 | 42 | */ |
| 43 | - private $_left = 0.7; |
|
| 43 | + private $_left = 0.7; |
|
| 44 | 44 | |
| 45 | 45 | /** |
| 46 | 46 | * Right |
| 47 | 47 | * |
| 48 | 48 | * @var double |
| 49 | 49 | */ |
| 50 | - private $_right = 0.7; |
|
| 50 | + private $_right = 0.7; |
|
| 51 | 51 | |
| 52 | 52 | /** |
| 53 | 53 | * Top |
| 54 | 54 | * |
| 55 | 55 | * @var double |
| 56 | 56 | */ |
| 57 | - private $_top = 0.75; |
|
| 57 | + private $_top = 0.75; |
|
| 58 | 58 | |
| 59 | 59 | /** |
| 60 | 60 | * Bottom |
| 61 | 61 | * |
| 62 | 62 | * @var double |
| 63 | 63 | */ |
| 64 | - private $_bottom = 0.75; |
|
| 64 | + private $_bottom = 0.75; |
|
| 65 | 65 | |
| 66 | 66 | /** |
| 67 | 67 | * Header |
| 68 | 68 | * |
| 69 | 69 | * @var double |
| 70 | 70 | */ |
| 71 | - private $_header = 0.3; |
|
| 71 | + private $_header = 0.3; |
|
| 72 | 72 | |
| 73 | 73 | /** |
| 74 | 74 | * Footer |
| 75 | 75 | * |
| 76 | 76 | * @var double |
| 77 | 77 | */ |
| 78 | - private $_footer = 0.3; |
|
| 78 | + private $_footer = 0.3; |
|
| 79 | 79 | |
| 80 | 80 | /** |
| 81 | 81 | * Create a new PHPExcel_Worksheet_PageMargins |
@@ -77,132 +77,132 @@ |
||
| 77 | 77 | */ |
| 78 | 78 | private $_footer = 0.3; |
| 79 | 79 | |
| 80 | - /** |
|
| 81 | - * Create a new PHPExcel_Worksheet_PageMargins |
|
| 82 | - */ |
|
| 83 | - public function __construct() |
|
| 84 | - { |
|
| 85 | - } |
|
| 86 | - |
|
| 87 | - /** |
|
| 88 | - * Get Left |
|
| 89 | - * |
|
| 90 | - * @return double |
|
| 91 | - */ |
|
| 92 | - public function getLeft() { |
|
| 93 | - return $this->_left; |
|
| 94 | - } |
|
| 95 | - |
|
| 96 | - /** |
|
| 97 | - * Set Left |
|
| 98 | - * |
|
| 99 | - * @param double $pValue |
|
| 100 | - * @return PHPExcel_Worksheet_PageMargins |
|
| 101 | - */ |
|
| 102 | - public function setLeft($pValue) { |
|
| 103 | - $this->_left = $pValue; |
|
| 104 | - return $this; |
|
| 105 | - } |
|
| 106 | - |
|
| 107 | - /** |
|
| 108 | - * Get Right |
|
| 109 | - * |
|
| 110 | - * @return double |
|
| 111 | - */ |
|
| 112 | - public function getRight() { |
|
| 113 | - return $this->_right; |
|
| 114 | - } |
|
| 115 | - |
|
| 116 | - /** |
|
| 117 | - * Set Right |
|
| 118 | - * |
|
| 119 | - * @param double $pValue |
|
| 120 | - * @return PHPExcel_Worksheet_PageMargins |
|
| 121 | - */ |
|
| 122 | - public function setRight($pValue) { |
|
| 123 | - $this->_right = $pValue; |
|
| 124 | - return $this; |
|
| 125 | - } |
|
| 126 | - |
|
| 127 | - /** |
|
| 128 | - * Get Top |
|
| 129 | - * |
|
| 130 | - * @return double |
|
| 131 | - */ |
|
| 132 | - public function getTop() { |
|
| 133 | - return $this->_top; |
|
| 134 | - } |
|
| 135 | - |
|
| 136 | - /** |
|
| 137 | - * Set Top |
|
| 138 | - * |
|
| 139 | - * @param double $pValue |
|
| 140 | - * @return PHPExcel_Worksheet_PageMargins |
|
| 141 | - */ |
|
| 142 | - public function setTop($pValue) { |
|
| 143 | - $this->_top = $pValue; |
|
| 144 | - return $this; |
|
| 145 | - } |
|
| 146 | - |
|
| 147 | - /** |
|
| 148 | - * Get Bottom |
|
| 149 | - * |
|
| 150 | - * @return double |
|
| 151 | - */ |
|
| 152 | - public function getBottom() { |
|
| 153 | - return $this->_bottom; |
|
| 154 | - } |
|
| 155 | - |
|
| 156 | - /** |
|
| 157 | - * Set Bottom |
|
| 158 | - * |
|
| 159 | - * @param double $pValue |
|
| 160 | - * @return PHPExcel_Worksheet_PageMargins |
|
| 161 | - */ |
|
| 162 | - public function setBottom($pValue) { |
|
| 163 | - $this->_bottom = $pValue; |
|
| 164 | - return $this; |
|
| 165 | - } |
|
| 166 | - |
|
| 167 | - /** |
|
| 168 | - * Get Header |
|
| 169 | - * |
|
| 170 | - * @return double |
|
| 171 | - */ |
|
| 172 | - public function getHeader() { |
|
| 173 | - return $this->_header; |
|
| 174 | - } |
|
| 175 | - |
|
| 176 | - /** |
|
| 177 | - * Set Header |
|
| 178 | - * |
|
| 179 | - * @param double $pValue |
|
| 180 | - * @return PHPExcel_Worksheet_PageMargins |
|
| 181 | - */ |
|
| 182 | - public function setHeader($pValue) { |
|
| 183 | - $this->_header = $pValue; |
|
| 184 | - return $this; |
|
| 185 | - } |
|
| 186 | - |
|
| 187 | - /** |
|
| 188 | - * Get Footer |
|
| 189 | - * |
|
| 190 | - * @return double |
|
| 191 | - */ |
|
| 192 | - public function getFooter() { |
|
| 193 | - return $this->_footer; |
|
| 194 | - } |
|
| 195 | - |
|
| 196 | - /** |
|
| 197 | - * Set Footer |
|
| 198 | - * |
|
| 199 | - * @param double $pValue |
|
| 200 | - * @return PHPExcel_Worksheet_PageMargins |
|
| 201 | - */ |
|
| 202 | - public function setFooter($pValue) { |
|
| 203 | - $this->_footer = $pValue; |
|
| 204 | - return $this; |
|
| 205 | - } |
|
| 80 | + /** |
|
| 81 | + * Create a new PHPExcel_Worksheet_PageMargins |
|
| 82 | + */ |
|
| 83 | + public function __construct() |
|
| 84 | + { |
|
| 85 | + } |
|
| 86 | + |
|
| 87 | + /** |
|
| 88 | + * Get Left |
|
| 89 | + * |
|
| 90 | + * @return double |
|
| 91 | + */ |
|
| 92 | + public function getLeft() { |
|
| 93 | + return $this->_left; |
|
| 94 | + } |
|
| 95 | + |
|
| 96 | + /** |
|
| 97 | + * Set Left |
|
| 98 | + * |
|
| 99 | + * @param double $pValue |
|
| 100 | + * @return PHPExcel_Worksheet_PageMargins |
|
| 101 | + */ |
|
| 102 | + public function setLeft($pValue) { |
|
| 103 | + $this->_left = $pValue; |
|
| 104 | + return $this; |
|
| 105 | + } |
|
| 106 | + |
|
| 107 | + /** |
|
| 108 | + * Get Right |
|
| 109 | + * |
|
| 110 | + * @return double |
|
| 111 | + */ |
|
| 112 | + public function getRight() { |
|
| 113 | + return $this->_right; |
|
| 114 | + } |
|
| 115 | + |
|
| 116 | + /** |
|
| 117 | + * Set Right |
|
| 118 | + * |
|
| 119 | + * @param double $pValue |
|
| 120 | + * @return PHPExcel_Worksheet_PageMargins |
|
| 121 | + */ |
|
| 122 | + public function setRight($pValue) { |
|
| 123 | + $this->_right = $pValue; |
|
| 124 | + return $this; |
|
| 125 | + } |
|
| 126 | + |
|
| 127 | + /** |
|
| 128 | + * Get Top |
|
| 129 | + * |
|
| 130 | + * @return double |
|
| 131 | + */ |
|
| 132 | + public function getTop() { |
|
| 133 | + return $this->_top; |
|
| 134 | + } |
|
| 135 | + |
|
| 136 | + /** |
|
| 137 | + * Set Top |
|
| 138 | + * |
|
| 139 | + * @param double $pValue |
|
| 140 | + * @return PHPExcel_Worksheet_PageMargins |
|
| 141 | + */ |
|
| 142 | + public function setTop($pValue) { |
|
| 143 | + $this->_top = $pValue; |
|
| 144 | + return $this; |
|
| 145 | + } |
|
| 146 | + |
|
| 147 | + /** |
|
| 148 | + * Get Bottom |
|
| 149 | + * |
|
| 150 | + * @return double |
|
| 151 | + */ |
|
| 152 | + public function getBottom() { |
|
| 153 | + return $this->_bottom; |
|
| 154 | + } |
|
| 155 | + |
|
| 156 | + /** |
|
| 157 | + * Set Bottom |
|
| 158 | + * |
|
| 159 | + * @param double $pValue |
|
| 160 | + * @return PHPExcel_Worksheet_PageMargins |
|
| 161 | + */ |
|
| 162 | + public function setBottom($pValue) { |
|
| 163 | + $this->_bottom = $pValue; |
|
| 164 | + return $this; |
|
| 165 | + } |
|
| 166 | + |
|
| 167 | + /** |
|
| 168 | + * Get Header |
|
| 169 | + * |
|
| 170 | + * @return double |
|
| 171 | + */ |
|
| 172 | + public function getHeader() { |
|
| 173 | + return $this->_header; |
|
| 174 | + } |
|
| 175 | + |
|
| 176 | + /** |
|
| 177 | + * Set Header |
|
| 178 | + * |
|
| 179 | + * @param double $pValue |
|
| 180 | + * @return PHPExcel_Worksheet_PageMargins |
|
| 181 | + */ |
|
| 182 | + public function setHeader($pValue) { |
|
| 183 | + $this->_header = $pValue; |
|
| 184 | + return $this; |
|
| 185 | + } |
|
| 186 | + |
|
| 187 | + /** |
|
| 188 | + * Get Footer |
|
| 189 | + * |
|
| 190 | + * @return double |
|
| 191 | + */ |
|
| 192 | + public function getFooter() { |
|
| 193 | + return $this->_footer; |
|
| 194 | + } |
|
| 195 | + |
|
| 196 | + /** |
|
| 197 | + * Set Footer |
|
| 198 | + * |
|
| 199 | + * @param double $pValue |
|
| 200 | + * @return PHPExcel_Worksheet_PageMargins |
|
| 201 | + */ |
|
| 202 | + public function setFooter($pValue) { |
|
| 203 | + $this->_footer = $pValue; |
|
| 204 | + return $this; |
|
| 205 | + } |
|
| 206 | 206 | |
| 207 | 207 | /** |
| 208 | 208 | * Implement PHP __clone to create a deep clone, not just a shallow copy. |
@@ -40,119 +40,119 @@ discard block |
||
| 40 | 40 | * |
| 41 | 41 | * @var boolean |
| 42 | 42 | */ |
| 43 | - private $_sheet = false; |
|
| 43 | + private $_sheet = false; |
|
| 44 | 44 | |
| 45 | 45 | /** |
| 46 | 46 | * Objects |
| 47 | 47 | * |
| 48 | 48 | * @var boolean |
| 49 | 49 | */ |
| 50 | - private $_objects = false; |
|
| 50 | + private $_objects = false; |
|
| 51 | 51 | |
| 52 | 52 | /** |
| 53 | 53 | * Scenarios |
| 54 | 54 | * |
| 55 | 55 | * @var boolean |
| 56 | 56 | */ |
| 57 | - private $_scenarios = false; |
|
| 57 | + private $_scenarios = false; |
|
| 58 | 58 | |
| 59 | 59 | /** |
| 60 | 60 | * Format cells |
| 61 | 61 | * |
| 62 | 62 | * @var boolean |
| 63 | 63 | */ |
| 64 | - private $_formatCells = false; |
|
| 64 | + private $_formatCells = false; |
|
| 65 | 65 | |
| 66 | 66 | /** |
| 67 | 67 | * Format columns |
| 68 | 68 | * |
| 69 | 69 | * @var boolean |
| 70 | 70 | */ |
| 71 | - private $_formatColumns = false; |
|
| 71 | + private $_formatColumns = false; |
|
| 72 | 72 | |
| 73 | 73 | /** |
| 74 | 74 | * Format rows |
| 75 | 75 | * |
| 76 | 76 | * @var boolean |
| 77 | 77 | */ |
| 78 | - private $_formatRows = false; |
|
| 78 | + private $_formatRows = false; |
|
| 79 | 79 | |
| 80 | 80 | /** |
| 81 | 81 | * Insert columns |
| 82 | 82 | * |
| 83 | 83 | * @var boolean |
| 84 | 84 | */ |
| 85 | - private $_insertColumns = false; |
|
| 85 | + private $_insertColumns = false; |
|
| 86 | 86 | |
| 87 | 87 | /** |
| 88 | 88 | * Insert rows |
| 89 | 89 | * |
| 90 | 90 | * @var boolean |
| 91 | 91 | */ |
| 92 | - private $_insertRows = false; |
|
| 92 | + private $_insertRows = false; |
|
| 93 | 93 | |
| 94 | 94 | /** |
| 95 | 95 | * Insert hyperlinks |
| 96 | 96 | * |
| 97 | 97 | * @var boolean |
| 98 | 98 | */ |
| 99 | - private $_insertHyperlinks = false; |
|
| 99 | + private $_insertHyperlinks = false; |
|
| 100 | 100 | |
| 101 | 101 | /** |
| 102 | 102 | * Delete columns |
| 103 | 103 | * |
| 104 | 104 | * @var boolean |
| 105 | 105 | */ |
| 106 | - private $_deleteColumns = false; |
|
| 106 | + private $_deleteColumns = false; |
|
| 107 | 107 | |
| 108 | 108 | /** |
| 109 | 109 | * Delete rows |
| 110 | 110 | * |
| 111 | 111 | * @var boolean |
| 112 | 112 | */ |
| 113 | - private $_deleteRows = false; |
|
| 113 | + private $_deleteRows = false; |
|
| 114 | 114 | |
| 115 | 115 | /** |
| 116 | 116 | * Select locked cells |
| 117 | 117 | * |
| 118 | 118 | * @var boolean |
| 119 | 119 | */ |
| 120 | - private $_selectLockedCells = false; |
|
| 120 | + private $_selectLockedCells = false; |
|
| 121 | 121 | |
| 122 | 122 | /** |
| 123 | 123 | * Sort |
| 124 | 124 | * |
| 125 | 125 | * @var boolean |
| 126 | 126 | */ |
| 127 | - private $_sort = false; |
|
| 127 | + private $_sort = false; |
|
| 128 | 128 | |
| 129 | 129 | /** |
| 130 | 130 | * AutoFilter |
| 131 | 131 | * |
| 132 | 132 | * @var boolean |
| 133 | 133 | */ |
| 134 | - private $_autoFilter = false; |
|
| 134 | + private $_autoFilter = false; |
|
| 135 | 135 | |
| 136 | 136 | /** |
| 137 | 137 | * Pivot tables |
| 138 | 138 | * |
| 139 | 139 | * @var boolean |
| 140 | 140 | */ |
| 141 | - private $_pivotTables = false; |
|
| 141 | + private $_pivotTables = false; |
|
| 142 | 142 | |
| 143 | 143 | /** |
| 144 | 144 | * Select unlocked cells |
| 145 | 145 | * |
| 146 | 146 | * @var boolean |
| 147 | 147 | */ |
| 148 | - private $_selectUnlockedCells = false; |
|
| 148 | + private $_selectUnlockedCells = false; |
|
| 149 | 149 | |
| 150 | 150 | /** |
| 151 | 151 | * Password |
| 152 | 152 | * |
| 153 | 153 | * @var string |
| 154 | 154 | */ |
| 155 | - private $_password = ''; |
|
| 155 | + private $_password = ''; |
|
| 156 | 156 | |
| 157 | 157 | /** |
| 158 | 158 | * Create a new PHPExcel_Worksheet_Protection |
@@ -522,7 +522,7 @@ discard block |
||
| 522 | 522 | * @return PHPExcel_Worksheet_Protection |
| 523 | 523 | */ |
| 524 | 524 | function setPassword($pValue = '', $pAlreadyHashed = false) { |
| 525 | - if (!$pAlreadyHashed) { |
|
| 525 | + if ( ! $pAlreadyHashed) { |
|
| 526 | 526 | $pValue = PHPExcel_Shared_PasswordHasher::hashPassword($pValue); |
| 527 | 527 | } |
| 528 | 528 | $this->_password = $pValue; |
@@ -154,20 +154,20 @@ discard block |
||
| 154 | 154 | */ |
| 155 | 155 | private $_password = ''; |
| 156 | 156 | |
| 157 | - /** |
|
| 158 | - * Create a new PHPExcel_Worksheet_Protection |
|
| 159 | - */ |
|
| 160 | - public function __construct() |
|
| 161 | - { |
|
| 162 | - } |
|
| 163 | - |
|
| 164 | - /** |
|
| 165 | - * Is some sort of protection enabled? |
|
| 166 | - * |
|
| 167 | - * @return boolean |
|
| 168 | - */ |
|
| 169 | - function isProtectionEnabled() { |
|
| 170 | - return $this->_sheet || |
|
| 157 | + /** |
|
| 158 | + * Create a new PHPExcel_Worksheet_Protection |
|
| 159 | + */ |
|
| 160 | + public function __construct() |
|
| 161 | + { |
|
| 162 | + } |
|
| 163 | + |
|
| 164 | + /** |
|
| 165 | + * Is some sort of protection enabled? |
|
| 166 | + * |
|
| 167 | + * @return boolean |
|
| 168 | + */ |
|
| 169 | + function isProtectionEnabled() { |
|
| 170 | + return $this->_sheet || |
|
| 171 | 171 | $this->_objects || |
| 172 | 172 | $this->_scenarios || |
| 173 | 173 | $this->_formatCells || |
@@ -183,351 +183,351 @@ discard block |
||
| 183 | 183 | $this->_autoFilter || |
| 184 | 184 | $this->_pivotTables || |
| 185 | 185 | $this->_selectUnlockedCells; |
| 186 | - } |
|
| 187 | - |
|
| 188 | - /** |
|
| 189 | - * Get Sheet |
|
| 190 | - * |
|
| 191 | - * @return boolean |
|
| 192 | - */ |
|
| 193 | - function getSheet() { |
|
| 194 | - return $this->_sheet; |
|
| 195 | - } |
|
| 196 | - |
|
| 197 | - /** |
|
| 198 | - * Set Sheet |
|
| 199 | - * |
|
| 200 | - * @param boolean $pValue |
|
| 201 | - * @return PHPExcel_Worksheet_Protection |
|
| 202 | - */ |
|
| 203 | - function setSheet($pValue = false) { |
|
| 204 | - $this->_sheet = $pValue; |
|
| 205 | - return $this; |
|
| 206 | - } |
|
| 207 | - |
|
| 208 | - /** |
|
| 209 | - * Get Objects |
|
| 210 | - * |
|
| 211 | - * @return boolean |
|
| 212 | - */ |
|
| 213 | - function getObjects() { |
|
| 214 | - return $this->_objects; |
|
| 215 | - } |
|
| 216 | - |
|
| 217 | - /** |
|
| 218 | - * Set Objects |
|
| 219 | - * |
|
| 220 | - * @param boolean $pValue |
|
| 221 | - * @return PHPExcel_Worksheet_Protection |
|
| 222 | - */ |
|
| 223 | - function setObjects($pValue = false) { |
|
| 224 | - $this->_objects = $pValue; |
|
| 225 | - return $this; |
|
| 226 | - } |
|
| 227 | - |
|
| 228 | - /** |
|
| 229 | - * Get Scenarios |
|
| 230 | - * |
|
| 231 | - * @return boolean |
|
| 232 | - */ |
|
| 233 | - function getScenarios() { |
|
| 234 | - return $this->_scenarios; |
|
| 235 | - } |
|
| 236 | - |
|
| 237 | - /** |
|
| 238 | - * Set Scenarios |
|
| 239 | - * |
|
| 240 | - * @param boolean $pValue |
|
| 241 | - * @return PHPExcel_Worksheet_Protection |
|
| 242 | - */ |
|
| 243 | - function setScenarios($pValue = false) { |
|
| 244 | - $this->_scenarios = $pValue; |
|
| 245 | - return $this; |
|
| 246 | - } |
|
| 247 | - |
|
| 248 | - /** |
|
| 249 | - * Get FormatCells |
|
| 250 | - * |
|
| 251 | - * @return boolean |
|
| 252 | - */ |
|
| 253 | - function getFormatCells() { |
|
| 254 | - return $this->_formatCells; |
|
| 255 | - } |
|
| 256 | - |
|
| 257 | - /** |
|
| 258 | - * Set FormatCells |
|
| 259 | - * |
|
| 260 | - * @param boolean $pValue |
|
| 261 | - * @return PHPExcel_Worksheet_Protection |
|
| 262 | - */ |
|
| 263 | - function setFormatCells($pValue = false) { |
|
| 264 | - $this->_formatCells = $pValue; |
|
| 265 | - return $this; |
|
| 266 | - } |
|
| 267 | - |
|
| 268 | - /** |
|
| 269 | - * Get FormatColumns |
|
| 270 | - * |
|
| 271 | - * @return boolean |
|
| 272 | - */ |
|
| 273 | - function getFormatColumns() { |
|
| 274 | - return $this->_formatColumns; |
|
| 275 | - } |
|
| 276 | - |
|
| 277 | - /** |
|
| 278 | - * Set FormatColumns |
|
| 279 | - * |
|
| 280 | - * @param boolean $pValue |
|
| 281 | - * @return PHPExcel_Worksheet_Protection |
|
| 282 | - */ |
|
| 283 | - function setFormatColumns($pValue = false) { |
|
| 284 | - $this->_formatColumns = $pValue; |
|
| 285 | - return $this; |
|
| 286 | - } |
|
| 287 | - |
|
| 288 | - /** |
|
| 289 | - * Get FormatRows |
|
| 290 | - * |
|
| 291 | - * @return boolean |
|
| 292 | - */ |
|
| 293 | - function getFormatRows() { |
|
| 294 | - return $this->_formatRows; |
|
| 295 | - } |
|
| 296 | - |
|
| 297 | - /** |
|
| 298 | - * Set FormatRows |
|
| 299 | - * |
|
| 300 | - * @param boolean $pValue |
|
| 301 | - * @return PHPExcel_Worksheet_Protection |
|
| 302 | - */ |
|
| 303 | - function setFormatRows($pValue = false) { |
|
| 304 | - $this->_formatRows = $pValue; |
|
| 305 | - return $this; |
|
| 306 | - } |
|
| 307 | - |
|
| 308 | - /** |
|
| 309 | - * Get InsertColumns |
|
| 310 | - * |
|
| 311 | - * @return boolean |
|
| 312 | - */ |
|
| 313 | - function getInsertColumns() { |
|
| 314 | - return $this->_insertColumns; |
|
| 315 | - } |
|
| 316 | - |
|
| 317 | - /** |
|
| 318 | - * Set InsertColumns |
|
| 319 | - * |
|
| 320 | - * @param boolean $pValue |
|
| 321 | - * @return PHPExcel_Worksheet_Protection |
|
| 322 | - */ |
|
| 323 | - function setInsertColumns($pValue = false) { |
|
| 324 | - $this->_insertColumns = $pValue; |
|
| 325 | - return $this; |
|
| 326 | - } |
|
| 327 | - |
|
| 328 | - /** |
|
| 329 | - * Get InsertRows |
|
| 330 | - * |
|
| 331 | - * @return boolean |
|
| 332 | - */ |
|
| 333 | - function getInsertRows() { |
|
| 334 | - return $this->_insertRows; |
|
| 335 | - } |
|
| 336 | - |
|
| 337 | - /** |
|
| 338 | - * Set InsertRows |
|
| 339 | - * |
|
| 340 | - * @param boolean $pValue |
|
| 341 | - * @return PHPExcel_Worksheet_Protection |
|
| 342 | - */ |
|
| 343 | - function setInsertRows($pValue = false) { |
|
| 344 | - $this->_insertRows = $pValue; |
|
| 345 | - return $this; |
|
| 346 | - } |
|
| 347 | - |
|
| 348 | - /** |
|
| 349 | - * Get InsertHyperlinks |
|
| 350 | - * |
|
| 351 | - * @return boolean |
|
| 352 | - */ |
|
| 353 | - function getInsertHyperlinks() { |
|
| 354 | - return $this->_insertHyperlinks; |
|
| 355 | - } |
|
| 356 | - |
|
| 357 | - /** |
|
| 358 | - * Set InsertHyperlinks |
|
| 359 | - * |
|
| 360 | - * @param boolean $pValue |
|
| 361 | - * @return PHPExcel_Worksheet_Protection |
|
| 362 | - */ |
|
| 363 | - function setInsertHyperlinks($pValue = false) { |
|
| 364 | - $this->_insertHyperlinks = $pValue; |
|
| 365 | - return $this; |
|
| 366 | - } |
|
| 367 | - |
|
| 368 | - /** |
|
| 369 | - * Get DeleteColumns |
|
| 370 | - * |
|
| 371 | - * @return boolean |
|
| 372 | - */ |
|
| 373 | - function getDeleteColumns() { |
|
| 374 | - return $this->_deleteColumns; |
|
| 375 | - } |
|
| 376 | - |
|
| 377 | - /** |
|
| 378 | - * Set DeleteColumns |
|
| 379 | - * |
|
| 380 | - * @param boolean $pValue |
|
| 381 | - * @return PHPExcel_Worksheet_Protection |
|
| 382 | - */ |
|
| 383 | - function setDeleteColumns($pValue = false) { |
|
| 384 | - $this->_deleteColumns = $pValue; |
|
| 385 | - return $this; |
|
| 386 | - } |
|
| 387 | - |
|
| 388 | - /** |
|
| 389 | - * Get DeleteRows |
|
| 390 | - * |
|
| 391 | - * @return boolean |
|
| 392 | - */ |
|
| 393 | - function getDeleteRows() { |
|
| 394 | - return $this->_deleteRows; |
|
| 395 | - } |
|
| 396 | - |
|
| 397 | - /** |
|
| 398 | - * Set DeleteRows |
|
| 399 | - * |
|
| 400 | - * @param boolean $pValue |
|
| 401 | - * @return PHPExcel_Worksheet_Protection |
|
| 402 | - */ |
|
| 403 | - function setDeleteRows($pValue = false) { |
|
| 404 | - $this->_deleteRows = $pValue; |
|
| 405 | - return $this; |
|
| 406 | - } |
|
| 407 | - |
|
| 408 | - /** |
|
| 409 | - * Get SelectLockedCells |
|
| 410 | - * |
|
| 411 | - * @return boolean |
|
| 412 | - */ |
|
| 413 | - function getSelectLockedCells() { |
|
| 414 | - return $this->_selectLockedCells; |
|
| 415 | - } |
|
| 416 | - |
|
| 417 | - /** |
|
| 418 | - * Set SelectLockedCells |
|
| 419 | - * |
|
| 420 | - * @param boolean $pValue |
|
| 421 | - * @return PHPExcel_Worksheet_Protection |
|
| 422 | - */ |
|
| 423 | - function setSelectLockedCells($pValue = false) { |
|
| 424 | - $this->_selectLockedCells = $pValue; |
|
| 425 | - return $this; |
|
| 426 | - } |
|
| 427 | - |
|
| 428 | - /** |
|
| 429 | - * Get Sort |
|
| 430 | - * |
|
| 431 | - * @return boolean |
|
| 432 | - */ |
|
| 433 | - function getSort() { |
|
| 434 | - return $this->_sort; |
|
| 435 | - } |
|
| 436 | - |
|
| 437 | - /** |
|
| 438 | - * Set Sort |
|
| 439 | - * |
|
| 440 | - * @param boolean $pValue |
|
| 441 | - * @return PHPExcel_Worksheet_Protection |
|
| 442 | - */ |
|
| 443 | - function setSort($pValue = false) { |
|
| 444 | - $this->_sort = $pValue; |
|
| 445 | - return $this; |
|
| 446 | - } |
|
| 447 | - |
|
| 448 | - /** |
|
| 449 | - * Get AutoFilter |
|
| 450 | - * |
|
| 451 | - * @return boolean |
|
| 452 | - */ |
|
| 453 | - function getAutoFilter() { |
|
| 454 | - return $this->_autoFilter; |
|
| 455 | - } |
|
| 456 | - |
|
| 457 | - /** |
|
| 458 | - * Set AutoFilter |
|
| 459 | - * |
|
| 460 | - * @param boolean $pValue |
|
| 461 | - * @return PHPExcel_Worksheet_Protection |
|
| 462 | - */ |
|
| 463 | - function setAutoFilter($pValue = false) { |
|
| 464 | - $this->_autoFilter = $pValue; |
|
| 465 | - return $this; |
|
| 466 | - } |
|
| 467 | - |
|
| 468 | - /** |
|
| 469 | - * Get PivotTables |
|
| 470 | - * |
|
| 471 | - * @return boolean |
|
| 472 | - */ |
|
| 473 | - function getPivotTables() { |
|
| 474 | - return $this->_pivotTables; |
|
| 475 | - } |
|
| 476 | - |
|
| 477 | - /** |
|
| 478 | - * Set PivotTables |
|
| 479 | - * |
|
| 480 | - * @param boolean $pValue |
|
| 481 | - * @return PHPExcel_Worksheet_Protection |
|
| 482 | - */ |
|
| 483 | - function setPivotTables($pValue = false) { |
|
| 484 | - $this->_pivotTables = $pValue; |
|
| 485 | - return $this; |
|
| 486 | - } |
|
| 487 | - |
|
| 488 | - /** |
|
| 489 | - * Get SelectUnlockedCells |
|
| 490 | - * |
|
| 491 | - * @return boolean |
|
| 492 | - */ |
|
| 493 | - function getSelectUnlockedCells() { |
|
| 494 | - return $this->_selectUnlockedCells; |
|
| 495 | - } |
|
| 496 | - |
|
| 497 | - /** |
|
| 498 | - * Set SelectUnlockedCells |
|
| 499 | - * |
|
| 500 | - * @param boolean $pValue |
|
| 501 | - * @return PHPExcel_Worksheet_Protection |
|
| 502 | - */ |
|
| 503 | - function setSelectUnlockedCells($pValue = false) { |
|
| 504 | - $this->_selectUnlockedCells = $pValue; |
|
| 505 | - return $this; |
|
| 506 | - } |
|
| 507 | - |
|
| 508 | - /** |
|
| 509 | - * Get Password (hashed) |
|
| 510 | - * |
|
| 511 | - * @return string |
|
| 512 | - */ |
|
| 513 | - function getPassword() { |
|
| 514 | - return $this->_password; |
|
| 515 | - } |
|
| 516 | - |
|
| 517 | - /** |
|
| 518 | - * Set Password |
|
| 519 | - * |
|
| 520 | - * @param string $pValue |
|
| 521 | - * @param boolean $pAlreadyHashed If the password has already been hashed, set this to true |
|
| 522 | - * @return PHPExcel_Worksheet_Protection |
|
| 523 | - */ |
|
| 524 | - function setPassword($pValue = '', $pAlreadyHashed = false) { |
|
| 525 | - if (!$pAlreadyHashed) { |
|
| 526 | - $pValue = PHPExcel_Shared_PasswordHasher::hashPassword($pValue); |
|
| 527 | - } |
|
| 186 | + } |
|
| 187 | + |
|
| 188 | + /** |
|
| 189 | + * Get Sheet |
|
| 190 | + * |
|
| 191 | + * @return boolean |
|
| 192 | + */ |
|
| 193 | + function getSheet() { |
|
| 194 | + return $this->_sheet; |
|
| 195 | + } |
|
| 196 | + |
|
| 197 | + /** |
|
| 198 | + * Set Sheet |
|
| 199 | + * |
|
| 200 | + * @param boolean $pValue |
|
| 201 | + * @return PHPExcel_Worksheet_Protection |
|
| 202 | + */ |
|
| 203 | + function setSheet($pValue = false) { |
|
| 204 | + $this->_sheet = $pValue; |
|
| 205 | + return $this; |
|
| 206 | + } |
|
| 207 | + |
|
| 208 | + /** |
|
| 209 | + * Get Objects |
|
| 210 | + * |
|
| 211 | + * @return boolean |
|
| 212 | + */ |
|
| 213 | + function getObjects() { |
|
| 214 | + return $this->_objects; |
|
| 215 | + } |
|
| 216 | + |
|
| 217 | + /** |
|
| 218 | + * Set Objects |
|
| 219 | + * |
|
| 220 | + * @param boolean $pValue |
|
| 221 | + * @return PHPExcel_Worksheet_Protection |
|
| 222 | + */ |
|
| 223 | + function setObjects($pValue = false) { |
|
| 224 | + $this->_objects = $pValue; |
|
| 225 | + return $this; |
|
| 226 | + } |
|
| 227 | + |
|
| 228 | + /** |
|
| 229 | + * Get Scenarios |
|
| 230 | + * |
|
| 231 | + * @return boolean |
|
| 232 | + */ |
|
| 233 | + function getScenarios() { |
|
| 234 | + return $this->_scenarios; |
|
| 235 | + } |
|
| 236 | + |
|
| 237 | + /** |
|
| 238 | + * Set Scenarios |
|
| 239 | + * |
|
| 240 | + * @param boolean $pValue |
|
| 241 | + * @return PHPExcel_Worksheet_Protection |
|
| 242 | + */ |
|
| 243 | + function setScenarios($pValue = false) { |
|
| 244 | + $this->_scenarios = $pValue; |
|
| 245 | + return $this; |
|
| 246 | + } |
|
| 247 | + |
|
| 248 | + /** |
|
| 249 | + * Get FormatCells |
|
| 250 | + * |
|
| 251 | + * @return boolean |
|
| 252 | + */ |
|
| 253 | + function getFormatCells() { |
|
| 254 | + return $this->_formatCells; |
|
| 255 | + } |
|
| 256 | + |
|
| 257 | + /** |
|
| 258 | + * Set FormatCells |
|
| 259 | + * |
|
| 260 | + * @param boolean $pValue |
|
| 261 | + * @return PHPExcel_Worksheet_Protection |
|
| 262 | + */ |
|
| 263 | + function setFormatCells($pValue = false) { |
|
| 264 | + $this->_formatCells = $pValue; |
|
| 265 | + return $this; |
|
| 266 | + } |
|
| 267 | + |
|
| 268 | + /** |
|
| 269 | + * Get FormatColumns |
|
| 270 | + * |
|
| 271 | + * @return boolean |
|
| 272 | + */ |
|
| 273 | + function getFormatColumns() { |
|
| 274 | + return $this->_formatColumns; |
|
| 275 | + } |
|
| 276 | + |
|
| 277 | + /** |
|
| 278 | + * Set FormatColumns |
|
| 279 | + * |
|
| 280 | + * @param boolean $pValue |
|
| 281 | + * @return PHPExcel_Worksheet_Protection |
|
| 282 | + */ |
|
| 283 | + function setFormatColumns($pValue = false) { |
|
| 284 | + $this->_formatColumns = $pValue; |
|
| 285 | + return $this; |
|
| 286 | + } |
|
| 287 | + |
|
| 288 | + /** |
|
| 289 | + * Get FormatRows |
|
| 290 | + * |
|
| 291 | + * @return boolean |
|
| 292 | + */ |
|
| 293 | + function getFormatRows() { |
|
| 294 | + return $this->_formatRows; |
|
| 295 | + } |
|
| 296 | + |
|
| 297 | + /** |
|
| 298 | + * Set FormatRows |
|
| 299 | + * |
|
| 300 | + * @param boolean $pValue |
|
| 301 | + * @return PHPExcel_Worksheet_Protection |
|
| 302 | + */ |
|
| 303 | + function setFormatRows($pValue = false) { |
|
| 304 | + $this->_formatRows = $pValue; |
|
| 305 | + return $this; |
|
| 306 | + } |
|
| 307 | + |
|
| 308 | + /** |
|
| 309 | + * Get InsertColumns |
|
| 310 | + * |
|
| 311 | + * @return boolean |
|
| 312 | + */ |
|
| 313 | + function getInsertColumns() { |
|
| 314 | + return $this->_insertColumns; |
|
| 315 | + } |
|
| 316 | + |
|
| 317 | + /** |
|
| 318 | + * Set InsertColumns |
|
| 319 | + * |
|
| 320 | + * @param boolean $pValue |
|
| 321 | + * @return PHPExcel_Worksheet_Protection |
|
| 322 | + */ |
|
| 323 | + function setInsertColumns($pValue = false) { |
|
| 324 | + $this->_insertColumns = $pValue; |
|
| 325 | + return $this; |
|
| 326 | + } |
|
| 327 | + |
|
| 328 | + /** |
|
| 329 | + * Get InsertRows |
|
| 330 | + * |
|
| 331 | + * @return boolean |
|
| 332 | + */ |
|
| 333 | + function getInsertRows() { |
|
| 334 | + return $this->_insertRows; |
|
| 335 | + } |
|
| 336 | + |
|
| 337 | + /** |
|
| 338 | + * Set InsertRows |
|
| 339 | + * |
|
| 340 | + * @param boolean $pValue |
|
| 341 | + * @return PHPExcel_Worksheet_Protection |
|
| 342 | + */ |
|
| 343 | + function setInsertRows($pValue = false) { |
|
| 344 | + $this->_insertRows = $pValue; |
|
| 345 | + return $this; |
|
| 346 | + } |
|
| 347 | + |
|
| 348 | + /** |
|
| 349 | + * Get InsertHyperlinks |
|
| 350 | + * |
|
| 351 | + * @return boolean |
|
| 352 | + */ |
|
| 353 | + function getInsertHyperlinks() { |
|
| 354 | + return $this->_insertHyperlinks; |
|
| 355 | + } |
|
| 356 | + |
|
| 357 | + /** |
|
| 358 | + * Set InsertHyperlinks |
|
| 359 | + * |
|
| 360 | + * @param boolean $pValue |
|
| 361 | + * @return PHPExcel_Worksheet_Protection |
|
| 362 | + */ |
|
| 363 | + function setInsertHyperlinks($pValue = false) { |
|
| 364 | + $this->_insertHyperlinks = $pValue; |
|
| 365 | + return $this; |
|
| 366 | + } |
|
| 367 | + |
|
| 368 | + /** |
|
| 369 | + * Get DeleteColumns |
|
| 370 | + * |
|
| 371 | + * @return boolean |
|
| 372 | + */ |
|
| 373 | + function getDeleteColumns() { |
|
| 374 | + return $this->_deleteColumns; |
|
| 375 | + } |
|
| 376 | + |
|
| 377 | + /** |
|
| 378 | + * Set DeleteColumns |
|
| 379 | + * |
|
| 380 | + * @param boolean $pValue |
|
| 381 | + * @return PHPExcel_Worksheet_Protection |
|
| 382 | + */ |
|
| 383 | + function setDeleteColumns($pValue = false) { |
|
| 384 | + $this->_deleteColumns = $pValue; |
|
| 385 | + return $this; |
|
| 386 | + } |
|
| 387 | + |
|
| 388 | + /** |
|
| 389 | + * Get DeleteRows |
|
| 390 | + * |
|
| 391 | + * @return boolean |
|
| 392 | + */ |
|
| 393 | + function getDeleteRows() { |
|
| 394 | + return $this->_deleteRows; |
|
| 395 | + } |
|
| 396 | + |
|
| 397 | + /** |
|
| 398 | + * Set DeleteRows |
|
| 399 | + * |
|
| 400 | + * @param boolean $pValue |
|
| 401 | + * @return PHPExcel_Worksheet_Protection |
|
| 402 | + */ |
|
| 403 | + function setDeleteRows($pValue = false) { |
|
| 404 | + $this->_deleteRows = $pValue; |
|
| 405 | + return $this; |
|
| 406 | + } |
|
| 407 | + |
|
| 408 | + /** |
|
| 409 | + * Get SelectLockedCells |
|
| 410 | + * |
|
| 411 | + * @return boolean |
|
| 412 | + */ |
|
| 413 | + function getSelectLockedCells() { |
|
| 414 | + return $this->_selectLockedCells; |
|
| 415 | + } |
|
| 416 | + |
|
| 417 | + /** |
|
| 418 | + * Set SelectLockedCells |
|
| 419 | + * |
|
| 420 | + * @param boolean $pValue |
|
| 421 | + * @return PHPExcel_Worksheet_Protection |
|
| 422 | + */ |
|
| 423 | + function setSelectLockedCells($pValue = false) { |
|
| 424 | + $this->_selectLockedCells = $pValue; |
|
| 425 | + return $this; |
|
| 426 | + } |
|
| 427 | + |
|
| 428 | + /** |
|
| 429 | + * Get Sort |
|
| 430 | + * |
|
| 431 | + * @return boolean |
|
| 432 | + */ |
|
| 433 | + function getSort() { |
|
| 434 | + return $this->_sort; |
|
| 435 | + } |
|
| 436 | + |
|
| 437 | + /** |
|
| 438 | + * Set Sort |
|
| 439 | + * |
|
| 440 | + * @param boolean $pValue |
|
| 441 | + * @return PHPExcel_Worksheet_Protection |
|
| 442 | + */ |
|
| 443 | + function setSort($pValue = false) { |
|
| 444 | + $this->_sort = $pValue; |
|
| 445 | + return $this; |
|
| 446 | + } |
|
| 447 | + |
|
| 448 | + /** |
|
| 449 | + * Get AutoFilter |
|
| 450 | + * |
|
| 451 | + * @return boolean |
|
| 452 | + */ |
|
| 453 | + function getAutoFilter() { |
|
| 454 | + return $this->_autoFilter; |
|
| 455 | + } |
|
| 456 | + |
|
| 457 | + /** |
|
| 458 | + * Set AutoFilter |
|
| 459 | + * |
|
| 460 | + * @param boolean $pValue |
|
| 461 | + * @return PHPExcel_Worksheet_Protection |
|
| 462 | + */ |
|
| 463 | + function setAutoFilter($pValue = false) { |
|
| 464 | + $this->_autoFilter = $pValue; |
|
| 465 | + return $this; |
|
| 466 | + } |
|
| 467 | + |
|
| 468 | + /** |
|
| 469 | + * Get PivotTables |
|
| 470 | + * |
|
| 471 | + * @return boolean |
|
| 472 | + */ |
|
| 473 | + function getPivotTables() { |
|
| 474 | + return $this->_pivotTables; |
|
| 475 | + } |
|
| 476 | + |
|
| 477 | + /** |
|
| 478 | + * Set PivotTables |
|
| 479 | + * |
|
| 480 | + * @param boolean $pValue |
|
| 481 | + * @return PHPExcel_Worksheet_Protection |
|
| 482 | + */ |
|
| 483 | + function setPivotTables($pValue = false) { |
|
| 484 | + $this->_pivotTables = $pValue; |
|
| 485 | + return $this; |
|
| 486 | + } |
|
| 487 | + |
|
| 488 | + /** |
|
| 489 | + * Get SelectUnlockedCells |
|
| 490 | + * |
|
| 491 | + * @return boolean |
|
| 492 | + */ |
|
| 493 | + function getSelectUnlockedCells() { |
|
| 494 | + return $this->_selectUnlockedCells; |
|
| 495 | + } |
|
| 496 | + |
|
| 497 | + /** |
|
| 498 | + * Set SelectUnlockedCells |
|
| 499 | + * |
|
| 500 | + * @param boolean $pValue |
|
| 501 | + * @return PHPExcel_Worksheet_Protection |
|
| 502 | + */ |
|
| 503 | + function setSelectUnlockedCells($pValue = false) { |
|
| 504 | + $this->_selectUnlockedCells = $pValue; |
|
| 505 | + return $this; |
|
| 506 | + } |
|
| 507 | + |
|
| 508 | + /** |
|
| 509 | + * Get Password (hashed) |
|
| 510 | + * |
|
| 511 | + * @return string |
|
| 512 | + */ |
|
| 513 | + function getPassword() { |
|
| 514 | + return $this->_password; |
|
| 515 | + } |
|
| 516 | + |
|
| 517 | + /** |
|
| 518 | + * Set Password |
|
| 519 | + * |
|
| 520 | + * @param string $pValue |
|
| 521 | + * @param boolean $pAlreadyHashed If the password has already been hashed, set this to true |
|
| 522 | + * @return PHPExcel_Worksheet_Protection |
|
| 523 | + */ |
|
| 524 | + function setPassword($pValue = '', $pAlreadyHashed = false) { |
|
| 525 | + if (!$pAlreadyHashed) { |
|
| 526 | + $pValue = PHPExcel_Shared_PasswordHasher::hashPassword($pValue); |
|
| 527 | + } |
|
| 528 | 528 | $this->_password = $pValue; |
| 529 | 529 | return $this; |
| 530 | - } |
|
| 530 | + } |
|
| 531 | 531 | |
| 532 | 532 | /** |
| 533 | 533 | * Implement PHP __clone to create a deep clone, not just a shallow copy. |
@@ -59,8 +59,8 @@ |
||
| 59 | 59 | */ |
| 60 | 60 | public function __construct(PHPExcel_Worksheet $parent = null, $rowIndex = 1) { |
| 61 | 61 | // Set parent and row index |
| 62 | - $this->_parent = $parent; |
|
| 63 | - $this->_rowIndex = $rowIndex; |
|
| 62 | + $this->_parent = $parent; |
|
| 63 | + $this->_rowIndex = $rowIndex; |
|
| 64 | 64 | } |
| 65 | 65 | |
| 66 | 66 | /** |
@@ -133,8 +133,9 @@ |
||
| 133 | 133 | * Set the iterator to its previous value |
| 134 | 134 | */ |
| 135 | 135 | public function prev() { |
| 136 | - if ($this->_position > 1) |
|
| 137 | - --$this->_position; |
|
| 136 | + if ($this->_position > 1) { |
|
| 137 | + --$this->_position; |
|
| 138 | + } |
|
| 138 | 139 | } |
| 139 | 140 | |
| 140 | 141 | /** |