$isSupervisor
$isSupervisor : boolean
Supervisor?
$parent : \PhpOffice\PhpSpreadsheet\Spreadsheet|\PhpOffice\PhpSpreadsheet\Style\Style
Parent. Only used for supervisor.
$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 : array<mixed,\PhpOffice\PhpSpreadsheet\Style\Conditional>
Conditional styles.
$protection : \PhpOffice\PhpSpreadsheet\Style\Protection
Protection.
__construct(boolean $isSupervisor = false, boolean $isConditional = false)
Create a new Style.
boolean | $isSupervisor | Flag indicating if this is a supervisor or not Leave this value at default unless you understand exactly what its ramifications are |
boolean | $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 |
getActiveSheet() : \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet
Get the currently active sheet. Only used for supervisor.
getSharedComponent() : \PhpOffice\PhpSpreadsheet\Style\Style
Get the shared style component for the currently active cell in currently active sheet.
Only used for style supervisor.
getParent() : \PhpOffice\PhpSpreadsheet\Spreadsheet
Get parent. Only used for style supervisor.
applyFromArray(array $pStyles, boolean $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'
]
]
],
'quotePrefix' => true
]
);
array | $pStyles | Array containing style information |
boolean | $pAdvanced | advanced mode for setting borders |
getFill() : \PhpOffice\PhpSpreadsheet\Style\Fill
Get Fill.
getFont() : \PhpOffice\PhpSpreadsheet\Style\Font
Get Font.
setFont(\PhpOffice\PhpSpreadsheet\Style\Font $font) : \PhpOffice\PhpSpreadsheet\Style\Style
Set font.
\PhpOffice\PhpSpreadsheet\Style\Font | $font |
getBorders() : \PhpOffice\PhpSpreadsheet\Style\Borders
Get Borders.
getAlignment() : \PhpOffice\PhpSpreadsheet\Style\Alignment
Get Alignment.
getNumberFormat() : \PhpOffice\PhpSpreadsheet\Style\NumberFormat
Get Number Format.
getConditionalStyles() : array<mixed,\PhpOffice\PhpSpreadsheet\Style\Conditional>
Get Conditional Styles. Only used on supervisor.
setConditionalStyles(array<mixed,\PhpOffice\PhpSpreadsheet\Style\Conditional> $pValue) : \PhpOffice\PhpSpreadsheet\Style\Style
Set Conditional Styles. Only used on supervisor.
array<mixed,\PhpOffice\PhpSpreadsheet\Style\Conditional> | $pValue | Array of conditional styles |
getProtection() : \PhpOffice\PhpSpreadsheet\Style\Protection
Get Protection.
setQuotePrefix(boolean $pValue) : \PhpOffice\PhpSpreadsheet\Style\Style
Set quote prefix.
boolean | $pValue |