Examples of org.apache.poi.hssf.record.formula.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);
    }

      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()]));

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

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.