internal SLBorderProperties Clone()
{
SLBorderProperties bp = new SLBorderProperties(this.listThemeColors, this.listIndexedColors);
bp.HasColor = this.HasColor;
bp.clrReal = this.clrReal.Clone();
bp.HasBorderStyle = this.HasBorderStyle;
bp.vBorderStyle = this.vBorderStyle;
return(bp);
}
internal static string WriteToXmlTag(string BorderTag, SLBorderProperties bp)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("<x:{0}", BorderTag);
if (bp.HasBorderStyle)
{
sb.AppendFormat(" style=\"{0}\"", bp.GetBorderStyleAttribute(bp.BorderStyle));
}
if (bp.HasColor)
{
sb.Append("><x:color");
if (bp.clrReal.Auto != null)
{
sb.AppendFormat(" auto=\"{0}\"", bp.clrReal.Auto.Value ? "1" : "0");
}
if (bp.clrReal.Indexed != null)
{
sb.AppendFormat(" indexed=\"{0}\"", bp.clrReal.Indexed.Value);
}
if (bp.clrReal.Rgb != null)
{
sb.AppendFormat(" rgb=\"{0}\"", bp.clrReal.Rgb);
}
if (bp.clrReal.Theme != null)
{
sb.AppendFormat(" theme=\"{0}\"", bp.clrReal.Theme.Value);
}
if (bp.clrReal.Tint != null)
{
sb.AppendFormat(" tint=\"{0}\"", bp.clrReal.Tint.Value);
}
sb.AppendFormat(" /></x:{0}>", BorderTag);
}
else
{
sb.Append(" />");
}
return(sb.ToString());
}
/// <summary>
/// Form SLBorder from DocumentFormat.OpenXml.Spreadsheet.Border class.
/// </summary>
/// <param name="border">The source DocumentFormat.OpenXml.Spreadsheet.Border class.</param>
public void FromBorder(Border border)
{
this.SetAllNull();
if (border.LeftBorder != null)
{
HasLeftBorder = true;
this.bpLeftBorder = new SLBorderProperties(this.listThemeColors, this.listIndexedColors);
this.bpLeftBorder.FromBorderPropertiesType(border.LeftBorder);
}
if (border.RightBorder != null)
{
HasRightBorder = true;
this.bpRightBorder = new SLBorderProperties(this.listThemeColors, this.listIndexedColors);
this.bpRightBorder.FromBorderPropertiesType(border.RightBorder);
}
if (border.TopBorder != null)
{
HasTopBorder = true;
this.bpTopBorder = new SLBorderProperties(this.listThemeColors, this.listIndexedColors);
this.bpTopBorder.FromBorderPropertiesType(border.TopBorder);
}
if (border.BottomBorder != null)
{
HasBottomBorder = true;
this.bpBottomBorder = new SLBorderProperties(this.listThemeColors, this.listIndexedColors);
this.bpBottomBorder.FromBorderPropertiesType(border.BottomBorder);
}
if (border.DiagonalBorder != null)
{
HasDiagonalBorder = true;
this.bpDiagonalBorder = new SLBorderProperties(this.listThemeColors, this.listIndexedColors);
this.bpDiagonalBorder.FromBorderPropertiesType(border.DiagonalBorder);
}
if (border.VerticalBorder != null)
{
HasVerticalBorder = true;
this.bpVerticalBorder = new SLBorderProperties(this.listThemeColors, this.listIndexedColors);
this.bpVerticalBorder.FromBorderPropertiesType(border.VerticalBorder);
}
if (border.HorizontalBorder != null)
{
HasHorizontalBorder = true;
this.bpHorizontalBorder = new SLBorderProperties(this.listThemeColors, this.listIndexedColors);
this.bpHorizontalBorder.FromBorderPropertiesType(border.HorizontalBorder);
}
if (border.DiagonalUp != null)
{
this.DiagonalUp = border.DiagonalUp.Value;
}
else
{
this.DiagonalUp = null;
}
if (border.DiagonalDown != null)
{
this.DiagonalDown = border.DiagonalDown.Value;
}
else
{
this.DiagonalDown = null;
}
if (border.Outline != null)
{
this.Outline = border.Outline.Value;
}
else
{
this.Outline = null;
}
Sync();
}
/// <summary>
/// Remove any existing horizontal border.
/// </summary>
public void RemoveHorizontalBorder()
{
this.bpHorizontalBorder = new SLBorderProperties(this.listThemeColors, this.listIndexedColors);
HasHorizontalBorder = false;
}
/// <summary>
/// Remove any existing vertical border.
/// </summary>
public void RemoveVerticalBorder()
{
this.bpVerticalBorder = new SLBorderProperties(this.listThemeColors, this.listIndexedColors);
HasVerticalBorder = false;
}
/// <summary>
/// Remove any existing bottom border.
/// </summary>
public void RemoveBottomBorder()
{
this.bpBottomBorder = new SLBorderProperties(this.listThemeColors, this.listIndexedColors);
HasBottomBorder = false;
}
/// <summary>
/// Remove any existing right border.
/// </summary>
public void RemoveRightBorder()
{
this.bpRightBorder = new SLBorderProperties(this.listThemeColors, this.listIndexedColors);
HasRightBorder = false;
}
/// <summary>
/// Form SLBorder from DocumentFormat.OpenXml.Spreadsheet.Border class.
/// </summary>
/// <param name="border">The source DocumentFormat.OpenXml.Spreadsheet.Border class.</param>
public void FromBorder(Border border)
{
this.SetAllNull();
if (border.LeftBorder != null)
{
HasLeftBorder = true;
this.bpLeftBorder = new SLBorderProperties(this.listThemeColors, this.listIndexedColors);
this.bpLeftBorder.FromBorderPropertiesType(border.LeftBorder);
}
if (border.RightBorder != null)
{
HasRightBorder = true;
this.bpRightBorder = new SLBorderProperties(this.listThemeColors, this.listIndexedColors);
this.bpRightBorder.FromBorderPropertiesType(border.RightBorder);
}
if (border.TopBorder != null)
{
HasTopBorder = true;
this.bpTopBorder = new SLBorderProperties(this.listThemeColors, this.listIndexedColors);
this.bpTopBorder.FromBorderPropertiesType(border.TopBorder);
}
if (border.BottomBorder != null)
{
HasBottomBorder = true;
this.bpBottomBorder = new SLBorderProperties(this.listThemeColors, this.listIndexedColors);
this.bpBottomBorder.FromBorderPropertiesType(border.BottomBorder);
}
if (border.DiagonalBorder != null)
{
HasDiagonalBorder = true;
this.bpDiagonalBorder = new SLBorderProperties(this.listThemeColors, this.listIndexedColors);
this.bpDiagonalBorder.FromBorderPropertiesType(border.DiagonalBorder);
}
if (border.VerticalBorder != null)
{
HasVerticalBorder = true;
this.bpVerticalBorder = new SLBorderProperties(this.listThemeColors, this.listIndexedColors);
this.bpVerticalBorder.FromBorderPropertiesType(border.VerticalBorder);
}
if (border.HorizontalBorder != null)
{
HasHorizontalBorder = true;
this.bpHorizontalBorder = new SLBorderProperties(this.listThemeColors, this.listIndexedColors);
this.bpHorizontalBorder.FromBorderPropertiesType(border.HorizontalBorder);
}
if (border.DiagonalUp != null) this.DiagonalUp = border.DiagonalUp.Value;
else this.DiagonalUp = null;
if (border.DiagonalDown != null) this.DiagonalDown = border.DiagonalDown.Value;
else this.DiagonalDown = null;
if (border.Outline != null) this.Outline = border.Outline.Value;
else this.Outline = null;
Sync();
}
internal static string WriteToXmlTag(string BorderTag, SLBorderProperties bp)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("<x:{0}", BorderTag);
if (bp.HasBorderStyle)
{
sb.AppendFormat(" style=\"{0}\"", bp.GetBorderStyleAttribute(bp.BorderStyle));
}
if (bp.HasColor)
{
sb.Append("><x:color");
if (bp.clrReal.Auto != null) sb.AppendFormat(" auto=\"{0}\"", bp.clrReal.Auto.Value ? "1" : "0");
if (bp.clrReal.Indexed != null) sb.AppendFormat(" indexed=\"{0}\"", bp.clrReal.Indexed.Value);
if (bp.clrReal.Rgb != null) sb.AppendFormat(" rgb=\"{0}\"", bp.clrReal.Rgb);
if (bp.clrReal.Theme != null) sb.AppendFormat(" theme=\"{0}\"", bp.clrReal.Theme.Value);
if (bp.clrReal.Tint != null) sb.AppendFormat(" tint=\"{0}\"", bp.clrReal.Tint.Value);
sb.AppendFormat(" /></x:{0}>", BorderTag);
}
else
{
sb.Append(" />");
}
return sb.ToString();
}
/// <summary>
/// Remove any existing horizontal border.
/// </summary>
public void RemoveHorizontalBorder()
{
this.bpHorizontalBorder = new SLBorderProperties(this.listThemeColors, this.listIndexedColors);
HasHorizontalBorder = false;
}
/// <summary>
/// Remove any existing vertical border.
/// </summary>
public void RemoveVerticalBorder()
{
this.bpVerticalBorder = new SLBorderProperties(this.listThemeColors, this.listIndexedColors);
HasVerticalBorder = false;
}
/// <summary>
/// Remove any existing bottom border.
/// </summary>
public void RemoveBottomBorder()
{
this.bpBottomBorder = new SLBorderProperties(this.listThemeColors, this.listIndexedColors);
HasBottomBorder = false;
}
/// <summary>
/// Remove any existing right border.
/// </summary>
public void RemoveRightBorder()
{
this.bpRightBorder = new SLBorderProperties(this.listThemeColors, this.listIndexedColors);
HasRightBorder = false;
}
internal SLBorderProperties Clone()
{
SLBorderProperties bp = new SLBorderProperties(this.listThemeColors, this.listIndexedColors);
bp.HasColor = this.HasColor;
bp.clrReal = this.clrReal.Clone();
bp.HasBorderStyle = this.HasBorderStyle;
bp.vBorderStyle = this.vBorderStyle;
return bp;
}