Constants

CONDITION_NONE

CONDITION_NONE = 'none'

CONDITION_CELLIS

CONDITION_CELLIS = 'cellIs'

CONDITION_CONTAINSTEXT

CONDITION_CONTAINSTEXT = 'containsText'

CONDITION_EXPRESSION

CONDITION_EXPRESSION = 'expression'

CONDITION_CONTAINSBLANKS

CONDITION_CONTAINSBLANKS = 'containsBlanks'

CONDITION_NOTCONTAINSBLANKS

CONDITION_NOTCONTAINSBLANKS = 'notContainsBlanks'

OPERATOR_NONE

OPERATOR_NONE = ''

OPERATOR_BEGINSWITH

OPERATOR_BEGINSWITH = 'beginsWith'

OPERATOR_ENDSWITH

OPERATOR_ENDSWITH = 'endsWith'

OPERATOR_EQUAL

OPERATOR_EQUAL = 'equal'

OPERATOR_GREATERTHAN

OPERATOR_GREATERTHAN = 'greaterThan'

OPERATOR_GREATERTHANOREQUAL

OPERATOR_GREATERTHANOREQUAL = 'greaterThanOrEqual'

OPERATOR_LESSTHAN

OPERATOR_LESSTHAN = 'lessThan'

OPERATOR_LESSTHANOREQUAL

OPERATOR_LESSTHANOREQUAL = 'lessThanOrEqual'

OPERATOR_NOTEQUAL

OPERATOR_NOTEQUAL = 'notEqual'

OPERATOR_CONTAINSTEXT

OPERATOR_CONTAINSTEXT = 'containsText'

OPERATOR_NOTCONTAINS

OPERATOR_NOTCONTAINS = 'notContains'

OPERATOR_BETWEEN

OPERATOR_BETWEEN = 'between'

Properties

$conditionType

$conditionType : string

Condition type.

Type

string

$operatorType

$operatorType : string

Operator type.

Type

string

$text

$text : string

Text.

Type

string

$stopIfTrue

$stopIfTrue : boolean

Stop on this condition, if it matches.

Type

boolean

$condition

$condition : array<mixed,string>

Condition.

Type

array<mixed,string>

$style

$style : \PhpOffice\PhpSpreadsheet\Style\Style

Style.

Type

\PhpOffice\PhpSpreadsheet\Style\Style

Methods

__construct()

__construct() 

Create a new Conditional.

getConditionType()

getConditionType() : string

Get Condition type.

Returns

string

setConditionType()

setConditionType(string  $pValue) : $this

Set Condition type.

Parameters

string $pValue

Condition type, see self::CONDITION_*

Returns

$this

getOperatorType()

getOperatorType() : string

Get Operator type.

Returns

string

setOperatorType()

setOperatorType(string  $pValue) : $this

Set Operator type.

Parameters

string $pValue

Conditional operator type, see self::OPERATOR_*

Returns

$this

getText()

getText() : string

Get text.

Returns

string

setText()

setText(string  $value) : $this

Set text.

Parameters

string $value

Returns

$this

getStopIfTrue()

getStopIfTrue() : boolean

Get StopIfTrue.

Returns

boolean

setStopIfTrue()

setStopIfTrue(boolean  $value) : $this

Set StopIfTrue.

Parameters

boolean $value

Returns

$this

getConditions()

getConditions() : array<mixed,string>

Get Conditions.

Returns

array<mixed,string>

setConditions()

setConditions(array<mixed,string>  $pValue) : $this

Set Conditions.

Parameters

array<mixed,string> $pValue

Condition

Returns

$this

addCondition()

addCondition(string  $pValue) : $this

Add Condition.

Parameters

string $pValue

Condition

Returns

$this

getStyle()

getStyle() : \PhpOffice\PhpSpreadsheet\Style\Style

Get Style.

Returns

\PhpOffice\PhpSpreadsheet\Style\Style

setStyle()

setStyle(\PhpOffice\PhpSpreadsheet\Style\Style  $pValue = null) : $this

Set Style.

Parameters

\PhpOffice\PhpSpreadsheet\Style\Style $pValue

Returns

$this

getHashCode()

getHashCode() : string

Get hash code.

Returns

string —

Hash code

__clone()

__clone() 

Implement PHP __clone to create a deep clone, not just a shallow copy.