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

  }


  private static Ptg parseSingleToken(String formula, Class<? extends Ptg> ptgClass) {
    Ptg[] ptgs = parseFormula(formula);
    assertEquals(1, ptgs.length);
    Ptg result = ptgs[0];
    assertEquals(ptgClass, result.getClass());
    return result;
  }

View Full Code Here

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

    cell.setCellFormula("[multibookFormulaB.xls]AnotherSheet!B1");
    assertEquals("[multibookFormulaB.xls]AnotherSheet!B1", cell.getCellFormula());
  }
  private static void confirmSingle3DRef(Ptg[] ptgs, int expectedExternSheetIndex) {
    assertEquals(1, ptgs.length);
    Ptg ptg0 = ptgs[0];
    assertTrue(ptg0 instanceof Ref3DPtg);
    assertEquals(expectedExternSheetIndex, ((Ref3DPtg)ptg0).getExternSheetIndex());
  }

View Full Code Here

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

            NameRecord origNameRecord = workbook.getNameRecord(filterDbNameIndex);
            // copy original formula but adjust 3D refs to the new external sheet index
            int newExtSheetIx = workbook.checkExternSheet(newSheetIndex);
            Ptg[] ptgs = origNameRecord.getNameDefinition();
            for (int i=0; i< ptgs.length; i++) {
                Ptg ptg = ptgs[i];


                if (ptg instanceof Area3DPtg) {
                    Area3DPtg a3p = (Area3DPtg) ((OperandPtg) ptg).copy();
                    a3p.setExternSheetIndex(newExtSheetIx);
                    ptgs[i] = a3p;

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 || 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

        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);
                field_13_raw_name_definition=new byte[size];
                System.arraycopy(data,offset,field_13_raw_name_definition,0,size);
            }
        } catch (java.lang.UnsupportedOperationException uoe) {

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.