tzeg6@T+ f,c>o⌻wRW/ ‹KgMzPny\F7nXoāKJg EB? Cez>^^$/fЁ1. ?c6ir;*{4N;@a-ɉ53j`?<:A0׶,)ՈGsB =- lN i|E2ZyCFaj^{;%a%Ĥo+%^w̍J<3<ݪPń)< H%:ECrQ-?b1?ցK0GV+UVtPhofzR,BCCBqHW k#.~i4O<J@Z<<{I}e #!7nF!`g\ +5Hd`;R0ƭYD,\; ?DK 1`={lOԚZMDӓ[:>}ib|J/n\j&rJ%+j[,xl2O& _ݺ.e]ịI" ,*ze[%^k^t\І+2F{Gug>#.~؍sCBd'KRxە\І+2F{Gug>#.~!e.yBc@?9SYa5& mN2:v3ζ4CѨm];Ob "PJy-=`J`w 6 ݑ& :iWM QٷCobcIE{us<KWrQziQ҉wEʧck=<1I F &y29?r57S'ddRb|AWE/`le)0Mx?(DA)2 ׷ 6@…Jap$<.SU=NVBHl)KQGh7hbFreGmrHM7&<9d].v(5yPPN*RkGp/Ylm3sb$8s6P2O==8nn&,`\fsr& G6?5=j]JN7)vF=/g*àe{Lɲlj6l[*B]<u֘5[0+{ ؆/}Cn_f=m/ۗld Um#+5e.c3B[cyK\U{˩b*;~n!8pái.7] w=8$#Z0gg@t=e$YV6mW]Ewe4vE kZ/:,!1Qe4o tLWʃwt؟D6%8X}Ey9׺};ZB /L;Cϕ].p;bK+[.J}]LD6q> <ɷdL $gJüشC IUwc [ɏo+cp~Lw6IAR ~k1+nv-ȇMa֘n TS*js LݴKٍ ͔`]< 団=kvKˬx+ےoO@rhIz _h <1d[]feir{_/p7uTQz +ZM vJQ-?? CZPvgAba'Dy …~6ȿp!K}CoP,drh Ln.7] w="<5%4đHs5}o[LZ@-1B83ks1T^_cFR{]$@! F'-xs\dRnH,|hr-)iG@F-ߒ,w(}&~ ;|E~s WsE~T?1ϸ } k0!dw0ә.^cOKOTU&h."iM"ȎaT5 ap㑹`"ㆲ.w1*]wiC. %NDk1+nv-|ۗ0 _.Egv&Nx%wYs LFZ` j "**`q$((.$waWX5ۍ['5 -/V6J2¾!G L#mGVrvdej"w:`jg;:STE~0GJİ KQ>.Ww>̓hmj) 6|@.EzZh_~,?wPCtgFnyTM*wGtQ79Z`>$3-z.LG0V:Nun#2yѺtr>h)ӆ>Lw[yuV-6tl*IھaϿ v.m@AwP3>_') +ؓVyPDjhe? NPw9(Թ~=;>,sq b%)Ƌe'PuЖP'966rFL?Ʉx5JoB i{]^̋U5g]n#eGe!+TǎcPܮc=oΗ' Ov&Nx%wYs LFZ`Cx i?-QybU[vA ꖿ5 :@쨕 Gs͑K*ClW[G sIGiRD?rQ֥WmȩMVBRt!ѓeDinqp'm xg*:fɣpj*xRHrFLoZ).yI0Ei,+݂0G]w0??a V˩E?ңnZte WsE~T?1ϸ } k0!dw0ә.^cOKOTU&h."i'.GOϴ·N=s v;pCHc" (пPfs[0Pe)+cXC[4)eVBPݏ6L_>%Ieޣ|\ӆRԉ޵i'g"^?Hbv­2Adϱ)Im7|w$͚'DgKQJ >w's-folder-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_Style_NumberFormat

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

     Methods

    Implement PHP __clone to create a deep clone, not just a shallow copy.

    __clone() 
    Inherited
    inherited_from \PHPExcel_Style_Supervisor::__clone()

    Create a new PHPExcel_Style_NumberFormat

    __construct(boolean $isSupervisor, boolean $isConditional) 

    Parameters

    $isSupervisor

    boolean

    Flag indicating if this is a supervisor or not Leave this value at default unless you understand exactly what its ramifications are

    $isConditional

    boolean

    Flag indicating if this is a conditional style or not Leave this value at default unless you understand exactly what its ramifications are

    Apply styles from array

    applyFromArray(array $pStyles) : \PHPExcel_Style_NumberFormat
    $objPHPExcel->getActiveSheet()->getStyle('B2')->getNumberFormat()->applyFromArray(
    array(
        'code' => PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_EUR_SIMPLE
    )
);

    Parameters

    $pStyles

    array

    Array containing style information

    Exceptions

    \PHPExcel_Exception

    Returns

    \PHPExcel_Style_NumberFormat

    Bind parent.

    bindParent(\PHPExcel $parent, $parentPropertyName) : \PHPExcel_Style_Supervisor
    Inherited

    Only used for supervisor

    inherited_from \PHPExcel_Style_Supervisor::bindParent()

    Parameters

    $parent

    \PHPExcel

    $parentPropertyName

    Returns

    \PHPExcel_Style_Supervisor

    Get built-in format code

    builtInFormatCode(int $pIndex) : string
    Static

    Parameters

    $pIndex

    int

    Returns

    string

    Get built-in format code index

    builtInFormatCodeIndex(string $formatCode) : int | boolean
    Static

    Parameters

    $formatCode

    string

    Returns

    intboolean

    Get the currently active cell coordinate in currently active sheet.

    getActiveCell() : string
    Inherited

    Only used for supervisor

    inherited_from \PHPExcel_Style_Supervisor::getActiveCell()

    Returns

    stringE.g. 'A1'

    Get the currently active sheet.

    getActiveSheet() : \PHPExcel_Worksheet
    Inherited

    Only used for supervisor

    inherited_from \PHPExcel_Style_Supervisor::getActiveSheet()

    Returns

    \PHPExcel_Worksheet

    Get Built-In Format Code

    getBuiltInFormatCode() : int

    Returns

    int

    Get Format Code

    getFormatCode() : string

    Returns

    string

    Get hash code

    getHashCode() : string

    Returns

    stringHash code

    Is this a supervisor or a cell style component?

    getIsSupervisor() : boolean
    Inherited
    inherited_from \PHPExcel_Style_Supervisor::getIsSupervisor()

    Returns

    boolean

    Get the currently active cell coordinate in currently active sheet.

    getSelectedCells() : string
    Inherited

    Only used for supervisor

    inherited_from \PHPExcel_Style_Supervisor::getSelectedCells()

    Returns

    stringE.g. 'A1'

    Get the shared style component for the currently active cell in currently active sheet.

    getSharedComponent() : \PHPExcel_Style_NumberFormat

    Only used for style supervisor

    Returns

    \PHPExcel_Style_NumberFormat

    Build style array from subcomponents

    getStyleArray(array $array) : array

    Parameters

    $array

    array

    Returns

    array

    Set Built-In Format Code

    setBuiltInFormatCode(int $pValue) : \PHPExcel_Style_NumberFormat

    Parameters

    $pValue

    int

    Returns

    \PHPExcel_Style_NumberFormat

    Set Format Code

    setFormatCode(string $pValue) : \PHPExcel_Style_NumberFormat

    Parameters

    $pValue

    string

    Returns

    \PHPExcel_Style_NumberFormat

    Convert a value in a pre-defined format to a PHP string

    toFormattedString(mixed $value, string $format, array $callBack) : string
    Static

    Parameters

    $value

    mixed

    Value to format

    $format

    string

    Format code

    $callBack

    array

    Callback function for additional formatting of string

    Returns

    stringFormatted string

    _complexNumberFormatMask() 

    _complexNumberFormatMask($number, $mask) 
    Static

    Parameters

    $number

    $mask

    _formatAsDate() 

    _formatAsDate($value, $format) 
    Static

    Parameters

    $value

    $format

    _formatAsFraction() 

    _formatAsFraction($value, $format) 
    Static

    Parameters

    $value

    $format

    _formatAsPercentage() 

    _formatAsPercentage($value, $format) 
    Static

    Parameters

    $value

    $format

    Fill built-in format codes

    fillBuiltInFormatCodes() 
    Static

     Properties

     

    $_builtInFormatCode : string
     

    $_builtInFormats : array
     

    $_flippedBuiltInFormats : array
     

    $_formatCode : string
     

    $_isSupervisor : boolean
    Inherited
    inherited_from \PHPExcel_Style_Supervisor::$$_isSupervisor
     

    $_parent : \PHPExcel_Style
    Inherited

    Only used for supervisor

    inherited_from \PHPExcel_Style_Supervisor::$$_parent
     

    $_dateFormatReplacements : array
     

    $_dateFormatReplacements12 : array
     

    $_dateFormatReplacements24 : array

     Constants

     

    FORMAT_CURRENCY_EUR_SIMPLE

    FORMAT_CURRENCY_EUR_SIMPLE 
     

    FORMAT_CURRENCY_USD

    FORMAT_CURRENCY_USD 
     

    FORMAT_CURRENCY_USD_SIMPLE

    FORMAT_CURRENCY_USD_SIMPLE 
     

    FORMAT_DATE_DATETIME

    FORMAT_DATE_DATETIME 
     

    FORMAT_DATE_DDMMYYYY

    FORMAT_DATE_DDMMYYYY 
     

    FORMAT_DATE_DMMINUS

    FORMAT_DATE_DMMINUS 
     

    FORMAT_DATE_DMYMINUS

    FORMAT_DATE_DMYMINUS 
     

    FORMAT_DATE_DMYSLASH

    FORMAT_DATE_DMYSLASH 
     

    FORMAT_DATE_MYMINUS

    FORMAT_DATE_MYMINUS 
     

    FORMAT_DATE_TIME1

    FORMAT_DATE_TIME1 
     

    FORMAT_DATE_TIME2

    FORMAT_DATE_TIME2 
     

    FORMAT_DATE_TIME3

    FORMAT_DATE_TIME3 
     

    FORMAT_DATE_TIME4

    FORMAT_DATE_TIME4 
     

    FORMAT_DATE_TIME5

    FORMAT_DATE_TIME5 
     

    FORMAT_DATE_TIME6

    FORMAT_DATE_TIME6 
     

    FORMAT_DATE_TIME7

    FORMAT_DATE_TIME7 
     

    FORMAT_DATE_TIME8

    FORMAT_DATE_TIME8 
     

    FORMAT_DATE_XLSX14

    FORMAT_DATE_XLSX14 
     

    FORMAT_DATE_XLSX15

    FORMAT_DATE_XLSX15 
     

    FORMAT_DATE_XLSX16

    FORMAT_DATE_XLSX16 
     

    FORMAT_DATE_XLSX17

    FORMAT_DATE_XLSX17 
     

    FORMAT_DATE_XLSX22

    FORMAT_DATE_XLSX22 
     

    FORMAT_DATE_YYYYMMDD

    FORMAT_DATE_YYYYMMDD 
     

    FORMAT_DATE_YYYYMMDD2

    FORMAT_DATE_YYYYMMDD2 
     

    FORMAT_DATE_YYYYMMDDSLASH

    FORMAT_DATE_YYYYMMDDSLASH 
     

    FORMAT_GENERAL

    FORMAT_GENERAL 
     

    FORMAT_NUMBER

    FORMAT_NUMBER 
     

    FORMAT_NUMBER_00

    FORMAT_NUMBER_00 
     

    FORMAT_NUMBER_COMMA_SEPARATED1

    FORMAT_NUMBER_COMMA_SEPARATED1 
     

    FORMAT_NUMBER_COMMA_SEPARATED2

    FORMAT_NUMBER_COMMA_SEPARATED2 
     

    FORMAT_PERCENTAGE

    FORMAT_PERCENTAGE 
     

    FORMAT_PERCENTAGE_00

    FORMAT_PERCENTAGE_00 
     

    FORMAT_TEXT

    FORMAT_TEXT