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

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

53
54
55
56
57
58
59
60
61
62
63
    confirmCountA(1, args);
   
    args = new Eval[] {
      new NumberEval(0), 
      new NumberEval(0),
      new StringEval(""),
    };
    confirmCountA(3, args);
   
    args = new Eval[] {
      EvalFactory.createAreaEval("D2:F5", 3, 4), 
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
    ValueEval[] values;
   
    // when criteria is a boolean value
    values = new ValueEval[] {
        new NumberEval(0), 
        new StringEval("TRUE"),  // note - does not match boolean TRUE
        BoolEval.TRUE,
        BoolEval.FALSE,
        BoolEval.TRUE,
        BlankEval.INSTANCE,
    };
    range = createAreaEval("A1:B2", values);
    confirmCountIf(2, range, BoolEval.TRUE);
   
    // when criteria is numeric
    values = new ValueEval[] {
        new NumberEval(0), 
        new StringEval("2"), 
        new StringEval("2.001"), 
        new NumberEval(2), 
        new NumberEval(2), 
        BoolEval.TRUE,
        BlankEval.INSTANCE,
    };
    range = createAreaEval("A1:B2", values);
    confirmCountIf(3, range, new NumberEval(2));
    // note - same results when criteria is a string that parses as the number with the same value
    confirmCountIf(3, range, new StringEval("2.00"));
   
    if (false) { // not supported yet:
      // when criteria is an expression (starting with a comparison operator)
      confirmCountIf(4, range, new StringEval(">1"));
    }
  }
View Full Code Here
57
58
59
60
61
62
63
    assertEquals(expectedError.getErrorCode(), ((ErrorEval)result).getErrorCode());
  }
 
  public void testBasic() {
   
    confirmMid(new StringEval("galactic"), new NumberEval(3), new NumberEval(4), "lact");
  }
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
  /**
   * Valid cases where args are not precisely (string, int, int) but can be resolved OK.
   */
  public void testUnusualArgs() {
    // startPos with fractional digits
    confirmMid(new StringEval("galactic"), new NumberEval(3.1), new NumberEval(4), "lact");
   
    // string startPos
    confirmMid(new StringEval("galactic"), new StringEval("3"), new NumberEval(4), "lact");
   
    // text (first) arg type is number, other args are strings with fractional digits
    confirmMid(new NumberEval(123456), new StringEval("3.1"), new StringEval("2.9"), "34");
   
    // startPos is 1x1 area ref, numChars is cell ref
    AreaEval aeStart = new Area2DEval(new AreaPtg("A1:A1"), new ValueEval[] { new NumberEval(2), } );
    RefEval reNumChars = new Ref2DEval(new ReferencePtg("B1"), new NumberEval(3));
    confirmMid(new StringEval("galactic"), aeStart, reNumChars, "ala");

    confirmMid(new StringEval("galactic"), new NumberEval(3.1), BlankEval.INSTANCE, "");

    confirmMid(new StringEval("galactic"), new NumberEval(3), BoolEval.FALSE, "");
    confirmMid(new StringEval("galactic"), new NumberEval(3), BoolEval.TRUE, "l");
    confirmMid(BlankEval.INSTANCE, new NumberEval(3), BoolEval.TRUE, "");
 
  }
View Full Code Here
90
91
92
93
94
95
96
97
98
99
  /**
   * Extreme values for startPos and numChars
   */
  public void testExtremes() {
    confirmMid(new StringEval("galactic"), new NumberEval(4), new NumberEval(400), "actic");
   
    confirmMid(new StringEval("galactic"), new NumberEval(30), new NumberEval(4), "");
    confirmMid(new StringEval("galactic"), new NumberEval(3), new NumberEval(0), "");
  }
View Full Code Here
101
102
103
104
105
106
107
108
109
110
111
112
113
114
  /**
   * All sorts of ways to make MID return defined errors.
   */
  public void testErrors() {
    confirmMid(ErrorEval.NAME_INVALID, new NumberEval(3), new NumberEval(4), ErrorEval.NAME_INVALID);
    confirmMid(new StringEval("galactic"), ErrorEval.NAME_INVALID, new NumberEval(4), ErrorEval.NAME_INVALID);
    confirmMid(new StringEval("galactic"), new NumberEval(3), ErrorEval.NAME_INVALID, ErrorEval.NAME_INVALID);
    confirmMid(new StringEval("galactic"), ErrorEval.DIV_ZERO, ErrorEval.NAME_INVALID, ErrorEval.DIV_ZERO);
   
    confirmMid(new StringEval("galactic"), BlankEval.INSTANCE, new NumberEval(3.1), ErrorEval.VALUE_INVALID);
   
    confirmMid(new StringEval("galactic"), new NumberEval(0), new NumberEval(4), ErrorEval.VALUE_INVALID);
    confirmMid(new StringEval("galactic"), new NumberEval(1), new NumberEval(-1), ErrorEval.VALUE_INVALID);
  }
View Full Code Here
53
54
55
56
57
58
59
60
61
62
    Eval arg = new Ref2DEval(new ReferencePtg((short)1, (short)1, false, false), innerValue);
    return invokeT(arg);
  }
 
  private static void confirmText(String text) {
    Eval arg = new StringEval(text);
    Eval eval = invokeT(arg);
    StringEval se = (StringEval) eval;
    assertEquals(text, se.getStringValue());
  }
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
111
112
  }

  public void testRefValues() {
    Eval eval;
   
    eval = invokeTWithReference(new StringEval("def"));
    confirmString(eval, "def");
    eval = invokeTWithReference(new StringEval(" "));
    confirmString(eval, " ");

    eval = invokeTWithReference(new NumberEval(2));
    confirmString(eval, "");
    eval = invokeTWithReference(BoolEval.TRUE);
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
61
    assertEquals(expectedError.getErrorCode(), ((ErrorEval)result).getErrorCode());
  }
 
  public void testBasic() {
   
    confirmTrim(new StringEval(" hi "), "hi");
    confirmTrim(new StringEval("hi "), "hi");
    confirmTrim(new StringEval("  hi"), "hi");
    confirmTrim(new StringEval(" hi there  "), "hi there");
    confirmTrim(new StringEval(""), "");
    confirmTrim(new StringEval("   "), "");
  }
View Full Code Here
50
51
52
53
54
55
56
    assertEquals(expectedError.getErrorCode(), ((ErrorEval)result).getErrorCode());
  }
 
  public void testBasic() {
   
    confirmLen(new StringEval("galactic"), 8);
  }
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.