You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by on...@apache.org on 2016/04/12 13:28:25 UTC
svn commit: r1738773 -
/poi/trunk/src/java/org/apache/poi/ss/formula/functions/FinanceFunction.java
Author: onealj
Date: Tue Apr 12 11:28:25 2016
New Revision: 1738773
URL: http://svn.apache.org/viewvc?rev=1738773&view=rev
Log:
whitespace (tabs to spaces)
Modified:
poi/trunk/src/java/org/apache/poi/ss/formula/functions/FinanceFunction.java
Modified: poi/trunk/src/java/org/apache/poi/ss/formula/functions/FinanceFunction.java
URL: http://svn.apache.org/viewvc/poi/trunk/src/java/org/apache/poi/ss/formula/functions/FinanceFunction.java?rev=1738773&r1=1738772&r2=1738773&view=diff
==============================================================================
--- poi/trunk/src/java/org/apache/poi/ss/formula/functions/FinanceFunction.java (original)
+++ poi/trunk/src/java/org/apache/poi/ss/formula/functions/FinanceFunction.java Tue Apr 12 11:28:25 2016
@@ -28,50 +28,50 @@ import org.apache.poi.ss.formula.eval.Va
* @author Amol S. Deshmukh < amolweb at ya hoo dot com >
*/
public abstract class FinanceFunction implements Function3Arg, Function4Arg {
- private static final ValueEval DEFAULT_ARG3 = NumberEval.ZERO;
- private static final ValueEval DEFAULT_ARG4 = BoolEval.FALSE;
+ private static final ValueEval DEFAULT_ARG3 = NumberEval.ZERO;
+ private static final ValueEval DEFAULT_ARG4 = BoolEval.FALSE;
- protected FinanceFunction() {
- // no instance fields
- }
-
- public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1,
- ValueEval arg2) {
- return evaluate(srcRowIndex, srcColumnIndex, arg0, arg1, arg2, DEFAULT_ARG3);
- }
- public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1,
- ValueEval arg2, ValueEval arg3) {
- return evaluate(srcRowIndex, srcColumnIndex, arg0, arg1, arg2, arg3, DEFAULT_ARG4);
- }
- public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1,
- ValueEval arg2, ValueEval arg3, ValueEval arg4) {
- double result;
- try {
- double d0 = NumericFunction.singleOperandEvaluate(arg0, srcRowIndex, srcColumnIndex);
- double d1 = NumericFunction.singleOperandEvaluate(arg1, srcRowIndex, srcColumnIndex);
- double d2 = NumericFunction.singleOperandEvaluate(arg2, srcRowIndex, srcColumnIndex);
- double d3 = NumericFunction.singleOperandEvaluate(arg3, srcRowIndex, srcColumnIndex);
- double d4 = NumericFunction.singleOperandEvaluate(arg4, srcRowIndex, srcColumnIndex);
- result = evaluate(d0, d1, d2, d3, d4 != 0.0);
- NumericFunction.checkValue(result);
- } catch (EvaluationException e) {
- return e.getErrorEval();
- }
- return new NumberEval(result);
- }
- public ValueEval evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex) {
- switch (args.length) {
- case 3:
- return evaluate(srcRowIndex, srcColumnIndex, args[0], args[1], args[2], DEFAULT_ARG3, DEFAULT_ARG4);
- case 4: {
- ValueEval arg3 = args[3];
- if(arg3 == MissingArgEval.instance) {
- arg3 = DEFAULT_ARG3;
- }
- return evaluate(srcRowIndex, srcColumnIndex, args[0], args[1], args[2], arg3, DEFAULT_ARG4);
- }
- case 5: {
+ protected FinanceFunction() {
+ // no instance fields
+ }
+
+ public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1,
+ ValueEval arg2) {
+ return evaluate(srcRowIndex, srcColumnIndex, arg0, arg1, arg2, DEFAULT_ARG3);
+ }
+ public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1,
+ ValueEval arg2, ValueEval arg3) {
+ return evaluate(srcRowIndex, srcColumnIndex, arg0, arg1, arg2, arg3, DEFAULT_ARG4);
+ }
+ public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1,
+ ValueEval arg2, ValueEval arg3, ValueEval arg4) {
+ double result;
+ try {
+ double d0 = NumericFunction.singleOperandEvaluate(arg0, srcRowIndex, srcColumnIndex);
+ double d1 = NumericFunction.singleOperandEvaluate(arg1, srcRowIndex, srcColumnIndex);
+ double d2 = NumericFunction.singleOperandEvaluate(arg2, srcRowIndex, srcColumnIndex);
+ double d3 = NumericFunction.singleOperandEvaluate(arg3, srcRowIndex, srcColumnIndex);
+ double d4 = NumericFunction.singleOperandEvaluate(arg4, srcRowIndex, srcColumnIndex);
+ result = evaluate(d0, d1, d2, d3, d4 != 0.0);
+ NumericFunction.checkValue(result);
+ } catch (EvaluationException e) {
+ return e.getErrorEval();
+ }
+ return new NumberEval(result);
+ }
+ public ValueEval evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex) {
+ switch (args.length) {
+ case 3:
+ return evaluate(srcRowIndex, srcColumnIndex, args[0], args[1], args[2], DEFAULT_ARG3, DEFAULT_ARG4);
+ case 4: {
+ ValueEval arg3 = args[3];
+ if(arg3 == MissingArgEval.instance) {
+ arg3 = DEFAULT_ARG3;
+ }
+ return evaluate(srcRowIndex, srcColumnIndex, args[0], args[1], args[2], arg3, DEFAULT_ARG4);
+ }
+ case 5: {
ValueEval arg3 = args[3];
if(arg3 == MissingArgEval.instance) {
arg3 = DEFAULT_ARG3;
@@ -80,54 +80,54 @@ public abstract class FinanceFunction im
if(arg4 == MissingArgEval.instance) {
arg4 = DEFAULT_ARG4;
}
- return evaluate(srcRowIndex, srcColumnIndex, args[0], args[1], args[2], arg3, arg4);
- }
- }
- return ErrorEval.VALUE_INVALID;
- }
-
- protected double evaluate(double[] ds) throws EvaluationException {
- // All finance functions have 3 to 5 args, first 4 are numbers, last is boolean
- // default for last 2 args are 0.0 and false
- // Text boolean literals are not valid for the last arg
-
- double arg3 = 0.0;
- double arg4 = 0.0;
-
- switch(ds.length) {
- case 5:
- arg4 = ds[4];
- case 4:
- arg3 = ds[3];
- case 3:
- break;
- default:
- throw new IllegalStateException("Wrong number of arguments");
- }
- return evaluate(ds[0], ds[1], ds[2], arg3, arg4!=0.0);
- }
-
- protected abstract double evaluate(double rate, double arg1, double arg2, double arg3, boolean type) throws EvaluationException ;
-
-
- public static final Function FV = new FinanceFunction() {
- protected double evaluate(double rate, double arg1, double arg2, double arg3, boolean type) {
- return FinanceLib.fv(rate, arg1, arg2, arg3, type);
- }
- };
- public static final Function NPER = new FinanceFunction() {
- protected double evaluate(double rate, double arg1, double arg2, double arg3, boolean type) {
- return FinanceLib.nper(rate, arg1, arg2, arg3, type);
- }
- };
- public static final Function PMT = new FinanceFunction() {
- protected double evaluate(double rate, double arg1, double arg2, double arg3, boolean type) {
- return FinanceLib.pmt(rate, arg1, arg2, arg3, type);
- }
- };
- public static final Function PV = new FinanceFunction() {
- protected double evaluate(double rate, double arg1, double arg2, double arg3, boolean type) {
- return FinanceLib.pv(rate, arg1, arg2, arg3, type);
- }
- };
+ return evaluate(srcRowIndex, srcColumnIndex, args[0], args[1], args[2], arg3, arg4);
+ }
+ }
+ return ErrorEval.VALUE_INVALID;
+ }
+
+ protected double evaluate(double[] ds) throws EvaluationException {
+ // All finance functions have 3 to 5 args, first 4 are numbers, last is boolean
+ // default for last 2 args are 0.0 and false
+ // Text boolean literals are not valid for the last arg
+
+ double arg3 = 0.0;
+ double arg4 = 0.0;
+
+ switch(ds.length) {
+ case 5:
+ arg4 = ds[4];
+ case 4:
+ arg3 = ds[3];
+ case 3:
+ break;
+ default:
+ throw new IllegalStateException("Wrong number of arguments");
+ }
+ return evaluate(ds[0], ds[1], ds[2], arg3, arg4!=0.0);
+ }
+
+ protected abstract double evaluate(double rate, double arg1, double arg2, double arg3, boolean type) throws EvaluationException ;
+
+
+ public static final Function FV = new FinanceFunction() {
+ protected double evaluate(double rate, double arg1, double arg2, double arg3, boolean type) {
+ return FinanceLib.fv(rate, arg1, arg2, arg3, type);
+ }
+ };
+ public static final Function NPER = new FinanceFunction() {
+ protected double evaluate(double rate, double arg1, double arg2, double arg3, boolean type) {
+ return FinanceLib.nper(rate, arg1, arg2, arg3, type);
+ }
+ };
+ public static final Function PMT = new FinanceFunction() {
+ protected double evaluate(double rate, double arg1, double arg2, double arg3, boolean type) {
+ return FinanceLib.pmt(rate, arg1, arg2, arg3, type);
+ }
+ };
+ public static final Function PV = new FinanceFunction() {
+ protected double evaluate(double rate, double arg1, double arg2, double arg3, boolean type) {
+ return FinanceLib.pv(rate, arg1, arg2, arg3, type);
+ }
+ };
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org