Overview
Package
Class
Use
Tree
Deprecated
Index
Help
PREV PACKAGE
NEXT PACKAGE
FRAMES
NO FRAMES
All Classes
Package org.apache.poi.hssf.record.formula.functions
Interface Summary
Function
Class Summary
Abs
Absref
Acos
Acosh
Activecell
Address
And
Areas
Argument
Asc
Asin
Asinh
Atan
Atan2
Atanh
Avedev
Average
Averagea
Betadist
Betainv
Binomdist
BooleanFunction
Call
Caller
Ceiling
Cell
Char
Chidist
Chiinv
Chitest
Choose
Clean
Code
Column
Columns
Combin
Concatenate
Confidence
Correl
Cos
Cosh
Count
Counta
Countblank
Countif
Covar
Critbinom
Customrepeat
Date
Datedif
Datestring
Datevalue
Daverage
Day
Days360
Db
Dbcs
Dcount
Dcounta
Ddb
Degrees
Deref
Devsq
Dget
Dmax
Dmin
Dollar
Dproduct
Dstdev
Dstdevp
Dsum
Dvar
Dvarp
Echo
Error
Errortype
Evaluate
Even
Exact
Exec
Exp
Expondist
Fact
False
Fdist
Files
FinanceFunction
FinanceLib
Find
Findb
Finv
Fisher
Fisherinv
Fixed
Floor
Forecast
Formulaconvert
Fpos
Frequency
Ftest
Fv
Gammadist
Gammainv
Gammaln
Geomean
Goto
Group
Growth
Halt
Harmean
Help
Hlookup
Hour
Hyperlink
Hypgeomdist
If
Index
Indirect
Info
Initiate
Input
Int
Intercept
Ipmt
Irr
Isblank
Iserr
IsError
Islogical
IsNa
Isnontext
Isnumber
Ispmt
Isref
Istext
Kurt
Large
Lasterror
Left
Leftb
Len
Lenb
Linest
Links
Ln
Log
Log10
Logest
LogicalFunction
Loginv
Lognormdist
Lookup
Lower
Match
MathX
Max
Maxa
Mdeterm
Median
Mid
An implementation of the MID function: Returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.
Midb
Min
Mina
Minute
Minverse
Mirr
Mmult
Mod
Mode
Month
MultiOperandNumericFunction
N
Na
Names
Negbinomdist
Normdist
Norminv
Normsdist
Normsinv
Not
Note
NotImplementedFunction
Now
Nper
Npv
Numberstring
NumericFunction
Odd
Offset
Or
Pearson
Percentile
Percentrank
Permut
Pi
Pmt
Poisson
Power
Ppmt
Prob
Product
Proper
Pv
Quartile
Radians
Rand
Rank
Rate
Reftext
Relref
Replace
An implementation of the REPLACE function: Replaces part of a text string based on the number of characters you specify, with another text string.
Replaceb
Rept
Request
Result
Right
Rightb
Roman
Round
Rounddown
Roundup
Row
Rows
Rsq
Search
Searchb
Second
Series
Setname
Setvalue
Sign
Sin
Sinh
Skew
Sln
Slope
Small
Sqrt
Standardize
StatsLib
Stdev
Stdeva
Stdevp
Stdevpa
Step
Steyx
Substitute
An implementation of the SUBSTITUTE function: Substitutes text in a text string with new text, some number of times.
Subtotal
Sum
Sumif
Sumproduct
Sumsq
Sumx2my2
Sumx2py2
Sumxmy2
Syd
T
Tan
Tanh
Tdist
Text
TextFunction
Textref
Time
Timevalue
Tinv
Today
Transpose
Trend
Trim
An implementation of the TRIM function: Removes leading and trailing spaces from value if evaluated operand value is string.
Trimmean
True
Trunc
Ttest
Type
Upper
Usdollar
Value
Var
Vara
Varp
Varpa
Vdb
Vlookup
Volatile
Weekday
Weibull
XYNumericFunction
Year
Ztest
Overview
Package
Class
Use
Tree
Deprecated
Index
Help
PREV PACKAGE
NEXT PACKAGE
FRAMES
NO FRAMES
All Classes
Copyright 2008 The Apache Software Foundation or its licensors, as applicable.