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

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

214
215
216
217
218
219
220
221
222
      byte ptgSid = in.readByte();
      switch(ptgSid) {
        case AreaPtg.sid:   return new AreaPtg(in);
        case Area3DPtg.sid: return new Area3DPtg(in);
        case RefPtg.sid:    return new RefPtg(in);
        case Ref3DPtg.sid:  return new Ref3DPtg(in);
      }
      return null;
    }
View Full Code Here
546
547
548
549
550
551
552
553
554
555
556
            ptg = new Area3DPtg();
            ((Area3DPtg) ptg).setExternSheetIndex(externSheetIndex);
            ((Area3DPtg) ptg).setArea(ref);
            this.setDefinitionTextLength((short)((Area3DPtg) ptg).getSize());
        } else {
            ptg = new Ref3DPtg();
            ((Ref3DPtg) ptg).setExternSheetIndex(externSheetIndex);
            ((Ref3DPtg) ptg).setArea(ref);
            this.setDefinitionTextLength((short)((Ref3DPtg) ptg).getSize());
        }
View Full Code Here
682
683
684
685
686
687
688
689
690
691
692
693
               
                if (ptg instanceof Area3DPtg) {
                    Area3DPtg a3p = (Area3DPtg) ptg;
                    a3p.setExternSheetIndex(newExtSheetIx);
                } else if (ptg instanceof Ref3DPtg) {
                    Ref3DPtg r3p = (Ref3DPtg) ptg;
                    r3p.setExternSheetIndex(newExtSheetIx);
                }
                ptgs[i] = ptg;
            }
            NameRecord newNameRecord = workbook.createBuiltInName(NameRecord.BUILTIN_FILTER_DB, newSheetIndex+1);
            newNameRecord.setNameDefinition(ptgs);
View Full Code Here
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
                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
740
741
742
743
744
745
746
747
748
749
750
            ptg = new UnionPtg();
                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
670
671
672
673
674
675
676
677
678
679
680
681
                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
586
587
588
589
590
591
592
593
594
595
596
            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
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
            this.setDefinitionTextLength((short)((Area3DPtg) ptg).getSize());

        } else {

            ptg = new Ref3DPtg();

            ((Ref3DPtg) ptg).setExternSheetIndex(externSheetIndex);

            ((Ref3DPtg) ptg).setArea(ref);
View Full Code Here
562
563
564
565
566
567
568
569
570
571
572
            ptg = new Area3DPtg();
            ((Area3DPtg) ptg).setExternSheetIndex(externSheetIndex);
            ((Area3DPtg) ptg).setArea(ref);
            this.setDefinitionTextLength((short)((Area3DPtg) ptg).getSize());
        } else {
            ptg = new Ref3DPtg();
            ((Ref3DPtg) ptg).setExternSheetIndex(externSheetIndex);
            ((Ref3DPtg) ptg).setArea(ref);
            this.setDefinitionTextLength((short)((Ref3DPtg) ptg).getSize());
        }
View Full Code Here
373
374
375
376
377
378
379
380
381
382
383
384
385
386
            RefPtg refA = (RefPtg) ptgA;
            return new AreaPtg(refA.getRow(), refB.getRow(), refA.getColumn(), refB.getColumn(),
                    refA.isRowRelative(), refB.isRowRelative(), refA.isColRelative(), refB.isColRelative());
        }
        if (ptgA instanceof Ref3DPtg) {
            Ref3DPtg refA = (Ref3DPtg) ptgA;
            return new Area3DPtg(refA.getRow(), refB.getRow(), refA.getColumn(), refB.getColumn(),
                    refA.isRowRelative(), refB.isRowRelative(), refA.isColRelative(), refB.isColRelative(),
                    refA.getExternSheetIndex());
        }
        // Note - other operand types (like AreaPtg) which probably can't evaluate
        // do not cause validation errors at parse time
        return null;
    }
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.