Beispiel #1
0
 /**
  * Get font record data
  *
  * @return string
  */
 public function writeFont()
 {
     $font_outline = 0;
     $font_shadow = 0;
     $icv = $this->colorIndex;
     // Index to color palette
     if ($this->font->getSuperScript()) {
         $sss = 1;
     } elseif ($this->font->getSubScript()) {
         $sss = 2;
     } else {
         $sss = 0;
     }
     $bFamily = 0;
     // Font family
     $bCharSet = \PHPExcel\Shared\Font::getCharsetFromFontName($this->font->getName());
     // Character set
     $record = 0x31;
     // Record identifier
     $reserved = 0x0;
     // Reserved
     $grbit = 0x0;
     // Font attributes
     if ($this->font->getItalic()) {
         $grbit |= 0x2;
     }
     if ($this->font->getStrikethrough()) {
         $grbit |= 0x8;
     }
     if ($font_outline) {
         $grbit |= 0x10;
     }
     if ($font_shadow) {
         $grbit |= 0x20;
     }
     $data = pack("vvvvvCCCC", $this->font->getSize() * 20, $grbit, $icv, self::mapBold($this->font->getBold()), $sss, self::mapUnderline($this->font->getUnderline()), $bFamily, $bCharSet, $reserved);
     $data .= \PHPExcel\Shared\StringHelper::UTF8toBIFF8UnicodeShort($this->font->getName());
     $length = strlen($data);
     $header = pack("vv", $record, $length);
     return $header . $data;
 }
Beispiel #2
0
 /**
  * Convert column width from (intrinsic) Excel units to pixels
  *
  * @param   float    $pValue        Value in cell dimension
  * @param   \PHPExcel\Style\Font $pDefaultFont    Default font of the workbook
  * @return  int        Value in pixels
  */
 public static function cellDimensionToPixels($pValue, \PHPExcel\Style\Font $pDefaultFont)
 {
     // Font name and size
     $name = $pDefaultFont->getName();
     $size = $pDefaultFont->getSize();
     if (isset(\PHPExcel\Shared\Font::$defaultColumnWidths[$name][$size])) {
         // Exact width can be determined
         $colWidth = $pValue * \PHPExcel\Shared\Font::$defaultColumnWidths[$name][$size]['px'] / \PHPExcel\Shared\Font::$defaultColumnWidths[$name][$size]['width'];
     } else {
         // We don't have data for this particular font and size, use approximation by
         // extrapolating from Calibri 11
         $colWidth = $pValue * $size * \PHPExcel\Shared\Font::$defaultColumnWidths['Calibri'][11]['px'] / \PHPExcel\Shared\Font::$defaultColumnWidths['Calibri'][11]['width'] / 11;
     }
     // Round pixels to closest integer
     $colWidth = (int) round($colWidth);
     return $colWidth;
 }
Beispiel #3
0
 /**
  * Write Font
  *
  * @param     \PHPExcel\Shared\XMLWriter        $objWriter         XML Writer
  * @param     \PHPExcel\Style\Font                $pFont            Font style
  * @throws     \PHPExcel\Writer\Exception
  */
 private function writeFont(\PHPExcel\Shared\XMLWriter $objWriter = null, \PHPExcel\Style\Font $pFont = null)
 {
     // font
     $objWriter->startElement('font');
     //    Weird! The order of these elements actually makes a difference when opening Excel2007
     //        files in Excel2003 with the compatibility pack. It's not documented behaviour,
     //        and makes for a real WTF!
     // Bold. We explicitly write this element also when false (like MS Office Excel 2007 does
     // for conditional formatting). Otherwise it will apparently not be picked up in conditional
     // formatting style dialog
     if ($pFont->getBold() !== null) {
         $objWriter->startElement('b');
         $objWriter->writeAttribute('val', $pFont->getBold() ? '1' : '0');
         $objWriter->endElement();
     }
     // Italic
     if ($pFont->getItalic() !== null) {
         $objWriter->startElement('i');
         $objWriter->writeAttribute('val', $pFont->getItalic() ? '1' : '0');
         $objWriter->endElement();
     }
     // Strikethrough
     if ($pFont->getStrikethrough() !== null) {
         $objWriter->startElement('strike');
         $objWriter->writeAttribute('val', $pFont->getStrikethrough() ? '1' : '0');
         $objWriter->endElement();
     }
     // Underline
     if ($pFont->getUnderline() !== null) {
         $objWriter->startElement('u');
         $objWriter->writeAttribute('val', $pFont->getUnderline());
         $objWriter->endElement();
     }
     // Superscript / subscript
     if ($pFont->getSuperScript() === true || $pFont->getSubScript() === true) {
         $objWriter->startElement('vertAlign');
         if ($pFont->getSuperScript() === true) {
             $objWriter->writeAttribute('val', 'superscript');
         } elseif ($pFont->getSubScript() === true) {
             $objWriter->writeAttribute('val', 'subscript');
         }
         $objWriter->endElement();
     }
     // Size
     if ($pFont->getSize() !== null) {
         $objWriter->startElement('sz');
         $objWriter->writeAttribute('val', $pFont->getSize());
         $objWriter->endElement();
     }
     // Foreground color
     if ($pFont->getColor()->getARGB() !== null) {
         $objWriter->startElement('color');
         $objWriter->writeAttribute('rgb', $pFont->getColor()->getARGB());
         $objWriter->endElement();
     }
     // Name
     if ($pFont->getName() !== null) {
         $objWriter->startElement('name');
         $objWriter->writeAttribute('val', $pFont->getName());
         $objWriter->endElement();
     }
     $objWriter->endElement();
 }
Beispiel #4
0
 /**
  * Get the effective row height for rows without a row dimension or rows with height -1
  * For example, for Calibri 11 this is 15 points
  *
  * @param \PHPExcel\Style\Font $font The workbooks default font
  * @return float Row height in points
  */
 public static function getDefaultRowHeightByFont(\PHPExcel\Style\Font $font)
 {
     switch ($font->getName()) {
         case 'Arial':
             switch ($font->getSize()) {
                 case 10:
                     // inspection of Arial 10 workbook says 12.75pt ~17px
                     $rowHeight = 12.75;
                     break;
                 case 9:
                     // inspection of Arial 9 workbook says 12.00pt ~16px
                     $rowHeight = 12;
                     break;
                 case 8:
                     // inspection of Arial 8 workbook says 11.25pt ~15px
                     $rowHeight = 11.25;
                     break;
                 case 7:
                     // inspection of Arial 7 workbook says 9.00pt ~12px
                     $rowHeight = 9;
                     break;
                 case 6:
                 case 5:
                     // inspection of Arial 5,6 workbook says 8.25pt ~11px
                     $rowHeight = 8.25;
                     break;
                 case 4:
                     // inspection of Arial 4 workbook says 6.75pt ~9px
                     $rowHeight = 6.75;
                     break;
                 case 3:
                     // inspection of Arial 3 workbook says 6.00pt ~8px
                     $rowHeight = 6;
                     break;
                 case 2:
                 case 1:
                     // inspection of Arial 1,2 workbook says 5.25pt ~7px
                     $rowHeight = 5.25;
                     break;
                 default:
                     // use Arial 10 workbook as an approximation, extrapolation
                     $rowHeight = 12.75 * $font->getSize() / 10;
                     break;
             }
             break;
         case 'Calibri':
             switch ($font->getSize()) {
                 case 11:
                     // inspection of Calibri 11 workbook says 15.00pt ~20px
                     $rowHeight = 15;
                     break;
                 case 10:
                     // inspection of Calibri 10 workbook says 12.75pt ~17px
                     $rowHeight = 12.75;
                     break;
                 case 9:
                     // inspection of Calibri 9 workbook says 12.00pt ~16px
                     $rowHeight = 12;
                     break;
                 case 8:
                     // inspection of Calibri 8 workbook says 11.25pt ~15px
                     $rowHeight = 11.25;
                     break;
                 case 7:
                     // inspection of Calibri 7 workbook says 9.00pt ~12px
                     $rowHeight = 9;
                     break;
                 case 6:
                 case 5:
                     // inspection of Calibri 5,6 workbook says 8.25pt ~11px
                     $rowHeight = 8.25;
                     break;
                 case 4:
                     // inspection of Calibri 4 workbook says 6.75pt ~9px
                     $rowHeight = 6.75;
                     break;
                 case 3:
                     // inspection of Calibri 3 workbook says 6.00pt ~8px
                     $rowHeight = 6.0;
                     break;
                 case 2:
                 case 1:
                     // inspection of Calibri 1,2 workbook says 5.25pt ~7px
                     $rowHeight = 5.25;
                     break;
                 default:
                     // use Calibri 11 workbook as an approximation, extrapolation
                     $rowHeight = 15 * $font->getSize() / 11;
                     break;
             }
             break;
         case 'Verdana':
             switch ($font->getSize()) {
                 case 10:
                     // inspection of Verdana 10 workbook says 12.75pt ~17px
                     $rowHeight = 12.75;
                     break;
                 case 9:
                     // inspection of Verdana 9 workbook says 11.25pt ~15px
                     $rowHeight = 11.25;
                     break;
                 case 8:
                     // inspection of Verdana 8 workbook says 10.50pt ~14px
                     $rowHeight = 10.5;
                     break;
                 case 7:
                     // inspection of Verdana 7 workbook says 9.00pt ~12px
                     $rowHeight = 9.0;
                     break;
                 case 6:
                 case 5:
                     // inspection of Verdana 5,6 workbook says 8.25pt ~11px
                     $rowHeight = 8.25;
                     break;
                 case 4:
                     // inspection of Verdana 4 workbook says 6.75pt ~9px
                     $rowHeight = 6.75;
                     break;
                 case 3:
                     // inspection of Verdana 3 workbook says 6.00pt ~8px
                     $rowHeight = 6;
                     break;
                 case 2:
                 case 1:
                     // inspection of Verdana 1,2 workbook says 5.25pt ~7px
                     $rowHeight = 5.25;
                     break;
                 default:
                     // use Verdana 10 workbook as an approximation, extrapolation
                     $rowHeight = 12.75 * $font->getSize() / 10;
                     break;
             }
             break;
         default:
             // just use Calibri as an approximation
             $rowHeight = 15 * $font->getSize() / 11;
             break;
     }
     return $rowHeight;
 }
Beispiel #5
0
 /**
  * Create CSS style (\PHPExcel\Style\Font)
  *
  * @param    \PHPExcel\Style\Font        $pStyle            \PHPExcel\Style\Font
  * @return    array
  */
 private function createCSSStyleFont(\PHPExcel\Style\Font $pStyle)
 {
     // Construct CSS
     $css = array();
     // Create CSS
     if ($pStyle->getBold()) {
         $css['font-weight'] = 'bold';
     }
     if ($pStyle->getUnderline() != \PHPExcel\Style\Font::UNDERLINE_NONE && $pStyle->getStrikethrough()) {
         $css['text-decoration'] = 'underline line-through';
     } elseif ($pStyle->getUnderline() != \PHPExcel\Style\Font::UNDERLINE_NONE) {
         $css['text-decoration'] = 'underline';
     } elseif ($pStyle->getStrikethrough()) {
         $css['text-decoration'] = 'line-through';
     }
     if ($pStyle->getItalic()) {
         $css['font-style'] = 'italic';
     }
     $css['color'] = '#' . $pStyle->getColor()->getRGB();
     $css['font-family'] = '\'' . $pStyle->getName() . '\'';
     $css['font-size'] = $pStyle->getSize() . 'pt';
     return $css;
 }