Examples of CellReference

com.haulmont.yarg.formatters.impl.xlsx.CellReference
org.apache.poi.hssf.util.CellReference
@author Avik Sengupta @author Dennis Doubleday (patch to seperateRowColumns())
org.apache.poi.ss.util.CellReference
@author Avik Sengupta @author Dennis Doubleday (patch to seperateRowColumns())
org.zkoss.poi.ss.util.CellReference

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


            //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

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

     * @param num column index of this cell
     */
    protected void setCellNum(int num) {
        checkBounds(num);
        cellNum = num;
        String ref = new CellReference(getRowIndex(), getColumnIndex()).formatAsString();
        cell.setR(ref);
    }

View Full Code Here

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

     * the comment for this cell will be removed.
     *
     * @param comment comment associated with this cell
     */
    public void setCellComment(Comment comment) {
        String cellRef = new CellReference(row.getRowNum(), getColumnIndex()).formatAsString();
        getSheet().setCellComment(cellRef, (XSSFComment)comment);
    }

View Full Code Here

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

     */
    public void setHyperlink(Hyperlink hyperlink) {
        XSSFHyperlink link = (XSSFHyperlink)hyperlink;


        // Assign to us
        link.setCellReference( new CellReference(row.getRowNum(), cellNum).formatAsString() );


        // Add to the lists
        getSheet().setCellHyperlink(link);
    }

View Full Code Here

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

        CTPane pane = getPane();
        if (colSplit > 0) pane.setXSplit(colSplit);
        if (rowSplit > 0) pane.setYSplit(rowSplit);
        pane.setState(STPaneState.FROZEN);
        if (rowSplit == 0) {
            pane.setTopLeftCell(new CellReference(0, topRow).formatAsString());
            pane.setActivePane(STPane.TOP_RIGHT);
        } else if (colSplit == 0) {
            pane.setTopLeftCell(new CellReference(rowSplit, 0).formatAsString());
            pane.setActivePane(STPane.BOTTOM_LEFT);
        } else {
            pane.setTopLeftCell(new CellReference(leftmostColumn, topRow).formatAsString());
            pane.setActivePane(STPane.BOTTOM_RIGHT);
        }


        CTSheetView ctView = getDefaultSheetView();
        ctView.setSelectionArray(null);

View Full Code Here

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

        if (sheetComments == null) return null;
        else return sheetComments.findCellComment(row, column);
    }


    public XSSFHyperlink getHyperlink(int row, int column) {
        String ref = new CellReference(row, column).formatAsString();
        for(XSSFHyperlink hyperlink : hyperlinks) {
            if(hyperlink.getCellRef().equals(ref)) {
                return hyperlink;
            }
        }

View Full Code Here

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

        return rows.size() == 0 ? 0 : rows.lastKey();
    }


    public short getLeftCol() {
        String cellRef = worksheet.getSheetViews().getSheetViewArray(0).getTopLeftCell();
        CellReference cellReference = new CellReference(cellRef);
        return cellReference.getCol();
    }

View Full Code Here

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

     *
     * @return null if no pane configured, or the pane information.
     */
    public PaneInformation getPaneInformation() {
        CTPane pane = getPane();
        CellReference cellRef = pane.isSetTopLeftCell() ? new CellReference(pane.getTopLeftCell()) : null;
        return new PaneInformation((short)pane.getXSplit(), (short)pane.getYSplit(),
                (short)(cellRef == null ? 0 : cellRef.getRow()),(cellRef == null ? 0 : cellRef.getCol()),
                (byte)pane.getActivePane().intValue(), pane.getState() == STPaneState.FROZEN);
    }

View Full Code Here

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

     *
     * @return integer indicating the rownum (0 based) of the top row
     */
    public short getTopRow() {
        String cellRef = getSheetTypeSheetView().getTopLeftCell();
        CellReference cellReference = new CellReference(cellRef);
        return (short) cellReference.getRow();
    }

View Full Code Here

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


            if(sheetComments != null){
                //TODO shift Note's anchor in the associated /xl/drawing/vmlDrawings#.vml
                CTCommentList lst = sheetComments.getCTComments().getCommentList();
                for (CTComment comment : lst.getCommentArray()) {
                    CellReference ref = new CellReference(comment.getRef());
                    if(ref.getRow() == rownum){
                        ref = new CellReference(rownum + n, ref.getCol());
                        comment.setRef(ref.formatAsString());
                    }
                }
            }
        }
        XSSFRowShifter rowShifter = new XSSFRowShifter(this);

View Full Code Here

0 1 2 3 4 5

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.