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

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

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

org.apache.poi.hssf.record.formula.NamePtg
@author andy @author Jason Height (jheight at chariot dot net dot au)


    public boolean isRange() {
      return _nameRecord.hasFormula(); // TODO - is this right?
    }
    public NamePtg createPtg() {
      return new NamePtg(_index);
    }

View Full Code Here

    }
    public boolean isRange() {
      return _nameRecord.hasFormula(); // TODO - is this right?
    }
    public NamePtg createPtg() {
      return new NamePtg(_index);
    }

View Full Code Here


    public boolean isRange() {
      return hasFormula(); // TODO - is this right?
    }
    public NamePtg createPtg() {
      return new NamePtg(_index);
    }

View Full Code Here

  private Eval getEvalForPtg(Ptg ptg, int sheetIndex, EvaluationTracker tracker) {
    //  consider converting all these (ptg instanceof XxxPtg) expressions to (ptg.getClass() == XxxPtg.class)


    if (ptg instanceof NamePtg) {
      // named ranges, macro functions
      NamePtg namePtg = (NamePtg) ptg;
      EvaluationName nameRecord = _workbook.getName(namePtg);
      if (nameRecord.isFunctionName()) {
        return new NameEval(nameRecord.getNameText());
      }
      if (nameRecord.hasFormula()) {

View Full Code Here


    Ptg[] ptg = HSSFFormulaParser.parse("myFunc()", w);
    // myFunc() actually takes 1 parameter.  Don't know if POI will ever be able to detect this problem


    // the name gets encoded as the first arg
    NamePtg tname = (NamePtg) ptg[0];
    assertEquals("myFunc", tname.toFormulaString(book));


    AbstractFunctionPtg tfunc = (AbstractFunctionPtg) ptg[1];
    assertTrue(tfunc.isExternalFunction());
  }

View Full Code Here

        Ptg[] ptg = fp.getRPNPtg();


        AbstractFunctionPtg tfunc = (AbstractFunctionPtg) ptg[0];
        assertEquals("externalflag", tfunc.getName());


        NamePtg tname = (NamePtg) ptg[1];
        assertEquals("FOO", tname.toFormulaString(w));
    }

View Full Code Here

        Ptg[] ptg = fp.getRPNPtg();


        AbstractFunctionPtg tfunc = (AbstractFunctionPtg) ptg[0];
        assertEquals("externalflag", tfunc.getName());


        NamePtg tname = (NamePtg) ptg[1];
        assertEquals("FOO", tname.toFormulaString(w));
    }

View Full Code Here

        Ptg[] ptg = fp.getRPNPtg();


        AbstractFunctionPtg tfunc = (AbstractFunctionPtg) ptg[0];
        assertEquals("externalflag", tfunc.getName());


        NamePtg tname = (NamePtg) ptg[1];
        assertEquals("FOO", tname.toFormulaString(w));
    }

View Full Code Here

        Ptg[] ptg = fp.getRPNPtg();


        AbstractFunctionPtg tfunc = (AbstractFunctionPtg) ptg[0];
        assertEquals("externalflag", tfunc.getName());


        NamePtg tname = (NamePtg) ptg[1];
        assertEquals("FOO", tname.toFormulaString(w));
    }

View Full Code Here


    Ptg[] ptg = HSSFFormulaParser.parse("myFunc()", w);
    // myFunc() actually takes 1 parameter.  Don't know if POI will ever be able to detect this problem


    // the name gets encoded as the first arg
    NamePtg tname = (NamePtg) ptg[0];
    assertEquals("myFunc", tname.toFormulaString(book));


    AbstractFunctionPtg tfunc = (AbstractFunctionPtg) ptg[1];
    assertTrue(tfunc.isExternalFunction());
  }

View Full Code Here

0 1 2 3 4

TOP

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

org.apache.poi.hssf.model.TestFormulaParser

org.apache.poi.hssf.record.NameRecord

org.apache.poi.hssf.usermodel.HSSFEvaluationWorkbook$Name

org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator

org.apache.poi.hssf.usermodel.HSSFName

org.apache.poi.hssf.usermodel.TestFormulas

org.apache.poi.ss.formula.WorkbookEvaluator

org.apache.poi.ss.usermodel.FormulaEvaluator

org.apache.poi.ss.usermodel.Name

org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook$Name

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.