DEFAULT_RANGE
DEFAULT_RANGE = 'A1:A1'
Default range variable constant
@var string
PHPExcel_Cell
Copyright (c) 2006 - 2015 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
$calculatedValue : mixed
Calculated value of the cell (used for caching) This returns the value last calculated by MS Excel or whichever spreadsheet program was used to create the original spreadsheet file.
Note that this value is not guaranteed to reflect the actual calculated value because it is possible that auto-calculation was disabled in the original spreadsheet, and underlying data values used by the formula have changed since it was last calculated.
attach(\PHPExcel_CachedObjectStorage_CacheBase $parent)
| \PHPExcel_CachedObjectStorage_CacheBase | $parent |
__construct( $pValue = null, string $pDataType = null, \PHPExcel_Worksheet $pSheet = null)
Create a new Cell
@param mixed $pValue
| $pValue | ||
| string | $pDataType | @param PHPExcel_Worksheet $pSheet @throws PHPExcel_Exception |
| \PHPExcel_Worksheet | $pSheet |
setValueExplicit( $pValue = null, string $pDataType = \PHPExcel_Cell_DataType::TYPE_STRING)
Set the value for a cell, with the explicit data type passed to the method (bypassing any use of the value binder)
@param mixed $pValue Value
| $pValue | ||
| string | $pDataType | Explicit data type @return PHPExcel_Cell @throws PHPExcel_Exception |
getCalculatedValue(boolean $resetLog = true)
Get calculated cell value
@deprecated Since version 1.7.8 for planned changes to cell for array formula handling
| boolean | $resetLog | Whether the calculation engine logger should be reset or not @return mixed @throws PHPExcel_Exception |
setCalculatedValue( $pValue = null) : \PHPExcel_Cell
Set old calculated value (cached)
@param mixed $pValue Value
| $pValue |
getOldCalculatedValue() : mixed
Get old calculated value (cached) This returns the value last calculated by MS Excel or whichever spreadsheet program was used to create the original spreadsheet file.
Note that this value is not guaranteed to refelect the actual calculated value because it is possible that auto-calculation was disabled in the original spreadsheet, and underlying data values used by the formula have changed since it was last calculated.
setDataType( $pDataType = \PHPExcel_Cell_DataType::TYPE_STRING) : \PHPExcel_Cell
Set cell data type
@param string $pDataType
| $pDataType |
setDataValidation(\PHPExcel_Cell_DataValidation $pDataValidation = null) : \PHPExcel_Cell
Set Data validation rules
@param PHPExcel_Cell_DataValidation $pDataValidation
| \PHPExcel_Cell_DataValidation | $pDataValidation |
@throws PHPExcel_Exception
setHyperlink(\PHPExcel_Cell_Hyperlink $pHyperlink = null) : \PHPExcel_Cell
Set Hyperlink
@param PHPExcel_Cell_Hyperlink $pHyperlink
| \PHPExcel_Cell_Hyperlink | $pHyperlink |
@throws PHPExcel_Exception
rebindParent(\PHPExcel_Worksheet $parent) : \PHPExcel_Cell
Re-bind parent
@param PHPExcel_Worksheet $parent
| \PHPExcel_Worksheet | $parent |
absoluteReference( $pCoordinateString = 'A1') : string
Make string row, column or cell coordinate absolute
@param string $pCoordinateString e.g. 'A' or '1' or 'A1' Note that this value can be a row or column reference as well as a cell reference
| $pCoordinateString |
Absolute coordinate e.g. '$A' or '$1' or '$A$1' @throws PHPExcel_Exception
splitRange( $pRange = 'A1:A1') : array
Split range into coordinate strings
@param string $pRange e.g. 'B4:D9' or 'B4:D9,H2:O11' or 'B4'
| $pRange |
Array containg one or more arrays containing one or two coordinate strings e.g. array('B4','D9') or array(array('B4','D9'),array('H2','O11')) or array('B4')
compareCells(\PHPExcel_Cell $a, \PHPExcel_Cell $b) : integer
Compare 2 cells
| \PHPExcel_Cell | $a | Cell a |
| \PHPExcel_Cell | $b | Cell b |
Result of comparison (always -1 or 1, never zero!)
getValueBinder() : \PHPExcel_Cell_IValueBinder
Get value binder to use
setValueBinder(\PHPExcel_Cell_IValueBinder $binder = null)
Set value binder to use
| \PHPExcel_Cell_IValueBinder | $binder |
setXfIndex(integer $pValue) : \PHPExcel_Cell
Set index to cellXf
| integer | $pValue |