/** * 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); }
public void TestGetSetBorderTop() { //default values Assert.AreEqual(BorderStyle.None, cellStyle.BorderTop); int num = stylesTable.GetBorders().Count; cellStyle.BorderTop = BorderStyle.Medium; Assert.AreEqual(BorderStyle.Medium, cellStyle.BorderTop); //a new border has been Added Assert.AreEqual(num + 1, stylesTable.GetBorders().Count); //id of the Created border uint borderId = cellStyle.GetCoreXf().borderId; Assert.IsTrue(borderId > 0); //check Changes in the underlying xml bean CT_Border ctBorder = stylesTable.GetBorderAt((int)borderId).GetCTBorder(); Assert.AreEqual(ST_BorderStyle.medium, ctBorder.top.style); num = stylesTable.GetBorders().Count; //setting the same border multiple times should not change borderId for (int i = 0; i < 3; i++) { cellStyle.BorderTop = BorderStyle.Medium; Assert.AreEqual(BorderStyle.Medium, cellStyle.BorderTop); } Assert.AreEqual((uint)borderId, cellStyle.GetCoreXf().borderId); Assert.AreEqual(num, stylesTable.GetBorders().Count); Assert.AreSame(ctBorder, stylesTable.GetBorderAt((int)borderId).GetCTBorder()); //setting border to none Removes the <top> element cellStyle.BorderTop = BorderStyle.None; Assert.AreEqual(num, stylesTable.GetBorders().Count); borderId = cellStyle.GetCoreXf().borderId; ctBorder = stylesTable.GetBorderAt((int)borderId).GetCTBorder(); Assert.IsFalse(ctBorder.IsSetTop()); }
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 setTopBorderColor(CT_Color color) { CT_BorderPr pr = _border.IsSetTop() ? _border.top : _border.AddNewTop(); if (color == null) { pr.UnsetColor(); } else { pr.color = (color); } }