Examples with CTTwoCellAnchor org.openxmlformats.schemas.drawingml.x2006.spreadsheetDrawing.CTTwoCellAnchor used on opensource projects

Example 6 with CTTwoCellAnchor

use of org.openxmlformats.schemas.drawingml.x2006.spreadsheetDrawing.CTTwoCellAnchor in project poi by apache.

the class XSSFDrawing method createObjectData.

@Override
public XSSFObjectData createObjectData(ClientAnchor anchor, int storageId, int pictureIndex) {
    XSSFSheet sh = getSheet();
    PackagePart sheetPart = sh.getPackagePart();
    /*
         * The shape id of the ole object seems to be a legacy shape id.
         * 
         * see 5.3.2.1 legacyDrawing (Legacy Drawing Object):
         * Legacy Shape ID that is unique throughout the entire document.
         * Legacy shape IDs should be assigned based on which portion of the document the
         * drawing resides on. The assignment of these ids is broken down into clusters of
         * 1024 values. The first cluster is 1-1024, the second 1025-2048 and so on.
         *
         * Ole shapes seem to start with 1025 on the first sheet ...
         * and not sure, if the ids need to be reindexed when sheets are removed
         * or more than 1024 shapes are on a given sheet (see #51332 for a similar issue)
         */
    XSSFSheet sheet = getSheet();
    XSSFWorkbook wb = sheet.getWorkbook();
    int sheetIndex = wb.getSheetIndex(sheet);
    long shapeId = (sheetIndex + 1) * 1024 + newShapeId();
    // add reference to OLE part
    PackagePartName olePN;
    try {
        olePN = PackagingURIHelper.createPartName("/xl/embeddings/oleObject" + storageId + ".bin");
    } catch (InvalidFormatException e) {
        throw new POIXMLException(e);
    }
    PackageRelationship olePR = sheetPart.addRelationship(olePN, TargetMode.INTERNAL, POIXMLDocument.OLE_OBJECT_REL_TYPE);
    // add reference to image part
    XSSFPictureData imgPD = sh.getWorkbook().getAllPictures().get(pictureIndex);
    PackagePartName imgPN = imgPD.getPackagePart().getPartName();
    PackageRelationship imgSheetPR = sheetPart.addRelationship(imgPN, TargetMode.INTERNAL, PackageRelationshipTypes.IMAGE_PART);
    PackageRelationship imgDrawPR = getPackagePart().addRelationship(imgPN, TargetMode.INTERNAL, PackageRelationshipTypes.IMAGE_PART);
    // add OLE part metadata to sheet
    CTWorksheet cwb = sh.getCTWorksheet();
    CTOleObjects oo = cwb.isSetOleObjects() ? cwb.getOleObjects() : cwb.addNewOleObjects();
    CTOleObject ole1 = oo.addNewOleObject();
    ole1.setProgId("Package");
    ole1.setShapeId(shapeId);
    ole1.setId(olePR.getId());
    XmlCursor cur1 = ole1.newCursor();
    cur1.toEndToken();
    cur1.beginElement("objectPr", XSSFRelation.NS_SPREADSHEETML);
    cur1.insertAttributeWithValue("id", PackageRelationshipTypes.CORE_PROPERTIES_ECMA376_NS, imgSheetPR.getId());
    cur1.insertAttributeWithValue("defaultSize", "0");
    cur1.beginElement("anchor", XSSFRelation.NS_SPREADSHEETML);
    cur1.insertAttributeWithValue("moveWithCells", "1");
    CTTwoCellAnchor ctAnchor = createTwoCellAnchor((XSSFClientAnchor) anchor);
    XmlCursor cur2 = ctAnchor.newCursor();
    cur2.copyXmlContents(cur1);
    cur2.dispose();
    cur1.toParent();
    cur1.toFirstChild();
    cur1.setName(new QName(XSSFRelation.NS_SPREADSHEETML, "from"));
    cur1.toNextSibling();
    cur1.setName(new QName(XSSFRelation.NS_SPREADSHEETML, "to"));
    cur1.dispose();
    // add a new shape and link OLE & image part
    CTShape ctShape = ctAnchor.addNewSp();
    ctShape.set(XSSFObjectData.prototype());
    ctShape.getSpPr().setXfrm(createXfrm((XSSFClientAnchor) anchor));
    // workaround for not having the vmlDrawing filled
    CTBlipFillProperties blipFill = ctShape.getSpPr().addNewBlipFill();
    blipFill.addNewBlip().setEmbed(imgDrawPR.getId());
    blipFill.addNewStretch().addNewFillRect();
    CTNonVisualDrawingProps cNvPr = ctShape.getNvSpPr().getCNvPr();
    cNvPr.setId(shapeId);
    cNvPr.setName("Object " + shapeId);
    XmlCursor extCur = cNvPr.getExtLst().getExtArray(0).newCursor();
    extCur.toFirstChild();
    extCur.setAttributeText(new QName("spid"), "_x0000_s" + shapeId);
    extCur.dispose();
    XSSFObjectData shape = new XSSFObjectData(this, ctShape);
    shape.anchor = (XSSFClientAnchor) anchor;
    return shape;
}

Example 7 with CTTwoCellAnchor

use of org.openxmlformats.schemas.drawingml.x2006.spreadsheetDrawing.CTTwoCellAnchor in project poi by apache.

the class XSSFDrawing method createGroup.

/**
     * Creates a simple shape.  This includes such shapes as lines, rectangles,
     * and ovals.
     *
     * @param anchor    the client anchor describes how this group is attached
     *                  to the sheet.
     * @return  the newly created shape.
     */
public XSSFShapeGroup createGroup(XSSFClientAnchor anchor) {
    CTTwoCellAnchor ctAnchor = createTwoCellAnchor(anchor);
    CTGroupShape ctGroup = ctAnchor.addNewGrpSp();
    ctGroup.set(XSSFShapeGroup.prototype());
    CTTransform2D xfrm = createXfrm(anchor);
    CTGroupTransform2D grpXfrm = ctGroup.getGrpSpPr().getXfrm();
    grpXfrm.setOff(xfrm.getOff());
    grpXfrm.setExt(xfrm.getExt());
    grpXfrm.setChExt(xfrm.getExt());
    XSSFShapeGroup shape = new XSSFShapeGroup(this, ctGroup);
    shape.anchor = anchor;
    return shape;
}

Example 8 with CTTwoCellAnchor

use of org.openxmlformats.schemas.drawingml.x2006.spreadsheetDrawing.CTTwoCellAnchor in project poi by apache.

the class XSSFDrawing method createTwoCellAnchor.

/**
     * Create and initialize a CTTwoCellAnchor that anchors a shape against top-left and bottom-right cells.
     *
     * @return a new CTTwoCellAnchor
     */
private CTTwoCellAnchor createTwoCellAnchor(XSSFClientAnchor anchor) {
    CTTwoCellAnchor ctAnchor = drawing.addNewTwoCellAnchor();
    ctAnchor.setFrom(anchor.getFrom());
    ctAnchor.setTo(anchor.getTo());
    ctAnchor.addNewClientData();
    anchor.setTo(ctAnchor.getTo());
    anchor.setFrom(ctAnchor.getFrom());
    STEditAs.Enum aditAs;
    switch(anchor.getAnchorType()) {
        case DONT_MOVE_AND_RESIZE:
            aditAs = STEditAs.ABSOLUTE;
            break;
        case MOVE_AND_RESIZE:
            aditAs = STEditAs.TWO_CELL;
            break;
        case MOVE_DONT_RESIZE:
            aditAs = STEditAs.ONE_CELL;
            break;
        default:
            aditAs = STEditAs.ONE_CELL;
    }
    ctAnchor.setEditAs(aditAs);
    return ctAnchor;
}

Example 9 with CTTwoCellAnchor

use of org.openxmlformats.schemas.drawingml.x2006.spreadsheetDrawing.CTTwoCellAnchor in project poi by apache.

the class XSSFDrawing method createConnector.

/**
     * Creates a simple shape.  This includes such shapes as lines, rectangles,
     * and ovals.
     *
     * @param anchor    the client anchor describes how this group is attached
     *                  to the sheet.
     * @return  the newly created shape.
     */
public XSSFConnector createConnector(XSSFClientAnchor anchor) {
    CTTwoCellAnchor ctAnchor = createTwoCellAnchor(anchor);
    CTConnector ctShape = ctAnchor.addNewCxnSp();
    ctShape.set(XSSFConnector.prototype());
    XSSFConnector shape = new XSSFConnector(this, ctShape);
    shape.anchor = anchor;
    return shape;
}

Example 10 with CTTwoCellAnchor

use of org.openxmlformats.schemas.drawingml.x2006.spreadsheetDrawing.CTTwoCellAnchor in project poi by apache.

the class XSSFDrawing method createPicture.

/**
     * Creates a picture.
     *
     * @param anchor    the client anchor describes how this picture is attached to the sheet.
     * @param pictureIndex the index of the picture in the workbook collection of pictures,
     *   {@link org.apache.poi.xssf.usermodel.XSSFWorkbook#getAllPictures()} .
     *
     * @return  the newly created picture shape.
     */
public XSSFPicture createPicture(XSSFClientAnchor anchor, int pictureIndex) {
    PackageRelationship rel = addPictureReference(pictureIndex);
    long shapeId = newShapeId();
    CTTwoCellAnchor ctAnchor = createTwoCellAnchor(anchor);
    CTPicture ctShape = ctAnchor.addNewPic();
    ctShape.set(XSSFPicture.prototype());
    ctShape.getNvPicPr().getCNvPr().setId(shapeId);
    XSSFPicture shape = new XSSFPicture(this, ctShape);
    shape.anchor = anchor;
    shape.setPictureReference(rel);
    ctShape.getSpPr().setXfrm(createXfrm(anchor));
    return shape;
}