/** * Create an instance of {@link CTTwoCellAnchor } * */ public CTTwoCellAnchor createCTTwoCellAnchor() { return new CTTwoCellAnchor(); }
protected void shiftChart(Document.ChartWrapper chart, Range templateRange, Range firstResultRange) { Offset offset = calculateOffset(templateRange, firstResultRange); CTTwoCellAnchor anchor = chart.getAnchor(); anchor.getFrom().setRow(anchor.getFrom().getRow() + offset.downOffset); anchor.getFrom().setCol(anchor.getFrom().getCol() + offset.rightOffset); anchor.getTo().setRow(anchor.getTo().getRow() + offset.downOffset); anchor.getTo().setCol(anchor.getTo().getCol() + offset.rightOffset); }
protected void shiftChart(Document.ChartWrapper chart, Range templateRange, Range firstResultRange) { Offset offset = calculateOffset(templateRange, firstResultRange); CTTwoCellAnchor anchor = chart.getAnchor(); anchor.getFrom().setRow(anchor.getFrom().getRow() + offset.downOffset); anchor.getFrom().setCol(anchor.getFrom().getCol() + offset.rightOffset); anchor.getTo().setRow(anchor.getTo().getRow() + offset.downOffset); anchor.getTo().setCol(anchor.getTo().getCol() + offset.rightOffset); }
if (anchorObj instanceof CTTwoCellAnchor) { ctTwoCellAnchor = (CTTwoCellAnchor) anchorObj; CTMarker from = ctTwoCellAnchor.getFrom(); CTMarker to = ctTwoCellAnchor.getTo(); String sheetName = worksheets.get(worksheets.size() - 1).name; range = new Range(sheetName, from.getCol() + 1, from.getRow() + 1, to.getCol() + 1, to.getRow() + 1);
/** * Create an instance of {@link CTTwoCellAnchor } * */ public CTTwoCellAnchor createCTTwoCellAnchor() { return new CTTwoCellAnchor(); }
if (anchorObj instanceof CTTwoCellAnchor) { ctTwoCellAnchor = (CTTwoCellAnchor) anchorObj; CTMarker from = ctTwoCellAnchor.getFrom(); CTMarker to = ctTwoCellAnchor.getTo(); String sheetName = worksheets.get(worksheets.size() - 1).name; range = new Range(sheetName, from.getCol() + 1, from.getRow() + 1, to.getCol() + 1, to.getRow() + 1);