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

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

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

org.apache.poi.hssf.record.formula.AttrPtg
"Special Attributes" This seems to be a Misc Stuff and Junk record. One function it serves is in SUM functions (i.e. SUM(A1:A3) causes an area PTG then an ATTR with the SUM option set) @author andy @author Jason Height (jheight at chariot dot net dot au)

    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
          byte nArgs = 1;  // tAttrSum always has 1 parameter
          ptg = new FuncVarPtg("SUM", nArgs);
        }

View Full Code Here

                String contents = stack.pop();
                stack.push ("(" + contents + ")");
                continue;
            }
            if (ptg instanceof AttrPtg) {
                AttrPtg attrPtg = ((AttrPtg) ptg);
                if (attrPtg.isOptimizedIf() || attrPtg.isOptimizedChoose() || attrPtg.isGoto()) {
                    continue;
                }
                if (attrPtg.isSpace()) {
                    // POI currently doesn't render spaces in formulas
                    continue;
                    // but if it ever did, care must be taken:
                    // tAttrSpace comes *before* the operand it applies to, which may be consistent
                    // with how the formula text appears but is against the RPN ordering assumed here
                }
                if (attrPtg.isSemiVolatile()) {
                    // similar to tAttrSpace - RPN is violated
                    continue;
                }
                if (attrPtg.isSum()) {
                    String[] operands = getOperands(stack, attrPtg.getNumberOfOperands());
                    stack.push(attrPtg.toFormulaString(operands));
                    continue;
                }
                throw new RuntimeException("Unexpected tAttr: " + attrPtg.toString());
            }


            if (ptg instanceof WorkbookDependentFormula) {
                WorkbookDependentFormula optg = (WorkbookDependentFormula) ptg;
                stack.push(optg.toFormulaString(book));

View Full Code Here

        fp.parse();
        Ptg[] asts = fp.getRPNPtg();
        assertEquals(7, asts.length);


        BoolPtg flag  = (BoolPtg) asts[0];
    AttrPtg funif = (AttrPtg) asts[1];
        StringPtg y = (StringPtg) asts[2];
    AttrPtg goto1 = (AttrPtg) asts[3];
        StringPtg n = (StringPtg) asts[4];




        assertEquals(true, flag.getValue());
        assertEquals("Y", y.getValue());
        assertEquals("N", n.getValue());
        assertEquals("IF", funif.toFormulaString((HSSFWorkbook) null));
        assertTrue("Goto ptg exists", goto1.isGoto());
    }

View Full Code Here

    assertEquals(9, asts.length);
    
    IntPtg op1 = (IntPtg) asts[0];
    IntPtg op2 = (IntPtg) asts[1];
    EqualPtg eq = (EqualPtg) asts[2];    
    AttrPtg ifPtg = (AttrPtg) asts[3];
    IntPtg res1 = (IntPtg) asts[4];
        
    AttrPtg ptgGoto= (AttrPtg) asts[5];    
    assertEquals("Goto 1 Length", (short)10, ptgGoto.getData());
    
    IntPtg res2 = (IntPtg) asts[6];    
    AttrPtg ptgGoto2 = (AttrPtg) asts[7];    
    assertEquals("Goto 2 Length", (short)3, ptgGoto2.getData());
    
    assertEquals("If FALSE offset", (short)7, ifPtg.getData());
    
    FuncVarPtg funcPtg = (FuncVarPtg)asts[8];
  }

View Full Code Here

    fp.parse();
    Ptg[] asts = fp.getRPNPtg();
    assertEquals("11 Ptgs expected", 11, asts.length);


    assertTrue("IF Attr set correctly", (asts[3] instanceof AttrPtg));
    AttrPtg ifFunc = (AttrPtg)asts[3];
    assertTrue("It is not an if", ifFunc.isOptimizedIf());
    
    assertTrue("Average Function set correctly", (asts[5] instanceof FuncVarPtg));
  }

View Full Code Here

    fp.parse();
    Ptg[] asts = fp.getRPNPtg();
    assertEquals("7 Ptgs expected", 7, asts.length);


    assertTrue("IF Attr set correctly", (asts[3] instanceof AttrPtg));
    AttrPtg ifFunc = (AttrPtg)asts[3];
    assertTrue("It is not an if", ifFunc.isOptimizedIf());
    
    assertTrue("Single Value is not an IntPtg", (asts[4] instanceof IntPtg));
    IntPtg intPtg = (IntPtg)asts[4];
    assertEquals("Result", (short)10, intPtg.getValue());

View Full Code Here


    public void testSpaceAtStartOfFormula() {
        // Simulating cell formula of "= 4" (note space)
        // The same Ptg array can be observed if an excel file is saved with that exact formula


        AttrPtg spacePtg = AttrPtg.createSpace(AttrPtg.SpaceType.SPACE_BEFORE, 1);
        Ptg[] ptgs = { spacePtg, new IntPtg(4), };
        String formulaString;
        try {
            formulaString = FormulaParser.toFormulaString(null, ptgs);
        } catch (IllegalStateException e) {

View Full Code Here

  private static void confirmAttrData(Ptg[] ptgs, int i, int expectedData) {
    Ptg ptg = ptgs[i];
    if (!(ptg instanceof AttrPtg)) {
      throw new AssertionFailedError("Token[" + i + "] was not AttrPtg as expected");
    }
    AttrPtg attrPtg = (AttrPtg) ptg;
    assertEquals(expectedData, attrPtg.getData());
  }

View Full Code Here

  public void testYN() {
    Ptg[] ptgs = parseFormula("IF(TRUE,\"Y\",\"N\")");
    assertEquals(7, ptgs.length);


    BoolPtg flag  = (BoolPtg) ptgs[0];
    AttrPtg funif = (AttrPtg) ptgs[1];
    StringPtg y = (StringPtg) ptgs[2];
    AttrPtg goto1 = (AttrPtg) ptgs[3];
    StringPtg n = (StringPtg) ptgs[4];




    assertEquals(true, flag.getValue());
    assertEquals("Y", y.getValue());
    assertEquals("N", n.getValue());
    assertEquals("IF", funif.toFormulaString((HSSFWorkbook) null));
    assertTrue("Goto ptg exists", goto1.isGoto());
  }

View Full Code Here

  public void testNestedFunctionIf() {
    Ptg[] ptgs = parseFormula("IF(A1=B1,AVERAGE(A1:B1),AVERAGE(A2:B2))");
    assertEquals(11, ptgs.length);


    assertTrue("IF Attr set correctly", (ptgs[3] instanceof AttrPtg));
    AttrPtg ifFunc = (AttrPtg)ptgs[3];
    assertTrue("It is not an if", ifFunc.isOptimizedIf());


    assertTrue("Average Function set correctly", (ptgs[5] instanceof FuncVarPtg));
  }

View Full Code Here

0 1 2 3 4 5 6 7 8

TOP

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

org.apache.poi.hssf.model.ParseNode

org.apache.poi.hssf.model.TestFormulaParser

org.apache.poi.hssf.model.TestFormulaParserIf

org.apache.poi.ss.formula.FormulaRenderer

org.apache.poi.ss.formula.OperandClassTransformer

org.apache.poi.ss.formula.ParseNode

org.apache.poi.ss.formula.WorkbookEvaluator

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.