Uses of Interface
org.apache.poi.hssf.record.formula.functions.Function

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
          Implementation for Excel COLUMNS function.
 class Combin
           
 class Concatenate
           
 class Confidence
           
 class Correl
           
 class Cos
           
 class Cosh
           
 class Count
          Counts the number of cells that contain numeric data within the list of arguments.
 class Counta
          Counts the number of cells that contain data within the list of arguments.
 class Countblank
           
 class Countif
          Implementation for the function COUNTIF

Syntax: COUNTIF ( range, criteria )

range   is the range of cells to be counted based on the criteria criteriais used to determine which cells to count

 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
          Implementation of the HLOOKUP() function.

HLOOKUP finds a column in a lookup table by the first row value and returns the value from another row.
Syntax:
HLOOKUP(lookup_value, table_array, row_index_num, range_lookup)

lookup_value The value to be found in the first column of the table array.
table_array An area reference for the lookup data.

 class Hour
           
 class Hyperlink
           
 class Hypgeomdist
           
 class If
           
 class Index
          Implementation for the Excel function INDEX

Syntax :
INDEX ( reference, row_num[, column_num [, area_num]])
INDEX ( array, row_num[, column_num])

referencetypically an area reference, possibly a union of areas arraya literal array value (currently not supported) row_numselects the row within the array or area reference column_numselects column within the array or area reference.
 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
          Implementation of Excel function LOOKUP.

LOOKUP finds an index row in a lookup table by the first column value and returns the value from another column.

 class Lower
           
 class Match
          Implementation for the MATCH() Excel function.

Syntax:
MATCH(lookup_value, lookup_array, match_type)

Returns a 1-based index specifying at what position in the lookup_array the specified lookup_value is found.

Specific matching behaviour can be modified with the optional match_type parameter.

 class Max
           
 class Maxa
           
 class Mdeterm
           
 class Median
           
 class Mid
          An implementation of the MID function
MID returns a specific number of characters from a text string, starting at the specified position.

Syntax:
MID(text, start_num, num_chars)

 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
          Implementation of Excel function 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 Or
           
 class Pearson
           
 class Percentile
           
 class Percentrank
           
 class Permut
           
 class Pi
           
 class Pmt
          Implementation for the PMT() Excel function.

Syntax:
PMT(rate, nper, pv, fv, type)

Returns the constant repayment amount required for a loan assuming a constant interest rate.

rate the loan interest rate.
nper the number of loan repayments.
pv the present value of the future payments (or principle).
fv the future value (default zero) surplus cash at the end of the loan lifetime.
type whether payments are due at the beginning(1) or end(0 - default) of each payment period.

 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
          Implementation for Excel ROWS function.
 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
          Implementation for the Excel function SUMPRODUCT

Syntax :
SUMPRODUCT ( array1[, array2[, array3[, ...]]])

array1, ...
 class Sumsq
           
 class Sumx2my2
          Implementation of Excel function SUMX2MY2()

Calculates the sum of differences of squares in two arrays of the same size.
Syntax:
SUMX2MY2(arrayX, arrayY)

result = Σi: 0..n(xi2-yi2)

 class Sumx2py2
          Implementation of Excel function SUMX2PY2()

Calculates the sum of squares in two arrays of the same size.
Syntax:
SUMX2PY2(arrayX, arrayY)

result = Σi: 0..n(xi2+yi2)

 class Sumxmy2
          Implementation of Excel function SUMXMY2()

Calculates the sum of squares of differences between two arrays of the same size.
Syntax:
SUMXMY2(arrayX, arrayY)

result = Σi: 0..n(xi-yi)2

 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
          Implementation of the VLOOKUP() function.

VLOOKUP finds a row in a lookup table by the first column value and returns the value from another column.
Syntax:
VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

lookup_value The value to be found in the first column of the table array.
table_array An area reference for the lookup data.

 class Volatile
           
 class Weekday
           
 class Weibull
           
 class XYNumericFunction
           
 class Year
           
 class Ztest
           
 



Copyright 2008 The Apache Software Foundation or its licensors, as applicable.