Interface Function

All Known Subinterfaces:
Function0Arg, Function1Arg, Function2Arg, Function3Arg, Function4Arg
All Known Implementing Classes:
Address, AggregateFunction, Areas, Bin2Dec, BooleanFunction, CalendarFieldFunction, Choose, Code, Column, Columns, Complex, ConcatEval, Count, Counta, Countblank, Countif, DateFunc, Days360, Dec2Bin, Dec2Hex, Delta, DStarRunner, Errortype, Even, FactDouble, FinanceFunction, Fixed, Fixed0ArgFunction, Fixed1ArgFunction, Fixed2ArgFunction, Fixed3ArgFunction, Fixed4ArgFunction, Frequency, Hex2Dec, Hlookup, Hyperlink, IfFunc, Imaginary, ImReal, Index, Intercept, IntersectionEval, IPMT, Irr, LinearRegressionFunction, LogicalFunction, Lookup, Match, MatrixFunction, MatrixFunction.MutableValueCollector, MatrixFunction.OneArrayArg, MatrixFunction.TwoArrayArg, MinaMaxa, Mirr, Mode, MultiOperandNumericFunction, Na, NotImplementedFunction, Now, Npv, NumericFunction, NumericFunction.OneArg, NumericFunction.TwoArg, Oct2Dec, Odd, Offset, PercentEval, PPMT, Quotient, RangeEval, Rank, Rate, RelationalOperationEval, Replace, Rept, Roman, RowFunc, Rows, Slope, Substitute, Subtotal, Sumif, Sumproduct, Sumx2my2, Sumx2py2, Sumxmy2, T, TextFunction, TimeFunc, Today, Trend, TwoOperandNumericOperation, UnaryMinusEval, UnaryPlusEval, Value, Vlookup, WeekdayFunc, WeekNum, 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
    Description
    evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
     
  • Method Details

    • 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.