Uses of Interface
org.zkoss.poi.ss.formula.functions.Function

Packages that use Function

Package	Description
org.zkoss.poi.ss.formula	This package contains common internal POI code for manipulating formulas.
org.zkoss.poi.ss.formula.eval
org.zkoss.poi.ss.formula.functions
org.zkoss.zssex.formula	Classes bridging ZK Spreadsheet formula functions to ZK EL functions.
org.zkoss.zssex.formula.fn	ZK EL functions implementation that realize ZK Spreadsheet formula functions.

Uses of Function in org.zkoss.poi.ss.formula

Methods in org.zkoss.poi.ss.formula with parameters of type Function

Modifier and Type	Method and Description
static void	WorkbookEvaluator.registerFunction(java.lang.String name, Function func) Register a function in runtime.

Uses of Function in org.zkoss.poi.ss.formula.eval

Classes in org.zkoss.poi.ss.formula.eval that implement Function

Modifier and Type	Class and Description
class	ConcatEval
class	IntersectionEval
class	PercentEval Implementation of Excel formula token '%'.
class	RangeEval
class	RelationalOperationEval Base class for all comparison operator evaluators
class	TwoOperandNumericOperation
static class	TwoOperandNumericOperation.MultiplyFunc
class	UnaryMinusEval
class	UnaryPlusEval

Fields in org.zkoss.poi.ss.formula.eval declared as Function

Modifier and Type	Field and Description
static Function	TwoOperandNumericOperation.AddEval
static Function	TwoOperandNumericOperation.DivideEval
static Function	RelationalOperationEval.EqualEval
protected static Function[]	FunctionEval.functions Array elements corresponding to unimplemented functions are null
static Function	RelationalOperationEval.GreaterEqualEval
static Function	RelationalOperationEval.GreaterThanEval
static Function	UnaryPlusEval.instance
static Function	UnaryMinusEval.instance
static Function	RangeEval.instance
static Function	PercentEval.instance
static Function	IntersectionEval.instance
static Function	ConcatEval.instance
static Function	RelationalOperationEval.LessEqualEval
static Function	RelationalOperationEval.LessThanEval
static Function	RelationalOperationEval.NotEqualEval
static Function	TwoOperandNumericOperation.PowerEval
static Function	TwoOperandNumericOperation.SubtractEval

Methods in org.zkoss.poi.ss.formula.eval that return Function

Modifier and Type	Method and Description
static Function	FunctionEval.getBasicFunction(int functionIndex)

Methods in org.zkoss.poi.ss.formula.eval with parameters of type Function

Modifier and Type	Method and Description
static void	FunctionEval.registerFunction(java.lang.String name, Function func) Register a new function in runtime.

Uses of Function in org.zkoss.poi.ss.formula.functions

Subinterfaces of Function in org.zkoss.poi.ss.formula.functions

Modifier and Type	Interface and Description
interface	Function0Arg Implemented by all functions that can be called with zero arguments
interface	Function1Arg Implemented by all functions that can be called with one argument
interface	Function2Arg Implemented by all functions that can be called with two arguments
interface	Function3Arg Implemented by all functions that can be called with three arguments
interface	Function4Arg Implemented by all functions that can be called with four arguments

Classes in org.zkoss.poi.ss.formula.functions that implement Function

Modifier and Type	Class and Description
class	Address Creates a text reference as text, given specified row and column numbers.
class	AggregateFunction
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.
static class	BooleanFunction.OneArg
class	CalendarFieldFunction Implementation of Excel functions Date parsing functions: Date - DAY, MONTH and YEAR Time - HOUR, MINUTE and SECOND
class	Choose
class	Column
class	Columns Implementation for Excel COLUMNS function.
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 Implementation for the function COUNTBLANK Syntax: COUNTBLANK ( range ) range is the range of cells to count blanks 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 DateFunc Implementation for the Excel function DATE class Days360 Calculates the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations. class Errortype Implementation for the ERROR.TYPE() Excel function. class Even class FinanceFunction class Fixed0ArgFunction Convenience base class for functions that only take zero arguments. class Fixed1ArgFunction Convenience base class for functions that must take exactly one argument. class Fixed2ArgFunction Convenience base class for functions that must take exactly two arguments. class Fixed3ArgFunction Convenience base class for functions that must take exactly three arguments. class Fixed4ArgFunction Convenience base class for functions that must take exactly four arguments. class Hlookup Implementation of the HLOOKUP() function. class Hyperlink Implementation of Excel HYPERLINK function. class IfFunc Implementation for the Excel function 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. default is 1 area_numused when reference is a union of areas class Irr Calculates the internal rate of return. class LogicalFunction class Lookup Implementation of Excel function LOOKUP. class Match Implementation for the MATCH() Excel function. class MinaMaxa class Mode class MultiOperandNumericFunction class Na Implementation of Excel function NA() class NotImplementedFunction class Now Implementation of Excel NOW() Function class Npv Calculates the net present value of an investment by using a discount rate and a series of future payments (negative values) and income (positive values). class NumericFunction 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. class OverridableFunction A Overridable function to provide the chance of override poi's basic functions class Rank Returns the rank of a number in a list of numbers. class Rate Implements the Excel Rate function 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. class RowFunc Implementation for the Excel function ROW class Rows Implementation for Excel ROWS function. class Substitute An implementation of the SUBSTITUTE function: Substitutes text in a text string with new text, some number of times. class Subtotal Implementation for the Excel function SUBTOTAL Syntax : SUBTOTAL ( functionCode, ref1, ref2 ... ) functionCode(1-11) Selects the underlying aggregate function to be used (see table below) ref1, ref2 ... class Sumif Implementation for the Excel function SUMIF Syntax : SUMIF ( range, criteria, sum_range ) rangeThe range over which criteria is applied. class Sumproduct Implementation for the Excel function SUMPRODUCT Syntax : SUMPRODUCT ( array1[, array2[, array3[, ...]]]) class Sumx2my2 Implementation of Excel function SUMX2MY2() Calculates the sum of differences of squares in two arrays of the same size. class Sumx2py2 Implementation of Excel function SUMX2PY2() Calculates the sum of squares in two arrays of the same size. class Sumxmy2 Implementation of Excel function SUMXMY2() Calculates the sum of squares of differences between two arrays of the same size. class T Implementation of Excel T() function If the argument is a text or error value it is returned unmodified. class TextFunction class TimeFunc Implementation for the Excel function TIME class Today Implementation of Excel TODAY() Function class Value Implementation for Excel VALUE() function. class Vlookup Implementation of the VLOOKUP() function. class WeekdayFunc Implementation for the Excel function WEEKDAY class XYNumericFunction Fields in org.zkoss.poi.ss.formula.functions declared as Function Modifier and Type Field and Description static Function NumericFunction.ABS static Function NumericFunction.ACOS static Function NumericFunction.ACOSH static Function BooleanFunction.AND 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 TextFunction.CHAR Returns the character specified by a number. static Function TextFunction.CLEAN An implementation of the CLEAN function: In Excel, the Clean function removes all non-printable characters from a string. 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 BooleanFunction.FALSE static Function TextFunction.FIND Implementation of the FIND() function. static Function NumericFunction.FLOOR static Function FinanceFunction.FV static Function CalendarFieldFunction.HOUR static Function WeekdayFunc.instance static Function DateFunc.instance static Function NumericFunction.INT static Function LogicalFunction.ISBLANK static Function LogicalFunction.ISERROR static Function LogicalFunction.ISLOGICAL static Function LogicalFunction.ISNA Implementation for Excel ISNA() function. static Function LogicalFunction.ISNONTEXT static Function LogicalFunction.ISNUMBER static Function LogicalFunction.ISREF static Function LogicalFunction.ISTEXT 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. static Function AggregateFunction.MIN static Function MinaMaxa.MINA static Function CalendarFieldFunction.MINUTE static Function NumericFunction.MOD static Function CalendarFieldFunction.MONTH static Function BooleanFunction.NOT static Function FinanceFunction.NPER static Function BooleanFunction.OR static Function NumericFunction.PI static Function FinanceFunction.PMT static Function NumericFunction.POISSON static Function NumericFunction.POWER static Function AggregateFunction.PRODUCT static Function FinanceFunction.PV static Function NumericFunction.RADIANS static Function NumericFunction.RAND static Function TextFunction.RIGHT static Function NumericFunction.ROUND static Function NumericFunction.ROUNDDOWN static Function NumericFunction.ROUNDUP static Function TextFunction.SEARCH Implementation of the FIND() function. static Function CalendarFieldFunction.SECOND 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.STDEVP static Function AggregateFunction.SUM static Function AggregateFunction.SUMSQ static Function NumericFunction.TAN static Function NumericFunction.TANH static Function TextFunction.TEXT An implementation of the TEXT function TEXT returns a number value formatted with the given number formatting string. 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 BooleanFunction.TRUE static Function NumericFunction.TRUNC static Function TextFunction.UPPER static Function AggregateFunction.VAR static Function AggregateFunction.VARP static Function CalendarFieldFunction.YEAR Constructors in org.zkoss.poi.ss.formula.functions with parameters of type Function Constructor and Description OverridableFunction(java.lang.String name, Function original) Uses of Function in org.zkoss.zssex.formula Classes in org.zkoss.zssex.formula that implement Function Modifier and Type Class and Description class ELEvalFunction This the default function that delegate the POI function call to EL tld function. Uses of Function in org.zkoss.zssex.formula.fn Fields in org.zkoss.zssex.formula.fn declared as Function Modifier and Type Field and Description static Function FinanceFunctionImpl.ACCRINT static Function FinanceFunctionImpl.ACCRINTM static Function FinanceFunctionImpl.AMORDEGRC static Function FinanceFunctionImpl.AMORLINC static Function StatFunctionImpl.AVERAGEA static Function EngineeringFunctionImpl.BESSELI static Function EngineeringFunctionImpl.BESSELJ static Function EngineeringFunctionImpl.BESSELK static Function EngineeringFunctionImpl.BESSELY static Function EngineeringFunctionImpl.BIN2DEC static Function EngineeringFunctionImpl.BIN2HEX static Function EngineeringFunctionImpl.BIN2OCT static Function StatFunctionImpl.BINOMDIST static Function TextFunctionImpl.CHAR static Function StatFunctionImpl.CHIDIST static Function StatFunctionImpl.CHIINV static Function TextFunctionImpl.CODE static Function EngineeringFunctionImpl.COMPLEX static Function FinanceFunctionImpl.COUPDAYBS static Function FinanceFunctionImpl.COUPDAYS static Function FinanceFunctionImpl.COUPDAYSNC static Function FinanceFunctionImpl.COUPNCD static Function FinanceFunctionImpl.COUPNUM static Function FinanceFunctionImpl.COUPPCD static Function FinanceFunctionImpl.CUMIPMT static Function FinanceFunctionImpl.CUMPRINC static Function DateTimeFunctionImpl.DATEVALUE static Function FinanceFunctionImpl.DB static Function FinanceFunctionImpl.DDB static Function EngineeringFunctionImpl.DEC2BIN static Function EngineeringFunctionImpl.DEC2HEX static Function EngineeringFunctionImpl.DEC2OCT static Function EngineeringFunctionImpl.DELTA static Function FinanceFunctionImpl.DISC static Function FinanceFunctionImpl.DOLLARDE static Function FinanceFunctionImpl.DOLLARFR static Function FinanceFunctionImpl.DURATION static Function FinanceFunctionImpl.EFFECT static Function DateTimeFunctionImpl.EOMONTH static Function EngineeringFunctionImpl.ERF static Function EngineeringFunctionImpl.ERFC static Function StatFunctionImpl.EXPONDIST static Function MathFunctionImpl.FACTDOUBLE static Function StatFunctionImpl.FDIST static Function StatFunctionImpl.FINV static Function TextFunctionImpl.FIXED static Function FinanceFunctionImpl.FVSCHEDULE static Function StatFunctionImpl.GAMMADIST static Function StatFunctionImpl.GAMMAINV static Function StatFunctionImpl.GAMMALN static Function MathFunctionImpl.GCD static Function StatFunctionImpl.GEOMEAN static Function EngineeringFunctionImpl.GESTEP static Function StatFunctionImpl.HARMEAN static Function EngineeringFunctionImpl.HEX2BIN static Function EngineeringFunctionImpl.HEX2DEC static Function EngineeringFunctionImpl.HEX2OCT static Function DateTimeFunctionImpl.HOUR static Function StatFunctionImpl.HYPGEOMDIST static Function LogicalFunctionImpl.IFERROR static Function EngineeringFunctionImpl.IMABS static Function EngineeringFunctionImpl.IMAGINARY static Function EngineeringFunctionImpl.IMARGUMENT static Function EngineeringFunctionImpl.IMCONJUGATE static Function EngineeringFunctionImpl.IMCOS static Function EngineeringFunctionImpl.IMDIV static Function EngineeringFunctionImpl.IMEXP static Function EngineeringFunctionImpl.IMLN static Function EngineeringFunctionImpl.IMLOG10 static Function EngineeringFunctionImpl.IMLOG2 static Function EngineeringFunctionImpl.IMPOWER static Function EngineeringFunctionImpl.IMPRODUCT static Function EngineeringFunctionImpl.IMREAL static Function EngineeringFunctionImpl.IMSIN static Function EngineeringFunctionImpl.IMSQRT static Function EngineeringFunctionImpl.IMSUB static Function EngineeringFunctionImpl.IMSUM static Function StatFunctionImpl.INTERCEPT static Function FinanceFunctionImpl.INTRATE static Function FinanceFunctionImpl.IPMT static Function InfoFunctionImpl.ISERR Excel 2007 help document: ISERR(value): Returns TRUE if value refers to any error value except #N/A static Function StatFunctionImpl.KURT static Function MathFunctionImpl.LCM static Function TextFunctionImpl.LEFTB static Function MathFunctionImpl.MDETERM static Function DateTimeFunctionImpl.MINUTE static Function MathFunctionImpl.MINVERSE static Function MathFunctionImpl.MMULT static Function MathFunctionImpl.MROUND static Function MathFunctionImpl.MULTINOMIAL static Function InfoFunctionImpl.N static Function FinanceFunctionImpl.NOMINAL static Function StatFunctionImpl.NORMDIST static Function FinanceFunctionImpl.NPV static Function EngineeringFunctionImpl.OCT2BIN static Function EngineeringFunctionImpl.OCT2DEC static Function EngineeringFunctionImpl.OCT2HEX static Function StatFunctionImpl.POISSON static Function FinanceFunctionImpl.PPMT static Function FinanceFunctionImpl.PRICE static Function FinanceFunctionImpl.PRICEDISC static Function FinanceFunctionImpl.PRICEMAT static Function TextFunctionImpl.PROPER static Function MathFunctionImpl.QUOTIENT static Function MathFunctionImpl.RANDBETWEEN static Function FinanceFunctionImpl.RECEIVED static Function TextFunctionImpl.REPLACE static Function TextFunctionImpl.REPLACEB static Function TextFunctionImpl.REPT static Function MathFunctionImpl.ROMAN static Function DateTimeFunctionImpl.SECOND static Function StatFunctionImpl.SKEW static Function FinanceFunctionImpl.SLN static Function StatFunctionImpl.SLOPE static Function MathFunctionImpl.SQRTPI static Function StatFunctionImpl.STDEV static Function StatFunctionImpl.STDEVP static Function TextFunctionImpl.SUBSTITUTE static Function FinanceFunctionImpl.SYD static Function FinanceFunctionImpl.TBILLEQ static Function FinanceFunctionImpl.TBILLPRICE static Function FinanceFunctionImpl.TBILLYIELD static Function StatFunctionImpl.TDIST static Function FinanceFunctionImpl.Temp static Function StatFunctionImpl.TINV static Function InfoFunctionImpl.TYPE static Function TextFunctionImpl.VALUE static Function StatFunctionImpl.VAR static Function StatFunctionImpl.VARP static Function DateTimeFunctionImpl.WEEKDAY static Function StatFunctionImpl.WEIBULL static Function FinanceFunctionImpl.XNPV static Function FinanceFunctionImpl.YIELD static Function FinanceFunctionImpl.YIELDDISC static Function FinanceFunctionImpl.YIELDMAT Skip navigation links Overview Package Class Use Tree Deprecated Index Help Prev Next Frames No Frames All Classes Copyright © 2005-2010 Potix Corporation. All Rights Reserved.