New to Telerik UI for ASP.NET AJAXStart a free 30-day trial

Setting a Bottom Border on a Cell in RadSpreadsheet for ASP.NET AJAX

Environment

ProductRadSpreadsheet for ASP.NET AJAX
Versionall

Description

When working with RadSpreadsheet for ASP.NET AJAX, it might be necessary to visually distinguish certain cells by applying a border. Specifically, using a bottom border for a cell can help emphasize or separate content. This knowledge base article demonstrates how to set a bottom border on a cell within the RadSpreadsheet component.

This knowledge-base article also answers the following questions:

  • How do I style a cell in RadSpreadsheet with a border?
  • Can I apply a custom border color and size to a cell in RadSpreadsheet?
  • What is the recommended way to add a bottom border to a cell in ASP.NET AJAX RadSpreadsheet?

Solution

To set the bottom border of a cell in the RadSpreadsheet, utilize the BorderBottom property. This property accepts an instance of Telerik.Web.Spreadsheet.BorderStyle, which allows specifying the border's color and size.

Here is a step-by-step guide on how to implement this:

  1. Define a new instance of Telerik.Web.Spreadsheet.BorderStyle.
  2. Set the desired Color and Size for the border.
  3. Assign this border style to the BorderBottom property of the target cell.

Below is an illustrative example:

csharp
Cell firstCell = new Cell() { Index = 0, Value = "Select Date:", Bold = true };
row.AddCell(firstCell);
var borderStyle = new Telerik.Web.Spreadsheet.BorderStyle()
{
    Color = "black",
    Size = 2
};
// if the BorderTop is null, which is the default value
firstCell.BorderTop = borderStyle;
firstCell.BorderRight = borderStyle;
firstCell.BorderBottom = borderStyle;
firstCell.BorderLeft = borderStyle;

Key Points:

  • BorderBottom: Specifies the style for the bottom border of the cell.
  • Telerik.Web.Spreadsheet.BorderStyle: Enables customization of the border by setting its Color and Size.

By following these steps, you can easily add a bottom border to any cell in your RadSpreadsheet, enhancing the visual appeal and clarity of your spreadsheet data.

See Also