$valueBinder
$valueBinder : \PhpOffice\PhpSpreadsheet\Cell\IValueBinder
Value binder to use.
$valueBinder : \PhpOffice\PhpSpreadsheet\Cell\IValueBinder
Value binder to use.
$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.
$parent : \PhpOffice\PhpSpreadsheet\Collection\Cells
Collection of cells.
attach(\PhpOffice\PhpSpreadsheet\Collection\Cells $parent)
| \PhpOffice\PhpSpreadsheet\Collection\Cells | $parent |
__construct(mixed $pValue, string $pDataType, \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet)
Create a new Cell.
| mixed | $pValue | |
| string | $pDataType | |
| \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $pSheet |
setValue(mixed $pValue) : \PhpOffice\PhpSpreadsheet\Cell\Cell
Set cell value.
Sets the value for a cell, automatically determining the datatype using the value binder
| mixed | $pValue | Value |
setValueExplicit(mixed $pValue, string $pDataType) : \PhpOffice\PhpSpreadsheet\Cell\Cell
Set the value for a cell, with the explicit data type passed to the method (bypassing any use of the value binder).
| mixed | $pValue | Value |
| string | $pDataType | Explicit data type, see DataType::TYPE_* |
setCalculatedValue(mixed $pValue) : \PhpOffice\PhpSpreadsheet\Cell\Cell
Set old calculated value (cached).
| mixed | $pValue | Value |
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 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.
setDataType(string $pDataType) : \PhpOffice\PhpSpreadsheet\Cell\Cell
Set cell data type.
| string | $pDataType | see DataType::TYPE_* |
getDataValidation() : \PhpOffice\PhpSpreadsheet\Cell\DataValidation
Get Data validation rules.
setDataValidation(\PhpOffice\PhpSpreadsheet\Cell\DataValidation $pDataValidation = null) : \PhpOffice\PhpSpreadsheet\Cell\Cell
Set Data validation rules.
| \PhpOffice\PhpSpreadsheet\Cell\DataValidation | $pDataValidation |
getHyperlink() : \PhpOffice\PhpSpreadsheet\Cell\Hyperlink
Get Hyperlink.
setHyperlink(\PhpOffice\PhpSpreadsheet\Cell\Hyperlink $pHyperlink = null) : \PhpOffice\PhpSpreadsheet\Cell\Cell
Set Hyperlink.
| \PhpOffice\PhpSpreadsheet\Cell\Hyperlink | $pHyperlink |
getParent() : \PhpOffice\PhpSpreadsheet\Collection\Cells
Get cell collection.
getWorksheet() : \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet
Get parent worksheet.
getStyle() : \PhpOffice\PhpSpreadsheet\Style\Style
Get cell style.
rebindParent(\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $parent) : \PhpOffice\PhpSpreadsheet\Cell\Cell
Re-bind parent.
| \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $parent |
compareCells(\PhpOffice\PhpSpreadsheet\Cell\Cell $a, \PhpOffice\PhpSpreadsheet\Cell\Cell $b) : integer
Compare 2 cells.
| \PhpOffice\PhpSpreadsheet\Cell\Cell | $a | Cell a |
| \PhpOffice\PhpSpreadsheet\Cell\Cell | $b | Cell b |
Result of comparison (always -1 or 1, never zero!)
getValueBinder() : \PhpOffice\PhpSpreadsheet\Cell\IValueBinder
Get value binder to use.
setValueBinder(\PhpOffice\PhpSpreadsheet\Cell\IValueBinder $binder)
Set value binder to use.
| \PhpOffice\PhpSpreadsheet\Cell\IValueBinder | $binder |
setXfIndex(integer $pValue) : \PhpOffice\PhpSpreadsheet\Cell\Cell
Set index to cellXf.
| integer | $pValue |
setFormulaAttributes(mixed $pAttributes) : \PhpOffice\PhpSpreadsheet\Cell\Cell
Set the formula attributes.
| mixed | $pAttributes |