HEADmaster

1 files changed, 0 insertions, 798 deletions

diff --git a/admin/survey/excel/PHPExcel/Worksheet/PageSetup.php b/admin/survey/excel/PHPExcel/Worksheet/PageSetup.php
deleted file mode 100644
index eede154..0000000
--- a/admin/survey/excel/PHPExcel/Worksheet/PageSetup.php
+++ /dev/null
@@ -1,798 +0,0 @@
-<?php

-/**

- * PHPExcel

- *

- * Copyright (c) 2006 - 2012 PHPExcel

- *

- * This library is free software; you can redistribute it and/or

- * modify it under the terms of the GNU Lesser General Public

- * License as published by the Free Software Foundation; either

- * version 2.1 of the License, or (at your option) any later version.

- *

- * This library is distributed in the hope that it will be useful,

- * but WITHOUT ANY WARRANTY; without even the implied warranty of

- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU

- * Lesser General Public License for more details.

- *

- * You should have received a copy of the GNU Lesser General Public

- * License along with this library; if not, write to the Free Software

- * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA

- *

- * @category   PHPExcel

- * @package    PHPExcel_Worksheet

- * @copyright  Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)

- * @license    http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt	LGPL

- * @version    1.7.8, 2012-10-12

- */

-

-

-/**

- * PHPExcel_Worksheet_PageSetup

- *

- * <code>

- * Paper size taken from Office Open XML Part 4 - Markup Language Reference, page 1988:

- *

- * 1 = Letter paper (8.5 in. by 11 in.)

- * 2 = Letter small paper (8.5 in. by 11 in.)

- * 3 = Tabloid paper (11 in. by 17 in.)

- * 4 = Ledger paper (17 in. by 11 in.)

- * 5 = Legal paper (8.5 in. by 14 in.)

- * 6 = Statement paper (5.5 in. by 8.5 in.)

- * 7 = Executive paper (7.25 in. by 10.5 in.)

- * 8 = A3 paper (297 mm by 420 mm)

- * 9 = A4 paper (210 mm by 297 mm)

- * 10 = A4 small paper (210 mm by 297 mm)

- * 11 = A5 paper (148 mm by 210 mm)

- * 12 = B4 paper (250 mm by 353 mm)

- * 13 = B5 paper (176 mm by 250 mm)

- * 14 = Folio paper (8.5 in. by 13 in.)

- * 15 = Quarto paper (215 mm by 275 mm)

- * 16 = Standard paper (10 in. by 14 in.)

- * 17 = Standard paper (11 in. by 17 in.)

- * 18 = Note paper (8.5 in. by 11 in.)

- * 19 = #9 envelope (3.875 in. by 8.875 in.)

- * 20 = #10 envelope (4.125 in. by 9.5 in.)

- * 21 = #11 envelope (4.5 in. by 10.375 in.)

- * 22 = #12 envelope (4.75 in. by 11 in.)

- * 23 = #14 envelope (5 in. by 11.5 in.)

- * 24 = C paper (17 in. by 22 in.)

- * 25 = D paper (22 in. by 34 in.)

- * 26 = E paper (34 in. by 44 in.)

- * 27 = DL envelope (110 mm by 220 mm)

- * 28 = C5 envelope (162 mm by 229 mm)

- * 29 = C3 envelope (324 mm by 458 mm)

- * 30 = C4 envelope (229 mm by 324 mm)

- * 31 = C6 envelope (114 mm by 162 mm)

- * 32 = C65 envelope (114 mm by 229 mm)

- * 33 = B4 envelope (250 mm by 353 mm)

- * 34 = B5 envelope (176 mm by 250 mm)

- * 35 = B6 envelope (176 mm by 125 mm)

- * 36 = Italy envelope (110 mm by 230 mm)

- * 37 = Monarch envelope (3.875 in. by 7.5 in.).

- * 38 = 6 3/4 envelope (3.625 in. by 6.5 in.)

- * 39 = US standard fanfold (14.875 in. by 11 in.)

- * 40 = German standard fanfold (8.5 in. by 12 in.)

- * 41 = German legal fanfold (8.5 in. by 13 in.)

- * 42 = ISO B4 (250 mm by 353 mm)

- * 43 = Japanese double postcard (200 mm by 148 mm)

- * 44 = Standard paper (9 in. by 11 in.)

- * 45 = Standard paper (10 in. by 11 in.)

- * 46 = Standard paper (15 in. by 11 in.)

- * 47 = Invite envelope (220 mm by 220 mm)

- * 50 = Letter extra paper (9.275 in. by 12 in.)

- * 51 = Legal extra paper (9.275 in. by 15 in.)

- * 52 = Tabloid extra paper (11.69 in. by 18 in.)

- * 53 = A4 extra paper (236 mm by 322 mm)

- * 54 = Letter transverse paper (8.275 in. by 11 in.)

- * 55 = A4 transverse paper (210 mm by 297 mm)

- * 56 = Letter extra transverse paper (9.275 in. by 12 in.)

- * 57 = SuperA/SuperA/A4 paper (227 mm by 356 mm)

- * 58 = SuperB/SuperB/A3 paper (305 mm by 487 mm)

- * 59 = Letter plus paper (8.5 in. by 12.69 in.)

- * 60 = A4 plus paper (210 mm by 330 mm)

- * 61 = A5 transverse paper (148 mm by 210 mm)

- * 62 = JIS B5 transverse paper (182 mm by 257 mm)

- * 63 = A3 extra paper (322 mm by 445 mm)

- * 64 = A5 extra paper (174 mm by 235 mm)

- * 65 = ISO B5 extra paper (201 mm by 276 mm)

- * 66 = A2 paper (420 mm by 594 mm)

- * 67 = A3 transverse paper (297 mm by 420 mm)

- * 68 = A3 extra transverse paper (322 mm by 445 mm)

- * </code>

- *

- * @category   PHPExcel

- * @package    PHPExcel_Worksheet

- * @copyright  Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)

- */

-class PHPExcel_Worksheet_PageSetup

-{

-	/* Paper size */

-	const PAPERSIZE_LETTER							= 1;

-	const PAPERSIZE_LETTER_SMALL					= 2;

-	const PAPERSIZE_TABLOID							= 3;

-	const PAPERSIZE_LEDGER							= 4;

-	const PAPERSIZE_LEGAL							= 5;

-	const PAPERSIZE_STATEMENT						= 6;

-	const PAPERSIZE_EXECUTIVE						= 7;

-	const PAPERSIZE_A3								= 8;

-	const PAPERSIZE_A4								= 9;

-	const PAPERSIZE_A4_SMALL						= 10;

-	const PAPERSIZE_A5								= 11;

-	const PAPERSIZE_B4								= 12;

-	const PAPERSIZE_B5								= 13;

-	const PAPERSIZE_FOLIO							= 14;

-	const PAPERSIZE_QUARTO							= 15;

-	const PAPERSIZE_STANDARD_1						= 16;

-	const PAPERSIZE_STANDARD_2						= 17;

-	const PAPERSIZE_NOTE							= 18;

-	const PAPERSIZE_NO9_ENVELOPE					= 19;

-	const PAPERSIZE_NO10_ENVELOPE					= 20;

-	const PAPERSIZE_NO11_ENVELOPE					= 21;

-	const PAPERSIZE_NO12_ENVELOPE					= 22;

-	const PAPERSIZE_NO14_ENVELOPE					= 23;

-	const PAPERSIZE_C								= 24;

-	const PAPERSIZE_D								= 25;

-	const PAPERSIZE_E								= 26;

-	const PAPERSIZE_DL_ENVELOPE						= 27;

-	const PAPERSIZE_C5_ENVELOPE						= 28;

-	const PAPERSIZE_C3_ENVELOPE						= 29;

-	const PAPERSIZE_C4_ENVELOPE						= 30;

-	const PAPERSIZE_C6_ENVELOPE						= 31;

-	const PAPERSIZE_C65_ENVELOPE					= 32;

-	const PAPERSIZE_B4_ENVELOPE						= 33;

-	const PAPERSIZE_B5_ENVELOPE						= 34;

-	const PAPERSIZE_B6_ENVELOPE						= 35;

-	const PAPERSIZE_ITALY_ENVELOPE					= 36;

-	const PAPERSIZE_MONARCH_ENVELOPE				= 37;

-	const PAPERSIZE_6_3_4_ENVELOPE					= 38;

-	const PAPERSIZE_US_STANDARD_FANFOLD				= 39;

-	const PAPERSIZE_GERMAN_STANDARD_FANFOLD			= 40;

-	const PAPERSIZE_GERMAN_LEGAL_FANFOLD			= 41;

-	const PAPERSIZE_ISO_B4							= 42;

-	const PAPERSIZE_JAPANESE_DOUBLE_POSTCARD		= 43;

-	const PAPERSIZE_STANDARD_PAPER_1				= 44;

-	const PAPERSIZE_STANDARD_PAPER_2				= 45;

-	const PAPERSIZE_STANDARD_PAPER_3				= 46;

-	const PAPERSIZE_INVITE_ENVELOPE					= 47;

-	const PAPERSIZE_LETTER_EXTRA_PAPER				= 48;

-	const PAPERSIZE_LEGAL_EXTRA_PAPER				= 49;

-	const PAPERSIZE_TABLOID_EXTRA_PAPER				= 50;

-	const PAPERSIZE_A4_EXTRA_PAPER					= 51;

-	const PAPERSIZE_LETTER_TRANSVERSE_PAPER			= 52;

-	const PAPERSIZE_A4_TRANSVERSE_PAPER				= 53;

-	const PAPERSIZE_LETTER_EXTRA_TRANSVERSE_PAPER	= 54;

-	const PAPERSIZE_SUPERA_SUPERA_A4_PAPER			= 55;

-	const PAPERSIZE_SUPERB_SUPERB_A3_PAPER			= 56;

-	const PAPERSIZE_LETTER_PLUS_PAPER				= 57;

-	const PAPERSIZE_A4_PLUS_PAPER					= 58;

-	const PAPERSIZE_A5_TRANSVERSE_PAPER				= 59;

-	const PAPERSIZE_JIS_B5_TRANSVERSE_PAPER			= 60;

-	const PAPERSIZE_A3_EXTRA_PAPER					= 61;

-	const PAPERSIZE_A5_EXTRA_PAPER					= 62;

-	const PAPERSIZE_ISO_B5_EXTRA_PAPER				= 63;

-	const PAPERSIZE_A2_PAPER						= 64;

-	const PAPERSIZE_A3_TRANSVERSE_PAPER				= 65;

-	const PAPERSIZE_A3_EXTRA_TRANSVERSE_PAPER		= 66;

-

-	/* Page orientation */

-	const ORIENTATION_DEFAULT	= 'default';

-	const ORIENTATION_LANDSCAPE	= 'landscape';

-	const ORIENTATION_PORTRAIT	= 'portrait';

-

-	/* Print Range Set Method */

-	const SETPRINTRANGE_OVERWRITE	= 'O';

-	const SETPRINTRANGE_INSERT		= 'I';

-

-

-	/**

-	 * Paper size

-	 *

-	 * @var int

-	 */

-	private $_paperSize		= PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER;

-

-	/**

-	 * Orientation

-	 *

-	 * @var string

-	 */

-	private $_orientation	= PHPExcel_Worksheet_PageSetup::ORIENTATION_DEFAULT;

-

-	/**

-	 * Scale (Print Scale)

-	 *

-	 * Print scaling. Valid values range from 10 to 400

-	 * This setting is overridden when fitToWidth and/or fitToHeight are in use

-	 *

-	 * @var int?

-	 */

-	private $_scale			= 100;

-

-	/**

-	  * Fit To Page

-	  * Whether scale or fitToWith / fitToHeight applies

-	  *

-	  * @var boolean

-	  */

-	private $_fitToPage		= FALSE;

-

-	/**

-	  * Fit To Height

-	  * Number of vertical pages to fit on

-	  *

-	  * @var int?

-	  */

-	private $_fitToHeight	= 1;

-

-	/**

-	  * Fit To Width

-	  * Number of horizontal pages to fit on

-	  *

-	  * @var int?

-	  */

-	private $_fitToWidth	= 1;

-

-	/**

-	 * Columns to repeat at left

-	 *

-	 * @var array Containing start column and end column, empty array if option unset

-	 */

-	private $_columnsToRepeatAtLeft = array('', '');

-

-	/**

-	 * Rows to repeat at top

-	 *

-	 * @var array Containing start row number and end row number, empty array if option unset

-	 */

-	private $_rowsToRepeatAtTop = array(0, 0);

-

-	/**

-	 * Center page horizontally

-	 *

-	 * @var boolean

-	 */

-	private $_horizontalCentered = FALSE;

-

-	/**

-	 * Center page vertically

-	 *

-	 * @var boolean

-	 */

-	private $_verticalCentered = FALSE;

-

-	/**

-	 * Print area

-	 *

-	 * @var string

-	 */

-	private $_printArea = NULL;

-

-	/**

-	 * First page number

-	 *

-	 * @var int

-	 */

-	private $_firstPageNumber = NULL;

-

-    /**

-     * Create a new PHPExcel_Worksheet_PageSetup

-     */

-    public function __construct()

-    {

-    }

-

-    /**

-     * Get Paper Size

-     *

-     * @return int

-     */

-    public function getPaperSize() {

-    	return $this->_paperSize;

-    }

-

-    /**

-     * Set Paper Size

-     *

-     * @param int $pValue

-     * @return PHPExcel_Worksheet_PageSetup

-     */

-    public function setPaperSize($pValue = PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER) {

-    	$this->_paperSize = $pValue;

-    	return $this;

-    }

-

-    /**

-     * Get Orientation

-     *

-     * @return string

-     */

-    public function getOrientation() {

-    	return $this->_orientation;

-    }

-

-    /**

-     * Set Orientation

-     *

-     * @param string $pValue

-     * @return PHPExcel_Worksheet_PageSetup

-     */

-    public function setOrientation($pValue = PHPExcel_Worksheet_PageSetup::ORIENTATION_DEFAULT) {

-    	$this->_orientation = $pValue;

-    	return $this;

-    }

-

-	/**

-	 * Get Scale

-	 *

-	 * @return int?

-	 */

-	public function getScale() {

-		return $this->_scale;

-	}

-

-	/**

-	 * Set Scale

-	 *

-	 * Print scaling. Valid values range from 10 to 400

-	 * This setting is overridden when fitToWidth and/or fitToHeight are in use

-	 *

-	 * @param 	int?	$pValue

-	 * @param boolean	$pUpdate	Update fitToPage so scaling applies rather than fitToHeight / fitToWidth

-	 * @return PHPExcel_Worksheet_PageSetup

-	 * @throws 	Exception

-	 */

-	public function setScale($pValue = 100, $pUpdate = true) {

-		// Microsoft Office Excel 2007 only allows setting a scale between 10 and 400 via the user interface,

-		// but it is apparently still able to handle any scale >= 0, where 0 results in 100

-		if (($pValue >= 0) || is_null($pValue)) {

-			$this->_scale = $pValue;

-			if ($pUpdate) {

-				$this->_fitToPage = false;

-			}

-		} else {

-			throw new Exception("Scale must not be negative");

-		}

-		return $this;

-	}

-

-	/**

-	 * Get Fit To Page

-	 *

-	 * @return boolean

-	 */

-	public function getFitToPage() {

-		return $this->_fitToPage;

-	}

-

-	/**

-	 * Set Fit To Page

-	 *

-	 * @param boolean $pValue

-	 * @return PHPExcel_Worksheet_PageSetup

-	 */

-	public function setFitToPage($pValue = TRUE) {

-		$this->_fitToPage = $pValue;

-		return $this;

-	}

-

-	/**

-	 * Get Fit To Height

-	 *

-	 * @return int?

-	 */

-	public function getFitToHeight() {

-		return $this->_fitToHeight;

-	}

-

-	/**

-	 * Set Fit To Height

-	 *

-	 * @param int? $pValue

-	 * @param boolean $pUpdate Update fitToPage so it applies rather than scaling

-	 * @return PHPExcel_Worksheet_PageSetup

-	 */

-	public function setFitToHeight($pValue = 1, $pUpdate = TRUE) {

-		$this->_fitToHeight = $pValue;

-		if ($pUpdate) {

-			$this->_fitToPage = TRUE;

-		}

-		return $this;

-	}

-

-	/**

-	 * Get Fit To Width

-	 *

-	 * @return int?

-	 */

-	public function getFitToWidth() {

-		return $this->_fitToWidth;

-	}

-

-	/**

-	 * Set Fit To Width

-	 *

-	 * @param int? $pValue

-	 * @param boolean $pUpdate Update fitToPage so it applies rather than scaling

-	 * @return PHPExcel_Worksheet_PageSetup

-	 */

-	public function setFitToWidth($pValue = 1, $pUpdate = TRUE) {

-		$this->_fitToWidth = $pValue;

-		if ($pUpdate) {

-			$this->_fitToPage = TRUE;

-		}

-		return $this;

-	}

-

-	/**

-	 * Is Columns to repeat at left set?

-	 *

-	 * @return boolean

-	 */

-	public function isColumnsToRepeatAtLeftSet() {

-		if (is_array($this->_columnsToRepeatAtLeft)) {

-			if ($this->_columnsToRepeatAtLeft[0] != '' && $this->_columnsToRepeatAtLeft[1] != '') {

-				return true;

-			}

-		}

-

-		return false;

-	}

-

-	/**

-	 * Get Columns to repeat at left

-	 *

-	 * @return array Containing start column and end column, empty array if option unset

-	 */

-	public function getColumnsToRepeatAtLeft() {

-		return $this->_columnsToRepeatAtLeft;

-	}

-

-	/**

-	 * Set Columns to repeat at left

-	 *

-	 * @param array $pValue Containing start column and end column, empty array if option unset

-	 * @return PHPExcel_Worksheet_PageSetup

-	 */

-	public function setColumnsToRepeatAtLeft($pValue = null) {

-		if (is_array($pValue)) {

-			$this->_columnsToRepeatAtLeft = $pValue;

-		}

-		return $this;

-	}

-

-	/**

-	 * Set Columns to repeat at left by start and end

-	 *

-	 * @param string $pStart

-	 * @param string $pEnd

-	 * @return PHPExcel_Worksheet_PageSetup

-	 */

-	public function setColumnsToRepeatAtLeftByStartAndEnd($pStart = 'A', $pEnd = 'A') {

-		$this->_columnsToRepeatAtLeft = array($pStart, $pEnd);

-		return $this;

-	}

-

-	/**

-	 * Is Rows to repeat at top set?

-	 *

-	 * @return boolean

-	 */

-	public function isRowsToRepeatAtTopSet() {

-		if (is_array($this->_rowsToRepeatAtTop)) {

-			if ($this->_rowsToRepeatAtTop[0] != 0 && $this->_rowsToRepeatAtTop[1] != 0) {

-				return true;

-			}

-		}

-

-		return false;

-	}

-

-	/**

-	 * Get Rows to repeat at top

-	 *

-	 * @return array Containing start column and end column, empty array if option unset

-	 */

-	public function getRowsToRepeatAtTop() {

-		return $this->_rowsToRepeatAtTop;

-	}

-

-	/**

-	 * Set Rows to repeat at top

-	 *

-	 * @param array	$pValue	Containing start column and end column, empty array if option unset

-	 * @return PHPExcel_Worksheet_PageSetup

-	 */

-	public function setRowsToRepeatAtTop($pValue = null) {

-		if (is_array($pValue)) {

-			$this->_rowsToRepeatAtTop = $pValue;

-		}

-		return $this;

-	}

-

-	/**

-	 * Set Rows to repeat at top by start and end

-	 *

-	 * @param int $pStart

-	 * @param int $pEnd

-	 * @return PHPExcel_Worksheet_PageSetup

-	 */

-	public function setRowsToRepeatAtTopByStartAndEnd($pStart = 1, $pEnd = 1) {

-		$this->_rowsToRepeatAtTop = array($pStart, $pEnd);

-		return $this;

-	}

-

-	/**

-	 * Get center page horizontally

-	 *

-	 * @return bool

-	 */

-	public function getHorizontalCentered() {

-		return $this->_horizontalCentered;

-	}

-

-	/**

-	 * Set center page horizontally

-	 *

-	 * @param bool $value

-	 * @return PHPExcel_Worksheet_PageSetup

-	 */

-	public function setHorizontalCentered($value = false) {

-		$this->_horizontalCentered = $value;

-		return $this;

-	}

-

-	/**

-	 * Get center page vertically

-	 *

-	 * @return bool

-	 */

-	public function getVerticalCentered() {

-		return $this->_verticalCentered;

-	}

-

-	/**

-	 * Set center page vertically

-	 *

-	 * @param bool $value

-	 * @return PHPExcel_Worksheet_PageSetup

-	 */

-	public function setVerticalCentered($value = false) {

-		$this->_verticalCentered = $value;

-		return $this;

-	}

-

-	/**

-	 *	Get print area

-	 *

-	 * @param	int		$index	Identifier for a specific print area range if several ranges have been set

-	 *							Default behaviour, or a index value of 0, will return all ranges as a comma-separated string

-	 *							Otherwise, the specific range identified by the value of $index will be returned

-	 *							Print areas are numbered from 1

-	 * @throws	Exception

-	 * @return	string

-	 */

-	public function getPrintArea($index = 0) {

-		if ($index == 0) {

-			return $this->_printArea;

-		}

-		$printAreas = explode(',',$this->_printArea);

-		if (isset($printAreas[$index-1])) {

-			return $printAreas[$index-1];

-		}

-		throw new Exception("Requested Print Area does not exist");

-	}

-

-	/**

-	 * Is print area set?

-	 *

-	 * @param	int		$index	Identifier for a specific print area range if several ranges have been set

-	 *							Default behaviour, or an index value of 0, will identify whether any print range is set

-	 *							Otherwise, existence of the range identified by the value of $index will be returned

-	 *							Print areas are numbered from 1

-	 * @return	boolean

-	 */

-	public function isPrintAreaSet($index = 0) {

-		if ($index == 0) {

-			return !is_null($this->_printArea);

-		}

-		$printAreas = explode(',',$this->_printArea);

-		return isset($printAreas[$index-1]);

-	}

-

-	/**

-	 * Clear a print area

-	 *

-	 * @param	int		$index	Identifier for a specific print area range if several ranges have been set

-	 *							Default behaviour, or an index value of 0, will clear all print ranges that are set

-	 *							Otherwise, the range identified by the value of $index will be removed from the series

-	 *							Print areas are numbered from 1

-	 * @return	PHPExcel_Worksheet_PageSetup

-	 */

-	public function clearPrintArea($index = 0) {

-		if ($index == 0) {

-			$this->_printArea = NULL;

-		} else {

-			$printAreas = explode(',',$this->_printArea);

-			if (isset($printAreas[$index-1])) {

-				unset($printAreas[$index-1]);

-				$this->_printArea = implode(',',$printAreas);

-			}

-		}

-

-    	return $this;

-	}

-

-	/**

-	 * Set print area. e.g. 'A1:D10' or 'A1:D10,G5:M20'

-	 *

-	 * @param	string	$value

-	 * @param	int		$index	Identifier for a specific print area range allowing several ranges to be set

-	 *							When the method is "O"verwrite, then a positive integer index will overwrite that indexed

-	 *								entry in the print areas list; a negative index value will identify which entry to

-	 *								overwrite working bacward through the print area to the list, with the last entry as -1.

-	 *								Specifying an index value of 0, will overwrite <b>all</b> existing print ranges.

-	 *							When the method is "I"nsert, then a positive index will insert after that indexed entry in

-	 *								the print areas list, while a negative index will insert before the indexed entry.

-	 *								Specifying an index value of 0, will always append the new print range at the end of the

-	 *								list.

-	 *							Print areas are numbered from 1

-	 * @param	string	$method	Determines the method used when setting multiple print areas

-	 *							Default behaviour, or the "O" method, overwrites existing print area

-	 *							The "I" method, inserts the new print area before any specified index, or at the end of the list

-	 * @return	PHPExcel_Worksheet_PageSetup

-	 * @throws	Exception

-	 */

-	public function setPrintArea($value, $index = 0, $method = self::SETPRINTRANGE_OVERWRITE) {

-		if (strpos($value,'!') !== false) {

-			throw new Exception('Cell coordinate must not specify a worksheet.');

-		} elseif (strpos($value,':') === false) {

-			throw new Exception('Cell coordinate must be a range of cells.');

-		} elseif (strpos($value,'$') !== false) {

-			throw new Exception('Cell coordinate must not be absolute.');

-		}

-		$value = strtoupper($value);

-

-		if ($method == self::SETPRINTRANGE_OVERWRITE) {

-			if ($index == 0) {

-				$this->_printArea = $value;

-			} else {

-				$printAreas = explode(',',$this->_printArea);

-				if($index < 0) {

-					$index = count($printAreas) - abs($index) + 1;

-				}

-				if (($index <= 0) || ($index > count($printAreas))) {

-		    		throw new Exception('Invalid index for setting print range.');

-				}

-				$printAreas[$index-1] = $value;

-				$this->_printArea = implode(',',$printAreas);

-			}

-		} elseif($method == self::SETPRINTRANGE_INSERT) {

-			if ($index == 0) {

-				$this->_printArea .= ($this->_printArea == '') ? $value : ','.$value;

-			} else {

-				$printAreas = explode(',',$this->_printArea);

-				if($index < 0) {

-					$index = abs($index) - 1;

-				}

-				if ($index > count($printAreas)) {

-		    		throw new Exception('Invalid index for setting print range.');

-				}

-				$printAreas = array_merge(array_slice($printAreas,0,$index),array($value),array_slice($printAreas,$index));

-				$this->_printArea = implode(',',$printAreas);

-			}

-		} else {

-    		throw new Exception('Invalid method for setting print range.');

-		}

-

-    	return $this;

-	}

-

-	/**

-	 * Add a new print area (e.g. 'A1:D10' or 'A1:D10,G5:M20') to the list of print areas

-	 *

-	 * @param	string	$value

-	 * @param	int		$index	Identifier for a specific print area range allowing several ranges to be set

-	 *							A positive index will insert after that indexed entry in the print areas list, while a

-	 *								negative index will insert before the indexed entry.

-	 *								Specifying an index value of 0, will always append the new print range at the end of the

-	 *								list.

-	 *							Print areas are numbered from 1

-	 * @return	PHPExcel_Worksheet_PageSetup

-	 * @throws	Exception

-	 */

-	public function addPrintArea($value, $index = -1) {

-		return $this->setPrintArea($value, $index, self::SETPRINTRANGE_INSERT);

-	}

-

-	/**

-	 * Set print area

-	 *

-	 * @param	int		$column1	Column 1

-	 * @param	int		$row1		Row 1

-	 * @param	int		$column2	Column 2

-	 * @param	int		$row2		Row 2

-	 * @param	int		$index		Identifier for a specific print area range allowing several ranges to be set

-	 *								When the method is "O"verwrite, then a positive integer index will overwrite that indexed

-	 *									entry in the print areas list; a negative index value will identify which entry to

-	 *									overwrite working bacward through the print area to the list, with the last entry as -1.

-	 *									Specifying an index value of 0, will overwrite <b>all</b> existing print ranges.

-	 *								When the method is "I"nsert, then a positive index will insert after that indexed entry in

-	 *									the print areas list, while a negative index will insert before the indexed entry.

-	 *									Specifying an index value of 0, will always append the new print range at the end of the

-	 *									list.

-	 *								Print areas are numbered from 1

-	 * @param	string	$method		Determines the method used when setting multiple print areas

-	 *								Default behaviour, or the "O" method, overwrites existing print area

-	 *								The "I" method, inserts the new print area before any specified index, or at the end of the list

-	 * @return	PHPExcel_Worksheet_PageSetup

-	 * @throws	Exception

-	 */

-    public function setPrintAreaByColumnAndRow($column1, $row1, $column2, $row2, $index = 0, $method = self::SETPRINTRANGE_OVERWRITE)

-    {

-    	return $this->setPrintArea(PHPExcel_Cell::stringFromColumnIndex($column1) . $row1 . ':' . PHPExcel_Cell::stringFromColumnIndex($column2) . $row2, $index, $method);

-    }

-

-	/**

-	 * Add a new print area to the list of print areas

-	 *

-	 * @param	int		$column1	Start Column for the print area

-	 * @param	int		$row1		Start Row for the print area

-	 * @param	int		$column2	End Column for the print area

-	 * @param	int		$row2		End Row for the print area

-	 * @param	int		$index		Identifier for a specific print area range allowing several ranges to be set

-	 *								A positive index will insert after that indexed entry in the print areas list, while a

-	 *									negative index will insert before the indexed entry.

-	 *									Specifying an index value of 0, will always append the new print range at the end of the

-	 *									list.

-	 *								Print areas are numbered from 1

-	 * @return	PHPExcel_Worksheet_PageSetup

-	 * @throws	Exception

-	 */

-    public function addPrintAreaByColumnAndRow($column1, $row1, $column2, $row2, $index = -1)

-    {

-    	return $this->setPrintArea(PHPExcel_Cell::stringFromColumnIndex($column1) . $row1 . ':' . PHPExcel_Cell::stringFromColumnIndex($column2) . $row2, $index, self::SETPRINTRANGE_INSERT);

-	}

-

-	/**

-	 * Get first page number

-	 *

-	 * @return int

-	 */

-    public function getFirstPageNumber() {

-		return $this->_firstPageNumber;

-    }

-

-    /**

-     * Set first page number

-     *

-     * @param int $value

-     * @return PHPExcel_Worksheet_HeaderFooter

-     */

-    public function setFirstPageNumber($value = null) {

-		$this->_firstPageNumber = $value;

-		return $this;

-    }

-

-    /**

-     * Reset first page number

-     *

-     * @return PHPExcel_Worksheet_HeaderFooter

-     */

-    public function resetFirstPageNumber() {

-		return $this->setFirstPageNumber(null);

-    }

-

-	/**

-	 * Implement PHP __clone to create a deep clone, not just a shallow copy.

-	 */

-	public function __clone() {

-		$vars = get_object_vars($this);

-		foreach ($vars as $key => $value) {

-			if (is_object($value)) {

-				$this->$key = clone $value;

-			} else {

-				$this->$key = $value;

-			}

-		}

-	}

-}