name = null; $this->size = null; $this->bold = null; $this->italic = null; $this->superScript = null; $this->subScript = null; $this->underline = null; $this->strikethrough = null; $this->color = new Color(Color::COLOR_BLACK, $isSupervisor, $isConditional); } else { $this->color = new Color(Color::COLOR_BLACK, $isSupervisor); } // bind parent if we are a supervisor if ($isSupervisor) { $this->color->bindParent($this, 'color'); } } /** * Get the shared style component for the currently active cell in currently active sheet. * Only used for style supervisor. * * @return Font */ public function getSharedComponent() { return $this->parent->getSharedComponent()->getFont(); } /** * Build style array from subcomponents. * * @param array $array * * @return array */ public function getStyleArray($array) { return ['font' => $array]; } /** * Apply styles from array. * * * $spreadsheet->getActiveSheet()->getStyle('B2')->getFont()->applyFromArray( * array( * 'name' => 'Arial', * 'bold' => TRUE, * 'italic' => FALSE, * 'underline' => \PhpOffice\PhpSpreadsheet\Style\Font::UNDERLINE_DOUBLE, * 'strike' => FALSE, * 'color' => array( * 'rgb' => '808080' * ) * ) * ); * * * @param array $pStyles Array containing style information * * @throws \PhpOffice\PhpSpreadsheet\Exception * * @return Font */ 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['name'])) { $this->setName($pStyles['name']); } if (isset($pStyles['bold'])) { $this->setBold($pStyles['bold']); } if (isset($pStyles['italic'])) { $this->setItalic($pStyles['italic']); } if (isset($pStyles['superScript'])) { $this->setSuperScript($pStyles['superScript']); } if (isset($pStyles['subScript'])) { $this->setSubScript($pStyles['subScript']); } if (isset($pStyles['underline'])) { $this->setUnderline($pStyles['underline']); } if (isset($pStyles['strike'])) { $this->setStrikethrough($pStyles['strike']); } if (isset($pStyles['color'])) { $this->getColor()->applyFromArray($pStyles['color']); } if (isset($pStyles['size'])) { $this->setSize($pStyles['size']); } } } else { throw new \PhpOffice\PhpSpreadsheet\Exception('Invalid style array passed.'); } return $this; } /** * Get Name. * * @return string */ public function getName() { if ($this->isSupervisor) { return $this->getSharedComponent()->getName(); } return $this->name; } /** * Set Name. * * @param string $pValue * * @return Font */ public function setName($pValue = 'Calibri') { if ($pValue == '') { $pValue = 'Calibri'; } if ($this->isSupervisor) { $styleArray = $this->getStyleArray(['name' => $pValue]); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->name = $pValue; } return $this; } /** * Get Size. * * @return float */ public function getSize() { if ($this->isSupervisor) { return $this->getSharedComponent()->getSize(); } return $this->size; } /** * Set Size. * * @param float $pValue * * @return Font */ public function setSize($pValue = 10) { if ($pValue == '') { $pValue = 10; } if ($this->isSupervisor) { $styleArray = $this->getStyleArray(['size' => $pValue]); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->size = $pValue; } return $this; } /** * Get Bold. * * @return bool */ public function getBold() { if ($this->isSupervisor) { return $this->getSharedComponent()->getBold(); } return $this->bold; } /** * Set Bold. * * @param bool $pValue * * @return Font */ public function setBold($pValue = false) { if ($pValue == '') { $pValue = false; } if ($this->isSupervisor) { $styleArray = $this->getStyleArray(['bold' => $pValue]); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->bold = $pValue; } return $this; } /** * Get Italic. * * @return bool */ public function getItalic() { if ($this->isSupervisor) { return $this->getSharedComponent()->getItalic(); } return $this->italic; } /** * Set Italic. * * @param bool $pValue * * @return Font */ public function setItalic($pValue = false) { if ($pValue == '') { $pValue = false; } if ($this->isSupervisor) { $styleArray = $this->getStyleArray(['italic' => $pValue]); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->italic = $pValue; } return $this; } /** * Get SuperScript. * * @return bool */ public function getSuperScript() { if ($this->isSupervisor) { return $this->getSharedComponent()->getSuperScript(); } return $this->superScript; } /** * Set SuperScript. * * @param bool $pValue * * @return Font */ public function setSuperScript($pValue = false) { if ($pValue == '') { $pValue = false; } if ($this->isSupervisor) { $styleArray = $this->getStyleArray(['superScript' => $pValue]); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->superScript = $pValue; $this->subScript = !$pValue; } return $this; } /** * Get SubScript. * * @return bool */ public function getSubScript() { if ($this->isSupervisor) { return $this->getSharedComponent()->getSubScript(); } return $this->subScript; } /** * Set SubScript. * * @param bool $pValue * * @return Font */ public function setSubScript($pValue = false) { if ($pValue == '') { $pValue = false; } if ($this->isSupervisor) { $styleArray = $this->getStyleArray(['subScript' => $pValue]); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->subScript = $pValue; $this->superScript = !$pValue; } return $this; } /** * Get Underline. * * @return string */ public function getUnderline() { if ($this->isSupervisor) { return $this->getSharedComponent()->getUnderline(); } return $this->underline; } /** * Set Underline. * * @param string|bool $pValue \PhpOffice\PhpSpreadsheet\Style\Font underline type * If a boolean is passed, then TRUE equates to UNDERLINE_SINGLE, * false equates to UNDERLINE_NONE * * @return Font */ public function setUnderline($pValue = self::UNDERLINE_NONE) { if (is_bool($pValue)) { $pValue = ($pValue) ? self::UNDERLINE_SINGLE : self::UNDERLINE_NONE; } elseif ($pValue == '') { $pValue = self::UNDERLINE_NONE; } if ($this->isSupervisor) { $styleArray = $this->getStyleArray(['underline' => $pValue]); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->underline = $pValue; } return $this; } /** * Get Strikethrough. * * @return bool */ public function getStrikethrough() { if ($this->isSupervisor) { return $this->getSharedComponent()->getStrikethrough(); } return $this->strikethrough; } /** * Set Strikethrough. * * @param bool $pValue * * @return Font */ public function setStrikethrough($pValue = false) { if ($pValue == '') { $pValue = false; } if ($this->isSupervisor) { $styleArray = $this->getStyleArray(['strike' => $pValue]); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->strikethrough = $pValue; } return $this; } /** * Get Color. * * @return Color */ public function getColor() { return $this->color; } /** * Set Color. * * @param Color $pValue * * @throws \PhpOffice\PhpSpreadsheet\Exception * * @return Font */ public function setColor(Color $pValue = null) { // make sure parameter is a real color and not a supervisor $color = $pValue->getIsSupervisor() ? $pValue->getSharedComponent() : $pValue; if ($this->isSupervisor) { $styleArray = $this->getColor()->getStyleArray(['argb' => $color->getARGB()]); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->color = $color; } return $this; } /** * Get hash code. * * @return string Hash code */ public function getHashCode() { if ($this->isSupervisor) { return $this->getSharedComponent()->getHashCode(); } return md5( $this->name . $this->size . ($this->bold ? 't' : 'f') . ($this->italic ? 't' : 'f') . ($this->superScript ? 't' : 'f') . ($this->subScript ? 't' : 'f') . $this->underline . ($this->strikethrough ? 't' : 'f') . $this->color->getHashCode() . __CLASS__ ); } }