Class FinanceFunction
java.lang.Object
org.apache.poi.ss.formula.functions.FinanceFunction
- All Implemented Interfaces:
Function,Function3Arg,Function4Arg
- Author:
- Amol S. Deshmukh < amolweb at ya hoo dot com >
-
Field Summary
Fields -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionprotected doubleevaluate(double[] ds) protected abstract doubleevaluate(double rate, double arg1, double arg2, double arg3, boolean type) evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3) evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3, ValueEval arg4)
-
Field Details
-
FV
-
NPER
-
PMT
-
PV
-
-
Constructor Details
-
FinanceFunction
protected FinanceFunction()
-
-
Method Details
-
evaluate
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) Description copied from interface:Function3Arg- Specified by:
evaluatein interfaceFunction3Arg
-
evaluate
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3) Description copied from interface:Function4Arg- Specified by:
evaluatein interfaceFunction4Arg
-
evaluate
-
evaluate
- Specified by:
evaluatein interfaceFunction- Parameters:
args- the evaluated function arguments. Empty values are represented withBlankEvalorMissingArgEval, nevernull.srcRowIndex- row index of the cell containing the formula under evaluationsrcColumnIndex- column index of the cell containing the formula under evaluation- Returns:
- The evaluated result, possibly an
ErrorEval, nevernull. Note - Excel uses the error code #NUM! instead of IEEE NaN, so when numeric functions evaluate toDouble.NaNbe sure to translate the result toErrorEval.NUM_ERROR.
-
evaluate
- Throws:
EvaluationException
-
evaluate
protected abstract double evaluate(double rate, double arg1, double arg2, double arg3, boolean type) throws EvaluationException - Throws:
EvaluationException
-