PROTECTION_INHERIT
PROTECTION_INHERIT = 'inherit'
Protection styles
$parent : \PhpOffice\PhpSpreadsheet\Spreadsheet|\PhpOffice\PhpSpreadsheet\Style\Style
Parent. Only used for supervisor.
__construct(boolean $isSupervisor = false, boolean $isConditional = false)
Create a new Protection.
| 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\Protection
Get the shared style component for the currently active cell in currently active sheet.
Only used for style supervisor.
applyFromArray(array $pStyles) : \PhpOffice\PhpSpreadsheet\Style\Protection
Apply styles from array.
$spreadsheet->getActiveSheet()->getStyle('B2')->getLocked()->applyFromArray(
[
'locked' => TRUE,
'hidden' => FALSE
]
);
| array | $pStyles | Array containing style information |
setLocked(string $pValue) : \PhpOffice\PhpSpreadsheet\Style\Protection
Set locked.
| string | $pValue | see self::PROTECTION_* |
setHidden(string $pValue) : \PhpOffice\PhpSpreadsheet\Style\Protection
Set hidden.
| string | $pValue | see self::PROTECTION_* |
Loading…