internal ExcelComment(XmlNamespaceManager ns, XmlNode commentTopNode, ExcelRangeBase cell)
: base(null, cell, cell.Worksheet.VmlDrawings.NameSpaceManager)
{
//_commentHelper = new XmlHelper(ns, commentTopNode);
_commentHelper = XmlHelperFactory.Create(ns, commentTopNode);
var textElem = commentTopNode.SelectSingleNode("d:text", ns);
if (textElem == null)
{
textElem = commentTopNode.OwnerDocument.CreateElement("text", ExcelPackage.schemaMain);
commentTopNode.AppendChild(textElem);
}
if (!cell.Worksheet._vmlDrawings.ContainsKey(cell.Start.Row, cell.Start.Column))
{
cell.Worksheet._vmlDrawings.AddComment(cell);
}
TopNode = cell.Worksheet.VmlDrawings[cell.Start.Row, cell.Start.Column].TopNode;
RichText = new ExcelRichTextCollection(ns, textElem);
var tNode = textElem.SelectSingleNode("d:t", ns);
if (tNode != null)
{
_text = tNode.InnerText;
}
}
/// <summary>
/// Provides access to all the office document properties.
/// </summary>
/// <param name="package"></param>
/// <param name="ns"></param>
internal OfficeProperties(ExcelPackage package, XmlNamespaceManager ns) :
base(ns)
{
_package = package;
_coreHelper = XmlHelperFactory.Create(ns, CorePropertiesXml.SelectSingleNode("cp:coreProperties", NameSpaceManager));
_extendedHelper = XmlHelperFactory.Create(ns, ExtendedPropertiesXml);
_customHelper = XmlHelperFactory.Create(ns, CustomPropertiesXml);
}
/// <summary>
/// Provides access to all the office document properties.
/// </summary>
/// <param name="package"></param>
/// <param name="ns"></param>
internal OfficeProperties(ExcelPackage package, XmlNamespaceManager ns) :
base(ns)
{
_package = package;
_coreHelper = XmlHelperFactory.Create(ns, CorePropertiesXml.SelectSingleNode("cp:coreProperties", NameSpaceManager));
_extendedHelper = XmlHelperFactory.Create(ns, ExtendedPropertiesXml);
_customHelper = XmlHelperFactory.Create(ns, CustomPropertiesXml);
_customProperties = new Dictionary <string, XmlElement>(StringComparer.CurrentCultureIgnoreCase);
LoadCustomProperties();
}
internal ExcelComment(XmlNamespaceManager ns, XmlNode commentTopNode, ExcelRangeBase cell)
{
this.CommentHelper = XmlHelperFactory.Create(ns, commentTopNode);
var textElem = commentTopNode.SelectSingleNode("d:text", ns);
if (textElem == null)
{
textElem = commentTopNode.OwnerDocument.CreateElement("text", ExcelPackage.schemaMain);
commentTopNode.AppendChild(textElem);
}
this.Range = cell;
this.RichText = new ExcelRichTextCollection(ns, textElem);
}
