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

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

42
43
44
45
46
47
48
49
50
51
52
53
            retval = ErrorEval.VALUE_INVALID;
            break;
        case 1:
            ValueEval ve = singleOperandEvaluate(operands[0], srcRow, srcCol);
            if (ve instanceof NumericValueEval) {
                NumericValueEval ne = (NumericValueEval) ve;
                d = ne.getNumberValue();
            }
            else if (ve instanceof BlankEval) {
                // do nothing
            }
            else {
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
            retval = ErrorEval.VALUE_INVALID;
            break;
        case 2:
            ValueEval ve = singleOperandEvaluate(operands[0], srcRow, srcCol);
            if (ve instanceof NumericValueEval) {
                NumericValueEval ne = (NumericValueEval) ve;
                d0 = ne.getNumberValue();
            }
            else if (ve instanceof BlankEval) {
                // do nothing
            }
            else {
                retval = ErrorEval.NUM_ERROR;
            }

            if (retval == null) {
                ve = singleOperandEvaluate(operands[1], srcRow, srcCol);
                if (ve instanceof NumericValueEval) {
                    NumericValueEval ne = (NumericValueEval) ve;
                    d1 = ne.getNumberValue();
                }
                else if (ve instanceof BlankEval) {
                    // do nothing
                }
                else {
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
57
58
            retval = ErrorEval.VALUE_INVALID;
            break;
        case 1:
            ValueEval ve = singleOperandEvaluate(operands[0], srcCellRow, srcCellCol);
            if (ve instanceof NumericValueEval) {
                NumericValueEval ne = (NumericValueEval) ve;
                if (HSSFDateUtil.isValidExcelDate(ne.getNumberValue())) {
                    java.util.Date d = HSSFDateUtil.getJavaDate(ne.getNumberValue(), false); // XXX fix 1900/1904 problem
                    retval = new NumberEval(d.getMonth()+1);
                } else {
                    retval = ErrorEval.NUM_ERROR;
                }
            }
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
          default:
              retval = ErrorEval.VALUE_INVALID;
          case 4:
            ValueEval fourthveval = singleOperandEvaluate(operands[3], srcCellRow, srcCellCol);
            if (fourthveval instanceof NumericValueEval) {
              NumericValueEval numToReplaceEval = (NumericValueEval) fourthveval;
              // NOTE: it is safe to cast to int here
                  // because in Excel =SUBSTITUTE("teststr","t","T",1.9)
                  // returns Teststr
                  // so 1.9 must be truncated to 1
              numToReplace = (int) numToReplaceEval.getNumberValue();
            } else {
              retval = ErrorEval.VALUE_INVALID;
            }
          case 3: 
            // first operand is text string containing characters to replace
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
53
            retval = ErrorEval.VALUE_INVALID;
            break;
        case 1:
            ValueEval ve = singleOperandEvaluate(operands[0], srcRow, srcCol);
            if (ve instanceof NumericValueEval) {
                NumericValueEval ne = (NumericValueEval) ve;
                d = ne.getNumberValue();
            }
            else if (ve instanceof BlankEval) {
                // do nothing
            }
            else {
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
58
59
            retval = ErrorEval.VALUE_INVALID;
            break;
        case 1:
            ValueEval ve = singleOperandEvaluate(operands[0], srcCellRow, srcCellCol);
            if (ve instanceof NumericValueEval) {
                NumericValueEval ne = (NumericValueEval) ve;
                if (HSSFDateUtil.isValidExcelDate(ne.getNumberValue())) {
                    java.util.Date d = HSSFDateUtil.getJavaDate(ne.getNumberValue(), false); // XXX fix 1900/1904 problem
                    retval = new NumberEval(d.getYear()+1900);
                } else {
                    retval = ErrorEval.NUM_ERROR;
                }
            }
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
            ValueEval ve = singleOperandEvaluate(operands[0], srcRow, srcCol);
            if(ve instanceof ErrorEval) {
              return ve;
            }
            if (ve instanceof NumericValueEval) {
                NumericValueEval ne = (NumericValueEval) ve;
                d0 = ne.getNumberValue();
            }
            else if (ve instanceof BlankEval) {
                // do nothing
            }
            else {
                retval = ErrorEval.NUM_ERROR;
            }

            if (retval == null) {
                ve = singleOperandEvaluate(operands[1], srcRow, srcCol);
                if (ve instanceof NumericValueEval) {
                    NumericValueEval ne = (NumericValueEval) ve;
                    d1 = ne.getNumberValue();
                }
                else if (ve instanceof BlankEval) {
                    // do nothing
                }
                else {
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
53
            retval = ErrorEval.VALUE_INVALID;
            break;
        case 1:
            ValueEval ve = singleOperandEvaluate(operands[0], srcRow, srcCol);
            if (ve instanceof NumericValueEval) {
                NumericValueEval ne = (NumericValueEval) ve;
                d = ne.getNumberValue();
            }
            else if (ve instanceof BlankEval) {
                // do nothing
            }
            else {
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
            retval = ErrorEval.VALUE_INVALID;
            break;
        case 2:
            ValueEval ve = singleOperandEvaluate(operands[0], srcRow, srcCol);
            if (ve instanceof NumericValueEval) {
                NumericValueEval ne = (NumericValueEval) ve;
                d0 = ne.getNumberValue();
            }
            else if (ve instanceof BlankEval) {
                // do nothing
            }
            else {
                retval = ErrorEval.NUM_ERROR;
            }

            if (retval == null) {
                ve = singleOperandEvaluate(operands[1], srcRow, srcCol);
                if (ve instanceof NumericValueEval) {
                    NumericValueEval ne = (NumericValueEval) ve;
                    d1 = ne.getNumberValue();
                }
                else if (ve instanceof BlankEval) {
                    // do nothing
                }
                else {
View Full Code Here
226
227
228
229
230
231
232
233
234
235
236
      // Note for area SUMPRODUCTs, string values are interpreted as zero
      // even if they would parse as valid numeric values
      return 0;
    }
    if(ve instanceof NumericValueEval) {
      NumericValueEval nve = (NumericValueEval) ve;
      return nve.getNumberValue();
    }
    throw new RuntimeException("Unexpected value eval class ("
        + ve.getClass().getName() + ")");
  }
View Full Code Here
TOP

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

  • org.apache.poi.hssf.record.formula.functions.Abs
  • org.apache.poi.hssf.record.formula.functions.Acos
  • org.apache.poi.hssf.record.formula.functions.Acosh
  • org.apache.poi.hssf.record.formula.functions.Asin
  • org.apache.poi.hssf.record.formula.functions.Asinh
  • org.apache.poi.hssf.record.formula.functions.Atan
  • org.apache.poi.hssf.record.formula.functions.Atan2
  • org.apache.poi.hssf.record.formula.functions.Atanh
  • org.apache.poi.hssf.record.formula.functions.BooleanFunction
  • org.apache.poi.hssf.record.formula.functions.Ceiling
    • 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.