Examples of FuncVarPtg

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

145
146
147
148
149
150
151
152
    assertEquals(AttrPtg.class,    ptgs[5].getClass());
    assertEquals(RefPtg.class, ptgs[6].getClass());
    assertEquals(AttrPtg.class,    ptgs[7].getClass());
    assertEquals(FuncVarPtg.class,   ptgs[8].getClass());

    FuncVarPtg choose = (FuncVarPtg)ptgs[8];
    assertEquals("CHOOSE", choose.getName());
  }
View Full Code Here

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

154
155
156
157
158
159
160
161
162
    AttrPtg ptgGoto2 = (AttrPtg) asts[7];   
    assertEquals("Goto 2 Length", (short)3, ptgGoto2.getData());
   
    assertEquals("If FALSE offset", (short)7, ifPtg.getData());
   
    FuncVarPtg funcPtg = (FuncVarPtg)asts[8];
   
   
  }
View Full Code Here

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

197
198
199
200
201
202
203
204
205
206
    assertTrue("Single Value is not an IntPtg", (asts[4] instanceof IntPtg));
    IntPtg intPtg = (IntPtg)asts[4];
    assertEquals("Result", (short)10, intPtg.getValue());
   
    assertTrue("Ptg is not a Variable Function", (asts[6] instanceof FuncVarPtg));
    FuncVarPtg funcPtg = (FuncVarPtg)asts[6];
    assertEquals("Arguments", 2, funcPtg.getNumberOfOperands());
   
   
  }
View Full Code Here

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

186
187
188
189
190
191
192
193
194
    AttrPtg ptgGoto2 = (AttrPtg) asts[7];   
    assertEquals("Goto 2 Length", (short)3, ptgGoto2.getData());
   
    assertEquals("If FALSE offset", (short)7, ifPtg.getData());
   
    FuncVarPtg funcPtg = (FuncVarPtg)asts[8];
   
   
  }
View Full Code Here

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

229
230
231
232
233
234
235
236
237
238
    assertTrue("Single Value is not an IntPtg", (asts[4] instanceof IntPtg));
    IntPtg intPtg = (IntPtg)asts[4];
    assertEquals("Result", (short)10, intPtg.getValue());
   
    assertTrue("Ptg is not a Variable Function", (asts[6] instanceof FuncVarPtg));
    FuncVarPtg funcPtg = (FuncVarPtg)asts[6];
    assertEquals("Arguments", 2, funcPtg.getNumberOfOperands());
   
   
  }
View Full Code Here

Examples of org.apache.poi.ss.formula.ptg.FuncVarPtg

64
65
66
67
68
69
70
71
72
73
74
75
        EvaluationCell cell = getSheet().getCell(rowIndex, columnIndex);
        if(cell != null && cell.getCellType() == Cell.CELL_TYPE_FORMULA){
            EvaluationWorkbook wb = _bookEvaluator.getWorkbook();
            for(Ptg ptg : wb.getFormulaTokens(cell)){
                if(ptg instanceof FuncVarPtg){
                    FuncVarPtg f = (FuncVarPtg)ptg;
                    if("SUBTOTAL".equals(f.getName())) {
                        subtotal = true;
                        break;
                    }
                }
            }
View Full Code Here

Examples of org.apache.poi.ss.formula.ptg.FuncVarPtg

67
68
69
70
71
72
73
74
75
76
77
78
        EvaluationCell cell = getSheet().getCell(rowIndex, columnIndex);
        if(cell != null && cell.getCellType() == Cell.CELL_TYPE_FORMULA){
            EvaluationWorkbook wb = _bookEvaluator.getWorkbook();
            for(Ptg ptg : wb.getFormulaTokens(cell)){
                if(ptg instanceof FuncVarPtg){
                    FuncVarPtg f = (FuncVarPtg)ptg;
                    if("SUBTOTAL".equals(f.getName())) {
                        subtotal = true;
                        break;
                    }
                }
            }
View Full Code Here

Examples of org.apache.poi.ss.formula.ptg.FuncVarPtg

149
150
151
152
153
154
155
156
157
158
159
160
    temp.add(_token);
  }

  private static boolean isIf(Ptg token) {
    if (token instanceof FuncVarPtg) {
      FuncVarPtg func = (FuncVarPtg) token;
      if (FunctionMetadataRegistry.FUNCTION_NAME_IF.equals(func.getName())) {
        return true;
      }
    }
    return false;
  }
View Full Code Here

Examples of org.apache.poi.ss.formula.ptg.FuncVarPtg

145
146
147
148
149
150
151
152
    assertEquals(AttrPtg.class,    ptgs[5].getClass());
    assertEquals(RefPtg.class, ptgs[6].getClass());
    assertEquals(AttrPtg.class,    ptgs[7].getClass());
    assertEquals(FuncVarPtg.class,   ptgs[8].getClass());

    FuncVarPtg choose = (FuncVarPtg)ptgs[8];
    assertEquals("CHOOSE", choose.getName());
  }
View Full Code Here

Examples of org.apache.poi.ss.formula.ptg.FuncVarPtg

91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
 
  public void testComplexIRR_bug45041() {
    String formula = "(1+IRR(SUMIF(A:A,ROW(INDIRECT(MIN(A:A)&\":\"&MAX(A:A))),B:B),0))^365-1";
    Ptg[] ptgs = parseFormula(formula);

    FuncVarPtg rowFunc = (FuncVarPtg) ptgs[10];
    FuncVarPtg sumifFunc = (FuncVarPtg) ptgs[12];
    assertEquals("ROW", rowFunc.getName());
    assertEquals("SUMIF", sumifFunc.getName());

    if (rowFunc.getPtgClass() == Ptg.CLASS_VALUE || sumifFunc.getPtgClass() == Ptg.CLASS_VALUE) {
      throw new AssertionFailedError("Identified bug 45041");
    }
    confirmTokenClass(ptgs, 1, Ptg.CLASS_REF);
    confirmTokenClass(ptgs, 2, Ptg.CLASS_REF);
    confirmFuncClass(ptgs, 3, "MIN", Ptg.CLASS_VALUE);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.