Examples of FormulaParser

jxl.biff.formula.FormulaParser
Parses the formula passed in (either as parsed strings or as a string) into a tree of operators and operands
org.apache.mahout.pig.encoders.FormulaParser
org.apache.poi.hssf.model.FormulaParser
This class parses a formula string into a List of tokens in RPN order. Inspired by Lets Build a Compiler, by Jack Crenshaw BNF for the formula expression is : ::= [ ] ::= [ ] ::= | () | | ::= ([expression [, expression]*]) @author Avik Sengupta @author Andrew C. oliver (acoliver at apache dot org) @author Eric Ladner (eladner at goldinc dot com) @author Cameron Riley (criley at ekmail.com) @author Peter M. Murray (pete at quantrix dot com)
org.apache.poi.hssf.record.formula.FormulaParser
EXPERIMENTAL code to parse formulas back and forth between RPN and not @author Avik Sengupta
org.jfree.formula.parser.FormulaParser
org.openntf.formula.FormulaParser
This class adds additonal functionality to the AtFormulaParserImpl (which is auto generated). @author Roland Praml, Foconis AG
org.outerj.expression.FormulaParser
org.pentaho.reporting.libraries.formula.parser.FormulaParser
org.sbml.jsbml.text.parser.FormulaParser
@since 0.8 @version $Rev: 1524 $

Examples of jxl.biff.formula.FormulaParser


      if (formula1Length != 0)
      {
        byte[] tokens = new byte[formula1Length];
        System.arraycopy(data, formula1Pos, tokens, 0, formula1Length);
        formula1 = new FormulaParser(tokens, tmprt, es, nt,ws);
        formula1.parse();
      }


      if (formula2Length != 0)
      {
        byte[] tokens = new byte[formula2Length];
        System.arraycopy(data, formula2Pos, tokens, 0, formula2Length);
        formula2 = new FormulaParser(tokens, tmprt, es, nt, ws);
        formula2.parse();
      }
    }
    catch (FormulaException e)
    {

View Full Code Here

Examples of jxl.biff.formula.FormulaParser

    row1 = row;
    row2 = row;
    column1 = col;
    column2 = col;


    formula1 = new FormulaParser(formula1String,
                                 es, nt, ws, 
                                 ParseContext.DATA_VALIDATION);
    formula1.parse();


    if (formula2String != null)
    {
      formula2 = new FormulaParser(formula2String,
                                   es, nt, ws, 
                                   ParseContext.DATA_VALIDATION);
      formula2.parse();
    }
  }

View Full Code Here

Examples of org.apache.mahout.pig.encoders.FormulaParser

    }


    private EncodingSpec parse(String s) throws IOException, RecognitionException {
        Reader reader = new StringReader(s);
        CommonTokenStream input = new CommonTokenStream(new FormulaLexer(new ANTLRReaderStream(reader)));
        FormulaParser tokenParser = new FormulaParser(input);
        FormulaParser.expression_return parserResult = tokenParser.expression();
        reader.close();
        return parserResult.r;
    }

View Full Code Here

Examples of org.apache.poi.hssf.model.FormulaParser

            frec.setOptions(( short ) 2);
            frec.setValue(0);
            
            //only set to default if there is no extended format index already set
            if (rec.getXFIndex() == (short)0) rec.setXFIndex(( short ) 0x0f);
            FormulaParser fp = new FormulaParser(formula+";",book);
            fp.parse();
            Ptg[] ptg  = fp.getRPNPtg();
            int   size = 0;


            // clear the Ptg Stack
            for (int i=0, iSize=frec.getNumberOfExpressionTokens(); i<iSize; i++) {
                frec.popExpressionToken();

View Full Code Here

Examples of org.apache.poi.hssf.model.FormulaParser

     * @return
     */
    protected static ValueEval internalEvaluate(HSSFCell srcCell, HSSFRow srcRow, HSSFSheet sheet, HSSFWorkbook workbook) {
        int srcRowNum = srcRow.getRowNum();
        short srcColNum = srcCell.getCellNum();
        FormulaParser parser = new FormulaParser(srcCell.getCellFormula(), workbook.getWorkbook());
        parser.parse();
        Ptg[] ptgs = parser.getRPNPtg();
        // -- parsing over --
        


        Stack stack = new Stack();
        for (int i = 0, iSize = ptgs.length; i < iSize; i++) {

View Full Code Here

Examples of org.apache.poi.hssf.model.FormulaParser

     * @param formula
     * @param sheet
     * @param workbook
     */
    void inspectPtgs(String formula) {
        FormulaParser fp = new FormulaParser(formula, workbook.getWorkbook());
        fp.parse();
        Ptg[] ptgs = fp.getRPNPtg();
        System.out.println("<ptg-group>");
        for (int i = 0, iSize = ptgs.length; i < iSize; i++) {
            System.out.println("<ptg>");
            System.out.println(ptgs[i]);
            if (ptgs[i] instanceof OperationPtg) {

View Full Code Here

Examples of org.apache.poi.hssf.model.FormulaParser

            frec.setOptions(( short ) 2);
            frec.setValue(0);
            
            //only set to default if there is no extended format index already set
            if (rec.getXFIndex() == (short)0) rec.setXFIndex(( short ) 0x0f);
            FormulaParser fp = new FormulaParser(formula+";",book);
            fp.parse();
            Ptg[] ptg  = fp.getRPNPtg();
            int   size = 0;


            // clear the Ptg Stack
            for (int i=0, iSize=frec.getNumberOfExpressionTokens(); i<iSize; i++) {
                frec.popExpressionToken();

View Full Code Here

Examples of org.apache.poi.hssf.model.FormulaParser

     * This will allow you to generate the Ptgs yourself, if
     *  your needs are more complex than just having the
     *  formula evaluated. 
     */
    public static FormulaParser getUnderlyingParser(HSSFWorkbook workbook, String formula) {
        return new FormulaParser(formula, workbook);
    }

View Full Code Here

Examples of org.apache.poi.hssf.model.FormulaParser

     * @param formula
     * @param sheet
     * @param workbook
     */
    void inspectPtgs(String formula) {
        FormulaParser fp = new FormulaParser(formula, workbook);
        fp.parse();
        Ptg[] ptgs = fp.getRPNPtg();
        System.out.println("<ptg-group>");
        for (int i = 0, iSize = ptgs.length; i < iSize; i++) {
            System.out.println("<ptg>");
            System.out.println(ptgs[i]);
            if (ptgs[i] instanceof OperationPtg) {

View Full Code Here

Examples of org.apache.poi.hssf.model.FormulaParser

       dvRecord.setStringField( DVRecord.STRING_ERROR_TITLE, obj_validation.getErrorBoxTitle());
       dvRecord.setStringField( DVRecord.STRING_ERROR_TEXT, obj_validation.getErrorBoxText());


       //formula fields ( size and data )
       String str_formula = obj_validation.getFirstFormula();
       FormulaParser fp = new FormulaParser(str_formula, workbook);
       fp.parse();
       Stack ptg_arr = new Stack();
       Ptg[] ptg  = fp.getRPNPtg();
       int size = 0;
       for (int k = 0; k < ptg.length; k++)
       {
           if ( ptg[k] instanceof org.apache.poi.hssf.record.formula.AreaPtg )
           {
              //we should set ptgClass to Ptg.CLASS_REF and explicit formula string to false
              ptg[k].setClass(Ptg.CLASS_REF);
              obj_validation.setExplicitListFormula(false);
           }
           size += ptg[k].getSize();
           ptg_arr.push(ptg[k]);
       }
       dvRecord.setFirstFormulaRPN(ptg_arr);
       dvRecord.setFirstFormulaSize((short)size);


       dvRecord.setListExplicitFormula(obj_validation.getExplicitListFormula());


       if ( obj_validation.getSecondFormula() != null )
       {
         str_formula = obj_validation.getSecondFormula();
         fp = new FormulaParser(str_formula, workbook);
         fp.parse();
         ptg_arr = new Stack();
         ptg  = fp.getRPNPtg();
         size = 0;
         for (int k = 0; k < ptg.length; k++)
         {
             size += ptg[k].getSize();
             ptg_arr.push(ptg[k]);

View Full Code Here

0 1 2 3 4 5

TOP

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.