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

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


      int firstCol = 0;
      int lastCol = 0;
     
      for (Ptg ptg : linkedDataRecord.getFormulaOfLink()) {
        if (ptg instanceof AreaPtgBase) {
          AreaPtgBase areaPtg = (AreaPtgBase) ptg;
         
          firstRow = areaPtg.getFirstRow();
          lastRow = areaPtg.getLastRow();
         
          firstCol = areaPtg.getFirstColumn();
          lastCol = areaPtg.getLastColumn();
        }
      }
     
      return new CellRangeAddress(firstRow, lastRow, firstCol, lastCol);
    }
View Full Code Here


      int rowCount = (range.getLastRow() - range.getFirstRow()) + 1;
      int colCount = (range.getLastColumn() - range.getFirstColumn()) + 1;
     
      for (Ptg ptg : linkedDataRecord.getFormulaOfLink()) {
        if (ptg instanceof AreaPtgBase) {
          AreaPtgBase areaPtg = (AreaPtgBase) ptg;
         
          areaPtg.setFirstRow(range.getFirstRow());
          areaPtg.setLastRow(range.getLastRow());
         
          areaPtg.setFirstColumn(range.getFirstColumn());
          areaPtg.setLastColumn(range.getLastColumn());
          ptgList.add(areaPtg);
        }
      }
     
      linkedDataRecord.setFormulaOfLink(ptgList.toArray(new Ptg[ptgList.size()]));
View Full Code Here

TOP

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

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.