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

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

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

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)

    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 = toFormulaString(ptgs);
    } catch (IllegalStateException e) {

View Full Code Here

0 1 2 3 4 5 6 7 8

TOP

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

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.