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'

CONDITION_DATABAR

CONDITION_DATABAR = 'dataBar'

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'

OPERATOR_NOTBETWEEN

OPERATOR_NOTBETWEEN = 'notBetween'

Properties

$conditionType

$conditionType : string

Condition type.

Type

string

$operatorType

$operatorType : string

Operator type.

Type

string

$text

$text : string

Text.

Type

string

$stopIfTrue

$stopIfTrue : bool

Stop on this condition, if it matches.

Type

bool

$condition

$condition : string[]

Condition.

Type

string[]

$dataBar

$dataBar : \PhpOffice\PhpSpreadsheet\Style\ConditionalFormatting\ConditionalDataBar

Type

ConditionalDataBar

$style

$style : \PhpOffice\PhpSpreadsheet\Style\Style

Style.

Type

Style

Methods

__construct()

__construct() : mixed

Create a new Conditional.

Returns

mixed —

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() : bool

Get StopIfTrue.

Returns

bool —

setStopIfTrue()

setStopIfTrue(bool  $value) : $this

Set StopIfTrue.

Parameters

bool $value

Returns

$this —

getConditions()

getConditions() : string[]

Get Conditions.

Returns

string[] —

setConditions()

setConditions(bool|float|int|string|string[]  $pValue) : $this

Set Conditions.

Parameters

bool|float|int|string|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 —

getDataBar()

getDataBar() : \PhpOffice\PhpSpreadsheet\Style\ConditionalFormatting\ConditionalDataBar

get DataBar.

Returns

\PhpOffice\PhpSpreadsheet\Style\ConditionalFormatting\ConditionalDataBar —

| null

setDataBar()

setDataBar(\PhpOffice\PhpSpreadsheet\Style\ConditionalFormatting\ConditionalDataBar  $dataBar) : $this

set DataBar.

Parameters

\PhpOffice\PhpSpreadsheet\Style\ConditionalFormatting\ConditionalDataBar $dataBar

Returns

$this —

getHashCode()

getHashCode() : string

Get hash code.

Returns

string —

Hash code

__clone()

__clone() : mixed

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

Returns

mixed —