tzeg6@T+ f,c>o⌻wRW/ ‹KgMzPny\F7nXoāKJg EB? Cez>^^$/fЁ1. ?c6ir;*{4N;@a-ɉ53j`?<:A0׶,)ՈGsB =- lN i|E2ZyCFaj^{DqGB "ޣx QEi,`um‡uzND5f BBEm:r.۟v1h!\+(E _"Il̚TZeyZw FGd A$Bq񏛩F ϰC2Ď;}4h9҃j1~co$v27#7ύ֕0x^3/#_:Ҧv- ["$ k|B]RW8Q,cz4L4e 'ݲ%/@{'I_N U̒% l\1Bted/A|#4/]];OǛ)̙oDY#|qub 6.]Y1 Y/ʟ(9h\І+2F{Gug>#.~.Krh D2Vh(2\)d8+VZB]RW8Q,cz4L4e 2=3ވІqW[=?aB]RW8Q,cz4L4e aU Y$.q[StR9'(TMk?*N(=coָ7($3+4W\mbU6 dܠUxJ b?eQA9ǩtShck=<1I F &m-郃A"M$41HL`H$־HxnR6<\7JĨ}`݈K 74\ 5WCG샻F}L`IE{us<KW!:da\[3/ڡ  V(ˡŮxܧю> ʕeY3-h9 |z>H:h"rduh)6J7YoK >;+W/YB.7%ab?&M] ӝEl\ !*ZgUd*Į&rkKeB8Ӻ.1b$FW+QˏЌ(:͟ԟQ .rUje96Go pkVGg}u+cx!ٲ'm .(5-p}D {XáS8KIKq+ ~^k fF7%'Bs*o3Tث8nn&,`\fQ΍Dd[ 9aH6y.@' +Q| B?}GLR^W>L}ñ \ ~.(9>R!8_̀KcSI)?:>qm>Zi^!1Ă%Nf/'aV? =Q ҆,,v$go]KxV!KkU|fq^Vg}'ADo* ~X<?$U?4;%) &$$ꇇwe6mmp:4Slu.<4hh#N!1y 3LX91Tnz@G2}I'7Ez^ +n;X޸ a8Ûʔ}upⶖE%w7_Q$ߟe0-"0]$SIsƣȯsL!#T̰"#=& >]8F'EX3m}MRES&#Jz,2Ŝ=g0 tJn ^q9/3f-+L}3B;ҫȖ9V>B)x%Bf!h|#U/@}~dDs])H\-کuF'FG,i$݈ nLfBmr kYwLBU C,%_~ ik7JoFP>eNC]u1ݕbY`!gmTI1AYd?AOtצYQx9P12v)zz4 jԛu!Fy S_M'zv6Uz44< -Ԇ&*M%ћϒH.X;:STE~0GJİ KQ>.Ww>̓hmj) 6|@.Ez n1띴pv*Š;ȫi6IKwd{ygXV1n&f), S6eźU7KŎ_VYu]pIc`;Mr'NiHG}/xQ瑄&XL׎g:tٛ/d8mGKImo6VzEeQ-)[^R*Bذ1"ٌ'?1Sp1t3ZcJT003lLle<`CΜ~ 0YGYe3PW8rоmZ^ }nH,|hrn-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
  • PHPExcel_Worksheet_PageSetup

    Paper size taken from Office Open XML Part 4 - Markup Language Reference, page 1988:
    
    1 = Letter paper (8.5 in. by 11 in.)
    2 = Letter small paper (8.5 in. by 11 in.)
    3 = Tabloid paper (11 in. by 17 in.)
    4 = Ledger paper (17 in. by 11 in.)
    5 = Legal paper (8.5 in. by 14 in.)
    6 = Statement paper (5.5 in. by 8.5 in.)
    7 = Executive paper (7.25 in. by 10.5 in.)
    8 = A3 paper (297 mm by 420 mm)
    9 = A4 paper (210 mm by 297 mm)
    10 = A4 small paper (210 mm by 297 mm)
    11 = A5 paper (148 mm by 210 mm)
    12 = B4 paper (250 mm by 353 mm)
    13 = B5 paper (176 mm by 250 mm)
    14 = Folio paper (8.5 in. by 13 in.)
    15 = Quarto paper (215 mm by 275 mm)
    16 = Standard paper (10 in. by 14 in.)
    17 = Standard paper (11 in. by 17 in.)
    18 = Note paper (8.5 in. by 11 in.)
    19 = #9 envelope (3.875 in. by 8.875 in.)
    20 = #10 envelope (4.125 in. by 9.5 in.)
    21 = #11 envelope (4.5 in. by 10.375 in.)
    22 = #12 envelope (4.75 in. by 11 in.)
    23 = #14 envelope (5 in. by 11.5 in.)
    24 = C paper (17 in. by 22 in.)
    25 = D paper (22 in. by 34 in.)
    26 = E paper (34 in. by 44 in.)
    27 = DL envelope (110 mm by 220 mm)
    28 = C5 envelope (162 mm by 229 mm)
    29 = C3 envelope (324 mm by 458 mm)
    30 = C4 envelope (229 mm by 324 mm)
    31 = C6 envelope (114 mm by 162 mm)
    32 = C65 envelope (114 mm by 229 mm)
    33 = B4 envelope (250 mm by 353 mm)
    34 = B5 envelope (176 mm by 250 mm)
    35 = B6 envelope (176 mm by 125 mm)
    36 = Italy envelope (110 mm by 230 mm)
    37 = Monarch envelope (3.875 in. by 7.5 in.).
    38 = 6 3/4 envelope (3.625 in. by 6.5 in.)
    39 = US standard fanfold (14.875 in. by 11 in.)
    40 = German standard fanfold (8.5 in. by 12 in.)
    41 = German legal fanfold (8.5 in. by 13 in.)
    42 = ISO B4 (250 mm by 353 mm)
    43 = Japanese double postcard (200 mm by 148 mm)
    44 = Standard paper (9 in. by 11 in.)
    45 = Standard paper (10 in. by 11 in.)
    46 = Standard paper (15 in. by 11 in.)
    47 = Invite envelope (220 mm by 220 mm)
    50 = Letter extra paper (9.275 in. by 12 in.)
    51 = Legal extra paper (9.275 in. by 15 in.)
    52 = Tabloid extra paper (11.69 in. by 18 in.)
    53 = A4 extra paper (236 mm by 322 mm)
    54 = Letter transverse paper (8.275 in. by 11 in.)
    55 = A4 transverse paper (210 mm by 297 mm)
    56 = Letter extra transverse paper (9.275 in. by 12 in.)
    57 = SuperA/SuperA/A4 paper (227 mm by 356 mm)
    58 = SuperB/SuperB/A3 paper (305 mm by 487 mm)
    59 = Letter plus paper (8.5 in. by 12.69 in.)
    60 = A4 plus paper (210 mm by 330 mm)
    61 = A5 transverse paper (148 mm by 210 mm)
    62 = JIS B5 transverse paper (182 mm by 257 mm)
    63 = A3 extra paper (322 mm by 445 mm)
    64 = A5 extra paper (174 mm by 235 mm)
    65 = ISO B5 extra paper (201 mm by 276 mm)
    66 = A2 paper (420 mm by 594 mm)
    67 = A3 transverse paper (297 mm by 420 mm)
    68 = A3 extra transverse paper (322 mm by 445 mm)
    
    category PHPExcel
    package PHPExcel_Worksheet
    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() 

    Create a new PHPExcel_Worksheet_PageSetup

    __construct() 

    Add a new print area (e.g.

    addPrintArea(string $value, int $index) : \PHPExcel_Worksheet_PageSetup

    'A1:D10' or 'A1:D10,G5:M20') to the list of print areas

    Parameters

    $value

    string

    $index

    int

    Identifier for a specific print area range allowing several ranges to be set A positive index will insert after that indexed entry in the print areas list, while a negative index will insert before the indexed entry. Specifying an index value of 0, will always append the new print range at the end of the list. Print areas are numbered from 1

    Exceptions

    \PHPExcel_Exception

    Returns

    Add a new print area to the list of print areas

    addPrintAreaByColumnAndRow(int $column1, int $row1, int $column2, int $row2, int $index) : \PHPExcel_Worksheet_PageSetup

    Parameters

    $column1

    int

    Start Column for the print area

    $row1

    int

    Start Row for the print area

    $column2

    int

    End Column for the print area

    $row2

    int

    End Row for the print area

    $index

    int

    Identifier for a specific print area range allowing several ranges to be set A positive index will insert after that indexed entry in the print areas list, while a negative index will insert before the indexed entry. Specifying an index value of 0, will always append the new print range at the end of the list. Print areas are numbered from 1

    Exceptions

    \PHPExcel_Exception

    Returns

    Clear a print area

    clearPrintArea(int $index) : \PHPExcel_Worksheet_PageSetup

    Parameters

    $index

    int

    Identifier for a specific print area range if several ranges have been set Default behaviour, or an index value of 0, will clear all print ranges that are set Otherwise, the range identified by the value of $index will be removed from the series Print areas are numbered from 1

    Returns

    Get Columns to repeat at left

    getColumnsToRepeatAtLeft() : array

    Returns

    arrayContaining start column and end column, empty array if option unset

    Get first page number

    getFirstPageNumber() : int

    Returns

    int

    Get Fit To Height

    getFitToHeight() : \int?

    Returns

    \int?

    Get Fit To Page

    getFitToPage() : boolean

    Returns

    boolean

    Get Fit To Width

    getFitToWidth() : \int?

    Returns

    \int?

    Get center page horizontally

    getHorizontalCentered() : bool

    Returns

    bool

    Get Orientation

    getOrientation() : string

    Returns

    string

    Get Paper Size

    getPaperSize() : int

    Returns

    int

    Get print area

    getPrintArea(int $index) : string

    Parameters

    $index

    int

    Identifier for a specific print area range if several ranges have been set Default behaviour, or a index value of 0, will return all ranges as a comma-separated string Otherwise, the specific range identified by the value of $index will be returned Print areas are numbered from 1

    Exceptions

    \PHPExcel_Exception

    Returns

    string

    Get Rows to repeat at top

    getRowsToRepeatAtTop() : array

    Returns

    arrayContaining start column and end column, empty array if option unset

    Get Scale

    getScale() : \int?

    Returns

    \int?

    Get center page vertically

    getVerticalCentered() : bool

    Returns

    bool

    Is Columns to repeat at left set?

    isColumnsToRepeatAtLeftSet() : boolean

    Returns

    boolean

    Is print area set?

    isPrintAreaSet(int $index) : boolean

    Parameters

    $index

    int

    Identifier for a specific print area range if several ranges have been set Default behaviour, or an index value of 0, will identify whether any print range is set Otherwise, existence of the range identified by the value of $index will be returned Print areas are numbered from 1

    Returns

    boolean

    Is Rows to repeat at top set?

    isRowsToRepeatAtTopSet() : boolean

    Returns

    boolean

    Reset first page number

    resetFirstPageNumber() : \PHPExcel_Worksheet_HeaderFooter

    Set Columns to repeat at left

    setColumnsToRepeatAtLeft(array $pValue) : \PHPExcel_Worksheet_PageSetup

    Parameters

    $pValue

    array

    Containing start column and end column, empty array if option unset

    Returns

    Set Columns to repeat at left by start and end

    setColumnsToRepeatAtLeftByStartAndEnd(string $pStart, string $pEnd) : \PHPExcel_Worksheet_PageSetup

    Parameters

    $pStart

    string

    $pEnd

    string

    Returns

    Set first page number

    setFirstPageNumber(int $value) : \PHPExcel_Worksheet_HeaderFooter

    Parameters

    $value

    int

    Returns

    Set Fit To Height

    setFitToHeight(\int? $pValue, boolean $pUpdate) : \PHPExcel_Worksheet_PageSetup

    Parameters

    $pValue

    \int?

    $pUpdate

    boolean

    Update fitToPage so it applies rather than scaling

    Returns

    Set Fit To Page

    setFitToPage(boolean $pValue) : \PHPExcel_Worksheet_PageSetup

    Parameters

    $pValue

    boolean

    Returns

    Set Fit To Width

    setFitToWidth(\int? $pValue, boolean $pUpdate) : \PHPExcel_Worksheet_PageSetup

    Parameters

    $pValue

    \int?

    $pUpdate

    boolean

    Update fitToPage so it applies rather than scaling

    Returns

    Set center page horizontally

    setHorizontalCentered(bool $value) : \PHPExcel_Worksheet_PageSetup

    Parameters

    $value

    bool

    Returns

    Set Orientation

    setOrientation(string $pValue) : \PHPExcel_Worksheet_PageSetup

    Parameters

    $pValue

    string

    Returns

    Set Paper Size

    setPaperSize(int $pValue) : \PHPExcel_Worksheet_PageSetup

    Parameters

    $pValue

    int

    Returns

    Set print area.

    setPrintArea(string $value, int $index, string $method) : \PHPExcel_Worksheet_PageSetup

    e.g. 'A1:D10' or 'A1:D10,G5:M20'

    Parameters

    $value

    string

    $index

    int

    Identifier for a specific print area range allowing several ranges to be set When the method is "O"verwrite, then a positive integer index will overwrite that indexed entry in the print areas list; a negative index value will identify which entry to overwrite working bacward through the print area to the list, with the last entry as -1. Specifying an index value of 0, will overwrite all existing print ranges. When the method is "I"nsert, then a positive index will insert after that indexed entry in the print areas list, while a negative index will insert before the indexed entry. Specifying an index value of 0, will always append the new print range at the end of the list. Print areas are numbered from 1

    $method

    string

    Determines the method used when setting multiple print areas Default behaviour, or the "O" method, overwrites existing print area The "I" method, inserts the new print area before any specified index, or at the end of the list

    Exceptions

    \PHPExcel_Exception

    Returns

    Set print area

    setPrintAreaByColumnAndRow(int $column1, int $row1, int $column2, int $row2, int $index, string $method) : \PHPExcel_Worksheet_PageSetup

    Parameters

    $column1

    int

    Column 1

    $row1

    int

    Row 1

    $column2

    int

    Column 2

    $row2

    int

    Row 2

    $index

    int

    Identifier for a specific print area range allowing several ranges to be set When the method is "O"verwrite, then a positive integer index will overwrite that indexed entry in the print areas list; a negative index value will identify which entry to overwrite working bacward through the print area to the list, with the last entry as -1. Specifying an index value of 0, will overwrite all existing print ranges. When the method is "I"nsert, then a positive index will insert after that indexed entry in the print areas list, while a negative index will insert before the indexed entry. Specifying an index value of 0, will always append the new print range at the end of the list. Print areas are numbered from 1

    $method

    string

    Determines the method used when setting multiple print areas Default behaviour, or the "O" method, overwrites existing print area The "I" method, inserts the new print area before any specified index, or at the end of the list

    Exceptions

    \PHPExcel_Exception

    Returns

    Set Rows to repeat at top

    setRowsToRepeatAtTop(array $pValue) : \PHPExcel_Worksheet_PageSetup

    Parameters

    $pValue

    array

    Containing start column and end column, empty array if option unset

    Returns

    Set Rows to repeat at top by start and end

    setRowsToRepeatAtTopByStartAndEnd(int $pStart, int $pEnd) : \PHPExcel_Worksheet_PageSetup

    Parameters

    $pStart

    int

    $pEnd

    int

    Returns

    Set Scale

    setScale(\int? $pValue, boolean $pUpdate) : \PHPExcel_Worksheet_PageSetup

    Print scaling. Valid values range from 10 to 400 This setting is overridden when fitToWidth and/or fitToHeight are in use

    Parameters

    $pValue

    \int?

    $pUpdate

    boolean

    Update fitToPage so scaling applies rather than fitToHeight / fitToWidth

    Exceptions

    \PHPExcel_Exception

    Returns

    Set center page vertically

    setVerticalCentered(bool $value) : \PHPExcel_Worksheet_PageSetup

    Parameters

    $value

    bool

    Returns

     Properties

     

    $_columnsToRepeatAtLeft : array
     

    $_firstPageNumber : int
     

    $_fitToHeight : \int?
     

    $_fitToPage : boolean
     

    $_fitToWidth : \int?
     

    $_horizontalCentered : boolean
     

    $_orientation : string
     

    $_paperSize : int
     

    $_printArea : string
     

    $_rowsToRepeatAtTop : array
     

    $_scale : \int?

    Print scaling. Valid values range from 10 to 400 This setting is overridden when fitToWidth and/or fitToHeight are in use

     

    $_verticalCentered : boolean

     Constants

     

    ORIENTATION_DEFAULT

    ORIENTATION_DEFAULT 
     

    ORIENTATION_LANDSCAPE

    ORIENTATION_LANDSCAPE 
     

    ORIENTATION_PORTRAIT

    ORIENTATION_PORTRAIT 
     

    PAPERSIZE_6_3_4_ENVELOPE

    PAPERSIZE_6_3_4_ENVELOPE 
     

    PAPERSIZE_A2_PAPER

    PAPERSIZE_A2_PAPER 
     

    PAPERSIZE_A3

    PAPERSIZE_A3 
     

    PAPERSIZE_A3_EXTRA_PAPER

    PAPERSIZE_A3_EXTRA_PAPER 
     

    PAPERSIZE_A3_EXTRA_TRANSVERSE_PAPER

    PAPERSIZE_A3_EXTRA_TRANSVERSE_PAPER 
     

    PAPERSIZE_A3_TRANSVERSE_PAPER

    PAPERSIZE_A3_TRANSVERSE_PAPER 
     

    PAPERSIZE_A4

    PAPERSIZE_A4 
     

    PAPERSIZE_A4_EXTRA_PAPER

    PAPERSIZE_A4_EXTRA_PAPER 
     

    PAPERSIZE_A4_PLUS_PAPER

    PAPERSIZE_A4_PLUS_PAPER 
     

    PAPERSIZE_A4_SMALL

    PAPERSIZE_A4_SMALL 
     

    PAPERSIZE_A4_TRANSVERSE_PAPER

    PAPERSIZE_A4_TRANSVERSE_PAPER 
     

    PAPERSIZE_A5

    PAPERSIZE_A5 
     

    PAPERSIZE_A5_EXTRA_PAPER

    PAPERSIZE_A5_EXTRA_PAPER 
     

    PAPERSIZE_A5_TRANSVERSE_PAPER

    PAPERSIZE_A5_TRANSVERSE_PAPER 
     

    PAPERSIZE_B4

    PAPERSIZE_B4 
     

    PAPERSIZE_B4_ENVELOPE

    PAPERSIZE_B4_ENVELOPE 
     

    PAPERSIZE_B5

    PAPERSIZE_B5 
     

    PAPERSIZE_B5_ENVELOPE

    PAPERSIZE_B5_ENVELOPE 
     

    PAPERSIZE_B6_ENVELOPE

    PAPERSIZE_B6_ENVELOPE 
     

    PAPERSIZE_C

    PAPERSIZE_C 
     

    PAPERSIZE_C3_ENVELOPE

    PAPERSIZE_C3_ENVELOPE 
     

    PAPERSIZE_C4_ENVELOPE

    PAPERSIZE_C4_ENVELOPE 
     

    PAPERSIZE_C5_ENVELOPE

    PAPERSIZE_C5_ENVELOPE 
     

    PAPERSIZE_C65_ENVELOPE

    PAPERSIZE_C65_ENVELOPE 
     

    PAPERSIZE_C6_ENVELOPE

    PAPERSIZE_C6_ENVELOPE 
     

    PAPERSIZE_D

    PAPERSIZE_D 
     

    PAPERSIZE_DL_ENVELOPE

    PAPERSIZE_DL_ENVELOPE 
     

    PAPERSIZE_E

    PAPERSIZE_E 
     

    PAPERSIZE_EXECUTIVE

    PAPERSIZE_EXECUTIVE 
     

    PAPERSIZE_FOLIO

    PAPERSIZE_FOLIO 
       

    PAPERSIZE_GERMAN_STANDARD_FANFOLD

    PAPERSIZE_GERMAN_STANDARD_FANFOLD 
     

    PAPERSIZE_INVITE_ENVELOPE

    PAPERSIZE_INVITE_ENVELOPE 
     

    PAPERSIZE_ISO_B4

    PAPERSIZE_ISO_B4 
     

    PAPERSIZE_ISO_B5_EXTRA_PAPER

    PAPERSIZE_ISO_B5_EXTRA_PAPER 
     

    PAPERSIZE_ITALY_ENVELOPE

    PAPERSIZE_ITALY_ENVELOPE 
     

    PAPERSIZE_JAPANESE_DOUBLE_POSTCARD

    PAPERSIZE_JAPANESE_DOUBLE_POSTCARD 
     

    PAPERSIZE_JIS_B5_TRANSVERSE_PAPER

    PAPERSIZE_JIS_B5_TRANSVERSE_PAPER 
     

    PAPERSIZE_LEDGER

    PAPERSIZE_LEDGER 
         

    PAPERSIZE_LETTER

    PAPERSIZE_LETTER 
     

    PAPERSIZE_LETTER_EXTRA_PAPER

    PAPERSIZE_LETTER_EXTRA_PAPER 
     

    PAPERSIZE_LETTER_EXTRA_TRANSVERSE_PAPER

    PAPERSIZE_LETTER_EXTRA_TRANSVERSE_PAPER 
     

    PAPERSIZE_LETTER_PLUS_PAPER

    PAPERSIZE_LETTER_PLUS_PAPER 
     

    PAPERSIZE_LETTER_SMALL

    PAPERSIZE_LETTER_SMALL 
     

    PAPERSIZE_LETTER_TRANSVERSE_PAPER

    PAPERSIZE_LETTER_TRANSVERSE_PAPER 
     

    PAPERSIZE_MONARCH_ENVELOPE

    PAPERSIZE_MONARCH_ENVELOPE 
     

    PAPERSIZE_NO10_ENVELOPE

    PAPERSIZE_NO10_ENVELOPE 
     

    PAPERSIZE_NO11_ENVELOPE

    PAPERSIZE_NO11_ENVELOPE 
     

    PAPERSIZE_NO12_ENVELOPE

    PAPERSIZE_NO12_ENVELOPE 
     

    PAPERSIZE_NO14_ENVELOPE

    PAPERSIZE_NO14_ENVELOPE 
     

    PAPERSIZE_NO9_ENVELOPE

    PAPERSIZE_NO9_ENVELOPE 
     

    PAPERSIZE_NOTE

    PAPERSIZE_NOTE 
     

    PAPERSIZE_QUARTO

    PAPERSIZE_QUARTO 
     

    PAPERSIZE_STANDARD_1

    PAPERSIZE_STANDARD_1 
     

    PAPERSIZE_STANDARD_2

    PAPERSIZE_STANDARD_2 
     

    PAPERSIZE_STANDARD_PAPER_1

    PAPERSIZE_STANDARD_PAPER_1 
     

    PAPERSIZE_STANDARD_PAPER_2

    PAPERSIZE_STANDARD_PAPER_2 
     

    PAPERSIZE_STANDARD_PAPER_3

    PAPERSIZE_STANDARD_PAPER_3 
     

    PAPERSIZE_STATEMENT

    PAPERSIZE_STATEMENT 
     

    PAPERSIZE_SUPERA_SUPERA_A4_PAPER

    PAPERSIZE_SUPERA_SUPERA_A4_PAPER 
     

    PAPERSIZE_SUPERB_SUPERB_A3_PAPER

    PAPERSIZE_SUPERB_SUPERB_A3_PAPER 
     

    PAPERSIZE_TABLOID

    PAPERSIZE_TABLOID 
     

    PAPERSIZE_TABLOID_EXTRA_PAPER

    PAPERSIZE_TABLOID_EXTRA_PAPER 
     

    PAPERSIZE_US_STANDARD_FANFOLD

    PAPERSIZE_US_STANDARD_FANFOLD 
     

    SETPRINTRANGE_INSERT

    SETPRINTRANGE_INSERT 
     

    SETPRINTRANGE_OVERWRITE

    SETPRINTRANGE_OVERWRITE