============== TEST ==============
Test name: 01simple.php

17:48:52 Create new PHPExcel object
17:48:52 Set document properties
17:48:52 Add some data
17:48:52 Rename worksheet
17:48:52 Write to Excel2007 format


============== TEST ==============
Test name: 02types.php

17:48:52 Create new PHPExcel object
17:48:52 Set document properties
17:48:52 Set default font
17:48:52 Add some data
17:48:52 Rename worksheet
17:48:52 Write to Excel2007 format


============== TEST ==============
Test name: 02types-xls.php

17:48:52 Create new PHPExcel object
17:48:52 Set document properties
17:48:52 Set default font
17:48:52 Add some data
17:48:52 Rename worksheet
17:48:52 Write to Excel5 format


============== TEST ==============
Test name: 03formulas.php

17:48:52 Create new PHPExcel object
17:48:52 Set document properties
17:48:52 Add some data
17:48:52 Sum of Range #1 is 23
17:48:52 Sum of Range #2 is 33
17:48:52 Sum of both Ranges is 56
17:48:52 Minimum value in either Range is 3
17:48:52 Maximum value in either Range is 17
17:48:52 Average value of both Ranges is 9.333333333333334
17:48:52 Rename worksheet
17:48:52 Write to Excel2007 format


============== TEST ==============
Test name: 04printing.php

17:48:52 Create new PHPExcel object
17:48:52 Set document properties
17:48:52 Add some data
17:48:52 Set header/footer
17:48:52 Add a drawing to the header
17:48:52 Set page orientation and size
17:48:52 Rename worksheet
17:48:52 Write to Excel2007 format


============== TEST ==============
Test name: 05featuredemo.php

17:48:52 Create new PHPExcel object
17:48:52 Set document properties
17:48:52 Add some data
17:48:52 Add comments
17:48:52 Add rich-text string
17:48:52 Merge cells
17:48:52 Protect cells
17:48:52 Set cell number formats
17:48:52 Set column widths
17:48:52 Set fonts
17:48:52 Set alignments
17:48:52 Set thin black border outline around column
17:48:52 Set thick brown border outline around Total
17:48:52 Set fills
17:48:52 Set style for header row using alternative method
17:48:52 Unprotect a cell
17:48:52 Add a hyperlink to the sheet
17:48:52 Add a drawing to the worksheet
17:48:52 Add a drawing to the worksheet
17:48:52 Add a drawing to the worksheet
17:48:52 Play around with inserting and removing rows and columns
17:48:52 Set header/footer
17:48:52 Set page orientation and size
17:48:52 Rename first worksheet
17:48:52 Create a second Worksheet object
17:48:52 Add some data
17:48:52 Set the worksheet tab color
17:48:52 Set alignments
17:48:52 Set column widths
17:48:52 Set fonts
17:48:52 Add a drawing to the worksheet
17:48:52 Set page orientation and size
17:48:52 Rename second worksheet
17:48:52 Write to Excel2007 format


============== TEST ==============
Test name: 06largescale.php

17:48:52 Create new PHPExcel object
17:48:52 Set properties
17:48:52 Add data
17:48:52 Hide 'Phone' and 'fax' columns
17:48:52 Set outline levels
17:48:52 Freeze panes
17:48:52 Rows to repeat at top
17:48:53 Write to Excel2007 format


============== TEST ==============
Test name: 06largescale-xls.php

17:48:53 Create new PHPExcel object
17:48:53 Set properties
17:48:53 Add data
17:48:53 Hide 'Phone' and 'fax' columns
17:48:53 Set outline levels
17:48:53 Freeze panes
17:48:53 Rows to repeat at top
17:48:54 Write to Excel5 format


============== TEST ==============
Test name: 07reader.php

Please run 05featuredemo.php first.


============== TEST ==============
Test name: 08conditionalformatting.php

17:48:54 Create new PHPExcel object
17:48:54 Set document properties
17:48:54 Add some data
17:48:54 Set column widths
17:48:54 Add conditional formatting
17:48:54 Duplicate the conditional formatting across a range of cells
17:48:54 Set fonts
17:48:54 Set header/footer
17:48:54 Set page orientation and size
17:48:54 Rename worksheet
17:48:54 Write to Excel2007 format


============== TEST ==============
Test name: 09pagebreaks.php

17:48:54 Create new PHPExcel object
17:48:54 Set document properties
17:48:54 Add data and page breaks
17:48:54 Write to Excel2007 format


============== TEST ==============
Test name: 10autofilter.php

17:48:54 Create new PHPExcel object
17:48:54 Set document properties
17:48:54 Add data
17:48:54 Set title row bold
17:48:54 Set autofilter
17:48:54 Write to Excel2007 format


============== TEST ==============
Test name: 11documentsecurity.php

17:48:54 Create new PHPExcel object
17:48:54 Set document properties
17:48:54 Add some data
17:48:54 Rename worksheet
17:48:54 Set document security
17:48:54 Set sheet security
17:48:54 Write to Excel2007 format


============== TEST ==============
Test name: 11documentsecurity-xls.php

17:48:54 Create new PHPExcel object
17:48:54 Set document properties
17:48:54 Add some data
17:48:54 Rename worksheet
17:48:54 Set document security
17:48:54 Set sheet security
17:48:54 Write to Excel5 format


============== TEST ==============
Test name: 13calculation.php

17:48:54 List implemented functions
Array
(
    [0] => ABS
    [1] => ACCRINT
    [2] => ACCRINTM
    [3] => ACOS
    [4] => ACOSH
    [5] => ADDRESS
    [6] => AMORDEGRC
    [7] => AMORLINC
    [8] => AND
    [9] => ASIN
    [10] => ASINH
    [11] => ATAN
    [12] => ATAN2
    [13] => ATANH
    [14] => AVEDEV
    [15] => AVERAGE
    [16] => AVERAGEA
    [17] => AVERAGEIF
    [18] => BESSELI
    [19] => BESSELJ
    [20] => BESSELK
    [21] => BESSELY
    [22] => BETADIST
    [23] => BETAINV
    [24] => BIN2DEC
    [25] => BIN2HEX
    [26] => BIN2OCT
    [27] => BINOMDIST
    [28] => CEILING
    [29] => CHAR
    [30] => CHIDIST
    [31] => CHIINV
    [32] => CHOOSE
    [33] => CLEAN
    [34] => CODE
    [35] => COLUMN
    [36] => COLUMNS
    [37] => COMBIN
    [38] => COMPLEX
    [39] => CONCATENATE
    [40] => CONFIDENCE
    [41] => CONVERT
    [42] => CORREL
    [43] => COS
    [44] => COSH
    [45] => COUNT
    [46] => COUNTA
    [47] => COUNTBLANK
    [48] => COUNTIF
    [49] => COUPDAYBS
    [50] => COUPDAYS
    [51] => COUPDAYSNC
    [52] => COUPNCD
    [53] => COUPNUM
    [54] => COUPPCD
    [55] => COVAR
    [56] => CRITBINOM
    [57] => CUMIPMT
    [58] => CUMPRINC
    [59] => DATE
    [60] => DATEDIF
    [61] => DATEVALUE
    [62] => DAVERAGE
    [63] => DAY
    [64] => DAYS360
    [65] => DB
    [66] => DCOUNT
    [67] => DCOUNTA
    [68] => DDB
    [69] => DEC2BIN
    [70] => DEC2HEX
    [71] => DEC2OCT
    [72] => DEGREES
    [73] => DELTA
    [74] => DEVSQ
    [75] => DGET
    [76] => DISC
    [77] => DMAX
    [78] => DMIN
    [79] => DOLLAR
    [80] => DOLLARDE
    [81] => DOLLARFR
    [82] => DPRODUCT
    [83] => DSTDEV
    [84] => DSTDEVP
    [85] => DSUM
    [86] => DVAR
    [87] => DVARP
    [88] => EDATE
    [89] => EFFECT
    [90] => EOMONTH
    [91] => ERF
    [92] => ERFC
    [93] => ERROR.TYPE
    [94] => EVEN
    [95] => EXP
    [96] => EXPONDIST
    [97] => FACT
    [98] => FACTDOUBLE
    [99] => FALSE
    [100] => FIND
    [101] => FINDB
    [102] => FISHER
    [103] => FISHERINV
    [104] => FIXED
    [105] => FLOOR
    [106] => FORECAST
    [107] => FV
    [108] => FVSCHEDULE
    [109] => GAMMADIST
    [110] => GAMMAINV
    [111] => GAMMALN
    [112] => GCD
    [113] => GEOMEAN
    [114] => GESTEP
    [115] => GROWTH
    [116] => HARMEAN
    [117] => HEX2BIN
    [118] => HEX2DEC
    [119] => HEX2OCT
    [120] => HOUR
    [121] => HYPERLINK
    [122] => HYPGEOMDIST
    [123] => IF
    [124] => IFERROR
    [125] => IMABS
    [126] => IMAGINARY
    [127] => IMARGUMENT
    [128] => IMCONJUGATE
    [129] => IMCOS
    [130] => IMDIV
    [131] => IMEXP
    [132] => IMLN
    [133] => IMLOG10
    [134] => IMLOG2
    [135] => IMPOWER
    [136] => IMPRODUCT
    [137] => IMREAL
    [138] => IMSIN
    [139] => IMSQRT
    [140] => IMSUB
    [141] => IMSUM
    [142] => INDEX
    [143] => INDIRECT
    [144] => INT
    [145] => INTERCEPT
    [146] => INTRATE
    [147] => IPMT
    [148] => IRR
    [149] => ISBLANK
    [150] => ISERR
    [151] => ISERROR
    [152] => ISEVEN
    [153] => ISLOGICAL
    [154] => ISNA
    [155] => ISNONTEXT
    [156] => ISNUMBER
    [157] => ISODD
    [158] => ISPMT
    [159] => ISTEXT
    [160] => KURT
    [161] => LARGE
    [162] => LCM
    [163] => LEFT
    [164] => LEFTB
    [165] => LEN
    [166] => LENB
    [167] => LINEST
    [168] => LN
    [169] => LOG
    [170] => LOG10
    [171] => LOGEST
    [172] => LOGINV
    [173] => LOGNORMDIST
    [174] => LOOKUP
    [175] => LOWER
    [176] => MATCH
    [177] => MAX
    [178] => MAXA
    [179] => MAXIF
    [180] => MDETERM
    [181] => MEDIAN
    [182] => MID
    [183] => MIDB
    [184] => MIN
    [185] => MINA
    [186] => MINIF
    [187] => MINUTE
    [188] => MINVERSE
    [189] => MIRR
    [190] => MMULT
    [191] => MOD
    [192] => MODE
    [193] => MONTH
    [194] => MROUND
    [195] => MULTINOMIAL
    [196] => N
    [197] => NA
    [198] => NEGBINOMDIST
    [199] => NETWORKDAYS
    [200] => NOMINAL
    [201] => NORMDIST
    [202] => NORMINV
    [203] => NORMSDIST
    [204] => NORMSINV
    [205] => NOT
    [206] => NOW
    [207] => NPER
    [208] => NPV
    [209] => OCT2BIN
    [210] => OCT2DEC
    [211] => OCT2HEX
    [212] => ODD
    [213] => OFFSET
    [214] => OR
    [215] => PEARSON
    [216] => PERCENTILE
    [217] => PERCENTRANK
    [218] => PERMUT
    [219] => PI
    [220] => PMT
    [221] => POISSON
    [222] => POWER
    [223] => PPMT
    [224] => PRICE
    [225] => PRICEDISC
    [226] => PRICEMAT
    [227] => PRODUCT
    [228] => PROPER
    [229] => PV
    [230] => QUARTILE
    [231] => QUOTIENT
    [232] => RADIANS
    [233] => RAND
    [234] => RANDBETWEEN
    [235] => RANK
    [236] => RATE
    [237] => RECEIVED
    [238] => REPLACE
    [239] => REPLACEB
    [240] => REPT
    [241] => RIGHT
    [242] => RIGHTB
    [243] => ROMAN
    [244] => ROUND
    [245] => ROUNDDOWN
    [246] => ROUNDUP
    [247] => ROW
    [248] => ROWS
    [249] => RSQ
    [250] => SEARCH
    [251] => SEARCHB
    [252] => SECOND
    [253] => SERIESSUM
    [254] => SIGN
    [255] => SIN
    [256] => SINH
    [257] => SKEW
    [258] => SLN
    [259] => SLOPE
    [260] => SMALL
    [261] => SQRT
    [262] => SQRTPI
    [263] => STANDARDIZE
    [264] => STDEV
    [265] => STDEVA
    [266] => STDEVP
    [267] => STDEVPA
    [268] => STEYX
    [269] => SUBSTITUTE
    [270] => SUBTOTAL
    [271] => SUM
    [272] => SUMIF
    [273] => SUMPRODUCT
    [274] => SUMSQ
    [275] => SUMX2MY2
    [276] => SUMX2PY2
    [277] => SUMXMY2
    [278] => SYD
    [279] => T
    [280] => TAN
    [281] => TANH
    [282] => TBILLEQ
    [283] => TBILLPRICE
    [284] => TBILLYIELD
    [285] => TDIST
    [286] => TEXT
    [287] => TIME
    [288] => TIMEVALUE
    [289] => TINV
    [290] => TODAY
    [291] => TRANSPOSE
    [292] => TREND
    [293] => TRIM
    [294] => TRIMMEAN
    [295] => TRUE
    [296] => TRUNC
    [297] => TYPE
    [298] => UPPER
    [299] => VAR
    [300] => VARA
    [301] => VARP
    [302] => VARPA
    [303] => VERSION
    [304] => VLOOKUP
    [305] => WEEKDAY
    [306] => WEEKNUM
    [307] => WEIBULL
    [308] => WORKDAY
    [309] => XIRR
    [310] => XNPV
    [311] => YEAR
    [312] => YEARFRAC
    [313] => YIELDDISC
    [314] => YIELDMAT
    [315] => ZTEST
)
17:48:54 Create new PHPExcel object
17:48:54 Add some data and formulas
17:48:54 Calculated data
Value of B14 [=COUNT(B2:B12)]: 7
Value of B15 [=SUM(B2:B12)]: 64
Value of B16 [=MAX(B2:B12)]: 22
Value of B17 [=MIN(B2:B12)]: 2
Value of B18 [=AVERAGE(B2:B12)]: 9.142857142857142
Value of B19 [=MEDIAN(B2:B12)]: 8
Value of B20 [=MODE(B2:B12)]: #N/A
Value of B22 [=COUNTA(B2:B12)]: 10
Value of B23 [=MAXA(B2:B12)]: 22
Value of B24 [=MINA(B2:B12)]: 0
Value of B26 [=STDEV(B2:B12)]: 6.618876325292973
Value of B27 [=STDEVA(B2:B12)]: 6.883958809354461
Value of B28 [=STDEVP(B2:B12)]: 6.127888739864919
Value of B29 [=STDEVPA(B2:B12)]: 6.530696746902279
Value of B31 [=DEVSQ(B2:B12)]: 262.8571428571429
Value of B32 [=VAR(B2:B12)]: 47.44444444444444
Value of B33 [=VARA(B2:B12)]: 47.38888888888889
Value of B34 [=VARP(B2:B12)]: 42.17283950617284
Value of B35 [=VARPA(B2:B12)]: 42.65
Value of B37 [=DATE(2007, 12, 21)]: 39437
Value of B38 [=DATEDIF( DATE(2007, 12, 21), DATE(2007, 12, 22), "D" )]: 1
Value of B39 [=DATEVALUE("01-Feb-2006 10:06 AM")]: 38749
Value of B40 [=DAY( DATE(2006, 1, 2) )]: 2
Value of B41 [=DAYS360( DATE(2002, 2, 3), DATE(2005, 5, 31) )]: 1198
Value of C14 [=COUNT(C2:C12)]: 11
Value of C15 [=SUM(C2:C12)]: 30
Value of C16 [=MAX(C2:C12)]: 4
Value of C17 [=MIN(C2:C12)]: 0
Value of C18 [=AVERAGE(C2:C12)]: 2.727272727272727
Value of C19 [=MEDIAN(C2:C12)]: 3
Value of C20 [=MODE(C2:C12)]: 4
Value of C22 [=COUNTA(C2:C12)]: 11
Value of C23 [=MAXA(C2:C12)]: 4
Value of C24 [=MINA(C2:C12)]: 0
Value of C26 [=STDEV(C2:C12)]: 1.348399724926484
Value of C27 [=STDEVA(C2:C12)]: 1.348399724926484
Value of C28 [=STDEVP(C2:C12)]: 1.28564869306645
Value of C29 [=STDEVPA(C2:C12)]: 1.28564869306645
Value of C31 [=DEVSQ(C2:C12)]: 18.18181818181818
Value of C32 [=VAR(C2:C12)]: 1.818181818181818
Value of C33 [=VARA(C2:C12)]: 1.818181818181818
Value of C34 [=VARP(C2:C12)]: 1.652892561983471
Value of C35 [=VARPA(C2:C12)]: 1.652892561983471
Value of D14 [=((D2 * D3) + D4) & " should be 10"]: 10 should be 10
Value of E14 [=PI()]: 3.141592653589793
Value of E15 [=RAND()]: 0.7920006000000001
Value of E16 [=RANDBETWEEN(5, 10)]: 8
Value of F17 [=COUNT(B2:C12)]: 18
Value of F18 [=SUM(B2:C12)]: 94
Value of F19 [=MAX(B2:C12)]: 22
Value of F20 [=MIN(B2:C12)]: 0
Value of F21 [=AVERAGE(B2:C12)]: 5.222222222222222
Value of F22 [=MEDIAN(B2:C12)]: 4
Value of F23 [=MODE(B2:C12)]: 4
17:48:54 Write to Excel2007 format


============== TEST ==============
Test name: 14excel5.php

17:48:54 Create new PHPExcel object
17:48:54 Set document properties
17:48:54 Add some data
17:48:54 Add comments
17:48:54 Add rich-text string
17:48:54 Merge cells
17:48:54 Protect cells
17:48:54 Set cell number formats
17:48:54 Set column widths
17:48:54 Set fonts
17:48:54 Set alignments
17:48:54 Set thin black border outline around column
17:48:54 Set thick brown border outline around Total
17:48:54 Set fills
17:48:54 Set style for header row using alternative method
17:48:54 Unprotect a cell
17:48:54 Add a hyperlink to the sheet
17:48:54 Add a drawing to the worksheet
17:48:54 Add a drawing to the worksheet
17:48:54 Add a drawing to the worksheet
17:48:54 Play around with inserting and removing rows and columns
17:48:54 Set header/footer
17:48:54 Set page orientation and size
17:48:54 Rename first worksheet
17:48:54 Create a second Worksheet object
17:48:54 Add some data
17:48:54 Set the worksheet tab color
17:48:54 Set alignments
17:48:54 Set column widths
17:48:54 Set fonts
17:48:54 Add a drawing to the worksheet
17:48:54 Set page orientation and size
17:48:54 Rename second worksheet
17:48:54 Write to Excel5 format


============== TEST ==============
Test name: 15datavalidation.php

17:48:55 Create new PHPExcel object
17:48:55 Set document properties
17:48:55 Add data
17:48:55 Set data validation
17:48:55 Write to Excel2007 format


============== TEST ==============
Test name: 15datavalidation-xls.php

17:48:55 Create new PHPExcel object
17:48:55 Set document properties
17:48:55 Add data
17:48:55 Set data validation
17:48:55 Write to Excel5 format


============== TEST ==============
Test name: 16csv.php

17:48:55 Create new PHPExcel object
17:48:55 Set document properties
17:48:55 Add some data
17:48:55 Add comments
17:48:55 Add rich-text string
17:48:55 Merge cells
17:48:55 Protect cells
17:48:55 Set cell number formats
17:48:55 Set column widths
17:48:55 Set fonts
17:48:55 Set alignments
17:48:55 Set thin black border outline around column
17:48:55 Set thick brown border outline around Total
17:48:55 Set fills
17:48:55 Set style for header row using alternative method
17:48:55 Unprotect a cell
17:48:55 Add a hyperlink to the sheet
17:48:55 Add a drawing to the worksheet
17:48:55 Add a drawing to the worksheet
17:48:55 Add a drawing to the worksheet
17:48:55 Play around with inserting and removing rows and columns
17:48:55 Set header/footer
17:48:55 Set page orientation and size
17:48:55 Rename first worksheet
17:48:55 Create a second Worksheet object
17:48:55 Add some data
17:48:55 Set the worksheet tab color
17:48:55 Set alignments
17:48:55 Set column widths
17:48:55 Set fonts
17:48:55 Add a drawing to the worksheet
17:48:55 Set page orientation and size
17:48:55 Rename second worksheet
17:48:55 Write to CSV format


============== TEST ==============
Test name: 17html.php

17:48:55 Create new PHPExcel object
17:48:55 Set document properties
17:48:55 Add some data
17:48:55 Add comments
17:48:55 Add rich-text string
17:48:55 Merge cells
17:48:55 Protect cells
17:48:55 Set cell number formats
17:48:55 Set column widths
17:48:55 Set fonts
17:48:55 Set alignments
17:48:55 Set thin black border outline around column
17:48:55 Set thick brown border outline around Total
17:48:55 Set fills
17:48:55 Set style for header row using alternative method
17:48:55 Unprotect a cell
17:48:55 Add a hyperlink to the sheet
17:48:55 Add a drawing to the worksheet
17:48:55 Add a drawing to the worksheet
17:48:55 Add a drawing to the worksheet
17:48:55 Play around with inserting and removing rows and columns
17:48:55 Set header/footer
17:48:55 Set page orientation and size
17:48:55 Rename first worksheet
17:48:55 Create a second Worksheet object
17:48:55 Add some data
17:48:55 Set the worksheet tab color
17:48:55 Set alignments
17:48:55 Set column widths
17:48:55 Set fonts
17:48:55 Add a drawing to the worksheet
17:48:55 Set page orientation and size
17:48:55 Rename second worksheet
17:48:55 Write to HTML format


============== TEST ==============
Test name: 18extendedcalculation.php

17:48:55 List implemented functions
Array
(
    [0] => ABS
    [1] => ACCRINT
    [2] => ACCRINTM
    [3] => ACOS
    [4] => ACOSH
    [5] => ADDRESS
    [6] => AMORDEGRC
    [7] => AMORLINC
    [8] => AND
    [9] => ASIN
    [10] => ASINH
    [11] => ATAN
    [12] => ATAN2
    [13] => ATANH
    [14] => AVEDEV
    [15] => AVERAGE
    [16] => AVERAGEA
    [17] => AVERAGEIF
    [18] => BESSELI
    [19] => BESSELJ
    [20] => BESSELK
    [21] => BESSELY
    [22] => BETADIST
    [23] => BETAINV
    [24] => BIN2DEC
    [25] => BIN2HEX
    [26] => BIN2OCT
    [27] => BINOMDIST
    [28] => CEILING
    [29] => CHAR
    [30] => CHIDIST
    [31] => CHIINV
    [32] => CHOOSE
    [33] => CLEAN
    [34] => CODE
    [35] => COLUMN
    [36] => COLUMNS
    [37] => COMBIN
    [38] => COMPLEX
    [39] => CONCATENATE
    [40] => CONFIDENCE
    [41] => CONVERT
    [42] => CORREL
    [43] => COS
    [44] => COSH
    [45] => COUNT
    [46] => COUNTA
    [47] => COUNTBLANK
    [48] => COUNTIF
    [49] => COUPDAYBS
    [50] => COUPDAYS
    [51] => COUPDAYSNC
    [52] => COUPNCD
    [53] => COUPNUM
    [54] => COUPPCD
    [55] => COVAR
    [56] => CRITBINOM
    [57] => CUMIPMT
    [58] => CUMPRINC
    [59] => DATE
    [60] => DATEDIF
    [61] => DATEVALUE
    [62] => DAVERAGE
    [63] => DAY
    [64] => DAYS360
    [65] => DB
    [66] => DCOUNT
    [67] => DCOUNTA
    [68] => DDB
    [69] => DEC2BIN
    [70] => DEC2HEX
    [71] => DEC2OCT
    [72] => DEGREES
    [73] => DELTA
    [74] => DEVSQ
    [75] => DGET
    [76] => DISC
    [77] => DMAX
    [78] => DMIN
    [79] => DOLLAR
    [80] => DOLLARDE
    [81] => DOLLARFR
    [82] => DPRODUCT
    [83] => DSTDEV
    [84] => DSTDEVP
    [85] => DSUM
    [86] => DVAR
    [87] => DVARP
    [88] => EDATE
    [89] => EFFECT
    [90] => EOMONTH
    [91] => ERF
    [92] => ERFC
    [93] => ERROR.TYPE
    [94] => EVEN
    [95] => EXP
    [96] => EXPONDIST
    [97] => FACT
    [98] => FACTDOUBLE
    [99] => FALSE
    [100] => FIND
    [101] => FINDB
    [102] => FISHER
    [103] => FISHERINV
    [104] => FIXED
    [105] => FLOOR
    [106] => FORECAST
    [107] => FV
    [108] => FVSCHEDULE
    [109] => GAMMADIST
    [110] => GAMMAINV
    [111] => GAMMALN
    [112] => GCD
    [113] => GEOMEAN
    [114] => GESTEP
    [115] => GROWTH
    [116] => HARMEAN
    [117] => HEX2BIN
    [118] => HEX2DEC
    [119] => HEX2OCT
    [120] => HOUR
    [121] => HYPERLINK
    [122] => HYPGEOMDIST
    [123] => IF
    [124] => IFERROR
    [125] => IMABS
    [126] => IMAGINARY
    [127] => IMARGUMENT
    [128] => IMCONJUGATE
    [129] => IMCOS
    [130] => IMDIV
    [131] => IMEXP
    [132] => IMLN
    [133] => IMLOG10
    [134] => IMLOG2
    [135] => IMPOWER
    [136] => IMPRODUCT
    [137] => IMREAL
    [138] => IMSIN
    [139] => IMSQRT
    [140] => IMSUB
    [141] => IMSUM
    [142] => INDEX
    [143] => INDIRECT
    [144] => INT
    [145] => INTERCEPT
    [146] => INTRATE
    [147] => IPMT
    [148] => IRR
    [149] => ISBLANK
    [150] => ISERR
    [151] => ISERROR
    [152] => ISEVEN
    [153] => ISLOGICAL
    [154] => ISNA
    [155] => ISNONTEXT
    [156] => ISNUMBER
    [157] => ISODD
    [158] => ISPMT
    [159] => ISTEXT
    [160] => KURT
    [161] => LARGE
    [162] => LCM
    [163] => LEFT
    [164] => LEFTB
    [165] => LEN
    [166] => LENB
    [167] => LINEST
    [168] => LN
    [169] => LOG
    [170] => LOG10
    [171] => LOGEST
    [172] => LOGINV
    [173] => LOGNORMDIST
    [174] => LOOKUP
    [175] => LOWER
    [176] => MATCH
    [177] => MAX
    [178] => MAXA
    [179] => MAXIF
    [180] => MDETERM
    [181] => MEDIAN
    [182] => MID
    [183] => MIDB
    [184] => MIN
    [185] => MINA
    [186] => MINIF
    [187] => MINUTE
    [188] => MINVERSE
    [189] => MIRR
    [190] => MMULT
    [191] => MOD
    [192] => MODE
    [193] => MONTH
    [194] => MROUND
    [195] => MULTINOMIAL
    [196] => N
    [197] => NA
    [198] => NEGBINOMDIST
    [199] => NETWORKDAYS
    [200] => NOMINAL
    [201] => NORMDIST
    [202] => NORMINV
    [203] => NORMSDIST
    [204] => NORMSINV
    [205] => NOT
    [206] => NOW
    [207] => NPER
    [208] => NPV
    [209] => OCT2BIN
    [210] => OCT2DEC
    [211] => OCT2HEX
    [212] => ODD
    [213] => OFFSET
    [214] => OR
    [215] => PEARSON
    [216] => PERCENTILE
    [217] => PERCENTRANK
    [218] => PERMUT
    [219] => PI
    [220] => PMT
    [221] => POISSON
    [222] => POWER
    [223] => PPMT
    [224] => PRICE
    [225] => PRICEDISC
    [226] => PRICEMAT
    [227] => PRODUCT
    [228] => PROPER
    [229] => PV
    [230] => QUARTILE
    [231] => QUOTIENT
    [232] => RADIANS
    [233] => RAND
    [234] => RANDBETWEEN
    [235] => RANK
    [236] => RATE
    [237] => RECEIVED
    [238] => REPLACE
    [239] => REPLACEB
    [240] => REPT
    [241] => RIGHT
    [242] => RIGHTB
    [243] => ROMAN
    [244] => ROUND
    [245] => ROUNDDOWN
    [246] => ROUNDUP
    [247] => ROW
    [248] => ROWS
    [249] => RSQ
    [250] => SEARCH
    [251] => SEARCHB
    [252] => SECOND
    [253] => SERIESSUM
    [254] => SIGN
    [255] => SIN
    [256] => SINH
    [257] => SKEW
    [258] => SLN
    [259] => SLOPE
    [260] => SMALL
    [261] => SQRT
    [262] => SQRTPI
    [263] => STANDARDIZE
    [264] => STDEV
    [265] => STDEVA
    [266] => STDEVP
    [267] => STDEVPA
    [268] => STEYX
    [269] => SUBSTITUTE
    [270] => SUBTOTAL
    [271] => SUM
    [272] => SUMIF
    [273] => SUMPRODUCT
    [274] => SUMSQ
    [275] => SUMX2MY2
    [276] => SUMX2PY2
    [277] => SUMXMY2
    [278] => SYD
    [279] => T
    [280] => TAN
    [281] => TANH
    [282] => TBILLEQ
    [283] => TBILLPRICE
    [284] => TBILLYIELD
    [285] => TDIST
    [286] => TEXT
    [287] => TIME
    [288] => TIMEVALUE
    [289] => TINV
    [290] => TODAY
    [291] => TRANSPOSE
    [292] => TREND
    [293] => TRIM
    [294] => TRIMMEAN
    [295] => TRUE
    [296] => TRUNC
    [297] => TYPE
    [298] => UPPER
    [299] => VAR
    [300] => VARA
    [301] => VARP
    [302] => VARPA
    [303] => VERSION
    [304] => VLOOKUP
    [305] => WEEKDAY
    [306] => WEEKNUM
    [307] => WEIBULL
    [308] => WORKDAY
    [309] => XIRR
    [310] => XNPV
    [311] => YEAR
    [312] => YEARFRAC
    [313] => YIELDDISC
    [314] => YIELDMAT
    [315] => ZTEST
)
17:48:55 Create new PHPExcel object
17:48:55 Add some data
17:48:55 Calculated data
Value of B14 [=COUNT(B2:B12)]: 7
Value of B15 [=SUM(B2:B12)]: 64
Value of B16 [=MAX(B2:B12)]: 22
Value of B17 [=MIN(B2:B12)]: 2
Value of B18 [=AVERAGE(B2:B12)]: 9.142857142857142
Value of B19 [=MEDIAN(B2:B12)]: 8
Value of B20 [=MODE(B2:B12)]: #N/A
Value of B22 [=COUNTA(B2:B12)]: 10
Value of B23 [=MAXA(B2:B12)]: 22
Value of B24 [=MINA(B2:B12)]: 0
Value of B26 [=STDEV(B2:B12)]: 6.618876325292973
Value of B27 [=STDEVA(B2:B12)]: 6.883958809354461
Value of B28 [=STDEVP(B2:B12)]: 6.127888739864919
Value of B29 [=STDEVPA(B2:B12)]: 6.530696746902279
Value of B31 [=DEVSQ(B2:B12)]: 262.8571428571429
Value of B32 [=VAR(B2:B12)]: 47.44444444444444
Value of B33 [=VARA(B2:B12)]: 47.38888888888889
Value of B34 [=VARP(B2:B12)]: 42.17283950617284
Value of B35 [=VARPA(B2:B12)]: 42.65
Value of C14 [=COUNT(C2:C12)]: 11
Value of C15 [=SUM(C2:C12)]: 30
Value of C16 [=MAX(C2:C12)]: 4
Value of C17 [=MIN(C2:C12)]: 0
Value of C18 [=AVERAGE(C2:C12)]: 2.727272727272727
Value of C19 [=MEDIAN(C2:C12)]: 3
Value of C20 [=MODE(C2:C12)]: 4
Value of C22 [=COUNTA(C2:C12)]: 11
Value of C23 [=MAXA(C2:C12)]: 4
Value of C24 [=MINA(C2:C12)]: 0
Value of C26 [=STDEV(C2:C12)]: 1.348399724926484
Value of C27 [=STDEVA(C2:C12)]: 1.348399724926484
Value of C28 [=STDEVP(C2:C12)]: 1.28564869306645
Value of C29 [=STDEVPA(C2:C12)]: 1.28564869306645
Value of C31 [=DEVSQ(C2:C12)]: 18.18181818181818
Value of C32 [=VAR(C2:C12)]: 1.818181818181818
Value of C33 [=VARA(C2:C12)]: 1.818181818181818
Value of C34 [=VARP(C2:C12)]: 1.652892561983471
Value of C35 [=VARPA(C2:C12)]: 1.652892561983471
17:48:55 Peak memory usage: 4.25 MB
17:48:55 Done.


============== TEST ==============
Test name: 19namedrange.php

17:48:55 Create new PHPExcel object
17:48:55 Set document properties
17:48:55 Add some data
17:48:55 Define named ranges
17:48:55 Rename named ranges
17:48:55 Rename worksheet
17:48:55 Create new Worksheet object
17:48:55 Add some data
17:48:55 Resolve range
Cell B1 {=PersonFN}: Maarten
Cell B3 {=PersonFN & " " & PersonLN}: Maarten Balliauw
Cell Person!B1: Maarten
17:48:55 Rename worksheet
17:48:55 Write to Excel2007 format


============== TEST ==============
Test name: 20readexcel5.php

Please run 14excel5.php first.


============== TEST ==============
Test name: 21pdf.php

17:48:55 Create new PHPExcel object
17:48:55 Set document properties
17:48:55 Add some data
17:48:55 Add comments
17:48:55 Add rich-text string
17:48:55 Merge cells
17:48:55 Protect cells
17:48:55 Set cell number formats
17:48:55 Set column widths
17:48:55 Set fonts
17:48:55 Set alignments
17:48:55 Set thin black border outline around column
17:48:55 Set thick brown border outline around Total
17:48:55 Set fills
17:48:55 Set style for header row using alternative method
17:48:55 Unprotect a cell
17:48:55 Add a hyperlink to the sheet
17:48:55 Add a drawing to the worksheet
17:48:55 Add a drawing to the worksheet
17:48:55 Add a drawing to the worksheet
17:48:55 Play around with inserting and removing rows and columns
17:48:55 Set header/footer
17:48:55 Set page orientation and size
17:48:55 Rename first worksheet
17:48:55 Create a second Worksheet object
17:48:55 Add some data
17:48:55 Set the worksheet tab color
17:48:55 Set alignments
17:48:55 Set column widths
17:48:55 Set fonts
17:48:55 Add a drawing to the worksheet
17:48:55 Set page orientation and size
17:48:55 Rename second worksheet
17:48:55 Hide grid lines
17:48:55 Set orientation to landscape
17:48:55 Write to PDF format


============== TEST ==============
Test name: 22heavilyformatted.php

17:48:55 Create new PHPExcel object
17:48:55 Set document properties
17:48:55 Add some data
17:48:55 Write to Excel2007 format


============== TEST ==============
Test name: 23sharedstyles.php

17:48:55 Create new PHPExcel object
17:48:55 Set document properties
17:48:55 Add some data
17:48:55 Write to Excel2007 format


============== TEST ==============
Test name: 24readfilter.php

Please run 06largescale.php first.


============== TEST ==============
Test name: 25inmemoryimage.php

17:48:55 Create new PHPExcel object
17:48:55 Set document properties
17:48:55 Generate an image
17:48:55 Add a drawing to the worksheet
17:48:55 Write to Excel2007 format


============== TEST ==============
Test name: 26utf8.php

17:48:55 Load Excel2007 template file
17:48:55 Write to Excel5 format


============== TEST ==============
Test name: 27imagesexcel5.php

17:48:55 Load Excel2007 template file
17:48:55 Write to Excel5 format


============== TEST ==============
Test name: 28iterator.php

Please run 05featuredemo.php first.


============== TEST ==============
Test name: 29advancedvaluebinder.php

17:48:56 Set timezone
16:48:56 Set value binder
16:48:56 Create new PHPExcel object
16:48:56 Set document properties
16:48:56 Set default font
16:48:56 Set column widths
16:48:56 Add some data
16:48:56 Rename worksheet
16:48:56 Write to Excel5 format


============== TEST ==============
Test name: 30template.php

17:48:56 Load from Excel5 template
17:48:56 Add new data to the template
17:48:56 Write to Excel5 format


============== TEST ==============
Test name: 31docproperties_write.php

17:48:56 Load Tests from Excel2007 file
Call time to read Workbook was 0.0177 seconds
17:48:56 Current memory usage: 3.5 MB
17:48:56 Adjust properties
17:48:56 Write to Excel2007 format


============== TEST ==============
Test name: 31docproperties_write-xls.php

17:48:56 Load Tests from Excel5 file
Call time to read Workbook was 0.0213 seconds
17:48:56 Current memory usage: 4.25 MB
17:48:56 Adjust properties
17:48:56 Write to Excel5 format


============== TEST ==============
Test name: 32chartreadwrite.php

17:48:56 Load Test from Excel2007 file 32readwriteAreaChart1.xlsx
17:48:56 Iterate worksheets looking at the charts
Worksheet: Data
    chart1 - "Sales"
             areaChart
17:48:56 Write Tests to Excel2007 file 


============== TEST ==============
Test name: OOCalcReader.php

17:48:56 Load from OOCalc file
Call time to read Workbook was 0.0225 seconds
17:48:56 Current memory usage: 3.25 MB
17:48:56 Write to Excel2007 format


============== TEST ==============
Test name: SylkReader.php

17:48:56 Load from SYLK file
17:48:56 Write to Excel2007 format


============== TEST ==============
Test name: Excel2003XMLReader.php

17:48:56 Load from Excel2003XML file
Call time to read Workbook was 0.1785 seconds
17:48:56 Current memory usage: 4.25 MB
17:48:56 Write to Excel5 format


============== TEST ==============
Test name: XMLReader.php

17:48:56 Load from XML file
Loading XMLTest.xml using Excel2003XML Reader
17:48:56 Write to Excel2007 format


============== TEST ==============
Test name: GnumericReader.php

17:48:56 Load from Gnumeric file
Call time to read Workbook was 0.0743 seconds
17:48:57 Current memory usage: 5.25 MB
17:48:57 Write to Excel2007 format