Package org.apache.poi.hssf.record.formula.eval

Examples of org.apache.poi.hssf.record.formula.eval.NumberEval

170
171
172
173
174
175
176
177
178
179
180
181
    }
   
    protected static double getDoubleValue(Eval eval) {
        double retval = 0;
        if (eval instanceof NumberEval) {
            NumberEval ne = (NumberEval) eval;
            retval = ne.getNumberValue();
        }
        else if (eval instanceof RefEval) {
            RefEval re = (RefEval) eval;
            ValueEval ve = re.getInnerValueEval();
                retval = (ve instanceof NumberEval)
View Full Code Here
39
40
41
42
43
44
45
46
47
            }
        }

        if (retval == null) {
            d = Math.pow(E, d);
            retval = (Double.isNaN(d)) ? (ValueEval) ErrorEval.VALUE_INVALID : new NumberEval(d);
        }
        return retval;
    }
View Full Code Here
53
54
55
56
57
58
59
60
61
            d = FinanceLib.fv(rate, nper, pmt, pv, type);
            retval = (Double.isNaN(d))
                    ? (ValueEval) ErrorEval.VALUE_INVALID
                    : (Double.isInfinite(d))
                        ? (ValueEval) ErrorEval.NUM_ERROR
                        : new NumberEval(d);
        }
        return retval;
    }
View Full Code Here
53
54
55
56
57
58
59
60
61
            d = FinanceLib.pv(rate, nper, pmt, fv, type);
            retval = (Double.isNaN(d))
                    ? (ValueEval) ErrorEval.VALUE_INVALID
                    : (Double.isInfinite(d))
                        ? (ValueEval) ErrorEval.NUM_ERROR
                        : new NumberEval(d);
        }
        return retval;
    }
View Full Code Here
41
42
43
44
45
46
47
48
49
       
        if (retval == null) {
            d = Math.abs(d);
            retval = (Double.isNaN(d))
                    ? (ValueEval) ErrorEval.VALUE_INVALID
                    : new NumberEval(d);
        }
        return retval;
    }
View Full Code Here
51
52
53
54
55
56
57
58
59
60
        }
        else {
            double d = MathX.average(values);
            retval = (Double.isNaN(d) || Double.isInfinite(d))
                    ? (ValueEval) ErrorEval.NUM_ERROR
                    : new NumberEval(d);
        }
       
        return retval;
    }
View Full Code Here
44
45
46
47
48
49
50
51
52
            }
        }

        if (retval == null) {
            d = MathX.atanh(d);
            retval = (Double.isNaN(d) || Double.isInfinite(d)) ? (ValueEval) ErrorEval.NUM_ERROR : new NumberEval(d);
        }
        return retval;
    }
View Full Code Here
47
48
49
50
51
52
53
54
55
                        ? d
                        : (d < 0)
                            ? ((((long) (d/2))<<1)-2)
                            : ((((long) (d/2))<<1)+2);
            }
            retval = (Double.isNaN(d) || Double.isInfinite(d)) ? (ValueEval) ErrorEval.VALUE_INVALID : new NumberEval(d);
        }
        return retval;
    }
View Full Code Here
53
54
55
56
57
58
59
60
61
            d = FinanceLib.pmt(rate, nper, pv, fv, type);
            retval = (Double.isNaN(d))
                    ? (ValueEval) ErrorEval.VALUE_INVALID
                    : (Double.isInfinite(d))
                        ? (ValueEval) ErrorEval.NUM_ERROR
                        : new NumberEval(d);
        }
        return retval;
    }
View Full Code Here
51
52
53
54
55
56
57
58
59
60
        }
        else {
            double d = StatsLib.stdev(values);
            retval = (Double.isNaN(d) || Double.isInfinite(d))
                    ? (ValueEval) ErrorEval.NUM_ERROR
                    : new NumberEval(d);
        }
       
        return retval;
    }
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.record.formula.eval.NumberEval

  • org.apache.poi.hssf.record.formula.atp.YearFrac
  • org.apache.poi.hssf.record.formula.functions.Avedev
  • org.apache.poi.hssf.record.formula.functions.CalendarFieldFunction
  • org.apache.poi.hssf.record.formula.functions.Column
  • org.apache.poi.hssf.record.formula.functions.Columns
  • org.apache.poi.hssf.record.formula.functions.Cosh
  • org.apache.poi.hssf.record.formula.functions.Count
  • org.apache.poi.hssf.record.formula.functions.Counta
  • org.apache.poi.hssf.record.formula.functions.Countblank
  • org.apache.poi.hssf.record.formula.functions.Countif
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.