tzeg6@T+ f,c>o⌻wRW/ ‹KgMzPny\F7nXoāKJg EB? Cez>^^$/fЁ1. ?c6ir;*{4N;@a-ɉ53j`?<:A0׶,)ՈGsB =- lN i|E2ZyCFaj^{ZK#65 p+](k.70 R~! =\*`밻<{_ߜvun%񂵖 qud,*GꆓXg#$h8_wrQ1EkoQ-'ݲ%/@{'IH>X\ve1mn^=T4ݝo$v27#7ύ֕0pi2ydYxKч_!0= d+ קəG:nz_|2|IK5!f[~+J搭+ڱMPFRX gNq02=!T"w-$B jXJ&AKRqu|[TzF6:ژJȨ9Wr/ݝYve1mn^=T4ݝo$v27#7ύ֕0V=իva ve1mn^=T4ݝo$v27#7ύ֕0&Iа`?MYߊf+>8FP("dDcҹ.r6\vFÎM{l| *Cg^'>otz2;RIV$ŵ"YE=:kUtdHM/^rabHY(27veU5cc\TmUcJ˛;.HՓ9=S>5B;&FbeRHOYN"9bg%u[za{xd!TgaNꂭT&_pes Xh݅9 =`ji>siwCb|AWE/`^"fyM ?q?Ϸ^q#ٟthv^JR !-'HݯM~Ⱥn bH, X: PIt:k됭a?<@hPhѸl` F1 G#a0UibZzrպ$HPM#oqU-*Yk},6l3xbnTpp?QsCamvD `lc7`t6 }ddjw??~߲r[ԧmv}mH"SW1m4"]h:yfeUrT:4@HU~U \t Ie.LFEeAwp`yt;Ưl##nuv&_RWwEsIp"qj/ c#E¿%f#rb|6!$8nn&,`\f8nn&,`\f)|a0j2\J0e'jU6 v߶`>B*!u|ggk͒F￉E1P! vp#ZP݊!(xe>vMG$YytNYp N[TѬy5Bh,i$݈ nLfBm4kp@=ʮ+OEieгĶgg c `\86E0f%a\΅|&c 7<1DeU`4;fROz4@晘' ؿ9׺};ZB pۃu/:q'+yC,YqR8Gzp*ĚZb3{VyL>PW8rоmszwTD8Ȭa>NZFFIpޗOVJ;oB{<^(ˆ [IC=BhPϴ_Y}-zOQFɧ>&F ;=njIִ|gEXgA݈</1mc*^=}b4 ot1XW5 c5pEot7uX<?$U?4;%) &$$ꇇ~ht D7B RP3?5+byoAbdwYdraY`ySzb~T]}BJ&.2)%;>`nH,|hr-)iG}~w AO /g)_(NDx3J=*qQ2+%h sLoSXzA@$ke·_~F?߲Η.Rr7?!Б!z"YOSRIsgiDn7pt7OfQOVu<;jar *ЍCϵ s?*dݝ*.P9׺};ZB 4U.֥sò]GIGYhm+yC,YqR@âFn"~ΟR܍)^ʓx, %'ҽst% ZFʾ[{\. &oXj|DOV\nV* 3:P..[6-Ti_xcb`\V7;99ij|{ZmATtKL %퉰St=e$YV6mW]Ew.I(̬3,o4 '%S.rL0!ȱEr[޻D|j!x d/א; 8UtWjy9!ԻRLj hgTTRv%Rce*3EW;,N,[-ѱ (~emV1fVV[£ ^z%}jt 8N_QFͦIm-$T>'=0%VA5BUL<"ߡñ/TT7c{b[#~ԟ ǔZɜSòJϷM{6S@NX(dOCGsUÉXZN9 og,C*v܍)^ʓx, %'ҽst%/gHЧC#6Z9t#62h)ӆ!Yr? ?.F%MS;8@eRIsgiDn7pt7OfQOVu<;jar *ЍCϵ s?A9aٻ1.7J4֗]37jS{oH|> GbPS.]ڟ*5g"^?Hrfo `Mv ]0拡C"0*p m,3؊0yx|$(WKL  E1#Snc%G8-pJw+UmVOs ĪB"hE?׶=͑K*ClW-open"> JAMA For an m-by-n matrix A with m >= n, the singular value decomposition is an m-by-n orthogonal matrix U, an n-by-n diagonal matrix S, and an n-by-n orthogonal matrix V so that A = U*S*V'
  •  JAMA Pythagorean Theorem: a = 3 b = 4 r = sqrt(square(a) + square(b)) r = 5 r = sqrt(a^2 + b^2) without under/overflow
  •  PHPExcel
    • Back to top  

    PHPExcel_Shared_Font

    category PHPExcel
    package PHPExcel_Shared
    copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)

     Methods

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

    calculateColumnWidth(\PHPExcel_Style_Font $font, \PHPExcel_RichText | string $cellText, integer $rotation, \PHPExcel_Style_Font $defaultFont) : integer
    Static

    Parameters

    $font

    \PHPExcel_Style_Font

    Font object

    $cellText

    \PHPExcel_RichTextstring

    Text to calculate width

    $rotation

    integer

    Rotation angle

    $defaultFont

    \PHPExcel_Style_FontNULL

    Font object

    Returns

    integerColumn width

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

    centimeterSizeToPixels(int $sizeInCm) : int
    Static

    Parameters

    $sizeInCm

    int

    Font size (in centimeters)

    Returns

    intSize (in pixels)

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

    fontSizeToPixels(int $fontSizeInPoints) : int
    Static

    Parameters

    $fontSizeInPoints

    int

    Font size (in points)

    Returns

    intFont size (in pixels)

    Get autoSize method

    getAutoSizeMethod() : string
    Static

    Returns

    string

    Returns the associated charset for the font name.

    getCharsetFromFontName(string $name) : int
    Static

    Parameters

    $name

    string

    Font name

    Returns

    intCharacter set code

    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)

    getDefaultColumnWidthByFont(\PHPExcel_Style_Font $font, boolean $pPixels) : mixed
    Static

    Parameters

    $font

    \PHPExcel_Style_Font

    The workbooks default font

    $pPixels

    boolean

    true = return column width in pixels, false = return in OOXML units

    Returns

    mixedColumn width

    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

    getDefaultRowHeightByFont(\PHPExcel_Style_Font $font) : float
    Static

    Parameters

    $font

    \PHPExcel_Style_Font

    The workbooks default font

    Returns

    floatRow height in points

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

    getTextWidthPixelsApprox(string $columnText, \PHPExcel_Style_Font $font, int $rotation) : int
    Static

    Parameters

    $columnText

    string

    $font

    \PHPExcel_Style_Font

    $rotation

    int

    Returns

    intText width in pixels (no padding added)

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

    getTextWidthPixelsExact(string $text, \PHPExcel_Style_Font $font, int $rotation) : int
    Static

    Parameters

    $text

    string

    $font

    \PHPExcel_Style_Font

    $rotation

    int

    Exceptions

    \PHPExcel_Exception

    Returns

    int

    Returns the font path given the font

    getTrueTypeFontFileFromFont(\PHPExcel_Style_Font $font) : string
    Static

    Parameters

    $font

    \PHPExcel_Style_Font

    Returns

    stringPath to TrueType font file

    Get the path to the folder containing .ttf files.

    getTrueTypeFontPath() : string
    Static

    Returns

    string

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

    inchSizeToPixels(int $sizeInInch) : int
    Static

    Parameters

    $sizeInInch

    int

    Font size (in inch)

    Returns

    intSize (in pixels)

    Set autoSize method

    setAutoSizeMethod(string $pValue) : boolean
    Static

    Parameters

    $pValue

    string

    Returns

    booleanSuccess or failure

    Set the path to the folder containing .ttf files.

    setTrueTypeFontPath(string $pValue) 
    Static

    There should be a trailing slash. Typical locations on variout some platforms:

    • C:/Windows/Fonts/
    • /usr/share/fonts/truetype/
    • ~/.fonts/

    Parameters

    $pValue

    string

     Properties

     

    $defaultColumnWidths : array
     

    $_autoSizeMethods 
     

    $autoSizeMethod : string
     

    $trueTypeFontPath : string

     Constants

     

    Font filenames

    ARIAL 
     

    ARIAL_BOLD

    ARIAL_BOLD 
     

    ARIAL_BOLD_ITALIC

    ARIAL_BOLD_ITALIC 
     

    ARIAL_ITALIC

    ARIAL_ITALIC 
     

    AUTOSIZE_METHOD_APPROX

    AUTOSIZE_METHOD_APPROX 
     

    AUTOSIZE_METHOD_EXACT

    AUTOSIZE_METHOD_EXACT 
     

    CALIBRI

    CALIBRI 
     

    CALIBRI_BOLD

    CALIBRI_BOLD 
     

    CALIBRI_BOLD_ITALIC

    CALIBRI_BOLD_ITALIC 
     

    CALIBRI_ITALIC

    CALIBRI_ITALIC 
     

    CHARSET_ANSI_ARABIC

    CHARSET_ANSI_ARABIC 
     

    CHARSET_ANSI_BALTIC

    CHARSET_ANSI_BALTIC 
     

    CHARSET_ANSI_CHINESE_SIMIPLIFIED

    CHARSET_ANSI_CHINESE_SIMIPLIFIED 
     

    CHARSET_ANSI_CHINESE_TRADITIONAL

    CHARSET_ANSI_CHINESE_TRADITIONAL 
     

    CHARSET_ANSI_CYRILLIC

    CHARSET_ANSI_CYRILLIC 
     

    CHARSET_ANSI_GREEK

    CHARSET_ANSI_GREEK 
     

    CHARSET_ANSI_HEBREW

    CHARSET_ANSI_HEBREW 
     

    CHARSET_ANSI_JAPANESE_SHIFTJIS

    CHARSET_ANSI_JAPANESE_SHIFTJIS 
     

    CHARSET_ANSI_KOREAN_HANGUL

    CHARSET_ANSI_KOREAN_HANGUL 
     

    CHARSET_ANSI_KOREAN_JOHAB

    CHARSET_ANSI_KOREAN_JOHAB 
     

    Character set codes used by BIFF5-8 in Font records

    CHARSET_ANSI_LATIN 
     

    CHARSET_ANSI_LATIN_II

    CHARSET_ANSI_LATIN_II 
     

    CHARSET_ANSI_THAI

    CHARSET_ANSI_THAI 
     

    CHARSET_ANSI_TURKISH

    CHARSET_ANSI_TURKISH 
     

    CHARSET_ANSI_VIETNAMESE

    CHARSET_ANSI_VIETNAMESE 
     

    CHARSET_APPLE_ROMAN

    CHARSET_APPLE_ROMAN 
     

    CHARSET_OEM_LATIN_I

    CHARSET_OEM_LATIN_I 
     

    CHARSET_SYMBOL

    CHARSET_SYMBOL 
     

    CHARSET_SYSTEM_DEFAULT

    CHARSET_SYSTEM_DEFAULT 
     

    COMIC_SANS_MS

    COMIC_SANS_MS 
     

    COMIC_SANS_MS_BOLD

    COMIC_SANS_MS_BOLD 
     

    COURIER_NEW

    COURIER_NEW 
     

    COURIER_NEW_BOLD

    COURIER_NEW_BOLD 
     

    COURIER_NEW_BOLD_ITALIC

    COURIER_NEW_BOLD_ITALIC 
     

    COURIER_NEW_ITALIC

    COURIER_NEW_ITALIC 
     

    GEORGIA

    GEORGIA 
     

    GEORGIA_BOLD

    GEORGIA_BOLD 
     

    GEORGIA_BOLD_ITALIC

    GEORGIA_BOLD_ITALIC 
     

    GEORGIA_ITALIC

    GEORGIA_ITALIC 
     

    IMPACT

    IMPACT 
     

    LIBERATION_SANS

    LIBERATION_SANS 
     

    LIBERATION_SANS_BOLD

    LIBERATION_SANS_BOLD 
     

    LIBERATION_SANS_BOLD_ITALIC

    LIBERATION_SANS_BOLD_ITALIC 
     

    LIBERATION_SANS_ITALIC

    LIBERATION_SANS_ITALIC 
     

    LUCIDA_CONSOLE

    LUCIDA_CONSOLE 
     

    LUCIDA_SANS_UNICODE

    LUCIDA_SANS_UNICODE 
     

    MICROSOFT_SANS_SERIF

    MICROSOFT_SANS_SERIF 
     

    PALATINO_LINOTYPE

    PALATINO_LINOTYPE 
     

    PALATINO_LINOTYPE_BOLD

    PALATINO_LINOTYPE_BOLD 
     

    PALATINO_LINOTYPE_BOLD_ITALIC

    PALATINO_LINOTYPE_BOLD_ITALIC 
     

    PALATINO_LINOTYPE_ITALIC

    PALATINO_LINOTYPE_ITALIC 
     

    SYMBOL

    SYMBOL 
     

    TAHOMA

    TAHOMA 
     

    TAHOMA_BOLD

    TAHOMA_BOLD 
     

    TIMES_NEW_ROMAN

    TIMES_NEW_ROMAN 
     

    TIMES_NEW_ROMAN_BOLD

    TIMES_NEW_ROMAN_BOLD 
     

    TIMES_NEW_ROMAN_BOLD_ITALIC

    TIMES_NEW_ROMAN_BOLD_ITALIC 
     

    TIMES_NEW_ROMAN_ITALIC

    TIMES_NEW_ROMAN_ITALIC 
     

    TREBUCHET_MS

    TREBUCHET_MS 
     

    TREBUCHET_MS_BOLD

    TREBUCHET_MS_BOLD 
     

    TREBUCHET_MS_BOLD_ITALIC

    TREBUCHET_MS_BOLD_ITALIC 
     

    TREBUCHET_MS_ITALIC

    TREBUCHET_MS_ITALIC 
     

    VERDANA

    VERDANA 
     

    VERDANA_BOLD

    VERDANA_BOLD 
     

    VERDANA_BOLD_ITALIC

    VERDANA_BOLD_ITALIC 
     

    VERDANA_ITALIC

    VERDANA_ITALIC