Examples of MemFuncPtg

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

523
524
525
526
527
528
529
530
531
532
533
534
        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

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

688
689
690
691
692
693
694
695
696
697
698
699
        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

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

694
695
696
697
698
699
700
701
702
703
704
705
        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

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

935
936
937
938
939
940
941
942
943
944
945
        Stack ptgs = new Stack();

        if (settingRowAndColumn)
        {
            ptgs.add(new MemFuncPtg(23)); // TODO - where did constant '23' come from?
        }
        if (startColumn >= 0)
        {
            Area3DPtg area3DPtg1 = new Area3DPtg();
            area3DPtg1.setExternSheetIndex(externSheetIndex);
View Full Code Here

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

207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
        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

Examples of org.apache.poi.ss.formula.ptg.MemFuncPtg

986
987
988
989
990
991
992
993
994
995
996
        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

Examples of org.apache.poi.ss.formula.ptg.MemFuncPtg

259
260
261
262
263
264
265
266
267
268
269
  }

  private static ParseNode augmentWithMemPtg(ParseNode root) {
    Ptg memPtg;
    if (needsMemFunc(root)) {
      memPtg = new MemFuncPtg(root.getEncodedSize());
    } else {
      memPtg = new MemAreaPtg(root.getEncodedSize());
    }
    return new ParseNode(memPtg, root);
  }
View Full Code Here

Examples of org.apache.poi.ss.formula.ptg.MemFuncPtg

1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
        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

Examples of org.apache.poi.ss.formula.ptg.MemFuncPtg

1060
1061
1062
1063
1064
1065
1066
1067
        FuncVarPtg.class,
        UnionPtg.class,
        Ref3DPtg.class,
        UnionPtg.class
    );
    MemFuncPtg mf = (MemFuncPtg)ptgs[0];
    assertEquals(45, mf.getLenRefSubexpression());
  }
View Full Code Here

Examples of org.apache.poi.ss.formula.ptg.MemFuncPtg

1081
1082
1083
1084
1085
1086
1087
1088
        MemFuncPtg.class,
        Ref3DPtg.class,
        Ref3DPtg.class,
        RangePtg.class
    );
    MemFuncPtg mf = (MemFuncPtg)ptgs[0];
    assertEquals(15, mf.getLenRefSubexpression());
  }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.