private void checkWorkbookBack(HSSFWorkbook wb) { HSSFWorkbook wbBack = HSSFTestDataSamples.writeOutAndReadBack(wb); assertNotNull(wbBack); HSSFSheet sheetBack = wbBack.getSheetAt(0); assertNotNull(sheetBack); HSSFPatriarch patriarchBack = sheetBack.getDrawingPatriarch(); assertNotNull(patriarchBack); List<HSSFShape> children = patriarchBack.getChildren(); assertEquals(4, children.size()); HSSFShape hssfShape = children.get(0); assertTrue(hssfShape instanceof HSSFSimpleShape); HSSFAnchor anchor = hssfShape.getAnchor(); assertTrue(anchor instanceof HSSFClientAnchor); assertEquals(0, anchor.getDx1()); assertEquals(512, anchor.getDx2()); assertEquals(0, anchor.getDy1()); assertEquals(100, anchor.getDy2()); HSSFClientAnchor cAnchor = (HSSFClientAnchor) anchor; assertEquals(1, cAnchor.getCol1()); assertEquals(1, cAnchor.getCol2()); assertEquals(1, cAnchor.getRow1()); assertEquals(1, cAnchor.getRow2()); hssfShape = children.get(1); assertTrue(hssfShape instanceof HSSFSimpleShape); anchor = hssfShape.getAnchor(); assertTrue(anchor instanceof HSSFClientAnchor); assertEquals(512, anchor.getDx1()); assertEquals(1024, anchor.getDx2()); assertEquals(0, anchor.getDy1()); assertEquals(100, anchor.getDy2()); cAnchor = (HSSFClientAnchor) anchor; assertEquals(1, cAnchor.getCol1()); assertEquals(1, cAnchor.getCol2()); assertEquals(1, cAnchor.getRow1()); assertEquals(1, cAnchor.getRow2()); hssfShape = children.get(2); assertTrue(hssfShape instanceof HSSFSimpleShape); anchor = hssfShape.getAnchor(); assertTrue(anchor instanceof HSSFClientAnchor); assertEquals(0, anchor.getDx1()); assertEquals(512, anchor.getDx2()); assertEquals(0, anchor.getDy1()); assertEquals(100, anchor.getDy2()); cAnchor = (HSSFClientAnchor) anchor; assertEquals(2, cAnchor.getCol1()); assertEquals(2, cAnchor.getCol2()); assertEquals(2, cAnchor.getRow1()); assertEquals(2, cAnchor.getRow2()); hssfShape = children.get(3); assertTrue(hssfShape instanceof HSSFSimpleShape); anchor = hssfShape.getAnchor(); assertTrue(anchor instanceof HSSFClientAnchor); assertEquals(0, anchor.getDx1()); assertEquals(512, anchor.getDx2()); assertEquals(100, anchor.getDy1()); assertEquals(200, anchor.getDy2()); cAnchor = (HSSFClientAnchor) anchor; assertEquals(2, cAnchor.getCol1()); assertEquals(2, cAnchor.getCol2()); assertEquals(2, cAnchor.getRow1()); assertEquals(2, cAnchor.getRow2()); }