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

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

39
40
41
42
43
44
45
46
47
            }
        }

        if (retval == null) {
            d = MathX.cosh(d);
            retval = (Double.isNaN(d) || Double.isInfinite(d)) ? (ValueEval) ErrorEval.VALUE_INVALID : new NumberEval(d);
        }
        return retval;
    }
View Full Code Here
37
38
39
40
41
42
43
44
45
46
       
        if (retval == null) {
            double d = MathX.sumx2py2(values[X], values[Y]);
            retval = (Double.isNaN(d) || Double.isInfinite(d))
                    ? (ValueEval) ErrorEval.NUM_ERROR
                    : new NumberEval(d);
        }
       
        return retval;
    }
View Full Code Here
45
46
47
48
49
50
51
52
53
            }
        }

        if (retval == null) {
            d = MathX.asinh(d);
            retval = (Double.isNaN(d)) ? (ValueEval) ErrorEval.NUM_ERROR : new NumberEval(d);
        }
        return retval;
    }
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
93
        }
        else if (ve instanceof BoolEval) {
            retval = (BoolEval) ve;
        }
        else if (ve instanceof NumberEval) {
            NumberEval ne = (NumberEval) ve;
            retval = ne.getNumberValue() != 0 ? BoolEval.TRUE : BoolEval.FALSE;
        }
        else if (ve instanceof StringEval) {
            StringEval se = (StringEval) ve;
            String str = se.getStringValue();
            retval = str.equalsIgnoreCase("true")
View Full Code Here
41
42
43
44
45
46
47
48
49
        if (retval == null) {
            d = Math.asin(d);
            retval = (Double.isNaN(d))
                    ? (ValueEval) ErrorEval.NUM_ERROR
                    : new NumberEval(d);
        }
        return retval;
    }
View Full Code Here
54
55
56
57
58
59
60
61
62
            }
        }
       
        if (retval == null) {
            double d = Math.pow(d0, d1);
            retval = (Double.isNaN(d) || Double.isNaN(d)) ? (ValueEval) ErrorEval.VALUE_INVALID : new NumberEval(d);
        }
        return retval;
    }
View Full Code Here
44
45
46
47
48
49
50
51
52
53
        }
        else {
            double d = MathX.sumsq(values);
            retval = (Double.isNaN(d) || Double.isInfinite(d))
                    ? (ValueEval) ErrorEval.NUM_ERROR
                    : new NumberEval(d);
        }
       
        return retval;
    }
View Full Code Here
62
63
64
65
66
67
68
69
70
                        : 0;
            }
            else {
                d = MathX.round(d0, (int) d1);
            }
            retval = (Double.isNaN(d) || Double.isInfinite(d)) ? (ValueEval) ErrorEval.VALUE_INVALID : new NumberEval(d);
        }
        return retval;
    }
View Full Code Here
42
43
44
45
46
47
48
49
50
        if (retval == null) {
            d = Math.log(d) / LOG_10_TO_BASE_e;
            retval = (Double.isNaN(d) || Double.isInfinite(d))
                    ? (ValueEval) ErrorEval.NUM_ERROR
                    : new NumberEval(d);
        }
        return retval;
    }
View Full Code Here
39
40
41
42
43
44
45
46
47
        if (retval == null) {
            d = MathX.acosh(d);
            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.