/** * Initialize a new Speadsheet VML drawing */ private void newDrawing(){ CTShapeLayout layout = CTShapeLayout.Factory.newInstance(); layout.setExt(STExt.EDIT); CTIdMap idmap = layout.addNewIdmap(); idmap.setExt(STExt.EDIT); idmap.setData("1"); _items.add(layout); _qnames.add(QNAME_SHAPE_LAYOUT); CTShapetype shapetype = CTShapetype.Factory.newInstance(); _shapeTypeId = COMMENT_SHAPE_TYPE_ID; shapetype.setId(_shapeTypeId); shapetype.setCoordsize("21600,21600"); shapetype.setSpt(202); shapetype.setPath2("m,l,21600r21600,l21600,xe"); shapetype.addNewStroke().setJoinstyle(STStrokeJoinStyle.MITER); CTPath path = shapetype.addNewPath(); path.setGradientshapeok(STTrueFalse.T); path.setConnecttype(STConnectType.RECT); _items.add(shapetype); _qnames.add(QNAME_SHAPE_TYPE); }
formulas.addNewF().setEqn("sum @6 0 @5"); CTPath path = shapetype.addNewPath(); path.setTextpathok(STTrueFalse.T); path.setConnecttype(STConnectType.CUSTOM); path.setConnectlocs("@9,0;@10,10800;@11,21600;@12,10800"); path.setConnectangles("270,180,90,0"); CTTextPath shapeTypeTextPath = shapetype.addNewTextpath(); shapeTypeTextPath.setOn(STTrueFalse.T);
protected CTShape newCommentShape(){ CTShape shape = CTShape.Factory.newInstance(); shape.setId("_x0000_s" + (++_shapeId)); shape.setType("#" + _shapeTypeId); shape.setStyle("position:absolute; visibility:hidden"); shape.setFillcolor("#ffffe1"); shape.setInsetmode(STInsetMode.AUTO); shape.addNewFill().setColor("#ffffe1"); CTShadow shadow = shape.addNewShadow(); shadow.setOn(STTrueFalse.T); shadow.setColor("black"); shadow.setObscured(STTrueFalse.T); shape.addNewPath().setConnecttype(STConnectType.NONE); shape.addNewTextbox().setStyle("mso-direction-alt:auto"); CTClientData cldata = shape.addNewClientData(); cldata.setObjectType(STObjectType.NOTE); cldata.addNewMoveWithCells(); cldata.addNewSizeWithCells(); cldata.addNewAnchor().setStringValue("1, 15, 0, 2, 3, 15, 3, 16"); cldata.addNewAutoFill().setStringValue("False"); cldata.addNewRow().setBigIntegerValue(new BigInteger("0")); cldata.addNewColumn().setBigIntegerValue(new BigInteger("0")); _items.add(shape); _qnames.add(QNAME_SHAPE); return shape; }
formulas.addNewF().setEqn("sum @6 0 @5"); CTPath path = shapetype.addNewPath(); path.setTextpathok(STTrueFalse.T); path.setConnecttype(STConnectType.CUSTOM); path.setConnectlocs("@9,0;@10,10800;@11,21600;@12,10800"); path.setConnectangles("270,180,90,0"); CTTextPath shapeTypeTextPath = shapetype.addNewTextpath(); shapeTypeTextPath.setOn(STTrueFalse.T);
protected CTShape newCommentShape(){ CTShape shape = CTShape.Factory.newInstance(); shape.setId("_x0000_s" + (++_shapeId)); shape.setType("#" + _shapeTypeId); shape.setStyle("position:absolute; visibility:hidden"); shape.setFillcolor("#ffffe1"); shape.setInsetmode(STInsetMode.AUTO); shape.addNewFill().setColor("#ffffe1"); CTShadow shadow = shape.addNewShadow(); shadow.setOn(STTrueFalse.T); shadow.setColor("black"); shadow.setObscured(STTrueFalse.T); shape.addNewPath().setConnecttype(STConnectType.NONE); shape.addNewTextbox().setStyle("mso-direction-alt:auto"); CTClientData cldata = shape.addNewClientData(); cldata.setObjectType(STObjectType.NOTE); cldata.addNewMoveWithCells(); cldata.addNewSizeWithCells(); cldata.addNewAnchor().setStringValue("1, 15, 0, 2, 3, 15, 3, 16"); cldata.addNewAutoFill().setStringValue("False"); cldata.addNewRow().setBigIntegerValue(new BigInteger("0")); cldata.addNewColumn().setBigIntegerValue(new BigInteger("0")); _items.add(shape); _qnames.add(QNAME_SHAPE); return shape; }
/** * Initialize a new Speadsheet VML drawing */ private void newDrawing(){ CTShapeLayout layout = CTShapeLayout.Factory.newInstance(); layout.setExt(STExt.EDIT); CTIdMap idmap = layout.addNewIdmap(); idmap.setExt(STExt.EDIT); idmap.setData("1"); _items.add(layout); _qnames.add(QNAME_SHAPE_LAYOUT); CTShapetype shapetype = CTShapetype.Factory.newInstance(); _shapeTypeId = COMMENT_SHAPE_TYPE_ID; shapetype.setId(_shapeTypeId); shapetype.setCoordsize("21600,21600"); shapetype.setSpt(202); shapetype.setPath2("m,l,21600r21600,l21600,xe"); shapetype.addNewStroke().setJoinstyle(STStrokeJoinStyle.MITER); CTPath path = shapetype.addNewPath(); path.setGradientshapeok(STTrueFalse.T); path.setConnecttype(STConnectType.RECT); _items.add(shapetype); _qnames.add(QNAME_SHAPE_TYPE); }