Interfaces, Classes and Traits
- WizardInterface
Table of Contents
-
EXPRESSIONS
= [PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_CONTAINSTEXT => 'NOT(ISERROR(SEARCH(%s,%s)))', PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_NOTCONTAINS => 'ISERROR(SEARCH(%s,%s))', PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_BEGINSWITH => 'LEFT(%s,LEN(%s))=%s', PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_ENDSWITH => 'RIGHT(%s,LEN(%s))=%s']
-
MAGIC_OPERATIONS
= ['contains' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_CONTAINSTEXT, 'doesntContain' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_NOTCONTAINS, 'doesNotContain' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_NOTCONTAINS, 'beginsWith' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_BEGINSWITH, 'startsWith' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_BEGINSWITH, 'endsWith' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_ENDSWITH]
-
OPERATORS
= [PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_CONTAINSTEXT => PhpOfficePhpSpreadsheetStyleConditional::CONDITION_CONTAINSTEXT, PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_NOTCONTAINS => PhpOfficePhpSpreadsheetStyleConditional::CONDITION_NOTCONTAINSTEXT, PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_BEGINSWITH => PhpOfficePhpSpreadsheetStyleConditional::CONDITION_BEGINSWITH, PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_ENDSWITH => PhpOfficePhpSpreadsheetStyleConditional::CONDITION_ENDSWITH]
-
$cellRange
: string
-
$expression
: string
-
$operand
: string
-
$operandValueType
: string
-
$operator
: string
-
$referenceCell
: string
-
$referenceColumn
: int
-
$referenceRow
: int
-
$stopIfTrue
: bool
-
$style
: Style|null
-
__call()
: self
-
__construct()
: mixed
-
beginsWith()
:
-
contains()
:
-
doesNotContain()
:
-
doesntContain()
:
-
endsWith()
:
-
fromConditional()
: WizardInterface
-
getCellRange()
: string
-
getConditional()
: Conditional
-
getStopIfTrue()
: bool
-
getStyle()
: Style
-
reverseAdjustCellRef()
: string
-
setCellRange()
: void
-
setStopIfTrue()
: void
-
setStyle()
: void
-
startsWith()
:
-
adjustConditionsForCellReferences()
: array<string|int, mixed>
-
cellConditionCheck()
: string
-
conditionCellAdjustment()
: string
-
operand()
: void
-
operator()
: void
-
reverseCellAdjustment()
: string
-
setExpression()
: void
-
setReferenceCellForExpressions()
: void
-
validateOperand()
: string
-
wrapValue()
: string
EXPRESSIONS
protected
mixed
EXPRESSIONS
= [PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_CONTAINSTEXT => 'NOT(ISERROR(SEARCH(%s,%s)))', PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_NOTCONTAINS => 'ISERROR(SEARCH(%s,%s))', PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_BEGINSWITH => 'LEFT(%s,LEN(%s))=%s', PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_ENDSWITH => 'RIGHT(%s,LEN(%s))=%s']
MAGIC_OPERATIONS
protected
mixed
MAGIC_OPERATIONS
= ['contains' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_CONTAINSTEXT, 'doesntContain' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_NOTCONTAINS, 'doesNotContain' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_NOTCONTAINS, 'beginsWith' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_BEGINSWITH, 'startsWith' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_BEGINSWITH, 'endsWith' => PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_ENDSWITH]
OPERATORS
protected
mixed
OPERATORS
= [PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_CONTAINSTEXT => PhpOfficePhpSpreadsheetStyleConditional::CONDITION_CONTAINSTEXT, PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_NOTCONTAINS => PhpOfficePhpSpreadsheetStyleConditional::CONDITION_NOTCONTAINSTEXT, PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_BEGINSWITH => PhpOfficePhpSpreadsheetStyleConditional::CONDITION_BEGINSWITH, PhpOfficePhpSpreadsheetStyleConditional::OPERATOR_ENDSWITH => PhpOfficePhpSpreadsheetStyleConditional::CONDITION_ENDSWITH]
$cellRange
protected
string
$cellRange
$expression
protected
string
$expression
$operand
protected
string
$operand
$operandValueType
protected
string
$operandValueType
$operator
protected
string
$operator
$referenceCell
protected
string
$referenceCell
$referenceColumn
protected
int
$referenceColumn
$referenceRow
protected
int
$referenceRow
$stopIfTrue
protected
bool
$stopIfTrue
= false
$style
protected
Style|null
$style
__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
—
beginsWith()
public
beginsWith(string $value, string $operandValueType = Wizard::VALUE_TYPE_LITERAL) :
Parameters
-
$value
: string
-
-
$operandValueType = Wizard::VALUE_TYPE_LITERAL
: string
-
Return values
—
contains()
public
contains(string $value, string $operandValueType = Wizard::VALUE_TYPE_LITERAL) :
Parameters
-
$value
: string
-
-
$operandValueType = Wizard::VALUE_TYPE_LITERAL
: string
-
Return values
—
doesNotContain()
public
doesNotContain(string $value, string $operandValueType = Wizard::VALUE_TYPE_LITERAL) :
Parameters
-
$value
: string
-
-
$operandValueType = Wizard::VALUE_TYPE_LITERAL
: string
-
Return values
—
doesntContain()
public
doesntContain(string $value, string $operandValueType = Wizard::VALUE_TYPE_LITERAL) :
Parameters
-
$value
: string
-
-
$operandValueType = Wizard::VALUE_TYPE_LITERAL
: string
-
Return values
—
endsWith()
public
endsWith(string $value, string $operandValueType = Wizard::VALUE_TYPE_LITERAL) :
Parameters
-
$value
: string
-
-
$operandValueType = Wizard::VALUE_TYPE_LITERAL
: string
-
Return values
—
fromConditional()
public
static fromConditional(Conditional $conditional[, string $cellRange = 'A1' ]) : WizardInterface
Parameters
-
$conditional
: Conditional
-
-
$cellRange
: string
= 'A1'
-
Return values
WizardInterface
—
getCellRange()
public
getCellRange() : string
Return values
string
—
getConditional()
public
getConditional() : Conditional
Return values
Conditional
—
getStopIfTrue()
public
getStopIfTrue() : bool
Return values
bool
—
getStyle()
public
getStyle() : Style
Return values
Style
—
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
—
setStyle()
public
setStyle(Style $style) : void
Parameters
-
$style
: Style
-
Return values
void
—
startsWith()
public
startsWith(string $value, string $operandValueType = Wizard::VALUE_TYPE_LITERAL) :
Parameters
-
$value
: string
-
-
$operandValueType = Wizard::VALUE_TYPE_LITERAL
: string
-
Return values
—
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(string $operand[, string $operandValueType = Wizard::VALUE_TYPE_LITERAL ]) : void
Parameters
-
$operand
: string
-
-
$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
—
setExpression()
protected
setExpression() : void
Return values
void
—
setReferenceCellForExpressions()
protected
setReferenceCellForExpressions(string $conditionalRange) : void
Parameters
-
$conditionalRange
: string
-
Return values
void
—
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(string $value) : string
Parameters
-
$value
: string
-
Return values
string
—