locked = self::PROTECTION_INHERIT; $this->hidden = self::PROTECTION_INHERIT; } } /** * Get the shared style component for the currently active cell in currently active sheet. * Only used for style supervisor. * * @return Protection */ public function getSharedComponent() { return $this->parent->getSharedComponent()->getProtection(); } /** * Build style array from subcomponents. * * @param array $array * * @return array */ public function getStyleArray($array) { return ['protection' => $array]; } /** * Apply styles from array. * * * $spreadsheet->getActiveSheet()->getStyle('B2')->getLocked()->applyFromArray( * array( * 'locked' => TRUE, * 'hidden' => FALSE * ) * ); * * * @param array $pStyles Array containing style information * * @throws \PhpOffice\PhpSpreadsheet\Exception * * @return Protection */ public function applyFromArray($pStyles = null) { if (is_array($pStyles)) { if ($this->isSupervisor) { $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($this->getStyleArray($pStyles)); } else { if (isset($pStyles['locked'])) { $this->setLocked($pStyles['locked']); } if (isset($pStyles['hidden'])) { $this->setHidden($pStyles['hidden']); } } } else { throw new \PhpOffice\PhpSpreadsheet\Exception('Invalid style array passed.'); } return $this; } /** * Get locked. * * @return string */ public function getLocked() { if ($this->isSupervisor) { return $this->getSharedComponent()->getLocked(); } return $this->locked; } /** * Set locked. * * @param string $pValue * * @return Protection */ public function setLocked($pValue = self::PROTECTION_INHERIT) { if ($this->isSupervisor) { $styleArray = $this->getStyleArray(['locked' => $pValue]); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->locked = $pValue; } return $this; } /** * Get hidden. * * @return string */ public function getHidden() { if ($this->isSupervisor) { return $this->getSharedComponent()->getHidden(); } return $this->hidden; } /** * Set hidden. * * @param string $pValue * * @return Protection */ public function setHidden($pValue = self::PROTECTION_INHERIT) { if ($this->isSupervisor) { $styleArray = $this->getStyleArray(['hidden' => $pValue]); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->hidden = $pValue; } return $this; } /** * Get hash code. * * @return string Hash code */ public function getHashCode() { if ($this->isSupervisor) { return $this->getSharedComponent()->getHashCode(); } return md5( $this->locked . $this->hidden . __CLASS__ ); } }