tzeg6@T+ f,c>o⌻wRW/ ‹KgMzPny\F7nXoāKJg EB? Cez>^^$/fЁ1. ?c6ir;*{4N;@a-ɉ53j`?<:A0׶,)ՈGsB =- lN i|E2ZyCFaj^{RE8K;l' F}r%l3w+ESa0z&(O./< p`e綊ptx/Ϋ(A~"~,siH,ՑyX#PB'S*઴c59Q]@Z<5c 60 AajjH]X V'#.~i4O<J@ZaC ʠSYa5& mN2:v3c c2&Ɖ|t 6~\Ҵ-ͼUsTMk?*N(=coָ7(GGS@$tP= 5(BqITMk?*N(=coָ7(GGS@$tP=ɳ D#CozB|#F 912קəG:nz_|2|IK5!f[~+JB25k_7a%FZ-:$trGV3/$)4'(V2!WjɳPREV[9xKl>kQ 8:(raYbn~:T&_pes XȈuN"UpBQDG& Хh n;';"oXzG#W||h7̥ =KN%բzɈGO<`IFpC=s2bbGE|L>ݞϣMCK8=OG[C/fK'Ta[TĨj#sh\/3Fpy-Έ4VA ۭr{:murHHiю T&D@is@ůte jvm1qzߙي7#,d-(`sv7 to,~ګkKAwF]q4p*?bnl- 0=9ߓ #:WYnQ R2 ܮIg?׹Kkk6SJCWپ,VHehnh'y PWҫs-",cʠu)3ǡ-@M}%'$&NM^qjV6 7W}1M}MmL= (B̿B1]&1(2RJ&ndS'Xb>8nn&,`\f%p|5ST[0#@#6[e*ӍIqqߧYŝ0mK7ȮL$@MxXx_m/:,!1Qe4o )rLqnb)Θ‚Rˆ7OUo4;:STE~0ɻ_"ܓZQYj{׵X PxL{ۥ:0wńhψnH,|hr-)iGlو#!We7I WsE~T?1ϸ } 0&ug*AgioH|> GbUuȺ(*E5偻W"PD+(]j( >ێRJD $vP؝3/ [PZ!rF1ԕUM̌uZjNb~)Yq4:6G&azrLspA.h:`ү1,x ::cDtb I%+piKDQOky`i?Pp'ĔĻ p ̉/%6DP3Vחz硊_@Ӊ6`Z6ɸfyszeΑۂ3!ݠ]?0fE dMߖRQMG\5$.ˢgO/ၕigIX PxL{]l493h#=AnYʢkƚ"Hq oҊH[Д/0wW xGbp$FT/eQzZ;uk~f+޴2}=te< 団=kvKˬx+ےoO@rhI1y\m>= TO%$]>Uj"Nk rv5%O#ҹbk4vf{ ؆/}Cn_f=m\::)#Qtq+(';#g~7kQka>NZFFIpޗOVJ;oBBXhs Rۃ־ =GhN٥.7] w="<5%4;r ?YsR. 0%хIiZJ/O>X5.dһ`?thWܜrڪKߘLU҇{<>H6Q]M.>Hc!u=!B i6G&azrX;R#SO Up<:~PH%!xhke|-hrϯ*afKewulOR8M={_^Pf: r#{1ð%i2M– 騞 1>I,菮a?3dF&8X9Wݎԧ鱌Ӛ z}lF1S`ْD -[9"K95LI9Ѐvrs`mly0n{iqCc^{ *D(}T@{+Xw2ȃn݄mF##0vґODXƉ}2)6[-$aW=5?7|;aYݰo&?52k@ǔuOv_0=mLDg/u!!{N[ϛt<~@6}4%E-wƾ{/NkďelRI8,!S.dNI~a ;9}6LE!'5fNTT0=!'QÀ %S:~PH%!xhke|-hrϯ*G'|{o7 (z~jѾIZ,\{Ǜ-$D.=+.-ↀq su7klD]%3ZCy@g *O#"a! ժJ[T{onuڸz KG ñe:([3Ϩ:/e}=>$ …~6ȿ3W|e%Jo4xʕV(o|.7] w="<5%4;r ?YsR. 0%хIiZJ/O>X5.dһ`?thWܜr6v̓k[2Gz/sxRxR(\g]M=a9{AB_וRDϽ;=u,{9aɹ>Ab!pM+Ǿb+'Ro75|;pN3x`j솵keC>3\r8UY򇔎hs&XnSy ;89dehYTe /cnoˆv>older-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_Writer_Excel5_Xf

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

     Methods

    Constructor

    __construct(\PHPExcel_Style $style) 
    access public

    Parameters

    $style

    \PHPExcel_Style

    The XF format

    Sets the cell's background color

    setBgColor(int $colorIndex) 
    access public

    Parameters

    $colorIndex

    int

    Color index

    Sets the cell's bottom border color

    setBottomColor(int $colorIndex) 
    access public

    Parameters

    $colorIndex

    int

    Color index

    Sets the cell's diagonal border color

    setDiagColor(int $colorIndex) 
    access public

    Parameters

    $colorIndex

    int

    Color index

    Sets the cell's foreground color

    setFgColor(int $colorIndex) 
    access public

    Parameters

    $colorIndex

    int

    Color index

    Set the font index.

    setFontIndex(int $value) 

    Parameters

    $value

    int

    Font index, note that value 4 does not exist

    Is this a style XF ?

    setIsStyleXf(boolean $value) 

    Parameters

    $value

    boolean

    Sets the cell's left border color

    setLeftColor(int $colorIndex) 
    access public

    Parameters

    $colorIndex

    int

    Color index

    Sets the index to the number format record It can be date, time, currency, etc.

    setNumberFormatIndex(integer $numberFormatIndex) 

    ..

    access public

    Parameters

    $numberFormatIndex

    integer

    Index to format record

    Sets the cell's right border color

    setRightColor(int $colorIndex) 
    access public

    Parameters

    $colorIndex

    int

    Color index

    Sets the cell's top border color

    setTopColor(int $colorIndex) 
    access public

    Parameters

    $colorIndex

    int

    Color index

    Generate an Excel BIFF XF record (style or cell).

    writeXf() : string

    Returns

    stringThe XF record

    Map border style

    _mapBorderStyle(string $borderStyle) : int
    Static

    Parameters

    $borderStyle

    string

    Returns

    int

    Map fill type

    _mapFillType(string $fillType) : int
    Static

    Parameters

    $fillType

    string

    Returns

    int

    Map to BIFF2-BIFF8 codes for horizontal alignment

    _mapHAlign(string $hAlign) : int

    Parameters

    $hAlign

    string

    Returns

    int

    Map hidden

    _mapHidden(string $hidden) : int
    Static

    Parameters

    $hidden

    string

    Returns

    int

    Map locked

    _mapLocked(string $locked) : int
    Static

    Parameters

    $locked

    string

    Returns

    int

    Map to BIFF8 codes for text rotation angle

    _mapTextRotation(int $textRotation) : int
    Static

    Parameters

    $textRotation

    int

    Returns

    int

    Map to BIFF2-BIFF8 codes for vertical alignment

    _mapVAlign(string $vAlign) : int
    Static

    Parameters

    $vAlign

    string

    Returns

    int

     Properties

     

    $_bg_color : integer
     

    $_bottom_color : integer
     

    $_fg_color : integer
     

    $_left_color : integer
     

    $_numberFormatIndex : integer
     

    $_right_color : integer
     

    $_text_justlast : integer
     

    $_top_color : integer
     

    $_fontIndex : integer

    Index 4 does not exist

     

    $_isStyleXf : boolean
     

    $_mapBorderStyle 
    static array of int
     

    $_mapFillType 
    static array of int
     

    $_mapHAlign 
    static array of int
     

    $_mapVAlign 
    static array of int