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 org.apache.poi.hssf.model.FormulaParser

                HSSFCell c = (HSSFCell)ci.next();
                if(c.getCellType() == HSSFCell.CELL_TYPE_FORMULA) {
                    // Since it's a formula cell, process the
                    //  formula string, and look to see if
                    //  it contains any references
                    FormulaParser fp = new FormulaParser(c.getCellFormula(), workbook);
                    fp.parse();


                    // Look for references, and update if needed
                    Ptg[] ptgs = fp.getRPNPtg();
                    boolean changed = false;
                    for(int i=0; i<ptgs.length; i++) {
                        if(ptgs[i] instanceof RefPtg) {
                            RefPtg rptg = (RefPtg)ptgs[i];
                            if(startRow <= rptg.getRowAsInt() &&
                                    rptg.getRowAsInt() <= endRow) {
                                // References a row that moved
                                rptg.setRow(rptg.getRowAsInt() + n);
                                changed = true;
                            }
                        }
                    }
                    // If any references were changed, then
                    //  re-create the formula string
                    if(changed) {
                        c.setCellFormula(
                                fp.toFormulaString(ptgs)
                        );
                    }
                }
            }
        }

View Full Code Here

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

            rec.getFormulaRecord().setOptions(( short ) 2);
            rec.getFormulaRecord().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;
            //System.out.println("got Ptgs " + ptg.length);
            for (int k = 0; k < ptg.length; k++) {
                size += ptg[ k ].getSize();
                rec.getFormulaRecord().pushExpressionToken(ptg[ k ]);

View Full Code Here

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

            rec.getFormulaRecord().setOptions(( short ) 2);
            rec.getFormulaRecord().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;
            //System.out.println("got Ptgs " + ptg.length);
            for (int k = 0; k < ptg.length; k++) {
                size += ptg[ k ].getSize();
                rec.getFormulaRecord().pushExpressionToken(ptg[ k ]);

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

            tracker.endEvaluate(workbook, sheet, srcRowNum, srcColNum);
        }
    }
    private static ValueEval evaluateCell(HSSFWorkbook workbook, HSSFSheet sheet, 
            int srcRowNum, short srcColNum, String cellFormulaText) {
        FormulaParser parser = new FormulaParser(cellFormulaText, workbook);
        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);
        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

            rec.getFormulaRecord().setOptions(( short ) 2);
            rec.getFormulaRecord().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;
            //System.out.println("got Ptgs " + ptg.length);
            for (int k = 0; k < ptg.length; k++) {
                size += ptg[ k ].getSize();
                rec.getFormulaRecord().pushExpressionToken(ptg[ k ]);

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

       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

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

                HSSFCell c = (HSSFCell)ci.next();
                if(c.getCellType() == HSSFCell.CELL_TYPE_FORMULA) {
                    // Since it's a formula cell, process the
                    //  formula string, and look to see if
                    //  it contains any references
                    FormulaParser fp = new FormulaParser(c.getCellFormula(), workbook);
                    fp.parse();


                    // Look for references, and update if needed
                    Ptg[] ptgs = fp.getRPNPtg();
                    boolean changed = false;
                    for(int i=0; i<ptgs.length; i++) {
                        if(ptgs[i] instanceof ReferencePtg) {
                            ReferencePtg rptg = (ReferencePtg)ptgs[i];
                            if(startRow <= rptg.getRowAsInt() &&
                                    rptg.getRowAsInt() <= endRow) {
                                // References a row that moved
                                rptg.setRow(rptg.getRowAsInt() + n);
                                changed = true;
                            }
                        }
                    }
                    // If any references were changed, then
                    //  re-create the formula string
                    if(changed) {
                        c.setCellFormula(
                                fp.toFormulaString(ptgs)
                        );
                    }
                }
            }
        }

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.