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

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

50
51
52
53
54
55
56
57
58
59
60
61
  public void testBasic() {
    ValueEval[] arg0values = new ValueEval[] { _30, _30, _40, _40, _50, _50  };
    ValueEval[] arg2values = new ValueEval[] { _30, _40, _50, _60, _60, _60 };

    AreaEval arg0;
    AreaEval arg2;

    arg0 = EvalFactory.createAreaEval("A3:B5", arg0values);
    arg2 = EvalFactory.createAreaEval("D1:E3", arg2values);

    confirm(60.0, arg0, new NumberEval(30.0));
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
84
   */
  public void testCriteriaArgRange() {
    ValueEval[] arg0values = new ValueEval[] { _50, _60, _50, _50, _50, _30,  };
    ValueEval[] arg1values = new ValueEval[] { _30, _40, _50, _60,  };

    AreaEval arg0;
    AreaEval arg1;
    ValueEval ve;

    arg0 = EvalFactory.createAreaEval("A3:B5", arg0values);
    arg1 = EvalFactory.createAreaEval("A2:D2", arg1values); // single row range

View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
76
    ValueEval[] bValues = {
      new NumberEval(3),
      new NumberEval(6),
      new NumberEval(7),
    };
    AreaEval aeA = EvalFactory.createAreaEval("A1:A3", aValues);
    AreaEval aeB = EvalFactory.createAreaEval("B1:B3", bValues);

    ValueEval[] args = { aeA, aeB, };
    ValueEval result = invokeSumproduct(args);
    confirmDouble(65D, result);
  }
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
  /**
   * For scalar products, the terms may be 1x1 area refs
   */
  public void testOneByOneArea() {

    AreaEval ae = EvalFactory.createAreaEval("A1:A1", new ValueEval[] { new NumberEval(7), });

    ValueEval[] args = {
        ae,
        new NumberEval(2),
      };
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
101
    confirmDouble(14D, result);
  }

  public void testMismatchAreaDimensions() {

    AreaEval aeA = EvalFactory.createAreaEval("A1:A3", new ValueEval[3]);
    AreaEval aeB = EvalFactory.createAreaEval("B1:D1", new ValueEval[3]);

    ValueEval[] args;
    args = new ValueEval[] { aeA, aeB, };
    assertEquals(ErrorEval.VALUE_INVALID, invokeSumproduct(args));
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
  public void testAreaWithErrorCell() {
    ValueEval[] aValues = {
      ErrorEval.REF_INVALID,
      null,
    };
    AreaEval aeA = EvalFactory.createAreaEval("A1:A2", aValues);
    AreaEval aeB = EvalFactory.createAreaEval("B1:B2", new ValueEval[2]);

    ValueEval[] args = { aeA, aeB, };
    assertEquals(ErrorEval.REF_INVALID, invokeSumproduct(args));
  }
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
      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
80
81
82
83
84
85
86
87
88
89
90
      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
100
101
102
103
104
105
106
107
108
109
110
      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
120
121
122
123
124
125
126
127
128
129
130
        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.