Файл: protected/extensions/PHPExcel/Documentation/FunctionListByCategory.txt
Строк: 582
CATEGORY_CUBE
CUBEKPIMEMBER *** Not yet Implemented
CUBEMEMBER
*** Not yet Implemented
CUBEMEMBERPROPERTY *** Not yet
Implemented
CUBERANKEDMEMBER *** Not yet Implemented
CUBESET
*** Not yet Implemented
CUBESETCOUNT *** Not yet
Implemented
CUBEVALUE *** Not yet
Implemented
CATEGORY_DATABASE
DAVERAGE
PHPExcel_Calculation_Database::DAVERAGE
DCOUNT
PHPExcel_Calculation_Database::DCOUNT
DCOUNTA
PHPExcel_Calculation_Database::DCOUNTA
DGET
PHPExcel_Calculation_Database::DGET
DMAX
PHPExcel_Calculation_Database::DMAX
DMIN
PHPExcel_Calculation_Database::DMIN
DPRODUCT
PHPExcel_Calculation_Database::DPRODUCT
DSTDEV
PHPExcel_Calculation_Database::DSTDEV
DSTDEVP
PHPExcel_Calculation_Database::DSTDEVP
DSUM
PHPExcel_Calculation_Database::DSUM
DVAR
PHPExcel_Calculation_Database::DVAR
DVARP
PHPExcel_Calculation_Database::DVARP
CATEGORY_DATE_AND_TIME
DATE
PHPExcel_Calculation_DateTime::DATE
DATEDIF
PHPExcel_Calculation_DateTime::DATEDIF
DATEVALUE
PHPExcel_Calculation_DateTime::DATEVALUE
DAY
PHPExcel_Calculation_DateTime::DAYOFMONTH
DAYS360
PHPExcel_Calculation_DateTime::DAYS360
EDATE
PHPExcel_Calculation_DateTime::EDATE
EOMONTH
PHPExcel_Calculation_DateTime::EOMONTH
HOUR
PHPExcel_Calculation_DateTime::HOUROFDAY
MINUTE
PHPExcel_Calculation_DateTime::MINUTEOFHOUR
MONTH
PHPExcel_Calculation_DateTime::MONTHOFYEAR
NETWORKDAYS
PHPExcel_Calculation_DateTime::NETWORKDAYS
NOW
PHPExcel_Calculation_DateTime::DATETIMENOW
SECOND
PHPExcel_Calculation_DateTime::SECONDOFMINUTE
TIME
PHPExcel_Calculation_DateTime::TIME
TIMEVALUE
PHPExcel_Calculation_DateTime::TIMEVALUE
TODAY
PHPExcel_Calculation_DateTime::DATENOW
WEEKDAY
PHPExcel_Calculation_DateTime::DAYOFWEEK
WEEKNUM
PHPExcel_Calculation_DateTime::WEEKOFYEAR
WORKDAY
PHPExcel_Calculation_DateTime::WORKDAY
YEAR
PHPExcel_Calculation_DateTime::YEAR
YEARFRAC
PHPExcel_Calculation_DateTime::YEARFRAC
CATEGORY_ENGINEERING
BESSELI
PHPExcel_Calculation_Engineering::BESSELI
BESSELJ
PHPExcel_Calculation_Engineering::BESSELJ
BESSELK
PHPExcel_Calculation_Engineering::BESSELK
BESSELY
PHPExcel_Calculation_Engineering::BESSELY
BIN2DEC
PHPExcel_Calculation_Engineering::BINTODEC
BIN2HEX
PHPExcel_Calculation_Engineering::BINTOHEX
BIN2OCT
PHPExcel_Calculation_Engineering::BINTOOCT
COMPLEX
PHPExcel_Calculation_Engineering::COMPLEX
CONVERT
PHPExcel_Calculation_Engineering::CONVERTUOM
DEC2BIN
PHPExcel_Calculation_Engineering::DECTOBIN
DEC2HEX
PHPExcel_Calculation_Engineering::DECTOHEX
DEC2OCT
PHPExcel_Calculation_Engineering::DECTOOCT
DELTA
PHPExcel_Calculation_Engineering::DELTA
ERF
PHPExcel_Calculation_Engineering::ERF
ERFC
PHPExcel_Calculation_Engineering::ERFC
GESTEP
PHPExcel_Calculation_Engineering::GESTEP
HEX2BIN
PHPExcel_Calculation_Engineering::HEXTOBIN
HEX2DEC
PHPExcel_Calculation_Engineering::HEXTODEC
HEX2OCT
PHPExcel_Calculation_Engineering::HEXTOOCT
IMABS
PHPExcel_Calculation_Engineering::IMABS
IMAGINARY
PHPExcel_Calculation_Engineering::IMAGINARY
IMARGUMENT
PHPExcel_Calculation_Engineering::IMARGUMENT
IMCONJUGATE
PHPExcel_Calculation_Engineering::IMCONJUGATE
IMCOS
PHPExcel_Calculation_Engineering::IMCOS
IMDIV
PHPExcel_Calculation_Engineering::IMDIV
IMEXP
PHPExcel_Calculation_Engineering::IMEXP
IMLN
PHPExcel_Calculation_Engineering::IMLN
IMLOG10
PHPExcel_Calculation_Engineering::IMLOG10
IMLOG2
PHPExcel_Calculation_Engineering::IMLOG2
IMPOWER
PHPExcel_Calculation_Engineering::IMPOWER
IMPRODUCT
PHPExcel_Calculation_Engineering::IMPRODUCT
IMREAL
PHPExcel_Calculation_Engineering::IMREAL
IMSIN
PHPExcel_Calculation_Engineering::IMSIN
IMSQRT
PHPExcel_Calculation_Engineering::IMSQRT
IMSUB
PHPExcel_Calculation_Engineering::IMSUB
IMSUM
PHPExcel_Calculation_Engineering::IMSUM
OCT2BIN
PHPExcel_Calculation_Engineering::OCTTOBIN
OCT2DEC
PHPExcel_Calculation_Engineering::OCTTODEC
OCT2HEX
PHPExcel_Calculation_Engineering::OCTTOHEX
CATEGORY_FINANCIAL
ACCRINT
PHPExcel_Calculation_Financial::ACCRINT
ACCRINTM
PHPExcel_Calculation_Financial::ACCRINTM
AMORDEGRC
PHPExcel_Calculation_Financial::AMORDEGRC
AMORLINC
PHPExcel_Calculation_Financial::AMORLINC
COUPDAYBS
PHPExcel_Calculation_Financial::COUPDAYBS
COUPDAYS
PHPExcel_Calculation_Financial::COUPDAYS
COUPDAYSNC
PHPExcel_Calculation_Financial::COUPDAYSNC
COUPNCD
PHPExcel_Calculation_Financial::COUPNCD
COUPNUM
PHPExcel_Calculation_Financial::COUPNUM
COUPPCD
PHPExcel_Calculation_Financial::COUPPCD
CUMIPMT
PHPExcel_Calculation_Financial::CUMIPMT
CUMPRINC
PHPExcel_Calculation_Financial::CUMPRINC
DB
PHPExcel_Calculation_Financial::DB
DDB
PHPExcel_Calculation_Financial::DDB
DISC
PHPExcel_Calculation_Financial::DISC
DOLLARDE
PHPExcel_Calculation_Financial::DOLLARDE
DOLLARFR
PHPExcel_Calculation_Financial::DOLLARFR
DURATION *** Not
yet Implemented
EFFECT
PHPExcel_Calculation_Financial::EFFECT
FV
PHPExcel_Calculation_Financial::FV
FVSCHEDULE
PHPExcel_Calculation_Financial::FVSCHEDULE
INTRATE
PHPExcel_Calculation_Financial::INTRATE
IPMT
PHPExcel_Calculation_Financial::IPMT
IRR
PHPExcel_Calculation_Financial::IRR
ISPMT
PHPExcel_Calculation_Financial::ISPMT
MDURATION *** Not yet
Implemented
MIRR
PHPExcel_Calculation_Financial::MIRR
NOMINAL
PHPExcel_Calculation_Financial::NOMINAL
NPER
PHPExcel_Calculation_Financial::NPER
NPV
PHPExcel_Calculation_Financial::NPV
ODDFPRICE *** Not yet
Implemented
ODDFYIELD *** Not yet Implemented
ODDLPRICE
*** Not yet Implemented
ODDLYIELD *** Not yet
Implemented
PMT
PHPExcel_Calculation_Financial::PMT
PPMT
PHPExcel_Calculation_Financial::PPMT
PRICE
PHPExcel_Calculation_Financial::PRICE
PRICEDISC
PHPExcel_Calculation_Financial::PRICEDISC
PRICEMAT
PHPExcel_Calculation_Financial::PRICEMAT
PV
PHPExcel_Calculation_Financial::PV
RATE
PHPExcel_Calculation_Financial::RATE
RECEIVED
PHPExcel_Calculation_Financial::RECEIVED
SLN
PHPExcel_Calculation_Financial::SLN
SYD
PHPExcel_Calculation_Financial::SYD
TBILLEQ
PHPExcel_Calculation_Financial::TBILLEQ
TBILLPRICE
PHPExcel_Calculation_Financial::TBILLPRICE
TBILLYIELD
PHPExcel_Calculation_Financial::TBILLYIELD
USDOLLAR ***
Not yet Implemented
VDB *** Not yet Implemented
XIRR
PHPExcel_Calculation_Financial::XIRR
XNPV
PHPExcel_Calculation_Financial::XNPV
YIELD *** Not
yet Implemented
YIELDDISC
PHPExcel_Calculation_Financial::YIELDDISC
YIELDMAT
PHPExcel_Calculation_Financial::YIELDMAT
CATEGORY_INFORMATION
CELL
*** Not yet Implemented
ERROR.TYPE
PHPExcel_Calculation_Functions::ERROR_TYPE
INFO ***
Not yet Implemented
ISBLANK
PHPExcel_Calculation_Functions::IS_BLANK
ISERR
PHPExcel_Calculation_Functions::IS_ERR
ISERROR
PHPExcel_Calculation_Functions::IS_ERROR
ISEVEN
PHPExcel_Calculation_Functions::IS_EVEN
ISLOGICAL
PHPExcel_Calculation_Functions::IS_LOGICAL
ISNA
PHPExcel_Calculation_Functions::IS_NA
ISNONTEXT
PHPExcel_Calculation_Functions::IS_NONTEXT
ISNUMBER
PHPExcel_Calculation_Functions::IS_NUMBER
ISODD
PHPExcel_Calculation_Functions::IS_ODD
ISREF *** Not
yet Implemented
ISTEXT
PHPExcel_Calculation_Functions::IS_TEXT
N
PHPExcel_Calculation_Functions::N
NA
PHPExcel_Calculation_Functions::NA
TYPE
PHPExcel_Calculation_Functions::TYPE
VERSION
PHPExcel_Calculation_Functions::VERSION
CATEGORY_LOGICAL
AND
PHPExcel_Calculation_Logical::LOGICAL_AND
FALSE
PHPExcel_Calculation_Logical::FALSE
IF
PHPExcel_Calculation_Logical::STATEMENT_IF
IFERROR
PHPExcel_Calculation_Logical::IFERROR
NOT
PHPExcel_Calculation_Logical::NOT
OR
PHPExcel_Calculation_Logical::LOGICAL_OR
TRUE
PHPExcel_Calculation_Logical::TRUE
CATEGORY_LOOKUP_AND_REFERENCE
ADDRESS
PHPExcel_Calculation_LookupRef::CELL_ADDRESS
AREAS
*** Not yet Implemented
CHOOSE
PHPExcel_Calculation_LookupRef::CHOOSE
COLUMN
PHPExcel_Calculation_LookupRef::COLUMN
COLUMNS
PHPExcel_Calculation_LookupRef::COLUMNS
GETPIVOTDATA *** Not
yet Implemented
HLOOKUP
PHPExcel_Calculation_LookupRef::HLOOKUP
HYPERLINK
PHPExcel_Calculation_LookupRef::HYPERLINK
INDEX
PHPExcel_Calculation_LookupRef::INDEX
INDIRECT
PHPExcel_Calculation_LookupRef::INDIRECT
LOOKUP
PHPExcel_Calculation_LookupRef::LOOKUP
MATCH
PHPExcel_Calculation_LookupRef::MATCH
OFFSET
PHPExcel_Calculation_LookupRef::OFFSET
ROW
PHPExcel_Calculation_LookupRef::ROW
ROWS
PHPExcel_Calculation_LookupRef::ROWS
RTD *** Not yet
Implemented
TRANSPOSE
PHPExcel_Calculation_LookupRef::TRANSPOSE
VLOOKUP
PHPExcel_Calculation_LookupRef::VLOOKUP
CATEGORY_MATH_AND_TRIG
ABS
abs
ACOS acos
ACOSH
acosh
ASIN asin
ASINH asinh
ATAN
atan
ATAN2
PHPExcel_Calculation_MathTrig::REVERSE_ATAN2
ATANH
atanh
CEILING
PHPExcel_Calculation_MathTrig::CEILING
COMBIN
PHPExcel_Calculation_MathTrig::COMBIN
COS cos
COSH
cosh
DEGREES rad2deg
EVEN
PHPExcel_Calculation_MathTrig::EVEN
EXP exp
FACT
PHPExcel_Calculation_MathTrig::FACT
FACTDOUBLE
PHPExcel_Calculation_MathTrig::FACTDOUBLE
FLOOR
PHPExcel_Calculation_MathTrig::FLOOR
GCD
PHPExcel_Calculation_MathTrig::GCD
INT
PHPExcel_Calculation_MathTrig::INT
LCM
PHPExcel_Calculation_MathTrig::LCM
LN log
LOG
PHPExcel_Calculation_MathTrig::LOG_BASE
LOG10
log10
MDETERM
PHPExcel_Calculation_MathTrig::MDETERM
MINVERSE
PHPExcel_Calculation_MathTrig::MINVERSE
MMULT
PHPExcel_Calculation_MathTrig::MMULT
MOD
PHPExcel_Calculation_MathTrig::MOD
MROUND
PHPExcel_Calculation_MathTrig::MROUND
MULTINOMIAL
PHPExcel_Calculation_MathTrig::MULTINOMIAL
ODD
PHPExcel_Calculation_MathTrig::ODD
PI pi
POWER
PHPExcel_Calculation_MathTrig::POWER
PRODUCT
PHPExcel_Calculation_MathTrig::PRODUCT
QUOTIENT
PHPExcel_Calculation_MathTrig::QUOTIENT
RADIANS
deg2rad
RAND
PHPExcel_Calculation_MathTrig::RAND
RANDBETWEEN
PHPExcel_Calculation_MathTrig::RAND
ROMAN
PHPExcel_Calculation_MathTrig::ROMAN
ROUND
round
ROUNDDOWN
PHPExcel_Calculation_MathTrig::ROUNDDOWN
ROUNDUP
PHPExcel_Calculation_MathTrig::ROUNDUP
SERIESSUM
PHPExcel_Calculation_MathTrig::SERIESSUM
SIGN
PHPExcel_Calculation_MathTrig::SIGN
SIN sin
SINH
sinh
SQRT sqrt
SQRTPI
PHPExcel_Calculation_MathTrig::SQRTPI
SUBTOTAL
PHPExcel_Calculation_MathTrig::SUBTOTAL
SUM
PHPExcel_Calculation_MathTrig::SUM
SUMIF
PHPExcel_Calculation_MathTrig::SUMIF
SUMIFS *** Not yet
Implemented
SUMPRODUCT
PHPExcel_Calculation_MathTrig::SUMPRODUCT
SUMSQ
PHPExcel_Calculation_MathTrig::SUMSQ
SUMX2MY2
PHPExcel_Calculation_MathTrig::SUMX2MY2
SUMX2PY2
PHPExcel_Calculation_MathTrig::SUMX2PY2
SUMXMY2
PHPExcel_Calculation_MathTrig::SUMXMY2
TAN tan
TANH
tanh
TRUNC
PHPExcel_Calculation_MathTrig::TRUNC
CATEGORY_STATISTICAL
AVEDEV
PHPExcel_Calculation_Statistical::AVEDEV
AVERAGE
PHPExcel_Calculation_Statistical::AVERAGE
AVERAGEA
PHPExcel_Calculation_Statistical::AVERAGEA
AVERAGEIF
PHPExcel_Calculation_Statistical::AVERAGEIF
AVERAGEIFS ***
Not yet Implemented
BETADIST
PHPExcel_Calculation_Statistical::BETADIST
BETAINV
PHPExcel_Calculation_Statistical::BETAINV
BINOMDIST
PHPExcel_Calculation_Statistical::BINOMDIST
CHIDIST
PHPExcel_Calculation_Statistical::CHIDIST
CHIINV
PHPExcel_Calculation_Statistical::CHIINV
CHITEST *** Not
yet Implemented
CONFIDENCE
PHPExcel_Calculation_Statistical::CONFIDENCE
CORREL
PHPExcel_Calculation_Statistical::CORREL
COUNT
PHPExcel_Calculation_Statistical::COUNT
COUNTA
PHPExcel_Calculation_Statistical::COUNTA
COUNTBLANK
PHPExcel_Calculation_Statistical::COUNTBLANK
COUNTIF
PHPExcel_Calculation_Statistical::COUNTIF
COUNTIFS *** Not
yet Implemented
COVAR
PHPExcel_Calculation_Statistical::COVAR
CRITBINOM
PHPExcel_Calculation_Statistical::CRITBINOM
DEVSQ
PHPExcel_Calculation_Statistical::DEVSQ
EXPONDIST
PHPExcel_Calculation_Statistical::EXPONDIST
FDIST ***
Not yet Implemented
FINV *** Not yet
Implemented
FISHER
PHPExcel_Calculation_Statistical::FISHER
FISHERINV
PHPExcel_Calculation_Statistical::FISHERINV
FORECAST
PHPExcel_Calculation_Statistical::FORECAST
FREQUENCY ***
Not yet Implemented
FTEST *** Not yet
Implemented
GAMMADIST
PHPExcel_Calculation_Statistical::GAMMADIST
GAMMAINV
PHPExcel_Calculation_Statistical::GAMMAINV
GAMMALN
PHPExcel_Calculation_Statistical::GAMMALN
GEOMEAN
PHPExcel_Calculation_Statistical::GEOMEAN
GROWTH
PHPExcel_Calculation_Statistical::GROWTH
HARMEAN
PHPExcel_Calculation_Statistical::HARMEAN
HYPGEOMDIST
PHPExcel_Calculation_Statistical::HYPGEOMDIST
INTERCEPT
PHPExcel_Calculation_Statistical::INTERCEPT
KURT
PHPExcel_Calculation_Statistical::KURT
LARGE
PHPExcel_Calculation_Statistical::LARGE
LINEST
PHPExcel_Calculation_Statistical::LINEST
LOGEST
PHPExcel_Calculation_Statistical::LOGEST
LOGINV
PHPExcel_Calculation_Statistical::LOGINV
LOGNORMDIST
PHPExcel_Calculation_Statistical::LOGNORMDIST
MAX
PHPExcel_Calculation_Statistical::MAX
MAXA
PHPExcel_Calculation_Statistical::MAXA
MAXIF
PHPExcel_Calculation_Statistical::MAXIF
MEDIAN
PHPExcel_Calculation_Statistical::MEDIAN
MEDIANIF *** Not
yet Implemented
MIN
PHPExcel_Calculation_Statistical::MIN
MINA
PHPExcel_Calculation_Statistical::MINA
MINIF
PHPExcel_Calculation_Statistical::MINIF
MODE
PHPExcel_Calculation_Statistical::MODE
NEGBINOMDIST
PHPExcel_Calculation_Statistical::NEGBINOMDIST
NORMDIST
PHPExcel_Calculation_Statistical::NORMDIST
NORMINV
PHPExcel_Calculation_Statistical::NORMINV
NORMSDIST
PHPExcel_Calculation_Statistical::NORMSDIST
NORMSINV
PHPExcel_Calculation_Statistical::NORMSINV
PEARSON
PHPExcel_Calculation_Statistical::CORREL
PERCENTILE
PHPExcel_Calculation_Statistical::PERCENTILE
PERCENTRANK
PHPExcel_Calculation_Statistical::PERCENTRANK
PERMUT
PHPExcel_Calculation_Statistical::PERMUT
POISSON
PHPExcel_Calculation_Statistical::POISSON
PROB *** Not
yet Implemented
QUARTILE
PHPExcel_Calculation_Statistical::QUARTILE
RANK
PHPExcel_Calculation_Statistical::RANK
RSQ
PHPExcel_Calculation_Statistical::RSQ
SKEW
PHPExcel_Calculation_Statistical::SKEW
SLOPE
PHPExcel_Calculation_Statistical::SLOPE
SMALL
PHPExcel_Calculation_Statistical::SMALL
STANDARDIZE
PHPExcel_Calculation_Statistical::STANDARDIZE
STDEV
PHPExcel_Calculation_Statistical::STDEV
STDEVA
PHPExcel_Calculation_Statistical::STDEVA
STDEVP
PHPExcel_Calculation_Statistical::STDEVP
STDEVPA
PHPExcel_Calculation_Statistical::STDEVPA
STEYX
PHPExcel_Calculation_Statistical::STEYX
TDIST
PHPExcel_Calculation_Statistical::TDIST
TINV
PHPExcel_Calculation_Statistical::TINV
TREND
PHPExcel_Calculation_Statistical::TREND
TRIMMEAN
PHPExcel_Calculation_Statistical::TRIMMEAN
TTEST ***
Not yet Implemented
VAR
PHPExcel_Calculation_Statistical::VARFunc
VARA
PHPExcel_Calculation_Statistical::VARA
VARP
PHPExcel_Calculation_Statistical::VARP
VARPA
PHPExcel_Calculation_Statistical::VARPA
WEIBULL
PHPExcel_Calculation_Statistical::WEIBULL
ZTEST
PHPExcel_Calculation_Statistical::ZTEST
CATEGORY_TEXT_AND_DATA
ASC
*** Not yet Implemented
BAHTTEXT *** Not yet
Implemented
CHAR
PHPExcel_Calculation_TextData::CHARACTER
CLEAN
PHPExcel_Calculation_TextData::TRIMNONPRINTABLE
CODE
PHPExcel_Calculation_TextData::ASCIICODE
CONCATENATE
PHPExcel_Calculation_TextData::CONCATENATE
DOLLAR
PHPExcel_Calculation_TextData::DOLLAR
EXACT *** Not yet
Implemented
FIND
PHPExcel_Calculation_TextData::SEARCHSENSITIVE
FINDB
PHPExcel_Calculation_TextData::SEARCHSENSITIVE
FIXED
PHPExcel_Calculation_TextData::FIXEDFORMAT
JIS ***
Not yet Implemented
LEFT
PHPExcel_Calculation_TextData::LEFT
LEFTB
PHPExcel_Calculation_TextData::LEFT
LEN
PHPExcel_Calculation_TextData::STRINGLENGTH
LENB
PHPExcel_Calculation_TextData::STRINGLENGTH
LOWER
PHPExcel_Calculation_TextData::LOWERCASE
MID
PHPExcel_Calculation_TextData::MID
MIDB
PHPExcel_Calculation_TextData::MID
PHONETIC *** Not yet
Implemented
PROPER
PHPExcel_Calculation_TextData::PROPERCASE
REPLACE
PHPExcel_Calculation_TextData::REPLACE
REPLACEB
PHPExcel_Calculation_TextData::REPLACE
REPT
str_repeat
RIGHT
PHPExcel_Calculation_TextData::RIGHT
RIGHTB
PHPExcel_Calculation_TextData::RIGHT
SEARCH
PHPExcel_Calculation_TextData::SEARCHINSENSITIVE
SEARCHB
PHPExcel_Calculation_TextData::SEARCHINSENSITIVE
SUBSTITUTE
PHPExcel_Calculation_TextData::SUBSTITUTE
T
PHPExcel_Calculation_TextData::RETURNSTRING
TEXT
PHPExcel_Calculation_TextData::TEXTFORMAT
TRIM
PHPExcel_Calculation_TextData::TRIMSPACES
UPPER
PHPExcel_Calculation_TextData::UPPERCASE
VALUE
PHPExcel_Calculation_TextData::VALUE