CellValue
extends WizardAbstract
in package
implements
WizardInterface
Table of Contents
Interfaces
Constants
- MAGIC_OPERATIONS = ['equals' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_EQUAL, 'notEquals' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_NOTEQUAL, 'greaterThan' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_GREATERTHAN, 'greaterThanOrEqual' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_GREATERTHANOREQUAL, 'lessThan' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_LESSTHAN, 'lessThanOrEqual' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_LESSTHANOREQUAL, 'between' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_BETWEEN, 'notBetween' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_NOTBETWEEN]
- RANGE_OPERATORS = \PhpOffice\PhpSpreadsheet\Style\ConditionalFormatting\CellMatcher::COMPARISON_RANGE_OPERATORS
- SINGLE_OPERATORS = \PhpOffice\PhpSpreadsheet\Style\ConditionalFormatting\CellMatcher::COMPARISON_OPERATORS
Properties
- $cellRange : string
- $expression : string
- $operand : array<string|int, mixed>
- $operandValueType : array<string|int, string>
- $operator : string
- $referenceCell : string
- $referenceColumn : int
- $referenceRow : int
- $stopIfTrue : bool
- $style : Style|null
Methods
- __call() : self
- __construct() : mixed
- and() : CellValue
- between() : CellValue
- equals() : CellValue
- fromConditional() : WizardInterface
- getCellRange() : string
- getConditional() : Conditional
- getStopIfTrue() : bool
- getStyle() : Style
- greaterThan() : CellValue
- greaterThanOrEqual() : CellValue
- lessThan() : CellValue
- lessThanOrEqual() : CellValue
- notBetween() : CellValue
- notEquals() : CellValue
- reverseAdjustCellRef() : string
- setCellRange() : void
- setStopIfTrue() : void
- setStyle() : void
- adjustConditionsForCellReferences() : array<string|int, mixed>
- cellConditionCheck() : string
- conditionCellAdjustment() : string
- operand() : void
- operator() : void
- reverseCellAdjustment() : string
- setReferenceCellForExpressions() : void
- unwrapString() : string
- validateOperand() : string
- wrapValue() : float|int|string
Constants
MAGIC_OPERATIONS
protected
mixed
MAGIC_OPERATIONS
= ['equals' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_EQUAL, 'notEquals' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_NOTEQUAL, 'greaterThan' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_GREATERTHAN, 'greaterThanOrEqual' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_GREATERTHANOREQUAL, 'lessThan' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_LESSTHAN, 'lessThanOrEqual' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_LESSTHANOREQUAL, 'between' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_BETWEEN, 'notBetween' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_NOTBETWEEN]
RANGE_OPERATORS
protected
mixed
RANGE_OPERATORS
= \PhpOffice\PhpSpreadsheet\Style\ConditionalFormatting\CellMatcher::COMPARISON_RANGE_OPERATORS
SINGLE_OPERATORS
protected
mixed
SINGLE_OPERATORS
= \PhpOffice\PhpSpreadsheet\Style\ConditionalFormatting\CellMatcher::COMPARISON_OPERATORS
Properties
$cellRange
protected
string
$cellRange
$expression
protected
string
$expression
$operand
protected
array<string|int, mixed>
$operand
= [0]
$operandValueType
protected
array<string|int, string>
$operandValueType
= []
$operator
protected
string
$operator
= \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_EQUAL
$referenceCell
protected
string
$referenceCell
$referenceColumn
protected
int
$referenceColumn
$referenceRow
protected
int
$referenceRow
$stopIfTrue
protected
bool
$stopIfTrue
= false
$style
protected
Style|null
$style
= null
Methods
__call()
public
__call(string $methodName, array<string|int, mixed> $arguments) : self
Parameters
- $methodName : string
- $arguments : array<string|int, mixed>
Return values
self__construct()
public
__construct(string $cellRange) : mixed
Parameters
- $cellRange : string
and()
public
and([mixed $value = ][, string $operandValueType = Wizard::VALUE_TYPE_LITERAL ]) : CellValue
Parameters
- $value : mixed =
- $operandValueType : string = Wizard::VALUE_TYPE_LITERAL
Return values
CellValuebetween()
public
between([mixed $value = ][, string $operandValueType = Wizard::VALUE_TYPE_LITERAL ]) : CellValue
Parameters
- $value : mixed =
- $operandValueType : string = Wizard::VALUE_TYPE_LITERAL
Return values
CellValueequals()
public
equals([mixed $value = ][, string $operandValueType = Wizard::VALUE_TYPE_LITERAL ]) : CellValue
Parameters
- $value : mixed =
- $operandValueType : string = Wizard::VALUE_TYPE_LITERAL
Return values
CellValuefromConditional()
public
static fromConditional(Conditional $conditional[, string $cellRange = 'A1' ]) : WizardInterface
Parameters
- $conditional : Conditional
- $cellRange : string = 'A1'
Return values
WizardInterfacegetCellRange()
public
getCellRange() : string
Return values
stringgetConditional()
public
getConditional() : Conditional
Return values
ConditionalgetStopIfTrue()
public
getStopIfTrue() : bool
Return values
boolgetStyle()
public
getStyle() : Style
Return values
StylegreaterThan()
public
greaterThan([mixed $value = ][, string $operandValueType = Wizard::VALUE_TYPE_LITERAL ]) : CellValue
Parameters
- $value : mixed =
- $operandValueType : string = Wizard::VALUE_TYPE_LITERAL
Return values
CellValuegreaterThanOrEqual()
public
greaterThanOrEqual([mixed $value = ][, string $operandValueType = Wizard::VALUE_TYPE_LITERAL ]) : CellValue
Parameters
- $value : mixed =
- $operandValueType : string = Wizard::VALUE_TYPE_LITERAL
Return values
CellValuelessThan()
public
lessThan([mixed $value = ][, string $operandValueType = Wizard::VALUE_TYPE_LITERAL ]) : CellValue
Parameters
- $value : mixed =
- $operandValueType : string = Wizard::VALUE_TYPE_LITERAL
Return values
CellValuelessThanOrEqual()
public
lessThanOrEqual([mixed $value = ][, string $operandValueType = Wizard::VALUE_TYPE_LITERAL ]) : CellValue
Parameters
- $value : mixed =
- $operandValueType : string = Wizard::VALUE_TYPE_LITERAL
Return values
CellValuenotBetween()
public
notBetween([mixed $value = ][, string $operandValueType = Wizard::VALUE_TYPE_LITERAL ]) : CellValue
Parameters
- $value : mixed =
- $operandValueType : string = Wizard::VALUE_TYPE_LITERAL
Return values
CellValuenotEquals()
public
notEquals([mixed $value = ][, string $operandValueType = Wizard::VALUE_TYPE_LITERAL ]) : CellValue
Parameters
- $value : mixed =
- $operandValueType : string = Wizard::VALUE_TYPE_LITERAL
Return values
CellValuereverseAdjustCellRef()
public
static reverseAdjustCellRef(string $condition, string $cellRange) : string
Parameters
- $condition : string
- $cellRange : string
Return values
stringsetCellRange()
public
setCellRange(string $cellRange) : void
Parameters
- $cellRange : string
setStopIfTrue()
public
setStopIfTrue(bool $stopIfTrue) : void
Parameters
- $stopIfTrue : bool
setStyle()
public
setStyle(Style $style) : void
Parameters
- $style : Style
adjustConditionsForCellReferences()
protected
adjustConditionsForCellReferences(array<string|int, mixed> $conditions) : array<string|int, mixed>
Parameters
- $conditions : array<string|int, mixed>
Return values
array<string|int, mixed>cellConditionCheck()
protected
cellConditionCheck(string $condition) : string
Parameters
- $condition : string
Return values
stringconditionCellAdjustment()
protected
conditionCellAdjustment(array<string|int, mixed> $matches) : string
Parameters
- $matches : array<string|int, mixed>
Return values
stringoperand()
protected
operand(int $index, mixed $operand[, string $operandValueType = Wizard::VALUE_TYPE_LITERAL ]) : void
Parameters
- $index : int
- $operand : mixed
- $operandValueType : string = Wizard::VALUE_TYPE_LITERAL
operator()
protected
operator(string $operator) : void
Parameters
- $operator : string
reverseCellAdjustment()
protected
static reverseCellAdjustment(array<string|int, mixed> $matches, int $referenceColumn, int $referenceRow) : string
Parameters
- $matches : array<string|int, mixed>
- $referenceColumn : int
- $referenceRow : int
Return values
stringsetReferenceCellForExpressions()
protected
setReferenceCellForExpressions(string $conditionalRange) : void
Parameters
- $conditionalRange : string
unwrapString()
protected
static unwrapString(string $condition) : string
Parameters
- $condition : string
Return values
stringvalidateOperand()
protected
validateOperand(string $operand[, string $operandValueType = Wizard::VALUE_TYPE_LITERAL ]) : string
Parameters
- $operand : string
- $operandValueType : string = Wizard::VALUE_TYPE_LITERAL
Return values
stringwrapValue()
protected
wrapValue(null|bool|float|int|string $value, string $operandValueType) : float|int|string
Parameters
- $value : null|bool|float|int|string
-
value to be wrapped
- $operandValueType : string