Documentation

DataValidationHelper
in package

Table of Contents

Properties

$errorStyles  : array<int, string>
$operators  : array<int, string>
$types  : array<int, string>

Methods

errorStyle()  : string|null
operator()  : string|null
type()  : string|null

Properties

$errorStyles

private static array<int, string> $errorStyles = [0x0 => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::STYLE_STOP, 0x1 => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::STYLE_WARNING, 0x2 => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::STYLE_INFORMATION]

$operators

private static array<int, string> $operators = [0x0 => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::OPERATOR_BETWEEN, 0x1 => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::OPERATOR_NOTBETWEEN, 0x2 => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::OPERATOR_EQUAL, 0x3 => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::OPERATOR_NOTEQUAL, 0x4 => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::OPERATOR_GREATERTHAN, 0x5 => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::OPERATOR_LESSTHAN, 0x6 => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::OPERATOR_GREATERTHANOREQUAL, 0x7 => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::OPERATOR_LESSTHANOREQUAL]

$types

private static array<int, string> $types = [0x0 => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::TYPE_NONE, 0x1 => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::TYPE_WHOLE, 0x2 => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::TYPE_DECIMAL, 0x3 => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::TYPE_LIST, 0x4 => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::TYPE_DATE, 0x5 => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::TYPE_TIME, 0x6 => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::TYPE_TEXTLENGTH, 0x7 => \PhpOffice\PhpSpreadsheet\Cell\DataValidation::TYPE_CUSTOM]

Methods

errorStyle()

public static errorStyle(int $errorStyle) : string|null
Parameters
$errorStyle : int
Return values
string|null

operator()

public static operator(int $operator) : string|null
Parameters
$operator : int
Return values
string|null

type()

public static type(int $type) : string|null
Parameters
$type : int
Return values
string|null

        
On this page

Search results