public void TestGetSetBottomBorderColor() { //defaults Assert.AreEqual(IndexedColors.Black.Index, cellStyle.BottomBorderColor); Assert.IsNull(cellStyle.GetBottomBorderXSSFColor()); int num = stylesTable.GetBorders().Count; XSSFColor clr; //setting indexed color cellStyle.BottomBorderColor = (IndexedColors.BlueGrey.Index); Assert.AreEqual(IndexedColors.BlueGrey.Index, cellStyle.BottomBorderColor); clr = cellStyle.GetBottomBorderXSSFColor(); Assert.IsTrue(clr.GetCTColor().IsSetIndexed()); Assert.AreEqual(IndexedColors.BlueGrey.Index, clr.Indexed); //a new border was Added to the styles table 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((uint)IndexedColors.BlueGrey.Index, ctBorder.bottom.color.indexed); //setting XSSFColor num = stylesTable.GetBorders().Count; clr = new XSSFColor(Color.Cyan); cellStyle.SetBottomBorderColor(clr); Assert.AreEqual(clr.GetCTColor().ToString(), cellStyle.GetBottomBorderXSSFColor().GetCTColor().ToString()); byte[] rgb = cellStyle.GetBottomBorderXSSFColor().GetRgb(); Assert.AreEqual(Color.Cyan.ToArgb(), Color.FromArgb(rgb[0] & 0xFF, rgb[1] & 0xFF, rgb[2] & 0xFF).ToArgb()); //another border was Added to the styles table Assert.AreEqual(num, stylesTable.GetBorders().Count); //passing null unsets the color cellStyle.SetBottomBorderColor(null); Assert.IsNull(cellStyle.GetBottomBorderXSSFColor()); }