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

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

993
994
995
996
997
998
999
1000
1001
1002
1003
        List temp = new ArrayList();

        if (settingRowAndColumn) {
            final int exprsSize = 2 * 11 + 1; // 2 * Area3DPtg.SIZE + UnionPtg.SIZE
            temp.add(new MemFuncPtg(exprsSize));
        }
        if (startColumn >= 0) {
            Area3DPtg colArea = new Area3DPtg(0, MAX_ROW, startColumn, endColumn,
                    false, false, false, false, externSheetIndex);
            temp.add(colArea);
View Full Code Here
708
709
710
711
712
713
714
715
716
717
718
719
        Stack ptgs = new Stack();

        if (settingRowAndColumn)
        {
            MemFuncPtg memFuncPtg = new MemFuncPtg();
            memFuncPtg.setLenRefSubexpression(23);
            ptgs.add(memFuncPtg);
        }
        if (startColumn >= 0)
        {
            Area3DPtg area3DPtg1 = new Area3DPtg();
View Full Code Here
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
        assertEquals("test", nr.getNameText());

        Ptg[] def =nr.getNameDefinition();
        assertEquals(4, def.length);

        MemFuncPtg ptgA = (MemFuncPtg)def[0];
        Area3DPtg ptgB = (Area3DPtg)def[1];
        Area3DPtg ptgC = (Area3DPtg)def[2];
        UnionPtg ptgD = (UnionPtg)def[3];
        assertEquals("", ptgA.toFormulaString());
        assertEquals(refA, ptgB.toFormulaString(eb));
        assertEquals(refB, ptgC.toFormulaString(eb));
        assertEquals(",", ptgD.toFormulaString());

        assertEquals(ref, HSSFFormulaParser.toFormulaString(wb, nr.getNameDefinition()));
View Full Code Here
975
976
977
978
979
980
981
982
        UnionPtg.class,
        Ref3DPtg.class,
        UnionPtg.class,
    };
    confirmTokenClasses(ptgs, expectedClasses);
    MemFuncPtg mf = (MemFuncPtg)ptgs[0];
    assertEquals(45, mf.getLenRefSubexpression());
  }
View Full Code Here
997
998
999
1000
1001
1002
1003
1004
        Ref3DPtg.class,
        Ref3DPtg.class,
        RangePtg.class,
    };
    confirmTokenClasses(ptgs, expectedClasses);
    MemFuncPtg mf = (MemFuncPtg)ptgs[0];
    assertEquals(15, mf.getLenRefSubexpression());
  }
View Full Code Here
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
        MemFuncPtg.class,
        Ref3DPtg.class,
        Ref3DPtg.class,
        RangePtg.class,
    });
    MemFuncPtg mf;
    mf = (MemFuncPtg)ptgs[0];
    assertEquals(15, mf.getLenRefSubexpression());

  }
View Full Code Here
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
      RefPtg.class, // [G7]
      RangePtg.class,
      AttrPtg.class, // [sum ]
    });

    MemFuncPtg mf = (MemFuncPtg)ptgs[0];
    assertEquals(57, mf.getLenRefSubexpression());
    assertEquals("D4:E5", ((AreaPtgBase)ptgs[7]).toFormulaString());
    assertTrue(((AttrPtg)ptgs[16]).isSum());

    ptgs = parseFormula("SUM(A1:B2:C3:D4)");
    confirmTokenClasses(ptgs, new Class[] {
View Full Code Here
959
960
961
962
963
964
965
966
967
968
969
        List temp = new ArrayList();

        if (settingRowAndColumn) {
            final int exprsSize = 2 * 11 + 1; // 2 * Area3DPtg.SIZE + UnionPtg.SIZE
            temp.add(new MemFuncPtg(exprsSize));
        }
        if (startColumn >= 0) {
            Area3DPtg colArea = new Area3DPtg(0, MAX_ROW, startColumn, endColumn,
                    false, false, false, false, externSheetIndex);
            temp.add(colArea);
View Full Code Here
900
901
902
903
904
905
906
907
908
909
910
911
        Stack ptgs = new Stack();

        if (settingRowAndColumn)
        {
            MemFuncPtg memFuncPtg = new MemFuncPtg();
            memFuncPtg.setLenRefSubexpression(23);
            ptgs.add(memFuncPtg);
        }
        if (startColumn >= 0)
        {
            Area3DPtg area3DPtg1 = new Area3DPtg();
View Full Code Here
962
963
964
965
966
967
968
969
970
971
972
        List temp = new ArrayList();

        if (settingRowAndColumn) {
            final int exprsSize = 2 * 11 + 1; // 2 * Area3DPtg.SIZE + UnionPtg.SIZE
            temp.add(new MemFuncPtg(exprsSize));
        }
        if (startColumn >= 0) {
            Area3DPtg colArea = new Area3DPtg(0, MAX_ROW, startColumn, endColumn,
                    false, false, false, false, externSheetIndex);
            temp.add(colArea);
View Full Code Here
TOP

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

  • org.apache.poi.hssf.model.TestFormulaParser
  • org.apache.poi.hssf.usermodel.HSSFWorkbook
  • org.apache.poi.hssf.util.TestAreaReference
  • org.apache.poi.ss.formula.FormulaParser
    • 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.