Examples of FuncVarPtg

org.apache.poi.hssf.record.formula.FuncVarPtg
@author Jason Height (jheight at chariot dot net dot au)
org.apache.poi.ss.formula.ptg.FuncVarPtg
@author Jason Height (jheight at chariot dot net dot au)

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

    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.hssf.record.formula.FuncVarPtg

        AttrPtg attrPtg = (AttrPtg) ptg;
        if (attrPtg.isSum()) {
          // Excel prefers to encode 'SUM()' as a tAttr token, but this evaluator
          // expects the equivalent function token
          byte nArgs = 1;  // tAttrSum always has 1 parameter
          ptg = new FuncVarPtg("SUM", nArgs);
        }
      }
      if (ptg instanceof ControlPtg) {
        // skip Parentheses, Attr, etc
        continue;

View Full Code Here

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

    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

    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

    assertTrue("Single Value is not an IntPtg", (ptgs[4] instanceof IntPtg));
    IntPtg intPtg = (IntPtg)ptgs[4];
    assertEquals("Result", (short)10, intPtg.getValue());


    assertTrue("Ptg is not a Variable Function", (ptgs[6] instanceof FuncVarPtg));
    FuncVarPtg funcPtg = (FuncVarPtg)ptgs[6];
    assertEquals("Arguments", 2, funcPtg.getNumberOfOperands());
  }

View Full Code Here

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

    }
    
    if (isSingleArgSum(token)) {
      // Need to process the argument of SUM with transformFunctionNode below
      // so make a dummy FuncVarPtg for that call.
      token = new FuncVarPtg("SUM", (byte)1);
      // Note - the tAttrSum token (node.getToken()) is a base 
      // token so does not need to have its operand class set
    }
    if (token instanceof ValueOperatorPtg || token instanceof ControlPtg
        || token instanceof MemFuncPtg

View Full Code Here

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

    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.hssf.record.formula.FuncVarPtg

    Ptg[] ptgs = {
        new RefPtg("C1"),
        new RefPtg("C1"),
        new IntPtg(0),
        new RefPtg("B1"),
        new FuncVarPtg("OFFSET", (byte)3),
        RangePtg.instance,
        AttrPtg.SUM,
      };
    fr.setParsedExpression(ptgs);
  }

View Full Code Here

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

        AttrPtg attrPtg = (AttrPtg) ptg;
        if (attrPtg.isSum()) {
          // Excel prefers to encode 'SUM()' as a tAttr token, but this evaluator
          // expects the equivalent function token
          byte nArgs = 1;  // tAttrSum always has 1 parameter
          ptg = new FuncVarPtg("SUM", nArgs);
        }
      }
      if (ptg instanceof ControlPtg) {
        // skip Parentheses, Attr, etc
        continue;

View Full Code Here

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

    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

0 1 2 3 4 5

TOP

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.