org.zkoss.poi.ss.formula.functions

Interface Function

All Known Subinterfaces:

Function0Arg, Function1Arg, Function2Arg, Function3Arg, Function4Arg

All Known Implementing Classes:

Address, AggregateFunction, BooleanFunction, BooleanFunction.OneArg, CalendarFieldFunction, Choose, Column, Columns, ConcatEval, Count, Counta, Countblank, Countif, DateFunc, Days360, ELEvalFunction, Errortype, Even, FinanceFunction, Fixed0ArgFunction, Fixed1ArgFunction, Fixed2ArgFunction, Fixed3ArgFunction, Fixed4ArgFunction, Hlookup, Hyperlink, IfFunc, Index, IntersectionEval, Irr, LogicalFunction, Lookup, Match, MinaMaxa, Mode, MultiOperandNumericFunction, Na, NotImplementedFunction, Now, Npv, NumericFunction, NumericFunction.OneArg, NumericFunction.TwoArg, Odd, Offset, OverridableFunction, PercentEval, RangeEval, Rank, Rate, RelationalOperationEval, Replace, RowFunc, Rows, Substitute, Subtotal, Sumif, Sumproduct, Sumx2my2, Sumx2py2, Sumxmy2, T, TextFunction, TimeFunc, Today, TwoOperandNumericOperation, TwoOperandNumericOperation.MultiplyFunc, UnaryMinusEval, UnaryPlusEval, Value, Vlookup, WeekdayFunc, XYNumericFunction

public interface Function

Common interface for all implementations of Excel built-in functions.

Author:

Amol S. Deshmukh < amolweb at ya hoo dot com >

Method Summary

Modifier and Type	Method and Description
ValueEval	evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)

Method Detail

evaluate

ValueEval evaluate(ValueEval[] args,
                   int srcRowIndex,
                   int srcColumnIndex)

Parameters:

args - the evaluated function arguments. Empty values are represented with BlankEval or MissingArgEval, never null.

srcRowIndex - row index of the cell containing the formula under evaluation

srcColumnIndex - column index of the cell containing the formula under evaluation

Returns:

The evaluated result, possibly an ErrorEval, never null. Note - Excel uses the error code #NUM! instead of IEEE NaN, so when numeric functions evaluate to Double.NaN be sure to translate the result to ErrorEval.NUM_ERROR.