Package org.apache.poi.ss.formula.eval

Examples of org.apache.poi.ss.formula.eval.AreaEval

153
154
155
156
157
158
159
160
161
162
163
    }
    assertFalse(mp.matches(seA));
    assertTrue(mp.matches(seB));

    // general tests for not-equal (<>) operator
    AreaEval range;
    ValueEval[] values;

    values = new ValueEval[] {
        new StringEval("aa"),
        new StringEval("def"),
View Full Code Here
198
199
200
201
202
203
204
205
206
207
208
    /**
     * String criteria in COUNTIF are case insensitive;
     * for example, the string "apples" and the string "APPLES" will match the same cells.
     */
    public void testCaseInsensitiveStringComparison() {
        AreaEval range;
        ValueEval[] values;

        values = new ValueEval[] {
                new StringEval("no"),
                new StringEval("NO"),
View Full Code Here
227
228
229
230
231
232
233
234
235
236
237
        new NumberEval(21),
        new NumberEval(25),
        new NumberEval(25),
        new NumberEval(25),
    };
    AreaEval arg0 = EvalFactory.createAreaEval("C1:C6", values);

    ValueEval criteriaArg = EvalFactory.createRefEval("A1", new NumberEval(25));
    ValueEval[] args=  { arg0, criteriaArg, };

    double actual = NumericFunctionInvoker.invoke(new Countif(), args);
View Full Code Here
267
268
269
270
271
272
273
274
275
276
277
    ValueEval v0 = new NumberEval(2.0);
    ValueEval v1 = new StringEval("abc");
    ValueEval v2 = ErrorEval.DIV_ZERO;

    AreaEval ev = EvalFactory.createAreaEval("A10:A12", new ValueEval[] { v0, v1, v2, });

    I_MatchPredicate mp;
    mp = Countif.createCriteriaPredicate(ev, 9, srcColIx);
    confirmPredicate(true, mp, srcColIx);
    confirmPredicate(false, mp, "abc");
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
      new NumberEval(10),
      new NumberEval(10),
      new NumberEval(25),
    };

    AreaEval ae = EvalFactory.createAreaEval("A1:A5", values);

    confirmInt(2, invokeMatch(new NumberEval(5), ae, MATCH_LARGEST_LTE));
    confirmInt(2, invokeMatch(new NumberEval(5), ae, MATCH_EXACT));
    confirmInt(4, invokeMatch(new NumberEval(10), ae, MATCH_LARGEST_LTE));
    confirmInt(3, invokeMatch(new NumberEval(10), ae, MATCH_EXACT));
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
      new NumberEval(10),
      new NumberEval(10),
      new NumberEval(4),
    };

    AreaEval ae = EvalFactory.createAreaEval("A1:A5", values);

    confirmInt(2, invokeMatch(new NumberEval(10), ae, MATCH_SMALLEST_GTE));
    confirmInt(2, invokeMatch(new NumberEval(10), ae, MATCH_EXACT));
    confirmInt(4, invokeMatch(new NumberEval(9), ae, MATCH_SMALLEST_GTE));
    confirmInt(1, invokeMatch(new NumberEval(20), ae, MATCH_SMALLEST_GTE));
View Full Code Here
104
105
106
107
108
109
110
111
112
113
114
      new StringEval("Ed"),
      new StringEval("Greg"),
      new StringEval("Ian"),
    };

    AreaEval ae = EvalFactory.createAreaEval("A1:A5", values);

    // Note String comparisons are case insensitive
    confirmInt(3, invokeMatch(new StringEval("Ed"), ae, MATCH_LARGEST_LTE));
    confirmInt(3, invokeMatch(new StringEval("eD"), ae, MATCH_LARGEST_LTE));
    confirmInt(3, invokeMatch(new StringEval("Ed"), ae, MATCH_EXACT));
View Full Code Here
125
126
127
128
129
130
131
132
133
134
135
                new StringEval("Ed"),
                new StringEval("Greg"),
                new StringEval("Ian"),
        };

        AreaEval ae = EvalFactory.createAreaEval("A1:A5", values);

        // Note String comparisons are case insensitive
        confirmInt(3, invokeMatch(new StringEval("e*"), ae, MATCH_EXACT));
        confirmInt(3, invokeMatch(new StringEval("*d"), ae, MATCH_EXACT));

View Full Code Here
151
152
153
154
155
156
157
158
159
160
        ValueEval[] values = {
                new StringEval("what?"),
                new StringEval("all*")
        };

        AreaEval ae = EvalFactory.createAreaEval("A1:A2", values);

        confirmInt(1, invokeMatch(new StringEval("what~?"), ae, MATCH_EXACT));
        confirmInt(2, invokeMatch(new StringEval("all~*"), ae, MATCH_EXACT));
    }
View Full Code Here
166
167
168
169
170
171
172
173
174
175
176
        BoolEval.FALSE,
        BoolEval.TRUE,
        BoolEval.TRUE,
    };

    AreaEval ae = EvalFactory.createAreaEval("A1:A4", values);

    // Note String comparisons are case insensitive
    confirmInt(2, invokeMatch(BoolEval.FALSE, ae, MATCH_LARGEST_LTE));
    confirmInt(1, invokeMatch(BoolEval.FALSE, ae, MATCH_EXACT));
    confirmInt(4, invokeMatch(BoolEval.TRUE, ae, MATCH_LARGEST_LTE));
View Full Code Here
TOP

Related Classes of org.apache.poi.ss.formula.eval.AreaEval

  • org.apache.poi.ss.formula.atp.TestPercentile
  • org.apache.poi.ss.formula.functions.Rank
  • org.apache.poi.ss.formula.functions.Sumif
  • org.apache.poi.ss.formula.functions.Sumproduct
  • org.apache.poi.ss.formula.functions.TestCountFuncs
  • org.apache.poi.ss.formula.functions.TestIndex
  • org.apache.poi.ss.formula.functions.TestMatch
  • org.apache.poi.ss.formula.functions.TestMid
  • org.apache.poi.ss.formula.functions.TestSubtotal
  • org.apache.poi.ss.formula.functions.TestSumif
    • 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.