/// <summary>
/// Adds OpenXml <see cref="CellFormat"/> to document stylesheet CellStyleFormats.
/// </summary>
/// <param name="documentContext">Source document.</param>
/// <param name="cellFormat">CellFormat to add.</param>
/// <param name="name">Name attached to cellFormat.</param>
/// <returns>The same document context.</returns>
public static DocumentContext AddCellStyleFormat(this DocumentContext documentContext, CellFormat cellFormat, string name)
{
Stylesheet stylesheet = documentContext.GetStylesheet();
if (stylesheet.CellStyleFormats == null)
{
stylesheet.CellStyleFormats = new CellStyleFormats();
}
stylesheet.CellStyleFormats.AppendChild(cellFormat.SetStyleSheetName(name));
stylesheet.CellStyleFormats.Count = (uint)stylesheet.CellStyleFormats.ChildElements.Count;
return(documentContext);
}
/// <summary>
/// Adds OpenXml <see cref="CellFormat"/> to document stylesheet CellFormats.
/// </summary>
/// <param name="documentContext">Source document.</param>
/// <param name="cellFormat">CellFormat to add.</param>
/// <param name="name">Name attached to cellFormat.</param>
/// <param name="replaceOldIfExists">Replace old if exists.</param>
/// <returns>The same document context.</returns>
public static DocumentContext AddCellFormat(this DocumentContext documentContext, CellFormat cellFormat, string name, bool replaceOldIfExists = true)
{
Stylesheet stylesheet = documentContext.GetStylesheet();
if (stylesheet.CellFormats == null)
{
stylesheet.CellFormats = new CellFormats();
}
if (replaceOldIfExists)
{
var existent = documentContext.TryGetCellFormat(name);
if (existent != null)
{
stylesheet.CellFormats.RemoveChild(existent);
}
}
stylesheet.CellFormats.AppendChild(cellFormat.SetStyleSheetName(name));
stylesheet.CellFormats.Count = (uint)stylesheet.CellFormats.ChildElements.Count;
return(documentContext);
}
