$isSupervisor
$isSupervisor : bool
Supervisor?
$isSupervisor : bool
Supervisor?
$parent : \PhpOffice\PhpSpreadsheet\Spreadsheet|\PhpOffice\PhpSpreadsheet\Style\Style
Parent. Only used for supervisor.
$parentPropertyName : null|string
Parent property name.
$font : \PhpOffice\PhpSpreadsheet\Style\Font
Font.
$fill : \PhpOffice\PhpSpreadsheet\Style\Fill
Fill.
$borders : \PhpOffice\PhpSpreadsheet\Style\Borders
Borders.
$alignment : \PhpOffice\PhpSpreadsheet\Style\Alignment
Alignment.
$numberFormat : \PhpOffice\PhpSpreadsheet\Style\NumberFormat
Number Format.
$conditionalStyles : \PhpOffice\PhpSpreadsheet\Style\Conditional[]
Conditional styles.
$protection : \PhpOffice\PhpSpreadsheet\Style\Protection
Protection.
$index : int
Index of style in collection. Only used for real style.
$quotePrefix : bool
Use Quote Prefix when displaying in cell editor. Only used for real style.
__construct(bool $isSupervisor = false, bool $isConditional = false) : mixed
Create a new Style.
| bool | $isSupervisor | Flag indicating if this is a supervisor or not Leave this value at default unless you understand exactly what its ramifications are |
| bool | $isConditional | Flag indicating if this is a conditional style or not Leave this value at default unless you understand exactly what its ramifications are |
bindParent(\PhpOffice\PhpSpreadsheet\Spreadsheet|\PhpOffice\PhpSpreadsheet\Style\Style $parent, null|string $parentPropertyName = null) : \PhpOffice\PhpSpreadsheet\Style\Supervisor
Bind parent. Only used for supervisor.
| \PhpOffice\PhpSpreadsheet\Spreadsheet|\PhpOffice\PhpSpreadsheet\Style\Style | $parent | |
| null|string | $parentPropertyName |
applyFromArray(array $pStyles, bool $pAdvanced = true) : \PhpOffice\PhpSpreadsheet\Style\Style
Apply styles from array.
$spreadsheet->getActiveSheet()->getStyle('B2')->applyFromArray(
[
'font' => [
'name' => 'Arial',
'bold' => true,
'italic' => false,
'underline' => Font::UNDERLINE_DOUBLE,
'strikethrough' => false,
'color' => [
'rgb' => '808080'
]
],
'borders' => [
'bottom' => [
'borderStyle' => Border::BORDER_DASHDOT,
'color' => [
'rgb' => '808080'
]
],
'top' => [
'borderStyle' => Border::BORDER_DASHDOT,
'color' => [
'rgb' => '808080'
]
]
],
'alignment' => [
'horizontal' => Alignment::HORIZONTAL_CENTER,
'vertical' => Alignment::VERTICAL_CENTER,
'wrapText' => true,
],
'quotePrefix' => true
]
);
| array | $pStyles | Array containing style information |
| bool | $pAdvanced | advanced mode for setting borders |
setConditionalStyles(\PhpOffice\PhpSpreadsheet\Style\Conditional[] $pValue) : \PhpOffice\PhpSpreadsheet\Style\Style
Set Conditional Styles. Only used on supervisor.
| \PhpOffice\PhpSpreadsheet\Style\Conditional[] | $pValue | Array of conditional styles |