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 double
evaluate
(double[] ds) protected abstract double
evaluate
(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:
evaluate
in interfaceFunction3Arg
-
evaluate
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3) Description copied from interface:Function4Arg
- Specified by:
evaluate
in interfaceFunction4Arg
-
evaluate
-
evaluate
- Specified by:
evaluate
in interfaceFunction
- Parameters:
args
- the evaluated function arguments. Empty values are represented withBlankEval
orMissingArgEval
, 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.NaN
be 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
-