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

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

693
694
695
696
697
698
699
700
701
702
703
704
        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
907
908
909
910
911
912
913
914
915
916
917
        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
567
568
569
570
571
572
573
574
575
576
577
578
        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
914
915
916
917
918
919
920
921
        FuncVarPtg.class,
        UnionPtg.class,
        Ref3DPtg.class,
        UnionPtg.class
    );
    MemFuncPtg mf = (MemFuncPtg)ptgs[0];
    assertEquals(45, mf.getLenRefSubexpression());
  }
View Full Code Here
935
936
937
938
939
940
941
942
        MemFuncPtg.class,
        Ref3DPtg.class,
        Ref3DPtg.class,
        RangePtg.class
    );
    MemFuncPtg mf = (MemFuncPtg)ptgs[0];
    assertEquals(15, mf.getLenRefSubexpression());
  }
View Full Code Here
1045
1046
1047
1048
1049
1050
1051
1052
1053
        MemFuncPtg.class,
        Ref3DPtg.class,
        Ref3DPtg.class,
        RangePtg.class
    );
    MemFuncPtg mf;
    mf = (MemFuncPtg)ptgs[0];
    assertEquals(15, mf.getLenRefSubexpression());
  }
View Full Code Here
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
      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,
View Full Code Here
960
961
962
963
964
965
966
967
968
969
970
        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
547
548
549
550
551
552
553
554
555
556
557
558
        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
961
962
963
964
965
966
967
968
969
970
971
        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.