Examples of NumberEval

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

56
57
58
59
60
61
62
63
64
65
66
            cnum = srcCellCol;
        }
       
        if (retval == null) {
            retval = (cnum >= 0)
                    ? new NumberEval(cnum + 1) // +1 since excel colnums are 1 based
                    : (ValueEval) ErrorEval.VALUE_INVALID;
        }
       
        return retval;
    }
View Full Code Here

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

78
79
80
81
82
83
84
85
86
                        : 0;
            }
            else {
                d = MathX.roundDown(d0, (int) d1);
            }
            retval = (Double.isNaN(d) || Double.isInfinite(d)) ? (ValueEval) ErrorEval.VALUE_INVALID : new NumberEval(d);
        }
        return retval;
    }
View Full Code Here

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

253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
     */
    protected static CellValue getCellValueForEval(ValueEval eval) {
        CellValue retval = null;
        if (eval != null) {
            if (eval instanceof NumberEval) {
                NumberEval ne = (NumberEval) eval;
                retval = new CellValue(HSSFCell.CELL_TYPE_NUMERIC);
                retval.setNumberValue(ne.getNumberValue());
            }
            else if (eval instanceof BoolEval) {
                BoolEval be = (BoolEval) eval;
                retval = new CellValue(HSSFCell.CELL_TYPE_BOOLEAN);
                retval.setBooleanValue(be.getBooleanValue());
            }
            else if (eval instanceof StringEval) {
                StringEval ne = (StringEval) eval;
                retval = new CellValue(HSSFCell.CELL_TYPE_STRING);
                retval.setStringValue(ne.getStringValue());
            }
            else if (eval instanceof BlankEval) {
                retval = new CellValue(HSSFCell.CELL_TYPE_BLANK);
            }
            else {
View Full Code Here

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

483
484
485
486
487
488
489
490
491
492
493
    protected static ValueEval getEvalForCell(HSSFCell cell, HSSFRow row, HSSFSheet sheet, HSSFWorkbook workbook) {
        ValueEval retval = BlankEval.INSTANCE;
        if (cell != null) {
            switch (cell.getCellType()) {
            case HSSFCell.CELL_TYPE_NUMERIC:
                retval = new NumberEval(cell.getNumericCellValue());
                break;
            case HSSFCell.CELL_TYPE_STRING:
                retval = new StringEval(cell.getRichStringCellValue().getString());
                break;
            case HSSFCell.CELL_TYPE_FORMULA:
View Full Code Here

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

519
520
521
522
523
524
525
526
527
528
529
    protected static void pushRef2DEval(ReferencePtg ptg, Stack stack,
            HSSFCell cell, HSSFRow row, HSSFSheet sheet, HSSFWorkbook workbook) {
        if (cell != null)
            switch (cell.getCellType()) {
            case HSSFCell.CELL_TYPE_NUMERIC:
                stack.push(new Ref2DEval(ptg, new NumberEval(cell.getNumericCellValue()), false));
                break;
            case HSSFCell.CELL_TYPE_STRING:
                stack.push(new Ref2DEval(ptg, new StringEval(cell.getRichStringCellValue().getString()), false));
                break;
            case HSSFCell.CELL_TYPE_FORMULA:
View Full Code Here

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

556
557
558
559
560
561
562
563
564
565
566
    protected static void pushRef3DEval(Ref3DPtg ptg, Stack stack, HSSFCell cell,
            HSSFRow row, HSSFSheet sheet, HSSFWorkbook workbook) {
        if (cell != null)
            switch (cell.getCellType()) {
            case HSSFCell.CELL_TYPE_NUMERIC:
                stack.push(new Ref3DEval(ptg, new NumberEval(cell.getNumericCellValue()), false));
                break;
            case HSSFCell.CELL_TYPE_STRING:
                stack.push(new Ref3DEval(ptg, new StringEval(cell.getRichStringCellValue().getString()), false));
                break;
            case HSSFCell.CELL_TYPE_FORMULA:
View Full Code Here

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

40
41
42
43
44
45
46
47
48
            }
        }

        if (retval == null) {
            d = Math.log(d);
            retval = (Double.isNaN(d) || Double.isInfinite(d)) ? (ValueEval) ErrorEval.VALUE_INVALID : new NumberEval(d);
        }
        return retval;
    }
View Full Code Here

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

51
52
53
54
55
56
57
58
59
60
        }
        else {
            double d = StatsLib.avedev(values);
            retval = (Double.isNaN(d) || Double.isInfinite(d))
                    ? (ValueEval) ErrorEval.NUM_ERROR
                    : new NumberEval(d);
        }
       
        return retval;
    }
View Full Code Here

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

41
42
43
44
45
46
47
48
49
        if (retval == null) {
            d = Math.sqrt(d);
            retval = (Double.isNaN(d))
                    ? (ValueEval) ErrorEval.NUM_ERROR
                    : new NumberEval(d);
        }
        return retval;
    }
View Full Code Here

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

51
52
53
54
55
56
57
58
59
60
        }
        else {
            double d = StatsLib.median(values);
            retval = (Double.isNaN(d) || Double.isInfinite(d))
                    ? (ValueEval) ErrorEval.NUM_ERROR
                    : new NumberEval(d);
        }
       
        return retval;
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.