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

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

76
77
78
79
80
81
82
83
84
85
86
87
            NumberEval neval = (NumberEval) eval;
            double d = neval.getNumberValue();
            numval = (int) d;
        }
        else if (eval instanceof StringEval) {
            StringEval seval = (StringEval) eval;
            String s = seval.getStringValue();
            try {
                double d = Double.parseDouble(s);
                numval = (int) d;
            }
            catch (Exception e) {
View Full Code Here
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
            }
        case 1:
            ValueEval veval = singleOperandEvaluate(operands[0], srcCellRow, srcCellCol);
            String str = null;
            if (veval instanceof StringEval) {
                StringEval stringEval = (StringEval) veval;
                str = stringEval.getStringValue();
            }
            else if (veval instanceof BoolEval) {
                BoolEval beval = (BoolEval) veval;
                str = beval.getBooleanValue() ? "TRUE" : "FALSE";
            }
            else if (veval instanceof NumberEval) {
                NumberEval neval = (NumberEval) veval;
                str = neval.getStringValue();
            }
            if (null != str) {
                str = str.substring(0, Math.min(str.length(), index));
                retval = new StringEval(str);
            }
        }
        return retval;
    }
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
86
            NumberEval neval = (NumberEval) eval;
            double d = neval.getNumberValue();
            numval = (int) d;
        }
        else if (eval instanceof StringEval) {
            StringEval seval = (StringEval) eval;
            String s = seval.getStringValue();
            try {
                double d = Double.parseDouble(s);
                numval = (int) d;
            }
            catch (Exception e) {
View Full Code Here
50
51
52
53
54
55
56
57
58
59
                break;
            }
        }
       
        if (retval == null) {
            retval = new StringEval(sb.toString());
        }
       
        return retval;
    }
View Full Code Here
102
103
104
105
106
107
108
109
110
111
112
113
        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")
                    ? BoolEval.TRUE
                    : str.equalsIgnoreCase("false")
                            ? BoolEval.FALSE
                            : (ValueEval) ErrorEval.VALUE_INVALID;
View Full Code Here
55
56
57
58
59
60
61
62
63
64
            }
        }
       
        if (retval == null) {
            s = (s == null) ? EMPTY_STRING : s;
            retval = new StringEval(s.toLowerCase());
        }
       
        return retval;
    }
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
69
    public boolean matches(Eval x) {
      if(x instanceof StringEval) {
        // if the target(x) is a string, but parses as a number
        // it may still count as a match
        StringEval se = (StringEval)x;
        Double val = parseDouble(se.getStringValue());
        if(val == null) {
          // x is text that is not a number
          return false;
        }
        return val.doubleValue() == _value;
View Full Code Here
55
56
57
58
59
60
61
62
63
64
            }
        }
       
        if (retval == null) {
            s = (s == null) ? EMPTY_STRING : s;
            retval = new StringEval(s.toUpperCase());
        }
       
        return retval;
    }
View Full Code Here
301
302
303
304
305
306
307
308
309
310
311
312
   
    if (ve instanceof NumericValueEval) {
      return ((NumericValueEval) ve).getNumberValue();
    }
    if (ve instanceof StringEval) {
      StringEval se = (StringEval) ve;
      Double d = parseDouble(se.getStringValue());
      if(d == null) {
        throw new EvalEx(ErrorEval.VALUE_INVALID);
      }
      return d.doubleValue();
    }
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
    }
    if (numChars < 0) {
      return ErrorEval.VALUE_INVALID;
    }
    if (numChars < 0 || startIx > len) {
      return new StringEval("");
    }
    int endIx = startIx + numChars;
    if (endIx > len) {
      endIx = len;
    }
    String result = text.substring(startIx, endIx);
    return new StringEval(result);

  }
View Full Code Here
TOP

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

  • org.apache.poi.hssf.record.formula.functions.Concatenate
  • org.apache.poi.hssf.record.formula.functions.Countif$BooleanMatcher
  • org.apache.poi.hssf.record.formula.functions.Countif$NumberMatcher
  • org.apache.poi.hssf.record.formula.functions.Countif$StringMatcher
  • org.apache.poi.hssf.record.formula.functions.Left
  • org.apache.poi.hssf.record.formula.functions.LookupUtils
  • org.apache.poi.hssf.record.formula.functions.LookupUtils$StringLookupComparer
  • org.apache.poi.hssf.record.formula.functions.Lower
  • org.apache.poi.hssf.record.formula.functions.Match
  • org.apache.poi.hssf.record.formula.functions.Mid
    • 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.