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

Examples of org.apache.poi.hssf.record.formula.AreaPtg

66
67
68
69
70
71
72
73
74
75
76
      int rowNum, int colNum, double expectedResult) {
    ValueEval[] values = new ValueEval[dValues.length];
    for (int i = 0; i < values.length; i++) {
      values[i] = new NumberEval(dValues[i]);
    }
    Area2DEval arg0 = new Area2DEval(new AreaPtg(areaRefString), values);
   
    Eval[] args;
    if (colNum > 0) {
      args = new Eval[] { arg0, new NumberEval(rowNum), new NumberEval(colNum), };
    } else {
View Full Code Here
120
121
122
123
124
125
126
127
128
129
130
        new NumberEval(21),
        new NumberEval(25),
        new NumberEval(25),
        new NumberEval(25),
    };
    Area2DEval arg0 = new Area2DEval(new AreaPtg("C1:C6"), values);
   
    Ref2DEval criteriaArg = new Ref2DEval(new ReferencePtg("A1"), new NumberEval(25));
    Eval[] args=  { arg0, criteriaArg, };
   
    double actual = NumericFunctionInvoker.invoke(new Countif(), args);
View Full Code Here
131
132
133
134
135
136
137
    assertEquals(4, actual, 0D);
  }
 

  private static AreaEval createAreaEval(String areaRefStr, ValueEval[] values) {
    return new Area2DEval(new AreaPtg(areaRefStr), values);
  }
View Full Code Here
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
                HSSFRow row = xsheet.getRow(rownum);
                HSSFCell cell = (row != null) ? row.getCell(colnum) : null;
                pushRef3DEval(ptg, stack, cell, row, xsheet, workbook);
            }
            else if (ptgs[i] instanceof AreaPtg) {
                AreaPtg ap = (AreaPtg) ptgs[i];
                short row0 = ap.getFirstRow();
                short col0 = ap.getFirstColumn();
                short row1 = ap.getLastRow();
                short col1 = ap.getLastColumn();
                ValueEval[] values = new ValueEval[(row1 - row0 + 1) * (col1 - col0 + 1)];
                for (short x = row0; sheet != null && x < row1 + 1; x++) {
                    HSSFRow row = sheet.getRow(x);
                    for (short y = col0; row != null && y < col1 + 1; y++) {
                        values[(x - row0) * (col1 - col0 + 1) + (y - col0)] =
View Full Code Here
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
    assertEquals(AreaPtg.class, ops.get(0).getClass());
    assertEquals(FuncVarPtg.class, ops.get(1).getClass());

    // Actually stored as C1 to C65536
    // (last row is -1 === 65535)
    AreaPtg ptg = (AreaPtg) ops.get(0);
    assertEquals(2, ptg.getFirstColumn());
    assertEquals(2, ptg.getLastColumn());
    assertEquals(0, ptg.getFirstRow());
    assertEquals(65535, ptg.getLastRow());
    assertEquals("C:C", ptg.toFormulaString(wb));

    // Will show as C:C, but won't know how many
    // rows it covers as we don't have the sheet
    // to hand when turning the Ptgs into a string
    assertEquals("SUM(C:C)", cellSUM.getCellFormula());
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
   
    // 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 RefPtg("B1"), new NumberEval(3));
    confirmMid(new StringEval("galactic"), aeStart, reNumChars, "ala");

    confirmMid(new StringEval("galactic"), new NumberEval(3.1), BlankEval.INSTANCE, "");
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
  public void testColumnOperand() {

    short firstRow = (short)8;
    short lastRow = (short)12;
    short colNum = (short)5;
    AreaPtg areaPtg = new AreaPtg(firstRow, lastRow, colNum, colNum, false, false, false, false);
    ValueEval[] values = {
        new NumberEval(27), 
        new NumberEval(29), 
        new NumberEval(35),  // value in row 10
        new NumberEval(37), 
View Full Code Here
49
50
51
52
53
54
55
    ValueEval[] values = new ValueEval[nValues];
    for (int i = 0; i < nValues; i++) {
      values[i] = ZERO;
    }
   
    return new Area2DEval(new AreaPtg(areaRefStr), values);
  }
View Full Code Here
120
121
122
123
124
125
126
127
128
129
130
        new NumberEval(21),
        new NumberEval(25),
        new NumberEval(25),
        new NumberEval(25),
    };
    Area2DEval arg0 = new Area2DEval(new AreaPtg("C1:C6"), values);
   
    Ref2DEval criteriaArg = new Ref2DEval(new RefPtg("A1"), new NumberEval(25));
    Eval[] args=  { arg0, criteriaArg, };
   
    double actual = NumericFunctionInvoker.invoke(new Countif(), args);
View Full Code Here
131
132
133
134
135
136
137
    assertEquals(4, actual, 0D);
  }
 

  private static AreaEval createAreaEval(String areaRefStr, ValueEval[] values) {
    return new Area2DEval(new AreaPtg(areaRefStr), values);
  }
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.record.formula.AreaPtg

  • org.apache.poi.hssf.record.aggregates.CFRecordsAggregate
  • org.apache.poi.hssf.record.EmbeddedObjectRefSubRecord
  • org.apache.poi.hssf.record.formula.eval.TestAreaEval
  • org.apache.poi.hssf.record.formula.eval.TestUnaryPlusEval
  • org.apache.poi.hssf.record.formula.functions.EvalFactory
  • org.apache.poi.hssf.record.formula.functions.LookupUtils
  • org.apache.poi.hssf.record.formula.functions.Offset
  • org.apache.poi.hssf.record.formula.functions.TestCountFuncs
  • org.apache.poi.hssf.record.formula.functions.TestIndex
  • org.apache.poi.hssf.record.formula.functions.TestMatch
    • 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.