/**
* Set the color to use for the top border as a {@link XSSFColor} value
*
* @param color the color to use
*/
public void SetTopBorderColor(XSSFColor color)
{
CT_Border ct = GetCTBorder();
if (color == null && !ct.IsSetTop())
{
return;
}
CT_BorderPr pr = ct.IsSetTop() ? ct.top : ct.AddNewTop();
if (color != null)
{
pr.color = color.GetCTColor();
}
else
{
pr.UnsetColor();
}
int idx = _stylesSource.PutBorder(new XSSFCellBorder(ct, _theme));
_cellXf.borderId = (uint)idx;
_cellXf.applyBorder = (true);
}
/**
* Get the type of border to use for the selected border
*
* @param side - - where to apply the color defInition
* @return borderstyle - the type of border to use. default value is NONE if border style is not Set.
* @see BorderStyle
*/
public BorderStyle GetBorderStyle(BorderSide side)
{
CT_BorderPr ctborder = GetBorder(side);
ST_BorderStyle?border = ctborder == null ? ST_BorderStyle.none : ctborder.style;
return((BorderStyle)border);
}
public void setTopBorderColor(CT_Color color)
{
CT_BorderPr pr = _border.IsSetTop() ? _border.top : _border.AddNewTop();
if (color == null)
{
pr.UnsetColor();
}
else
{
pr.color = (color);
}
}
public void setRightBorderColor(CT_Color color)
{
CT_BorderPr pr = _border.IsSetRight() ? _border.right : _border.AddNewRight();
if (color == null)
{
pr.UnsetColor();
}
else
{
pr.color = (color);
}
}
public void setDiagonalBorderColor(CT_Color color)
{
CT_BorderPr pr = _border.IsSetDiagonal() ? _border.diagonal : _border.AddNewDiagonal();
if (color == null)
{
pr.UnsetColor();
}
else
{
pr.color = (color);
}
}
public void setBottomBorderColor(CT_Color color)
{
CT_BorderPr pr = _border.IsSetBottom() ? _border.bottom : _border.AddNewBottom();
if (color == null)
{
pr.UnsetColor();
}
else
{
pr.color = (color);
}
}
/**
* Set the color to use for the selected border
*
* @param side - where to apply the color defInition
* @param color - the color to use
*/
public void SetBorderColor(BorderSide side, XSSFColor color)
{
CT_BorderPr borderPr = GetBorder(side, true);
if (color == null)
{
borderPr.UnsetColor();
}
else
{
borderPr.color = color.GetCTColor();
}
}
private BorderEdge ConvertBorderEdge(CT_BorderPr e)
{
if (e == null)
{
return(null);
}
BorderEdge edge = new BorderEdge
{
Style = (BorderStyle)e.style,
Color = ConvertColor(e.color)
};
return(edge);
}
public XSSFColor GetBorderColor(BorderSide side)
{
CT_BorderPr border = this.GetBorder(side);
if (border == null || !border.IsSetColor())
{
return((XSSFColor)null);
}
XSSFColor color = new XSSFColor(border.color);
if (this._theme != null)
{
this._theme.InheritFromThemeAsRequired(color);
}
return(color);
}
/**
* Get the color to use for the selected border
*
* @param side - where to apply the color defInition
* @return color - color to use as XSSFColor. null if color is not set
*/
public XSSFColor GetBorderColor(BorderSide side)
{
CT_BorderPr borderPr = GetBorder(side);
if (borderPr != null && borderPr.IsSetColor())
{
XSSFColor clr = new XSSFColor(borderPr.color);
if (_theme != null)
{
_theme.InheritFromThemeAsRequired(clr);
}
return(clr);
}
else
{
// No border set
return(null);
}
}
public void SetTopBorderColor(XSSFColor color)
{
CT_Border ctBorder = this.GetCTBorder();
if (color == null && !ctBorder.IsSetTop())
{
return;
}
CT_BorderPr ctBorderPr = ctBorder.IsSetTop() ? ctBorder.top : ctBorder.AddNewTop();
if (color != null)
{
ctBorderPr.color = color.GetCTColor();
}
else
{
ctBorderPr.UnsetColor();
}
this._cellXf.borderId = (uint)this._stylesSource.PutBorder(new XSSFCellBorder(ctBorder, this._theme));
this._cellXf.applyBorder = true;
}
public void TestGetBorderStyle()
{
CT_Stylesheet stylesheet = new CT_Stylesheet();
CT_Border border = stylesheet.AddNewBorders().AddNewBorder();
CT_BorderPr top = border.AddNewTop();
CT_BorderPr right = border.AddNewRight();
CT_BorderPr bottom = border.AddNewBottom();
top.style = (ST_BorderStyle.dashDot);
right.style = (ST_BorderStyle.none);
bottom.style = (ST_BorderStyle.thin);
XSSFCellBorder cellBorderStyle = new XSSFCellBorder(border);
Assert.AreEqual("DashDot", cellBorderStyle.GetBorderStyle(BorderSide.TOP).ToString());
Assert.AreEqual("None", cellBorderStyle.GetBorderStyle(BorderSide.RIGHT).ToString());
Assert.AreEqual(BorderStyle.None, cellBorderStyle.GetBorderStyle(BorderSide.RIGHT));
Assert.AreEqual("Thin", cellBorderStyle.GetBorderStyle(BorderSide.BOTTOM).ToString());
Assert.AreEqual(BorderStyle.Thin, cellBorderStyle.GetBorderStyle(BorderSide.BOTTOM));
}
public XMLBorderPartModel(CT_BorderPr part, XMLPaletteModel palette)
{
this._part = part;
this._palette = palette;
}
public BorderStyle GetBorderStyle(BorderSide side)
{
CT_BorderPr border = this.GetBorder(side);
return((BorderStyle) new ST_BorderStyle?(border == null ? ST_BorderStyle.none : border.style).Value);
}
