Package org.apache.poi.hssf.model

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

51
52
53
54
55
56
57
58
59
60
61
62
63
     * @param sheet
     * @param workbook
     */
    void inspectPtgs(String formula) {
      HSSFWorkbook hssfWb = (HSSFWorkbook)workbook;
        FormulaParser fp = new FormulaParser(formula, hssfWb);
        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
278
279
280
281
282
283
284
285
286
287
288
289
290
     * @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
675
676
677
678
679
680
681
682
683
684
685
686
687
     * @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
643
644
645
646
647
648
649
650
651
652
653
654
655
            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
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
 
  private String shiftAllColumnsBy1(String  formula)
  {
    int letUsShiftColumn1By1Column=1;
   
    FormulaParser parser = new FormulaParser(formula,null);
    parser.parse();

    final Ptg[] ptgs = parser.getRPNPtg();
    for(int i=0; i<ptgs.length; i++)
    {
      Ptg ptg = ptgs[i];
      if (ptg instanceof AreaPtg )
      {
        AreaPtg aptg = (AreaPtg)ptg;
        aptg.setFirstColumn((short)(aptg.getFirstColumn()+letUsShiftColumn1By1Column));
        aptg.setLastColumn((short)(aptg.getLastColumn()+letUsShiftColumn1By1Column));
      }
    }
    String newFormula = parser.toFormulaString(ptgs);
    return newFormula;
  }
View Full Code Here
708
709
710
711
712
713
714
715
716
717
718
719
720
            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
171
172
173
174
175
176
177
     * 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.getWorkbook());
    }
View Full Code Here
355
356
357
358
359
360
361
362
363
364
365
366
367
     * @param workbook
     */
    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
743
744
745
746
747
748
749
750
751
752
753
754
755
     * @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
672
673
674
675
676
677
678
679
680
681
682
683
684
            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
TOP

Related Classes of org.apache.poi.hssf.model.FormulaParser$Node

  • ca.eandb.jmist.framework.color.Color
  • ca.eandb.jmist.math.Point2
  • ca.eandb.jmist.math.Point3
  • ca.eandb.jmist.math.Ray3
  • ca.eandb.jmist.math.SphericalCoordinates
  • ca.eandb.jmist.math.Vector3
  • cc.mallet.types.FeatureVector
  • cc.mallet.types.Instance
  • cc.mallet.types.InstanceList
  • com.badlogic.gdx.math.Rectangle
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.