Examples of AreaPtgBase

org.apache.poi.hssf.record.formula.AreaPtgBase
Specifies a rectangular area of cells A1:A4 for instance. @author andy @author Jason Height (jheight at chariot dot net dot au)
org.apache.poi.ss.formula.ptg.AreaPtgBase
Specifies a rectangular area of cells A1:A4 for instance. @author andy @author Jason Height (jheight at chariot dot net dot au)
org.zkoss.poi.ss.formula.ptg.AreaPtgBase

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);
    }

View Full Code Here

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

      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

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

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

      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

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

    if(ptg instanceof RefPtgBase) {
      final RefPtgBase rptg = (RefPtgBase)ptg;
      return rptgSetRowCol(rptg, dstCell, offRow, offCol, ver);
    }
    if(ptg instanceof AreaPtgBase) {
      final AreaPtgBase aptg = (AreaPtgBase) ptg;
      return aptgSetRowCol(aptg, dstCell, offRow, offCol, ver);
    }
    return ptg;
  }

View Full Code Here

TOP

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.