Examples of Ptg

com.extentech.formats.XLS.formulas.Ptg
Ptg is the interface all ptgs implement in order to be handled equally under the eyes of the all seeing one, "he that shall not be named" A ptg is a unique segment of a formula stack that indicates a value, a reference to a value, or an operation. See the docs under Formula for more information. @see Ptg @see Formula
org.apache.poi.hssf.record.formula.Ptg
Ptg represents a syntactic token in a formula. 'PTG' is an acronym for 'parse thing'. Originally, the name referred to the single byte identifier at the start of the token, but in POI, Ptg encapsulates the whole formula token (initial byte + value data).
Ptgs are logically arranged in a tree representing the structure of the parsed formula. However, in BIFF files Ptgs are written/read in Reverse-Polish Notation order. The RPN ordering also simplifies formula evaluation logic, so POI mostly accesses Ptgs in the same way. @author andy @author avik @author Jason Height (jheight at chariot dot net dot au)
org.apache.poi.ss.formula.ptg.Ptg
Ptg represents a syntactic token in a formula. 'PTG' is an acronym for 'parse thing'. Originally, the name referred to the single byte identifier at the start of the token, but in POI, Ptg encapsulates the whole formula token (initial byte + value data).
Ptgs are logically arranged in a tree representing the structure of the parsed formula. However, in BIFF files Ptgs are written/read in Reverse-Polish Notation order. The RPN ordering also simplifies formula evaluation logic, so POI mostly accesses Ptgs in the same way. @author andy @author avik @author Jason Height (jheight at chariot dot net dot au)
org.zkoss.poi.ss.formula.ptg.Ptg

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


    Stack<ValueEval> stack = new Stack<ValueEval>();
    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 AttrPtg) {
        AttrPtg attrPtg = (AttrPtg) ptg;
        if (attrPtg.isSum()) {
          // Excel prefers to encode 'SUM()' as a tAttr token, but this evaluator
          // expects the equivalent function token

View Full Code Here

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

    sb.append("    .NameIsMultibyte        = ").append(field_11_nameIsMultibyte).append("\n");
    sb.append("    .Name (Unicode text)    = ").append( getNameText() ).append("\n");
    Ptg[] ptgs = field_13_name_definition.getTokens();
    sb.append("    .Formula (nTokens=").append(ptgs.length).append("):") .append("\n");
    for (int i = 0; i < ptgs.length; i++) {
      Ptg ptg = ptgs[i];
      sb.append("       " + ptg.toString()).append(ptg.getRVAType()).append("\n");
    }


    sb.append("    .Menu text       = ").append(field_14_custom_menu_text).append("\n");
    sb.append("    .Description text= ").append(field_15_description_text).append("\n");
    sb.append("    .Help topic text = ").append(field_16_help_topic_text).append("\n");

View Full Code Here

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

   */
  public int getExternSheetNumber(){
    if (field_13_name_definition.getEncodedSize() < 1) {
      return 0;
    }
    Ptg ptg = field_13_name_definition.getTokens()[0];


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


    }
    if (ptg.getClass() == Ref3DPtg.class){
      return ((Ref3DPtg) ptg).getExternSheetIndex();
    }
    return 0;
  }

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 {

View Full Code Here

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

        Stack stack = new Stack();
        int   pos           = start_of_expression + offset;
        int   sizeCounter   = 0;
        try {
            while (sizeCounter < size) {
                Ptg ptg = Ptg.createPtg(data, pos);


                pos += ptg.getSize();
                sizeCounter += ptg.getSize();
                stack.push(ptg);
            }
        } catch (java.lang.UnsupportedOperationException uoe) {
            System.err.println("[WARNING] Unknown Ptg "
                    + uoe.getMessage() );

View Full Code Here

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


    private void serializePtgs(byte [] data, int offset) {
        int pos = offset;


        for (int k = 0; k < field_13_name_definition.size(); k++) {
            Ptg ptg = ( Ptg ) field_13_name_definition.get(k);


            ptg.writeBytes(data, pos);
            pos += ptg.getSize();
        }
    }

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) 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(){
        if (field_13_name_definition == null) return "#REF!";
        Ptg ptg = (Ptg) field_13_name_definition.peek();
        String result = "";


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


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


        return result;
    }

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.