Documentation

Blanks extends WizardAbstract implements WizardInterface

Interfaces, Classes and Traits

WizardInterface

Table of Contents

EXPRESSIONS  = [PhpOfficePhpSpreadsheetStyleConditionalFormattingWizard::NOT_BLANKS => 'LEN(TRIM(%s))>0', PhpOfficePhpSpreadsheetStyleConditionalFormattingWizard::BLANKS => 'LEN(TRIM(%s))=0']
OPERATORS  = ['notBlank' => false, 'isBlank' => true, 'notEmpty' => false, 'empty' => true]
$cellRange  : string
$expression  : string
$inverse  : bool
$referenceCell  : string
$referenceColumn  : int
$referenceRow  : int
$stopIfTrue  : bool
$style  : Style|null
__call()  : self
__construct()  : mixed
fromConditional()  : WizardInterface
getCellRange()  : string
getConditional()  : Conditional
getStopIfTrue()  : bool
getStyle()  : Style
isBlank()  :
isEmpty()  :
notBlank()  :
notEmpty()  :
reverseAdjustCellRef()  : string
setCellRange()  : void
setStopIfTrue()  : void
setStyle()  : void
adjustConditionsForCellReferences()  : array<string|int, mixed>
cellConditionCheck()  : string
conditionCellAdjustment()  : string
getExpression()  : void
inverse()  : void
reverseCellAdjustment()  : string
setReferenceCellForExpressions()  : void
validateOperand()  : string

Constants

EXPRESSIONS

protected mixed EXPRESSIONS = [PhpOfficePhpSpreadsheetStyleConditionalFormattingWizard::NOT_BLANKS => 'LEN(TRIM(%s))>0', PhpOfficePhpSpreadsheetStyleConditionalFormattingWizard::BLANKS => 'LEN(TRIM(%s))=0']

OPERATORS

protected mixed OPERATORS = ['notBlank' => false, 'isBlank' => true, 'notEmpty' => false, 'empty' => true]

Properties

$inverse

protected bool $inverse

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[, bool $inverse = false ]) : mixed
Parameters
$cellRange : string
$inverse : bool = false
Return values
mixed —

getCellRange()

public getCellRange() : string
Return values
string —

getStopIfTrue()

public getStopIfTrue() : bool
Return values
bool —

isBlank()

public isBlank() :
Return values
—

isEmpty()

public isEmpty() :
Return values
—

notBlank()

public notBlank() :
Return values
—

notEmpty()

public notEmpty() :
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 —

getExpression()

protected getExpression() : void
Return values
void —

inverse()

protected inverse(bool $inverse) : void
Parameters
$inverse : bool
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 —

validateOperand()

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

Search results