| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556 | 
							- <?php
 
- namespace PhpOffice\PhpSpreadsheet\Style;
 
- use PhpOffice\PhpSpreadsheet\Exception as PhpSpreadsheetException;
 
- class Font extends Supervisor
 
- {
 
-     // Underline types
 
-     const UNDERLINE_NONE = 'none';
 
-     const UNDERLINE_DOUBLE = 'double';
 
-     const UNDERLINE_DOUBLEACCOUNTING = 'doubleAccounting';
 
-     const UNDERLINE_SINGLE = 'single';
 
-     const UNDERLINE_SINGLEACCOUNTING = 'singleAccounting';
 
-     /**
 
-      * Font Name.
 
-      *
 
-      * @var string
 
-      */
 
-     protected $name = 'Calibri';
 
-     /**
 
-      * Font Size.
 
-      *
 
-      * @var float
 
-      */
 
-     protected $size = 11;
 
-     /**
 
-      * Bold.
 
-      *
 
-      * @var bool
 
-      */
 
-     protected $bold = false;
 
-     /**
 
-      * Italic.
 
-      *
 
-      * @var bool
 
-      */
 
-     protected $italic = false;
 
-     /**
 
-      * Superscript.
 
-      *
 
-      * @var bool
 
-      */
 
-     protected $superscript = false;
 
-     /**
 
-      * Subscript.
 
-      *
 
-      * @var bool
 
-      */
 
-     protected $subscript = false;
 
-     /**
 
-      * Underline.
 
-      *
 
-      * @var string
 
-      */
 
-     protected $underline = self::UNDERLINE_NONE;
 
-     /**
 
-      * Strikethrough.
 
-      *
 
-      * @var bool
 
-      */
 
-     protected $strikethrough = false;
 
-     /**
 
-      * Foreground color.
 
-      *
 
-      * @var Color
 
-      */
 
-     protected $color;
 
-     /**
 
-      * @var int
 
-      */
 
-     public $colorIndex;
 
-     /**
 
-      * Create a new Font.
 
-      *
 
-      * @param bool $isSupervisor Flag indicating if this is a supervisor or not
 
-      *                                    Leave this value at default unless you understand exactly what
 
-      *                                        its ramifications are
 
-      * @param bool $isConditional Flag indicating if this is a conditional style or not
 
-      *                                    Leave this value at default unless you understand exactly what
 
-      *                                        its ramifications are
 
-      */
 
-     public function __construct($isSupervisor = false, $isConditional = false)
 
-     {
 
-         // Supervisor?
 
-         parent::__construct($isSupervisor);
 
-         // Initialise values
 
-         if ($isConditional) {
 
-             $this->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.
 
-      *
 
-      * <code>
 
-      * $spreadsheet->getActiveSheet()->getStyle('B2')->getFont()->applyFromArray(
 
-      *     [
 
-      *         'name' => 'Arial',
 
-      *         'bold' => TRUE,
 
-      *         'italic' => FALSE,
 
-      *         'underline' => \PhpOffice\PhpSpreadsheet\Style\Font::UNDERLINE_DOUBLE,
 
-      *         'strikethrough' => FALSE,
 
-      *         'color' => [
 
-      *             'rgb' => '808080'
 
-      *         ]
 
-      *     ]
 
-      * );
 
-      * </code>
 
-      *
 
-      * @param array $pStyles Array containing style information
 
-      *
 
-      * @throws PhpSpreadsheetException
 
-      *
 
-      * @return Font
 
-      */
 
-     public function applyFromArray(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['strikethrough'])) {
 
-                 $this->setStrikethrough($pStyles['strikethrough']);
 
-             }
 
-             if (isset($pStyles['color'])) {
 
-                 $this->getColor()->applyFromArray($pStyles['color']);
 
-             }
 
-             if (isset($pStyles['size'])) {
 
-                 $this->setSize($pStyles['size']);
 
-             }
 
-         }
 
-         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)
 
-     {
 
-         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)
 
-     {
 
-         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)
 
-     {
 
-         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)
 
-     {
 
-         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)
 
-     {
 
-         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)
 
-     {
 
-         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 bool|string $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)
 
-     {
 
-         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)
 
-     {
 
-         if ($pValue == '') {
 
-             $pValue = false;
 
-         }
 
-         if ($this->isSupervisor) {
 
-             $styleArray = $this->getStyleArray(['strikethrough' => $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 PhpSpreadsheetException
 
-      *
 
-      * @return Font
 
-      */
 
-     public function setColor(Color $pValue)
 
-     {
 
-         // 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__
 
-         );
 
-     }
 
- }
 
 
  |