Source for file Alignment.php
Documentation is available at Alignment.php
* Copyright (c) 2006 - 2009 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
* @package PHPExcel_Style
* @copyright Copyright (c) 2006 - 2009 PHPExcel (http://www.codeplex.com/PHPExcel)
* @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
* @version 1.6.5, 2009-01-05
/** PHPExcel_IComparable */
require_once 'PHPExcel/IComparable.php';
* PHPExcel_Style_Alignment
* @package PHPExcel_Style
* @copyright Copyright (c) 2006 - 2009 PHPExcel (http://www.codeplex.com/PHPExcel)
/* Horizontal alignment styles */
const HORIZONTAL_GENERAL = 'general';
const HORIZONTAL_LEFT = 'left';
const HORIZONTAL_RIGHT = 'right';
const HORIZONTAL_CENTER = 'center';
const HORIZONTAL_JUSTIFY = 'justify';
/* Vertical alignment styles */
const VERTICAL_BOTTOM = 'bottom';
const VERTICAL_TOP = 'top';
const VERTICAL_CENTER = 'center';
const VERTICAL_JUSTIFY = 'justify';
* Indent - only possible with horizontal alignment left and right
* @var _parentPropertyName string
* Create a new PHPExcel_Style_Alignment
* Configures this object for late binding as a property of a parent object
* @param $parentPropertyName
// Initialize parent PHPExcel_Style for late binding. This relationship purposely ends immediately when this object
// is bound to the PHPExcel_Style object pointed to so as to prevent circular references.
* Returns the PHPExcel_Style_Alignment that is actual bound to PHPExcel_Style
* @return PHPExcel_Style_Alignment
return $this; // I am bound
return $this; // No one is bound yet
* If no PHPExcel_Style_Alignment has been bound to PHPExcel_Style then bind this one. Return the actual bound one.
* @return PHPExcel_Style_Alignment
return $this; // I am already bound
* Apply styles from array
* $objPHPExcel->getActiveSheet()->getStyle('B2')->getAlignment()->applyFromArray(
* 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
* 'vertical' => PHPExcel_Style_Alignment::VERTICAL_CENTER,
* @param array $pStyles Array containing style information
throw new Exception("Invalid style array passed.");
public function setHorizontal($pValue = PHPExcel_Style_Alignment::HORIZONTAL_GENERAL) {
public function setVertical($pValue = PHPExcel_Style_Alignment::VERTICAL_BOTTOM) {
// Excel2007 value 255 => PHPExcel value -165
if ( ($pValue >= - 90 && $pValue <= 90) || $pValue == - 165 ) {
throw new Exception("Text rotation should be a value between -90 and 90.");
$pValue = 0; // indent not supported
* @return string Hash code
. $property->_textRotation
. ($property->_wrapText ? 't' : 'f')
. ($property->_shrinkToFit ? 't' : 'f')
* Note that this index may vary during script execution! Only reliable moment is
* while doing a write of a workbook and when changes are not allowed.
* @return string Hash index
* Note that this index may vary during script execution! Only reliable moment is
* while doing a write of a workbook and when changes are not allowed.
* @param string $value Hash index
* Implement PHP __clone to create a deep clone, not just a shallow copy.
foreach ($vars as $key => $value) {
$this->$key = clone $value;
|