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

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

396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
                HSSFRow row = sheet.getRow(rowIx);
                HSSFCell cell = (row != null) ? row.getCell(colIx) : null;
                stack.push(createRef2DEval(refPtg, cell, row, sheet, workbook));
            }
            else if (ptg instanceof Ref3DPtg) {
                Ref3DPtg refPtg = (Ref3DPtg) ptg;
                int colIx = refPtg.getColumn();
                int rowIx = refPtg.getRow();
                Workbook wb = workbook.getWorkbook();
                HSSFSheet xsheet = workbook.getSheetAt(wb.getSheetIndexFromExternSheetIndex(refPtg.getExternSheetIndex()));
                HSSFRow row = xsheet.getRow(rowIx);
                HSSFCell cell = (row != null) ? row.getCell(colIx) : null;
                stack.push(createRef3DEval(refPtg, cell, row, xsheet, workbook));
            }
            else if (ptg instanceof AreaPtg) {
View Full Code Here
683
684
685
686
687
688
689
690
691
692
693
694
                if (ptg instanceof Area3DPtg) {
                    Area3DPtg a3p = (Area3DPtg) ((OperandPtg) ptg).copy();
                    a3p.setExternSheetIndex(newExtSheetIx);
                    ptgs[i] = a3p;
                } else if (ptg instanceof Ref3DPtg) {
                    Ref3DPtg r3p = (Ref3DPtg) ((OperandPtg) ptg).copy();
                    r3p.setExternSheetIndex(newExtSheetIx);
                    ptgs[i] = r3p;
                }
            }
            NameRecord newNameRecord = workbook.createBuiltInName(NameRecord.BUILTIN_FILTER_DB, newSheetIndex+1);
            newNameRecord.setNameDefinition(ptgs);
View Full Code Here
708
709
710
711
712
713
714
715
716
717
718
            ptg = new Area3DPtg();
            ((Area3DPtg) ptg).setExternSheetIndex(externSheetIndex);
            ((Area3DPtg) ptg).setArea(ref);
            this.setDefinitionTextLength((short)ptg.getSize());
        } else {
            ptg = new Ref3DPtg();
            ((Ref3DPtg) ptg).setExternSheetIndex(externSheetIndex);
            ((Ref3DPtg) ptg).setArea(ref);
            this.setDefinitionTextLength((short)ptg.getSize());
        }
View Full Code Here
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
                HSSFRow row = sheet.getRow(rownum);
                HSSFCell cell = (row != null) ? row.getCell(colnum) : null;
                pushRef2DEval(ptg, stack, cell, row, sheet, workbook);
            }
            else if (ptgs[i] instanceof Ref3DPtg) {
                Ref3DPtg ptg = (Ref3DPtg) ptgs[i];
                short colnum = ptg.getColumn();
                short rownum = ptg.getRow();
                Workbook wb = workbook.getWorkbook();
                HSSFSheet xsheet = workbook.getSheetAt(wb.getSheetIndexFromExternSheetIndex(ptg.getExternSheetIndex()));
                HSSFRow row = xsheet.getRow(rownum);
                HSSFCell cell = (row != null) ? row.getCell(colnum) : null;
                pushRef3DEval(ptg, stack, cell, row, xsheet, workbook);
            }
            else if (ptgs[i] instanceof AreaPtg) {
View Full Code Here
692
693
694
695
696
697
698
699
700
701
702
            ptg = new Area3DPtg();
            ((Area3DPtg) ptg).setExternSheetIndex(externSheetIndex);
            ((Area3DPtg) ptg).setArea(ref);
            this.setDefinitionTextLength((short)ptg.getSize());
        } else {
            ptg = new Ref3DPtg();
            ((Ref3DPtg) ptg).setExternSheetIndex(externSheetIndex);
            ((Ref3DPtg) ptg).setArea(ref);
            this.setDefinitionTextLength((short)ptg.getSize());
        }
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
120
    //  all the ptgs give back the right things
    List ptgs = ((FormulaRecord)mockListen._frecs.get(0)).getParsedExpression();
    assertEquals(1, ptgs.size());
    assertTrue(ptgs.get(0) instanceof Ref3DPtg);
   
    Ref3DPtg ptg = (Ref3DPtg)ptgs.get(0);
    assertEquals("Sheet1!A1", ptg.toFormulaString(stubHSSF));
   
   
    // Now check we get the right formula back for
    //  a few sample ones
   
View Full Code Here
696
697
698
699
700
701
702
703
704
705
706
            ptg = UnionPtg.instance;
                field_13_name_definition.push(ptg);
              this.setDefinitionTextLength( (short)(getDefinitionLength() + ptg.getSize()) );
          }
        } else {
            ptg = new Ref3DPtg();
            ((Ref3DPtg) ptg).setExternSheetIndex(externSheetIndex);
            ((Ref3DPtg) ptg).setArea(ref);
            field_13_name_definition.push(ptg);
            this.setDefinitionTextLength((short)ptg.getSize());
        }
View Full Code Here
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
                Row row = sheet.getRow(rowIx);
                Cell cell = (row != null) ? row.getCell(colIx) : null;
                stack.push(createRef2DEval(refPtg, cell, row, sheet, workbook));
            }
            else if (ptg instanceof Ref3DPtg) {
                Ref3DPtg refPtg = (Ref3DPtg) ptg;
                int colIx = refPtg.getColumn();
                int rowIx = refPtg.getRow();
                Sheet xsheet = workbook.getSheetAt(
                    workbook.getSheetIndexFromExternSheetIndex(refPtg.getExternSheetIndex())
                );
                Row row = xsheet.getRow(rowIx);
                Cell cell = (row != null) ? row.getCell(colIx) : null;
                stack.push(createRef3DEval(refPtg, cell, row, xsheet, workbook));
            }
View Full Code Here
325
326
327
328
329
330
331
332
333
334
335
336
337
338
                HSSFRow row = sheet.getRow(rownum);
                HSSFCell cell = (row != null) ? row.getCell(colnum) : null;
                pushRef2DEval(ptg, stack, cell, row, sheet, workbook);
            }
            else if (ptgs[i] instanceof Ref3DPtg) {
                Ref3DPtg ptg = (Ref3DPtg) ptgs[i];
                short colnum = ptg.getColumn();
                short rownum = ptg.getRow();
                HSSFSheet xsheet = workbook.getSheetAt(ptg.getExternSheetIndex());
                HSSFRow row = sheet.getRow(rownum);
                HSSFCell cell = (row != null) ? row.getCell(colnum) : null;
                pushRef3DEval(ptg, stack, cell, row, sheet, workbook);
            }
            else if (ptgs[i] instanceof AreaPtg) {
View Full Code Here
671
672
673
674
675
676
677
678
679
680
681
682
                if (ptg instanceof Area3DPtg) {
                    Area3DPtg a3p = (Area3DPtg) ((OperandPtg) ptg).copy();
                    a3p.setExternSheetIndex(newExtSheetIx);
                    ptgs[i] = a3p;
                } else if (ptg instanceof Ref3DPtg) {
                    Ref3DPtg r3p = (Ref3DPtg) ((OperandPtg) ptg).copy();
                    r3p.setExternSheetIndex(newExtSheetIx);
                    ptgs[i] = r3p;
                }
            }
            NameRecord newNameRecord = workbook.createBuiltInName(NameRecord.BUILTIN_FILTER_DB, newSheetIndex+1);
            newNameRecord.setNameDefinition(ptgs);
View Full Code Here
TOP

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

  • org.apache.poi.hssf.eventusermodel.TestEventWorkbookBuilder
  • org.apache.poi.hssf.record.EmbeddedObjectRefSubRecord
  • org.apache.poi.hssf.record.NameRecord
  • org.apache.poi.hssf.record.SubRecord$LbsDataSubRecord
  • org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator
  • org.apache.poi.hssf.usermodel.HSSFWorkbook
  • org.apache.poi.hssf.util.CellReference
  • org.apache.poi.hssf.util.RangeAddress
  • org.apache.poi.hssf.util.SheetReferences
  • 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.