horizontal = null; $this->vertical = null; $this->textRotation = null; } } /** * Get the shared style component for the currently active cell in currently active sheet. * Only used for style supervisor. * * @return Alignment */ public function getSharedComponent() { return $this->parent->getSharedComponent()->getAlignment(); } /** * Build style array from subcomponents. * * @param array $array * * @return array */ public function getStyleArray($array) { return ['alignment' => $array]; } /** * Apply styles from array. * * * $spreadsheet->getActiveSheet()->getStyle('B2')->getAlignment()->applyFromArray( * array( * 'horizontal' => \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER, * 'vertical' => \PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER, * 'rotation' => 0, * 'wrap' => TRUE * ) * ); * * * @param array $pStyles Array containing style information * * @throws \PhpOffice\PhpSpreadsheet\Exception * * @return Alignment */ 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['horizontal'])) { $this->setHorizontal($pStyles['horizontal']); } if (isset($pStyles['vertical'])) { $this->setVertical($pStyles['vertical']); } if (isset($pStyles['rotation'])) { $this->setTextRotation($pStyles['rotation']); } if (isset($pStyles['wrap'])) { $this->setWrapText($pStyles['wrap']); } if (isset($pStyles['shrinkToFit'])) { $this->setShrinkToFit($pStyles['shrinkToFit']); } if (isset($pStyles['indent'])) { $this->setIndent($pStyles['indent']); } if (isset($pStyles['readorder'])) { $this->setReadorder($pStyles['readorder']); } } } else { throw new \PhpOffice\PhpSpreadsheet\Exception('Invalid style array passed.'); } return $this; } /** * Get Horizontal. * * @return string */ public function getHorizontal() { if ($this->isSupervisor) { return $this->getSharedComponent()->getHorizontal(); } return $this->horizontal; } /** * Set Horizontal. * * @param string $pValue * * @return Alignment */ public function setHorizontal($pValue = self::HORIZONTAL_GENERAL) { if ($pValue == '') { $pValue = self::HORIZONTAL_GENERAL; } if ($this->isSupervisor) { $styleArray = $this->getStyleArray(['horizontal' => $pValue]); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->horizontal = $pValue; } return $this; } /** * Get Vertical. * * @return string */ public function getVertical() { if ($this->isSupervisor) { return $this->getSharedComponent()->getVertical(); } return $this->vertical; } /** * Set Vertical. * * @param string $pValue * * @return Alignment */ public function setVertical($pValue = self::VERTICAL_BOTTOM) { if ($pValue == '') { $pValue = self::VERTICAL_BOTTOM; } if ($this->isSupervisor) { $styleArray = $this->getStyleArray(['vertical' => $pValue]); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->vertical = $pValue; } return $this; } /** * Get TextRotation. * * @return int */ public function getTextRotation() { if ($this->isSupervisor) { return $this->getSharedComponent()->getTextRotation(); } return $this->textRotation; } /** * Set TextRotation. * * @param int $pValue * * @throws \PhpOffice\PhpSpreadsheet\Exception * * @return Alignment */ public function setTextRotation($pValue = 0) { // Excel2007 value 255 => PhpSpreadsheet value -165 if ($pValue == 255) { $pValue = -165; } // Set rotation if (($pValue >= -90 && $pValue <= 90) || $pValue == -165) { if ($this->isSupervisor) { $styleArray = $this->getStyleArray(['rotation' => $pValue]); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->textRotation = $pValue; } } else { throw new \PhpOffice\PhpSpreadsheet\Exception('Text rotation should be a value between -90 and 90.'); } return $this; } /** * Get Wrap Text. * * @return bool */ public function getWrapText() { if ($this->isSupervisor) { return $this->getSharedComponent()->getWrapText(); } return $this->wrapText; } /** * Set Wrap Text. * * @param bool $pValue * * @return Alignment */ public function setWrapText($pValue = false) { if ($pValue == '') { $pValue = false; } if ($this->isSupervisor) { $styleArray = $this->getStyleArray(['wrap' => $pValue]); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->wrapText = $pValue; } return $this; } /** * Get Shrink to fit. * * @return bool */ public function getShrinkToFit() { if ($this->isSupervisor) { return $this->getSharedComponent()->getShrinkToFit(); } return $this->shrinkToFit; } /** * Set Shrink to fit. * * @param bool $pValue * * @return Alignment */ public function setShrinkToFit($pValue = false) { if ($pValue == '') { $pValue = false; } if ($this->isSupervisor) { $styleArray = $this->getStyleArray(['shrinkToFit' => $pValue]); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->shrinkToFit = $pValue; } return $this; } /** * Get indent. * * @return int */ public function getIndent() { if ($this->isSupervisor) { return $this->getSharedComponent()->getIndent(); } return $this->indent; } /** * Set indent. * * @param int $pValue * * @return Alignment */ public function setIndent($pValue = 0) { if ($pValue > 0) { if ($this->getHorizontal() != self::HORIZONTAL_GENERAL && $this->getHorizontal() != self::HORIZONTAL_LEFT && $this->getHorizontal() != self::HORIZONTAL_RIGHT) { $pValue = 0; // indent not supported } } if ($this->isSupervisor) { $styleArray = $this->getStyleArray(['indent' => $pValue]); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->indent = $pValue; } return $this; } /** * Get read order. * * @return int */ public function getReadorder() { if ($this->isSupervisor) { return $this->getSharedComponent()->getReadorder(); } return $this->readorder; } /** * Set read order. * * @param int $pValue * * @return Alignment */ public function setReadorder($pValue = 0) { if ($pValue < 0 || $pValue > 2) { $pValue = 0; } if ($this->isSupervisor) { $styleArray = $this->getStyleArray(['readorder' => $pValue]); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->readorder = $pValue; } return $this; } /** * Get hash code. * * @return string Hash code */ public function getHashCode() { if ($this->isSupervisor) { return $this->getSharedComponent()->getHashCode(); } return md5( $this->horizontal . $this->vertical . $this->textRotation . ($this->wrapText ? 't' : 'f') . ($this->shrinkToFit ? 't' : 'f') . $this->indent . $this->readorder . __CLASS__ ); } }