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

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

983
984
985
986
987
988
989
990
991
992
993
                    ParseNode other = comparisonExpression();
                    result = new ParseNode(UnionPtg.instance, result, other);
                    continue;
            }
            if (hasUnions) {
                MemFuncPtg memFuncPtg = new MemFuncPtg(result.getEncodedSize());
                result = new ParseNode(memFuncPtg, result);
            }
            return result;
        }
    }
View Full Code Here
992
993
994
995
996
997
998
999
1000
1001
1002
        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
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
        assertEquals("test", nr.getNameText());

        List def =nr.getNameDefinition();
        assertEquals(4, def.size());

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

        assertEquals(ref, nr.getAreaReference(workbook));
View Full Code Here
525
526
527
528
529
530
531
532
533
534
535
536
        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
561
562
563
564
565
566
567
568
569
570
571
572
        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
737
738
739
740
741
742
743
744
745
746
747
748
        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
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
        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, nr.getAreaReference(wb));
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.