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)

    /** gets the reference , the area only (range)
     * @return area reference
     */
    public String getAreaReference(SheetReferences refs){
        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).toFormulaString(refs);


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


        return result;
    }

View Full Code Here

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

        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

    public void testLinkFormula() {
        RecordInputStream is = new RecordInputStream(new ByteArrayInputStream(linkData));
        is.nextRecord();
        TextObjectRecord rec = new TextObjectRecord(is);


        Ptg ptg = rec.getLinkRefPtg();
        assertNotNull(ptg);
        assertEquals(RefPtg.class, ptg.getClass());
        RefPtg rptg = (RefPtg) ptg;
        assertEquals("T2", rptg.toFormulaString());


        byte [] data2 = rec.serialize();
        assertEquals(linkData.length, data2.length);

View Full Code Here

        }
        return parseRangeExpression(iden);
    }


    private ParseNode parseRangeExpression(Identifier iden) {
        Ptg ptgA = parseNameOrCellRef(iden);
        if (look == ':') {
            GetChar();
            Identifier iden2 = parseIdentifier();
            Ptg ptgB = parseNameOrCellRef(iden2);
            Ptg simplified = reduceRangeExpression(ptgA, ptgB);
            
            if (simplified == null) {
                ParseNode[] children = {
                    new ParseNode(ptgA),    
                    new ParseNode(ptgB),

View Full Code Here

     * Excel function, and has not been encountered before.
     *
     * @param name case preserved function name (as it was entered/appeared in the formula).
     */
    private ParseNode function(String name) {
        Ptg nameToken = null;
        if(!AbstractFunctionPtg.isBuiltInFunctionName(name)) {
            // user defined function
            // in the token tree, the name is more or less the first argument


            EvaluationName hName = _book.getName(name, _sheetIndex);

View Full Code Here

    /** Parse and Translate a Math Term */
    private ParseNode  Term() {
        ParseNode result = powerFactor();
        while(true) {
            SkipWhite();
            Ptg operator;
            switch(look) {
                case '*':
                    Match('*');
                    operator = MultiplyPtg.instance;
                    break;

View Full Code Here

            SkipWhite();
            switch(look) {
                case '=':
                case '>':
                case '<':
                    Ptg comparisonToken = getComparisonToken();
                    ParseNode other = concatExpression();
                    result = new ParseNode(comparisonToken, result, other);
                    continue;
            }
            return result; // finished with predicate expression

View Full Code Here

    /** Parse and Translate an Expression */
    private ParseNode additiveExpression() {
        ParseNode result = Term();
        while (true) {
            SkipWhite();
            Ptg operator;
            switch(look) {
                case '+':
                    Match('+');
                    operator = AddPtg.instance;
                    break;

View Full Code Here

    sb.append("  .zero      = ").append(HexDump.intToHex(field_6_zero)).append("\n");


    Ptg[] ptgs = field_8_parsed_expr.getTokens();
    for (int k = 0; k < ptgs.length; k++ ) {
      sb.append("    Ptg[").append(k).append("]=");
      Ptg ptg = ptgs[k];
      sb.append(ptg.toString()).append(ptg.getRVAType()).append("\n");
    }
    sb.append("[/FORMULA]\n");
    return sb.toString();
  }

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.