Documentation

Font

in package

• Application

Table of Contents

Constants

ARIAL  = 'arial.ttf'

Font filenames

ARIAL_BOLD  = 'arialbd.ttf'

ARIAL_BOLD_ITALIC  = 'arialbi.ttf'

ARIAL_ITALIC  = 'ariali.ttf'

AUTOSIZE_METHOD_APPROX  = 'approx'

AUTOSIZE_METHOD_EXACT  = 'exact'

CALIBRI  = 'calibri.ttf'

CALIBRI_BOLD  = 'calibrib.ttf'

CALIBRI_BOLD_ITALIC  = 'calibriz.ttf'

CALIBRI_ITALIC  = 'calibrii.ttf'

CHARSET_ANSI_ARABIC  = 0xb2

CHARSET_ANSI_BALTIC  = 0xba

CHARSET_ANSI_CHINESE_SIMIPLIFIED  = 0x86

CHARSET_ANSI_CHINESE_TRADITIONAL  = 0x88

CHARSET_ANSI_CYRILLIC  = 0xcc

CHARSET_ANSI_GREEK  = 0xa1

CHARSET_ANSI_HEBREW  = 0xb1

CHARSET_ANSI_JAPANESE_SHIFTJIS  = 0x80

CHARSET_ANSI_KOREAN_HANGUL  = 0x81

CHARSET_ANSI_KOREAN_JOHAB  = 0x82

CHARSET_ANSI_LATIN  = 0x0

Character set codes used by BIFF5-8 in Font records

CHARSET_ANSI_LATIN_II  = 0xee

CHARSET_ANSI_THAI  = 0xdd

CHARSET_ANSI_TURKISH  = 0xa2

CHARSET_ANSI_VIETNAMESE  = 0xa3

CHARSET_APPLE_ROMAN  = 0x4d

CHARSET_FROM_FONT_NAME  = ['EucrosiaUPC' => self::CHARSET_ANSI_THAI, 'Wingdings' => self::CHARSET_SYMBOL, 'Wingdings 2' => self::CHARSET_SYMBOL, 'Wingdings 3' => self::CHARSET_SYMBOL]

CHARSET_OEM_LATIN_I  = 0xff

CHARSET_SYMBOL  = 0x2

CHARSET_SYSTEM_DEFAULT  = 0x1

COMIC_SANS_MS  = 'comic.ttf'

COMIC_SANS_MS_BOLD  = 'comicbd.ttf'

COURIER_NEW  = 'cour.ttf'

COURIER_NEW_BOLD  = 'courbd.ttf'

COURIER_NEW_BOLD_ITALIC  = 'courbi.ttf'

COURIER_NEW_ITALIC  = 'couri.ttf'

DEFAULT_COLUMN_WIDTHS  = ['Arial' => [1 => ['px' => 24, 'width' => 12.0, 'height' => 5.25], 2 => ['px' => 24, 'width' => 12.0, 'height' => 5.25], 3 => ['px' => 32, 'width' => 10.6640625, 'height' => 6.0], 4 => ['px' => 32, 'width' => 10.6640625, 'height' => 6.75], 5 => ['px' => 40, 'width' => 10.0, 'height' => 8.25], 6 => ['px' => 48, 'width' => 9.59765625, 'height' => 8.25], 7 => ['px' => 48, 'width' => 9.59765625, 'height' => 9.0], 8 => ['px' => 56, 'width' => 9.33203125, 'height' => 11.25], 9 => ['px' => 64, 'width' => 9.140625, 'height' => 12.0], 10 => ['px' => 64, 'width' => 9.140625, 'height' => 12.75]], 'Calibri' => [1 => ['px' => 24, 'width' => 12.0, 'height' => 5.25], 2 => ['px' => 24, 'width' => 12.0, 'height' => 5.25], 3 => ['px' => 32, 'width' => 10.6640625, 'height' => 6.0], 4 => ['px' => 32, 'width' => 10.6640625, 'height' => 6.75], 5 => ['px' => 40, 'width' => 10.0, 'height' => 8.25], 6 => ['px' => 48, 'width' => 9.59765625, 'height' => 8.25], 7 => ['px' => 48, 'width' => 9.59765625, 'height' => 9.0], 8 => ['px' => 56, 'width' => 9.33203125, 'height' => 11.25], 9 => ['px' => 56, 'width' => 9.33203125, 'height' => 12.0], 10 => ['px' => 64, 'width' => 9.140625, 'height' => 12.75], 11 => ['px' => 64, 'width' => 9.140625, 'height' => 15.0]], 'Verdana' => [1 => ['px' => 24, 'width' => 12.0, 'height' => 5.25], 2 => ['px' => 24, 'width' => 12.0, 'height' => 5.25], 3 => ['px' => 32, 'width' => 10.6640625, 'height' => 6.0], 4 => ['px' => 32, 'width' => 10.6640625, 'height' => 6.75], 5 => ['px' => 40, 'width' => 10.0, 'height' => 8.25], 6 => ['px' => 48, 'width' => 9.59765625, 'height' => 8.25], 7 => ['px' => 48, 'width' => 9.59765625, 'height' => 9.0], 8 => ['px' => 64, 'width' => 9.140625, 'height' => 10.5], 9 => ['px' => 72, 'width' => 9.0, 'height' => 11.25], 10 => ['px' => 72, 'width' => 9.0, 'height' => 12.75]]]

How wide is a default column for a given default font and size? Empirical data found by inspecting real Excel files and reading off the pixel width in Microsoft Office Excel 2007.

FONT_FILE_NAMES  = ['Arial' => ['x' => self::ARIAL, 'xb' => self::ARIAL_BOLD, 'xi' => self::ARIAL_ITALIC, 'xbi' => self::ARIAL_BOLD_ITALIC], 'Calibri' => ['x' => self::CALIBRI, 'xb' => self::CALIBRI_BOLD, 'xi' => self::CALIBRI_ITALIC, 'xbi' => self::CALIBRI_BOLD_ITALIC], 'Comic Sans MS' => ['x' => self::COMIC_SANS_MS, 'xb' => self::COMIC_SANS_MS_BOLD, 'xi' => self::COMIC_SANS_MS, 'xbi' => self::COMIC_SANS_MS_BOLD], 'Courier New' => ['x' => self::COURIER_NEW, 'xb' => self::COURIER_NEW_BOLD, 'xi' => self::COURIER_NEW_ITALIC, 'xbi' => self::COURIER_NEW_BOLD_ITALIC], 'Georgia' => ['x' => self::GEORGIA, 'xb' => self::GEORGIA_BOLD, 'xi' => self::GEORGIA_ITALIC, 'xbi' => self::GEORGIA_BOLD_ITALIC], 'Impact' => ['x' => self::IMPACT, 'xb' => self::IMPACT, 'xi' => self::IMPACT, 'xbi' => self::IMPACT], 'Liberation Sans' => ['x' => self::LIBERATION_SANS, 'xb' => self::LIBERATION_SANS_BOLD, 'xi' => self::LIBERATION_SANS_ITALIC, 'xbi' => self::LIBERATION_SANS_BOLD_ITALIC], 'Lucida Console' => ['x' => self::LUCIDA_CONSOLE, 'xb' => self::LUCIDA_CONSOLE, 'xi' => self::LUCIDA_CONSOLE, 'xbi' => self::LUCIDA_CONSOLE], 'Lucida Sans Unicode' => ['x' => self::LUCIDA_SANS_UNICODE, 'xb' => self::LUCIDA_SANS_UNICODE, 'xi' => self::LUCIDA_SANS_UNICODE, 'xbi' => self::LUCIDA_SANS_UNICODE], 'Microsoft Sans Serif' => ['x' => self::MICROSOFT_SANS_SERIF, 'xb' => self::MICROSOFT_SANS_SERIF, 'xi' => self::MICROSOFT_SANS_SERIF, 'xbi' => self::MICROSOFT_SANS_SERIF], 'Palatino Linotype' => ['x' => self::PALATINO_LINOTYPE, 'xb' => self::PALATINO_LINOTYPE_BOLD, 'xi' => self::PALATINO_LINOTYPE_ITALIC, 'xbi' => self::PALATINO_LINOTYPE_BOLD_ITALIC], 'Symbol' => ['x' => self::SYMBOL, 'xb' => self::SYMBOL, 'xi' => self::SYMBOL, 'xbi' => self::SYMBOL], 'Tahoma' => ['x' => self::TAHOMA, 'xb' => self::TAHOMA_BOLD, 'xi' => self::TAHOMA, 'xbi' => self::TAHOMA_BOLD], 'Times New Roman' => ['x' => self::TIMES_NEW_ROMAN, 'xb' => self::TIMES_NEW_ROMAN_BOLD, 'xi' => self::TIMES_NEW_ROMAN_ITALIC, 'xbi' => self::TIMES_NEW_ROMAN_BOLD_ITALIC], 'Trebuchet MS' => ['x' => self::TREBUCHET_MS, 'xb' => self::TREBUCHET_MS_BOLD, 'xi' => self::TREBUCHET_MS_ITALIC, 'xbi' => self::TREBUCHET_MS_BOLD_ITALIC], 'Verdana' => ['x' => self::VERDANA, 'xb' => self::VERDANA_BOLD, 'xi' => self::VERDANA_ITALIC, 'xbi' => self::VERDANA_BOLD_ITALIC]]

GEORGIA  = 'georgia.ttf'

GEORGIA_BOLD  = 'georgiab.ttf'

GEORGIA_BOLD_ITALIC  = 'georgiaz.ttf'

GEORGIA_ITALIC  = 'georgiai.ttf'

IMPACT  = 'impact.ttf'

LIBERATION_SANS  = 'LiberationSans-Regular.ttf'

LIBERATION_SANS_BOLD  = 'LiberationSans-Bold.ttf'

LIBERATION_SANS_BOLD_ITALIC  = 'LiberationSans-BoldItalic.ttf'

LIBERATION_SANS_ITALIC  = 'LiberationSans-Italic.ttf'

LUCIDA_CONSOLE  = 'lucon.ttf'

LUCIDA_SANS_UNICODE  = 'l_10646.ttf'

MICROSOFT_SANS_SERIF  = 'micross.ttf'

PALATINO_LINOTYPE  = 'pala.ttf'

PALATINO_LINOTYPE_BOLD  = 'palab.ttf'

PALATINO_LINOTYPE_BOLD_ITALIC  = 'palabi.ttf'

PALATINO_LINOTYPE_ITALIC  = 'palai.ttf'

SYMBOL  = 'symbol.ttf'

TAHOMA  = 'tahoma.ttf'

TAHOMA_BOLD  = 'tahomabd.ttf'

TIMES_NEW_ROMAN  = 'times.ttf'

TIMES_NEW_ROMAN_BOLD  = 'timesbd.ttf'

TIMES_NEW_ROMAN_BOLD_ITALIC  = 'timesbi.ttf'

TIMES_NEW_ROMAN_ITALIC  = 'timesi.ttf'

TREBUCHET_MS  = 'trebuc.ttf'

TREBUCHET_MS_BOLD  = 'trebucbd.ttf'

TREBUCHET_MS_BOLD_ITALIC  = 'trebucbi.ttf'

TREBUCHET_MS_ITALIC  = 'trebucit.ttf'

VERDANA  = 'verdana.ttf'

VERDANA_BOLD  = 'verdanab.ttf'

VERDANA_BOLD_ITALIC  = 'verdanaz.ttf'

VERDANA_ITALIC  = 'verdanai.ttf'

AUTOSIZE_METHODS  = [self::AUTOSIZE_METHOD_APPROX, self::AUTOSIZE_METHOD_EXACT]

Properties

$autoSizeMethod  : string

AutoSize method.

$extraFontArray  : array<string, array<string, string>>

Array that can be used to supplement FONT_FILE_NAMES for calculating exact width.

$paddingAmountExact  : null|float|int

Pad amount for exact in pixels; use best guess if null.

$trueTypeFontPath  : string

Path to folder containing TrueType font .ttf files.

Methods

calculateColumnWidth()  : float

Calculate an (approximate) OpenXML column width, based on font size and text contained.

centimeterSizeToPixels()  : float

Calculate an (approximate) pixel size, based on centimeter size.

fontSizeToPixels()  : int

Calculate an (approximate) pixel size, based on a font points size.

getAutoSizeMethod()  : string

Get autoSize method.

getCharsetFromFontName()  : int

Returns the associated charset for the font name.

getDefaultColumnWidthByFont()  : mixed

Get the effective column width for columns without a column dimension or column with width -1 For example, for Calibri 11 this is 9.140625 (64 px).

getDefaultRowHeightByFont()  : float

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.

getExtraFontArray()  : array<string, array<string, string>>

getPaddingAmountExact()  : null|float|int

Get pad amount for exact in pixels; or null if using best guess.

getTextWidthPixelsApprox()  : int

Get approximate width in pixels for a string of text in a certain font at a certain rotation angle.

getTextWidthPixelsExact()  : float

Get GD text width in pixels for a string of text in a certain font at a certain rotation angle.

getTrueTypeFontFileFromFont()  : string

Returns the font path given the font.

getTrueTypeFontPath()  : string

Get the path to the folder containing .ttf files.

inchSizeToPixels()  : float|int

Calculate an (approximate) pixel size, based on inch size.

setAutoSizeMethod()  : bool

Set autoSize method.

setExtraFontArray()  : void

setPaddingAmountExact()  : void

Set pad amount for exact in pixels; use best guess if null.

setTrueTypeFontPath()  : void

Set the path to the folder containing .ttf files. There should be a trailing slash.

findFontFile()  : string|null