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

Package org.apache.poi.hssf.record.formula

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

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)


     */


    public short getExternSheetNumber(){


        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();


        }

View Full Code Here


     */


    public void setExternSheetNumber(short externSheetNumber){


        Ptg ptg;


        


        if (field_13_name_definition.isEmpty()){


            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


    


    private Ptg createNewPtg(){


        Ptg ptg = new Area3DPtg();


        field_13_name_definition.push(ptg);

View Full Code Here


     */


    public String getAreaReference(){


        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();


        }

View Full Code Here


        //Trying to find if what ptg do we need


        RangeAddress ra = new RangeAddress(ref);


        Ptg oldPtg;


        Ptg ptg;


        


        if (field_13_name_definition.isEmpty()){

View Full Code Here


        


        while (sizeCounter < size) {


            Ptg ptg = Ptg.createPtg(data, pos);


            


            pos += ptg.getSize();


            sizeCounter += ptg.getSize();


            stack.push(ptg);


        }

View Full Code Here


    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

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


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

        }


    }


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


        return ptg;
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.poi.hssf.record.formula.Ptg

org.apache.poi.hssf.dev.FormulaViewer

org.apache.poi.hssf.model.OperandClassTransformer

org.apache.poi.hssf.model.TestFormulaParser

org.apache.poi.hssf.model.TestFormulaParserIf

org.apache.poi.hssf.model.TestOperandClassTransformer

org.apache.poi.hssf.model.TestRVA

org.apache.poi.hssf.record.aggregates.CFRecordsAggregate

org.apache.poi.hssf.record.aggregates.FormulaRecordAggregate

org.apache.poi.hssf.record.ArrayRecord

org.apache.poi.hssf.record.chart.LinkedDataRecord

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.