/** * Create an instance of {@link CTMarker } * */ public CTMarker createCTMarker() { return new CTMarker(); }
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); }
@Override public void inlineToXlsx(SpreadsheetMLPackage pkg, WorksheetPart worksheetPart, Cell newCell, Object paramValue, Matcher matcher) { try { Image image = new Image(paramValue, matcher); if (image.isValid()) { BinaryPartAbstractImage imagePart = BinaryPartAbstractImage.createImagePart(pkg, worksheetPart, image.imageContent); CTOneCellAnchor anchor = new CTOneCellAnchor(); anchor.setFrom(new CTMarker()); CellReference cellReference = new CellReference("", newCell.getR()); anchor.getFrom().setCol(cellReference.getColumn() - 1); anchor.getFrom().setRow(cellReference.getRow() - 1); anchor.setExt(new CTPositiveSize2D()); anchor.getExt().setCx(XlsxUtils.convertPxToEmu(image.width)); anchor.getExt().setCy(XlsxUtils.convertPxToEmu(image.height)); newCell.setV(null); putImage(worksheetPart, pkg, imagePart, anchor); } } catch (Exception e) { throw new ReportFormattingException("An error occurred while inserting bitmap to xlsx file", e); } }
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); }
@Override public void inlineToXlsx(SpreadsheetMLPackage pkg, WorksheetPart worksheetPart, Cell newCell, Object paramValue, Matcher matcher) { try { Image image = new Image(paramValue, matcher); if (image.isValid()) { BinaryPartAbstractImage imagePart = BinaryPartAbstractImage.createImagePart(pkg, worksheetPart, image.imageContent); CTOneCellAnchor anchor = new CTOneCellAnchor(); anchor.setFrom(new CTMarker()); CellReference cellReference = new CellReference("", newCell.getR()); anchor.getFrom().setCol(cellReference.getColumn() - 1); anchor.getFrom().setRow(cellReference.getRow() - 1); anchor.setExt(new CTPositiveSize2D()); anchor.getExt().setCx(XlsxUtils.convertPxToEmu(image.width)); anchor.getExt().setCy(XlsxUtils.convertPxToEmu(image.height)); newCell.setV(null); putImage(worksheetPart, pkg, imagePart, anchor); } } catch (Exception e) { throw new ReportFormattingException("An error occurred while inserting bitmap to xlsx file", e); } }
/** * Create an instance of {@link CTMarker } * */ public CTMarker createCTMarker() { return new CTMarker(); }