/**
* Creates a comment.
* @param anchor the client anchor describes how this comment is attached
* to the sheet.
* @return the newly Created comment.
*/
public IComment CreateCellComment(IClientAnchor anchor)
{
XSSFClientAnchor ca = (XSSFClientAnchor)anchor;
XSSFSheet sheet = (XSSFSheet)GetParent();
//create comments and vmlDrawing parts if they don't exist
CommentsTable comments = sheet.GetCommentsTable(true);
XSSFVMLDrawing vml = sheet.GetVMLDrawing(true);
Npoi.Core.OpenXmlFormats.Vml.CT_Shape vmlShape = vml.newCommentShape();
if (ca.IsSet())
{
// convert offsets from emus to pixels since we get a DrawingML-anchor
// but create a VML Drawing
int dx1Pixels = ca.Dx1 / Units.EMU_PER_PIXEL;
int dy1Pixels = ca.Dy1 / Units.EMU_PER_PIXEL;
int dx2Pixels = ca.Dx2 / Units.EMU_PER_PIXEL;
int dy2Pixels = ca.Dy2 / Units.EMU_PER_PIXEL;
String position =
ca.Col1 + ", " + dx1Pixels + ", " +
ca.Row1 + ", " + dy1Pixels + ", " +
ca.Col2 + ", " + dx2Pixels + ", " +
ca.Row2 + ", " + dy2Pixels;
vmlShape.GetClientDataArray(0).SetAnchorArray(0, position);
}
String ref1 = new CellReference(ca.Row1, ca.Col1).FormatAsString();
if (comments.FindCellComment(ref1) != null)
{
throw new ArgumentException("Multiple cell comments in one cell are not allowed, cell: " + ref1);
}
return(new XSSFComment(comments, comments.NewComment(ref1), vmlShape));
}
public void GetSetRow()
{
CommentsTable sheetComments = new CommentsTable();
XSSFVMLDrawing vml = new XSSFVMLDrawing();
CT_Comment ctComment = sheetComments.NewComment("A1");
CT_Shape vmlShape = vml.newCommentShape();
XSSFComment comment = new XSSFComment(sheetComments, ctComment, vmlShape);
comment.Row = (1);
Assert.AreEqual(1, comment.Row);
Assert.AreEqual(1, new CellReference(ctComment.@ref).Row);
Assert.AreEqual(1, vmlShape.GetClientDataArray(0).GetRowArray(0));
comment.Row = (5);
Assert.AreEqual(5, comment.Row);
Assert.AreEqual(5, new CellReference(ctComment.@ref).Row);
Assert.AreEqual(5, vmlShape.GetClientDataArray(0).GetRowArray(0));
}
public void TestFindCommentShape()
{
XSSFVMLDrawing vml = new XSSFVMLDrawing();
vml.Read(POIDataSamples.GetSpreadSheetInstance().OpenResourceAsStream("vmlDrawing1.vml"));
CT_Shape sh_a1 = vml.FindCommentShape(0, 0);
Assert.IsNotNull(sh_a1);
Assert.AreEqual("_x0000_s1025", sh_a1.id);
CT_Shape sh_b1 = vml.FindCommentShape(0, 1);
Assert.IsNotNull(sh_b1);
Assert.AreEqual("_x0000_s1026", sh_b1.id);
CT_Shape sh_c1 = vml.FindCommentShape(0, 2);
Assert.IsNull(sh_c1);
CT_Shape sh_d1 = vml.newCommentShape();
Assert.AreEqual("_x0000_s1027", sh_d1.id);
sh_d1.GetClientDataArray(0).SetRowArray(0, 0);
sh_d1.GetClientDataArray(0).SetColumnArray(0, 3);
Assert.AreSame(sh_d1, vml.FindCommentShape(0, 3));
//newly created drawing
XSSFVMLDrawing newVml = new XSSFVMLDrawing();
Assert.IsNull(newVml.FindCommentShape(0, 0));
sh_a1 = newVml.newCommentShape();
Assert.AreEqual("_x0000_s1025", sh_a1.id);
sh_a1.GetClientDataArray(0).SetRowArray(0, 0);
sh_a1.GetClientDataArray(0).SetColumnArray(0, 1);
Assert.AreSame(sh_a1, newVml.FindCommentShape(0, 1));
}
public void TestNew()
{
XSSFVMLDrawing vml = new XSSFVMLDrawing();
List <object> items = vml.GetItems();
Assert.AreEqual(2, items.Count);
Assert.IsTrue(items[0] is CT_ShapeLayout);
CT_ShapeLayout layout = (CT_ShapeLayout)items[0];
Assert.AreEqual(ST_Ext.edit, layout.ext);
Assert.AreEqual(ST_Ext.edit, layout.idmap.ext);
Assert.AreEqual("1", layout.idmap.data);
Assert.IsTrue(items[1] is CT_Shapetype);
CT_Shapetype type = (CT_Shapetype)items[1];
Assert.AreEqual("21600,21600", type.coordsize);
Assert.AreEqual(202.0f, type.spt);
Assert.AreEqual("m,l,21600r21600,l21600,xe", type.path2);
Assert.IsTrue(type.id.StartsWith("_x0000_"));
Assert.AreEqual(Npoi.Core.OpenXmlFormats.Vml.ST_TrueFalse.t, type.path.gradientshapeok);
Assert.AreEqual(ST_ConnectType.rect, type.path.connecttype);
CT_Shape shape = vml.newCommentShape();
Assert.AreEqual(3, items.Count);
Assert.AreSame(items[2], shape);
Assert.IsTrue(shape.type.StartsWith("#_x0000_"));
Assert.AreEqual("position:absolute; visibility:hidden", shape.style);
Assert.AreEqual("#ffffe1", shape.fillcolor);
Assert.AreEqual(ST_InsetMode.auto, shape.insetmode);
Assert.AreEqual("#ffffe1", shape.fill.color);
CT_Shadow shadow = shape.shadow;
Assert.AreEqual(Npoi.Core.OpenXmlFormats.Vml.ST_TrueFalse.t, shadow.on);
Assert.AreEqual("black", shadow.color);
Assert.AreEqual(Npoi.Core.OpenXmlFormats.Vml.ST_TrueFalse.t, shadow.obscured);
Assert.AreEqual(ST_ConnectType.none, shape.path.connecttype);
Assert.AreEqual("mso-direction-alt:auto", shape.textbox.style);
CT_ClientData cldata = shape.GetClientDataArray(0);
Assert.AreEqual(ST_ObjectType.Note, cldata.ObjectType);
Assert.AreEqual(1, cldata.SizeOfMoveWithCellsArray());
Assert.AreEqual(1, cldata.SizeOfSizeWithCellsArray());
Assert.AreEqual("1, 15, 0, 2, 3, 15, 3, 16", cldata.anchor);
Assert.AreEqual(ST_TrueFalseBlank.@false, cldata.autoFill);
Assert.AreEqual(0, cldata.GetRowArray(0));
Assert.AreEqual(0, cldata.GetColumnArray(0));
//serialize and read again
MemoryStream out1 = new MemoryStream();
vml.Write(out1);
XSSFVMLDrawing vml2 = new XSSFVMLDrawing();
vml2.Read(new MemoryStream(out1.ToArray()));
List <object> items2 = vml2.GetItems();
Assert.AreEqual(3, items2.Count);
Assert.IsTrue(items2[0] is CT_ShapeLayout);
Assert.IsTrue(items2[1] is CT_Shapetype);
Assert.IsTrue(items2[2] is CT_Shape);
}