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 Absref
           
 class Activecell
           
 class Address
           
 class AggregateFunction
           
 class And
           
 class Areas
           
 class Argument
           
 class Asc
           
 class Averagea
           
 class Betadist
           
 class Betainv
           
 class Binomdist
           
 class BooleanFunction
          Here are the general rules concerning Boolean functions: Blanks are ignored (not either true or false) Strings are ignored if part of an area ref or cell ref, otherwise they must be 'true' or 'false' Numbers: 0 is false.
 class CalendarFieldFunction
          Implementation of Excel functions DAY, MONTH and YEAR
 class Call
           
 class Caller
           
 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 Confidence
           
 class Correl
           
 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 Datedif
           
 class DateFunc
           
 class Datestring
           
 class Datevalue
           
 class Daverage
           
 class Days360
           
 class Db
           
 class Dbcs
           
 class Dcount
           
 class Dcounta
           
 class Ddb
           
 class Deref
           
 class Dget
           
 class Dmax
           
 class Dmin
           
 class Dproduct
           
 class Dstdev
           
 class Dstdevp
           
 class Dsum
           
 class Dvar
           
 class Dvarp
           
 class Echo
           
 class Error
           
 class Errortype
          Implementation for the ERROR.TYPE() Excel function.

Syntax:
ERROR.TYPE(errorValue)

Returns a number corresponding to the error type of the supplied argument.

errorValueReturn Value #NULL!1 #DIV/0!2 #VALUE!3 #REF!4 #NAME?5 #NUM!6 #N/A!7 everything else#N/A! Note - the results of ERROR.TYPE() are different to the constants defined in HSSFErrorConstants.
 class Evaluate
           
 class Even
           
 class Exec
           
 class Expondist
           
 class False
           
 class Fdist
           
 class Files
           
 class FinanceFunction
           
 class Find
           
 class Findb
           
 class Finv
           
 class Fisher
           
 class Fisherinv
           
 class Fixed
           
 class Forecast
           
 class Formulaconvert
           
 class Fpos
           
 class Frequency
           
 class Ftest
           
 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 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 Lasterror
           
 class Leftb
           
 class Lenb
           
 class Linest
           
 class Links
           
 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 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 Mdeterm
           
 class Midb
           
 class MinaMaxa
           
 class Minute
           
 class Minverse
           
 class Mirr
           
 class Mmult
           
 class Mode
           
 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
          Implementation of Excel NOW() Function
 class Npv
           
 class Numberstring
           
 class NumericFunction
           
static class NumericFunction.MultiArg
           
static class NumericFunction.OneArg
           
static class NumericFunction.TwoArg
           
 class Odd
           
 class Offset
          Implementation for Excel function OFFSET()

OFFSET returns an area reference that is a specified number of rows and columns from a reference cell or area.

Syntax:
OFFSET(reference, rows, cols, height, width)

reference is the base reference.
rows is the number of rows up or down from the base reference.
cols is the number of columns left or right from the base reference.
height (default same height as base reference) is the row count for the returned area reference.
width (default same width as base reference) is the column count for the returned area reference.

 class Or
           
 class Pearson
           
 class Percentile
           
 class Percentrank
           
 class Permut
           
 class Pi
           
 class Poisson
           
 class Ppmt
           
 class Prob
           
 class Proper
           
 class Quartile
           
 class Rand
           
 class Rank
           
 class Rate
           
 class Reftext
           
 class Relref
           
 class Replace
          An implementation of the Excel REPLACE() function

: Replaces part of a text string based on the number of characters you specify, with another text string.
Syntax:
REPLACE(oldText, startNum, numChars, newText)

oldText The text string containing characters to replace
startNum The position of the first character to replace (1-based)
numChars The number of characters to replace
newText The new text value to replace the removed section

 class Replaceb
           
 class Rept
           
 class Request
           
 class Result
           
 class Rightb
           
 class Roman
           
 class Row
           
 class Rows
          Implementation for Excel ROWS function.
 class Rsq
           
 class Search
           
 class Searchb
           
 class Second
           
 class Series
           
 class Setname
           
 class Setvalue
           
 class Skew
           
 class Sln
           
 class Slope
           
 class Standardize
           
 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 Sumif
           
 class Sumproduct
          Implementation for the Excel function SUMPRODUCT

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

array1, ...
 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 Tdist
           
 class Text
           
 class TextFunction
           
 class Textref
           
 class Time
           
 class Timevalue
           
 class Tinv
           
 class Today
          Implementation of Excel TODAY() Function
 class Transpose
           
 class Trend
           
 class Trimmean
           
 class True
           
 class Trunc
           
 class Ttest
           
 class Type
           
 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 Ztest
           
 

Fields in org.apache.poi.hssf.record.formula.functions declared as Function
static Function NumericFunction.ABS
           
static Function NumericFunction.ACOS
           
static Function NumericFunction.ACOSH
           
static Function NumericFunction.ASIN
           
static Function NumericFunction.ASINH
           
static Function NumericFunction.ATAN
           
static Function NumericFunction.ATAN2
           
static Function NumericFunction.ATANH
           
static Function AggregateFunction.AVEDEV
           
static Function AggregateFunction.AVERAGE
           
static Function NumericFunction.CEILING
           
static Function NumericFunction.COMBIN
           
static Function TextFunction.CONCATENATE
           
static Function NumericFunction.COS
           
static Function NumericFunction.COSH
           
static Function CalendarFieldFunction.DAY
           
static Function NumericFunction.DEGREES
           
static Function AggregateFunction.DEVSQ
           
static Function NumericFunction.DOLLAR
           
static Function TextFunction.EXACT
           
static Function NumericFunction.EXP
           
static Function NumericFunction.FACT
           
static Function NumericFunction.FLOOR
           
static Function FinanceFunction.FV
           
static Function DateFunc.instance
           
static Function NumericFunction.INT
           
static Function AggregateFunction.LARGE
           
static Function TextFunction.LEFT
           
static Function TextFunction.LEN
           
static Function NumericFunction.LN
           
static Function NumericFunction.LOG
           
static Function NumericFunction.LOG10
           
static Function TextFunction.LOWER
           
static Function AggregateFunction.MAX
           
static Function MinaMaxa.MAXA
           
static Function AggregateFunction.MEDIAN
           
static Function TextFunction.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)

static Function AggregateFunction.MIN
           
static Function MinaMaxa.MINA
           
static Function NumericFunction.MOD
           
static Function CalendarFieldFunction.MONTH
           
static Function FinanceFunction.NPER
           
static Function FinanceFunction.PMT
           
static Function NumericFunction.POWER
           
static Function AggregateFunction.PRODUCT
           
static Function FinanceFunction.PV
           
static Function NumericFunction.RADIANS
           
static Function TextFunction.RIGHT
           
static Function NumericFunction.ROUND
           
static Function NumericFunction.ROUNDDOWN
           
static Function NumericFunction.ROUNDUP
           
static Function NumericFunction.SIGN
           
static Function NumericFunction.SIN
           
static Function NumericFunction.SINH
           
static Function AggregateFunction.SMALL
           
static Function NumericFunction.SQRT
           
static Function AggregateFunction.STDEV
           
static Function AggregateFunction.SUM
           
static Function AggregateFunction.SUMSQ
           
static Function NumericFunction.TAN
           
static Function NumericFunction.TANH
           
static Function TextFunction.TRIM
          An implementation of the TRIM function: Removes leading and trailing spaces from value if evaluated operand value is string.
static Function TextFunction.UPPER
           
static Function CalendarFieldFunction.YEAR
           
 



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