public void testNew() throws Exception { XSSFWorkbook wb = new XSSFWorkbook(); XSSFSheet sheet = wb.createSheet(); // multiple calls of createDrawingPatriarch should return the same instance of XSSFDrawing XSSFDrawing dr1 = sheet.createDrawingPatriarch(); XSSFDrawing dr2 = sheet.createDrawingPatriarch(); assertSame(dr1, dr2); List<POIXMLDocumentPart> rels = sheet.getRelations(); assertEquals(1, rels.size()); assertTrue(rels.get(0) instanceof XSSFDrawing); XSSFDrawing drawing = (XSSFDrawing) rels.get(0); String drawingId = drawing.getPackageRelationship().getId(); // there should be a relation to this drawing in the worksheet assertTrue(sheet.getCTWorksheet().isSetDrawing()); assertEquals(drawingId, sheet.getCTWorksheet().getDrawing().getId()); XSSFConnector c1 = drawing.createConnector(new XSSFClientAnchor(0, 0, 0, 0, 0, 0, 2, 2)); c1.setLineWidth(2.5); c1.setLineStyle(1); XSSFShapeGroup c2 = drawing.createGroup(new XSSFClientAnchor(0, 0, 0, 0, 0, 0, 5, 5)); assertNotNull(c2); XSSFSimpleShape c3 = drawing.createSimpleShape(new XSSFClientAnchor(0, 0, 0, 0, 2, 2, 3, 4)); c3.setText(new XSSFRichTextString("Test String")); c3.setFillColor(128, 128, 128); XSSFTextBox c4 = drawing.createTextbox(new XSSFClientAnchor(0, 0, 0, 0, 4, 4, 5, 6)); XSSFRichTextString rt = new XSSFRichTextString("Test String"); rt.applyFont(0, 5, wb.createFont()); rt.applyFont(5, 6, wb.createFont()); c4.setText(rt); c4.setNoFill(true); assertEquals(4, drawing.getCTDrawing().sizeOfTwoCellAnchorArray()); List<XSSFShape> shapes = drawing.getShapes(); assertEquals(4, shapes.size()); assertTrue(shapes.get(0) instanceof XSSFConnector); assertTrue(shapes.get(1) instanceof XSSFShapeGroup); assertTrue(shapes.get(2) instanceof XSSFSimpleShape); assertTrue(shapes.get(3) instanceof XSSFSimpleShape); // // Save and re-load it wb = XSSFTestDataSamples.writeOutAndReadBack(wb); sheet = wb.getSheetAt(0); // Check dr1 = sheet.createDrawingPatriarch(); CTDrawing ctDrawing = dr1.getCTDrawing(); // Connector, shapes and text boxes are all two cell anchors assertEquals(0, ctDrawing.sizeOfAbsoluteAnchorArray()); assertEquals(0, ctDrawing.sizeOfOneCellAnchorArray()); assertEquals(4, ctDrawing.sizeOfTwoCellAnchorArray()); shapes = dr1.getShapes(); assertEquals(4, shapes.size()); assertTrue(shapes.get(0) instanceof XSSFConnector); assertTrue(shapes.get(1) instanceof XSSFShapeGroup); assertTrue(shapes.get(2) instanceof XSSFSimpleShape); assertTrue(shapes.get(3) instanceof XSSFSimpleShape); // // Ensure it got the right namespaces String xml = ctDrawing.toString(); assertTrue( xml.contains( "xmlns:xdr=\"http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing\"")); assertTrue(xml.contains("xmlns:a=\"http://schemas.openxmlformats.org/drawingml/2006/main\"")); assertNotNull(XSSFTestDataSamples.writeOutAndReadBack(wb)); }