Package org.apache.poi.ss.formula.ptg

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

574
575
576
577
578
579
580
581
582
583
584
585
    if (ptg instanceof Area3DPtg) {
      Area3DPtg aptg = (Area3DPtg) ptg;
      return ec.getArea3DEval(aptg.getFirstRow(), aptg.getFirstColumn(), aptg.getLastRow(), aptg.getLastColumn(), aptg.getExternSheetIndex());
    }
    if (ptg instanceof RefPtg) {
      RefPtg rptg = (RefPtg) ptg;
      return ec.getRefEval(rptg.getRow(), rptg.getColumn());
    }
    if (ptg instanceof AreaPtg) {
      AreaPtg aptg = (AreaPtg) ptg;
      return ec.getAreaEval(aptg.getFirstRow(), aptg.getFirstColumn(), aptg.getLastRow(), aptg.getLastColumn());
    }
View Full Code Here
599
600
601
602
603
604
605
606
607
608
609
      SimpleRangePart part2) throws FormulaParseException {
    Ptg ptg;
    if (part2 == null) {
      CellReference cr = part1.getCellReference();
      if (sheetIden == null) {
        ptg = new RefPtg(cr);
      } else {
        ptg = _book.get3DReferencePtg(cr, sheetIden);
      }
    } else {
      AreaReference areaRef = createAreaRef(part1, part2);
View Full Code Here
73
74
75
76
77
78
79
   */
  public static RefEval createRefEval(String refStr) {
    return createRefEval(refStr, NumberEval.ZERO);
  }
  public static RefEval createRefEval(String refStr, ValueEval value) {
    return new MockRefEval(new RefPtg(refStr), value);
  }
View Full Code Here
183
184
185
186
187
188
189
190
191
192
193
194
        TextObjectRecord rec = new TextObjectRecord(is);

        Ptg ptg = rec.getLinkRefPtg();
        assertNotNull(ptg);
        assertEquals(RefPtg.class, ptg.getClass());
        RefPtg rptg = (RefPtg) ptg;
        assertEquals("T2", rptg.toFormulaString());

        byte [] data2 = rec.serialize();
        assertEquals(linkData.length, data2.length);
        assertArrayEquals(linkData, data2);
    }
View Full Code Here
578
579
580
581
582
583
584
585
586
587
588
589
    if (ptg instanceof Area3DPtg) {
      Area3DPtg aptg = (Area3DPtg) ptg;
      return ec.getArea3DEval(aptg.getFirstRow(), aptg.getFirstColumn(), aptg.getLastRow(), aptg.getLastColumn(), aptg.getExternSheetIndex());
    }
    if (ptg instanceof RefPtg) {
      RefPtg rptg = (RefPtg) ptg;
      return ec.getRefEval(rptg.getRow(), rptg.getColumn());
    }
    if (ptg instanceof AreaPtg) {
      AreaPtg aptg = (AreaPtg) ptg;
      return ec.getAreaEval(aptg.getFirstRow(), aptg.getFirstColumn(), aptg.getLastRow(), aptg.getLastColumn());
    }
View Full Code Here
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
    if(ptg instanceof RefPtg) {
      if (currentExternSheetIx != _externSheetIndex) {
        // local refs on other sheets are unaffected
        return null;
      }
      RefPtg rptg = (RefPtg)ptg;
      return rowMoveRefPtg(rptg);
    }
    if(ptg instanceof Ref3DPtg) {
      Ref3DPtg rptg = (Ref3DPtg)ptg;
      if (_externSheetIndex != rptg.getExternSheetIndex()) {
        // only move 3D refs that refer to the sheet with cells being moved
        // (currentExternSheetIx is irrelevant)
        return null;
      }
      return rowMoveRefPtg(rptg);
View Full Code Here
159
160
161
162
163
164
165
166
167
168
    LittleEndianInput in = new LittleEndianInputStream(new ByteArrayInputStream(formulaRawBytes));
    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
675
676
677
678
679
680
681
682
683
684
685
686
       }
       if (ptg instanceof Area3DPxg) {
           return ec.getArea3DEval((Area3DPxg)ptg);
       }
       if (ptg instanceof RefPtg) {
           RefPtg rptg = (RefPtg) ptg;
           return ec.getRefEval(rptg.getRow(), rptg.getColumn());
       }
       if (ptg instanceof AreaPtg) {
           AreaPtg aptg = (AreaPtg) ptg;
           return ec.getAreaEval(aptg.getFirstRow(), aptg.getFirstColumn(), aptg.getLastRow(), aptg.getLastColumn());
       }
View Full Code Here
609
610
611
612
613
614
615
616
617
618
619
620
    if (ptg instanceof Area3DPtg) {
      Area3DPtg aptg = (Area3DPtg) ptg;
      return ec.getArea3DEval(aptg.getFirstRow(), aptg.getFirstColumn(), aptg.getLastRow(), aptg.getLastColumn(), aptg.getExternSheetIndex());
    }
    if (ptg instanceof RefPtg) {
      RefPtg rptg = (RefPtg) ptg;
      return ec.getRefEval(rptg.getRow(), rptg.getColumn());
    }
    if (ptg instanceof AreaPtg) {
      AreaPtg aptg = (AreaPtg) ptg;
      return ec.getAreaEval(aptg.getFirstRow(), aptg.getFirstColumn(), aptg.getLastRow(), aptg.getLastColumn());
    }
View Full Code Here
658
659
660
661
662
663
664
665
666
667
668
669
    if (ptg instanceof Area3DPtg) {
      Area3DPtg aptg = (Area3DPtg) ptg;
      return ec.getArea3DEval(aptg.getFirstRow(), aptg.getFirstColumn(), aptg.getLastRow(), aptg.getLastColumn(), aptg.getExternSheetIndex());
    }
    if (ptg instanceof RefPtg) {
      RefPtg rptg = (RefPtg) ptg;
      return ec.getRefEval(rptg.getRow(), rptg.getColumn());
    }
    if (ptg instanceof AreaPtg) {
      AreaPtg aptg = (AreaPtg) ptg;
      return ec.getAreaEval(aptg.getFirstRow(), aptg.getFirstColumn(), aptg.getLastRow(), aptg.getLastColumn());
    }
View Full Code Here
TOP

Related Classes of org.apache.poi.ss.formula.ptg.RefPtg

  • org.apache.poi.hssf.record.EmbeddedObjectRefSubRecord
  • org.apache.poi.hssf.record.TestFormulaRecord
  • org.apache.poi.hssf.record.TestSharedFormulaRecord
  • org.apache.poi.hssf.record.TestTextObjectRecord
  • org.apache.poi.ss.formula.FormulaParser
  • org.apache.poi.ss.formula.FormulaShifter
  • org.apache.poi.ss.formula.functions.EvalFactory
  • org.apache.poi.ss.formula.WorkbookEvaluator
  • org.apache.poi.ss.util.CellReference
    • 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.