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