Examples of Ptg


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

      int result = 0;
        List list   = field_13_name_definition;
       
        for (int k = 0; k < list.size(); k++)
        {
          Ptg ptg = ( Ptg ) list.get(k);
         
          result += ptg.getSize();
        }
        return result;   
    }
View Full Code Here

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

    /** gets the extern sheet number
     * @return extern sheet index
     */
    public short getExternSheetNumber(){
        if (field_13_name_definition == null || field_13_name_definition.isEmpty()) return 0;
        Ptg ptg = (Ptg) field_13_name_definition.peek();
        short result = 0;

        if (ptg.getClass() == Area3DPtg.class){
            result = ((Area3DPtg) ptg).getExternSheetIndex();

        } else if (ptg.getClass() == Ref3DPtg.class){
            result = ((Ref3DPtg) ptg).getExternSheetIndex();
        }

        return result;
    }
View Full Code Here

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

    /** sets the extern sheet number
     * @param externSheetNumber extern sheet number
     */
    public void setExternSheetNumber(short externSheetNumber){
        Ptg ptg;

        if (field_13_name_definition == null || field_13_name_definition.isEmpty()){
            field_13_name_definition = new Stack();
            ptg = createNewPtg();
        } else {
            ptg = (Ptg) field_13_name_definition.peek();
        }

        if (ptg.getClass() == Area3DPtg.class){
            ((Area3DPtg) ptg).setExternSheetIndex(externSheetNumber);

        } else if (ptg.getClass() == Ref3DPtg.class){
            ((Ref3DPtg) ptg).setExternSheetIndex(externSheetNumber);
        }

    }
View Full Code Here

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

        }

    }

    private Ptg createNewPtg(){
        Ptg ptg = new Area3DPtg();
        field_13_name_definition.push(ptg);

        return ptg;
    }
View Full Code Here

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

    /** gets the reference , the area only (range)
     * @return area reference
     */
    public String getAreaReference(Workbook book){
        if (field_13_name_definition == null || field_13_name_definition.isEmpty()) return "Error";
        Ptg ptg = (Ptg) field_13_name_definition.peek();
        String result = "";

        if (ptg.getClass() == Area3DPtg.class){
            result = ptg.toFormulaString(book);

        } else if (ptg.getClass() == Ref3DPtg.class){
            result = ptg.toFormulaString(book);
        } else if (ptg.getClass() == DeletedArea3DPtg.class || ptg.getClass() == DeletedRef3DPtg.class) {
          result = "#REF!"   ;     }

        return result;
    }
View Full Code Here

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

     * @param ref area reference
     */
    public void setAreaReference(String ref){
        //Trying to find if what ptg do we need
        RangeAddress ra = new RangeAddress(ref);
        Ptg oldPtg;
        Ptg ptg;

        if (field_13_name_definition==null ||field_13_name_definition.isEmpty()){
            field_13_name_definition = new Stack();
            oldPtg = createNewPtg();
        } else {
            //Trying to find extern sheet index
            oldPtg = (Ptg) field_13_name_definition.pop();
        }

        short externSheetIndex = 0;

        if (oldPtg.getClass() == Area3DPtg.class){
            externSheetIndex =  ((Area3DPtg) oldPtg).getExternSheetIndex();

        } else if (oldPtg.getClass() == Ref3DPtg.class){
            externSheetIndex =  ((Ref3DPtg) oldPtg).getExternSheetIndex();
        }

        if (ra.hasRange()) {
            ptg = new Area3DPtg();
            ((Area3DPtg) ptg).setExternSheetIndex(externSheetIndex);
            ((Area3DPtg) ptg).setArea(ref);
            this.setDefinitionTextLength((short)ptg.getSize());
        } else {
            ptg = new Ref3DPtg();
            ((Ref3DPtg) ptg).setExternSheetIndex(externSheetIndex);
            ((Ref3DPtg) ptg).setArea(ref);
            this.setDefinitionTextLength((short)ptg.getSize());
        }

        field_13_name_definition.push(ptg);

    }
View Full Code Here

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

    AbstractFunctionPtg afp = (AbstractFunctionPtg) ptgs[i];
    assertEquals(expectedFunctionName, afp.getName());
  }

  private void confirmTokenClass(Ptg[] ptgs, int i, byte operandClass) {
    Ptg ptg = ptgs[i];
    if (operandClass != ptg.getPtgClass()) {
      throw new AssertionFailedError("Wrong operand class for function ptg ("
          + ptg.toString() + "). Expected " + getOperandClassName(operandClass)
          + " but got " + getOperandClassName(ptg.getPtgClass()));
    }
  }
View Full Code Here

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

        Stack stack = new Stack();
        for (int i = 0, iSize = ptgs.length; i < iSize; i++) {

            // since we don't know how to handle these yet :(
            Ptg ptg = ptgs[i];
            if (ptg instanceof ControlPtg) {
                // skip Parentheses, Attr, etc
                continue;
            }
            if (ptg instanceof MemErrPtg) { continue; }
View Full Code Here

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

    transformNode(rootNode, rootNodeOperandClass, false);
  }

  private void transformNode(ParseNode node, byte desiredOperandClass,
      boolean callerForceArrayFlag) {
    Ptg token = node.getToken();
    ParseNode[] children = node.getChildren();
    if (token instanceof ValueOperatorPtg || token instanceof ControlPtg) {
      // Value Operator Ptgs and Control are base tokens, so token will be unchanged
     
      // but any child nodes are processed according to desiredOperandClass and callerForceArrayFlag
      for (int i = 0; i < children.length; i++) {
        ParseNode child = children[i];
        transformNode(child, desiredOperandClass, callerForceArrayFlag);
      }
      return;
    }
    if (token instanceof AbstractFunctionPtg) {
      transformFunctionNode((AbstractFunctionPtg) token, children, desiredOperandClass,
          callerForceArrayFlag);
      return;
    }
    if (children.length > 0) {
      throw new IllegalStateException("Node should not have any children");
    }

    if (token.isBaseToken()) {
      // nothing to do
      return;
    }
        if (callerForceArrayFlag) {
          switch (desiredOperandClass) {
            case Ptg.CLASS_VALUE:
            case Ptg.CLASS_ARRAY:
              token.setClass(Ptg.CLASS_ARRAY);
              break;
            case Ptg.CLASS_REF:
              token.setClass(Ptg.CLASS_REF);
              break;
            default:
              throw new IllegalStateException("Unexpected operand class ("
                  + desiredOperandClass + ")");
          }
        } else {
          token.setClass(desiredOperandClass);
        }
  }
View Full Code Here

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

  }

  private static Ptg parseSingleToken(String formula, Class ptgClass) {
    Ptg[] ptgs = parseFormula(formula);
    assertEquals(1, ptgs.length);
    Ptg result = ptgs[0];
    assertEquals(ptgClass, result.getClass());
    return result;
  }
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.