private XmlNode AddImage(string id, Uri targeUri, string Name, double width, double height)
{
var node = VmlDrawingXml.CreateElement("v", "shape", ExcelPackage.schemaMicrosoftVml);
VmlDrawingXml.DocumentElement.AppendChild(node);
node.SetAttribute("id", id);
node.SetAttribute("o:type", "#_x0000_t75");
node.SetAttribute("style", string.Format("position:absolute;margin-left:0;margin-top:0;width:{0}pt;height:{1}pt;z-index:1", width.ToString(CultureInfo.InvariantCulture), height.ToString(CultureInfo.InvariantCulture)));
//node.SetAttribute("fillcolor", "#ffffe1");
//node.SetAttribute("insetmode", ExcelPackage.schemaMicrosoftOffice, "auto");
node.InnerXml = string.Format("<v:imagedata o:relid=\"\" o:title=\"{0}\"/><o:lock v:ext=\"edit\" rotation=\"t\"/>", Name);
return(node);
}
private XmlNode AddDrawing(ExcelRangeBase cell)
{
int row = cell.Start.Row, col = cell.Start.Column;
var node = VmlDrawingXml.CreateElement("v", "shape", ExcelPackage.schemaMicrosoftVml);
var id = ExcelCellBase.GetCellID(cell.Worksheet.SheetID, cell._fromRow, cell._fromCol);
var ix = _drawings.IndexOf(id);
if (ix < 0 && (~ix < _drawings.Count))
{
ix = ~ix;
var prevDraw = _drawings[ix] as ExcelVmlDrawingBase;
prevDraw.TopNode.ParentNode.InsertBefore(node, prevDraw.TopNode);
}
else
{
VmlDrawingXml.DocumentElement.AppendChild(node);
}
node.SetAttribute("id", GetNewId());
node.SetAttribute("type", "#_x0000_t202");
node.SetAttribute("style", "position:absolute;z-index:1; visibility:hidden");
//node.SetAttribute("style", "position:absolute; margin-left:59.25pt;margin-top:1.5pt;width:108pt;height:59.25pt;z-index:1; visibility:hidden");
node.SetAttribute("fillcolor", "#ffffe1");
node.SetAttribute("insetmode", ExcelPackage.schemaMicrosoftOffice, "auto");
string vml = "<v:fill color2=\"#ffffe1\" />";
vml += "<v:shadow on=\"t\" color=\"black\" obscured=\"t\" />";
vml += "<v:path o:connecttype=\"none\" />";
vml += "<v:textbox style=\"mso-direction-alt:auto\">";
vml += "<div style=\"text-align:left\" />";
vml += "</v:textbox>";
vml += "<x:ClientData ObjectType=\"Note\">";
vml += "<x:MoveWithCells />";
vml += "<x:SizeWithCells />";
vml += string.Format("<x:Anchor>{0}, 15, {1}, 2, {2}, 31, {3}, 1</x:Anchor>", col, row - 1, col + 2, row + 3);
vml += "<x:AutoFill>False</x:AutoFill>";
vml += string.Format("<x:Row>{0}</x:Row>", row - 1);;
vml += string.Format("<x:Column>{0}</x:Column>", col - 1);
vml += "</x:ClientData>";
node.InnerXml = vml;
return(node);
}
private XmlNode AddControlDrawing(ExcelControl ctrl, string name)
{
var shapeElement = VmlDrawingXml.CreateElement("v", "shape", ExcelPackage.schemaMicrosoftVml);
VmlDrawingXml.DocumentElement.AppendChild(shapeElement);
shapeElement.SetAttribute("spid", ExcelPackage.schemaMicrosoftOffice, "_x0000_s" + ctrl.Id);
shapeElement.SetAttribute("id", name);
//shapeElement.SetAttribute("id", $"{ctrl.ControlTypeString}_x{ctrl.Id}_1");
shapeElement.SetAttribute("type", "#_x0000_t201");
shapeElement.SetAttribute("style", "position:absolute;z-index:1;");
shapeElement.SetAttribute("insetmode", ExcelPackage.schemaMicrosoftOffice, "auto");
SetShapeAttributes(ctrl, shapeElement);
var vml = new StringBuilder();
vml.Append(GetVml(ctrl, shapeElement));
vml.Append("<o:lock v:ext=\"edit\" rotation=\"t\"/>");
vml.Append("<v:textbox style=\"mso-direction-alt:auto\" o:singleclick=\"f\">");
if (ctrl is ExcelControlWithText textControl)
{
vml.Append($"<div style=\"text-align:center\"><font color=\"#000000\" size=\"{GetFontSize(ctrl)}\" face=\"{GetFontName(ctrl)}\">{textControl.Text}</font></div>");
}
vml.Append("</v:textbox>");
vml.Append($"<x:ClientData ObjectType=\"{ctrl.ControlTypeString}\">");
vml.Append(string.Format("<x:Anchor>{0}</x:Anchor>", ctrl.GetVmlAnchorValue()));
vml.Append(GetVmlClientData(ctrl, shapeElement));
vml.Append("<x:PrintObject>False</x:PrintObject>");
vml.Append("<x:AutoFill>False</x:AutoFill>");
if (ctrl.ControlType != eControlType.GroupBox)
{
vml.Append("<x:TextVAlign>Center</x:TextVAlign>");
}
vml.Append("</x:ClientData>");
shapeElement.InnerXml = vml.ToString();
return(shapeElement);
}