Examples of org.apache.poi.ss.util.CellReference$NameType

org.apache.poi.ss.util.CellReference
Used to classify identifiers found in formulas as cell references or not.

        extIx = _book.getExternalSheetIndex(sheetIden.getBookName(), sName);
      }
    }
    Ptg ptg;
    if (part2 == null) {
      CellReference cr = part1.getCellReference();
      if (sheetIden == null) {
        ptg = new RefPtg(cr);
      } else {
        ptg = new Ref3DPtg(cr, extIx);
      }

View Full Code Here

        CTShape vmlShape = vml.newCommentShape();


        XSSFComment comment = new XSSFComment(sheetComments, ctComment, vmlShape);
        comment.setColumn(1);
        assertEquals(1, comment.getColumn());
        assertEquals(1, new CellReference(ctComment.getRef()).getCol());
        assertEquals(1, vmlShape.getClientDataArray(0).getColumnArray(0).intValue());


        comment.setColumn(5);
        assertEquals(5, comment.getColumn());
        assertEquals(5, new CellReference(ctComment.getRef()).getCol());
        assertEquals(5, vmlShape.getClientDataArray(0).getColumnArray(0).intValue());
    }

View Full Code Here

        CTShape vmlShape = vml.newCommentShape();


        XSSFComment comment = new XSSFComment(sheetComments, ctComment, vmlShape);
        comment.setRow(1);
        assertEquals(1, comment.getRow());
        assertEquals(1, new CellReference(ctComment.getRef()).getRow());
        assertEquals(1, vmlShape.getClientDataArray(0).getRowArray(0).intValue());


        comment.setRow(5);
        assertEquals(5, comment.getRow());
        assertEquals(5, new CellReference(ctComment.getRef()).getRow());
        assertEquals(5, vmlShape.getClientDataArray(0).getRowArray(0).intValue());
    }

View Full Code Here


            //remove the reference in the calculation chain
            if(calcChain != null) calcChain.removeItem(sheetId, cell.getReference());


            CTCell ctCell = cell.getCTCell();
            String r = new CellReference(rownum, cell.getColumnIndex()).formatAsString();
            ctCell.setR(r);
        }
        setRowNum(rownum);
    }

View Full Code Here


    /**
     * @return the 0-based column of the cell that the comment is associated with.
     */
  public int getColumn() {
    return new CellReference(_comment.getRef()).getCol();
  }

View Full Code Here


    /**
     * @return the 0-based row index of the cell that the comment is associated with.
     */
  public int getRow() {
    return new CellReference(_comment.getRef()).getRow();
  }

View Full Code Here

     * Set the column of the cell that contains the comment
     *
     * @param col the 0-based column of the cell that contains the comment
     */
    public void setColumn(int col) {
        CellReference ref = new CellReference(getRow(), col);
    _comment.setRef(ref.formatAsString());
        if(_vmlShape != null) _vmlShape.getClientDataArray(0).setColumnArray(0, new BigInteger(String.valueOf(col)));
  }

View Full Code Here

     *
     * @param row the 0-based row of the cell that contains the comment
     */
  public void setRow(int row) {
    String newRef =
      (new CellReference(row, getColumn())).formatAsString();
    _comment.setRef(newRef);
        if(_vmlShape != null) _vmlShape.getClientDataArray(0).setRowArray(0, new BigInteger(String.valueOf(row)));
    }

View Full Code Here

        printSetup.setValidSettings(false);
    }


    private static String getReferenceBuiltInRecord(String sheetName, int startC, int endC, int startR, int endR) {
        //windows excel example for built-in title: 'second sheet'!$E:$F,'second sheet'!$2:$3
        CellReference colRef = new CellReference(sheetName, 0, startC, true, true);
        CellReference colRef2 = new CellReference(sheetName, 0, endC, true, true);


        String escapedName = SheetNameFormatter.format(sheetName);


        String c;
        if(startC == -1 && endC == -1) c= "";
        else c = escapedName + "!$" + colRef.getCellRefParts()[2] + ":$" + colRef2.getCellRefParts()[2];


        CellReference rowRef = new CellReference(sheetName, startR, 0, true, true);
        CellReference rowRef2 = new CellReference(sheetName, endR, 0, true, true);


        String r = "";
        if(startR == -1 && endR == -1) r = "";
        else {
            if (!rowRef.getCellRefParts()[1].equals("0") && !rowRef2.getCellRefParts()[1].equals("0")) {
                r = escapedName + "!$" + rowRef.getCellRefParts()[1] + ":$" + rowRef2.getCellRefParts()[1];
            }
        }


        StringBuffer rng = new StringBuffer();
        rng.append(c);

View Full Code Here

        return rng.toString();
    }


    private static String getReferencePrintArea(String sheetName, int startC, int endC, int startR, int endR) {
        //windows excel example: Sheet1!$C$3:$E$4
        CellReference colRef = new CellReference(sheetName, startR, startC, true, true);
        CellReference colRef2 = new CellReference(sheetName, endR, endC, true, true);


        return "$" + colRef.getCellRefParts()[2] + "$" + colRef.getCellRefParts()[1] + ":$" + colRef2.getCellRefParts()[2] + "$" + colRef2.getCellRefParts()[1];
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.poi.ss.util.CellReference$NameType

com.haulmont.yarg.formatters.impl.xls.Cell

com.haulmont.yarg.formatters.impl.XLSFormatter

core.Evaluation

loxia.support.excel.ExcelUtil

net.sf.jasperreports.engine.export.JRXlsExporter

org.apache.poi.hssf.model.RowBlocksReader

org.apache.poi.hssf.record.aggregates.FormulaRecordAggregate

org.apache.poi.hssf.record.aggregates.SharedValueManager

org.apache.poi.hssf.record.formula.Area3DPtg

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.