Documentation

TextValue extends WizardAbstract
in package
implements WizardInterface

Table of Contents

Interfaces

WizardInterface

Constants

EXPRESSIONS  = [\PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_CONTAINSTEXT => 'NOT(ISERROR(SEARCH(%s,%s)))', \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_NOTCONTAINS => 'ISERROR(SEARCH(%s,%s))', \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_BEGINSWITH => 'LEFT(%s,LEN(%s))=%s', \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_ENDSWITH => 'RIGHT(%s,LEN(%s))=%s']
MAGIC_OPERATIONS  = ['contains' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_CONTAINSTEXT, 'doesntContain' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_NOTCONTAINS, 'doesNotContain' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_NOTCONTAINS, 'beginsWith' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_BEGINSWITH, 'startsWith' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_BEGINSWITH, 'endsWith' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_ENDSWITH]
OPERATORS  = [\PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_CONTAINSTEXT => \PhpOffice\PhpSpreadsheet\Style\Conditional::CONDITION_CONTAINSTEXT, \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_NOTCONTAINS => \PhpOffice\PhpSpreadsheet\Style\Conditional::CONDITION_NOTCONTAINSTEXT, \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_BEGINSWITH => \PhpOffice\PhpSpreadsheet\Style\Conditional::CONDITION_BEGINSWITH, \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_ENDSWITH => \PhpOffice\PhpSpreadsheet\Style\Conditional::CONDITION_ENDSWITH]

Properties

$cellRange  : string
$expression  : string
$operand  : string
$operandValueType  : string
$operator  : string
$referenceCell  : string
$referenceColumn  : int
$referenceRow  : int
$stopIfTrue  : bool
$style  : Style|null

Methods

__call()  : self
__construct()  : mixed
beginsWith()  : TextValue
contains()  : TextValue
doesNotContain()  : TextValue
doesntContain()  : TextValue
endsWith()  : TextValue
fromConditional()  : WizardInterface
getCellRange()  : string
getConditional()  : Conditional
getStopIfTrue()  : bool
getStyle()  : Style
reverseAdjustCellRef()  : string
setCellRange()  : void
setStopIfTrue()  : void
setStyle()  : void
startsWith()  : TextValue
adjustConditionsForCellReferences()  : array<string|int, mixed>
cellConditionCheck()  : string
conditionCellAdjustment()  : string
operand()  : void
operator()  : void
reverseCellAdjustment()  : string
setExpression()  : void
setReferenceCellForExpressions()  : void
validateOperand()  : string
wrapValue()  : string

Constants

EXPRESSIONS

protected mixed EXPRESSIONS = [\PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_CONTAINSTEXT => 'NOT(ISERROR(SEARCH(%s,%s)))', \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_NOTCONTAINS => 'ISERROR(SEARCH(%s,%s))', \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_BEGINSWITH => 'LEFT(%s,LEN(%s))=%s', \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_ENDSWITH => 'RIGHT(%s,LEN(%s))=%s']

MAGIC_OPERATIONS

protected mixed MAGIC_OPERATIONS = ['contains' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_CONTAINSTEXT, 'doesntContain' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_NOTCONTAINS, 'doesNotContain' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_NOTCONTAINS, 'beginsWith' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_BEGINSWITH, 'startsWith' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_BEGINSWITH, 'endsWith' => \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_ENDSWITH]

OPERATORS

protected mixed OPERATORS = [\PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_CONTAINSTEXT => \PhpOffice\PhpSpreadsheet\Style\Conditional::CONDITION_CONTAINSTEXT, \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_NOTCONTAINS => \PhpOffice\PhpSpreadsheet\Style\Conditional::CONDITION_NOTCONTAINSTEXT, \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_BEGINSWITH => \PhpOffice\PhpSpreadsheet\Style\Conditional::CONDITION_BEGINSWITH, \PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_ENDSWITH => \PhpOffice\PhpSpreadsheet\Style\Conditional::CONDITION_ENDSWITH]

Properties

$operandValueType

protected string $operandValueType

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

beginsWith()

public beginsWith([string $value = ][, string $operandValueType = Wizard::VALUE_TYPE_LITERAL ]) : TextValue
Parameters
$value : string =
$operandValueType : string = Wizard::VALUE_TYPE_LITERAL
Return values
TextValue

contains()

public contains([string $value = ][, string $operandValueType = Wizard::VALUE_TYPE_LITERAL ]) : TextValue
Parameters
$value : string =
$operandValueType : string = Wizard::VALUE_TYPE_LITERAL
Return values
TextValue

doesNotContain()

public doesNotContain([string $value = ][, string $operandValueType = Wizard::VALUE_TYPE_LITERAL ]) : TextValue
Parameters
$value : string =
$operandValueType : string = Wizard::VALUE_TYPE_LITERAL
Return values
TextValue

doesntContain()

public doesntContain([string $value = ][, string $operandValueType = Wizard::VALUE_TYPE_LITERAL ]) : TextValue
Parameters
$value : string =
$operandValueType : string = Wizard::VALUE_TYPE_LITERAL
Return values
TextValue

endsWith()

public endsWith([string $value = ][, string $operandValueType = Wizard::VALUE_TYPE_LITERAL ]) : TextValue
Parameters
$value : string =
$operandValueType : string = Wizard::VALUE_TYPE_LITERAL
Return values
TextValue

getCellRange()

public getCellRange() : string
Return values
string

getStopIfTrue()

public getStopIfTrue() : bool
Return values
bool

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

setStopIfTrue()

public setStopIfTrue(bool $stopIfTrue) : void
Parameters
$stopIfTrue : bool

startsWith()

public startsWith([string $value = ][, string $operandValueType = Wizard::VALUE_TYPE_LITERAL ]) : TextValue
Parameters
$value : string =
$operandValueType : string = Wizard::VALUE_TYPE_LITERAL
Return values
TextValue

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

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
string

setExpression()

protected setExpression() : void

setReferenceCellForExpressions()

protected setReferenceCellForExpressions(string $conditionalRange) : void
Parameters
$conditionalRange : 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(string $value) : string
Parameters
$value : string
Return values
string 

        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results