Documentation

CellValue extends WizardAbstract implements WizardInterface

Interfaces, Classes and Traits

WizardInterface

Table of Contents

MAGIC_OPERATIONS  = ['equals' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_EQUAL, 'notEquals' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_NOTEQUAL, 'greaterThan' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_GREATERTHAN, 'greaterThanOrEqual' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_GREATERTHANOREQUAL, 'lessThan' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_LESSTHAN, 'lessThanOrEqual' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_LESSTHANOREQUAL, 'between' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_BETWEEN, 'notBetween' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_NOTBETWEEN]
RANGE_OPERATORS  = PhpOfficePhpSpreadsheetStyleConditionalFormattingCellMatcher::COMPARISON_RANGE_OPERATORS
SINGLE_OPERATORS  = PhpOfficePhpSpreadsheetStyleConditionalFormattingCellMatcher::COMPARISON_OPERATORS
$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
__call()  : self
__construct()  : mixed
and()  :
between()  :
equals()  :
fromConditional()  : WizardInterface
getCellRange()  : string
getConditional()  : Conditional
getStopIfTrue()  : bool
getStyle()  : Style
greaterThan()  :
greaterThanOrEqual()  :
lessThan()  :
lessThanOrEqual()  :
notBetween()  :
notEquals()  :
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' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_EQUAL, 'notEquals' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_NOTEQUAL, 'greaterThan' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_GREATERTHAN, 'greaterThanOrEqual' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_GREATERTHANOREQUAL, 'lessThan' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_LESSTHAN, 'lessThanOrEqual' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_LESSTHANOREQUAL, 'between' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_BETWEEN, 'notBetween' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_NOTBETWEEN]

RANGE_OPERATORS

protected mixed RANGE_OPERATORS = PhpOfficePhpSpreadsheetStyleConditionalFormattingCellMatcher::COMPARISON_RANGE_OPERATORS

SINGLE_OPERATORS

protected mixed SINGLE_OPERATORS = PhpOfficePhpSpreadsheetStyleConditionalFormattingCellMatcher::COMPARISON_OPERATORS

Properties

$operand

protected array<string|int, mixed> $operand = [0]

$operandValueType

protected array<string|int, string> $operandValueType = []

$operator

protected string $operator = PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_EQUAL

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
Return values
mixed —

and()

public and(mixed $value, string $operandValueType = Wizard::VALUE_TYPE_LITERAL) :
Parameters
$value : mixed
$operandValueType = Wizard::VALUE_TYPE_LITERAL : string
Return values
—

between()

public between(mixed $value, string $operandValueType = Wizard::VALUE_TYPE_LITERAL) :
Parameters
$value : mixed
$operandValueType = Wizard::VALUE_TYPE_LITERAL : string
Return values
—

equals()

public equals(mixed $value, string $operandValueType = Wizard::VALUE_TYPE_LITERAL) :
Parameters
$value : mixed
$operandValueType = Wizard::VALUE_TYPE_LITERAL : string
Return values
—

getCellRange()

public getCellRange() : string
Return values
string —

getStopIfTrue()

public getStopIfTrue() : bool
Return values
bool —

greaterThan()

public greaterThan(mixed $value, string $operandValueType = Wizard::VALUE_TYPE_LITERAL) :
Parameters
$value : mixed
$operandValueType = Wizard::VALUE_TYPE_LITERAL : string
Return values
—

greaterThanOrEqual()

public greaterThanOrEqual(mixed $value, string $operandValueType = Wizard::VALUE_TYPE_LITERAL) :
Parameters
$value : mixed
$operandValueType = Wizard::VALUE_TYPE_LITERAL : string
Return values
—

lessThan()

public lessThan(mixed $value, string $operandValueType = Wizard::VALUE_TYPE_LITERAL) :
Parameters
$value : mixed
$operandValueType = Wizard::VALUE_TYPE_LITERAL : string
Return values
—

lessThanOrEqual()

public lessThanOrEqual(mixed $value, string $operandValueType = Wizard::VALUE_TYPE_LITERAL) :
Parameters
$value : mixed
$operandValueType = Wizard::VALUE_TYPE_LITERAL : string
Return values
—

notBetween()

public notBetween(mixed $value, string $operandValueType = Wizard::VALUE_TYPE_LITERAL) :
Parameters
$value : mixed
$operandValueType = Wizard::VALUE_TYPE_LITERAL : string
Return values
—

notEquals()

public notEquals(mixed $value, string $operandValueType = Wizard::VALUE_TYPE_LITERAL) :
Parameters
$value : mixed
$operandValueType = Wizard::VALUE_TYPE_LITERAL : string
Return values
—

reverseAdjustCellRef()

public static reverseAdjustCellRef(string $condition, string $cellRange) : string
Parameters
$condition : string
$cellRange : string
Return values
string —

setCellRange()

public setCellRange(string $cellRange) : void
Parameters
$cellRange : string
Return values
void —

setStopIfTrue()

public setStopIfTrue(bool $stopIfTrue) : void
Parameters
$stopIfTrue : bool
Return values
void —

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
string —

conditionCellAdjustment()

protected conditionCellAdjustment(array<string|int, mixed> $matches) : string
Parameters
$matches : array<string|int, mixed>
Return values
string —

operand()

protected operand(int $index, mixed $operand[, string $operandValueType = Wizard::VALUE_TYPE_LITERAL ]) : void
Parameters
$index : int
$operand : mixed
$operandValueType : string = Wizard::VALUE_TYPE_LITERAL
Return values
void —

operator()

protected operator(string $operator) : void
Parameters
$operator : string
Return values
void —

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
string —

setReferenceCellForExpressions()

protected setReferenceCellForExpressions(string $conditionalRange) : void
Parameters
$conditionalRange : string
Return values
void —

unwrapString()

protected static unwrapString(string $condition) : string
Parameters
$condition : string
Return values
string —

validateOperand()

protected validateOperand(string $operand[, string $operandValueType = Wizard::VALUE_TYPE_LITERAL ]) : string
Parameters
$operand : string
$operandValueType : string = Wizard::VALUE_TYPE_LITERAL
Return values
string —

wrapValue()

protected wrapValue(mixed $value, string $operandValueType) : float|int|string
Parameters
$value : mixed
$operandValueType : string
Return values
float|int|string —

Search results