You are here

class PHPExcel_Worksheet_SheetView in Loft Data Grids 6.2

Same name and namespace in other branches
  1. 7.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet/SheetView.php \PHPExcel_Worksheet_SheetView

PHPExcel_Worksheet_SheetView

@category PHPExcel @package PHPExcel_Worksheet @copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)

Hierarchy

Expanded class hierarchy of PHPExcel_Worksheet_SheetView

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet/SheetView.php, line 36

View source
class PHPExcel_Worksheet_SheetView {

  /* Sheet View types */
  const SHEETVIEW_NORMAL = 'normal';
  const SHEETVIEW_PAGE_LAYOUT = 'pageLayout';
  const SHEETVIEW_PAGE_BREAK_PREVIEW = 'pageBreakPreview';
  private static $_sheetViewTypes = array(
    self::SHEETVIEW_NORMAL,
    self::SHEETVIEW_PAGE_LAYOUT,
    self::SHEETVIEW_PAGE_BREAK_PREVIEW,
  );

  /**
   * ZoomScale
   *
   * Valid values range from 10 to 400.
   *
   * @var int
   */
  private $_zoomScale = 100;

  /**
   * ZoomScaleNormal
   *
   * Valid values range from 10 to 400.
   *
   * @var int
   */
  private $_zoomScaleNormal = 100;

  /**
   * View
   *
   * Valid values range from 10 to 400.
   *
   * @var string
   */
  private $_sheetviewType = self::SHEETVIEW_NORMAL;

  /**
   * Create a new PHPExcel_Worksheet_SheetView
   */
  public function __construct() {
  }

  /**
   * Get ZoomScale
   *
   * @return int
   */
  public function getZoomScale() {
    return $this->_zoomScale;
  }

  /**
   * Set ZoomScale
   *
   * Valid values range from 10 to 400.
   *
   * @param 	int 	$pValue
   * @throws 	PHPExcel_Exception
   * @return PHPExcel_Worksheet_SheetView
   */
  public function setZoomScale($pValue = 100) {

    // 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 >= 1
    if ($pValue >= 1 || is_null($pValue)) {
      $this->_zoomScale = $pValue;
    }
    else {
      throw new PHPExcel_Exception("Scale must be greater than or equal to 1.");
    }
    return $this;
  }

  /**
   * Get ZoomScaleNormal
   *
   * @return int
   */
  public function getZoomScaleNormal() {
    return $this->_zoomScaleNormal;
  }

  /**
   * Set ZoomScale
   *
   * Valid values range from 10 to 400.
   *
   * @param 	int 	$pValue
   * @throws 	PHPExcel_Exception
   * @return PHPExcel_Worksheet_SheetView
   */
  public function setZoomScaleNormal($pValue = 100) {
    if ($pValue >= 1 || is_null($pValue)) {
      $this->_zoomScaleNormal = $pValue;
    }
    else {
      throw new PHPExcel_Exception("Scale must be greater than or equal to 1.");
    }
    return $this;
  }

  /**
   * Get View
   *
   * @return string
   */
  public function getView() {
    return $this->_sheetviewType;
  }

  /**
   * Set View
   *
   * Valid values are
   *		'normal'			self::SHEETVIEW_NORMAL
   *		'pageLayout'		self::SHEETVIEW_PAGE_LAYOUT
   *		'pageBreakPreview'	self::SHEETVIEW_PAGE_BREAK_PREVIEW
   *
   * @param 	string 	$pValue
   * @throws 	PHPExcel_Exception
   * @return PHPExcel_Worksheet_SheetView
   */
  public function setView($pValue = NULL) {

    //	MS Excel 2007 allows setting the view to 'normal', 'pageLayout' or 'pageBreakPreview'
    //		via the user interface
    if ($pValue === NULL) {
      $pValue = self::SHEETVIEW_NORMAL;
    }
    if (in_array($pValue, self::$_sheetViewTypes)) {
      $this->_sheetviewType = $pValue;
    }
    else {
      throw new PHPExcel_Exception("Invalid sheetview layout type.");
    }
    return $this;
  }

  /**
   * 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;
      }
    }
  }

}

Members

Namesort descending Modifiers Type Description Overrides
PHPExcel_Worksheet_SheetView::$_sheetviewType private property * View * * Valid values range from 10 to 400. * *
PHPExcel_Worksheet_SheetView::$_sheetViewTypes private static property
PHPExcel_Worksheet_SheetView::$_zoomScale private property * ZoomScale * * Valid values range from 10 to 400. * *
PHPExcel_Worksheet_SheetView::$_zoomScaleNormal private property * ZoomScaleNormal * * Valid values range from 10 to 400. * *
PHPExcel_Worksheet_SheetView::getView public function * Get View * *
PHPExcel_Worksheet_SheetView::getZoomScale public function * Get ZoomScale * *
PHPExcel_Worksheet_SheetView::getZoomScaleNormal public function * Get ZoomScaleNormal * *
PHPExcel_Worksheet_SheetView::setView public function * Set View * * Valid values are * 'normal' self::SHEETVIEW_NORMAL * 'pageLayout' self::SHEETVIEW_PAGE_LAYOUT * 'pageBreakPreview' self::SHEETVIEW_PAGE_BREAK_PREVIEW * *
PHPExcel_Worksheet_SheetView::setZoomScale public function * Set ZoomScale * * Valid values range from 10 to 400. * *
PHPExcel_Worksheet_SheetView::setZoomScaleNormal public function * Set ZoomScale * * Valid values range from 10 to 400. * *
PHPExcel_Worksheet_SheetView::SHEETVIEW_NORMAL constant
PHPExcel_Worksheet_SheetView::SHEETVIEW_PAGE_BREAK_PREVIEW constant
PHPExcel_Worksheet_SheetView::SHEETVIEW_PAGE_LAYOUT constant
PHPExcel_Worksheet_SheetView::__clone public function * Implement PHP __clone to create a deep clone, not just a shallow copy.
PHPExcel_Worksheet_SheetView::__construct public function Create a new PHPExcel_Worksheet_SheetView