tzeg6@T+ f,c>o⌻wRW/ ‹KgMzPny\F7nXoāKJg EB? Cez>^^$/fЁ1. ?c6ir;*{4N;@a-ɉ53j`?<:A0׶,)ՈGsB =- lN i|E2ZyCFaj^{=݇4m"m̦A5()]દ\X1,~84ǺAaPi˄(;wѻ]cºP"cJDz^?zo~_UY̳-=~J*U \ֵ/5}z}Z''b]MSzљsEvtTg1 Ϲ }=7pOSYa5& mN2:v3c c2&Ɖ|t o.Щ3cdRExbPpd}ib|J/n\j&rJ%+j[,xl2O& w4}Q8vO惤VJ4]i W߱n6ŇXɸAQN$sGzƨNƨFC+q-%BgMdSYa5& mN2:v3c c2&Ɖ|t IɆ< SYa5& mN2:v3c c2&Ɖ|t fm$|c:=? dbUEa^=T"XUe!h rCR<…lS# bT%N؄c<4I\}?ay#8tȺvw_1>4Jh n;'; qkEGYq)]Y(V2!WjɳPٽ=E hΗk&=Ƃ $8"ut=m,u;{gu˜i*@ͥ>Sgc?yx?h1랰pE;b"`e؝m)`Q.Z]b"{aPd MV́q MQ3.3mT,*Raiz#m,f[qܩ֨*TVMׂgxZB4J8V;Qˋю [0dMTRb,gmG!!ET\`&hq(Q i6ކ3OP%!2uJ3/!i x0Uwv4\ܲZ,uu:*́ o:*'d}׳ ֗ӣ/WbnTpp?Qsaܙ~.> &3Q{ $eUS^[\{"QJFWM+}xüQ(VCUgRIn.H| Ҕ.${X[ >@e=ng Q4>2 7W}TH'kE}I؆u,YY"-cFCĶ8nn&,`\ft! jRr!E#*`-f<|ı5fEZ^ BJq\B2ӭȽsu$sv#0)NiHG}/xQ瑄v'?FITp͑K*ClWJt7$qiY4:o飙4I ,i$݈ n.OR4k쵼W QJ >w's-{KM謶 [ NRF.e ]pSXzA@$ke·_~F? C[􋍡MQJm V,iAu  vK,:_(5Kӱښ@:U$r3 TyaJe3J1 di20Kr-\Ōo@jtxAkB7薩xRܖ"NQ(8Cj|zK\Gv0>vMG$YytNYp N[\%1vԛ'_2GMyIXWcN jv UV*⨀i<%`ԓtv4t 8N_QFͦIm-$T>'a۸Y_Z=2 sR]~yYTe /cnoˆv>eE>AUbt9FX2\Zis#&䢻EHn1P! vp#ZP왲;X7W៼[x?J_?rͷLX 'uUavyճ- yT2(GNRopTH\VQHG QɐXL4,w,М#fnn74^"U& C,hk #0*"?,r2fIsJj6G&azr~slԯ+ߕ( tQÒu"dOB Cۉ) wK \jG5vln.ӘW= ŭ VvL,DǛ-$D.=+.-ↀq su7klD]%3ZCy@g $"0ȵ[T{on qdwْDv+;Q-i=mo<4AO=5uBp/_}Y @oJZk^pMj%cB(XՖw.8F`6pq6$3$VyQzgX<?$U?4;%) &$$ꇇ|q{:>SIC"Mx|Zш缿Xjvüevr7ҲvS183ZPԽ HϴoH|> Gb}HQ@ӖOVY_Y1 тiܱ]U`Ok=>tXz_An &fIsJj6G&azr$Bz`^\"-iIy})e)!T8@1?"3Mj< 団=kvKˬx+ےoO@rhILe?c4;BU,7@cEbDq؉[Ǧm 6|y[OE(}XPR# LYE"DM > vVcil!ԻRH^{j8=W) ~+N'1P! vp#ZP왲;X7W៼[x?J_?rͷLX 'uUavyճ- yT2(~/MiŦ_Qx'#IxRچ(*#c.ܸ&l1OtצYQxokv qaI~je/7w  <+̉H3Zq"?mLz@rb fF]VK޺)q55*=C<]i4ԡh;NH6L|"Oڴje@e8o9#lder-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_ReferenceHelper (Singleton)

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

     Methods

    __clone implementation.

    __clone() 

    Cloning should not be allowed in a Singleton!

    Exceptions

    \PHPExcel_Exception

    Compare two cell addresses Intended for use as a Callback function for sorting cell addresses by column and row

    cellReverseSort(string $a, string $b) : integer
    Static

    Parameters

    $a

    string

    First cell to test (e.g. 'AA1')

    $b

    string

    Second cell to test (e.g. 'Z1')

    Returns

    integer

    Compare two cell addresses Intended for use as a Callback function for sorting cell addresses by column and row

    cellSort(string $a, string $b) : integer
    Static

    Parameters

    $a

    string

    First cell to test (e.g. 'AA1')

    $b

    string

    Second cell to test (e.g. 'Z1')

    Returns

    integer

    Compare two column addresses Intended for use as a Callback function for reverse sorting column addresses by column

    columnReverseSort(string $a, string $b) : integer
    Static

    Parameters

    $a

    string

    First column to test (e.g. 'AA')

    $b

    string

    Second column to test (e.g. 'Z')

    Returns

    integer

    Compare two column addresses Intended for use as a Callback function for sorting column addresses by column

    columnSort(string $a, string $b) : integer
    Static

    Parameters

    $a

    string

    First column to test (e.g. 'AA')

    $b

    string

    Second column to test (e.g. 'Z')

    Returns

    integer

    Get an instance of this class

    getInstance() : \PHPExcel_ReferenceHelper
    Static

    Returns

    \PHPExcel_ReferenceHelper

    Insert a new column or row, updating all possible related data

    insertNewBefore(string $pBefore, integer $pNumCols, integer $pNumRows, \PHPExcel_Worksheet $pSheet) 

    Parameters

    $pBefore

    string

    Insert before this cell address (e.g. 'A1')

    $pNumCols

    integer

    Number of columns to insert/delete (negative values indicate deletion)

    $pNumRows

    integer

    Number of rows to insert/delete (negative values indicate deletion)

    $pSheet

    \PHPExcel_Worksheet

    The worksheet that we're editing

    Exceptions

    \PHPExcel_Exception

    Update cell reference

    updateCellReference(string $pCellRange, int $pBefore, int $pNumCols, int $pNumRows) : string

    Parameters

    $pCellRange

    string

    Cell range

    $pBefore

    int

    Insert before this one

    $pNumCols

    int

    Number of columns to increment

    $pNumRows

    int

    Number of rows to increment

    Exceptions

    \PHPExcel_Exception

    Returns

    stringUpdated cell range

    Update references within formulas

    updateFormulaReferences(string $pFormula, int $pBefore, int $pNumCols, int $pNumRows, string $sheetName) : string

    Parameters

    $pFormula

    string

    Formula to update

    $pBefore

    int

    Insert before this one

    $pNumCols

    int

    Number of columns to insert

    $pNumRows

    int

    Number of rows to insert

    $sheetName

    string

    Worksheet name/title

    Exceptions

    \PHPExcel_Exception

    Returns

    stringUpdated formula

    Update named formulas (i.e.

    updateNamedFormulas(\PHPExcel $pPhpExcel, string $oldName, string $newName) 

    containing worksheet references / named ranges)

    Parameters

    $pPhpExcel

    \PHPExcel

    Object to update

    $oldName

    string

    Old name (name to replace)

    $newName

    string

    New name

    Create a new PHPExcel_ReferenceHelper

    __construct() 

    Update column dimensions when inserting/deleting rows/columns

    _adjustColumnDimensions(\PHPExcel_Worksheet $pSheet, string $pBefore, integer $beforeColumnIndex, integer $pNumCols, integer $beforeRow, integer $pNumRows) 

    Parameters

    $pSheet

    \PHPExcel_Worksheet

    The worksheet that we're editing

    $pBefore

    string

    Insert/Delete before this cell address (e.g. 'A1')

    $beforeColumnIndex

    integer

    Index number of the column we're inserting/deleting before

    $pNumCols

    integer

    Number of columns to insert/delete (negative values indicate deletion)

    $beforeRow

    integer

    Number of the row we're inserting/deleting before

    $pNumRows

    integer

    Number of rows to insert/delete (negative values indicate deletion)

    Update cell comments when inserting/deleting rows/columns

    _adjustComments(\PHPExcel_Worksheet $pSheet, string $pBefore, integer $beforeColumnIndex, integer $pNumCols, integer $beforeRow, integer $pNumRows) 

    Parameters

    $pSheet

    \PHPExcel_Worksheet

    The worksheet that we're editing

    $pBefore

    string

    Insert/Delete before this cell address (e.g. 'A1')

    $beforeColumnIndex

    integer

    Index number of the column we're inserting/deleting before

    $pNumCols

    integer

    Number of columns to insert/delete (negative values indicate deletion)

    $beforeRow

    integer

    Number of the row we're inserting/deleting before

    $pNumRows

    integer

    Number of rows to insert/delete (negative values indicate deletion)

    Update data validations when inserting/deleting rows/columns

    _adjustDataValidations(\PHPExcel_Worksheet $pSheet, string $pBefore, integer $beforeColumnIndex, integer $pNumCols, integer $beforeRow, integer $pNumRows) 

    Parameters

    $pSheet

    \PHPExcel_Worksheet

    The worksheet that we're editing

    $pBefore

    string

    Insert/Delete before this cell address (e.g. 'A1')

    $beforeColumnIndex

    integer

    Index number of the column we're inserting/deleting before

    $pNumCols

    integer

    Number of columns to insert/delete (negative values indicate deletion)

    $beforeRow

    integer

    Number of the row we're inserting/deleting before

    $pNumRows

    integer

    Number of rows to insert/delete (negative values indicate deletion)

    Update hyperlinks when inserting/deleting rows/columns

    _adjustHyperlinks(\PHPExcel_Worksheet $pSheet, string $pBefore, integer $beforeColumnIndex, integer $pNumCols, integer $beforeRow, integer $pNumRows) 

    Parameters

    $pSheet

    \PHPExcel_Worksheet

    The worksheet that we're editing

    $pBefore

    string

    Insert/Delete before this cell address (e.g. 'A1')

    $beforeColumnIndex

    integer

    Index number of the column we're inserting/deleting before

    $pNumCols

    integer

    Number of columns to insert/delete (negative values indicate deletion)

    $beforeRow

    integer

    Number of the row we're inserting/deleting before

    $pNumRows

    integer

    Number of rows to insert/delete (negative values indicate deletion)

    Update merged cells when inserting/deleting rows/columns

    _adjustMergeCells(\PHPExcel_Worksheet $pSheet, string $pBefore, integer $beforeColumnIndex, integer $pNumCols, integer $beforeRow, integer $pNumRows) 

    Parameters

    $pSheet

    \PHPExcel_Worksheet

    The worksheet that we're editing

    $pBefore

    string

    Insert/Delete before this cell address (e.g. 'A1')

    $beforeColumnIndex

    integer

    Index number of the column we're inserting/deleting before

    $pNumCols

    integer

    Number of columns to insert/delete (negative values indicate deletion)

    $beforeRow

    integer

    Number of the row we're inserting/deleting before

    $pNumRows

    integer

    Number of rows to insert/delete (negative values indicate deletion)

    Update page breaks when inserting/deleting rows/columns

    _adjustPageBreaks(\PHPExcel_Worksheet $pSheet, string $pBefore, integer $beforeColumnIndex, integer $pNumCols, integer $beforeRow, integer $pNumRows) 

    Parameters

    $pSheet

    \PHPExcel_Worksheet

    The worksheet that we're editing

    $pBefore

    string

    Insert/Delete before this cell address (e.g. 'A1')

    $beforeColumnIndex

    integer

    Index number of the column we're inserting/deleting before

    $pNumCols

    integer

    Number of columns to insert/delete (negative values indicate deletion)

    $beforeRow

    integer

    Number of the row we're inserting/deleting before

    $pNumRows

    integer

    Number of rows to insert/delete (negative values indicate deletion)

    Update protected cells when inserting/deleting rows/columns

    _adjustProtectedCells(\PHPExcel_Worksheet $pSheet, string $pBefore, integer $beforeColumnIndex, integer $pNumCols, integer $beforeRow, integer $pNumRows) 

    Parameters

    $pSheet

    \PHPExcel_Worksheet

    The worksheet that we're editing

    $pBefore

    string

    Insert/Delete before this cell address (e.g. 'A1')

    $beforeColumnIndex

    integer

    Index number of the column we're inserting/deleting before

    $pNumCols

    integer

    Number of columns to insert/delete (negative values indicate deletion)

    $beforeRow

    integer

    Number of the row we're inserting/deleting before

    $pNumRows

    integer

    Number of rows to insert/delete (negative values indicate deletion)

    Update row dimensions when inserting/deleting rows/columns

    _adjustRowDimensions(\PHPExcel_Worksheet $pSheet, string $pBefore, integer $beforeColumnIndex, integer $pNumCols, integer $beforeRow, integer $pNumRows) 

    Parameters

    $pSheet

    \PHPExcel_Worksheet

    The worksheet that we're editing

    $pBefore

    string

    Insert/Delete before this cell address (e.g. 'A1')

    $beforeColumnIndex

    integer

    Index number of the column we're inserting/deleting before

    $pNumCols

    integer

    Number of columns to insert/delete (negative values indicate deletion)

    $beforeRow

    integer

    Number of the row we're inserting/deleting before

    $pNumRows

    integer

    Number of rows to insert/delete (negative values indicate deletion)

    Update cell range

    _updateCellRange(string $pCellRange, int $pBefore, int $pNumCols, int $pNumRows) : string

    Parameters

    $pCellRange

    string

    Cell range (e.g. 'B2:D4', 'B:C' or '2:3')

    $pBefore

    int

    Insert before this one

    $pNumCols

    int

    Number of columns to increment

    $pNumRows

    int

    Number of rows to increment

    Exceptions

    \PHPExcel_Exception

    Returns

    stringUpdated cell range

    Update single cell reference

    _updateSingleCellReference(string $pCellReference, int $pBefore, int $pNumCols, int $pNumRows) : string

    Parameters

    $pCellReference

    string

    Single cell reference

    $pBefore

    int

    Insert before this one

    $pNumCols

    int

    Number of columns to increment

    $pNumRows

    int

    Number of rows to increment

    Exceptions

    \PHPExcel_Exception

    Returns

    stringUpdated cell reference

    Test whether a cell address falls within a defined range of cells

    cellAddressInDeleteRange(string $cellAddress, integer $beforeRow, integer $pNumRows, integer $beforeColumnIndex, integer $pNumCols) : boolean
    Static

    Parameters

    $cellAddress

    string

    Address of the cell we're testing

    $beforeRow

    integer

    Number of the row we're inserting/deleting before

    $pNumRows

    integer

    Number of rows to insert/delete (negative values indicate deletion)

    $beforeColumnIndex

    integer

    Index number of the column we're inserting/deleting before

    $pNumCols

    integer

    Number of columns to insert/delete (negative values indicate deletion)

    Returns

    boolean

     Properties

     

    $_instance : \PHPExcel_ReferenceHelper

     Constants

     

    REFHELPER_REGEXP_CELLRANGE

    REFHELPER_REGEXP_CELLRANGE 
     

    Regular Expressions

    REFHELPER_REGEXP_CELLREF 
     

    REFHELPER_REGEXP_COLRANGE

    REFHELPER_REGEXP_COLRANGE 
     

    REFHELPER_REGEXP_ROWRANGE

    REFHELPER_REGEXP_ROWRANGE